Home Page Icon
Home Page
Table of Contents for
Other Modeling Aspects and Trends
Close
Other Modeling Aspects and Trends
by Tony Morgan, Terry Halpin
Information Modeling and Relational Databases, 2nd Edition
Copyright
Dedication
Foreword
Foreword
Foreword
Preface
Online Resources
ORM Software
Acknowledgments
Introduction
Information Modeling
Modeling Approaches
Some Historical Background
The Relevant Skills
Summary
Chapter Notes
Information Levels and Frameworks
Four Information Levels
The Conceptual Level
Database Design Example
Development Frameworks
Summary
Chapter Notes
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
Chapter Notes
Introduction to CSDP Step 4
Uniqueness Constraints on Unaries and Binaries
Uniqueness Constraints on Longer Fact Types
External Uniqueness Constraints
Key Length Check
Projections and Joins
Summary
Chapter Notes
Mandatory Roles
Introduction to CSDP Step 5
Mandatory and Optional Roles
Reference Schemes
Case Study: A Compact Disc Retailer
Logical Derivation Check
Summary
Chapter Notes
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
Chapter Notes
Other Constraints and Final Checks
Introduction to CSDP Step 7
Occurrence Frequencies
Ring Constraints
Other Constraints and Rules
Final Checks
Summary
Chapter Notes
Entity Relationship Modeling
Overview of ER
Barker Notation
Information Engineering Notation
IDEF1X
Mapping from ORM to ER
Summary
Chapter Notes
Data Modeling in UML
Introduction
Object-Orientation
Attributes
Associations
Subtyping
Other Constraints and Derivation Rules
Mapping from ORM to UML
Summary
Chapter Notes
Advanced Modeling Issues
Join Constraints
Deontic Rules
Temporality
Collection Types
Nominalization and Objectification
Open/Closed World Semantics
Summary
Chapter Notes
Relational Mapping
Implementing a Conceptual Schema
Relational Schemas
Relational Mapping Procedure
Advanced Mapping Aspects
Summary
Chapter Notes
Relational Languages
SQL: 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 is 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
Chapter Notes
Other Database Features
SQL: The Bigger Picture
SQL: Defining Tables
SQL: Views
SQL: Triggers
SQL: Routines
More Database Objects
Transactions and Concurrency
Security and Metadata
Exploiting XML
Summary
Chapter Notes
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
Chapter Notes
Process and State Modeling
Modeling Dynamic Behavior
Processes and Workflow
State Models
Foundations for Process Theory
Modeling Information Dynamics in UML
Business Process Standards Initiatives
Standard process patterns
Summary
Chapter Notes
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
Chapter Notes
ER Glossary
UML Glossary
Useful Web Sites
Fact-Oriented Modeling (General)
Fact-Oriented Modeling Tools
Business Rules and Architecture Frameworks
SQL, XML, RDF, and OWL
UML, OCL, MDA, and SBVR
Workflow Modeling
Information Modeling Organizations
Bibliography
About the Authors
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Chapter Notes
Next
Next Chapter
Introduction
16. Other Modeling Aspects and Trends
16.1
Introduction
16.2
Data Warehousing and OLAP
16.3
Conceptual Query Languages
16.4
Schema Abstraction Mechanisms
16.5
Further Design Aspects
16.6
Ontologies and the Semantic Web
16.7
Postrelational Databases
16.8
Metamodeling
16.9
Summary
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset