database administrator
DESCRIPTION
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. - PowerPoint PPT PresentationTRANSCRIPT
DATABASE ADMINISTRATORDATABASE ADMINISTRATORPertemuan ke-1
Database-DBMS-Database Administrator
INTRODUCTION
Sekumpulan data yang
saling berhubungan
Sekumpulan data yang
saling berhubungan
DDATABASE
perangkat lunak perangkat lunak yang mengaturmengatur dan mengorganisasimengorganisasi penyimpanan database
kedalam komputer
RDBMS
RDRDBMSBMS
EMPLOYEE_ID
LAST_NAME
FIRST_NAME
SALARY COMMISION_PCT
DEPARTMENT_ID
BARIS
KOLOMPK FK
FIELD
NULL
SSTRUKTUR PPENYIMPANAN
Emp_Id Last_Name First_Name Dept_Id
HHOW THE DDATA IS OORGANIZED
Dept_Id Dept_Name
Employees Departments
Primary Key
Foreign Key
RDRDBMS MBMS MARKET s sHARE
CCOMPUTER & CCAREER OOPPORTUNITY
DDATABASE AADMINISTRATOR
Orang yang memastikan fungsi operasional aplikasi dan database organisasi dapat berjalan secara efisien
MMANAGEMENT DDISCIPLINE OF DBADBA
A good DBA is integral to the entire application development A good DBA is integral to the entire application development life cycle. life cycle.
DDATA, DDATABASE, AND SSYSTEM
AADMINISTRATOR
DDATA, DDATABASE, AND SSYSTEM
AADMINISTRATOR
IT InfrastructureIT InfrastructureSystem Administrator
DBA (if no SA)
Data and Metadata PolicyData and Metadata Policy Data Administrator
Database Administrator (if no DA)AnalysisAnalysis
DesignDesignDatabase Administrator
DevelopmentDevelopment
TestingTesting
Implementation (database, application)Implementation (database, application)
Maintenance & TuningMaintenance & Tuning
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
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.
TTASKS OF DBADBA
TTASKS OF DBA: D DATABASE D 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.
TType 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.
• 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
• 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
• 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.
• Data Warehouse Administrator – DBAs specifically to monitor and support the data
warehouse environmen
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