ITELEC2

このルーレットの内容（28 項目）

This works as central repository ------------------------------------- ( Data Warehouse )
It stores historical data ------------------------------------- ( data warehouse )
Give the 3 datas that stored in data warehouse ------------------------------------- ( Structured Data, Unstructured Data, Semi-Structured Data )
Data that is easiest to search and organized, because it is usually contained in rows and columns ------------------------------------- ( Structured Data )
Is a data that connot be contained in row/Column ------------------------------------- ( Unstructured Data )
Mix between Both of Structured and Semi-Structured ------------------------------------- ( Semi-Structured )
Darthmouth and General Mills in a joint research project, develop the terms dimensional and facts ------------------------------------- ( 1960 )
Nielsen and Iri introduces dinemsional data marts for retail sales ------------------------------------- ( 1970 )
Tera Data Corporation introduces a data management system which is specifically designed for decision support ------------------------------------- ( 1983 )
When was data warehousing started ------------------------------------- ( Late 1980's )
Types of Data Warehouse ------------------------------------- ( Enterprise Data Warehouse, Operational Data Store, Data Mart )
It is centralized warehouse. It provides decision and support across the enterprise. ------------------------------------- ( Enterprise Data Warehouse )
Also called ODS , are nothing but data stored required when neither data warehouse nor OLTP systems support organization ------------------------------------- ( Operational Data Store )
is a subset of data warehouse. it specially designed for particular line of business, such as sales, finance ------------------------------------- ( Data Mart )
In this stage data is just COPIED from an operational system ------------------------------------- ------------------------------------- ( Offline Operational Database )
Data in data warehouse is regularly updated from the operational database. The data warehouse is mapped and transformed to meet the data warehouse objectives ------------------------------------- ( Offline Data Warehouse )
in this stage, Data Warehouse are updated whenever any transaction takes place in operational database. ------------------------------------- ( Real time data warehouse )
Data are updated continuously , when the operational systems performs a transaction. ------------------------------------- ( Integrated Data Warehouse )
Give the 4 Components of data warehouse ------------------------------------- ( Load Manager, Warehouse Manager, Query Manager, End User Access Tools )
it is also called front component. It performs all the operations associated with the extraction and load of data into warehouse. ------------------------------------- ( Load Manager )
Performs operations associated with the management of data in the warehouse. Performs like analysis of data to ensure consistency creation of indexes and views. ------------------------------------- ( Warehouse Manager )
It is also called "Backend Component". It performs all operations related to the management of user queries. ------------------------------------- ( Query Manager )
End User Access Tools is Categorized into 5 different groups ------------------------------------- ( Data Reporting, Query Tools, Application Development Tools, EIS Tools, OLAP Tools and Data Mining Tools )
3 Steps to implement data warehouse ------------------------------------- ( Enterprise Strategy, Phased Delivery, Iterative Prototyping )
Here we identify technical including current architecture and tools. We also identify facts, dimensions, and attributes. Data Mapping and transformation is also passed ------------------------------------- ( Enterprise Strategy )
Data warehouse implementation should be phased based on subject areas. Related business entities like booking and billing should be first implemented the integrated with each other. ------------------------------------- ( Phased Delivery )
Rather than a bigbang approachh implementation the datawarehouse should be developed and tested iteratively ------------------------------------- ( Iterative Prototyping )
Dataware House 3 Tools ------------------------------------- ( Marklogic, Oracle, Amazon Redshift )