by Markus Winand.

Big News In Databases — Fall 2017


Don’t fall behind: Here’s the most important database news from the last six months.

SQL on The Rise

NoSQL pioneer Google writes that their Spanner database is becoming a SQL system (summary). Salesforce uses Artificial Intelligence to translate natural language to SQL. Even some ORM0 vendors say it is better to use SQL. Seems like SQL has a positive vibe.

The highly popular article “Why SQL is beating NoSQL, and what this means for the future of data” is a very nice write-up of why SQL had become frowned upon, and how it is now gaining new popularity right.

The Cloud War Continues

In the previous edition, I reported about the sudden spike in license costs for the Oracle database in Amazon’s AWS and Microsoft’s Azure cloud environments.

In July the opposite happened for users of Microsoft SQL Server: the cost of running the Standard Edition in Amazon’s AWS cloud was reduced by between 29 and 52 percent.

IBM’s Renaming Insanity

There is a saying that there are only two hard things in computer science: (0) cache invalidation, (1) naming things, (2) and off-by-one errors. In June, IBM renamed the products in the Db2 family and thereby demonstrated how to cause great harm by choosing poor names.

Old NameNew Name
DB2 for LUWDb2
DB2 for z/OSDb2 for z/OS
DB2 for iSeriesDb2 for i

Note the subtle but groundbreaking innovation to write the “b” in Db2 as a lower case letter.

All sarcasm aside: Previously, DB2 was a common element in the names of different products of the same family. The “for” addendum made a distinction between each product. As these products offer different features1, the distinction is quite important.

The new name Db2 doesn’t allow this distinction anymore because it represents the whole family as well as one specific product. This lack of differentiation becomes a real problem when searching the internet: webpages about the former product DB2 for LUW might not contain “LUW” anymore. Reducing the iSeries addendum to i doesn’t improve searching either.

Wikipedia says “A name is a term used for identification.” I doubt the new names fulfill this purpose sufficiently.

One thing is for sure: the new naming is an upgrade for the LUW version. The reverse of this conclusion shines an interesting light on the other variants. IBM also looses grounds in the just published Gartner Magic Quadrant for Operational Databases 2017—it’s now far behind SAP and Amazon Web Services (AWS).

Other Vendors Rethink Release Numbering

I have already mentioned that the next MySQL major release after 5.7 will be MySQL 8.0. In the meantime, a release candidate is available.

The next major release of the Oracle Database will be 18c (instead of 12.2.0.2). New releases will be annual and the version will be the last two digits of the release year (see also: release roadmap).

Starting with the just released PostgreSQL 10, there is no dot in the major versions of PostgreSQL anymore.

New Database Releases

In the past six month there were three major releases among the most popular SQL databases.

SQL Server 2017 (October 2017)

My personal picks from the “new features” list:

PostgreSQL 10 (October 2017)

My favorite new features:

MariaDB 10.2 (May 2017)

MariaDB3 10.2 introduces two very important features that will also appear in MySQL 8.0:

News on my Sites

Articles I published or updated:

From Twitter, in Great Brevity (follow me on Twitter)

About the Author

Photo of Markus Winand

Markus Winand teaches efficient SQL—inhouse and online. He minimizes the development time using modern SQL and optimizes the runtime with smart indexing. His book entitled SQL Performance Explained has become standard reading.

Buy his Book on Amazon

Cover of “SQL Performance Explained”: Squirrel running on grass

The essence of SQL tuning in 200 pages

Buy on Amazon
(paperback only)

Paperback and PDF also available at Markus’ store.

Hire Markus

The quick and easy way to benefit from his extensive knowledge and experience.
Learn more »

Footnotes

0

Object-relational mapping tools such as Sequel (mentioned in the article), Hibernate, Doctrine, …

1

IBM itself publishes “The SQL reference for cross-platform development” to document the common SQL functionality for developers.

2

The main limitation is the “batch mode” which is mostly used for queries accessing column store indexes. See “What You Need to Know about the Batch Mode Window Aggregate Operator in SQL Server 2016: Part 1” for a good intro.

3

MariaDB is the MySQL clone continued by the original creator of MySQL after Oracle indirectly acquired MySQL through Sun in 2009.

“Use The Index, Luke!” by Markus Winand is licensed under a Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 Unported License.
Legal | Contact | NO WARRANTY | Trademarks | Privacy | CC-BY-NC-ND 3.0 license