Preview

Datawearhousing

Satisfactory Essays
Open Document
Open Document
1743 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Datawearhousing
COMP9318 (12S1) ASSIGNMENT 1
DUE ON 23:59 21 APR, 2012 (SAT)
Q1. (30 marks)

Consider the restaurant section of http://www.eatability.com.au. One of the basical functionality is that a registered user can rate restaurants. E.g., look at the \Add a Review for 168_" part at http://www.eatability.com.au/au/sydney/168/.

You were asked to help the company to design a star schema to analyze various ratings on restaurants. You also need to list or draw hierarchies associated with each dimension. You only need to show up to three hierarchies for any dimension.1

Write down an MDX query that lists the top-5 restaurants in NSW in terms of food scores in 2011; for each of the restaurant listed, display their scores (food, service,
. . . ).

SELECT { Measures.[Food_rate], Measures.[Ambience_rate], Measures.[Service_rate],Measures.[Value_rate] } ON COLUMNS
HEAD( ORDER({[ Restaurant ].[ Australia ].[ Sydney ].[NSW].MEMBERS},
Measures.[Food_rate],
BDESC ),5
)ON ROWS
FROM [ Review]
WHERE [Calendar].[2011]

Q2. (20 marks)
Consider the following base cuboid Sales with three tuples and the aggregate function
SUM:

Location
Time
Item
Quantity
Sydney
2004
PS2
1400
Sydney
2005
PS2
1500
Melbourne
2004
PS2
1100
Melbourne
2005
XBox
1700

Location, Time, and Item are dimensions and Quantity is the measure. Suppose the system has built-in support for the value ALL.
(1) List the tuples in the complete data cube of R in a tabular form with 4 attributes,
i.e., Location; Time; Item; SUM(Quantity)?

Time
Item
Location
Sum(Quantity)
2004
PS2
Sydney
1400
2004
PS2
Melbourne
1100
2004
ALL
Sydney
1400
2004
ALL
Melbourne
1100
2004
ALL
ALL
2500
2004
PS2
ALL
2500
2005
PS2
Sydney
1500
2005
XBOX
Melbourne
1700
2005
ALL
Sydney
1500
2005
ALL
Melbourne
1700
2005
ALL
ALL
3200
2005
PS2
ALL
1500
2005
XBOX
ALL
1700
ALL
PS2
Sydney
2900
ALL

