Building Temporal Architecture on Transaction Logs

Conventional databases are related to the relational paradigm and store current valid data. It means that any change operation replaces original state. History cannot be directly obtained, however, transaction logs and internal change vectors can offer the ability to construct states, as they existed in the past. Flashback technology introduced in Oracle database is primarily intended for security, reliability, consistency, and recovery. The process of obtaining historical images can be strongly resource demanding. Our proposed solution enhances transaction logs by indexing them, delimited by the data pointers. Thanks to that, processing time and costs can be significantly reduced. Users deal only with conventional layer, historical data are automatically available through the effective log handling.

conventional paradigm, relational data, transaction logs, indexing, performance

1. A. Abhinivesh and N. Mahajan, “The Cloud DBA-Oracle,” Apress, 2017.

2. L. Anders, “Cloud computing basics,” Apress, 2021.

3. T. Cunningham, “Sharing and Generating PrivacyPreserving Spatio-Temporal Data Using Real-World Knowledge,” In 23rd IEEE International Conference on Mobile Data Management, Cyprus, 2022.

4. E. S. Chan, D. Gawlick, A. Ghoneimy and Z. H. Liu, "Situation aware computing for big data," 2014 IEEE International Conference on Big Data (Big Data), Washington, DC, USA, 2014, pp. 1-6, doi: 10.1109/BigData.2014.7004415.

5. J. Heller, “Pro Oracle SQL Development: Best Practices for Writing Advanced Queries”, Apress, 2022

6. S. Idreos, S. Manegold, and G. Graefe, “Adaptive indexing in modern database,” In ACM International Conference Proceeding Series, 2012.

7. J. Janáček and M. Kvet, “Shrinking fence search strategy for p-location problems,” In 2020 IEEE 20th International Symposium on Computational Intelligence and Informatics (CINTI), Hungary, 2020.

8. D. Kuhn, S. Alapati, B. Padfield, “Expert Oracle Indexing and Access Paths: Maximum Performance for Your Database”, Apress, 2016

9. D. Kuhn and T. Kyte, “Expert Oracle Database Architecture: Techniques and Solutions for High Performance and Productivity,” Apress, 2021.

10. D. Kuhn and T. Kyte, “Oracle Database Transactions and Locking Revealed: Building High Performance Through Concurrency“, Apress, 2020

...