How the IBM Common SQL Engine (CSE) Improves DB2

Today, newfound efficiencies and innovation are key to any business success – small, medium or large. In the rapidly evolving field of data analytics, innovative approaches to handling data are particularly important since data is the most valuable resource any business can have. IBM common SQL Engine is delivering application and query compatibility that is … Continue reading How the IBM Common SQL Engine (CSE) Improves DB2

An Overview of DB2 Federation

Data analytics has changed where data is no longer manageable in relational databases only. Data is flowing from various sources which are not of the same format. This means it is not possible to store all data in the same repository. Some are best suited for storing in relational databases, others for Apache Hadoop while … Continue reading An Overview of DB2 Federation

OLTP vs Data Warehousing

OLTP Versus Data Warehousing I’ve tried to explain the difference between OLTP systems and a Data Warehouse to my managers many times, as I’ve worked at a hospital as a Data Warehouse Manager/data analyst for many years. Why was the list that came from the operational applications different than the one that came from the … Continue reading OLTP vs Data Warehousing

Databases – What is ACID?

What does ACID mean in database technologies? Concerning databases, the acronym ACID means: Atomicity, Consistency, Isolation, and Durability. Why is ACID important? Atomicity, Consistency, Isolation, and Durability (ACID) are import to database, because ACID is a set of properties that guarantee that database transactions are processed reliably. Where is the ACID Concept described? Originally described … Continue reading Databases – What is ACID?

Databases – Database Isolation Level Cross Reference

  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 … Continue reading Databases – Database Isolation Level Cross Reference

Database – What is a foreign key?

Acronyms, Abbreviations, Terms, And Definitions Definition of a Foreign Key A foreign Key (FK) is a constraint that references the unique primary key (PK) of another table. Facts About Foreign Keys Foreign Keys act as a cross-reference between tables linking the foreign key (Child record) to the Primary key (parent record) of another table, which … Continue reading Database – What is a foreign key?

InfoSphere / Datastage – What are The support Connectors stages for dashDB?

In a recent discussion, the question came up concern which Infosphere Datastage connectors and/or stages are supported by IBM for dashDB.  So, it seems appropriate to share the insight gained from the question being answered. What Datastage Connectors and/or stages are Supported for dashDB You have three choices as to connectors, which may best meet … Continue reading InfoSphere / Datastage – What are The support Connectors stages for dashDB?