DOC PREVIEW
UT Dallas CS 6360 - Ch01

This preview shows page 1-2-17-18-19-35-36 out of 36 pages.

Save
View full document
View full document
Premium Document
Do you want full access? Go Premium and unlock all 36 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 36 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 36 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 36 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 36 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 36 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 36 pages.
Access to all documents
Download any document
Ad free experience
Premium Document
Do you want full access? Go Premium and unlock all 36 pages.
Access to all documents
Download any document
Ad free experience

Unformatted text preview:

Slide 1Chapter 1 OutlineIntroductionIntroduction (cont'd.)Slide 5Slide 6Slide 7An ExampleAn Example (cont'd.)Slide 10Slide 11Slide 12Slide 13Slide 14Slide 15Characteristics of the Database ApproachCharacteristics of the Database Approach (cont'd.)Self-Describing Nature of a Database SystemInsulation Between Programs and DataData AbstractionSlide 21Support of Multiple Views of the DataSharing of Data and Multiuser Transaction ProcessingSharing of Data and Multiuser Transaction Processing (cont'd.)Actors on the SceneActors on the Scene (cont'd.)Slide 27Workers behind the SceneAdvantages of Using the DBMS ApproachAdvantages of Using the DBMS Approach (cont'd.)Slide 31Slide 32Slide 33Slide 34When Not to Use a DBMSSummaryCopyright © 2011 Pearson Education, Inc. Publishing as Pearson Addison-WesleyChapter 1Databases and Database UsersCopyright © 2011 Ramez Elmasri and Shamkant NavatheChapter 1 OutlineIntroductionAn ExampleCharacteristics of the Database ApproachActors on the SceneWorkers behind the SceneAdvantages of Using the DBMS ApproachWhen Not to Use a DBMSCopyright © 2011 Ramez Elmasri and Shamkant NavatheIntroductionDatabase Collection of related dataKnown facts that can be recorded and that have implicit meaningMiniworld or universe of discourse (UoD)Represents some aspect of the real worldLogically coherent collection of data with inherent meaningBuilt for a specific purposeCopyright © 2011 Ramez Elmasri and Shamkant NavatheIntroduction (cont'd.)Example of a large commercial databaseAmazon.comDatabase management system (DBMS) Collection of programs Enables users to create and maintain a databaseDefining a database Specify the data types, structures, and constraints of the data to be storedCopyright © 2011 Ramez Elmasri and Shamkant NavatheIntroduction (cont'd.)Meta-dataDatabase definition or descriptive information Stored by the DBMS in the form of a database catalog or dictionaryManipulating a databaseQuery and update the database miniworld Generate reportsCopyright © 2011 Ramez Elmasri and Shamkant NavatheIntroduction (cont'd.)Sharing a database Allow multiple users and programs to access the database simultaneouslyApplication program Accesses database by sending queries to DBMSQuery Causes some data to be retrievedCopyright © 2011 Ramez Elmasri and Shamkant NavatheIntroduction (cont'd.)Transaction May cause some data to be read and some data to be written into the databaseProtection includes: System protectionSecurity protectionMaintain the database system Allow the system to evolve as requirements change over timeCopyright © 2011 Ramez Elmasri and Shamkant NavatheAn ExampleUNIVERSITY database Information concerning students, courses, and grades in a university environmentData recordsSTUDENT COURSESECTION GRADE_REPORT PREREQUISITECopyright © 2011 Ramez Elmasri and Shamkant NavatheAn Example (cont'd.)Specify structure of records of each file by specifying data type for each data element String of alphabetic charactersIntegerEtc.Copyright © 2011 Ramez Elmasri and Shamkant NavatheCopyright © 2011 Ramez Elmasri and Shamkant NavatheAn Example (cont'd.)Construct UNIVERSITY databaseStore data to represent each student, course, section, grade report, and prerequisite as a record in appropriate fileRelationships among the recordsManipulation involves querying and updatingCopyright © 2011 Ramez Elmasri and Shamkant NavatheAn Example (cont'd.)Examples of queries:Retrieve the transcriptList the names of students who took the section of the ‘Database’ course offered in fall 2008 and their grades in that sectionList the prerequisites of the ‘Database’ courseCopyright © 2011 Ramez Elmasri and Shamkant NavatheAn Example (cont'd.)Examples of updates:Change the class of ‘Smith’ to sophomoreCreate a new section for the ‘Database’ course for this semesterEnter a grade of ‘A’ for ‘Smith’ in the ‘Database’ section of last semesterCopyright © 2011 Ramez Elmasri and Shamkant NavatheAn Example (cont'd.)Phases for designing a database: Requirements specification and analysisConceptual designLogical design Physical designCopyright © 2011 Ramez Elmasri and Shamkant NavatheCopyright © 2011 Ramez Elmasri and Shamkant NavatheCharacteristics of the Database ApproachTraditional file processingEach user defines and implements the files needed for a specific software application Database approachSingle repository maintains data that is defined once and then accessed by various usersCopyright © 2011 Ramez Elmasri and Shamkant NavatheCharacteristics of the Database Approach (cont'd.)Main characteristics of database approach Self-describing nature of a database systemInsulation between programs and data, and data abstractionSupport of multiple views of the dataSharing of data and multiuser transaction processingCopyright © 2011 Ramez Elmasri and Shamkant NavatheSelf-Describing Nature of a Database SystemDatabase system contains complete definition of structure and constraintsMeta-dataDescribes structure of the databaseDatabase catalog used by: DBMS software Database users who need information about database structureCopyright © 2011 Ramez Elmasri and Shamkant NavatheInsulation Between Programs and DataProgram-data independenceStructure of data files is stored in DBMS catalog separately from access programsProgram-operation independenceOperations specified in two parts:•Interface includes operation name and data types of its arguments •Implementation can be changed without affecting the interfaceCopyright © 2011 Ramez Elmasri and Shamkant NavatheData abstractionAllows program-data independence and program-operation independenceConceptual representation of dataDoes not include details of how data is stored or how operations are implementedData model Type of data abstraction used to provide conceptual representationData AbstractionCopyright © 2011 Ramez Elmasri and Shamkant NavatheCopyright © 2011 Ramez Elmasri and Shamkant NavatheSupport of Multiple Views of the DataView Subset of the database Contains virtual data derived from the database files but is not explicitly storedMultiuser DBMS Users have a variety of distinct applicationsMust provide facilities for


View Full Document

UT Dallas CS 6360 - Ch01

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

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 Ch01
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 Ch01 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 Ch01 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?