数据库章节1解读.ppt

  1. 1、本文档共41页,可阅读全部内容。
  2. 2、有哪些信誉好的足球投注网站(book118)网站文档一经付费(服务费),不意味着购买了该文档的版权,仅供个人/单位学习、研究之用,不得用于商业用途,未经授权,严禁复制、发行、汇编、翻译或者网络传播等,侵权必究。
  3. 3、本站所有内容均由合作方或网友上传,本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺!文档内容仅供研究参考,付费前请自行鉴别。如您付费,意味着您自己接受本站规则且自行承担风险,本站不退款、不进行额外附加服务;查看《如何避免下载的几个坑》。如果您已付费下载过本站文档,您可以点击 这里二次下载
  4. 4、如文档侵犯商业秘密、侵犯著作权、侵犯人身权等,请点击“版权申诉”(推荐),也可以打举报电话:400-050-0827(电话支持时间:9:00-18:30)。
查看更多
Advantages of Database Approach (数据库技术的优势) Minimal data redundancy. Data consistency. Integration of data. Sharing of data. Enforcement of standards. Ease of application development. Uniform security, privacy and integrity. Data independence. * Focus On Data(以数据为核心) Data is most important Data defined first Standard format Access through DBMS Queries, Reports, Forms Application Programs * All Data DBMS Program1 Program2 Queries Reports Base Data Types(数据的表现形式) Numbers Integers Reals Text Length International Date/Time Images Bitmap Vector Sound Samples MIDI Video * Numbers, Text, and Dates Images Sound Video Input Process Output 12 + 8 = 20 000001100 000001000 ---------------- 000010100 20 0010000000000000000 0100000000000001001 0110000011000011011 0111111111111001111 1111111111111011111 1111111111100011111 8 9 20 7 8 19 5 6 15 000001000 000001001 000010100 ..... pitch, volume time 00101010111 11010101010 01010101010 11110100011 00101011011 00101010111 11010101010 01010101010 11110100011 00101011011 00101010111 11010101010 01010101010 11110100011 00101011011 00101010111 11010101010 01010101010 11110100011 00101011011 00101010111 11010101010 01010101010 11110100011 00101011011 Levels of Abstractions in DBMS (DBMS中的数据抽象化) * Example: University database * Data Independency (数据独立性) * Drawbacks of old File methods (文件存储方式的不足) Uncontrolled Duplication Wastes space Hard to update all files Inconsistent data Inflexibility Hard to change data Hard to change programs Limited data sharing Poor enforcement of standards Poor programmer productivity Excessive program maintenance * Example of DBMS vs. File Method (I) A University Database stores the following information: Students Professors Courses Classrooms Who teaches what Who teaches where Who teaches whom * University database: Students: studentID, name, sex, age, grade, class, courseID; Professors: staffID, name, sex, age, courseID, department; Courses: courseID, title, hours, classroomID, schedule; Classrooms: classroomID

文档评论(0)

shuwkb + 关注
实名认证
内容提供者

该用户很懒,什么也没介绍

1亿VIP精品文档

相关文档