Preview

Data Warehousing Assignment

Powerful Essays
Open Document
Open Document
1833 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Data Warehousing Assignment
Q. 1. With necessary diagram explain about data warehouse development life cycle .
Ans : Introduction to data warehouses. Data warehouse development lifecycle (Kimball’s approach)

Q. 2. What is Metadata ? What is it’s uses in Data warehousing Archietechture ?
Ans : In simple terms, meta data is information about data and is critical for not only the business user but also data warehouse administrators and developers. Without meta data, business users will be like tourists left in a new city without any information about the city, and data warehouse administrators will be like the town administrators who have no idea about the size of the city or how fast it is growing.
Despite its criticality, meta data continues to remain the most neglected part of many data warehousing projects. "We shall worry about it later" is usually the approach.
Different data warehousing systems have different structures. Some may have an ODS (operational data store), while some may have multiple data marts. Some may have a small number of data sources, while some may have dozens of data sources. In view of this, it is far more reasonable to present the different layers of a data warehouse architecture rather than discussing the specifics of any one system.
In general, all data warehouse systems have the following layers:
 Data Source Layer
 Data Extraction Layer
 Staging Area
 ETL Layer
 Data Storage Layer
 Data Logic Layer
 Data Presentation Layer
 Metadata Layer
 System Operations Layer
The picture below shows the relationships among the different components of the data warehouse architecture:
Metadata Layer
This is where information about the data stored in the data warehouse system is stored. A logical data model would be an example of something that's in the metadata layer. A metadata tool is often to used to manage metadata.

Q. 3. Write briefly about four ETL tools. What is Transformations? Briefly explain the basic

