First school data warehouse
Creating Date: 2003-12-26
Modification Date: 2003-12-29
[Abstract] This article is a learning experience of reading "Decision Support and Data Warehouse System".
[Keyword] Data warehouse, decision support
There is a very deep thing in the book, and the excerpt is as follows: "When the reader starts their career, remember that the technology is a tool to serve the organization. If not serving the organization, the technology will be worthless. We must first Considering the needs of the organization, learning technology in business is important, only can help organizations can achieve the information system that meets their needs. Only when we understand the needs of the organization, we should consider meeting the needs of organizational needs. Conversely, if you consider the needs of the organization first, you will only have an impressive but useless technical monument. "
As the name suggests, the data warehouse is a place where the goods or materials are stored. The role of the data warehouse is a kind of decision-making system. For decision makers of a business, not all information is critical, decision data does not require a thick report. Smaller data collection called data market
Some basic concepts in FAQ
What is the difference between N Eis and ESS? What is the common between them?
1. EIS: Senior Manage Information System
2. ESS: Advanced Manager Support System, add some additional features on the basis of EIS, such as connecting an email system or office schedule, possibly, and features of modeling and expert systems.
n Data warehouse has three features:
1. Contains a lot of data
2. The organizational data warehouse is to make decisions for more convenient use of data.
3. Provide end users with tools available to access data
n Two basic hardware advances make data warehouse practical
1. Need a lot of memory (low price and high capacity)
2. Need a lot of computer resources (rapid development of hardware)
n What is the data warehouse to provide input information? What is information from the data warehouse?
A: The operational database provides input for the data warehouse, and the user gets information from the data warehouse.
n Three things must do before the data loaded into the data warehouse?
A: Prepare, organize and present
Is there any characteristic of the information system used by senior managers?
1. Cross-sector
2. Data
3. Essential summary nature
4. Graphic
5. Communication based on communication
6. Customize the personal preferences for senior management
n What is data cube?
Multi-dimensional similarity to the organization data warehouse database
N What is the system? What is the key to the system?
The system is a target, consisting of a set of interactions, keywords: group, interaction, component, target
What is the difference between the N information system and the general system?
The purpose of the information system is to store, process, and exchange information
N What is the data flow map? What is the data flow map not?
Data flow diagrams indicate the interaction between components between the data streams between the processing and data storage. The data flow map is not a complete description of the system. The data flow map cannot represent system objectives, but it is usually possible to infer the target from other information sources, and the data flow map can also represent the time relationship between the processing in the system.
n Decision Support Systems and General Information Systems Different
The decision system is a special information system. Use more than one data store (database or file collection) to provide information that supports decisions. The decision support system does not update the database as its external information source. Decision support system and policy makers exchange information
n Why do decision support systems use models? If the model performance provides decision makers to display the same information as the world's observations, and it provides the advantage of the real world observation, the model will become useful tools.
What is the main type of the n model?
Graphics model, narrative model, physical model
n Why does not usually use continuous models in business?
Continuous system analog models describe physical or economic processes, which describes the digital moments of the system at variations. Simple continuous systems can be studied by integral and differential equations.
Business systems typically portrayed continuously with continuous changes in the system: order arrival, product delivery. From the perspective of business plan, these instant stages are independent. Conforming these instantaneous phases into the model increases the complexity of the model but does not increase its purpose. Therefore, business simulations usually do not need a continuous model.
n What is a pseudo-random number? Why is it useful in analog model? How is the pseudo-random number get?
The number generated by a repeatable formula, these numbers in the sense of statistics seem to be true random numbers. All analog packages and most programming languages have built-in functions that can return evenly distributed pseudo-random numbers on a very useful range.
