Database
Administrator (DBA)

The
Database Administrator is a man responsible for the 

We Will Write a Custom Essay Specifically
For You For Only $13.90/page!


order now

Ø  Installation 

Ø  Configuration 

Ø  Upgradation 

Ø  Administration 

Ø  Monitoring
and upkeep of databases 

 

Fundamental Roles: 

Ø  Database
arrangement 

Ø  Database
transparency 

Ø  Performance
issues 

Ø  Capacity
issues 

Ø  Data
Replication 

Ø  Table
upkeep 

DBA Functional
Organization: 

Ø  Planning

Ø  Design 

a)      Conceptual 

b)      Logical 

Ø  Implementation 

a)      Physical 

b)      Testing 

Ø  Operations 

Ø  Training 

 

DBA Tasks: 

Ø  Database
arrangement 

Ø  Performance
checking and tuning 

Ø  Database
openness 

Ø  Security 

Ø  Backup
and Recovery 

Ø  Data
Integrity 

Ø  Release
Migration 

Data
Warehouse Administrator

Data stockroom: 

Ø  It
is a stay lone store of information, facilitated from a couple, possibly
heterogeneous operational databases. 

Ø  It
is a strategy, not a thing. 

 

Data stockroom
administrator parts: 

Ø  New
part, going with the advancement in data stockrooms 

Ø  Like
DBA/DA parts 

Ø  Specific
parts: 

a)      Support
DSS applications 

b)      Manage
data stockroom advancement 

c)      Establish
organization level assertions regarding data circulation focuses and data
stores 

Ø  Tasks: 

a)      Involved
in KPI (Key, Performance, Indicator) 

The
KPI has 

a.       Measure 

b.      Innovate 

c.       Propagate 

d.      Strategize 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Connection
between DBA && DWA

Characteristics

Data Warehouse

Database

Workload

Designed to oblige request. You may not
know the workload of your data circulation focus early, so it should be
progressed to perform well for a wide arrangement of possible queries.

Supports just predefined operations.
Your applications might be especially tuned or expected to help only these
operations.

Data modifications

Updated all the time by the ETL
technique using mass data alteration strategies. End customers of a data
conveyance focus don’t direct invigorate the database.

Subject to individual DML enunciations
routinely issued by end customers. The OLTP database is constantly excellent
and mirrors the current state of each business trade.

Development design

Uses de-institutionalized or for the
most part de-institutionalized mappings, (for instance, a star design) to
update request performance.

Uses totally institutionalized outlines
to improve DML execution and to guarantee data consistency.

Common operations

A regular inquiry checks thousands or a
considerable number of sections. For example, a customer may request the
total arrangements for all customers last month.

An average operation gets to only an
unassuming pack of records. For example, a customer may recuperate the
present demand for a singular customer.

Recorded data

Stores various months or years of data
to help bona fide analysis.

Stores data from simply a large portion
of a month or months. Undeniable data held of course to meet the necessities
of the present trade.

 

 

x

Hi!
I'm Cody!

Would you like to get a custom essay? How about receiving a customized one?

Check it out