Data Warehouse Essay Example | Topics and Well Written Essays - 750 words

Data Warehouse - Essay Example The data warehousing is a multi-task activity and it quite different from traditional transaction-oriented operational database management activity. It involves various state – of – art application tools and techniques for aggregating and thereby summarizing large amounts of data that assists in an effective data management and retrial. A state-of-the-art application in the data warehousing is one that can achieve a near-real-time situation. Most organizations call for immediate decision-making, which needs real-time analysis, and presentation of decision-making. Many data warehouse applications achieve this by shortening the loading cycles using micro batch ETL. These applications have unique characteristics which include: highly scalable data mining algorithms, ease of integration with other components, efficient and secure in database processes, ease of use and user-friendliness and can support relevant standards. It is, however, important to have proper consideratio ns while choosing the methodology to use in the implementation of the applications and also the entire system. Two options are available. Both of the approaches have both advantages and disadvantages; therefore, the organization should consider the individual components and the nature of activities before deciding which approach to use. In any case, it is important to consider factors such as the volume of work, user technical skills, availability of budget and the time available to carry out the activity. (Prabhu, and Venkatesan, 20). What Have Been Notable Successes that We Can Emulate? There are numerous notable success stories of organization that can be emulated. One of such stories is Hallmark Cards. Hallmark Cards with $3.6 billion in annual sales and 20,000 employees, is a leader in the personal expressions industry. It has approximately 40,000 products selling through over 40,000 retail outlets. Since as a personal expression industry, it was very critical for the company business to understand what is happening at retail outlets in order to react quickly to changes in the environment. Hallmark utilized the warehouse environment with data mart along with decision support system (DSS) to help his management to understand market environment to launch a major new product line. By using data mart,