This topic contains a solution. Click here to go to the answer

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

panfilo

  • Hero Member
  • *****
  • Posts: 572
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
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
Thanks for the timely response, appreciate it


at

  • Member
  • Posts: 359
Reply 3 on: Yesterday
Gracias!

 

Did you know?

The most common treatment options for addiction include psychotherapy, support groups, and individual counseling.

Did you know?

Complications of influenza include: bacterial pneumonia, ear and sinus infections, dehydration, and worsening of chronic conditions such as asthma, congestive heart failure, or diabetes.

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?

Cancer has been around as long as humankind, but only in the second half of the twentieth century did the number of cancer cases explode.

Did you know?

Persons who overdose with cardiac glycosides have a better chance of overall survival if they can survive the first 24 hours after the overdose.

For a complete list of videos, visit our video library