Author Question: In Microsoft SQL Server creating a table structure is accomplished using which of the following? ... (Read 36 times)

HCHenry

  • Hero Member
  • *****
  • Posts: 591
In Microsoft SQL Server creating a table structure is accomplished using which of the following?
 
  A) Diagrams B) Stored procedures
  C) Tables D) Views

Question 2

Describe online analytical processing.
 
  What will be an ideal response?



juicepod

  • Sr. Member
  • ****
  • Posts: 310
Answer to Question 1

C

Answer to Question 2

Online analytical processing (OLAP) refers to the process of quickly conducting complex, multidimensional analyses of data stored in a database that is optimized for retrieval, typically using graphical software tools. OLAP tools enable users to analyze different dimensions of data beyond simple data summaries and data aggregations of normal database queries.

The chief component of an OLAP system is the OLAP server, which understands how data is organized in the database and has special functions for analyzing the data. The use of dedicated databases allows for tremendous increases in retrieval speed. OLAP systems preaggregate data so that only the subset of the data necessary for the queries is extracted, greatly improving performance.

OLAP systems are designed for efficient retrieval of data and categorize data as measures and dimensions. Measures, sometimes called facts, are the values or numbers the user wants to analyze, such as the sum of sales or the number of orders placed. Dimensions provide a way to summarize the data, such as region, time, or product line. To enable these multidimensional analyses, OLAP arranges the data as so-called cubes. An OLAP cube is a data structure allowing for multiple dimensions to be added to a traditional two-dimensional table. Analyzing the data on subsets of the dimensions is referred to as slicing and dicing.



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

According to research, pregnant women tend to eat more if carrying a baby boy. Male fetuses may secrete a chemical that stimulates their mothers to step up her energy intake.

Did you know?

The B-complex vitamins and vitamin C are not stored in the body and must be replaced each day.

Did you know?

Sperm cells are so tiny that 400 to 500 million (400,000,000–500,000,000) of them fit onto 1 tsp.

Did you know?

Children with strabismus (crossed eyes) can be treated. They are not able to outgrow this condition on their own, but with help, it can be more easily corrected at a younger age. It is important for infants to have eye examinations as early as possible in their development and then another at age 2 years.

Did you know?

Despite claims by manufacturers, the supplement known as Ginkgo biloba was shown in a study of more than 3,000 participants to be ineffective in reducing development of dementia and Alzheimer’s disease in older people.

For a complete list of videos, visit our video library