Unimark EC3000 Series Especificaciones descargar pdf (Pagina 170)

AIMS Attachment A: AIMS Statement of Work

Page 110 of 130

requested by the County. The database(s) shall be designed such that

the addition of fields and/or tables is easily accommodated. The

database schema shall be provided in a chart format showing all

tables, key fields, and hierarchical relationships.

7. SQL: The utilized native structured programming language shall be

storable in the database. The database shall employ a native

structured programming language that can utilize standard Structured

Query Language (SQL) which includes the following:

i Data Definition Language (DDL) statements

ii Data Manipulation Language (DML) statements

iii Transaction control statements

iv Session control statements

v System control statements

vi Embedded SQL statements

8. Database Maintenance: The database maintenance system shall be

capable of maintaining configuration control (i.e., keep track of

changes and compare versions of the database). Database

maintenance software shall be provided to allow modification of

designated database fields. Database documentation shall be

provided to enable the updating or regeneration of the database tables

when inputs are changed and added and as programs are modified or

added.

9. Archival Viewing: The database shall provide an archive capability

that provides “near time” retrieval of archived data. The data held

within the “operational” portion of the database shall include a

minimum of 7 calendar days of operational data. The CONTRACTOR

shall propose, and submit for approval, the maximum amount of

operational data to be stored for real time access that will not impact

the efficiency of the database. In addition to real-time (daily)

operational data, the database shall provide the ability to generate

real-time reports for operational data for a minimum of thirty-six (36)

months.

10. The database shall include the functionality and capability to allow the

authorized user to view or report on historical data. If the user wishes

to view or report on data which has been archived, an automated

mechanism shall be provided to have the requested data put online.

The methodology for providing this functionality must be approved by

the County prior to implementation.

Exhibit 3

Page 170 of 278

1 2 ... 165 166 167 168 169 170 171 172 173 174 175 ... 277 278

Sin comentarios

Unimark EC3000 Series Especificaciones Pagina 170