You May Also Find These Documents Helpful

  • Satisfactory Essays

    The Entity Relationship Diagram, also known as (ERD) demonstrates the relationship between data in the new database. ERD shows the logical path that the data follows. The data model gives one understanding and the visual representation to observe the different phases of the database and determine the path the information is pulled or stored from. Learning Team D demonstrate linking the different tables in the Fleet Truck Maintenance database. The creation of the logical path predicts the flow of the data entered and the tables relationship to other tables in the database.…

    • 553 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Inmon, B., & Valente, G. (2010). A peek into the future: The next wave of data warehousing. Enterprise Systems. Retrieved January 19, 2014 from http://esj.com/articles/2010/02/03/next-wave-dw.aspx…

    • 853 Words
    • 4 Pages
    Good Essays
  • Best Essays

    Metadata present a more complete picture of the data in the database than the data itself.…

    • 2439 Words
    • 17 Pages
    Best Essays
  • Good Essays

    | * The data warehouse of St George bank supports the integrated data among different departments * Data from different departments can be accessed freely * Integrated data from the data warehouse is more beneficial and creates more opportunities and BI for all departments (1+1=3) * “Most departments extract what they need from the warehouse using customer relationship management and BI applications without intervention.” * “They have access to all the data, can create their own filters, their own campaigns.”…

    • 341 Words
    • 1 Page
    Good Essays
  • Best Essays

    References: 1KeyData. (2012). Data Warehousing > Concepts > Conceptual, Logical, And Physical Data Models . Retrieved May 23 2012, from Conceptual, Logical, And Physical Data Models: http://www.1keydata.com/datawarehousing/data-modeling-levels.html…

    • 3587 Words
    • 15 Pages
    Best Essays
  • Good Essays

    “Databases are a mean for storing information in such a way that information can be retrieved from it. In simplest terms, a relational database is one that presents information in tables with rows and columns.” “A table is referred to as a relation in the sense that it is a collection of objects of the same type (rows).” “Data in a table can be related according to common keys or concepts, and the ability to retrieve related data from a table is the basis for the term relational database.” “A Database Management System (DBMS) handles the way data is stored, maintained, and retrieved.” “In the case of a relational database, a Relational Database Management System (RDBMS) performs these tasks. Oracle, 2014)”…

    • 672 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Data Warehousing Failures

    • 5385 Words
    • 22 Pages

    At first, the planner for the data warehouse wanted to use a dimensional model for tabular information. But political pressure forced the system’s early use. Consequently, mainframe data was largely replicated and these tables did not work well with the managed query environment tools that were acquired. The number of tables and joins, and subsequent catalog growth, prevented Auto Guys from using data as it was intended in a concise and coherent business format.…

    • 5385 Words
    • 22 Pages
    Powerful Essays
  • Better Essays

    Data Warehousing

    • 1687 Words
    • 7 Pages

    Data warehouses have a basic design with some variations. Data sources, warehouse and users make up the architect of the basic data warehouse. In our system we will be adding data marts and a staging area.…

    • 1687 Words
    • 7 Pages
    Better Essays
  • Good Essays

    A data warehouse is a database that stores current and historical data of potential interest to decision makers throughout the company.[1] In the Terrorist Watch List Database case, the information about suspected terrorists are consolidated and standardized from multiple government agencies so that the information can be centralized into a single list, from which different agencies can communicate and share information with each other. This centralized database is a specific example of data warehouse. In this case, the data warehouse containing the relevant information of individuals from each agency’s list enhancing effectiveness of communication between agencies as well as increase the consistency of information from separate databases.…

    • 860 Words
    • 4 Pages
    Good Essays
  • Good Essays

    If I were to design Ben & Jerry's data warehouse I would use several dimensions of information. The first dimension would consist of the company's products; ice cream, frozen yogurt or merchandise. The marketing department has to know which products are selling, if Ben & Jerry's didn't know that their T-shirts are selling out as soon as they hit the stores, then they wouldn't be able to take advantage of the opportunity to sell the shirts. The second dimension would consist of the different areas of sales; US, Canada, Mexico, or Europe. I am not sure if they sell their ice cream in Mexico, but with data collection they can find out if their ice cream would be a better seller in the hot climate, rather than pushing for greater distribution in Canada. The third dimension would consist of the "specifics"; where the sale was made, when the sale was made, and who purchased the product. This information can help in the design of the product to focus on the buyer; it can tailor flavors to seasons, and packaging to buyer who looks for the better-looking product. If Ben & Jerry's could know when a season was coming to an end in a specific area, then they could forecast the need or the decline in need and speed up, or slow down distribution to those areas. The focus of the information is that it needs to be useful, and almost any information is useful.…

    • 605 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Rei Data Warehousing

    • 716 Words
    • 3 Pages

    A data warehouse can be described as a “database that stores current and historical data of potential interest to decision makers throughout a company. The data originate in many core operational transaction systems, such as systems for sales, customer accounts, and manufacturing, and may include data from Web site transactions.1” REI is building a data warehouse to improve the company and to meet the needs of the customers. REI’s data warehouse will allow the company to view current and past data on sales, products, and customer information. The data warehouse will allow for the company to get to know the customers better and help in seeing which products are selling. The data warehouse will allow REI to become closer to the consumer and tailor goods to the needs of the consumer.…

    • 716 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Operational data are kept in a relational database that structures tables that tend to be extremely normalized. Operational data luggage compartment is optimized to support transactions that symbolize daily operations. For example, Customer data, and inventory data are in a frequent update mode. To provide effective modernize performance, operational systems keep data in many tables with the smallest number of fields. Operational data focus on individual transactions rather the effects of the transactions over time. In difference, data analysts tend to comprise of many data dimensions and are concerned in how the data recount over those…

    • 628 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    dfdfdfdfdfdfdfdfdf

    • 352 Words
    • 2 Pages

    13) A data warehouse also contains a special database that stores the ________, which records the data’s source, history, format and constraints. Page 283…

    • 352 Words
    • 2 Pages
    Satisfactory Essays
  • Best Essays

    Data Warehousing and Olap

    • 2507 Words
    • 11 Pages

    In the 1990s, as businesses grew more complex, corporation spread globally, and competition became fiercer, business executives became desperate for information to stay competitive and improve the bottom line. Data warehousing technologies have been successfully deployed in many industries: manufacturing (for order shipment and customer support), retail (for user profiling and inventory management), financial services (for claims analysis, risk analysis, credit card analysis, and fraud detection), transportation (for fleet management), telecommunications (for call analysis and fraud detection), utilities (for power usage analysis), and healthcare (for outcomes analysis). This paper presents a roadmap of data warehousing technologies, focusing on the special requirements that data warehouses place on database management systems (DBMSs).…

    • 2507 Words
    • 11 Pages
    Best Essays
  • Satisfactory Essays

    Designations used by companies to distinguish their products are often claimed as trademarks. In all instances…

    • 166945 Words
    • 668 Pages
    Satisfactory Essays