Index

Symbols  Numerics  A  B  C  D  E  F  G  H  I  J  L  M  N  O  P  Q  R  S  T  U  V  W  

Symbols

  • _id field, document-identifier 6
  • _id field, row-identifier 6
  • _metadata field, for document handling 3, 5.4
  • _nameConflicts field, for flex-column conflicts 8.4
  • @delete annotation (GraphQL) 3.2
  • @flex annotation 8.4
  • @flex GraphQL directive 9.1
  • @generated GraphQL directive 9.1
  • @hidden GraphQL directive 9.1
  • @insert annotation (GraphQL) 3.2
  • @link GraphQL directive 3.2, 9.1, 9.1.1
  • @nest GraphQL directive 9.1
  • @unnest GraphQL directive 3.2, 9.1
  • @update annotation (GraphQL) 3.2

Numerics

  • 1:1 entity relationships 2.2
  • 1:N entity relationships 2.2

A

  • ALL_JSON_DUALITY_VIEW_TAB_COLS view 5.7
  • ALL_JSON_DUALITY_VIEW_TABS view 5.7
  • ALL_JSON_DUALITY_VIEWS view 5.7
  • annotations
  • application migration to using duality views 2
  • AS FLEX annotation 8.4
  • asof field, system change number (SCN) 3
    • ensuring read consistency 5.5
  • associative table
    • See: mapping table

B

  • bracket, optional GraphQL syntax for duality view defintion 3.2
  • bridge table
    • See: mapping table

C

  • car-racing example 2
    • creating duality views with GraphQL 3.2
    • creating duality views with SQL 3.1
    • creating tables 2.3
    • duality views 3
    • entity relationships 2.2
  • case-sensitivity
    • JSON and SQL
  • CHECK annotation (ETAG calculation) 4.2
  • columns (hidden) for duality-view, ETAG and object ID 3
  • column types in tables underlying duality views 2.3
  • comment, GraphQL 3.2
  • complex or simple underlying data 8.3
  • composite primary and foreign keys, definition 2.3
  • concurrency, controlling 5.4, 5.4.1
  • content-based ETAG concurrency control, definition 5.4
  • converged database, definition 1.5
  • CREATE JSON RELATIONAL DUALITY VIEW 3
    • WHERE clause 3.3
  • creating duality views 3
    • over existing relational data 1.1

D

  • DATA JSON-type column for duality-view documents 3
  • DATA payload JSON-type column supported/generated by a duality view 3, 5.6
  • data types of columns in tables underlying duality views 2.3
  • DBA_JSON_DUALITY_VIEW_TAB_COLS view 5.7
  • DBA_JSON_DUALITY_VIEW_TABS view 5.7
  • DBA_JSON_DUALITY_VIEWS view 5.7
  • DBMS_JSON_DUALITY.begin_transaction PL/SQL procedure 5.4.1
  • DBMS_JSON_DUALITY.commit_transaction PL/SQL procedure 5.4.1
  • DBMS_JSON_DUALITY.register PL/SQL procedure 5.4.1
  • DBMS_JSON_SCHEMA.describe PL/SQL function 1.2, 5.7
  • DELETE annotation 4.1
  • deleting documents 5.2
  • describe PL/SQL function, package DBMS_JSON_SCHEMA 1.2, 5.7
  • dictionary views 1.2
  • directives, GraphQL
    • See: GraphQL directives
  • document
    • deleting 5.2
    • inserting 5.1
    • optimizing operations 5.6
    • querying 5.6
    • updating 5.3
  • document/table duality, definition 1, 1.3
  • document-centric use of duality views 1.2
  • document collection supported by a duality view, definition 1
  • document-handling field, _metadata 3, 5.4
  • document-identifer field, _id 6
  • document-identifier field, car-racing example 2.1
  • document key
    • definition 3
  • document migration to duality views 2
  • document-relational mapping (DRM), definition 1.3
  • documents, car-racing example 2.1
  • documents supported by a duality view, definition 1
  • document-version identifier (ETAG)
    • controlling concurrency 5.4
  • document-version identifier (ETAG value) 3
  • driver_race_map table 2.3
  • driver and race mapping table 2.3
  • driver document 2.1
  • driver duality view 3
    • creating with GraphQL 3.2
    • creating with SQL 3.1
    • JSON schema 5.7
  • driver entity 2.2
  • driver table 2.3
  • d-r-map entity 2.3
  • duality, document/table 1.3
    • definition 1
  • duality view
    • creation 3
    • definition 1, 1.2
    • JSON schema 5.7
    • motivation 1.2
    • overview 1
    • privileges needed for updating 4.3
    • rules for updating 4.4
  • duality view operations 5
  • duality views for car-racing example 3
    • creating with GraphQL 3.2
    • creating with SQL 3.1

