Inmon’s evolutionary approach to data warehouse design develops from operational relational database technology and development methods, while Kimball’s definition of business processes is more general. Both approaches describe techniques for maximizing data warehouse performance. Inmon also offers an explanation of how to declare grain, or the level of detail each data warehouse will contain. Kimball’s … More Technology – Inmon Vs Kimball Approach to Data Warehouse Design
A surrogate key is an artificial key, which functions as a proxy for a natural one. Similarly, a surrogate key in data- warehouses is used to maintain a link between the production and test systems. A surrogate can be an internal or external key. It is often the default key in data warehouses. A surrogate … More Technology – What is a Surrogate Key in Data Warehousing?
Denodo does not publish a concise list of what permissions denodo needs in a source database. So, I thought I would document what is required for a SQL Server data source for denodo. Source database Dendo Access Permissions Assuming there is no need to write back to the source DB, the data source connection permissions … More Denodo Source Database Permissions For SQL Server
Well, the question was asked today by a customer, what happened to the “Read” denodo user privilege between version 6 and version 7. So, I had to a little research and thought to write it down here, in case anyone else happens to ask or wants to know. The Denodo 6.0 “Read” privilege is now … More What Did The Denodo Read Privilege Change To In Denodo 7.0?
As the Virtual DataPort Administration Guide, explains in the section “Types of Access Rights” section, on VDP databases, views, rows, and columns. The denodo role-based access mechanism controls how and what a user or user role can use in the virtual layer, including the data catalog. Important Denodo Security Notes Consumer security authorization is imposed … More Technology – Denodo Security Enforcement
Here is a table quick reference of some common database and/or connection types, which use connection level isolation and the equivalent isolation levels. This quick reference may prove useful as a job aid reference, when working with and making decisions about isolation level usage. Database isolation levels Data sources Most restrictive isolation level More … More Databases – Database Isolation Level Cross Reference
Isolation levels are part of the ACID (Atomicity, Consistency, Isolation, Durability) paradigms in database control. Isolation levels allow developers and user to trade-off consistency for a potential gain in performance. Therefore, it is essential to understand them and how the apply in structured Query Language(SQL). The dashDB RDBMS has four isolations levels: Repeatable Read … More What are the dashDB isolation levels?
Aginity for Netezza an out complete feature, which auto completes brackets, quotes, and comment character, which some folks find useful and helpful. However, if you are an old-school style coder like me, you may find these annoying, to say the least. Usually, when I’m coding I want to write straight through without the need to … More Aginity for Netezza – How to disable and/or Enable the Autocomplete Function
Every once and a while, it happens that a SQL needs to be reused, but for whatever reason it was not saved. If it wasn’t too far back in time, you can recover the SQL from the User Query History. This is a fairly straight forward process, if not exactly obvious. The basic process is: … More How to get a previously run SQL in Aginity