Information wrt DBMSs (Department of Information Technology)

Matt Chapman - Free Our Info, NFP filed this request with the Department of Information Technology of Seattle, WA.
Tracking #

C030407-072218

Multi Request Information wrt DBMSs
Due Aug. 28, 2018
Est. Completion None
Status
Awaiting Response

Communications

From: Matt Chapman - Free Our Info, NFP

To Whom It May Concern:

Pursuant to the Washington Public 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 5 business days, as the statute requires.

With gratitude,
Matt Chapman,
Free Our Info, NFP

From: Department of Information Technology

--- Please respond above this line ---
07/27/2018
Dear Matt Chapman, This acknowledges receipt of your public disclosure request C030407-072218 received on July 22, 2018 regarding:
Sincerely, *ITD *PDR
To monitor the progress, update this request, make payments and download your responsive records please log into the
Public Records Request Center. (http://www.seattle.gov/public-records/public-records-request-center)

From: Department of Information Technology

--- Please respond above this line ---
07/27/2018
Dear Matt Chapman, This acknowledges receipt of your public disclosure request C030407-072218 received on July 22, 2018 regarding: Sincerely, *ITD *PDR
To monitor the progress, update this request, make payments and download your responsive records please log into the
Public Records Request Center. (http://www.seattle.gov/public-records/public-records-request-center)

From: Department of Information Technology

--- Please respond above this line ---
Dear Mr. Chapman:  Regarding your July 22, 2018request: Forall DBMSs owned, maintained, operated, contracted with/through, or supported bythe Information Technology - or similar - department(s) within your city, pleaseprovide me with the following information: -Underlying engine (eg, postgres,mysql, mariadb, cockroachdb, Mongodb, Oracle database, sybase, MSAccess, SQLServer, VoltDB, RethinkDB, Chronos, Elasticsearch, etcd, cassandra, etc) -Namesof software that connect to each DBMS -Names of departments that useinformation within the DBMS -Schema of database (preferably, with granularitydown to column names) -Contract identifier for each database, if relevant Iunderstand that the information respondent to this request may require thecreation of new documents - if that will be the case, then please provide mewith documents that may contain the information (eg, documentation, contracts,etc). I am also happy to narrow the scope of my request if necessary. As you may have guessed, this is a very large and complexrequest, and will take some time to produce.  I met with some departmentmembers, responsible for helping to pull this information together and severalquestions came up.  It would be helpful to get further clarificationbefore we proceed.  Here are some questions the group had: Are you requestingproduction vs. non-production databases? On premise only? No imbeddedsystems?  What do you mean by contract identifier?  Once we get yourclarification, we will be better able to give you a time estimate.  If we do not hear from you within 30 days, the City will consider your request closed.  Thankyou. Sincerely, Kristen Glundberg-Prossor Seattle Information Technology Public Disclosure
To monitor the progress, update this request, make payments and download your responsive records please log into the
Public Records Request Center. (http://www.seattle.gov/public-records/public-records-request-center)

From: Department of Information Technology

--- Please respond above this line ---
10/10/2018
Dear Mr. Chapman,
This email is in response to your public disclosure request C030407-072218 received on July 22, 2018 regarding the following:

It's come to my attention that it's been over 30 days and I hadn't heard back from you. Can you answer any of the clarifying questions in my last message? It would be super helpful so that we can move forward. Conversely is there any way that you could possibly narrow your request? Or, are you even still interested in this request? Let me know and many thanks.

Sincerely,
Kristen Glundberg-Prossor

PDO/Seattle IT

From: Matt Chapman - Free Our Info, NFP

Thank you for the followup and sorry it took so long to get back! Yes, I'm still interested in the records for this request.

Are you requesting production vs. non-production databases? Production only.
On premise only?
No imbedded systems? No need for imbedded systems.
What do you mean by contract identifier? This info can be dropped from the request.

Please let me know if there are any other questions. I realize that the information from this request might be a bit difficult to compile, but the information is incredibly valuable for understanding what sort of records exist for the use with future requests. For example, by knowing the names of columns exist in a table/database, that allows a requester to request only the information from those columns, where it would likely be a guessing game otherwise.

Thanks -
Matt Chapman

Files

There are no files associated with this request.