Database vs Data Warehouse
The basis for the difference between a database and a data warehouse arises from the fact that a data warehouse is a type of database that is used for data analysis. A database is an organized collection of data stored on a computer system. Information about students, teachers, and classes in a school stored in table fashion is an example for a database. As databases support large amount of data, concurrent processing, and efficient operations, they are widely used. But, as database is often subjected to updates, it not possible to have a proper view to do an analysis. Hence, a data warehouse technique must be followed to achieve this. A data warehouse is a special type of database, but which is optimized for querying and analysis. As a data warehouse extracts data from various sources and reports, it does so that decisions can be reached by analysis. Let us look at them and the difference between them in more detail here.
What is a Database?
A database is a collection of related data stored on a computer system. Usually, a database is organized and its data is related. For example, a school database would have several tables as teachers, students, and classes where each table would have records that specify information about each item. Here, we can see the structure is organized based on certain criteria and there are relationships between the tables as they all belong to the same school. A database has numerous uses in the computer world. Therefore, it is so famous that it is found very abundantly in various applications. The basic advantage of a database is that a database can store a huge amount of data in a very less space while providing very fast and easy operations on data.
A database often involves a software system called Database Management System (DBMS), which is responsible for storing and managing the data in the database. MySQL, Oracle, Microsoft SQL Server are some well-known database management systems. When creating a database on the computer, first step is to create a logical structure of how data is stored, organized, and manipulated based on the description we have for the system. This is called as database modeling. There are various modeling techniques such as relational model, network model, object oriented model, and hierarchical model, but the most famous one is the relational model. Even MySQL, which is one of the most used database management systems, uses the relational model to store its databases.
0 comments:
Post a Comment