Database Reference
In-Depth Information
1
Introduction to Oracle SQL
In this chapter:
Examine the history and evolution of data models and relational and
Oracle Databases.
What is relational data modeling?
What is SQL?
What software do you need to have in order to use this topic?
What are the tools for executing SQL?
Sample tables you use in the topic
This chapter will examine data modeling, the origins of SQL, software
requirements, plus SQL tools and how to use them. Finally, we will present
the MUSIC schema, which is used throughout this topic. Let's begin with a
little history.
1.1
A Little History
1.1.1
The Evolution of Database Modeling
The history of databases is essentially the history of different data modeling
techniques. Data modeling techniques have evolved over the last 50 years
from use of simple file systems to relational, object, and object-relational
models. Figure 1.1 shows the evolution of data modeling techniques.
File System
. Operating system files or “flat” text files. There is no
logical overlay structure.
