Home » Database Modeling Step by Step
Product Image

Database Modeling Step by Step

Gavin Powell
€72.99
Quantity:
In stock with our UK publisher. 14-28 days
Delivery/Collection within 10-20 working days
14 days return policy Shipping & Delivery
A01=Gavin Powell
academic database systems
AUTHOR Table
Author_Gavin Powell
BigData database modelling
BigData Databases
Bitmap Index
Boyce Codd Normal Form
Category=UNAR
Category=UND
Category=UYZM
Child Table
data modeling for research
Data Warehouse
Data Warehouse Database
Data Warehouse Model
Database Model
database normalization
database programming language
entity relationship modeling
eq_bestseller
eq_computing
eq_isMigrated=1
eq_isMigrated=2
eq_nobargain
eq_non-fiction
Fact Tables
Foreign Key
Foreign Key Column
intuitive relational modeling approach
JSON Document
JSON Object
Multivalued Dependency
Network Database Model
normalization theory
Object Databases
OLTP Database
Outer Join
Primary Key
Relational Database
Relational Database Model
schema design techniques
Snowflake Schema
SQL query optimization
Star Schema
structured query language
Transitive Dependency

Product details

  • ISBN 9780367422172
  • Weight: 453g
  • Dimensions: 156 x 234mm
  • Publication Date: 18 Dec 2019
  • Publisher: Taylor & Francis Ltd
  • Publication City/Country: GB
  • Product Form: Paperback
Secure checkout Fast Shipping Easy returns
Description

With the aim of simplifying relational database modeling, Database Modeling Step-by-Step presents the standard approach to database normalization and then adds its own approach, which is a more simplistic, intuitive way to building relational database models. Going from basics to contemporary topics, the book opens with relational data modeling and ends with BigData database modeling following a road map of the evolution in relational modeling and including brief introductions to data warehousing and BigData modeling. A break-down of the elements of a model explains what makes up a relational data model. This is followed by a comparison between standard normalization and a more simplistic intuitive approach to data modeling that a beginner can follow and understand.

A brief chapter explains how to use the database programming language SQL (Structured Query Language), which reads from and writes to a relational database. SQL is fundamental to data modeling because it helps in understanding how the model is used. In addition to the relational model, the last three chapters cover important modern world topics including denormalization that leads into data warehouses and BigData database modeling. The book explains how there is not much to logical data modeling in BigData databases because as they are often schema-less, which means that BigData databases do not have schemas embedded into the database itself, they have no metadata and thus not much of a logical data model.

Online bonus chapters include a case study that covers relational data modeling and are available at the author’s web site: www.oracletroubleshooter.com/datamodeling.html

About Gavin Powell

Gavin Powell is a veteran IT practitioner and author of a number of publications on Oracle technologies. He has extensive experience in many databases, including more than a decade working with Oracle databases.

Powell has authored the following books:



  • Oracle Performance Tuning for 10
gR2
  • Oracle SQL Jumpstart with Examples
    • (with Carol McCullough-Dieter)
  • Oracle Data Warehouse Tuning for 10
    • gR2
  • Oracle High-Performance Tuning for 9i and 10g

  • Working with GoldenGate 12c
    •

    More from this author