Learn free, at your own pace.

141

Data Subsetting

Data Subsetting is as simple as taking a small piece of data, with referential integrity in place, for some activity. For example, there is a requirement to…

142

Data or Web Scraping

This term is normally known by the Security department and is tagged with Hackers. ‘Data Scraping is also known as Web Scraping.’ The minor difference betwee…

143

Database and OLTP

In the current era there are many data stores like Database, Data Warehouse, Data Marts, Big Data, Data Lake, Data Vault, Business Vault, SQL, and NoSQL etc.…

144

Data Warehouse and Data Marts

The idea of a Data Warehouse emerged when organizations realized that transactional systems (OLTP), while excellent for recording day-to-day operations, were…

145

OLTP 3NF vsData Warehouse 3NF

This topic is very close to many experienced data modelers because it is surprisingly misunderstood. The confusion usually begins with one assumption: if bot…

146

Immutable Data Warehouse

Immutable Data Warehouse has come from immutable data. Data folks are aware of it but don’t use it more often. ‘Immutable means not changeable.’ Now, the que…

147

Logical Data Warehouse

A Logical Data Warehouse (LDW) is not a new storage technology but an architectural approach to delivering a unified data warehouse view without physically c…

148

Big Data

The term Big Data emerged in the early 2000s as enterprises began facing unprecedented growth in the amount, speed, and diversity of information being genera…

149

Data Lake

As organizations matured in their use of Data Warehouses, a new challenge began to surface. Warehouses were excellent for structured, relational data such as…

150

Big Data vs Data Lake

Over the past decade, the terms Big Data and Data Lake have often been used interchangeably, leading to significant confusion in both technical and business…