DOC PREVIEW
UT Dallas CS 6360 - Ch02

This preview shows page 1-2-3-18-19-36-37-38 out of 38 pages.

Save
View full document
View full document
Premium Document
Do you want full access? Go Premium and unlock all 38 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 38 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 38 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 38 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 38 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 38 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 38 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 38 pages.
Access to all documents
Download any document
Ad free experience
Premium Document
Do you want full access? Go Premium and unlock all 38 pages.
Access to all documents
Download any document
Ad free experience

Unformatted text preview:

Slide 1Chapter 2 OutlineDatabase System Concepts and ArchitectureData Models, Schemas, and InstancesData Models, Schemas, and Instances (cont'd.)Categories of Data ModelsCategories of Data Models (cont'd.)Slide 8Slide 9Schemas, Instances, and Database StateSchemas, Instances, and Database State (cont'd.)Slide 12Slide 13Three-Schema Architecture and Data IndependenceThree-Schema Architecture and Data Independence (cont'd.)Data IndependenceDBMS LanguagesDBMS InterfacesThe Database System EnvironmentThe Database System Environment (cont'd.)Slide 21Database System UtilitiesDatabase System Utilities (cont'd.)Centralized and Client/Server Architectures for DBMSsSlide 25Basic Client/Server ArchitecturesBasic Client/Server Architectures (cont'd.)Slide 28Slide 29Two-Tier Client/Server Architectures for DBMSsTwo-Tier Client/Server Architectures (cont'd.)Three-Tier and n-Tier Architectures for Web ApplicationsSlide 33Classification of Database Management SystemsClassification of Database Management Systems (cont'd.)Slide 36Slide 37SummaryCopyright © 2011 Pearson Education, Inc. Publishing as Pearson Addison-WesleyChapter 2Database System Concepts and ArchitectureCopyright © 2011 Ramez Elmasri and Shamkant NavatheChapter 2 OutlineData Models, Schemas, and InstancesThree-Schema Architecture and Data IndependenceDatabase Languages and InterfacesThe Database System EnvironmentCentralized and Client/Server Architecturesfor DBMSsClassification of Database Management SystemsCopyright © 2011 Ramez Elmasri and Shamkant NavatheDatabase System Conceptsand ArchitectureBasic client/server DBMS architectureClient moduleServer moduleCopyright © 2011 Ramez Elmasri and Shamkant NavatheData Models, Schemas, and InstancesData abstraction Suppression of details of data organization and storageHighlighting of the essential features for an improved understanding of dataCopyright © 2011 Ramez Elmasri and Shamkant NavatheData Models, Schemas, and Instances (cont'd.)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 databaseCopyright © 2011 Ramez Elmasri and Shamkant NavatheCategories of Data Models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 storageCopyright © 2011 Ramez Elmasri and Shamkant NavatheCategories of Data Models (cont'd.)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 association among the entitiesEntity-Relationship modelCopyright © 2011 Ramez Elmasri and Shamkant NavatheCategories of Data Models (cont'd.)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 modelsCopyright © 2011 Ramez Elmasri and Shamkant NavatheCategories of Data Models (cont'd.)Physical data models Describe how data is stored as files in the computer Access path •Structure that makes the search for particular database records efficientIndex •Example of an access path •Allows direct access to data using an index term or a keywordCopyright © 2011 Ramez Elmasri and Shamkant NavatheSchemas, Instances, and Database StateDatabase schemaDescription of a databaseSchema diagramA displayed schemaSchema constructEach object in the schemaDatabase state or snapshotData in database at a particular moment in timeCopyright © 2011 Ramez Elmasri and Shamkant NavatheSchemas, Instances, and Database State (cont'd.)Copyright © 2011 Ramez Elmasri and Shamkant NavatheSchemas, Instances, and Database State (cont'd.)Define a new databaseSpecify database schema to the DBMSInitial state Populated or loaded with the initial dataValid stateSatisfies the structure and constraints specified in the schemaCopyright © 2011 Ramez Elmasri and Shamkant NavatheSchemas, Instances, and Database State (cont'd.)Schema evolutionChanges applied to schema as application requirements changeCopyright © 2011 Ramez Elmasri and Shamkant NavatheThree-Schema Architectureand Data IndependenceInternal level Describes physical storage structure of the databaseConceptual levelDescribes structure of the whole database for a community of usersExternal or view level Describes part of the database that a particular user group is interested inCopyright © 2011 Ramez Elmasri and Shamkant NavatheThree-Schema Architectureand Data Independence (cont'd.)Copyright © 2011 Ramez Elmasri and Shamkant NavatheData IndependenceCapacity to change the schema at one level of a database system Without having to change the schema at the next higher levelTypes:LogicalPhysicalCopyright © 2011 Ramez Elmasri and Shamkant NavatheDBMS LanguagesData definition language (DDL)•Defines both schemasStorage definition language (SDL)•Specifies the internal schemaView definition language (VDL)•Specifies user views/mappings to conceptual schemaData manipulation language (DML)•Allows retrieval, insertion, deletion, modificationCopyright © 2011 Ramez Elmasri and Shamkant NavatheDBMS InterfacesMenu-based interfaces for Web clients or browsingForms-based interfacesNatural language interfacesSpeech input and outputInterfaces for parametric usersInterfaces for the DBACopyright © 2011 Ramez Elmasri and Shamkant NavatheThe Database System EnvironmentDBMS component modulesBuffer management Stored data manager DDL compiler Interactive query interface•Query compiler •Query optimizerPrecompilerCopyright © 2011 Ramez Elmasri and Shamkant NavatheThe Database System Environment (cont'd.)DBMS component modulesRuntime database processorSystem catalogConcurrency control systemBackup and recovery systemCopyright © 2011 Ramez Elmasri and Shamkant NavatheCopyright © 2011 Ramez Elmasri and Shamkant NavatheDatabase System UtilitiesLoadingLoad existing data filesBackupCreates a backup copy of the databaseCopyright © 2011 Ramez Elmasri


