An insight to the offline and online data warehouses

In nontechnical language, the term data warehouse refers to a database that is used to keep account, study and access data within an organization or a company. Data within an organization is generally acquired from all departments – namely the sales, marketing, administration, warehouse, human resource and customer support department – of the organization or business enterprise. Sometimes the raw data that are acquired may go through some preprocessing before it is submitted to a data warehouse. In case of the traditional or the common old data warehouses – it sets up main tasks by way of separate arrangement, assimilation and admission. The arrangement or staging area collects and stores the raw un-processed data that is acquired from different sources across the organization. The assimilation or integrated area processes and transforms the collected data into a format that is suitable for reporting. The data is then made available for access to users within the organization.

In the beginning, data warehouses that were used by organizations were offline operated data warehouses – wherein the data had to be updated at periodic intervals on a weekly or monthly basis and was saved in a report like format. The next were the offline data warehouses –wherein the data were updated from operational systems on a regular basis and was stocked up in a format that supported the reporting process. After a while the offline data warehouses were outdated, and in came the new online data warehouses – wherein data updates in actual time by way of keeping record of every single transaction that is carried out from the starting point. With the latest evolution being the integrated date warehouse – which keeps data that is collected from across the different departments of the organization, thus enabling a user’s real – time access to intelligence information from across departments within the company.