« previous next »

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

HCHenry

  • Hero Member
  • *****
  • Posts: 591
on: Jul 7, 2018
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
Reply #1 on: Jul 7, 2018
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
« previous next »
 

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates’s recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

It is important to read food labels and choose foods with low cholesterol and saturated trans fat. You should limit saturated fat to no higher than 6% of daily calories.

Did you know?

Oxytocin is recommended only for pregnancies that have a medical reason for inducing labor (such as eclampsia) and is not recommended for elective procedures or for making the birthing process more convenient.

Did you know?

Always store hazardous household chemicals in their original containers out of reach of children. These include bleach, paint, strippers and products containing turpentine, garden chemicals, oven cleaners, fondue fuels, nail polish, and nail polish remover.

Did you know?

More than 20 million Americans cite use of marijuana within the past 30 days, according to the National Survey on Drug Use and Health (NSDUH). More than 8 million admit to using it almost every day.

Function and structure of aquaporin Function and structure of aquaporin
Detailed aquaporin structure. Detailed aquaporin structure.
Human Structure Human Structure
Wet table and Vichy shower in a wet room. Wet table and Vichy shower in a wet room.
Structure of the proteasome Structure of the proteasome
How to create a table of values displaying commission and earnings (Question 1) How to create a table of values displaying commission and earnings (Question 1)
Video: Cerebral Cortex Animation

For a complete list of videos, visit our video library