8-Appendix I – Data Management Strategy.pdf

Appendix I – Data Management Strategy

Data Management Strategy

The City requires access to its data whether stored on site, in a hosted or cloud-based solution or maintained by a third party. To this end, the City requires compliance with data management standards and requirements to facilitate continued cost-effective access to all forms of City data.

Data Management Standard Framework:

The City has adopted the Data Management Association’s Guide to Data Management Body of Knowledge (DMBOK) as its data management framework.

Data Governance

Data Governance aspects for all data managed on-site or off-site must minimally include consideration for:

Data Operations including backup, recovery, monitoring, performance, disaster recovery, and business continuity as related to database activity.

Data Security including access control, encryption as required, data upload, data download, Health Insurance Portability and Access Act (HIPAA), Personally Identifiable Information (PII), Criminal Justice Information Service (CJIS), and other possible administrative or legal requirements

Data Quality including use of City Geo verification, City GIS districts, use of City Shape files, and overall data consistency and integrity

Data Master includes use of standard look up data Data Meta includes a Data Dictionary, an Entity Relation Diagram, and relevant data descriptions Data Availability including data reporting, extraction, inspection, review, migration, end of contract data resolution, and identification and agreement regarding the final disposition of City data at the end of contract.

Data Architecture

Database Management Systems

The City requires, where needed, that the Proposer provide an industry standard Relational Database Management System that meets the needs of all other requirements within this document. These include but are not limited to:

Security Data Integrity Backup and recovery ability to meet provided requirements for Service Level Agreement

(SLA) and Disaster Recovery Backup and Recovery to within SLA for data incidents where data recovery is required Performance characteristics to meet the required application SLAs as provided The ability to provide scheduled and ad hoc data extract requests

The ability, if requested, to provide a periodically updated full copy of the database solution for storage and full data access at a location of the City’s choosing

The data should be available at the end of the contract period as an industry standard supported backup file type to allow the City to recover the data on a City location and have full access and use of the data within the database system.

The City understands that there is a multiplicity of database types now available that are not considered to be standard Relational Database Management Systems. These Not or Not Only Structured Query Language (“NoSQL”) or non-relational systems may be presented as part of the proposal where their function is required to provide the required City service.

The City requires Proposers to provide:

An Entity Relationship Diagram (ERD) A Data Dictionary including table name, column name, data type, length, any constraints, default values, primary key/foreign key (to what tables and columns), how used in support of the solution.

Depending on data access parameters, other database technology solutions may be considered, if City data is accessible to its employees and delegates.

Appendix J - Enterprise Standards for Information Systems and Infrastructure

Enterprise Standards for Information Systems and Infrastructure

The following standards have been identified as necessary elements of any Networking and Infrastructure Framework and Program and as such are designated as appropriate standards for use at the City.

Cellular Communications

3GPP (3rd Generation Partnership Project) – LTE: Long Term Evolution – Wireless Mobility 3GPP (3rd Generation Partnership Project) – LTE Adv: Long Term Evolution Advanced –

Wireless Mobility NGMNA (Next Generation Mobile Networks Alliance) – 5G: 5th Generation Wireless

Mobile Network – Wireless Mobility

Institute of Electrical and Electronic Engineers (IEEE®) Communications Standards

IEEE 802.3 Series – Ethernet Standards IEEE 802.11 Series – Wireless networking standards – Wireless Data; including IEEE 802.11s – Wireless Mesh IEEE 802.15 Series – Bluetooth – Personal Area Networks

International Telecommunication Union (ITU) Standards for Wave Division Multiplexing (WDM) Optical Carrier Multiplexing (ITU spacing standards)

ITU-T G.694.1: "Spectral grids for Wavelength-Division Multiplexing (WDM) applications:

Dense Wavelength-Division Multiplexing (DWDM) frequency grid" ITU-T G.694.2: "WDM applications: Coarse Wavelength-Division Multiplexing (CWDM) wavelength grid ITU-T G.651: “Characteristics of 50/125 μm Multimode Graded-index Optical Fiber” ITU-T G.652: "Transmission media and optical systems characteristics – Optical fiber cables” ITU-T G.653: “Characteristics of Single-mode Dispersion Shifted Optical Fiber and Cable” ITU-T G.654: “Characteristics of Cut-off Shifted Single-mode Optical Fiber and Cable” ITU-T G.655: “Characteristics of Non-zero Dispersion Shifted Single-mode Optical Fiber and Cable” ITU-T G.656: “Characteristics of Non-zero Dispersion Shifted Fiber for Wideband

Transport” ITU-T G.657: “Characteristics of a Bending Loss Insensitive Single-mode Fiber for Access

Networks”

Internet Engineering Task Force (IETF) and International Organization for Standardization (ISO®) Routing Protocols

RFC 2328 Open Shortest Path First (OSPF Version 2 – applies to IPv4) RFC 5340 Open Shortest Path First (OSPF Version 3 – applies to IPv6) RFC 2453 RIP Version 2 (RIPv2) RFC 7868 Cisco's Enhanced Interior Gateway Routing Protocol (EIGRP) ISO/IEC 10589:2002 Intermediate System to Intermediate System (IS-IS)

Internet Engineering Task Force (IETF) Request for Comments (RFC)

RFC 1883 – The Internet Protocol version 6 Specification RFC 791 – Internet Protocol version 4 Specification