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, ...
Get Database Systems: Concepts, Design and Applications now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
