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 76 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
Gracias!

elyse44

  • Member
  • Posts: 319
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

The average office desk has 400 times more bacteria on it than a toilet.

Did you know?

Though the United States has largely rejected the metric system, it is used for currency, as in 100 pennies = 1 dollar. Previously, the British currency system was used, with measurements such as 12 pence to the shilling, and 20 shillings to the pound.

Did you know?

A good example of polar molecules can be understood when trying to make a cake. If water and oil are required, they will not mix together. If you put them into a measuring cup, the oil will rise to the top while the water remains on the bottom.

Did you know?

After 5 years of being diagnosed with rheumatoid arthritis, one every three patients will no longer be able to work.

Did you know?

Fatal fungal infections may be able to resist newer antifungal drugs. Globally, fungal infections are often fatal due to the lack of access to multiple antifungals, which may be required to be utilized in combination. Single antifungals may not be enough to stop a fungal infection from causing the death of a patient.

Zonal wind speeds on Uranus. Shaded areas show the southern collar and its future northern counterpa Zonal wind speeds on Uranus. Shaded areas show the southern collar and its future northern counterpa
Operational Definitions Operational Definitions
Organ systems affected by cystic fibrosis Organ systems affected by cystic fibrosis
Comparing root systems Comparing root systems
Energy homeostasis is regulated primarily by the brain, gastrointestinal tract, other organ systems, Energy homeostasis is regulated primarily by the brain, gastrointestinal tract, other organ systems,
Video: Antidiuretic hormone (vasoconstriction, water reabsorption & sweat inhibition)

For a complete list of videos, visit our video library