Information wrt DBMSs (Information Technology)

Matt Chapman filed this request with the Information Technology of Oklahoma City, OK.
Tracking #

730237201837
Multi Request Information wrt DBMSs
Submitted July 18, 2018
Est. Completion None
Status
No Responsive Documents

Communications

From: Matt Chapman

Subject: Oklahoma Open Records Act Request: Information wrt DBMSs (Information Technology)

Portal

To Whom It May Concern:

Pursuant to the Oklahoma Open Records Act, I hereby request the following records:

For all DBMSs owned, maintained, operated, contracted with/through, or supported by the Information Technology - or similar - department(s) within your city, please provide me with the following information:

-Underlying engine (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)
-Contract identifier for each database, if relevant

I understand that the information respondent to this request may require the creation of new documents - if that will be the case, then please provide me with documents that may contain the information (eg, documentation, contracts, etc). I am also happy to narrow the scope of my request if necessary.

Please also let me know if any help is needed with discovering any DBMS services. My background is in distributed systems systems administration and I can offer technical tips or advice if it would be helpful in any way.

The requested documents will be made available to the general public, and this request is not being made for commercial purposes. As I believe the information respondent to this request outweighs the costs and burden, I would like to kindly request a fee waiver.

I look forward to receiving your response to this request within 10 business days.

With gratitude,
Matt Chapman,
Free Our Info, NFP

From: Information Technology

Subject: Open Records Request Receipt

Portal

Open Records Request Receipt The City of Oklahoma City Open Records Request Receipt

Thank you for your open records request. Below are the details of your request.
City of Oklahoma City City Clerk
200 N Walker Ave
Oklahoma City, OK
405-297-2391
Please retain this receipt as your proof of your request.
Please note that it may take up to 7 business days for your request to be processed Receipt Number 730237201837
Receipt Date 7/23/2018 9:37:27 AM

CONFIDENTIALITY NOTE: This e-mail message and any attachments are intended solely for the person to which it is addressed and may contain privileged and confidential information protected by law. If you have received this communication in error, please notify the sender immediately by telephone or e-mail, destroy this message and delete any copies held in your electronic files. Unauthorized use and/or re-disclosure may subject you to penalties under applicable state and federal laws.

From: Information Technology

Subject: Oklahoma Open Records Request: Information wrt DBMSs (Information Technology, Oklahoma City, Oklahoma)

Portal

Mr. Chapman,

The City of Oklahoma City is in receipt of your recent Open Records request. We do not maintain a list containing all of the "underlying engine eg, postgres, mysql, mariadb, cockroachdb, Mongodb, Oracle database, sybase, MSAccess, SQL Server, VoltDB, RethinkDB, Chronos, Elasticsearch, etcd, cassandra, etc", "(n)ames of software that connect to each DBMS", or "(n)ames of departments that use information within the DBMS." Therefore, there are no records responsive to your request. You have also requested "(s)chema of database preferably, with granularity down to column names." Not all of this information will be subject to disclosure under the Oklahoma Open Records Act. Accordingly, for the City to proceed with this request, it will be necessary for a City employee to review and redact information from each schema, as appropriate. Because of the excessive disruption that fulfilling this request will cause, the City will charge $7.25 per quarter hour. If you still wish to receive this information, please notify us and we will provide you with an estimate of the total cost before we proceed. You have also asked for the "contract identifier for each database, if relevant." Please clarify what documentation you are seeking, so that we may attempt to fulfill the request. Similarly, you have requested "documents that may contain the information eg, documentation, contracts, etc." Please clarify what documentation you are seeking, so that we may attempt to fulfill the request.

Thank you.

Laura K. McDevitt
Assistant Municipal Counselor
City of Oklahoma City
200 N. Walker Ave. Ste. 400
Oklahoma City, OK 73102
CONFIDENTIALITY NOTE: This e-mail message and any attachments are intended solely for the person to which it is addressed and may contain privileged and confidential information protected by law. If you have received this communication in error, please notify the sender immediately by telephone or e-mail, destroy this message and delete any copies held in your electronic files. Unauthorized use and/or re-disclosure may subject you to penalties under applicable state and federal laws.

Files

There are no files associated with this request.