コンテンツへ移動
An introduction to database systems 資料のプレビュー
閉じる資料のプレビュー
確認中…

An introduction to database systems

著者: Christopher John Date
出版: Reading, Mass. : Pearson : Addison-Wesley, cop. 2004.
エディション/フォーマット:   book_printbook : English : 8th edすべてのエディションとフォーマットを見る
データベース:WorldCat
概要:
This book provides a comprehensive introduction to the large field of database systems through a solid grounding in the foundations of database technology.
評価:

(まだ評価がありません) 0 件のレビュー - 是非あなたから!

件名:
関連情報:

 

オンラインで入手

この資料へのリンク

オフラインで入手

&AllPage.SpinnerRetrieving; この資料の所蔵館を検索中…

詳細

ジャンル/形式: Matériel didactique
資料の種類: インターネット資料
ドキュメントの種類: 図書, インターネットリソース
すべての著者/寄与者: Christopher John Date
ISBN: 0321189566 9780321189561 0321197844 9780321197849
OCLC No.: 493222160
物理形態: 1 v. (XXVII-983 p.) : ill. ; 25 cm.
コンテンツ: (All chapters begin with an Introduction end with a Summary, Exercises, and Reference and Bibliography) I. PRELIMINARIES. 1. An Overview of Database Management. What is a database system? What is a database? Why database? Data independence. Relational systems and others. 2. Database System Architecture. The three levels of the architecture. The external level. The conceptual level. The internal level. Mappings. The database administrator. The database management system. Data communications. Client/server architecture. Utilities. Distributed processing. 3. An Introduction to Relational Databases. An informal look at the relational model. Relations and relvars. What relations mean. Optimization. The catalog. Base relvars and views. Transactions. The suppliers-and-parts database. 4. An Introduction to SQL. Overview. The catalog. Views. Transactions. Embedded SQL. Dynamic SQL and SQL/CLI. SQL is not perfect. II. THE RELATIONAL MODEL. 5. Types. Values v Variables. Types v Representations. Type Definition. Operators. Type generators. SQL facilities. 6. Relations. Tuples. Relation types. Relation values. Relation variables. SQL facilities. 7. Relational Algebra. Closure revisited. The original algebra: Syntax. The original algebra: Semantics. Examples. What is the algebra for? Further points. Additional operators. Grouping and ungrouping. 8. Relational Calculus. Tuple calculus. Examples. Calculus vs. algebra. Computational capabilities. SQL facilities. Domain calculus. Query-By-Example. 9. Integrity. A closer look. Predicates and propositions. Relvar predicates and database predicates. Checking the constraints. Internal v external constraints. Correctness v consistency. Integrity and views. A constraint classification scheme. Keys. Triggers (a digression). SQL facilities. 10. Views. What are views for? View retrievals. View updates. Snapshots (a digression). SQL facilities. III. DATABASE DESIGN. 11. Functional Dependencies. Basic definitions. Trivial and nontrivial dependencies. Closure of a set of dependencies. Closure of a set of attributes. Irreducible sets of dependencies. 12. Further Normalization I: 1NF, 2NF, 3NF, BCNF. Nonloss decomposition and functional dependencies. First, second, and third normal forms. Dependency preservation. Boyce/Codd normal form. A note on relation-valued attributes. 13. Further Normalization II: Higher Normal Forms. Multi-valued dependencies and fourth normal form. Join dependencies and fifth normal form. The normalization procedure summarized. A note on denormalization. Orthogonal design (a digression). Other normal forms. 14. Semantic Modeling. The overall approach. The E/R model. E/R diagrams. Database design with the E/R model. A brief analysis. IV. TRANSACTION MANAGEMENT. 15. Recovery. Transactions. Transaction recovery. System recovery. Media recovery. Two-phase commit. Savepoints (a digression). SQL facilities. 16. Concurrency. Three concurrency problems. Locking. The three concurrency problems revisited. Deadlock. Serializability. Recovery revisited. Isolation levels. Intent locking. ACID dropping. SQL facilities. V. FURTHER TOPICS. 17. Security. Discretionary access control. Mandatory access control. Statistical databases. Data encryption. SQL facilities. 18. Optimization. A motivating example. An overview of query processing. Expression transformation. Database statistics. A divide-and-conquer strategy. Implementing the relational operators. 19. Missing Information. An overview of the 3VL approach. Some consequences of the foregoing scheme. Nulls and keys. Outer join (a digression). Special values. SQL facilities. 20. Type Inheritance. Type hierarchies. Polymorphism and substitutability. Variables and assignments. Specialization by constraint. Comparisons. Operators, versions, and signatures. Is a circle an ellipse? Specialization by constraint revisited. SQL facilities. 21. Distributed Databases. Some preliminaries. The twelve objectives. Problems of distributed systems. Client/server systems. DBMS independence. SQL facilities. 22. Decision Support. Aspects of decision support. Database design for decision support. Data preparation. Data warehouses and data marts. Online analytical processing. Data mining. SQL facilities. 23. Temporal Databases. What is the problem? Intervals. Packing and unpacking relations. Generalizing the relational operators. Database work design. Integrity constraints. 24. Logic-Based Databases. Overview. Propositional calculus. Predicate calculus. A proof-theoretic view of databases. Deductive database systems. Recursive query processing. VI. OBJECTS, RELATIONS, AND XML. 25. Object Databases. Objects, classes, methods, and messages. A closer look. A cradle-to-grave example. Miscellaneous issues. 26. Object / Relational Databases. The First Great Blunder. The Second Great Blunder. Implementation issues. Benefits of true rapprochement. SQL facilities. 27. The World Wide Web and XML. The Web and the Internet. An overview of XML. XML data definition. XML data manipulation. XML and databases. SQL facilities. APPENDIXES. Appendix A: The TransRelational(TM) Model. Three levels of abstraction. The basic idea. Condensed columns. Merged columns. Implementing the relational operators. Appendix B: SQL Expressions, Table Expressions, and Boolean Expressions. Appendix C: Abbreviations, Acronyms, and Symbol. Appendix D: Online storage structures and access methods, database access: an overview, page sets and files, indexing, hashing, pointer chains, and compression techniques. Index.
責任者: C.J. Date.

