Information Modeling and Relational Databases

Name: Information Modeling and Relational Databases
Price: 6.76 USD
Availability: InStock
ISBN: 9780123735683

ISBN-10: 0123735688

ISBN-13: 9780123735683

Edition: 2nd 2008

Authors: Terry Halpin, Tony Morgan

List price: $89.95

30 day, 100% satisfaction guarantee!

Rent eBooks

150 day rental: $35.65 Expiration date: 9/23/2024

Marketplace

2 new & used from $6.76

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

Information Modeling and Relational Databases, second edition, provides an introduction to ORM (Object-Role Modeling)and much more. In fact, it is the only book to go beyond introductory coverage and provide all of the in-depth instruction you need to transform knowledge from domain experts into a sound database design. This book is intended for anyone with a stake in the accuracy and efficacy of databases: systems analysts, information modelers, database designers and administrators, and programmers. Terry Halpin, a pioneer in the development of ORM, blends conceptual information with practical instruction that will let you begin using ORM effectively as soon as possible. Supported by…

Book details

List price: $89.95
Edition: 2nd
Copyright year: 2008
Publisher: Elsevier Science & Technology
Publication date: 4/10/2008
Binding: Hardcover
Pages: 976
Size: 7.52" wide x 9.25" long x 0.72" tall
Weight: 3.740
Language: English

Dr. Terry Halpin is a professor at Northface University. He has led database research teams at several companies including Visio Corporation and Microsoft Corporation, where he worked on the conceptual and logical database modeling technology in Microsoft Visio for Enterprise Architects. His publications include over 100 technical papers and five books.




Introduction



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





Arity Check





















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



CSDP Step 6: Value, Set-Comparison and Subtype constraints



Basic Set Theory



Value Constraints and Independent Objects



Subset, Equality, and Exclusion Constraints



Subtyping



Generalization of Object Types



Summary



Other Constraints and Final Checks



CSDP Step 7: Other Constraints and Final Checks



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



SQL: Other Useful Constructs



Summary



Using Other Database Objects



SQL: Data Definition



SQL: User Defined Functions



SQL: Views and Computed Columns



SQL: Triggers



SQL: Stored Procedures



SQL: Indexes



Other Objects



Exploiting 3GLs



Exploiting XML



Security and Meta-Data



Concurrency



Summary



Schema Transformations



Schema Equivalence and Optimization



Predicate Specialization and Generalization



Nesting, Coreferencing, and Flattening



Other Transformations