E

  • embedding JSON-column values in documents 8, 8.1
  • entity relationships 2.2
  • ETAG document-version identifier
    • controlling concurrency 5.4
    • not used for partial updates 5.3
  • etag field, version identifier 3
    • controlling concurrency 5.4
  • ETAG hash-value participation, defining 4.2
  • ETAG hidden duality-view column for ETAG value 3, 5.4.1
  • ETAG table-row value 5.4
  • ETAG value, document-version identifier 3
  • evolution, schema 8.4
  • existing relational data as starting point 1.1

F

  • fields
    • _id, document-identifier 6
    • _id, row-identifier 6
    • _metadata, for document handling 3, 5.4
    • _nameConflicts for flex-column conflicts 8.4
    • asof, system change number (SCN) 3
      • ensuring read consistency 5.5
    • etag, version identifier 3
      • controlling concurrency 5.4
  • flex column
  • flex-column, field-naming conflicts 8.4
  • flexibility, schema 8.1, 8.2, 8.3, 8.4
  • foreign key, definition 2.3
  • Formula 1 example 2
  • function SYS_ROW_ETAG, optimistic concurrency control 5.4

G

  • generated JSON fields 7
  • generation functions, SQL/JSON 3
  • GraphQL
    • comment 3.2
    • creating car-racing duality views 3.2
    • creating duality views 9
    • optional bracket syntax for duality view defintion 3.2
  • GraphQL directives

H

  • hidden duality-view columns for ETAG and object ID 3
  • hidden JSON fields 7

I

  • identifying column, definition 2.3
  • identity column, definition 6
  • indentifying column, definition 2.1, 3
  • inline augmentation 7
  • INSERT annotation 4.1
  • inserting documents 5.1
  • item methods, used to optimize operations 5.6

J

  • JSON_SCHEMA column, dictionary views for duality views 1.2, 5.7
  • json_transform SQL function 5.3
  • json_value RETURNING clause, used to optimize operations 5.6
  • JSON data type columns in duality-view tables 1, 1.2, 8, 8.1, 8.3, 8.4
  • JSON documents, car-racing example 2.1
  • JSON-relational duality view
    • definition 1, 1.2
    • JSON schema 5.7
    • motivation 1.2
    • overview 1
  • JSON-relational duality views for car-racing example 3
    • creating with GraphQL 3.2
    • creating with SQL 3.1
  • JSON-relational mapping (JRM), definition 1.3
  • JSON schema
  • JSON Schema 1.2, 5.3, 8.1, 8.3, 8.4
    • description of duality view 5.7
  • JSON schema, use to validate JSON-column data 5.3
  • JSON-To-Duality Migrator 2
  • JSON-type column DATA, for duality-view documents 3
  • JSON type modifiers 8.1
  • JSON-type payload column DATA, supported/generated by a duality view 3, 5.6

L

  • lock-free (optimistic) concurrency control 5.4
    • definition and overview 4.2
    • duality-view transactions 5.4.1

M

  • many-to-many entity relationships 2.2
    • using mapping tables 2.3
  • many-to-one entity relationships 2.2
  • mapping objects/documents to relational 1.3
  • mapping table, definition 2.3
  • mapping table for tables driver and race 2.3
  • merging flex-column fields into documents 8, 8.2, 8.4
  • migration of document sets to duality views 2
  • MongoDB API, compatible document-identifier field _id 6
  • multitenant database, definition 1.5

N

  • N:N entity relationships 2.2
    • using mapping tables 2.3
  • naming conflicts, flex column 8.4
  • NEST SQL keyword 3.1
  • NOCHECK annotation (ETAG calculation) 4.2
  • NODELETE annotation 4.1
  • NOINSERT annotation 4.1
  • normalization, degree/granularity 8.3
  • normalized data, definition 1.2
  • normalized entity, definition 2.2
  • NOUPDATE annotation 4.1

