Technique of efficiently, comprehensively and autonomously support native JSON datatype in RDBMS for both OLTP and OLAP
Herein is a self-tuning database management system (DBMS) storing JavaScript object notation (JSON) documents and operating a JSON datatype as native to the DBMS. In an embodiment, a computer hosts a DBMS that executes a data definition language (DDL) statement that defines, in a database dictionary...
Gespeichert in:
| Hauptverfasser: | , , , , , , , , , , , , |
|---|---|
| Format: | Patent |
| Sprache: | eng |
| Schlagworte: | |
| Online-Zugang: | Volltext bestellen |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
| container_end_page | |
|---|---|
| container_issue | |
| container_start_page | |
| container_title | |
| container_volume | |
| creator | Arora, Vikas Abraham, Sundeep Krishnamurthy, Sriram Lu, Ying Sosa, Alfonso Colunga McMahon, Douglas J Zhang, Hui Spiegel, Joshua Liu, Zhen Hua Chang, Hui Joe Suresh, Srikrishnan Arora, Geeta Hammerschmidt, Beda C |
| description | Herein is a self-tuning database management system (DBMS) storing JavaScript object notation (JSON) documents and operating a JSON datatype as native to the DBMS. In an embodiment, a computer hosts a DBMS that executes a data definition language (DDL) statement that defines, in a database dictionary of the DBMS, a JSON document column of a database table that stores JSON documents as instances of the JSON datatype that is native in the DBMS. The DBMS may autonomously set or adjust configuration settings that control behaviors such as a default width of a JSON document column, in lining or not of the JSON document column, kind and scope and duration of indexing of the JSON document column, and/or caching of the JSON document column such as in an in memory columnar unit (IMCU). The DBMS may use the various configuration settings to control how JSON documents and the native JSON datatype are stored and/or processed. |
| format | Patent |
| fullrecord | <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_US11762834B2</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>US11762834B2</sourcerecordid><originalsourceid>FETCH-epo_espacenet_US11762834B23</originalsourceid><addsrcrecordid>eNqNjMsKgkAUQN20iOofbvtaqFFtswcRlpG2lmm8gwM6d3KuhX-fRB_Q6sDhcIbeO0NZGv1sEUgBKqWlRsNVNwNJtW2wROP0C6sOhClAtEyGampdL1xrLTUMRnBfwClNLlAIFtxZBG3gtovOKShq4EFcQhJn1-8kiTfXsTdQonI4-XHkTQ_7bHuco6UcnRUSDXJ-T31_tQzW4SIKwn-aDxNXRLU</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Technique of efficiently, comprehensively and autonomously support native JSON datatype in RDBMS for both OLTP and OLAP</title><source>esp@cenet</source><creator>Arora, Vikas ; Abraham, Sundeep ; Krishnamurthy, Sriram ; Lu, Ying ; Sosa, Alfonso Colunga ; McMahon, Douglas J ; Zhang, Hui ; Spiegel, Joshua ; Liu, Zhen Hua ; Chang, Hui Joe ; Suresh, Srikrishnan ; Arora, Geeta ; Hammerschmidt, Beda C</creator><creatorcontrib>Arora, Vikas ; Abraham, Sundeep ; Krishnamurthy, Sriram ; Lu, Ying ; Sosa, Alfonso Colunga ; McMahon, Douglas J ; Zhang, Hui ; Spiegel, Joshua ; Liu, Zhen Hua ; Chang, Hui Joe ; Suresh, Srikrishnan ; Arora, Geeta ; Hammerschmidt, Beda C</creatorcontrib><description>Herein is a self-tuning database management system (DBMS) storing JavaScript object notation (JSON) documents and operating a JSON datatype as native to the DBMS. In an embodiment, a computer hosts a DBMS that executes a data definition language (DDL) statement that defines, in a database dictionary of the DBMS, a JSON document column of a database table that stores JSON documents as instances of the JSON datatype that is native in the DBMS. The DBMS may autonomously set or adjust configuration settings that control behaviors such as a default width of a JSON document column, in lining or not of the JSON document column, kind and scope and duration of indexing of the JSON document column, and/or caching of the JSON document column such as in an in memory columnar unit (IMCU). The DBMS may use the various configuration settings to control how JSON documents and the native JSON datatype are stored and/or processed.</description><language>eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2023</creationdate><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktohtml>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20230919&DB=EPODOC&CC=US&NR=11762834B2$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,776,881,25543,76294</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20230919&DB=EPODOC&CC=US&NR=11762834B2$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>Arora, Vikas</creatorcontrib><creatorcontrib>Abraham, Sundeep</creatorcontrib><creatorcontrib>Krishnamurthy, Sriram</creatorcontrib><creatorcontrib>Lu, Ying</creatorcontrib><creatorcontrib>Sosa, Alfonso Colunga</creatorcontrib><creatorcontrib>McMahon, Douglas J</creatorcontrib><creatorcontrib>Zhang, Hui</creatorcontrib><creatorcontrib>Spiegel, Joshua</creatorcontrib><creatorcontrib>Liu, Zhen Hua</creatorcontrib><creatorcontrib>Chang, Hui Joe</creatorcontrib><creatorcontrib>Suresh, Srikrishnan</creatorcontrib><creatorcontrib>Arora, Geeta</creatorcontrib><creatorcontrib>Hammerschmidt, Beda C</creatorcontrib><title>Technique of efficiently, comprehensively and autonomously support native JSON datatype in RDBMS for both OLTP and OLAP</title><description>Herein is a self-tuning database management system (DBMS) storing JavaScript object notation (JSON) documents and operating a JSON datatype as native to the DBMS. In an embodiment, a computer hosts a DBMS that executes a data definition language (DDL) statement that defines, in a database dictionary of the DBMS, a JSON document column of a database table that stores JSON documents as instances of the JSON datatype that is native in the DBMS. The DBMS may autonomously set or adjust configuration settings that control behaviors such as a default width of a JSON document column, in lining or not of the JSON document column, kind and scope and duration of indexing of the JSON document column, and/or caching of the JSON document column such as in an in memory columnar unit (IMCU). The DBMS may use the various configuration settings to control how JSON documents and the native JSON datatype are stored and/or processed.</description><subject>CALCULATING</subject><subject>COMPUTING</subject><subject>COUNTING</subject><subject>ELECTRIC DIGITAL DATA PROCESSING</subject><subject>PHYSICS</subject><fulltext>true</fulltext><rsrctype>patent</rsrctype><creationdate>2023</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNqNjMsKgkAUQN20iOofbvtaqFFtswcRlpG2lmm8gwM6d3KuhX-fRB_Q6sDhcIbeO0NZGv1sEUgBKqWlRsNVNwNJtW2wROP0C6sOhClAtEyGampdL1xrLTUMRnBfwClNLlAIFtxZBG3gtovOKShq4EFcQhJn1-8kiTfXsTdQonI4-XHkTQ_7bHuco6UcnRUSDXJ-T31_tQzW4SIKwn-aDxNXRLU</recordid><startdate>20230919</startdate><enddate>20230919</enddate><creator>Arora, Vikas</creator><creator>Abraham, Sundeep</creator><creator>Krishnamurthy, Sriram</creator><creator>Lu, Ying</creator><creator>Sosa, Alfonso Colunga</creator><creator>McMahon, Douglas J</creator><creator>Zhang, Hui</creator><creator>Spiegel, Joshua</creator><creator>Liu, Zhen Hua</creator><creator>Chang, Hui Joe</creator><creator>Suresh, Srikrishnan</creator><creator>Arora, Geeta</creator><creator>Hammerschmidt, Beda C</creator><scope>EVB</scope></search><sort><creationdate>20230919</creationdate><title>Technique of efficiently, comprehensively and autonomously support native JSON datatype in RDBMS for both OLTP and OLAP</title><author>Arora, Vikas ; Abraham, Sundeep ; Krishnamurthy, Sriram ; Lu, Ying ; Sosa, Alfonso Colunga ; McMahon, Douglas J ; Zhang, Hui ; Spiegel, Joshua ; Liu, Zhen Hua ; Chang, Hui Joe ; Suresh, Srikrishnan ; Arora, Geeta ; Hammerschmidt, Beda C</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_US11762834B23</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2023</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>Arora, Vikas</creatorcontrib><creatorcontrib>Abraham, Sundeep</creatorcontrib><creatorcontrib>Krishnamurthy, Sriram</creatorcontrib><creatorcontrib>Lu, Ying</creatorcontrib><creatorcontrib>Sosa, Alfonso Colunga</creatorcontrib><creatorcontrib>McMahon, Douglas J</creatorcontrib><creatorcontrib>Zhang, Hui</creatorcontrib><creatorcontrib>Spiegel, Joshua</creatorcontrib><creatorcontrib>Liu, Zhen Hua</creatorcontrib><creatorcontrib>Chang, Hui Joe</creatorcontrib><creatorcontrib>Suresh, Srikrishnan</creatorcontrib><creatorcontrib>Arora, Geeta</creatorcontrib><creatorcontrib>Hammerschmidt, Beda C</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>Arora, Vikas</au><au>Abraham, Sundeep</au><au>Krishnamurthy, Sriram</au><au>Lu, Ying</au><au>Sosa, Alfonso Colunga</au><au>McMahon, Douglas J</au><au>Zhang, Hui</au><au>Spiegel, Joshua</au><au>Liu, Zhen Hua</au><au>Chang, Hui Joe</au><au>Suresh, Srikrishnan</au><au>Arora, Geeta</au><au>Hammerschmidt, Beda C</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Technique of efficiently, comprehensively and autonomously support native JSON datatype in RDBMS for both OLTP and OLAP</title><date>2023-09-19</date><risdate>2023</risdate><abstract>Herein is a self-tuning database management system (DBMS) storing JavaScript object notation (JSON) documents and operating a JSON datatype as native to the DBMS. In an embodiment, a computer hosts a DBMS that executes a data definition language (DDL) statement that defines, in a database dictionary of the DBMS, a JSON document column of a database table that stores JSON documents as instances of the JSON datatype that is native in the DBMS. The DBMS may autonomously set or adjust configuration settings that control behaviors such as a default width of a JSON document column, in lining or not of the JSON document column, kind and scope and duration of indexing of the JSON document column, and/or caching of the JSON document column such as in an in memory columnar unit (IMCU). The DBMS may use the various configuration settings to control how JSON documents and the native JSON datatype are stored and/or processed.</abstract><oa>free_for_read</oa></addata></record> |
| fulltext | fulltext_linktorsrc |
| identifier | |
| ispartof | |
| issn | |
| language | eng |
| recordid | cdi_epo_espacenet_US11762834B2 |
| source | esp@cenet |
| subjects | CALCULATING COMPUTING COUNTING ELECTRIC DIGITAL DATA PROCESSING PHYSICS |
| title | Technique of efficiently, comprehensively and autonomously support native JSON datatype in RDBMS for both OLTP and OLAP |
| url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-22T15%3A04%3A00IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-epo_EVB&rft_val_fmt=info:ofi/fmt:kev:mtx:patent&rft.genre=patent&rft.au=Arora,%20Vikas&rft.date=2023-09-19&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3EUS11762834B2%3C/epo_EVB%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_id=info:pmid/&rfr_iscdi=true |