1 / 15

DBMS

DBMS. Strategic Planning for Information Resources. Create enterprise data model. 1. Enterprise Data Model. Data Needs Can Be Defined by Creating an Enterprise Model. Develop Database. 2. Database. 9- 2. Describing the Database Contents. Data dictionary. Enter

ling
Download Presentation

DBMS

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. DBMS

  2. Strategic Planning for Information Resources Create enterprise data model 1. Enterprise Data Model Data Needs Can Be Defined by Creating an Enterprise Model Develop Database 2. Database 9-2

  3. Describing the Database Contents Data dictionary Enter dictionary data Step 1 Data description language (DDL) Step 2 Schema 9-3

  4. Schema • Data field name • Aliases (other names used for same data field) • Type of data (numeric alphabetic) • Number of positions • Number of decimal positions • Various integrity rules 9-4

  5. Rule for Required Field 9-5

  6. Enforcing Value of BookName 9-6

  7. Creating a Database • 1) Describe the data • 2) Enter the data • 3) Use the database • Query language • Query-by-example • Data manipulation language (DML) 9-7

  8. Query-by-Example 9-8

  9. The Database Administrator (DBA) D B A Duties • Database planning; work with users and others, define schema, etc. • Database implementation; creating the database and enforcing policies and procedures • Database operations • Database security 9-9

  10. Data description language processor A DBMS Model Database description (schema) Database manager Data manipulation language (DML) Query language Database Performance statistics Application programs Performance statistics processor Transaction log Information Information requests Performance statistics Backup/recovery module 9-10

  11. Knowledge Discovery in Databases (KDD) • Data warehousing • refinement in the database concept to make it • very large • very pure • very retrievable • Data mart • a more modest approach than data warehousing, generally only one segment of the firm 9-11

  12. Knowledge Discovery in Databases (KDD) (cont.) • Data mining • the process of finding relationships in data that are unknown to the user • may be for • verification • discovery • combination of verification and discovery 9-12

  13. DataBase Management System Advantages • Reduce data redundancy • Achieve data independence • Enable integration of data from multiple files • Retrieve data and information quickly • Improve security 9-13

  14. DBMS Disadvantages • Obtain expensive software • Obtain a large hardware configuration • Hire and maintain a DBA staff Requires a firm to: 9-14

  15. Summary • Organizations are storing vast amounts of data • Organization and structures in database • Dominated by relational • Staff positions • DBA • Knowledge discovery in databases • Database management systems 9-15

More Related