SQL’s unstoppable evolution: DBMS Innovations and how relational DBs outlasted every trend
Michael Stonebraker and Andrew Pavlo wrote about DBMS innovations in their paper “What Goes...
Read More
Category: RDBMS
Log-based Change Data Capture - lessons learnt
My article on medium summarizes experiences from various projects with log-based change data...
Read More
Columnar analytical databases for DWH and Data Analytics
The German magazine BI Spektrum published my article on analytical databases for DWH and Data...
Read MoreJSON and ISO SQL Standard
JSON was initially developed to exchange data via RESTful APIs (Representative State Transfer Application Programming Interface). The encoding is always Unicode, mostly UTF8. Programmable Web contains a variety of links to APIs...
Read MoreMetadata Management reloaded
Metadata is data about data. It used to be so simple with RDBMS and defined schemas. Variety creates the biggest challenge to derive metadata on-the-fly. What about schema-on-read? Schema-on-read applies the schema when data is retrieved.
Read More
Oracle Release Model, Release Updates (RU), Monthly Recommended Patches (MRPs) and discontinued Release Update Revisions (RUR)
Update Oct/2022 Monthly recommended patches will replace Release Update Revisions (RURs) from...
Read More
SQL Tuning – filtered rows percentage method
Kevin Meade is the author and publisher of his own book “Oracle SQL Performance Tuning and...
Read More
Current trends in Data Management by BARC
Dr. Carsten Bange from Business Application Research Center (BARC) presented trends in...
Read MoreSQL – Only the Strong Survive
There are tons of tech predictions at the end of every year. Eric Knorr lists “The incredible SQL comeback” in his 9 enterprise tech trends for 2017 and beyond. An old, mature programming language as the...
Read MoreDataBeat week 01/2015
Reference to blogs, tweets, discussions, etc that caught my attention during the last week.Data ModelingData independence as the key idea of RDBMS is illustrated in “Relational algebra-How it makes Relational Databases go...
Read More