historical databases that have not been updated to modern schemas). Recognize that the job is probably harder than you expect: A large portion of the data in data warehouses is incorrect, missing, or input in such a way that it is not usable (e.g.To this, we can add the 5 criteria presented on the website:
Deployment: Users access the relevant metadata, based on their needs.Maintenance: Updating of metadata to match changes in data architecture.They further identify the lifecycle of metadata as: Parankusham & Madupu (2006) outline the different roles of metadata as including: data characterization and indexing, the facilitation or restriction of data access, and the determination of the source and currency of data. This is regarded as a particularly crucial step. Implementing metadata: Metadata is essentially data about data.Accurately specifying user information needs.Deployment issues, such as how users will receive the information, how routine decisions must be automated, and how users with varying technical skills can access the data, must be addressed.Īccording to Frank (2002), the success of the implementation of the data warehouse depends on: The size of the database and the complexity of the analytical requirements must be determined. Finally, warehousing data should be implemented in a way that ensures that users understand the benefit early on. the time taken to analyze data and arrive at a decision). This involves the specification of current information lacks and the stages of the decision-making process (i.e. The next step is to identify the information needs of the decision makers. The first stage is largely concerned with identifying the critical success factors of the enterprise, so as to determine the focus of the systems applied to the warehouse. Tanler (1997) identifies three stages in the design and implementation of the data warehouse. Warehousing Data: Design and Implementation Theirauf's model for data warehousing is as follows: This server then passes on the extracted data to the warehouse database, which is employed by users to extract data through some form of software. A server hosts the data warehouse and the DSS. First data extraction of operational production data takes place, and this data is passed on to the warehouse database. Thierauf (1999) describes the process of warehousing data, extraction, and distribution.
DATA WAREHOUSING DATA MINING AND OLAP ALEX BERSON PDF DRIVER
Furthermore, the data warehouse is usually the driver of data-driven decision support systems (DSS), discussed in the following subsection. Data warehouses contain information ranging from measurements of performance to competitive intelligence (Tanler 1997).ĭata mining tools and techniques can be used to search stored data for patterns that might lead to new insights. The goal of storing data in a centralized system is thus to have the means to provide them with the right building blocks for sound information and knowledge. Warehousing data is based on the premise that the quality of a manager's decisions is based, at least in part,on the quality of his information. Warehousing Data: The Data Warehouse, Data Mining, and OLAP
0 kommentar(er)
