This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: Describe the data update difference between operational and analytical database systems. What ... (Read 37 times)

panfilo

  • Hero Member
  • *****
  • Posts: 572
on: Jul 7, 2018
Describe the data update difference between operational and analytical database systems.
 
  What will be an ideal response?

Question 2

Why is the following query invalid:SELECT productname, COUNT ()FROM PRODUCT;
 
  What will be an ideal response?


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

emilymalinowski12

  • Sr. Member
  • ****
  • Posts: 338
Reply #1 on: Jul 7, 2018
Answer to Question 1

Data in operational systems is regularly updated by the users. In operational databases, in addition to issuing queries for the retrieval of data, users routinely insert, modify, and delete data. On the other hand, the end users of analytical databases are only able to retrieve data, and updates of the data by the end users are not allowed.

Answer to Question 2

The reason this query is invalid is that aggregate functions, such as COUNT(), give results across multiple records, and this result cannot be mixed with column values of individual records. The query would have worked if it ended with the 'GROUP BY productname' clause.


panfilo

  • Member
  • Posts: 572
Reply 2 on: Jul 7, 2018
Excellent

kalskdjl1212

  • Member
  • Posts: 353
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

Asthma cases in Americans are about 75% higher today than they were in 1980.

Did you know?

Studies show that systolic blood pressure can be significantly lowered by taking statins. In fact, the higher the patient's baseline blood pressure, the greater the effect of statins on his or her blood pressure.

Did you know?

A headache when you wake up in the morning is indicative of sinusitis. Other symptoms of sinusitis can include fever, weakness, tiredness, a cough that may be more severe at night, and a runny nose or nasal congestion.

Did you know?

The types of cancer that alpha interferons are used to treat include hairy cell leukemia, melanoma, follicular non-Hodgkin's lymphoma, and AIDS-related Kaposi's sarcoma.

Did you know?

Acetaminophen (Tylenol) in overdose can seriously damage the liver. It should never be taken by people who use alcohol heavily; it can result in severe liver damage and even a condition requiring a liver transplant.

The cladistic approach from molecular genetic data The cladistic approach from molecular genetic data
Attack systems of pathogenic bacteria. Attack systems of pathogenic bacteria.
Lake position in the landscape and proportion of water received as groundwater (data from Webster et Lake position in the landscape and proportion of water received as groundwater (data from Webster et
The difference between mieosis and mitoses The difference between mieosis and mitoses
The effects of aging can be seen in the decline in function of many physiological systems. The effects of aging can be seen in the decline in function of many physiological systems.
Geothermal energy and powers Earth’s systems Geothermal energy and powers Earth’s systems
Video: Membrane transport proteins - pores, gated channels and pumps

For a complete list of videos, visit our video library