Data/hora: 02/06/2024 05:20:48

Biblioteca(s): | Embrapa Agricultura Digital.
Data corrente: | 19/05/2011
Data da última atualização: | 25/07/2011
Autoria: | HALPIN, T.; MORGAN, T.
Afiliação: | TERRY HALPIN; TONY MORGAN.
Título: | Information modeling and relational databases.
Edição: | 2nd ed.
Ano de publicação: | 2008
Fonte/Imprenta: | Burlington: Morgan Kaufmann, 2008.
Páginas: | 943 p. il.
Série: | (Morgan Kaufmann series in data management systems).
ISBN: | 978-0-12-373568-3
Idioma: | Inglês
Conteúdo: | Information Modeling. Modeling Approaches. Some Historical Background. The Relevant Skills. Summary. Information Levels and Frameworks. Four Information Levels. The Conceptual Level. Database Design Example. Development Frameworks. Summary. Conceptual Modeling: First Steps. Conceptual Modeling Language Criteria. Conceptual Schema Design Procedure. CSDP Step 1: From Examples to Elementary Facts. CSDP Step 2: Draw Fact Types, and Populate. CSDP Step 3: Trim Schema; Note Basic Derivations. Summary. Uniqueness Constraints. CSDP Step 4: Uniqueness Constraints. Uniqueness Constraints on Unaries and Binaries. Uniqueness Constraints on Longer Fact Types. External Uniqueness Constraints. Key Length Check. Projections and Joins. Summary. Mandatory Roles Introduction to CSDP Step 5. Mandatory and Optional Roles. Reference Schemes. Case Study: A Compact Disc Retailer. Logical Derivation Check. Summary. Value, Set-Comparison and Subtype Constraints. Introduction to CSDP Step 6. Basic Set Theory. Value Constraints and Independent Types. Subset, Equality, and Exclusion Constraints. Subtyping. Generalization of Object Types. Summary. Other Constraints and Final Checks. Introduction to CSDP Step 7. Occurrence Frequencies. Ring Constraints. Other Constraints and Rules. Final Checks. Summary. Entity Relationship Modeling. Overview of ER. Barker notation. Information Engineering notation. IDEF1X. Mapping from ORM to ER. Summary. Data Modeling in UML. Introduction. Object-Orientation. Attributes. Associations. Set-Comparison constraints. Subtyping. Other Constraints and Derivation Rules. Mapping from ORM to UML. Summary. Advanced Modeling Issues. Join Constraints. Deontic Rules. Temporality. Collection Types. Nominalization and Objectification. Open/Closed World Semantics. Higher-Order Types. Summary. Relational Mapping. Implementing a Conceptual Schema. Relational Schemas. Relational Mapping Procedure. Advanced Mapping Aspects. Summary. Data Manipulation with Relational Languages. Relational Algebra. Relational Database Systems. SQL: Historical and Structural Overview. SQL: Identifiers and Data Types. SQL: Choosing Columns, Rows, and Order. SQL: Joins. SQL: In, Between, Like, and Null Operators. SQL: Union and Simple Subqueries. SQL: Scalar Operators and Bag Functions. SQL: Grouping. SQL: Correlated and Existential Subqueries. SQL: Recursive Queries. SQL: Updating Table Populations. Summary. Using Other Database Objects. SQL: The Bigger Picture. SQL: Defining Tables. SQL: Views. SQL: Triggers. SQL: Routines. SQL: More Database Objects. Transactions and Concurrency. Security and Meta-Data. Exploiting XML. Summary. Schema Transformations. Schema Equivalence and Optimization. Predicate Specialization and Generalization. Nesting, Coreferencing, and Flattening. Other Transformations. Conceptual Schema Optimization. Normalization. Denormalization and Low Level Optimization. Reengineering. Data Migration and Query Transformation. Summary. Process and State Modeling. Introduction. Processes and Workflow. State Models. Foundations for Process Theory. Modeling Information Dynamics in UML. Business Process Standards Initiatives. Standard Process Patterns. Summary. Other Modeling Aspects and Trends. Introduction. Data Warehousing and OLAP. Conceptual Query Languages. Schema Abstraction Mechanisms. Further Design Aspects. Ontologies and the Semantic Web. Postrelational Databases. Metamodeling. Summary. ORM glossary. ER glossary. UML glossary. Useful Web Sites.
Palavras-Chave: | Banco de dados; Modelagem de informação; Modeling.
Thesaurus Nal: | Databases.
Categoria do assunto: | X Pesquisa, Tecnologia e Engenharia
Registro original: | Embrapa Agricultura Digital (CNPTIA)
Exemplares: | CNPTIA - (15765-1) - ADC - LV - PP - 005.74 - HAL - 2011.00084 - DIS