Data warehousing and storage systems - Essay Example

Comments (0) Cite this document
Data warehousing is the process of collection of integrated, subject-oriented, non-volatile and time-variant data to support decision making for a management. Data warehouse helps storage of historical and current data so that it can be used for quarterly or annual comparisons…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER95.5% of users find it useful
Data warehousing and storage systems
Read TextPreview

Extract of sample "Data warehousing and storage systems"

Data Warehousing and Storage System Introduction Data warehousing is the process of collection of integrated, oriented, non-volatile and time-variant data to support decision making for a management. Data warehouse helps storage of historical and current data so that it can be used for quarterly or annual comparisons by management of an organization or group. The application and benefits of Data warehousing and storage system is further illustrated in the discussion.
The types of Data warehousing are Online Analytical Processing, Data Mart, Predictive Analysis and Online Transaction Processing. These types of warehouses help in attaining different range and level of storage of data in a computing device. A data warehouse is useful because it can maintain replica of information from the source. This architectural convolution provides the prospect to alleviate the problem of database isolation level lock conflict in operation processing systems that is caused by long or large running attempts and queries related to analysis in the processing database of transaction (Silvers, 2008). The uses of data warehousing is not just limited to one prospect it also helps in compressing data into a single source from multiple sources so that only one query engine can be used. Data warehousing increases the efficiency of working and it improves the data quality by maintaining data history accurately even when the source transaction is unable to keep the record. It helps in keeping information secure and also updates if any alteration is done on any data. This is very important because storage of data should always be in a secured mode in order to avoid isolation of information.
The concept of data warehousing was brought forward in the later part of 1980, in order to deliver an architectural model for flow of information from operational systems to decision support systems (Becker, 2002). Data warehouses in order to obtain analytical access patterns are optimized. They involve in selecting specific fields of function unlike operational systems that use a common type of access pattern. Due to these differences analytical databases get benefited from column-oriented data base management system and operational database get benefited from row-oriented data base management system. Operational systems only maintain a picture or frame of business related information however data warehouses maintain the entire history that is implemented from ETL processes. The evolution of data warehousing in organization use is very sophisticated. There are mainly four levels of warehouses. Offline data warehouse, Offline operational data warehouse, integrated data warehouse and on time data warehouse. These four levels of data warehousing is used in order to store data for maximum utilization for organizational purposes. Storage of information is a very important concept because information should be stored in a proper architectural system from where information can be obtained for referring and modification purpose as and when required.
Data warehousing is very important in storage of data. Data warehousing provides proper security and safety for data stored in a system. The most important part is the accessibility of data when require. Because of the concept of warehousing information can be stored and retrieved from infinite history. Hence data warehousing is very important in data storage techniques for an organization.
Becker, S. (2002). Data Warehousing and Web Engineering. New York: IGI.
Silvers, F. (2008). Building and Maintaining a Data Warehouse. New York: CRC Press. Read More
Cite this document
  • APA
  • MLA
(“Data warehousing and storage systems Essay Example | Topics and Well Written Essays - 500 words”, n.d.)
Data warehousing and storage systems Essay Example | Topics and Well Written Essays - 500 words. Retrieved from
(Data Warehousing and Storage Systems Essay Example | Topics and Well Written Essays - 500 Words)
Data Warehousing and Storage Systems Essay Example | Topics and Well Written Essays - 500 Words.
“Data Warehousing and Storage Systems Essay Example | Topics and Well Written Essays - 500 Words”, n.d.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Data warehousing and storage systems

Data Warehousing and data mining

...capacity increased significantly at affordable prices.” The storage of historical data is an ultimate requirement of data warehouses (DWs) because it is utilized for knowledge discovery, formally known to be data mining (DM). DWs can retain all historical time stamped data, which helps to generate patterns of customer, product and employees’ behaviors. It is important to note that data warehouse is not a system that can be deployed in an environment rather it is a concept that shapes and evolves through integration of various tools and steps of data warehousing. More importantly,...
10 Pages(2500 words)Research Paper

Data Warehousing and Mining

...). Though it is feasible to produce the required results through such SQL characteristics as inline views, self joins and user-defined utilities the consequential queries could be difficult to recognize and may produce incorrectly long times for implementation. IMPACT OF PARALLEL COMPUTING TECHNOLOGIES ON DATA WAREHOUSING AND DATA MINING The complicated nature of data mining practices and the size of corporate data require performance that could be simply derived from very influential parallel computing systems and applications....
18 Pages(4500 words)Essay

