Distinguishing the Three Data Types

When organizations capture and analyze big data to extract knowledge and insight from it, they often must aggregate three diverse data types:

  • Structured
  • Semi-structured
  • Unstructured

In this post, I highlight the differences among these three...

Continue Reading...

The Differences Between OLTP and OLAP

Businesses and other organizations typically have two types of database management systems (DBMSs) — one for online transactional processing (OLTP) and another for online analytical processing (OLAP):

  • Online transactional processing (OLTP):...
Continue Reading...

Grasping Extract, Transform, and Load (ETL) Basics

To analyze a body of data, that data must first be loaded into a data warehouse; that is, it must be copied from one or more systems, converted into a uniform format, and written to the new destination. This process is commonly referred to as ...

Continue Reading...

Understanding Database Schemas

A schema is a formal description and/or illustration of how data is structured and related in a relational database. The description or illustration includes the following:

  • The tables that store the data
  • The fields in each table
  • The...
Continue Reading...

Data Science Tools of the Trade

The key ingredient for a successful data scientist is a curious, skeptical, and innovative mind. However, data scientists also need to be familiar with the tools of the trade, various technologies, which can be broken down into the following...

Continue Reading...

Data Modeling Basics

Data modeling is the process of defining the structure, flow, and relationships of data stored in a database management system (DBMS). A data model provides the framework for all the data an organization generates and stores, and it facilitates...

Continue Reading...
Close

50% Complete

Two Step

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.