Many agencies have major systems storing data in non-relational database systems such as Adabas, VSAM and Proprietary databases.
Many agencies have major systems storing data in relational database systems such as SQL Server, Oracle, DB2 and others.
Many agencies have major systems storing data in relational and non-relational database systems.
Some agencies have databases that are proprietary and interrelated to applications. To eliminate the database the application would need to be rewritten.
Some databases are administered by ITD and some databases are administered by an agency or contracted out by an agency.
Databases are housed at multiple locations.
All data is stored in relational databases supported across the enterprise with migration away from Adabas, VSAM and Proprietary databases.
Define a statewide standard for large, medium, and small databases.
Establish departmental implementation teams for system migration. Teams would take inventory of existing database systems, gather any known costs/resources, conduct risk analysis, and recommend implementations.
2. Data Dictionary
Some agencies have their own custom built data dictionaries. Some data standards are required from external entities.
Administered data dictionary repository defining common data elements and structures throughout the enterprise. Agency personnel can request changes and additions. All new development and migrations will incorporate data dictionary repository standards.
Gather requirements for statewide dictionary
Evaluate vendor products to determine if an administration toolset is necessary or if documentation will do the job
Provide recommendations on how to implement a statewide Data Dictionary
Define role of the Data Dictionary administrator(s)
Define how developers will interact with the Data Dictionary
Define statewide standards and procedures requiring use of the Data Dictionary
Decide where the Data Dictionary will reside
3. Statewide Data Warehouse
Some agencies have or are working on building data-warehouses and data-marts.
A statewide data warehouse administered by a central agency.
Warehouse Administrators will meet with agencies to identify data that is appropriate for sharing via the warehouse. Warehouse Administrators will develop migration schedules and methods. They will also publish information on what is available in the warehouse and how the data can be used.
The data in the warehouse will be utilized by state agencies and the general public.
Work with agencies to identify data that is appropriate for sharing via the warehouse
Evaluate vendor products and select a toolset for statewide warehouse administration
Evaluate and make recommendations on Analytical tools
Recommendation on how to implement a statewide Data Warehouse
Define role of Data Warehouse administrators
Publish information on what is available in the warehouse and how the data can be used
Develop migration schedules and methods
Define statewide standards and procedures for Data Warehouse usage
Decide where the Data Warehouse will reside
4. Statewide Customer Database
The same customer information is stored on multiple state databases.
Some agencies are currently working to consolidate demographic data from several of their own databases.
Some agencies have consolidated their customer demographic data into one database.
Some agencies maintain many addresses for a customer.
A statewide customer database accessible to all agencies that need to access and maintain customer demographic information. Customers would be able to notify the state once and all agencies would be notified of the change. Customers are defined as individuals or businesses doing business with any state agency.
Conduct a survey to identify agency interest and commitment.
Do feasibility study based on survey response. Feasibility study would provide a cost benefit analysis, identify security requirements, and define a project plan.
5. Database Redundancy
Some agencies are working on database redundancy implementation.
Some agencies have implemented database redundancy through mirroring server disk drives.
Database management systems are implemented to provide no downtime.
Define statewide standards and procedures based on the Governor's Continuum of Government (COG) Plan.
The Records Management Program is responsible for the preservation of state records. This includes determining retention periods, selecting the appropriate retention medium, choosing the best retention location, and selecting the best filing system for the records.