Use of Relational Data Base Systems Policy
Date Issued (revised): December 9. 2019
Date Effective: immediately
Supersedes: Version 2.00 February 15, 2001
Changes: Eliminate all references to the Department of Information Technology (DOIT).
The Office of Policy and Management has established this policy and reporting requirements, and associated standards to achieve the strategic direction of the State of Connecticut on the global use of RDBMS technology in all mission critical and important data base types of business applications and systems by the agencies.
- All new mission critical or important Database Systems whether acquired, leased, outsourced or developed in-house, will conform to the strategic relational database standards and products as defined by the Domain Architecture Team(s) in the Data Management and Warehouse Domain Technical Architecture document.
- All new mission critical or important Database Systems whether acquired, leased, outsourced or developed in-house, will use industry-standard SQL as the query language and database table definition and manipulation;
- Whenever possible, Database System architectures and applications will be designed such that stored procedures and triggers are only used to support data integrity, referential integrity, replication, security and access rights; the procedures and triggers are NOT to be used to support business rules, application logic or workflow;
- State Agencies will incorporate appropriate compliance language in all contracts with vendors for the acquisition, leasing, outsourcing, development or modification of Information Technology Database Systems.
Agency Planning and Reporting Responsibilities
- Agencies will incorporate this policy into their information technology plans.
- Agencies will draft plans to replace non-relational database systems with RDBMS for mission critical and inter-agency applications.
Agencies shall prepare a brief report that indicates the steps taken to ensure that their Database Systems are compliant with these policies and their associated standards.
DAS-BEST will develop Agency reporting requirements for those agencies that are utilizing funds provided by DAS-BEST or OPM.
This policy applies to the following entities: any State of Connecticut agency, institution, office, department, commission, council or instrumentality that utilizes Information Technology Based Database Systems in the conduct of its business.
This policy applies to the following:
- all new mission critical or important Database Systems that are purchased, leased, developed or modified by a State Agency
- all new mission critical or important Database Systems developed or modified by an outside provider or consultant,
- all new mission critical or important Database Systems obtained through an outsourcing arrangement.
- all existing mission critical or important Database Systems that are modified or updated by a State Agency, vendor, contractor or other party to achieve compliance with the [State Standard for Relational Data Base Products] or these policy statements.
For the purposes of this policy, the term State Agency refers to any State of Connecticut agency, institution, office, department, commission, council or instrumentality.
For purposes of this policy, Database Systems shall be defined to include (but not be limited to) the following: relational model database management systems and applications including data repositories, database applications, and transaction processing solutions. Database Systems also refers to relational database management systems implemented or obtained by outsourced Information Technology solutions.