O'Reilly logo

Database Systems: Concepts, Design and Applications by S. K. Singh

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

19.4. Operational Data versus DSS Data

Operational data and DSS data serve different purposes. Their formats and structure differ from one another. While operational data captures daily business transactions, the DSS data give tactical and strategic business meaning to the operational data. Most operational data are stored in relational database in which the structures (tables) tend to be highly normalised. The operational data storage is optimised to support transactions that present daily operations. Customer data, inventory data and so on, are frequently updated as when its status change. Operational systems store data in more than one table for effective update performance. For example, sales transaction might be represented by many tables, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required