Metodologia de Desarrollo de Base de Datos

The Database Framework
Page 1 of 10

The Database Framework
Victoria E Holt
The database framework is a system to look holistically at the database from the design
structure of databases in particular consideration of their fallibility & reliability and the
retrievability of data from multiple sources. Figure 1 highlights my perception of the
database process in the real world.

Scope andunderstanding
Real world
problem
situation

Audience
users,
organisations,
administrators
Business need

Plantation

Fundamental Design
Knowledge management
Business Intelligence

Tree

DATA

Global
Linkage
Holistic views

Figure 1 The database process

Regulations
security
metadata
sharing data

Technological Mapping
Backup
Mission Critical
Disaster Recovery
Spatial Geographic
ITIL Service FrameworkAdministration
Product
Technological
Development
Needs of the
People

The Database Framework
Page 2 of 10

The aim is to produce a database systems methodology which will have examined
current methods and practice, after reflecting and iteration, and drawing from that a
conclusion on how best to deliver effective database systems. Figure 2 details the key
elements within this bounded system showingtheir interconnectedness.

Design Architecture,
requirement analysis, meta
data, sharing data definition,
modelling , access
Release
Management,
Change control
Development, coding
standards e.g XML

Security,
Regulation

Disaster
Recovery,
Backups,
Long term
Archiving,
Geographic
locations

Mission
Critical
24/7

Performance
Tuning,
Optimisation,
Benchmarking

Business Intelligence,
Reporting,Data Warehousing,
Data Mining

Best
Practice,
Service
Delivery,
ITIL

Housekeeping,
Data Quality
Assurance, Data
Governance

Data Administration,
Health Checks on
servers
Sharing
Data

Database Auditing,
Compliance

Documentation

Figure 2 The key element within the system of interest

The Database Framework
Page 3 of 10

As we see today a large number of data systems fail due to things such a poordesign
knowledge management and specification, storing of ill thought out metadata, not
considering the need for business intelligence, integration of systems data, mission
criticality, high availability, not applying the ITIL framework with things such as change
management, retention policy for backups, archiving of digital data and of course
human error. The speed of change within the databaseindustry provides endless more
possibilities for the usage of the database. A framework, methodology, needs to provide
an overview so that database systems work efficiently, effectively with little need for
administration, the self managing system.
A lightweight framework on how to do something rather than specifics of the tasks
technically needs to be identified. It should contain a model forinteraction with modules
which are flexible, extendable and reusable. It needs to be easy to configure and apply
with specific goals.
The core problem situation that is identified in the relevant system shows the
transformation process within the perceived system. A root definition of this relevant
system which has emerged as the primary task system.

Root Definition
A system to store, share,manipulate and analyze raw data to provide
meaningful data for today and the future , which is accessible to the
public for the benefit of an organization subject to budgetary,
government and technological constraints.
The formulation of this root definition contains the six CATWOE elements which help to
highlight the transformation process within the system and the weltanschauung or
worldview.

CATWOECustomers:
Actors:
Transformation

Weltanschauung:
Owner:

the public
the public, database administrators,
organizations administrators
the process of storing raw data to either return it
in its original form, to share or to aid in
prediction analysis
to contain a repository of data that is accessible
by the relevant groups of users
organizations, government

The Database Framework
Page 4 of 10...