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 7.4

• @array GraphQL directive 10.1

• @cast GraphQL directive 10.1

• @delete annotation (GraphQL) 3.2

• @delete GraphQL directive 10.1

• @flex annotation 7.4

• @flex GraphQL directive 10.1

• @generated GraphQL directive 10.1

• @hidden GraphQL directive 10.1

• @insert annotation (GraphQL) 3.2

• @insert GraphQL directive 10.1

• @link GraphQL directive 3.2, 10.1, 10.1.1

• @nest GraphQL directive 10.1

• @nodelete GraphQL directive 10.1

• @noinsert GraphQL directive 10.1

• @noupdate GraphQL directive 10.1

• @object GraphQL directive 10.1

• @unnest GraphQL directive 3.2, 10.1

• @update annotation (GraphQL) 3.2

• @update GraphQL directive 10.1

---

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

  • @delete (GraphQL) 3.2

  • @flex (GraphQL) 7.4

  • @insert (GraphQL) 3.2

  • @update (GraphQL) 3.2

  • AS FLEX (SQL) 7.4

  • ETAG 4.1, 7.3, 7.4

  • updatability 4.1, 7.3, 7.4

• application migration to using duality views 2

• AS FLEX annotation 7.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: ETAG and object ID 3

• column types in tables underlying duality views 2.3

• comment, GraphQL 3.2

• complex or simple underlying data 7.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, duality view 9

  • notification 9.1, 9.1.1, 9.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

  • filtering included table rows 3.3

  • JSON schema 5.7

  • motivation 1.2

  • overview 1

  • privileges needed for updating 4.3

  • rules for updating 4.4

• duality view directives 9

  • notification 9.1, 9.1.1, 9.1.2

• 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 7, 7.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 column for ETAG value 3

• ETAG hidden duality-view column for ETAG value 5.4.1

• ETAG table-row value 5.4

• ETAG value, document-version identifier 3

• evolution, schema 7.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 7.4

  • asof, system change number (SCN) 3

    • ensuring read consistency 5.5

  • etag, version identifier 3

    • controlling concurrency 5.4

• flex column

  • definition 7.2

  • details 7.4

• flex-column, field-naming conflicts 7.4

• flexibility, schema 7.1, 7.2, 7.3, 7.4

• foreign key, definition 2.3

• Formula 1 example 2

• function SYS_ROW_ETAG, optimistic concurrency control 5.4

---

G

• generated JSON fields 8

  • read 8.1

  • write 8.2

• generation functions, SQL/JSON 3

• GraphQL

  • comment 3.2

  • creating car-racing duality views 3.2

  • creating duality views 10

  • optional bracket syntax for duality view defintion 3.2

• GraphQL directives

  • @array 10.1

  • @cast 10.1

  • @delete 10.1

  • @flex 10.1

  • @generated 10.1

  • @hidden 10.1

  • @insert 10.1

  • @link 3.2, 10.1, 10.1.1

  • @nest 10.1

  • @nodelete 10.1

  • @noinsert 10.1

  • @noupdate 10.1

  • @object 10.1

  • @unnest 3.2, 10.1

  • @update 10.1

---

H

• hidden columns for ETAG and object ID 3

• hidden JSON fields 8, 8.1, 8.2

---

I

• identifying column, definition 2.3

• identity column, definition 6

• indentifying column, definition 2.1, 3

• inline augmentation 8

  • read 8.1

  • write 8.2

• 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, 7, 7.1, 7.3, 7.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

  • use to validate JSON-column data 1.2, 2.3, 7.1, 7.3, 7.4

• JSON Schema 1.2, 5.3, 7.1, 7.3, 7.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 7.1

  • OBJECT 7.4

• 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 7, 7.2, 7.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 7.4

• nesting 3.4

• NOCHECK annotation (ETAG calculation) 4.2

• NODELETE annotation 4.1

• NOINSERT annotation 4.1

• normalization, degree/granularity 7.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 augmentation

  • inline 8.1

• read consistency, ensuring 5.5

• relational data as starting point 1.1

• relational mapping from objects/documents 1.3

• RESID hidden column for document identifier 3

• RESID hidden duality-view column for document identifier 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

  • description of duality view 5.7

  • use to validate JSON-column data 1.2, 2.3, 5.3, 7.1, 7.3, 7.4

• schema evolution 7.4

• schema flexibility 7.1, 7.2, 7.3, 7.4

• SCN

  • See: system change number

• secondary key 2.3

• security 1.4

• sharing JSON data among documents 1.2, 7

  • 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 7, 7.1, 7.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

• unnesting 3.4

• 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

• write augmentation

  • inline 8.2