A database can be referred to be a space for holding data. Through the database, we can store, organize, protect, and deliver data in a computerized structure. It consists of information in a series of two-dimensional tables (Cuzzocrea, 2011). Similarly, a data warehouse in the analysis and decision-making process by providing easy access to the database. A data warehouse can also be said to be a collection of a database which works together. This helps an organization get new deeper insights into the data they hold in multiple databases.
A database consists of single or multiple files which need to be stored in a server or a computer. Mostly all large organizations don’t just store all their records in a single computer of an individual but rather a system which is centrally hosted (Wang, Shen & Sun, 2013). This system consists of a server of one or more devices. The server provides the service over a network. Thus, these types of servers are protected from human-related disasters to other threats with the inclusion of controlled access, power backup, security and much more precautions in place to get physical access to the facility.
Collection of databases working together can be considered as a data warehouse. It makes the integration of data from multiple databases possible helping give a more concentrated look into the data for smarter, better business decisions based on it. Data warehouse provides a set of tools and architecture to systematically organize and understand data from multiple sets of databases.
Let’s consider an example to better understand database and data warehouse and their interlinkage. If you’re provided with a login to the server holding two databases, unless they’re specifically labeled to be database or data warehouse; there’s no easy way with which one can differentiate either of those. However, there’s a distinctive difference which we look into with another example. Considering an example of Bhat-Bhateni Supermarket, which has stores in multiple locations. For this example, let’s consider the number of branches the business holds to be eight. Bhat-Bhateni has a database for each of the store to keep track of sales, profit, stock and alike. On top of it, managers in each store provide a report as well. However, those details won’t give the overall picture of how well the entire business is doing. If you want to obtain the overall picture of the performance, each of the eight records must be tallied and computed because the database is different. Now, if the business wants to have a detailed look at it, they can make use of a data warehouse. With this, all the eight-store database will transfer data individually to the central database which can now be used to perform analysis and get a bird-eye view of the entire business operation.
References
Cuzzocrea, A. (2011). Pushing artificial intelligence in database and data warehouse systems. Data & Knowledge Engineering , 70 (8), 683-684.
Wang, X., Shen, J., & Sun, C. (2013). Data Warehouse Oriented Data Integration System Design and Implementation. Applied Mechanics And Materials , 321-324 , 2532-2535.
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.
A database can be referred to be a space for holding data. Through the database, we can store, organize, protect, and deliver data in a computerized structure. It consists of information in a series of two-dimensional tables (Cuzzocrea, 2011). Similarly, a data warehouse in the analysis and decision-making process by providing easy access to the database. A data warehouse can also be said to be a collection of a database which works together. This helps an organization get new deeper insights into the data they hold in multiple databases.
A database consists of single or multiple files which need to be stored in a server or a computer. Mostly all large organizations don’t just store all their records in a single computer of an individual but rather a system which is centrally hosted (Wang, Shen & Sun, 2013). This system consists of a server of one or more devices. The server provides the service over a network. Thus, these types of servers are protected from human-related disasters to other threats with the inclusion of controlled access, power backup, security and much more precautions in place to get physical access to the facility.
Collection of databases working together can be considered as a data warehouse. It makes the integration of data from multiple databases possible helping give a more concentrated look into the data for smarter, better business decisions based on it. Data warehouse provides a set of tools and architecture to systematically organize and understand data from multiple sets of databases.
Let’s consider an example to better understand database and data warehouse and their interlinkage. If you’re provided with a login to the server holding two databases, unless they’re specifically labeled to be database or data warehouse; there’s no easy way with which one can differentiate either of those. However, there’s a distinctive difference which we look into with another example. Considering an example of Bhat-Bhateni Supermarket, which has stores in multiple locations. For this example, let’s consider the number of branches the business holds to be eight. Bhat-Bhateni has a database for each of the store to keep track of sales, profit, stock and alike. On top of it, managers in each store provide a report as well. However, those details won’t give the overall picture of how well the entire business is doing. If you want to obtain the overall picture of the performance, each of the eight records must be tallied and computed because the database is different. Now, if the business wants to have a detailed look at it, they can make use of a data warehouse. With this, all the eight-store database will transfer data individually to the central database which can now be used to perform analysis and get a bird-eye view of the entire business operation.
References
Cuzzocrea, A. (2011). Pushing artificial intelligence in database and data warehouse systems. Data & Knowledge Engineering , 70 (8), 683-684.
Wang, X., Shen, J., & Sun, C. (2013). Data Warehouse Oriented Data Integration System Design and Implementation. Applied Mechanics And Materials , 321-324 , 2532-2535.