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