Data Warehouse and Data Essay

Submitted By ushaswin
Words: 2814
Pages: 12
Open Document
Data warehousing plays a vital role and important area of information technology infrastructure Data warehousing is a structure that holds data in a précised manner and data can be retrieved based on the business requirements of a company. There are many different kinds of data ware housing systems that a data is stored in a company and will be vary based on the storage like star flex schema data ware house, snow flake data ware house, metadata ware house and enterprise data warehouse systems.
In past data is being maintained in the papers, tapes and disks and now the data is maintained in the granular, systematic order and in highly secure way in appropriate data bases with structured tables, constrains, data diagrams, and keys combined know as data ware house.
As of now we would make a difference between the data in legacy format of operation to the on-going operation of Data Warehouse 2.0
Step-By-Step Growth and architectural view of DW 2.0:
In DW 2.0 when compared to 1st Generation data ware housing there is an advanced architectural features and technologies.
• There are remarkable changes made in the DW 2.0 when compared with the previous versions change in implementation of architectural, upgrade to systems and ability to communications with the end users which has got a vital change in the business.
• Online Process and access of data to a common business man in day to day life in reservation systems, ATM Process and online inventory management is not restricted to time.
• Corporate Data: Came to reality by adding the corporate information on the many applications by new vistas of processing opened up which was not previously obtained.
• Business made discussions on the structured data but there is also valuable information in the unstructured data which need to be made decision on it and the key to open up was made with ETL (Extract, transform, Load) which made vital changes in business.
• Capacity: Interact with different forms of technologies, speed up of processing, with stand of data in which capacity is an infrequently encountered constrains made easier in DW 2.0

Effects of Data ware house on Business:
The DW had higher effect on various businesses. In this case the situation raises where the business which are deeply reliable on the DW are follows:
• The airline environment which uses the frequent flyer technology
• The Credit card companies which cross verifies the persons profile to see if any fraudulent use of credit card.
• Company keeps track of oversupply and under supply of goods maintained by an organization
• Organization stores customer profile regarding transactions in detail manner in data ware house.
The Data ware house helps the organization to maintain long and detailed corporate memory.

Changes of Data in timely manner supported by DW :
There are wider changes in architectural and ability to maintain data in DW 2.0. It has greater ability to support the changes of data which changes in time to timely manner this is due to the semantically static and semantically temporal data in database designs.
If data entity changes happens, Semantic data changes occurs. In Meaning full static data will it will not always be fixed and there wouldn't be any changes and the data which is Meaning full secular data will be frequently changing . Taking an considering an example of customer profile with Meaning full secular data where we can edit details of his profile and we can add details in his profile this shows that data is frequently changing. If considering in an organization where details of an employee are maintained in case gets transferred or gets into new position where the roles, responsibilities, emails to whom he needs to report and who all needs to report to him will be changed and leads to add in columns to tables and changes in data. And now considering the example of Meaning full static data is yearly stocks where it will be mentioned the sales, profits,
Show More

Related Documents: Data Warehouse and Data Essay

Data Warehouses and Databases Essay

Data Warehouses and Databases Northern Alberta Institute of Technology Introduction Keeping track of information and knowing where it is at all times is a challenge for any organization. The need to be able to access and find information is extremely important. Above being able to find the information it needs to be useful and simplified for the users. Being able to turn data into information and storing the data in an accessible place is a huge need to organizations of any magnitude. This paper…

Words 653 - Pages 3

A Case Study: Opening Up The Data Warehouse '

________________________________________________________________ Opening up the data warehouse ________________________________________________________________ ________________________________________________________________ INFT13-320 Advanced Database Assignment 2 – Semester 122 ________________________________________________________________ Prepared by: Ryan Mouritz Prepared for: Bruce Vanstone Due Date: Friday 29 June 2012, 16:00 ________________________________________________________________…

Words 2523 - Pages 11

Data Warehouse and Business Intelligence Essay

community easy access to business data”. Business Intelligence Roadmap by L. T. Moss and S. Atre, Addison Wesley. Requirements: (1) Three definitions for “Business Intelligence” with source information. Include at least one definition found from a journal article. If website resources were used, include not only the web link/address but also information such as company name, author, page title, etc. 1. “BI is an umbrella term that combines architectures, tools, data bases, applications, practices…

Words 345 - Pages 2

Dimensional Modeling Fact Tables Essay

Dimensional Modeling ISYS637 Vocabulary Fact Table Dimension Table Star Schema Snowflake Schema 3/4/15 ISYS 637: DATA WAREHOUSE 2 Figure: Generating Reports from facts and dimensional attributes 3/4/15 ISYS 637: DATA WAREHOUSE 3 Dimensional Design Process (Source: “The Data Warehouse Toolkit” by Kimball and Ross, 2013) 1. Select the business process to model ◦ E.g. a dimensional model to capture order process 2. Declare the grain of the business process ◦ Specify exactly what an individual…

Words 1396 - Pages 6

Real Time Business Intelligence at Continental Airlines Essay

Describe “active” data warehousing as it is applied at Continental Airlines. Does Continental apply active or real-time warehousing differently than this concept is Normally described? Explain your answer. Answer: as shown in the case Continental senior management decided to invest in enterprise data warehouse that all employees could use for quick access to key information about the business and its customers. The data warehouse initial focus was to provide accurate integrated data revenue management…

Words 1686 - Pages 7

Essay On Data Warehousing

Data warehousing can greatly benefit and help any organization. In the book “Databases Illuminated”, data warehousing is described as a storage place of a company’s historical data that is often collected from various departments or sections of a company that belong to the company as a whole (Ricardo, 2012). With the scope and range of data that is stored this can at times include massive amounts of data. Such a “warehouse” of data can be invaluable to a company. I am sure that once anyone understands…

Words 2252 - Pages 10

Database: Database and Information Essay

Chapter 7 Databases and Data Warehouses 7.1 Databases * <<Introduction>> * The ability to understand, digest, analyze, and filter data and information is key to success for any professional in any industry. * Data are raw facts that describe the characteristics of an event. * E.g., characteristics for a sales event can include a date, item number, item description, quantity ordered, customer name, or shipping details. * Information is data converted into a meaningful…

Words 2716 - Pages 11

Nt1310 Unit 3 Data Derivation

the design). • Verifying the data within the transforming stage (making sure that the workflow is correct by testing and evaluating) • Execute the transforming stage. • Replacing the clean data with dirty data from original sources in order to improve data consistency and avoiding re-cleansing data for future extraction. 2.2.3 Data Derivation Data derivation is the process of creating a data value from many contributing data values through derivation algorithm. Data derivation is very vital because…

Words 1464 - Pages 6

Relational Database Optimized For Online Transactions

8). The data in a relational transaction system usually require a normalized structure with many tables, each containing a minimum of attributes and emphasizing data integrity. Query activity in the relational database tends to be low for additional processing cycles. A data warehouse focuses on querying capabilities and tends to be non-normalized, including few tables which contain large numbers of attributes. The queries in the data warehouse are usually broad in scope and complex. A data warehouse…

Words 998 - Pages 4

Mis Chapter 5 Essay

paragraph on each article, including: (1)Data, data everywhere -The world contains a vast amount of digital information that can make it possible to do many things, the data should be managed well that can be used to new sources of economic value, provide fresh insights into science and hold governments to account. -The interesting part of this article that I found out is the business of information management is helping organizations to make sense of their data, such as IBM, Microsoft. (2)All too…

Words 880 - Pages 4