FOIA - COPA - DBMS Information

To Whom It May Concern:

Pursuant to the Illinois Freedom of Information Act., I hereby request the following records:

For all Database Management Systems (DBMS) owned, maintained, operated, contracted with/through, or supported by the Chicago Office of Police Accountability, please provide me with the following information:

- Name(s) of the underlying engine(s) being used (eg, postgres, mysql, mariadb, cockroachdb, Mongodb, Oracle database, sybase, MSAccess, SQL Server, VoltDB, RethinkDB, Chronos, Elasticsearch, etcd, cassandra, etc)
- Names of software that connect to each DBMS
- Names of departments that use information within the DBMS
- Schema of database (preferably, with granularity down to column names - please also provide this data as machine readable, for example, within a .csv)
- Contract identifier for each database, if relevant

The requested documents will be made available to the general public, and this request is not being made for commercial purposes.

In the event that there are fees, I would be grateful if you would inform me of the total charges in advance of fulfilling my request. I would prefer the request filled electronically, by e-mail attachment if available or CD-ROM if not.

Thank you in advance for your anticipated cooperation in this matter. I look forward to receiving your response to this request within 5 business days, as the statute requires.

Sincerely,

J Ader