August 2009
Intermediate to advanced
893 pages
26h 48m
English
Content preview from Database Systems: Concepts, Design and Applications
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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, ...