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