Technique of Efficiently, Comprehensively and Autonomously Support Native JSON Datatype in Rdbms for Both Oltp & Olap

2. The method of claim 1 further comprising using a virtual column of the database table to access an index for at least one JSON document of the plurality of JSON documents.

4. The method of claim 1 further comprising generating an index for at least one JSON document of the plurality of JSON documents, wherein the index comprises at least one selected from the group consisting of: a bitmap, an inverted index, a path and value index, a text index, and an index of a subset of the plurality of JSON documents that are loaded into memory.

6. The method of claim 1 wherein each document of the plurality of JSON documents is individually persisted with at least one selected from the group consisting of: compression, encryption, and i-nodes that do not store multiple documents.

7. The method of claim 1 further comprising the DBMS modifying a portion of a JSON document of the plurality of JSON documents without entirely replacing the JSON document.

9. The method of claim 7 wherein said modifying the portion of the JSON document comprises generating redo data only for said portion of the JSON document.

10. The method of claim 1 further comprising generating a database view that contains a table column that is based on a field that is common to the plurality of JSON documents.

14. The method of claim 1 further comprising driving a lifecycle of an index for at least one JSON document of the plurality of JSON documents by generating the index without receiving a query.

15. The method of claim 1 further comprising driving a lifecycle of an index for at least one JSON document of the plurality of JSON documents by generating the index in response to receiving a query.

16. The method of claim 1 further comprising driving a lifecycle of an index for at least one JSON document of the plurality of JSON documents by generating the index in response to loading an in memory columnar unit (IMCU).

17. The method of claim 1 further comprising driving a lifecycle of an index for at least one JSON document of the plurality of JSON documents by generating the index as a path and value index for an in memory expression unit (IMEU).

18. The method of claim 1 further comprising driving a lifecycle of an index for at least one JSON document of the plurality of JSON documents by generating the index based on access statistics for the plurality of JSON documents.

19. The method of claim 1 further comprising driving a lifecycle of an index for at least one JSON document of the plurality of JSON documents by generating the index when available memory exceeds a threshold.

20. The method of claim 1 further comprising operating an index for at least one JSON document of the plurality of JSON documents, including returning sorted values.

21. The method of claim 1 further comprising operating an index for at least one JSON document of the plurality of JSON documents, including invoking a SQL operator that uses the JSON datatype that is native in the DBMS.

22. The method of claim 1 further comprising operating an index for at least one JSON document of the plurality of JSON documents, including invoking a user defined function (UDF).

24. The one or more non-transitory computer-readable media of claim 23 wherein the instructions further cause generating a database view that contains a table column that is based on a field that is common to the plurality of JSON documents.

25. The one or more non-transitory computer-readable media of claim 23 wherein the instructions further cause using a virtual column of the database table to access an index for at least one JSON document of the plurality of JSON documents.

26. The one or more non-transitory computer-readable media of claim 23 wherein the instructions further cause driving a lifecycle of an index for at least one JSON document of the plurality of JSON documents by discarding the index based on dynamic conditions.

27. The one or more non-transitory computer-readable media of claim 23 wherein the instructions further cause generating an index for at least one JSON document of the plurality of JSON documents, wherein the index comprises at least one selected from the group consisting of: a bitmap, an inverted index, a path and value index, a text index, and an index of a subset of the plurality of JSON documents that are loaded into memory.

28. The one or more non-transitory computer-readable media of claim 23 wherein the instructions further cause operating an index for at least one JSON document of the plurality of JSON documents, including evaluating an expression that is at least one selected from the group consisting of: compound and references multiple fields of the plurality of JSON documents.

29. The one or more non-transitory computer-readable media of claim 23 wherein each document of the plurality of JSON documents is individually persisted with at least one selected from the group consisting of: compression, encryption, and i-nodes that do not store multiple documents.

30. The one or more non-transitory computer-readable media of claim 23 wherein the instructions further cause the DBMS modifying a portion of a JSON document of the plurality of JSON documents without entirely replacing the JSON document.

31. The one or more non-transitory computer-readable media of claim 30 wherein said modifying the portion of the JSON document comprises copying-on-write.

32. The one or more non-transitory computer-readable media of claim 30 wherein said modifying the portion of the JSON document comprises generating redo data only for said portion of the JSON document.

36. The one or more non-transitory computer-readable media of claim 23 wherein the instructions further cause driving a lifecycle of an index for at least one JSON document of the plurality of JSON documents by generating the index without receiving a query.

37. The one or more non-transitory computer-readable media of claim 23 wherein the instructions further cause driving a lifecycle of an index for at least one JSON document of the plurality of JSON documents by generating the index in response to receiving a query.

38. The one or more non-transitory computer-readable media of claim 23 wherein the instructions further cause driving a lifecycle of an index for at least one JSON document of the plurality of JSON documents by generating the index in response to loading an in memory columnar unit (IMCU).

39. The one or more non-transitory computer-readable media of claim 23 wherein the instructions further cause driving a lifecycle of an index for at least one JSON document of the plurality of JSON documents by generating the index as a path and value index for an in memory expression unit (IMEU).

40. The one or more non-transitory computer-readable media of claim 23 wherein the instructions further cause driving a lifecycle of an index for at least one JSON document of the plurality of JSON documents by generating the index based on access statistics for the plurality of JSON documents.

41. The one or more non-transitory computer-readable media of claim 23 wherein the instructions further cause driving a lifecycle of an index for at least one JSON document of the plurality of JSON documents by generating the index when available memory exceeds a threshold.

42. The one or more non-transitory computer-readable media of claim 23 wherein the instructions further cause operating an index for at least one JSON document of the plurality of JSON documents, including returning sorted values.

43. The one or more non-transitory computer-readable media of claim 23 wherein the instructions further cause operating an index for at least one JSON document of the plurality of JSON documents, including invoking a SQL operator that uses the JSON datatype that is native in the DBMS.

44. The one or more non-transitory computer-readable media of claim 23 wherein the instructions further cause operating an index for at least one JSON document of the plurality of JSON documents, including invoking a user defined function (UDF).