Contents tagged with ETL

  • Four classes of databases systems

    Hello everybody,

    I want to leave a short note on four types of database systems:

    OLTP

    DSA

    DW

    ETL

    Online transactional processing

    This type of systems is used for data entry, basically for CRUD operations. As usually some rules of normalization is applied there. Also OLTP is not suitable for reporting purposes because processing normalized data takes a lot of computing powers. That's why next type of systems is used:

    Data warehouses

    This kind of systems is used for data-retrieval and reporting purposes. Mainly it's structure is optimized for data-retrieval needs. Quite often tables have redundancy, fewer tables, simpler relationship between tables. You can learn a bit more about … more