Raw data cannot be presented in required formats or interpreted for that matter. Database on the other hand is the process or system of categorizing these raw data into meaningful information which can be easily retrieve. The database holds information from various sources that are stored in a logical format. This collection helps to reduce inconsistency, improves accuracy, improved performance and security. (Wallace, 2015, p. 102)
With substantial and consistent increase in every day data from various sources and database, it becomes a challenge to manage it. How can you give special attention to collecting, transforming and converting it into meaningful information which is then used to make strong business decision? Data warehousing is the key to making this possible. (Rogers, 2000)
Database is flexible and the data can be changed. It can also help give reasonable decision making options. But when two or more types of systems need to be combined the speed may suffer. This can hamper the decision making as the information are not reliable. (Rogers, 2000) A data warehouse on the other hand not accepts data from various sources but also cleanses it and places it in correct form. (Rogers, 2000)
For example, excel, MS access, SPSS (Statistics for Data Analysis and Visualization) are examples of database while Redshift, BigQuery are some examples of data warehouse. Database are a smaller part of data warehouse. In a business setting, an entrepreneur will have to look after staff salary, inventory, sales,
Reference
Rogers, C. (2000). DATA WAREHOUSING. Allied Academies International Conference. Academy of Information and Management Sciences. Proceedings; Arden , 6-10.
Wallace, P. (2015). Information System in Action. In P. Wallace, Introduction to Information System (pp. 4-9). New Jersey: Pearson Education, Inc.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where students share, stay up-to-date, learn and grow.
Raw data cannot be presented in required formats or interpreted for that matter. Database on the other hand is the process or system of categorizing these raw data into meaningful information which can be easily retrieve. The database holds information from various sources that are stored in a logical format. This collection helps to reduce inconsistency, improves accuracy, improved performance and security. (Wallace, 2015, p. 102)
With substantial and consistent increase in every day data from various sources and database, it becomes a challenge to manage it. How can you give special attention to collecting, transforming and converting it into meaningful information which is then used to make strong business decision? Data warehousing is the key to making this possible. (Rogers, 2000)
Database is flexible and the data can be changed. It can also help give reasonable decision making options. But when two or more types of systems need to be combined the speed may suffer. This can hamper the decision making as the information are not reliable. (Rogers, 2000) A data warehouse on the other hand not accepts data from various sources but also cleanses it and places it in correct form. (Rogers, 2000)
For example, excel, MS access, SPSS (Statistics for Data Analysis and Visualization) are examples of database while Redshift, BigQuery are some examples of data warehouse. Database are a smaller part of data warehouse. In a business setting, an entrepreneur will have to look after staff salary, inventory, sales,
Reference
Rogers, C. (2000). DATA WAREHOUSING. Allied Academies International Conference. Academy of Information and Management Sciences. Proceedings; Arden , 6-10.
Wallace, P. (2015). Information System in Action. In P. Wallace, Introduction to Information System (pp. 4-9). New Jersey: Pearson Education, Inc.