Standard Relational and Network Database Languages - Cheng, C. P.

. .

Résumé :
This book is in three parts. The first part describes the database management system as it should be and discusses the various facilities it should offer the database administra- tor, the programmer and the general user. The second part describes SQL, including the schema and sub-schema defini- tion languages, the module language, the module language and themanipulation language while a third part is devoted to NDL including the commands to create the schema and the views, the module and the data manipulation language.

Sommaire:
I: The Database Environment.- 1 Database Management Systems.- 1.1 Introduction.- 1.2 The Three Architectural Levels.- 1.2.1 Logical Schema.- 1.2.2 Logical Subschema.- 1.2.3 Storage Schema.- 1.3 Database Models.- 1.3.1 Hierarchic Model.- 1.3.2 Network Model.- 1.3.3 Relational Model.- 1.4 Database Languages.- 1.4.1 Data Definition Language (DDL).- 1.4.2 Data Manipulation Language (DML).- 1.4.3 Data Storage Definition Language (DSDL).- 1.4.4 Query Language (QL).- 1.4.5 Query By Example (QBE).- 1.4.6 Data Dictionary.- 1.5 Standard Database Languages.- 1.5.1 Notations.- 1.5.2 Elementary Terms.- II: Structured Query Language (SQL).- 2 Relational Database Language (RDL).- 2.1 Introduction.- 2.2 Elementary Terms in SQL.- 3 Schema Definition in SQL.- 3.1 Schema Definition Language.- 3.2 Table Definition.- 3.3 View Definition.- 3.3.1 Query Specification.- 3.3.2 With Check Option.- 3.3.3 Updatability of Viewed Tables.- 3.4 Privilege Definition.- 4 Module Language in SQL.- 4.1 Tasks of the Module Language.- 4.2 Module Definition and Procedure Definition.- 4.3 Using an Embedded SQL Module.- 4.4 Error Handling in Embedded SQL.- 5 Data Manipulation Language in SQL.- 5.1 Tasks of the Data Manipulation Language.- 5.2 DML Statements and their Classification.- 5.2.1 Handling of Transactions.- 5.2.2 Location and Manipulation of Rows.- 5.2.3 Manipulation of Cursors.- III: Network Database Language (NDL).- 6 Network Database Language (NDL).- 6.1 Introduction.- 6.2 General Structure of NDL.- 6.2.1 Schema Definition Language.- 6.2.2 Subschema Definition Language.- 6.2.3 Module Language and Data Manipulation Language.- 6.3 Remarks on NDL Terminology.- 6.4 Elementary Terms in NDL.- 7 Schema Definition in NDL.- 7.1 Schema Definition Language.- 7.2 Record Type Definition.- 7.2.1 Record Uniqueness Clause.- 7.2.2 Component Type.- 7.2.3 Record Check Clause.- 7.3 Set Type Definition.- 7.3.1 Owner Clause.- 7.3.2 Order Clause.- 7.3.3 Member Clause.- 7.4 Example Schema of Suppliers-and-Parts.- 8 Subschema Definition in NDL.- 8.1 Subschema Definition Language.- 9 Module Language in NDL.- 9.1 Tasks of the Module Language.- 9.2 Module Definition and Procedure Definition.- 9.3 Using an Embedded NDL Module.- 10 Data Manipulation in NDL.- 10.1 Tasks of the Data Manipulation Language.- 10.2 Sessions and Session State.- 10.2.1 Cursors.- 10.2.2 Temporary Sets.- 10.2.3 Ready List.- 10.3 DML Statements and their Classification.- 10.3.1 Handling of Transactions.- 10.3.2 Readying of Record Types for Processing.- 10.3.3 Location of Record Occurrences.- 10.3.4 Manipulation of Record Occurrences.- 10.3.5 Connection Between Records and Set Occurrences.- 10.3.6 Nullifying Cursors.- 10.3.7 Test for Database Key, Set and Set Membership.- Appendixes.- Appendix A. Values, Search Conditions and Queries in SQL.- Appendix B. Conditions in NDL.- Appendix C. Auxiliary NDL Operations.- Appendix D. An Example Database of Suppliers-and-Parts.- Appendix E. SQL Keywords.- Appendix F. NDL Keywords.- References.