Data Blog

SQL – 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 prevailing trend for 2017 and later?After years of NoSQL...

Is my Oracle database healthy?

It's a common question if a database is in a healthy state. DBA_REGISTRY shows the status of components loaded into the database. Mike Dietrich mentions in his blog two additional checks that should be performed regularly during off-peak hours for Oracle...

Data Vault 2.0, Hashing and DB2 LUW

Data Vault 2.0, Hashing and DB2 LUW

Hashing is part of Data Vault 2.0. Hash Keys are used to provide a surrogate for business keys detect changes in fields in Satellite tables. Oracle, SQL Server, Informatica, etc have built-in functions to compute a hash key. Example with Oracle: select...

DataBeat week 06/2015

Reference to blogs, tweets, discussions, etc that caught my attention during the last week.Data Modeling"Data Modeler Of 2020" YouTube video by Steve Hoberman addresses topics like modeling for NoSQL or BigData, Fact Based Modeling, becoming more agile, etc."Basic...