Search code examples
sqldatabaserelational

What relational database innovations have there been in the last 10 years

The SQL implementation of relational databases has been around in their current form for something like 25 years (since System R and Ingres). Even the main (loosely adhered to) standard is ANSI-92 (although there were later updates) is a good 15 years old.

What innovations can you think of with SQL based databases in the last ten years or so. I am specifically excluding OLAP, Columnar and other non-relational (or at least non SQL) innovations. I also want to exclude 'application server' type features and bundling (like reporting tools)

Although the basic approach has remained fairly static, I can think of:

  • Availability
  • Ability to handle larger sets of data
  • Ease of maintenance and configuration
  • Support for more advanced data types (blob, xml, unicode etc)

Any others that you can think of?

Solution
    • Hash joins
    • Cost-based optimizers (pretty much turned query-writing on its head)
    • Partitioning (enables much better VLDB management)
    • Parallel (multi-threaded) query processing
    • Clustering (not just availability but scalability too)
    • More flexibility in SQL as well as easier integration of SQL with 3GL languages
    • Better diagnostics capabilities