1 / 16

POKOK BAHASAN Pertemuan 10

POKOK BAHASAN Pertemuan 10. Matakuliah : Sistem Informasi Manajemen Tahun : 2008. Chapter 3. Information Technology For Management 6 th Edition Turban, Leidner, McLean, Wetherbe Lecture Slides by L. Beaubien, Providence College John Wiley & Sons, Inc.

hayden
Download Presentation

POKOK BAHASAN Pertemuan 10

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. POKOK BAHASANPertemuan 10 Matakuliah : Sistem Informasi Manajemen Tahun : 2008

  2. Chapter 3 Information Technology For Management 6th Edition Turban, Leidner, McLean, Wetherbe Lecture Slides by L. Beaubien, Providence College John Wiley & Sons, Inc. Data Management: Data, Databases and Warehousing

  3. Learning Objectives • Recognize the importance of data, managerial issues, and life cycle • Describe sources of data, collection, and quality • Describe DMS • Describe Data Warehousing and Analytical Processing • Describe DBMS (benefits and issues)

  4. Introduction of Database • File-Based Approach • Limitation of File Based Approach • Database Approach • The Database

  5. File-Based Approach • File Based System is a collection of application programs that perform services for the end-users as the production of reports. Each program defines and manages its own data

  6. Aspects • Computerization: • Hardware • Software • Data • Information Needed: • Programmer • Users • Database Administrator

  7. Database System Component • Data: • Shared Data • Integrated • Hardware • Data Capacity • Software: • Creating File, Insert, Retrieving Data, Deleting Data, Security Control, Integrity Control, Recovery Control

  8. File-Based Approach

  9. Limitation of File Based-Approach • Separation and isolation of data • Duplication of Data • Data Dependence • Incompatible File Format • No Security

  10. Database Approach • DBMS: A Software system that enables users to define, create, maintain, and control access to the database • Facilities: • Its allows user to define the database through a Data Definition Language • Its allow user to Insert, Update, Retrieve data From The Database through Data Manipulation Language

  11. DBMS • Its provide controlled access to the database. For Example, it may provide: • A security system which prevents unauthorized users accessing the database • An integrity system which maintains the consistency of stored data • A concurrency control system, which allows shared access of the database • A recovery control system • A User control Catalog

  12. The Database • Advantages of DBMS: • Control of data Redudancy • Data Consistency • More information from the same amount of data • Sharing of data • Improved Data integrity • Improved Security • Enforcement Standard • Economic of Scale • Balance of Conflicting Requirement • Improved Data Accessibility and responsiveness • Increased Productivity

  13. The Database • Advantages of DBMS: • Improved maintenance through data independence • Increase concurrency • Improved Backup and recovery Services

  14. The Database • Disadvantages: • Complexity • Size • Cost of DBMS • Additional Hardware Costs • Cost of Conversion • Performance • Higher Impact of a Failure

  15. Review Questions • What differences between file-based system and Database ? • What is limitation of File-Based system ? • What is DBMS ?

More Related