Chap 2.1 Exploring data-driven solutions

Components across systems

A data driven solution contains:

  • Application and interfacing components

  • Data storage and management components

  • Underlying support components (operating systems, firmware, hardware)

Applications, presentation and interactions

  • Algorithmic, presentation and interactive components are primarily concerned with the user interface or front end, input and outputs, and with the processing of any data

  • Algorithmic coded solutions and interfaces cater to the requirements of problems

  • API → application programming interface

Data management and storage

Flat files as databases

Relational databases

    Keys

    Uniqueness constraints

        One-to-one relationship

        One-to-many relationship

        Many-to-many relationship

    Database field data types

        Integer

        Float

        Date and time

        Boolean

        Characters and strings

    PostgreSQL database management system data types