Data Management: Data Warehousing and Data Mining

...?Information Systems have hitherto relied upon data quality and integrity for its management. Countless companies faced numerous problems in accomplishing this task but thankfully SAP has emerged as effective, efficient and user friendly tool that customizes software to meet the particular needs of the company. SAP solutions are getting recognition worldwide and it had highest analytical and performance management revenue in the year 2010 (Gartner, 2011) Among the various products SAP has launched one of the very affective tool for business analytic solutions is SAP BusinessObjects. Users can explore and compare relevant information through SAP BusinessObjects Explorer even if they lack in IT training as...
2 Pages(500 words)Research Paper

Data Warehousing & Data Mining be considered by an organization before and during data warehouse development? Organizations are moving towards implementation of data warehousing as reformation strategy. The health sector has been reluctant in the application of information technology and information system. Therefore, implementation of data warehousing can be viewed as a competitive advantage to the health sector. Data warehousing has numerous advantages to a health organization. Ideally, data warehousing is meant to promote comparability of clinical data, which is a significant...
3 Pages(750 words)Assignment

Data Warehousing and Data Mining

...are linked with scalability, capability, and analogy of the data mining methods and procedures. Likewise, for making the data mining process effective, acquisition of information from data warehouses acquiring numerous databases is necessary. However, there are certain challenges when accessing data from large data warehouses, as some of the challenges includes long time delays in process data miming algorithms. However, the solution for this challenge is to incorporate distributed and parallel data mining techniques. These techniques can divide data in to different segments for making the process...
6 Pages(1500 words)Essay

Data Warehousing

.... The tools that are used in gathering the summarized data from various sources into the data warehouse are online analytical processing systems and the query tools. The tools are used in supporting adhoc analysis, inquiring and reporting of the data to the end-users without asking for assistance from the programmers while undertaking the required tasks in the appropriate manner (Witten & Frank 2000). Data warehousing Values. Data warehousing is easy to maintain and fast in generating reports. It is widely preferred because it doesn't require too much technical knowledge to control it hence any member of...
10 Pages(2500 words)Essay

Data Storage

...mechanisms to respond to the needs of the industries. In response to the demands of these varied types of computer users, new hybrid storage systems are now introduced: direct attached storage (DAS), storage area network (SAN) and network attached storage (NAS) (“Enterprise Data Storage”, n. d.). Enterprise business storage is also one of the popular new storage systems that play a special key role in ensuring that enterprise business intelligence is available and has leverage at the most opportune time and that discrete data silos are consolidated to...
2 Pages(500 words)Essay

Data Warehousing in Healthcare

...of information to allow for research and reorganization refers to data warehousing. The concept is as old as the ancient libraries. However, the tools for data storage are no longer large tomes of papyrus and paper, but IT based databases. Manufacturers of the Technology The setting up of data warehouses is not a preserve of any specific company. In fact, data warehouses have components made by different manufacturers. A consultant, usually a systems engineer, designs, and sets up a data warehouse for different clients based on their needs[Hya07]. In this sense, a data warehouse is not...
5 Pages(1250 words)Article

Data Warehousing

...Data Warehousing Introduction Data warehouse can be d as a database system through which several data can be analyzed and evaluated at a time. The concept of data warehouse has been introduced to extract, filter, classify and cluster data.. The actual purpose of developing data warehouse is to perform data analysis quickly and efficiently. In modern era, unprecedented advancement can be observed in the field of science and technology. Thus, in the current era people can be identified to have little time engaging in data processing unlike in the past decades. Notably,...
7 Pages(1750 words)Research Paper

W7D Review Data Warehousing

...Review Data Warehousing al Affiliation Review Data Warehousing What is the most practical and easily applied lesson on Datawarehouse? From among the lessons learned on data warehousing, the most practical and easily applied is the module on defining business requirements. Practitioners could easily understand concepts on requirements gathering methods (Chapter 5), including the types of questions to be used as well as the other techniques that were discussed (Ponniah, 2010). These techniques and skills learned in the process could also be applied in other endeavors: research, applications for employment, and other information-gathering...
1 Pages(250 words)Essay
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

Let us find you another Essay on topic Data warehousing and storage systems for FREE!

Contact Us