1 / 19

IS 4420 Database Fundamentals Leon Chen

IS 4420 Database Fundamentals Leon Chen . Agenda. About yourself Name Major About the instructor Syllabus Chapter 1. IS 4420 Database Fundamentals Chapter 1: The Database Environment Leon Chen. Overview. Database environment and Client/Server architecture

adamdaniel
Download Presentation

IS 4420 Database Fundamentals Leon Chen

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. IS 4420Database Fundamentals Leon Chen

  2. Agenda • About yourself • Name • Major • About the instructor • Syllabus • Chapter 1

  3. IS 4420Database FundamentalsChapter 1:The Database EnvironmentLeon Chen

  4. Overview • Database environment and Client/Server architecture • Database, data, information, and metadata • Evolution of database systems • Advantages of databases • Costs and risks of databases • Categories of databases • Components of database environment

  5. Figure 1-11 Components of the database environment Metadata Data

  6. Figure 2-11 Three-tiered client/server database architecture

  7. Definitions • Database - organized collection of logically related data • Data - stored representations of meaningful objects and events • Structured: numbers, text, dates • Unstructured: images, video, documents • Information: data processed to increase knowledge of the user • Metadata: data that describes the properties and context of user data (data about data)

  8. Figure 1-1a Converting data to information - data in context

  9. Graphical displays turn data into useful information that managers can use for decision making and interpretation

  10. Metadata • Data that describes the properties and context of user data (data about data)

  11. Evolution of Database Systems • Flat files (not database) - 1960s - 1980s • Hierarchical – 1970s - 1990s • Network – 1970s - 1990s • Relational – 1980s - present • Object-oriented – 1990s - present • Object-relational – 1990s - present • Data warehousing – 1980s - present • Web-enabled – 1990s - present

  12. DATABASE Approach • Central repository of shared data • Stored in a standardized, convenient form • Requires a Database Management System (DBMS) • A software system that is used to create, maintain, and provide controlled access to user databases

  13. Figure 1-11 Components of the database environment

  14. Components of the Database Environment • CASE Tools – computer-aided software engineering • Repository – centralized storehouse of metadata • Database Management System (DBMS) – software for managing the database • Database – storehouse of the data • Application Programs – software using the data • User Interface – text and graphical displays to users • Data Administrators – personnel responsible for maintaining the database • System Developers – personnel responsible for designing databases and software • End Users – people who use the applications and databases

  15. Data Database application Repository Metadata Information DBMS Database ERP Enterprise data model Data placed in context or summarized Application program Facts, text, graphics, etc. A graphical model about an organization Organized collection of related data Data definitions and constraints Centralized storehouse for all data definitions An integrated enterprise level MIS A software application to create, maintain and control a database Match terms and definitions

More Related