Information wrt DBMSs (Information Technology)

Matt Chapman - Free Our Info, NFP filed this request with the Information Technology of Houston, TX.
Est. Completion None
Status
Fix Required

Communications

From: Matt Chapman - Free Our Info, NFP

To Whom It May Concern:

Pursuant to the Texas Public Information 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, as the statute requires.

With gratitude,
Matt Chapman,
Free Our Info, NFP

From: Information Technology

Good afternoon-

This wasn't sent directly to me, but I have had a chance to review your request. Please see below clarifications in red needed to move forward with this request.

Define DMMs.

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: I can only address Houston IT services and no other departments throughout the City of Houston. Please contact those departments for their information.

-Underlying engine (eg, postgres, mysql, mariadb, cockroachdb, Mongodb, Oracle database, sybase, MSAccess, SQL Server, VoltDB, RethinkDB, Chronos, Elasticsearch, etcd, cassandra, etc)
What does the statement "Underlying Engine" mean? Please state what you want specifically.
-Names of software that connect to each DBMS
-Names of departments that use information within the DBMS
I can only speak to this department. Please reach out to the other departments for requests regarding information connected to their departments.
-Schema of database (preferably, with granularity down to column names)
Please clarify exactly what you are asking that we provide. Define Schema.
-Contract identifier for each database, if relevant
I'm not aware of what database you are referring to, what type of databases you are referring to, or if they exist. Please clarify exactly what you are asking that we provide. Define or explain what you mean by contract Identifier.

Thank you,

Jamil Whalen, CTCM
Contract Manager - Senior Contract Administrator
Public Information Officer (PIO)
Houston IT Services
[cid:image001.jpg@01CC4315.498B6C70]611 Walker Street 8th Floor
Houston, TX 77002
832-393-0220
Jamil.whalen@houstontx.gov<mailto:Jamil.whalen@houstontx.gov>

Files