FOIA - COPA - DBMS Information

J Ader filed this request with the Chicago Office Of Police Accountability of Chicago, IL.
Tracking #




From: J Ader

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.


J Ader

From: Chicago Office Of Police Accountability

Good afternoon,

Attached is COPA's response to your FOIA request received in our office on August 15, 2018.

Thank you.

This e-mail, and any attachments thereto, is intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information. If you are not the intended recipient of this e-mail (or the person responsible for delivering this document to the intended recipient), you are hereby notified that any dissemination, distribution, printing or copying of this e-mail, and any attachment thereto, is strictly prohibited. If you have received this e-mail in error, please respond to the individual sending the message, and permanently delete the original and any copy of any e-mail and printout thereof.