For example:
Data warehouses
- It is a system, can be used for data to analysis or with a reporting software.
- We can use data warehouse to integrate data from one or more disparate sources, creating a central repository of data
- Maintains a copy of the information from the source transaction systems, we only need a single query engine in order to view the data that we need
- It is useful to keep historical data, to improve the quality of the data (to be more consistent, less bad data), to combine all of the data from different sources into single data model
- Main goal is to combine the data form different sources and types of the data source
- Main benefit all of the associated data that can be used in disparate applications or in a singular application
Executive information systems
- It is a decision support system that is used to assist the senior executives for decision making process
- This is done by providing easier access to the important data that are needed in order to achieve the goals in an organization
- Usually features the graphical displays on the easy-to-use interface
- Can be used in many different types of organization to monitor the enterprise performance and to identify the opportunities and the problems
Online analytical processing (OLAP)
- It is a category of software allowing the users to analyze the information from multiple database systems at the same time
- A technology that enables the analysts to extract and view the business data from different point of view
- With OLAP, the data can be pre-calculated and pre-aggregated and this make the analysis faster
- OLAP database are divided into one or more cubes, and the cubes are then designed in a way that creating and viewing reports become easy
References:
No comments:
Post a Comment