Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Big News in Databases: Fall 2017

DZone's Guide to

Big News in Databases: Fall 2017

Let's take a look at some of the biggest news in the world of databases from the past six months!

· Database Zone
Free Resource

Find out how Database DevOps helps your team deliver value quicker while keeping your data safe and your organization compliant. Align DevOps for your applications with DevOps for your SQL Server databases to discover the advantages of true Database DevOps, brought to you in partnership with Redgate

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 ORM 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 rights.

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 Name New Name
DB2 for LUW Db2
DB2 for z/OS Db2 for z/OS
DB2 for iSeries Db2 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 features, 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: web pages 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 that a name is a term used for identification. I doubt these 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 loses ground 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 months, there were three major releases among the most popular SQL databases.

1. SQL Server 2017 (October 2017)

My personal picks from the “new features” list:

2. PostgreSQL 10 (October 2017)

My favorite new features:

3. MariaDB 10.2 (May 2017)

MariaDB 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 

Align DevOps for your applications with DevOps for your SQL Server databases to increase speed of delivery and keep data safe. Discover true Database DevOps, brought to you in partnership with Redgate

Topics:
database ,ibm ,mariadb ,postgresql ,sql server ,cloud database

Published at DZone with permission of Markus Winand, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}