O

  • object-document mapping (ODM) 1.3
  • object-relational mapping (ORM) 1.3
  • ODM (object-document mapping) 1.3
  • one-to-one entity relationships 2.2
  • operations on duality views 5
  • operations on tables underlying duality views 5
  • optimistic (lock-free) concurrency control 5.4
    • definition and overview 4.2
    • duality-view transactions 5.4.1
  • optimization of document operations 5.6
  • Oracle Database API for MongoDB, compatible document-identifier field _id 6
  • Oracle REST Data Services (ORDS)
    • deleting documents using REST 5.2
    • inserting documents using REST 5.1
    • updating documents using REST 5.3
  • Oracle SQL function json_transform 5.3
  • ORM (object-relational mapping) 1.3

P

  • payload JSON-type column DATA, supported/generated by a duality view 3, 5.6
  • payload of a JSON document, definition 2.1, 3, 5.4
  • PL/SQL subprograms
    • DBMS_JSON_DUALITY.begin_transaction 5.4.1
    • DBMS_JSON_DUALITY.commit_transaction 5.4.1
    • DBMS_JSON_DUALITY.register 5.4.1
  • polyglot database, definition 1.5
  • predefined fields for duality views
    • See: fields
  • pretty-printing
    • in book examples
  • primary key, definition 2.3
  • privileges needed for operations on duality-view data 4.3

Q

  • querying a duality view 5.6

R

  • race and driver mapping table 2.3
  • race document 2.1
  • race duality view 3
    • creating with GraphQL 3.2
    • creating with SQL 3.1
    • JSON schema 5.7
  • race entity 2.2
  • race table 2.3
  • read consistency, ensuring 5.5
  • relational data as starting point 1.1
  • relational mapping from objects/documents 1.3
  • RESID hidden duality-view column for document identifier 3, 5.4.1
  • REST
    • deleting documents using 5.2
    • inserting documents using 5.1
    • updating documents using 5.3
  • reusing existing relational data, for JSON documents 1.1
  • row-identifer field, _id 6
  • rules for updating duality views 4.4

S

  • schema, JSON
  • schema evolution 8.4
  • schema flexibility 8.1, 8.2, 8.3, 8.4
  • SCN
    • See: system change number
  • secondary key 2.3
  • security 1.4
  • sharing JSON data among documents 1.2, 8
    • foreign keys 2.3
  • SQL/JSON function json_value, RETURNING clause, used to optimize operations 5.6
  • SQL/JSON generation functions 3
  • SQL/JSON item methods, used to optimize operations 5.6
  • SQL function json_transform 5.3
  • static dictionary views for duality views 5.7
  • storing JSON data in underlying tables 8, 8.1, 8.3
  • support of document collection by duality view, definition 1
  • support of documents by a duality view, definition 1
  • SYS_ROW_ETAG function, optimistic concurrency control 5.4
  • system change number (SCN) field, asof 3
    • ensuring read consistency 5.5

T

  • table-centric use of duality views 1.1
  • table operations, effect on supported documents 5
  • tables
    • car-racing example 2.3
    • deleting data 5.2
    • inserting data 5.1
    • updating data 5.3
  • tables underlying duality views, column types 2.3
  • team document 2.1
  • team duality view 3
    • creating with GraphQL 3.2
    • creating with SQL 3.1
    • JSON schema 5.7
  • team entity 2.2
  • team table 2.3
  • transactions for duality views 5.4.1
  • triggers, guidelines 5.3.1
  • type-conversion item methods, used to optimize operations 5.6
  • types of columns in tables underlying duality views 2.3

U

  • unique key, definition 2.3
  • UNNEST SQL keyword 3.1
  • updatability, defining 4.1
  • UPDATE annotation 4.1
  • updating documents 5.3
  • updating duality views
    • privileges needed 4.3
    • rules 4.4
  • USER_JSON_DUALITY_VIEW_TAB_COLS view 5.7
  • USER_JSON_DUALITY_VIEW_TABS view 5.7
  • USER_JSON_DUALITY_VIEWS view 5.7

V

  • value-based ETAG concurrency control, definition 5.4
  • version-identifier field, etag 3
    • controlling concurrency 5.4
  • view, duality
    • See: duality view
  • views, static dictionary 5.7
  • views for JSON data, dictionary 1.2

W

  • WHERE clauses, duality-view tables 3.3