Skip to Main Content

Oracle Database 23c - Application Usage Domains and Annotations

Application Usage Domains

The new domain construct can act as lightweight type modifiers that centrally document intended data usage, extending and drastically improving SQL standard domains. This allows developers to better understand how the data is used and improves overall data quality, without the complexity and incompatibility of usage-specific data types or user-defined types.

Application Usage Annotations

Annotations are additional property metadata for database objects. They are centrally stored in the database so that you can share metadata information across applications, modules, and microservices. You can use them to customize business logic, user interfaces or provide information about your database objects to your metadata repositories.

Application Usage Domains

  • Data architecture trends
  • Usage Domains Overview
  • Technical specifications
  • Examples with explanation
  • Dictionary views
  • Required privileges
  • Demo

Application Usage Annotations

  • Recommendations and top challenges
  • Annotations Overview
  • Technical details
  • Examples of DDL statements
  • Dictionary views
  • Demo

DBA experience with Oracle Database 11g through 19c.

To introduce the Application Usage Domains and Annotations in Oracle Database 23c.

Resources

Featured Speakers

  • Speaker

    Valentin Leonard Tabacaru

    Oracle
    Senior Principal Product Manager

Workshop Info

Session Has Completed - 13 September 2023
1 Hour
English
Analyst, Architect, Database Administrator, Developer
Data Intent