logo for information-management-architect.com
leftimage for information-management-architect.com

Data File Management

Need to define business intelligence data file management standards and want practical standards and best practices for information management and data governance?

Data management is a sub-set of information management thatEnterprise Information Architecture 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 database selection guidelines, backup & recovery procedures, data retention/archiving policies, and disaster recovery planning.


Data file management checklist

The following should be addressed in data storage standards and best practices.
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 database data file management environment are required?

Depending upon specific installations, there may also be other supporting database environments such as:
Data model repositories;
Data movement code repositories;
Metadata repositories;
Business intelligence code repositories; and
Configuration management databases
What other standards and best practices are required?

Data storage standards and best practices should allow address the following
Data warehouse architecture
Enterprise data warehouse solutions
Warehouse data management
Database normalization
Estimating building a data warehouse
Estimates for creating data warehouse
Data storage warehouse
Enterprise information architecture
Data storage strategy
Enterprise data warehouse
Enterprise architecture tools
Operational data store
Data management software
Database and data warehouse
Database management system
Database software
Database schema
Database partitioning
Databases and data warehouses
Enterprise architecture
Data management information
Data compression
Enterprise business intelligence solutions
Relational database
Data backup storage
Enterprise information management
Data mart
Data warehouse systems
Database design
Database management
Enterprise architecture planning
Information architecture
Software architecture
Offsite data storage
Data management
System architecture
Information management technology
Information management tool
Data base management
Data management tools
Database development
Storage systems
Information management tools
Database servers
Data management solutions
Database architecture
Data warehouse architecture
Enterprise data warehouse solutions
Warehouse data management
Database normalization
Estimating building a data warehouse
Estimates for creating data warehouse
Data storage warehouse
Enterprise information architecture
Data storage strategy
Enterprise data warehouse
Enterprise architecture tools
Operational data store
Data management software
Database and data warehouse
Database management system
Database software
Database schema
Database partitioning
Databases and data warehouses
Enterprise architecture
Data management information
Data compression
Enterprise business intelligence solutions
Relational database
Data backup storage
Enterprise information management
Data mart
Data warehouse systems
Database design
Database management
Enterprise architecture planning
Information architecture
Software architecture
Offsite data storage
Data management
System architecture
Information management technology
Information management tool
Data base management
Data management tools
Database development
Storage systems
Information management tools
Database servers
Data management solutions
Database architecture

Summary...


Data file management  is a key component of enterprise business intelligence.

Standards and best practices are required to ensure rapid project delivery and optimal return on information management investment


footer for Information management page