Data Warehouse is Transaction-Oriented?

1

Problem Context

Reading the Data Warehouse issue, I drew some distinct conclusions about what the textbook states.

  

Notice what the author explains in relation to transaction-oriented DW:

     

IunderstandthattheauthorstatesthatDWaretransactionoriented.

  

Nowseewhatitsaysinthefollowingparagraph:

    

Soon after, he says that DW are not transaction-oriented , which left me a bit confused since he is denying it.

My Understandings

  • When I read about it I understood that DWs are decision support tools that are query-oriented .

  • I understand that because they are focused on queries, bank might not respect the well-known normal forms (1FN, 2FN, 3FN) as they increase the amount of relationships and decrease the chance of duplication.

  • The fact is that the relationship in the bank affects the performance of queries because of the various'JOIN 'that are constantly being performed. >

  • DW is often very large since it serves as the central repository for all other databases.

  • Transactional database (Conventional) are concerned with non-duplication of record, so they tend to respect normal forms. These can be called transaction-oriented banks .

  • The data stored in DW has a NOT volatile characteristic, meaning that in the loading step, the data is filtered and cleaned, after this step the data only > suffer transactions from queries and exclusions , sem que possam ser alterados , this feature represents non-volatility .

    >

    Doubt

    Are my understandings correct? Does the community agree in whole or in part with the statements listed above?

      

    Remembering that the main focus of the question is in the title, ie can I really consider that the DW are query-oriented?

    Source: Database Systems 6th edition, authors: Elmasri, Ramez Navathe, Shamkant B. Year: 2011 Cap 29, pg 720

        
    asked by anonymous 09.11.2017 / 17:47

    1 answer

    0

    I found the first fragment to be somewhat short, it is worth remembering another important characteristic of DW that the data practically do not suffer (nor should) changes to not interfere in the result of the analysis and new registrations are added periodically via batch (ETL). >

    Transactions are mostly used in writing operations where it is important to successfully complete all changes or cancel all and return to the previous (valid) state.

        
    09.11.2017 / 17:59