- Shopping Bag ( 0 items )
Thoroughly updated in this edition, this book delivers a comprehensive introduction to database theory and database design, with many examples of implementation. All the important data models are covered, including entity-relationship, relational, object-oriented, hierarchical, and network, although the emphasis on relational clearly reflects its place in industry.
The above interactions are examples of what we may call traditional database applications, where most of the information that is stored and accessed is either textual or numeric. In the past few years, advances in technology have been leading to exciting new applications of database systems. Multimedia databases can now store pictures, video clips, and sound messages. Geographic information systems (GIS) can store and analyze maps, weather data, and satellite images. Data warehouses and on-line analytical processing (OLAP) systems are used in many companies to extract and analyze useful information from very large databases for decision making. Real-time and active database technology is used in controlling industrial and manufacturing processes. And database search techniques are being applied to the World Wide Web to improve the search for information that is needed by users browsing through the Internet.
To understand the fundamentals of databasetechnology, however, we must start from the basics of traditional database applications. So, in Section 1. 1 of this chapter we define what a database is, and then we give definitions of other basic terms. In Section 1.2, we provide a simple UNIVERSITY database example to illustrate our discussion. Section 1.3 describes some of the main characteristics of database systems, and Sections 1.4 and 1.5 categorize the types of personnel whose jobs involve using and interacting with database systems. Sections 1.6, 1.7, and 1.8 offer a more thorough discussion of the various capabilities provided by database systems and of the implications of using the database approach. Section 1.9 summarizes the chapter.
The reader who desires only a quick introduction to database systems can study Sections 1.1 through 1.5, then skip or browse through Sections 1.6 through 1.8 and go on to Chapter 2.
Databases and database technology are having a major impact on the growing use of computers. It is fair to say that databases play a critical role in almost all areas where computers are used, including business, engineering, medicine, law, education, and library science, to name a few. The word database is in such common use that we must begin by defining a database. Our initial definition is quite general.
A database is a collection of related data. I By data, we mean known facts that can be recorded and that have implicit meaning. For example, consider the names, telephone numbers, and addresses of the people you know. You may have recorded this data in an indexed address book, or you may have stored it on a diskette, using a personal computer and software such as DBASE IV or V, Microsoft ACCESS, or EXCEL. This is a collection of related data with an implicit meaning and hence is a database.
The preceding definition of database is quite general; for example, we may consider the collection of words that make up this page of text to be related data and hence to constitute a database. However, the common use of the term database is usually more restricted. A database has the following implicit properties:
In other words, a database has some source from which data are derived, some degree of interaction with events in the real world, and an audience that is actively interested in the contents of the database.
A database can be of any size and of varying complexity. For example, the list of names and addresses referred to earlier may consist of only a few hundred records, each with a simple structure. On the other hand, the card catalog of a large library may contain half a million cards stored under different categories-by primary author's last name, by subject, by book title-with each category organized in alphabetic order. A database of even greater size and complexity is maintained by the Internal Revenue Service to keep track of the tax forms filed by U.S. taxpayers. If we assume that there are 100 million taxpayers and if each taxpayer files an average of five forms with approximately 200 characters of information per form, we would get a database of 100*(106)*200*5 characters (bytes) of information. If the IRS keeps the past three returns for each taxpayer in addition to the current return, we would get a database of 4*(1011) bytes (400 gigabytes). This huge amount of information must be organized and managed so that users can search for, retrieve, and update the data as needed.
A database may be generated and maintained manually or it may be computerized. The library card catalog is an example of a database that may be created and maintained manually. A computerized database may be created and maintained either by a group of application programs written specifically for that task or by a database management system.
A database management system (DBMS) is a collection of programs that enables users to create and maintain a database. The DBMS is hence a general-purpose software system that facilitates the processes of defining, constructing, and manipulating databases for various applications. Defining a database involves specifying the data types, structures, and constraints for the data to be stored in the database. Constructing the database is the process of storing the data itself on some storage medium that is controlled by the DBMS. Manipulating a database includes such functions as querying the database to retrieve specific data, updating the database to reflect changes in the miniworld, and generating reports from the data.
It is not necessary to use general-purpose DBMS software to implement a computerized database. We could write our own set of programs to create and maintain the database, in effect creating our own special-purpose DBMS software. In either case—whether we use a general-purpose DBMS or not—we usually have to employ a considerable amount of software to manipulate the database. We will call the database and DBMS software together a database system. Figure 1.1 illustrates these ideas...
|Pt. 1||Basic Concepts|
|Ch. 1||Databases and Database Users||2|
|Ch. 2||Database System Concepts and Architecture||23|
|Ch. 3||Data Modeling Using the Entity-Relationship Model||41|
|Ch. 4||Enhanced Entity-Relationship and Object Modeling||73|
|Ch. 5||Record Storage and Primary File Organizations||113|
|Ch. 6||Index Structures for Files||155|
|Pt. 2||Relational Model, Languages, and Systems||193|
|Ch. 7||The Relational Data Model, Relational Constraints, and the Relational Algebra||195|
|Ch. 8||SQL - The Relational Database Standard||243|
|Ch. 9||ER- and EER-to-Relational Mapping, and Other Relational Languages||289|
|Ch. 10||Examples of Relational Database Management Systems: Oracle and Microsoft Access||323|
|Pt. 3||Object-Oriented and Extended Relational Database Technology||357|
|Ch. 11||Concepts for Object-Oriented Databases||359|
|Ch. 12||Object Database Standards, Languages, and Design||385|
|Ch. 13||Object Relational and Extended Relational Database Systems||435|
|Pt. 4||Database Design Theory and Methodology||463|
|Ch. 14||Functional Dependencies and Normalization for Relational Databases||465|
|Ch. 15||Relational Database Design Algorithms and Further Dependencies||501|
|Ch. 16||Practical Database Design and Tuning||527|
|Pt. 5||System Implementation Techniques||568|
|Ch. 17||Database System Architectures and the System Catalog||569|
|Ch. 18||Query Processing and Optimization||585|
|Ch. 19||Transaction Processing Concepts||629|
|Ch. 20||Concurrency Control Techniques||661|
|Ch. 21||Database Recovery Techniques||689|
|Ch. 22||Database Security and Authorization||715|
|Pt. 6||Advanced Database Concepts & Emerging Application||731|
|Ch. 23||Enhanced Data Models for Advanced Applications||733|
|Ch. 24||Distributed Databases and Client-Server Architecture||765|
|Ch. 25||Deductive Databases||801|
|Ch. 26||Data Warehousing and Data Mining||841|
|Ch. 27||Emerging Database Technologies and Applications||873|
|App. A||Alternative Diagrammatic Notations||909|
|App. B||Parameters of Disks||913|
|App. C||An Overview of the Network Data Model||917|
|App. D||An Overview of the Hierarchical Data Model||941|