Effective restriction of the data manipulation operations in Oracle Database

Abstract

Relational theory is built on the foundation of four main operations manipulating data – Insert, Update, Delete and Select providing the data retrieval. However, many times, it is necessary to limit operations changing existing data, forming the concept of the insert-only tables. This paper evaluates performance of individual solutions by creating a methodology of data management and manipulation, which is a critical part of the complex data management and big data term of the intelligent transport systems, pointing to the security option. It drives you through the data level protection, privileges, up to immutable tables and retention periods. The evaluation study environment takes Oracle Database 23ai.

Keywords

• oracle database
• analytics
• insert-only tables
• immutable table
• trigger