UT Dallas CS 6360 - CS-6360_ch02 Concepts and Architecture (46 pages)

Previewing pages 1, 2, 3, 22, 23, 24, 44, 45, 46 of 46 page document View the full content.
View Full Document

CS-6360_ch02 Concepts and Architecture



Previewing pages 1, 2, 3, 22, 23, 24, 44, 45, 46 of actual document.

View the full content.
View Full Document
View Full Document

CS-6360_ch02 Concepts and Architecture

173 views


Pages:
46
School:
University of Texas at Dallas
Course:
Cs 6360 - Database Design
Database Design Documents

Unformatted text preview:

Chapter 2 Concepts and Architecture CS 6360 Database Systems Chris Irwin Davis Ph D Email cid021000 utdallas edu Phone 972 883 3574 O ce ECSS 4 705 Chapter 2 Outline 2 1 Data Models Schemas and Instances 2 2 Three Schema Architecture and Data Independence 2 3 Database Languages and Interfaces 2 4 The Database System Environment 2 5 Centralized and Client Server Architectures for DBMSs 2 6 Classification of Database Management Systems 2 2 1 Data Models Schemas and Instances Concepts and Architecture Basic client server DBMS architecture Client module Server module 4 Data Models and Schemas Data abstraction Suppression of details of data organization and storage Highlighting of the essential features for an improved understanding of data 5 Data Models and Schemas Data model Collection of concepts that describe the structure of a database Provides means to achieve data abstraction Basic operations Specify retrievals and updates on the database Dynamic aspect or behavior of a database application Allows the database designer to specify a set of valid operations allowed on database objects 6 Categories of Data Models Implementation High level or conceptual data models Close to the way many users perceive data Low level or physical data models Describe the details of how data is stored on computer storage media Representational data models Easily understood by end users Also similar to how data organized in computer storage Hides many details of data storage on disk but can be implemented on a computer system directly 7 Categories of Data Models Conceptual Types Relational data model Used most frequently in traditional commercial DBMSs Object data model New family of higher level implementation data models Closer to conceptual data models 8 Categories of Data Models Conceptual Features Entity Represents a real world object or concept Attribute Represents some property of interest Further describes an entity Relationship among two or more entities Represents an



View Full Document

Access the best Study Guides, Lecture Notes and Practice Exams

Loading Unlocking...
Login

Join to view CS-6360_ch02 Concepts and Architecture and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view CS-6360_ch02 Concepts and Architecture and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?