概要:

Provides a comprehensive introduction to the field of database systems. This eighth edition provides a grounding in the foundations of database technology while shedding some light on how the field  続きを読む

レビュー

ユーザーレビュー
GoodReadsのレビューを取得中…
DOGObooksのレビューを取得中…

タグ

まずはあなたから!
リクエストの確認

あなたは既にこの資料をリクエストしている可能性があります。このリクエストを続行してよろしければ、OK を選択してください。

リンクデータ


Primary Entity

<http://www.worldcat.org/oclc/493222160> # An introduction to database systems
    a schema:Book, schema:CreativeWork ;
   library:oclcnum "493222160" ;
   library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/679259#Place/reading_mass> ; # Reading, Mass.
   library:placeOfPublication <http://id.loc.gov/vocabulary/countries/mau> ;
   schema:about <http://experiment.worldcat.org/entity/work/data/679259#Topic/architecture_base_donnee> ; # architecture base donnée
   schema:about <http://experiment.worldcat.org/entity/work/data/679259#Topic/bases_de_donnees_manuels_d_enseignement_superieur> ; # Bases de données--Manuels d'enseignement supérieur
   schema:about <http://experiment.worldcat.org/entity/work/data/679259#Topic/integrite_base_donnee> ; # intégrité base donnée
   schema:about <http://experiment.worldcat.org/entity/work/data/679259#Topic/xml> ; # XML
   schema:about <http://dewey.info/class/005.74/e21/> ;
   schema:about <http://experiment.worldcat.org/entity/work/data/679259#Topic/base_de_donnees_gestion> ; # base de données - gestion
   schema:about <http://experiment.worldcat.org/entity/work/data/679259#Topic/base_de_donnees> ; # Base de données
   schema:about <http://experiment.worldcat.org/entity/work/data/679259#Topic/base_donnee_repartie> ; # base donnée répartie
   schema:about <http://experiment.worldcat.org/entity/work/data/679259#Topic/modele_representation> ; # modèle représentation
   schema:about <http://experiment.worldcat.org/entity/work/data/679259#Topic/sql> ; # SQL
   schema:about <http://experiment.worldcat.org/entity/work/data/679259#Thing/algebre> ; # Algebre
   schema:about <http://experiment.worldcat.org/entity/work/data/679259#Topic/bases_de_donnees_conception> ; # Bases de données--Conception
   schema:about <http://experiment.worldcat.org/entity/work/data/679259#Thing/information> ; # Information
   schema:about <http://experiment.worldcat.org/entity/work/data/679259#Topic/gestion_transaction> ; # gestion transaction
   schema:about <http://experiment.worldcat.org/entity/work/data/679259#Topic/gestion_des_bases_de_donnees> ; # Gestion des bases de données
   schema:about <http://experiment.worldcat.org/entity/work/data/679259#Topic/base_donnee_relationnelle> ; # base donnée relationnelle
   schema:about <http://experiment.worldcat.org/entity/work/data/679259#Topic/normalisation_base_donnee> ; # normalisation base donnée
   schema:about <http://id.worldcat.org/fast/888037> ; # Database management
   schema:about <http://experiment.worldcat.org/entity/work/data/679259#Topic/base_donnee_orientee_objet> ; # base donnée orientée objet
   schema:about <http://experiment.worldcat.org/entity/work/data/679259#Topic/conception_base_donnee> ; # conception base donnée
   schema:about <http://experiment.worldcat.org/entity/work/data/679259#Thing/sql> ; # Sql
   schema:about <http://experiment.worldcat.org/entity/work/data/679259#Topic/www> ; # WWW
   schema:about <http://experiment.worldcat.org/entity/work/data/679259#Topic/securite_base_donnee> ; # sécurité base donnée
   schema:about <http://experiment.worldcat.org/entity/work/data/679259#Topic/base_donnee_temporelle> ; # base donnée temporelle
   schema:about <http://experiment.worldcat.org/entity/work/data/679259#Topic/bases_de_donnees_gestion> ; # Bases de données--Gestion
   schema:about <http://experiment.worldcat.org/entity/work/data/679259#Topic/gestion_base_donnee> ; # gestion base donnée
   schema:bookEdition "8th ed." ;
   schema:bookFormat bgn:PrintBook ;
   schema:copyrightYear "op." ;
   schema:creator <http://experiment.worldcat.org/entity/work/data/679259#Person/date_christopher_john> ; # Christopher John Date
   schema:datePublished "2004" ;
   schema:description "This book provides a comprehensive introduction to the large field of database systems through a solid grounding in the foundations of database technology." ;
   schema:exampleOfWork <http://worldcat.org/entity/work/id/679259> ;
   schema:genre "Matériel didactique"@fr ;
   schema:inLanguage "en" ;
   schema:name "An introduction to database systems" ;
   schema:productID "493222160" ;
   schema:publication <http://www.worldcat.org/title/-/oclc/493222160#PublicationEvent/reading_mass_pearson_addison_wesley_cop_2004> ;
   schema:publisher <http://experiment.worldcat.org/entity/work/data/679259#Agent/addison_wesley> ; # Addison-Wesley
   schema:publisher <http://experiment.worldcat.org/entity/work/data/679259#Agent/pearson> ; # Pearson
   schema:url <http://www.uqtr.ca/biblio/notice/tablemat/18169760TM.html> ;
   schema:url <http://www.aw-bc.com/catalog/academic/product/0,4096,0321197844,00.html> ;
   schema:workExample <http://worldcat.org/isbn/9780321189561> ;
   schema:workExample <http://worldcat.org/isbn/9780321197849> ;
   wdrs:describedby <http://www.worldcat.org/title/-/oclc/493222160> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/679259#Agent/addison_wesley> # Addison-Wesley
    a bgn:Agent ;
   schema:name "Addison-Wesley" ;
    .

<http://experiment.worldcat.org/entity/work/data/679259#Person/date_christopher_john> # Christopher John Date
    a schema:Person ;
   schema:familyName "Date" ;
   schema:givenName "Christopher John" ;
   schema:name "Christopher John Date" ;
    .

<http://experiment.worldcat.org/entity/work/data/679259#Place/reading_mass> # Reading, Mass.
    a schema:Place ;
   schema:name "Reading, Mass." ;
    .

<http://experiment.worldcat.org/entity/work/data/679259#Topic/architecture_base_donnee> # architecture base donnée
    a schema:Intangible ;
   schema:name "architecture base donnée" ;
    .

<http://experiment.worldcat.org/entity/work/data/679259#Topic/base_de_donnees_gestion> # base de données - gestion
    a schema:Intangible ;
   schema:name "base de données - gestion" ;
    .

<http://experiment.worldcat.org/entity/work/data/679259#Topic/base_donnee_orientee_objet> # base donnée orientée objet
    a schema:Intangible ;
   schema:name "base donnée orientée objet" ;
    .

<http://experiment.worldcat.org/entity/work/data/679259#Topic/base_donnee_relationnelle> # base donnée relationnelle
    a schema:Intangible ;
   schema:name "base donnée relationnelle" ;
    .

<http://experiment.worldcat.org/entity/work/data/679259#Topic/base_donnee_repartie> # base donnée répartie
    a schema:Intangible ;
   schema:name "base donnée répartie" ;
    .

