Database Administrator (DBA) The Database Administrator is a man in charge of the • Installation • Configuration • Upgradation • Administration • Monitoring and upkeep of databases Essential Roles: 1. Database plan 2. Database openness 3. Performance issues 4. Capacity issues 5. Data Replication 6. Table upkeep DBA Functional Organization: 1. Planning 2. Design a) Conceptual b) Logical 3. Implementation a) Physical b) Testing 4. Operations 5. Training DBA Tasks: 1. Database plan 2. Performance checking and tuning 3. Database accessibility 4. Security 5. Backup and Recovery 6. Data Integrity 7. Release Migration Information Warehouse Administrator Information stockroom: • It is a remain solitary store of data, coordinated from a few, conceivably heterogeneous operational databases. • It is a procedure, not an item. Information stockroom manager parts: • New part, accompanying the development in information stockrooms • Similar to DBA/DA parts • Specific parts: 1) Support DSS applications 2) Manage information stockroom development 3) Establish administration level assentions with respect to information distribution centers and information stores • Tasks: 1) Involved in KPI (Key, Performance, Indicator) ? The KPI has a) Measure b) Innovate c) Propagate d) Strategize Correlation between DBA && DWA Characteristics Data Warehouse Database Workload Designed to oblige impromptu inquiries. You may not know the workload of your information distribution center ahead of time, so it ought to be advanced to perform well for a wide assortment of conceivable queries. Supports just predefined operations. Your applications may be particularly tuned or intended to help just these operations. Information modifications Updated all the time by the ETL procedure utilizing mass information adjustment methods. End clients of an information distribution center don’t straightforwardly refresh the database. Subject to individual DML articulations routinely issued by end clients. The OLTP database is dependably exceptional and mirrors the present condition of every business exchange. Construction design Uses de-standardized or mostly de-standardized mappings, (for example, a star pattern) to upgrade inquiry performance. Uses completely standardized blueprints to enhance DML execution and to ensure information consistency. Run of the mill operations A run of the mill question checks thousands or a great many columns. For instance, a client may ask for the aggregate deals for all clients last month. A run of the mill operation gets to just a modest bunch of records. For instance, a client may recover the present request for a solitary client. Recorded data Stores numerous months or years of information to help authentic analysis. Stores information from just half a month or months. Verifiable information held as expected to meet the necessities of the present exchange.