Reference no: EM133234864

1. Consider the following description of a sample database domain.

We would like to collect the values of temperature and humidity from two sensors located in a room. We would like to save such values in one-dimensional data cube. Assume that the values collected from the sensors are always recorded in the same moment in time and always one time per minute. Later on, we would like to compute an average temperature per hour, per day, per month and per year, the highest humidity per hour, per day, per month and per year, and so on.

In a general case we would like to aggregate the measurements of humidity and temperature over time.

Use a short explanation of a database domain given above to find one-dimensional data cube that should be implemented by to record the values of temperature and humidity. In your specification of a data cube, list the facts, the measures, the names of dimensions and the hierarchies.

2. Consider the following description of a sample database domain.

We would like to collect the values of temperature and humidity from two sensors located in the rooms located in the buildings. The buildings are located at the university campuses. Each campus is located in a city. A city hosts many campuses.

We would like to save the values in two-dimensional data cube. Assume that the values collected from the sensors are always recorded in the same moment in time and always one time per minute. Later on, we would like to compute an average temperature per hour, per day, per month and per year, an average temperature per building, per campus, per city, an average temperature per day and building, per month and campus, per year and city and so on.

In a general case, we would like to aggregate the measurements of humidity and temperature over time and location.

Use a short explanation of a database domain given above to find two-dimensional data cube that should be implemented to record the values of temperature and humidity. In your specification of a data cube, list the facts, the measures, the names of dimensions and the hierarchies.

3. Consider the following description of a sample database domain.

We would like to collect the values of temperature and humidity from two sensors located in the rooms located in the buildings. The buildings are located at the university campuses. Each campus is located in a city. A city hosts many campuses.

The values obtained from the sensors are saved on the computer systems. Each value is recorded on one computer system. A computer system stores many values. The computer systems belong to the local area networks. We would like to save the values in three-dimensional data cube. Assume that the values collected from the sensors are always recorded in the same moment in time and always one time per
minute. Later on, we would like to compute an average temperature per hour, per day, per month and per year, an average temperature per building, per campus, per city, an average temperature per day and building, per month and campus, per year and city, per computer system, per local area network, per computer system and city and month, per local area network, year and campus and so on.

In a general case we would like to aggregate the measurements of humidity and temperature over time, location, and computer/network hardware used store data.

Use a short explanation of a database domain given above to find three-dimensional data cube that should be implemented by to record the values of temperature and humidity. In your specification of a data cube, list the facts, the measures, the names of dimensions and the hierarchies.