DOC PREVIEW
UT Dallas CS 6360 - CS-6360_ch02 Concepts and Architecture

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:

!" #Chris Irwin Davis, Ph.D. Email: [email protected] Phone: (972) 883-3574 Office: ECSS 4.705Chapter 2: Concepts and ArchitectureCS-6360 Database Systems!" #2Chapter 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 Systems2.1 Data Models, Schemas, and Instances!" #Data Models and Schemas• Data model°One fundamental characteristic of the database approach is that it provides some level of data abstraction. °Collection of concepts that describe the structure of a database°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 objects4!" #5§2.1.1 Categories 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 storage°Hides many details of data storage on disk, but can be implemented on a computer system directly!" #6Categories 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•Semantic data model °Semantic Web!" #7Categories 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 association among the entities°Entity-Relationship model!" #Categories of Data Models• Physical°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 keyword8!" #Schemas, Instances, and Database State• In any data model, it is important to distinguish between the description of the database and the database itself9!" #Schemas, Instances, and Database State• Database schema°Description of a database• Schema diagram°Displays selected aspects of schema• Schema construct°Each object/instance in the schema (e.g. STUDENT or COURSE)• Database state or snapshot°Data in database at a particular moment in time10!" #11Schemas, Instances, and Database State!" #12Schemas, Instances, and Database StateTable Name Relation Name!" #13Schemas, Instances, and Database StateColumn name!Field name!" #Schemas, Instances, and Database State• 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 schema• Schema evolution°Changes applied to schema as application requirements change142.2 Three-Schema Architecture and Data Independence!" #16Three-Schema Architecture"and 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 in!" #Three-Schema Architecture"and Data Independence 17!" #Three-Schema Architecture"and Data Independence 18!" #Three-Schema Architecture"and Data Independence 19!" #Three-Schema Architecture"and Data Independence 20!" #21Data 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 °Physical •For example, changing to a different DBMS or disk drive without having to change the schema.2.3 Database Languages and Interfaces!" #23DBMS 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, modification!" #24DBMS User Interfaces (UIs)•Menu-based interfaces for Web clients or browsing•Forms-based interfaces•Graphical user interfaces (Like SSMS)•Natural language interfaces•Speech input and output•Interfaces for parametric users•Interfaces for the DBA2.5 Centralized and Client/Server Architectures!for DBMSs!" #26Centralized and Client/Server Architectures for DBMSs•Centralized DBMSs Architecture °All DBMS functionality, application program execution, and user interface processing carried out on one machine°This was the mainframe model, with dumb terminals. It is still widely used.!" #27Basic Client/Server Architectures•Servers with specific functionalities°File server •Maintains the files of the client machines.°Printer server •Connected to various printers; all print requests by the clients are forwarded to this machine°Web servers or e-mail servers!" #28Basic Client/Server Architectures•Client machines °Provide user with:•Appropriate interfaces to utilize these servers•Local processing power to run local applications•Server °System containing both hardware and software °Provides services to the client machines•Such as file access, printing, archiving, or database access!" #29Two-Tier Client/Server Architectures for DBMSs•Server handles°Query and transaction functionality related to SQL processing •Client handles°User interface programs and application programs!" #30Two-Tier Client/Server Architectures for DBMSs•Open Database Connectivity (ODBC) °Provides application programming interface (API)°Allows client-side programs to call the DBMS•Both client and server machines must have the necessary software installed•Java Database Connectivity (JDBC)°Allows Java client programs to access one or more DBMSs through a standard interface!" #31Three-Tier and n-Tier Architectures for Web Applications•Application server or Web server °Adds intermediate layer between client and the database server°Runs application programs and stores business rules•N-tier°Divide the layers


View Full Document

UT Dallas CS 6360 - CS-6360_ch02 Concepts and Architecture

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

Ch02

Ch02

38 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 CS-6360_ch02 Concepts and Architecture
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 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 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?