Common use of The Data Layer Clause in Contracts

The Data Layer. The data layer shall use an industry-proven and industry-standard relational database management system (“RDBMS”) based on the Microsoft SQL RDBMS in conformance with American National Standards Institute (“ANSI”) SQL standards. This layer is broken into following four primary database components: (a) The first component shall be a fully normalized database of record with a design based on industry-standard entity relationship models; (b) The second component shall be a denormalized database optimized for performance. The Contractor represents that it’s experience has shown that many DMV customers desire this feature to reduce latency and improve CIVLS performance required in the high-transaction volume operational environments CIVLS must support; (c) The third component includes a reporting database and business intelligence capabilities as described in Attachment 8 hereto. Contractor may also include a data warehouse containing relevant information from both CIVLS and third-party and external systems optimized for reporting. The data structures in the data warehouse will be designed to optimize aggregating factors by drill-down dimensions, such as time or location, and combine relationships across multiple data sources to support drill-down and ad-hoc reporting; and, (d) The fourth database component shall include an imaging repository that is integrated with CIVLS and includes a metadata structure optimized for search and retrieval functions.