Oracle Database 23c Domains and Annotations

Application Usage DomainsThe 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 AnnotationsAnnotations 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.

Outline

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

Prerequisites

DBA experience with Oracle Database 11g through 19c.

Objectives

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

#SELECTION#

#ICON_HTML#

Less coding using new SQL Domains in 23c (Blog)

#MISC#

#ACTIONS#
#SELECTION#

#ICON_HTML#

Annotations - The new metadata in 23c (Blog)

#MISC#

#ACTIONS#

Featured Speakers

Session Has Completed - 29 February 2024

Duration

1 Hour

Series Name

Location:

English

Audience

Analyst, Architect, Database Administrator, Developer

Products

Database 26ai

Featured Speaker Translation

Featured Speakers

Featured Speaker Translation

Join

Featured Speaker Translation

English

Featured Speaker Translation

Unregister

Featured Speaker Translation

Outline

Featured Speaker Translation

Objectives

Featured Speaker Translation

Resources

Featured Speaker Translation

29 February 2024

Featured Speaker Translation

Session Has Completed - 29 February 2024

Featured Speaker Translation

Session has been cancelled

Featured Speaker Translation

You Are A Speaker/Panelist

Featured Speaker Translation

1 Hour

Featured Speaker Translation

Pending

Featured Speaker Translation

Prerequisites

Featured Speaker Translation

Waitlisted

Featured Speaker Translation

Rejected

Featured Speaker Translation

Question And Answer

Featured Speaker Translation

Analyst, Architect, Database Administrator, Developer

Featured Speaker Translation

Add To Calendar

Featured Speaker Translation

Registration Status

Featured Speaker Translation

Series Name

Featured Speaker Translation

Session Time

Featured Speaker Translation

You Are Registered. You Will Be Able To Join The Session 15 Minutes Before It Starts.

Oracle Database 23c Domains and Annotations

Resources

Less coding using new SQL Domains in 23c (Blog)

Annotations - The new metadata in 23c (Blog)

Featured Speakers

Workshop Info

Hidden Translations