Database Reference
In-Depth Information
The DBA may sit in on the planning meetings as a technical advisor, but it is too
early to define the needed DBMS features. In the feasibility study phase, the DBA
assists in determining upgrades to the current infrastructure and calculation of costs.
DA
Understand business goals and objectives.
DA
Interpret organization's business plan for information requirements.
DA
Assess business opportunities and risks.
DA
Classify user groups for determination of data needs.
DA
Gauge user expectations.
DA
Determine data ownership issues.
DA
Develop enterprise information strategy and overall database
environment.
DA/DBA
Make preliminary estimate of data volumes.
DBA
Assess the readiness of technological infrastructure and estimate
costs for upgrade.
DA/DBA
Do preliminary skills review and estimate costs for training and
additional personnel.
DBA
Establish criteria for DBMS selection.
DA
Match benefits against costs and prepare justification for database
system.
Requirements Definition
The DA takes more active responsibilities in the requirements definition phase. The
DBA's role in this phase is to be available as a technical advisor and database expert.
DA
Provide insight into overall business operations to analysts.
DA
Consolidate and integrate information requirements.
DA
Establish clear data definitions.
DA
Express business rules.
DA
Establish constraints and rules to validate data.
DA/DBA
Prepare data dictionary entries for data elements.
DA
Ascertain data usage patterns and access frequencies.
DA
Prepare list of users to be authorized and their data access
requirements.
DA
Liaise with users to provide operational documents to analysts.
DBA
Provide layouts of current data files for analysts.
DA/DBA
Determine file conversions to switch over to new database system.
DBA
Estimate hardware storage space requirements.
Logical Design
The data modelers and database designers are active in this phase. They perform
almost all the tasks of modeling and logical design. The DA assumes the role of a
Search WWH ::
Custom Search