<http://experiment.worldcat.org/entity/work/data/679259#Topic/base_donnee_temporelle> # base donnée temporelle
    a schema:Intangible ;
   schema:name "base donnée temporelle" ;
    .

<http://experiment.worldcat.org/entity/work/data/679259#Topic/bases_de_donnees_conception> # Bases de données--Conception
    a schema:Intangible ;
   schema:name "Bases de données--Conception" ;
    .

<http://experiment.worldcat.org/entity/work/data/679259#Topic/bases_de_donnees_gestion> # Bases de données--Gestion
    a schema:Intangible ;
   schema:name "Bases de données--Gestion" ;
   schema:name "Bases de données--Gestion"@fr ;
    .

<http://experiment.worldcat.org/entity/work/data/679259#Topic/bases_de_donnees_manuels_d_enseignement_superieur> # Bases de données--Manuels d'enseignement supérieur
    a schema:Intangible ;
   schema:name "Bases de données--Manuels d'enseignement supérieur" ;
    .

<http://experiment.worldcat.org/entity/work/data/679259#Topic/conception_base_donnee> # conception base donnée
    a schema:Intangible ;
   schema:name "conception base donnée" ;
    .

<http://experiment.worldcat.org/entity/work/data/679259#Topic/gestion_base_donnee> # gestion base donnée
    a schema:Intangible ;
   schema:name "gestion base donnée" ;
    .

<http://experiment.worldcat.org/entity/work/data/679259#Topic/gestion_des_bases_de_donnees> # Gestion des bases de données
    a schema:Intangible ;
   schema:name "Gestion des bases de données" ;
    .

<http://experiment.worldcat.org/entity/work/data/679259#Topic/gestion_transaction> # gestion transaction
    a schema:Intangible ;
   schema:name "gestion transaction" ;
    .

<http://experiment.worldcat.org/entity/work/data/679259#Topic/integrite_base_donnee> # intégrité base donnée
    a schema:Intangible ;
   schema:name "intégrité base donnée" ;
    .

<http://experiment.worldcat.org/entity/work/data/679259#Topic/modele_representation> # modèle représentation
    a schema:Intangible ;
   schema:name "modèle représentation" ;
    .

<http://experiment.worldcat.org/entity/work/data/679259#Topic/normalisation_base_donnee> # normalisation base donnée
    a schema:Intangible ;
   schema:name "normalisation base donnée" ;
    .

<http://experiment.worldcat.org/entity/work/data/679259#Topic/securite_base_donnee> # sécurité base donnée
    a schema:Intangible ;
   schema:name "sécurité base donnée" ;
    .

<http://id.worldcat.org/fast/888037> # Database management
    a schema:Intangible ;
   schema:name "Database management" ;
    .

<http://worldcat.org/isbn/9780321189561>
    a schema:ProductModel ;
   schema:description "br" ;
   schema:isbn "0321189566" ;
   schema:isbn "9780321189561" ;
    .

<http://worldcat.org/isbn/9780321197849>
    a schema:ProductModel ;
   schema:isbn "0321197844" ;
   schema:isbn "9780321197849" ;
    .


Content-negotiable representations

ウインドウを閉じる

WorldCatにログインしてください 

アカウントをお持ちではないですか?簡単に 無料アカウントを作成することができます。.