View Full Document

UT Dallas CS 6360 - Ch02

Documents in this Course
Ch22(1)

Ch22(1)

44 pages

Ch21

Ch21

38 pages

Ch19

Ch19

46 pages

Ch18

Ch18

25 pages

Ch17

Ch17

21 pages

Ch15

Ch15

42 pages

Ch09

Ch09

42 pages

Ch05

Ch05

34 pages

Ch22

Ch22

45 pages

Ch21

Ch21

38 pages

Ch19

Ch19

48 pages

Ch18

Ch18

24 pages

Ch17

Ch17

22 pages

Ch16

Ch16

17 pages

Ch15

Ch15

42 pages

Ch09

Ch09

42 pages

Ch08

Ch08

39 pages

Ch07

Ch07

34 pages

Ch06

Ch06

43 pages

Ch05

Ch05

34 pages

Ch04

Ch04

39 pages

Ch03(2)

Ch03(2)

36 pages

Ch02

Ch02

33 pages

Ch08

Ch08

28 pages

Ch07

Ch07

31 pages

Ch06

Ch06

43 pages

Ch05

Ch05

39 pages

Ch04(1)

Ch04(1)

39 pages

Ch03(1)

Ch03(1)

38 pages

Ch02

Ch02

38 pages

Ch01

Ch01

36 pages

Ch24

Ch24

36 pages

Ch21

Ch21

54 pages

Ch19

Ch19

48 pages

Ch18

Ch18

24 pages

Ch17

Ch17

22 pages

Ch03(1)

Ch03(1)

38 pages

Ch02

Ch02

38 pages

Ch01

Ch01

36 pages

Ch24

Ch24

36 pages

Ch21

Ch21

54 pages

Ch19

Ch19

48 pages

Ch18

Ch18

24 pages

Ch17

Ch17

22 pages

Ch08

Ch08

28 pages

Ch07

Ch07

31 pages

Ch06

Ch06

43 pages

Ch05

Ch05

39 pages

Ch04(1)

Ch04(1)

39 pages

Ch08

Ch08

39 pages

Ch07

Ch07

40 pages

Ch06

Ch06

47 pages

Ch05

Ch05

41 pages

Ch04

Ch04

43 pages

Ch03

Ch03

41 pages

Ch02

Ch02

38 pages

Ch01

Ch01

36 pages

Ch21

Ch21

54 pages

Ch19

Ch19

51 pages

Ch18

Ch18

24 pages

Ch08

Ch08

39 pages

Ch07

Ch07

40 pages

Ch06

Ch06

47 pages

Ch05

Ch05

41 pages

Ch04

Ch04

43 pages

Ch03

Ch03

41 pages

Ch02

Ch02

38 pages

Ch01

Ch01

36 pages

Ch21

Ch21

54 pages

Ch19

Ch19

51 pages

Ch18

Ch18

24 pages

Ch17

Ch17

25 pages

lab-manual

lab-manual

215 pages

Ch08

Ch08

39 pages

Ch07

Ch07

40 pages

Ch06

Ch06

47 pages

Ch05

Ch05

41 pages

Ch04

Ch04

43 pages

Ch03

Ch03

41 pages

Ch01

Ch01

36 pages

Ch21

Ch21

54 pages

Ch19

Ch19

51 pages

Ch17

Ch17

25 pages

Ch21

Ch21

54 pages

Ch19

Ch19

51 pages

Ch18

Ch18

24 pages

Ch17

Ch17

25 pages

Ch08

Ch08

39 pages

Ch07

Ch07

40 pages

Ch06

Ch06

47 pages

Ch05

Ch05

41 pages

Ch04

Ch04

43 pages

Ch03

Ch03

41 pages

Ch02

Ch02

38 pages

Ch01

Ch01

36 pages

Ch04(1)

Ch04(1)

43 pages

Ch07

Ch07

40 pages

Ch03

Ch03

42 pages

Ch01

Ch01

36 pages

Ch02

Ch02

38 pages

Ch05

Ch05

41 pages

Ch06

Ch06

47 pages

Ch08

Ch08

39 pages

Ch17

Ch17

25 pages

Ch18

Ch18

24 pages

Ch09

Ch09

42 pages

Ch21

Ch21

54 pages

Ch19

Ch19

51 pages

Ch21

Ch21

54 pages

Ch19

Ch19

51 pages

Ch18

Ch18

24 pages

Ch17

Ch17

25 pages

Ch09

Ch09

42 pages

Ch08

Ch08

39 pages

Ch07

Ch07

40 pages

Ch06

Ch06

47 pages

Ch05

Ch05

41 pages

Ch04(1)

Ch04(1)

43 pages

Ch03

Ch03

42 pages

Ch02

Ch02

38 pages

Ch01

Ch01

36 pages

Load more
Download Ch02
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view Ch02 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 Ch02 2 2 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?