Significance of Database and Data Warehouse Design

A data Warehouse refers to a database that stores vital information that is instrumental in shaping decision making processes within an organization. It operates as an integrated and time-varying assortment of data resultant from operational data with an aim of informing strategic decision making by way of online analytical processing (OLAP) procedures.  Database technology has incessantly played a primary part as well as enhancing a crucial impact on the continually rising use of computer systems. It is crucial to note that databases play an essential role in a wide spectrum of applications where computers are used such as business, law, genetics, ecommerce, engineering, medicine, library science and education (Gallo et al, 2010).

Read also Data Warehouse Origin and History

A database can be defined as a compilation of related data, whereby data entails recorded facts that carry with them intrinsic implication. It encapsulates the an assortment of aspects of the real world, otherwise known as the universe of discourse, and the changes taking place being reflected in it. A database involves a rationally articulate collection of data that exhibit an inherent significance, thus implying that arbitrary collection of data do not qualify as a database (Elmasri & Navetha, 2011). Additionally, a database is designed, inhabited and assembled with a set of data that has a specific purpose and meant for an intended group of users besides a defined employment in which has interest to the users (Mittal et al., 2010).

Read also Data Warehouse Administration, Security And Future Trends

Characteristically, a database has some fundamentals that data can be drawn from, enhancing connections with real world events, and the provision for an active audience that interacts with the content.  Summarily, a database is considered as a repository for data and can be employed to the result of any bookkeeping and recording activity of any enterprise. Database systems users make interact through the use of query language which has two primary functions namely; defining the data structures serving as receptacles for the data in the database, and allowing the speedy retrieval as well as modification of data. Data manipulation task of the database involves data retrieval and data update (Mittal et al., 2010). Data retrieval encapsulates the obtaining of the stored data that meets the specifications of particular formulation of the query of significant purpose to the user.  Data update involves the modification, insertion and deletion of data.

Share with your friends
Order Unique Answer Now

Add a Comment