p. 280

3 - 2 Data Warehouse

Data warehouse is a company-wide integrated information system (multi-dimensional database) that expands the functions of databases and extracts the required decision-making information for the business strategy of the company. It is used in OLAP (OnLine Analytical Processing), which extracts the data that is accumulated through OLTP (OnLine Transaction Processing) in the mission critical systems, builds a massive database for information analysis, and conducts multifactor analysis and forecasts of data,. · 1 question

Data mining is the method to analyze data or regularity required for the management by using mathematical and statistical techniques such as OLAP. Mining, which is literally described as digging up data from databases, is useful in marketing strategies by analyzing a large amount of accumulated data and finding the potential needs of customers. For example, from a large amount of sales data, it extracts rules, such as “People who buy bread also buy milk simultaneously.” · 1 question

p. 281

This series of data management/analysis work from building a data warehouse to data mining is also called data administration. In recent years, the amount of accumulated data has become so large that it is also referred to as big data. It has become difficult to handle so much data with the commercially available database software (i.e., DBMS). Therefore, in some cases, a small-scale data warehouse (i.e., data mart) is used, which is prepared by extracting only data required for a specific department (or business operations) from the data warehouse. Data mart is easy to use because data is refined as per the requirement and level of end user. However, there is a risk that it may overlook unforeseen regularity.