« previous next »

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

Once thought to have neurofibromatosis, Joseph Merrick (also known as "the elephant man") is now, in retrospect, thought by clinical experts to have had Proteus syndrome. This endocrine disease causes continued and abnormal growth of the bones, muscles, skin, and so on and can become completely debilitating with severe deformities occurring anywhere on the body.

Did you know?

About 80% of major fungal systemic infections are due to Candida albicans. Another form, Candida peritonitis, occurs most often in postoperative patients. A rare disease, Candida meningitis, may follow leukemia, kidney transplant, other immunosuppressed factors, or when suffering from Candida septicemia.

Did you know?

Individuals are never “cured” of addictions. Instead, they learn how to manage their disease to lead healthy, balanced lives.

Did you know?

Elderly adults are at greatest risk of stroke and myocardial infarction and have the most to gain from prophylaxis. Patients ages 60 to 80 years with blood pressures above 160/90 mm Hg should benefit from antihypertensive treatment.

Did you know?

It is believed that the Incas used anesthesia. Evidence supports the theory that shamans chewed cocoa leaves and drilled holes into the heads of patients (letting evil spirits escape), spitting into the wounds they made. The mixture of cocaine, saliva, and resin numbed the site enough to allow hours of drilling.

The subunit structure and function of the ATP synthase The subunit structure and function of the ATP synthase
Diversity within the family structure. Diversity within the family structure.
Levels of protein structure: Primary structure Levels of protein structure: Primary structure
Knead the calf muscles with both hands. Place the foot flat on the table, knee bent. Reach behind ... Knead the calf muscles with both hands. Place the foot flat on the table, knee bent. Reach behind ...
Structure of the g complex bound to DNA Structure of the g complex bound to DNA
Structure of ATP Structure of ATP
Video: How to make cDNA Animation

For a complete list of videos, visit our video library