Understand Your Data with Use Case Domains and Annotations in Oracle Database 23ai

Data have many common use cases like currencies, addresses, and credit card numbers. These values should be handled in the same way throughout the database and across apps. 

However, stored in a database they become just numbers, strings, or dates. This loses the use case context and makes consistent handling challenging.

Oracle Database 23ai simplifies this with use case domains and schema annotations. 

Domains allow you to extend basic data types with data defaults, constraints, and sorting rules to create standard definitions you can apply to columns. Annotations let you add metadata to database objects, sharing intent information across apps and ensuring consistent handling. Watch to learn how these help to standardize your data definitions.

Highlights include:

04:40 - Oracle Database 23ai

05:55 - Example retail schema with values common to many tables

07:25 - The challenges with rich type systems

12:20 - Insert_timestamp definition

14:25 - Schema annotations; name-value metadata

16:00 - Demo of schema annotations

20:05 - Data use case domains

23:25 - Email address domains

27:25 - Lists of values with enum domains

29:50 - Demo of use case domains

45:00 - Define currency values with multicolumn domains

50:00 - Display and order rules for domains

51:50 - Postal addresses with flexible domains

56:50 - Demo of multicolumn and flexible domains