COLUMNAR CACHING IN TIERED STORAGE
A method comprises storing, within a storage system that is operatively coupled to a server machine that is executing a database server instance that manages a database, a persistent-format copy of a set of data, in a persistent-format, on persistent storage; wherein the set of data is from a table...
Gespeichert in:
| Hauptverfasser: | , , , , , , , , , , , , |
|---|---|
| Format: | Patent |
| Sprache: | eng ; fre ; ger |
| 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 | Shah, Viral Kamp, Jesse Chavan, Shasank K Umamageswaran, Kothanda Lahiri, Tirthankar Ganesh, Amit Ng, Adrian Tsz Him Colgan, Maria Macnicol, Roger D Meiyyappan, Krishnan Hua, Xia Loaiza, Juan R Qin, Yiran |
| description | A method comprises storing, within a storage system that is operatively coupled to a server machine that is executing a database server instance that manages a database, a persistent-format copy of a set of data, in a persistent-format, on persistent storage; wherein the set of data is from a table in the database managed by the database server instance. The method further comprises, in response to a load-triggering event, determining a target device in which to construct a mirror-format copy of the set of data, in a mirror-format; wherein the target device is one of the storage system and the server machine; wherein the mirror-format is different than the persistent format; wherein the target device is determined based on (i) metadata associated with the set of data, or (ii) one or more factors. The method further comprises, using data obtained from the persistent-format copy, constructing the mirror-format copy in volatile memory of the target device. One or more computer-readable media and a system comprise corresponding features. |
| format | Patent |
| fullrecord | <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_EP4209922A1</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>EP4209922A1</sourcerecordid><originalsourceid>FETCH-epo_espacenet_EP4209922A13</originalsourceid><addsrcrecordid>eNrjZFBy9vcJ9fVzDFJwdnT28PRzV_D0UwjxdA1ydVEIDvEPcnR35WFgTUvMKU7lhdLcDApuriHOHrqpBfnxqcUFicmpeakl8a4BJkYGlpZGRo6GxkQoAQDkvyHg</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>COLUMNAR CACHING IN TIERED STORAGE</title><source>esp@cenet</source><creator>Shah, Viral ; Kamp, Jesse ; Chavan, Shasank K ; Umamageswaran, Kothanda ; Lahiri, Tirthankar ; Ganesh, Amit ; Ng, Adrian Tsz Him ; Colgan, Maria ; Macnicol, Roger D ; Meiyyappan, Krishnan ; Hua, Xia ; Loaiza, Juan R ; Qin, Yiran</creator><creatorcontrib>Shah, Viral ; Kamp, Jesse ; Chavan, Shasank K ; Umamageswaran, Kothanda ; Lahiri, Tirthankar ; Ganesh, Amit ; Ng, Adrian Tsz Him ; Colgan, Maria ; Macnicol, Roger D ; Meiyyappan, Krishnan ; Hua, Xia ; Loaiza, Juan R ; Qin, Yiran</creatorcontrib><description>A method comprises storing, within a storage system that is operatively coupled to a server machine that is executing a database server instance that manages a database, a persistent-format copy of a set of data, in a persistent-format, on persistent storage; wherein the set of data is from a table in the database managed by the database server instance. The method further comprises, in response to a load-triggering event, determining a target device in which to construct a mirror-format copy of the set of data, in a mirror-format; wherein the target device is one of the storage system and the server machine; wherein the mirror-format is different than the persistent format; wherein the target device is determined based on (i) metadata associated with the set of data, or (ii) one or more factors. The method further comprises, using data obtained from the persistent-format copy, constructing the mirror-format copy in volatile memory of the target device. One or more computer-readable media and a system comprise corresponding features.</description><language>eng ; fre ; ger</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=20230712&DB=EPODOC&CC=EP&NR=4209922A1$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,776,881,25542,76516</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20230712&DB=EPODOC&CC=EP&NR=4209922A1$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>Shah, Viral</creatorcontrib><creatorcontrib>Kamp, Jesse</creatorcontrib><creatorcontrib>Chavan, Shasank K</creatorcontrib><creatorcontrib>Umamageswaran, Kothanda</creatorcontrib><creatorcontrib>Lahiri, Tirthankar</creatorcontrib><creatorcontrib>Ganesh, Amit</creatorcontrib><creatorcontrib>Ng, Adrian Tsz Him</creatorcontrib><creatorcontrib>Colgan, Maria</creatorcontrib><creatorcontrib>Macnicol, Roger D</creatorcontrib><creatorcontrib>Meiyyappan, Krishnan</creatorcontrib><creatorcontrib>Hua, Xia</creatorcontrib><creatorcontrib>Loaiza, Juan R</creatorcontrib><creatorcontrib>Qin, Yiran</creatorcontrib><title>COLUMNAR CACHING IN TIERED STORAGE</title><description>A method comprises storing, within a storage system that is operatively coupled to a server machine that is executing a database server instance that manages a database, a persistent-format copy of a set of data, in a persistent-format, on persistent storage; wherein the set of data is from a table in the database managed by the database server instance. The method further comprises, in response to a load-triggering event, determining a target device in which to construct a mirror-format copy of the set of data, in a mirror-format; wherein the target device is one of the storage system and the server machine; wherein the mirror-format is different than the persistent format; wherein the target device is determined based on (i) metadata associated with the set of data, or (ii) one or more factors. The method further comprises, using data obtained from the persistent-format copy, constructing the mirror-format copy in volatile memory of the target device. One or more computer-readable media and a system comprise corresponding features.</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>eNrjZFBy9vcJ9fVzDFJwdnT28PRzV_D0UwjxdA1ydVEIDvEPcnR35WFgTUvMKU7lhdLcDApuriHOHrqpBfnxqcUFicmpeakl8a4BJkYGlpZGRo6GxkQoAQDkvyHg</recordid><startdate>20230712</startdate><enddate>20230712</enddate><creator>Shah, Viral</creator><creator>Kamp, Jesse</creator><creator>Chavan, Shasank K</creator><creator>Umamageswaran, Kothanda</creator><creator>Lahiri, Tirthankar</creator><creator>Ganesh, Amit</creator><creator>Ng, Adrian Tsz Him</creator><creator>Colgan, Maria</creator><creator>Macnicol, Roger D</creator><creator>Meiyyappan, Krishnan</creator><creator>Hua, Xia</creator><creator>Loaiza, Juan R</creator><creator>Qin, Yiran</creator><scope>EVB</scope></search><sort><creationdate>20230712</creationdate><title>COLUMNAR CACHING IN TIERED STORAGE</title><author>Shah, Viral ; Kamp, Jesse ; Chavan, Shasank K ; Umamageswaran, Kothanda ; Lahiri, Tirthankar ; Ganesh, Amit ; Ng, Adrian Tsz Him ; Colgan, Maria ; Macnicol, Roger D ; Meiyyappan, Krishnan ; Hua, Xia ; Loaiza, Juan R ; Qin, Yiran</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_EP4209922A13</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng ; fre ; ger</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>Shah, Viral</creatorcontrib><creatorcontrib>Kamp, Jesse</creatorcontrib><creatorcontrib>Chavan, Shasank K</creatorcontrib><creatorcontrib>Umamageswaran, Kothanda</creatorcontrib><creatorcontrib>Lahiri, Tirthankar</creatorcontrib><creatorcontrib>Ganesh, Amit</creatorcontrib><creatorcontrib>Ng, Adrian Tsz Him</creatorcontrib><creatorcontrib>Colgan, Maria</creatorcontrib><creatorcontrib>Macnicol, Roger D</creatorcontrib><creatorcontrib>Meiyyappan, Krishnan</creatorcontrib><creatorcontrib>Hua, Xia</creatorcontrib><creatorcontrib>Loaiza, Juan R</creatorcontrib><creatorcontrib>Qin, Yiran</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>Shah, Viral</au><au>Kamp, Jesse</au><au>Chavan, Shasank K</au><au>Umamageswaran, Kothanda</au><au>Lahiri, Tirthankar</au><au>Ganesh, Amit</au><au>Ng, Adrian Tsz Him</au><au>Colgan, Maria</au><au>Macnicol, Roger D</au><au>Meiyyappan, Krishnan</au><au>Hua, Xia</au><au>Loaiza, Juan R</au><au>Qin, Yiran</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>COLUMNAR CACHING IN TIERED STORAGE</title><date>2023-07-12</date><risdate>2023</risdate><abstract>A method comprises storing, within a storage system that is operatively coupled to a server machine that is executing a database server instance that manages a database, a persistent-format copy of a set of data, in a persistent-format, on persistent storage; wherein the set of data is from a table in the database managed by the database server instance. The method further comprises, in response to a load-triggering event, determining a target device in which to construct a mirror-format copy of the set of data, in a mirror-format; wherein the target device is one of the storage system and the server machine; wherein the mirror-format is different than the persistent format; wherein the target device is determined based on (i) metadata associated with the set of data, or (ii) one or more factors. The method further comprises, using data obtained from the persistent-format copy, constructing the mirror-format copy in volatile memory of the target device. One or more computer-readable media and a system comprise corresponding features.</abstract><oa>free_for_read</oa></addata></record> |
| fulltext | fulltext_linktorsrc |
| identifier | |
| ispartof | |
| issn | |
| language | eng ; fre ; ger |
| recordid | cdi_epo_espacenet_EP4209922A1 |
| source | esp@cenet |
| subjects | CALCULATING COMPUTING COUNTING ELECTRIC DIGITAL DATA PROCESSING PHYSICS |
| title | COLUMNAR CACHING IN TIERED STORAGE |
| url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-02-13T17%3A39%3A18IST&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=Shah,%20Viral&rft.date=2023-07-12&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3EEP4209922A1%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 |