Question

Which compromise recognizes that enterprise databases exist in a finite storage space and also recognizes that the larger the size of the database, the less efficient querying becomes?

1) Event activity (or event history) roll-up
2) Storage of derivable attributes
3) Combined entity key posting
4) Consolidation of conceptually congruent event activities

Answer 1

The event activity roll-up is the compromise that deals with finite storage space in enterprise databases and the need for efficient querying by summarizing historical data.

Step-by-step explanation:

The compromise that recognizes that enterprise databases exist in a finite storage space and that larger databases can lead to less efficient querying is known as the event activity (or event history) roll-up. This approach involves periodically aggregating historical data, which reduces the detail for older transactions. By summarizing or 'rolling up' this data, the size of the database can be managed more effectively, which in turn can help maintain database performance. This strategy balances the need for historical data with the necessity of preserving storage space and query efficiency.