1 / 29

Chapter 1 Databases Introduction

Chapter 1 Databases Introduction. The content. 1).Database Application 2).Database concept 3).An example of database 4).Function of DBMS 5).DBMS product Difficulty: the function of DBMS Focus on: the concept of DBMS Hours:2 hours Teaching way: ppt. Database Application.

chiara
Download Presentation

Chapter 1 Databases Introduction

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. Chapter 1 Databases Introduction

  2. The content • 1).Database Application • 2).Database concept • 3).An example of database • 4).Function of DBMS • 5).DBMS product • Difficulty: the function of DBMS • Focus on: the concept of DBMS • Hours:2 hours • Teaching way: ppt

  3. Database Application • Databases touch all aspects of our lives • Banking: all transactions • Airlines: reservations, schedules • Universities: registration, grades • Sales: customers, products, purchases • Online retailers: order tracking, customized recommendations • Manufacturing: production, inventory, orders, supply chain • Human resources: employee records, salaries, tax deductions

  4. Database concept • 1) Data • Used to describe the world. • can be recorded and have implicit meaning. • Data can exist in a variety of forms -- as numerical numbers, letters, text, image, sound, video and etc. • Data can be stored ,processed, transmitted. • Example: • （Tom，male，1992，Chang Sha，computer specialty，2010）

  5. Database concept • 2) Database • it’s nothing more than a collection of related data that exists over a long period of time.

  6. Example of Data and Database

  7. Sizes of Database • Personal database • 1 user; < 10 MB • Workgroup database • < 25 users; < 100 MB • Organizational database • Hundreds to thousands users • >1 Trillion bytes, possibly several databases

  8. Database concept • 3) DBMS • A collection of programs that enables you to store, modify, protect,manage and extract information from a database. • There are many different types of DBMSs, ranging from small systems that run on personal computers to huge systems that run on mainframes.

  9. DBMS functionality • Definition • Define a database involves defining the data types, structures, and constraints for the data to be stored in the database. Manipulation • Manipulating a database includes such functions as querying the database to retrieve specific data, updating the database to reflect changes in the miniworld Sharing • Sharing a database allows multiple users and programs to access the database concurrently.

  10. DBMS functionality Protection • includes both system protection against hardware or software malfunction (or crashes), and security protection against unauthorized or malicious access. Maintenance Such as inputting and transferring of Data, DB backup and recovery, performance monitoring, audit and analysis etc.

  11. User User DB applications Application Systems Developing Tools Developing Tools DBMS DBMS, Compiling System DBA Operating System OS Hardware DB Database System (DBS) • 4) Database System (DBS). • DB, DBMS, Development Tools, DB applications, DB Administrator (DBA) and users DBMS in Computer System

  12. A simplified database system environment.

  13. A specific exampleA database that stores student and course information.

  14. A specific exampleA database that stores student and course information.

  15. A specific exampleA database that stores student and course information.

  16. A specific exampleTwo views derived from the database in Figure (a) The STUDENT TRANSCRIPT view. (b) The COURSE PREREQUISITES view.

  17. 3 DBMS Product

  18. The DBMS Marketplace • Relational DBMS companies – Oracle, Sybase – are among the largest software companies in the world. • IBM offers its relational DB2 system. With IMS, a nonrelational system, IBM is by some accounts the largest DBMS vendor in the world. • Microsoft offers SQL-Server, plus Microsoft Access for the cheap DBMS on the desktop, answered by “lite” systems from other competitors. • Relational companies also challenged by “object-oriented DB” companies. • But countered with “object-relational” systems, which retain the relational core while allowing type extension as in OO systems.

  19. Summary • From this lecture you can learn the basic concept of database such as DB,DBS,DBMS and the differences between them ,the function of DBMS and the history of data processing and via an example you can master these concept better.

  20. Any Questions? If there are any outstanding questions you can ask me one-to-one after the lecture OR privately in my office.

  21. Exercises • What are the definitions of data ,DB,DBMS,DBS,DBA? • Go to search the internet and find out the tendency of database. • Learn MS Access by yourself.

More Related