1 / 24

DATABASE ADMINISTRATOR

DATABASE ADMINISTRATOR. Pertemuan ke-1. Database-DBMS-Database Administrator. INTRODUCTION. D ATABASE. Sekumpulan data yang saling berhubungan. RD BMS. RDBMS. perangkat lunak yang mengatur dan mengorganisasi penyimpanan database kedalam komputer. S TRUKTUR P ENYIMPANAN. BARIS.

muncel
Download Presentation

DATABASE ADMINISTRATOR

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. DATABASE ADMINISTRATOR Pertemuan ke-1

  2. Database-DBMS-Database Administrator INTRODUCTION

  3. DATABASE Sekumpulan data yang saling berhubungan

  4. RDBMS RDBMS perangkat lunak yang mengatur dan mengorganisasi penyimpanan database kedalam komputer

  5. STRUKTUR PENYIMPANAN BARIS NULL KOLOM FK PK FIELD

  6. Employees Departments HOWTHEDATAISORGANIZED Foreign Key Primary Key

  7. RDBMS MARKET sHARE

  8. COMPUTER & CAREER OPPORTUNITY

  9. DATABASEADMINISTRATOR Orang yang memastikan fungsi operasional aplikasi dan database organisasi dapat berjalan secara efisien

  10. MANAGEMENTDISCIPLINE OF DBA A good DBA is integral to the entire application development life cycle.

  11. DATA,DATABASE, AND SYSTEM ADMINISTRATOR

  12. DATA,DATABASE, AND SYSTEM ADMINISTRATOR

  13. DA task • Identifying and cataloging the data required by business users • Producing conceptual and logical data models to accurately depict the relationship among data elements for business processes • Creating an enterprise data model that incorporates all of the data used by all of the organization's business processes • Setting data policies for the organization • Identifying data owners and stewards • Setting standards for control and usage of data

  14. SA Task • ensures that the IT infrastructure is operational for database development • setting up the DBMS appropriately • applying ongoing maintenance from the DBMS vendor • coordinating migration to new DBMS releases and versions.

  15. TASKSOF DBA

  16. TASKSOF DBA: DATABASE DESIGN • the DBA must understand • relational design practices. • relational theory and the specific implementation of the relational database management system (RDBMS) • conceptual and logical data modeling techniques. The ability to create and interpret entity-relationship diagrams is essential to designing a relational database.

  17. Type of DBA • System DBA • A system DBA focuses on technical rather than business issues, primarily in the system administration area • Indeed, the job of system DBA usually exists only if the organization does not have an official system administration or systems programming department. • Database Architect • The database architect is involved in new design and development work only.

  18. Database Analyst • Sometimes junior DBAs are referred to as database analysts. • Sometimes a database analyst performs a role similar to that of the database architect. • Sometimes the data administrator is referred to as the database analyst or perhaps as the data analyst • Data Modeler • A data modeler is usually responsible for a subset of the DA's responsibilities

  19. Application DBA • contrast to the system DBA is the application DBA. • The application DBA focuses on database design and the ongoing support • administration of databases for a specific application or applications. • The application DBA is likely to be an expert at writing and debugging complex SQL

  20. Task-Oriented DBA • quite rare outside of very large IT shops. • One example of a task-oriented DBA is a backup-and-recovery DBA who devotes his entire day to ensuring the recoverability of the organization's databases. • The performance analyst is usually the most skilled, senior member of the DBA staff.

  21. Data Warehouse Administrator • DBAs specifically to monitor and support the data warehouse environmen

  22. Tugas • Cari definisi dan perbedaan setiap DBMS terkait • Vendor pembuat • Kelebihan dan kekurangan • Contoh penerapan • Cari sertifikasi apa saja yang berkaitan dengan seorang DBA lengkap dengan penjelasannya

More Related