« previous next »

Author Question: In Microsoft SQL Server creating a table structure is accomplished using which of the following? ... (Read 79 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?

In 1864, the first barbiturate (barbituric acid) was synthesized.

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?

Though newer “smart” infusion pumps are increasingly becoming more sophisticated, they cannot prevent all programming and administration errors. Health care professionals that use smart infusion pumps must still practice the rights of medication administration and have other professionals double-check all high-risk infusions.

Did you know?

Only 12 hours after an egg cell is fertilized by a sperm cell, the egg cell starts to divide. As it continues to divide, it moves along the fallopian tube toward the uterus at about 1 inch per day.

Did you know?

According to animal studies, the typical American diet is damaging to the liver and may result in allergies, low energy, digestive problems, and a lack of ability to detoxify harmful substances.

An example of modification of a structure for a new function An example of modification of a structure for a new function
The structure and function of the renal corpuscle. The structure and function of the renal corpuscle.
Structure of hair Structure of hair
Structure of the Early Universe Structure of the Early Universe
Structure of NO3- Structure of NO3-
Table - Correlation Analysis Table - Correlation Analysis
Video: Global warming and its effect on climate change

For a complete list of videos, visit our video library