Autonomous Temporal Transaction Database

The data amount to be handled, managed, and evaluated is enormous. Intelligent information systems need to cover not just conventional data types. The whole evolution should be addressed instead. Cloud environment offers a wide range of opportunities pointing to the scalability of the solution. Oracle Cloud databases are based on the autonomous processing of the system administration done by machine learning and artificial intelligence. Autonomous database processing core element states mainly just the transaction control of the current valid states. In this paper, we deal with the temporal architectures pointing to the object, attribute and synchronization group granularity. The internal representation must be currently defined by the user explicitly. Our proposed solution is fully autonomous, covered by the Oracle Cloud technology. User just register the structure to be managed temporaly, granularity is maintained by the system, following the complexity and scalability of the solution. Data management is extended by the Granularity strategy management module to ensure either storage efficiency, as well as the format of the query result set. Introduced DBMS_AUT_TEMPORALITY package registers the data to the temporal sphere and limits the historical data reflecting the information value.