January 2016
Intermediate to advanced
25 pages
28m
English
Content preview from What Is Database Design, Anyway?
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 1. What Is Database Design, Anyway?
An earlier version of this essay appeared as a foreword to the book Oracle SQL Developer Data Modeler for Database Design Mastery, by Heli Helskyaho (Oracle Press, 2015). What follows is a revised and considerably expanded version of that foreword. My thanks to Heli and Oracle Press for allowing me to republish the essay here in its present form.
Databases lie at the heart of so much we do in the IT world that it’s surely obvious that they need to be properly designed. Yet design theory—meaning database design theory specifically, of course—doesn’t seem to be very well understood in the industry at large, and the same goes for design best practice also. You only have to look at the Wikipedia entry on database design to see the truth of these claims! In fact, before going any further, I’d like to quote a few sentences from that Wikipedia piece (with commentary by myself) as evidence in support of these claims:1
-
Database design is the process of producing a detailed data model of a database. This logical data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design....
Comment: So the “logical data model” contains “physical storage parameters”? Clearly, somebody is confused here, and I don’t think it’s me. Note too the circular nature of the foregoing “definition” (doing database design apparently consists of producing the things needed for doing database design). The ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.