Management Support System
The data and information loads are monitored and controlled
Normally, large amounts of historic data are utilized
Data are usually standardized to make it simple and maximize performance
Planned and unplanned queries are common in data warehouse
Describe the data warehouse process.
The warehouse process involve the processes of reporting and data analysis for decision-making. It is usually design for the purpose of inquiring and analyzing. The process involve various stages, which integrate ETL (Extract, Transform, and Load) process. These stages are access to data, data modeling, acquisition of data, cleaning and validation of data, data matching and data delivery and presentation for decision making. Usually the all process concept encompass data flow and channeling of information to various data sources systems.
What are the issues to consider when deciding which architecture for data warehousing to use?
Elicit requirements
Financial constrains
The business environmental description
Intended purpose, i.e the size of data to be catered for
The Alternatives
Describe the alternative architecture to the basic architectural design types in the data warehousing.
Evolution naturally, this form of alternative architecture involves development of warehouse development with time. There is no technological integration involves in natural evolution.
List five factors that potentially affect architecture selection decisions.
The availability of capital and resources constrains
The end users task nature
The compatibility of the proposed architecture with the existing system
The availability of techniques and technical personnel
The political and social factors
Information integration and flow between organization units and stakeholders
Describe various integration technologies that enable data and metadata integration.
Cloud computing, it is form of technologies that gives business to store and utilize huge amounts of data. Cloud computing is a set of system where separate set of technologies is involve in data and information storage.
Open source providers, this form of technologies involve use of providers such as enterprise service bus and other data integration startups. Business data can be tactically integrated in business when this form of technology is used.
Describe various issues that affect whether an organization will purchase data transformation tools or build transformation process itself.
Availability of resources. The presence of adequate capital determines an organization ability to purchase and adopt new data transformation.
Technical issues. Methodological process involving building transformational process maybe time consuming and expensive thus an organization may go on purchasing it. Likewise, lack of adequate technicians may encourage
Political and social issues. Stakeholders, governmental and political issues surrounding a company determines the organization decision on purchasing data transformation tools.
Describe a star schema.
Star schema is a term use in data warehousing and business intelligence (BI). It is the simplest modified data warehouse use in describing the dimensional values of data. The star schema consist of various statistic tables at the center and resemble the star. The star schema architecture utilization encourage simple data organization form inform of facts and dimensions.
List five benefits of a hosted data warehouse.
Hosted warehouse encourages faster connection in business
It promotes better quality software and equipment
It helps in freeing up cash flows and capacities in house systems
It is slightly cheap, as it requires minimal infrastructure investment and maintenances
Hosted warehouse is suitable in meeting storage of large volume of data
It encourages and makes powerful solution economical
Identify at least five data warehouse best practices.
Encouraging active stakeholders participation
Managing work flows and controls
Identify and prove the architecture in time
Systems and process integration
Perform interrelationships and modelling details in time
Delivering of working software and equipment regularly
Reference
Turban, E., Sharda, R. and Delen, D. (2011). Decision Support and Business Intelligence Systems, 9th Edition. Upper Saddle River, NJ: Prentice Hall Inc.