You May Also Find These Documents Helpful

  • Better Essays

    Law 531 Case 5.1

    • 1237 Words
    • 5 Pages

    It was stated that each restaurant in the guide was ranked based upon calculated surveys of customers of the restaurant, and the Zagat guide often quotes anonymous consumer comments.…

    • 1237 Words
    • 5 Pages
    Better Essays
  • Satisfactory Essays

    Data Comm

    • 501 Words
    • 3 Pages

    1) When you promoted your server to domain controller and installed DHCP, what would happen if there was another domain controller already on this network?…

    • 501 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    By researching the customer’s perception of the restaurant one will see how the customer chooses the restaurant desired, how important performance is to the customer, and what was the overall satisfactory. One can acquire such information by reviewing and discussing the survey, finding out what is most or least important to the customer, seeing what is expected on how the restaurant performs, and discussing the satisfaction of the customer.…

    • 2397 Words
    • 10 Pages
    Powerful Essays
  • Powerful Essays

    Compiled information gathered from the interview and references. In this phase were able to plan, analyze and create a design for the proposed system. Through this by the use of the data gathered to plan and create a system.…

    • 3231 Words
    • 13 Pages
    Powerful Essays
  • Satisfactory Essays

    Primary Key

    • 438 Words
    • 3 Pages

    2. For each of the entities identified, design tables and identify the possible candidate keys,…

    • 438 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Case Study

    • 540 Words
    • 3 Pages

    Assume you have been asked to help analyze the data and to make recommendations for improvement. Analyze the data using the checklist, a Pareto diagram, and run charts. Then construct a cause and diagram for the leading category on your Pareto diagram. Based on your analysis, prepare a list of recommendations that will address customer complaints.…

    • 540 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    The above tables show the data at different degrees of summarization. In the data warehousing research literature, a data cube such as each of the above is referred to as a cuboid. Given a set of dimensions, we can construct a lattice of cuboids, each showing the data at a different level of summarization, or group by (i.e., summarized by a different subset of the dimensions). The lattice of cuboids is then referred to as a data cube. The following figure shows a lattice of cuboids forming a data cube for the dimensions time, item, location, and supplier.…

    • 1086 Words
    • 5 Pages
    Good Essays
  • Good Essays

    Educational Datawarehouse

    • 7812 Words
    • 32 Pages

    INTRODUCTION ........................................................................................................ 1 1.1 THE WORKING MISSION ............................................................................................1 1.2 OVERVIEW OF THE NCCCS........................................................................................1 1.3 NCCCS P ROGRAMS ..................................................................................................1 1.5 DEFINING THE P ROBLEM ............................................................................................2 SCOPE AND OBJECTIVES......................................................................................... 3 2.1 SOLUTION OVERVIEW ................................................................................................3 2.2…

    • 7812 Words
    • 32 Pages
    Good Essays
  • Good Essays

    Milk and Checkout Line

    • 415 Words
    • 2 Pages

    Assume you have been asked to help analyze the data and to make recommendations for improvement. Analyze the data using the checklist, a Pareto diagram, and run charts. Then construct a cause-and-effect diagram for the leading category on your Pareto diagram. Based on your analysis, prepare a list of recommendations that will address customer complaints.…

    • 415 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Data Comm

    • 1106 Words
    • 5 Pages

    In order to access the internet, we need a computer software that is called web browser. Web browser is a must-have software in every PC or Laptops. Nowadays, there are more than a dozen alternative web browser we can use but the famous web browser that we all know are Google Chrome, Mozilla Firefox, Safari, Rockmelt and Internet Explorer. This are the example photos of the famous web browser :-…

    • 1106 Words
    • 5 Pages
    Good Essays
  • Better Essays

    The purpose of this paper is to highlight some best practices for data input and output. In addition, this paper will highlight appropriate uses of various storage means. Lastly, it will address the effect certain components of a computer have on its overall speed.…

    • 1256 Words
    • 6 Pages
    Better Essays
  • Satisfactory Essays

    1.1 There are many different risks to data security examples of the risks are theft, loss, neglect and insecure practises. Data security means to resist/protect your records and files from unauthorized users or destructive forces. I have numerous procedures to protect are data from unauthorized users are main ones are firewall protecting are network and computers from being hacked. Another one is that only certain users can get access to these sensitive systems, these users have their own personal passwords but even when they are logged on they can only get access to the data if they have the second password for system we used to store and protect are data.…

    • 443 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Data Internpretation

    • 718 Words
    • 3 Pages

    Directions: The following table shows the particulars regarding the members and the number of books issued to them in December 1992 in a city. Refer to the following to answer the question that follow.…

    • 718 Words
    • 3 Pages
    Good Essays
  • Better Essays

    DATA MANAGEMENT

    • 887 Words
    • 3 Pages

    Data mining is the process of analyzing data from different perceptions and summarizing it into useful evidence that can be used to increase revenue, cut costs or both. Data mining software is one of a number of analytical tools for analyzing data. It allows users to analyze data from many different dimensions or angles, categorize it and summarize the relationships identified. Association, Clustering, predictions and sequential patterns, decision trees and classification are the data mining techniques. It is a promising and relatively new technology. Data mining is defined as a process of discovering hidden valuable knowledge of analyzing large amounts of data, which is stored in databases or data warehouse, using various data mining techniques such as machine learning, artificial intelligence and statistical.…

    • 887 Words
    • 3 Pages
    Better Essays
  • Satisfactory Essays

    MANAGING DATA RESOURCES

    • 1048 Words
    • 18 Pages

    c h a p t e r 7 MANAGING DATA RESOURCES 7.1 © 2002 by Prentice Hall LEARNING OBJECTIVES • COMPARE TRADITIONAL FILE ORGANIZATION & MANAGEMENT TECHNIQUES • DESCRIBE HOW DATABASE MANAGEMENT SYSTEM ORGANIZES INFORMATION * 7.2 © 2002 by Prentice Hall LEARNING OBJECTIVES • IDENTIFY TYPES OF DATABASE, PRINCIPLES OF DATABASE DESIGN • DISCUSS DATABASE TRENDS * 7.3 © 2002 by Prentice Hall MANAGEMENT CHALLENGES • TRADITIONAL DATA FILE ENVIRONMENT • DATABASE APPROACH TO DATA MANAGEMENT • CREATING DATABASE ENVIRONMENT • DATABASE TRENDS * 7.4 © 2002 by Prentice Hall MANAGEMENT CHALLENGES 1.…

    • 1048 Words
    • 18 Pages
    Satisfactory Essays