By Ramez Elmasri, Shamkant Navathe
Responding to the requests of database professors nationwide,the top textbook for the introductory database administration direction is being absolutely revised in time for the startof Fall 1999 periods. basics of Database platforms, 3rd version is up-to-date to mirror the newest advancements indatabase learn and perform. It combines transparent motives of conception and genuine platforms, large insurance of modeling and layout of databases, and perfect examples with up to date introductions to fashionable database expertise.
Features of the 3rd variation
Presents transparent and entire dialogue of the relational strategy together with modeling, layout, and question languages
Reorganized fabric on information modeling to obviously separate entity courting modeling, prolonged entity courting modeling, and object-oriented modeling
NEW! supplies examples of actual database structures - Oracle and Microsoft entry - in Ch. 10
NEW and increased! presents assurance of the object-oriented and item relational method of info administration together with ODMG and SQL3
NEW! contains dialogue of determination help purposes of knowledge warehousing and knowledge mining, in addition to rising applied sciences of net databases, multimedia, and cellular databases
NEW! Covers complex modeling within the parts of energetic, temporal, and spatial databases
NEW! Discusses present database software components of GIS, genome, and electronic libraries
Read or Download Fundamentals of Database Systems (3rd Edition) PDF
Similar databases books
It doesn't matter what DBMS you're using—Oracle, DB2, SQL Server, MySQL, PostgreSQL—misunderstandings can continually come up over the right meanings of phrases, misunderstandings that may have a major influence at the good fortune of your database initiatives. for instance, listed here are a few universal database phrases: characteristic, BCNF, consistency, denormalization, predicate, repeating workforce, sign up for dependency.
Additional resources for Fundamentals of Database Systems (3rd Edition)
Let us briefly elaborate on the main criterion for classifying DBMSs: the data model. The basic relational data model represents a database as a collection of tables, where each table can be stored as a separate file. 02 is shown in a manner very similar to a relational representation. Most relational databases use the high-level query language called SQL and support a limited form of user views. We discuss the relational model, its languages and operations, and two sample commercial systems in Chapter 7 through Chapter 10.
The network model, also known as the CODASYL DBTG model (Note 11), has an associated record-at-a-time language that must be embedded in a host programming language. The hierarchical model represents data as hierarchical tree structures. Each hierarchy represents a number of related records. There is no standard language for the hierarchical model, although most hierarchical DBMSs have record-at-a-time languages. We give a brief overview of the network and hierarchical models in Appendix C and Appendix D (Note 12).
Once the data is in main memory buffers, it can be processed by other DBMS modules, as well as by application programs. The DDL compiler processes schema definitions, specified in the DDL, and stores descriptions of the schemas (meta-data) in the DBMS catalog. The catalog includes information such as the names of files, data items, storage details of each file, mapping information among schemas, and constraints, in addition to many other types of information that are needed by the DBMS modules.