Book Image

Hands-On Big Data Modeling

By : James Lee, Tao Wei, Suresh Kumar Mukhiya
Book Image

Hands-On Big Data Modeling

By: James Lee, Tao Wei, Suresh Kumar Mukhiya

Overview of this book

Modeling and managing data is a central focus of all big data projects. In fact, a database is considered to be effective only if you have a logical and sophisticated data model. This book will help you develop practical skills in modeling your own big data projects and improve the performance of analytical queries for your specific business requirements. To start with, you’ll get a quick introduction to big data and understand the different data modeling and data management platforms for big data. Then you’ll work with structured and semi-structured data with the help of real-life examples. Once you’ve got to grips with the basics, you’ll use the SQL Developer Data Modeler to create your own data models containing different file types such as CSV, XML, and JSON. You’ll also learn to create graph data models and explore data modeling with streaming data using real-world datasets. By the end of this book, you’ll be able to design and develop efficient data models for varying data sizes easily and efficiently.
Table of Contents (17 chapters)

DBMS-based approach to big data

In the database approach, a single repository of data is maintained which is defined once and then accessed by various users. A database is a self-describing collection of integrated records. It is self-describing because the database system contains not only the database itself, but also a complete definition of the database structure and constraints. This definition is stored in the DBMS catalog. The records are integrated because a database contains multiple files (usually called a table in database processing), and records within those tables are processed by their relationship to one another.

In database processing, the DBMS acts as an intermediary between the user, or application program, and database. A DBMS is a general-purpose software system that facilitates the processes of defining, constructing, manipulating, and sharing of the database...