|
What is Data Base Management?
Need
to manage
data base management and want practical standards and best practices for
information management governance and accountability?
Data
management is a sub-set of information management that
governs
organization and control of the structure and design, storage,
movement, security and quality of information.
What
is Data
Storage?
The
data storage discipline focuses on the management of persistent data
stores throughout the organization. It covers such topics as data
base selection guidelines, backup & recovery procedures,
data
retention/archiving policies, and disaster recovery planning.
What are
typical data base environments?
- Personal
schemas are created for individual developers who use
their personal
schema’s to develop and unit test individual code before moving to
system testing in the development environment;
- Development
environments are sometimes called a system test
environment
and are used to system test several code components before they are
moved to the integration test environment;
- Integration
test environment is
used by the integration
test
team. Integration testing is designed to ensure that
all
software performs to specification before it is moved into the quality
assurance test environment;
- Quality assurance (QA) environment is
used by an independent QA team to
ensure that the
application meets specified requirements. Some
form of version control
mechanism should control all objects that are migrated to this
environment;
- User
acceptance test environment
is sometimes created
for use by end users so they can test that the application meets
expectations;
- Production
environment
contains all
production data. Changes to this environment should only occur after
all stakeholders have signed-off on all testing;
- Production
support (DEV/Test) environment is used by the production
support team to fix and test any
production issues before moving them into production. It
is sometimes used to test new releases of operating system software or
”patches” before moving them into the production environment; and
- Operational readiness environment is
used to test the operational readiness of new
application software before it moves into production. Information
management solutions
frequently use the user acceptance
test environment for operational readiness since the primary “user” is
the
operational support team.
What
other data base management environment are required?
Depending
upon specific installations,
there may also be other supporting data base environments such as:
- Data model repositories;
- Data movement code repositories;
- Metadata repositories;
- Business intelligence code
repositories; and
- Configuration management data bases
What standards and best practices are required?
Summary...
Data base management is a sub-set of
information management that governs
organization and control of the structure and design, storage,
movement, security and quality of information.
Best practices are
required to ensure rapid project delivery and optimal return
on information management investment
|
