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...

The Scoop on Hadoop

You can’t have a discussion about big data or data science these days without mentioning Hadoop, but when you ask people what Hadoop is, they struggle to define it. I define Hadoop as a software framework for harnessing the power of...

Continue Reading...

Defining “Big Data”

Big data is a term that describes an immense volume of diverse data typically analyzed to identify patterns, trends, and associations. However, the term “big data” didn’t start out that way. In 1997, NASA researchers Michael Cox...

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...

What Do Data Scientists Do?

“Data scientist” is more difficult to define than terms used to describe other scientists, such as chemist, biologist, geneticist, or meteorologist. Part of the problem may be due to the fact that “data science” became a...

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...

What is Data Science?

Data science is a multi-disciplinary approach to extracting insight from data. The disciplines involved include computer science/information technology, math/statistics, and domain knowledge/expertise (for example, knowledge of a specific...

Continue Reading...
1 2 3 4 5
Close

50% Complete

Two Step

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