POLICY DRIVEN DATA PLACEMENT AND INFORMATION LIFECYCLE MANAGEMENT

A method, apparatus, and system for policy driven data placement and information lifecycle management in a database management system are provided. A user or database application can specify declarative policies that define the movement and transformation of stored database objects. The policies are...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: Ganesh, Amit, Mylavarapu, Ajit, Gaharwar, Prashant, Marwah, Vineet, Lakshmanan, Hariharan
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 Ganesh, Amit
Mylavarapu, Ajit
Gaharwar, Prashant
Marwah, Vineet
Lakshmanan, Hariharan
description A method, apparatus, and system for policy driven data placement and information lifecycle management in a database management system are provided. A user or database application can specify declarative policies that define the movement and transformation of stored database objects. The policies are associated with a database object and may also be inherited. A policy defines, for a database object, an archiving action to be taken, a scope, and a condition before the archiving action is triggered. Archiving actions may include compression, data movement, table clustering, and other actions to place the database object into an appropriate storage tier for a lifecycle phase of the database object. Conditions based on access statistics can be specified at the row level and may use segment or block level heatmaps. Policy evaluation occurs periodically in the background, with actions queued as tasks for a task scheduler.
format Patent
fullrecord <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_US2021149847A1</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>US2021149847A1</sourcerecordid><originalsourceid>FETCH-epo_espacenet_US2021149847A13</originalsourceid><addsrcrecordid>eNrjZHAM8PfxdI5UcAnyDHP1U3BxDHFUCPBxdHb1dfULUXD0c1Hw9HPzD_J1DPH091Pw8XRzdY509nFV8HX0c3QHK-JhYE1LzClO5YXS3AzKbq4hzh66qQX58anFBYnJqXmpJfGhwUYGRoaGJpYWJuaOhsbEqQIAeRQr2Q</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>POLICY DRIVEN DATA PLACEMENT AND INFORMATION LIFECYCLE MANAGEMENT</title><source>esp@cenet</source><creator>Ganesh, Amit ; Mylavarapu, Ajit ; Gaharwar, Prashant ; Marwah, Vineet ; Lakshmanan, Hariharan</creator><creatorcontrib>Ganesh, Amit ; Mylavarapu, Ajit ; Gaharwar, Prashant ; Marwah, Vineet ; Lakshmanan, Hariharan</creatorcontrib><description>A method, apparatus, and system for policy driven data placement and information lifecycle management in a database management system are provided. A user or database application can specify declarative policies that define the movement and transformation of stored database objects. The policies are associated with a database object and may also be inherited. A policy defines, for a database object, an archiving action to be taken, a scope, and a condition before the archiving action is triggered. Archiving actions may include compression, data movement, table clustering, and other actions to place the database object into an appropriate storage tier for a lifecycle phase of the database object. Conditions based on access statistics can be specified at the row level and may use segment or block level heatmaps. Policy evaluation occurs periodically in the background, with actions queued as tasks for a task scheduler.</description><language>eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2021</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&amp;date=20210520&amp;DB=EPODOC&amp;CC=US&amp;NR=2021149847A1$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,776,881,25542,76289</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&amp;date=20210520&amp;DB=EPODOC&amp;CC=US&amp;NR=2021149847A1$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>Ganesh, Amit</creatorcontrib><creatorcontrib>Mylavarapu, Ajit</creatorcontrib><creatorcontrib>Gaharwar, Prashant</creatorcontrib><creatorcontrib>Marwah, Vineet</creatorcontrib><creatorcontrib>Lakshmanan, Hariharan</creatorcontrib><title>POLICY DRIVEN DATA PLACEMENT AND INFORMATION LIFECYCLE MANAGEMENT</title><description>A method, apparatus, and system for policy driven data placement and information lifecycle management in a database management system are provided. A user or database application can specify declarative policies that define the movement and transformation of stored database objects. The policies are associated with a database object and may also be inherited. A policy defines, for a database object, an archiving action to be taken, a scope, and a condition before the archiving action is triggered. Archiving actions may include compression, data movement, table clustering, and other actions to place the database object into an appropriate storage tier for a lifecycle phase of the database object. Conditions based on access statistics can be specified at the row level and may use segment or block level heatmaps. Policy evaluation occurs periodically in the background, with actions queued as tasks for a task scheduler.</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>2021</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNrjZHAM8PfxdI5UcAnyDHP1U3BxDHFUCPBxdHb1dfULUXD0c1Hw9HPzD_J1DPH091Pw8XRzdY509nFV8HX0c3QHK-JhYE1LzClO5YXS3AzKbq4hzh66qQX58anFBYnJqXmpJfGhwUYGRoaGJpYWJuaOhsbEqQIAeRQr2Q</recordid><startdate>20210520</startdate><enddate>20210520</enddate><creator>Ganesh, Amit</creator><creator>Mylavarapu, Ajit</creator><creator>Gaharwar, Prashant</creator><creator>Marwah, Vineet</creator><creator>Lakshmanan, Hariharan</creator><scope>EVB</scope></search><sort><creationdate>20210520</creationdate><title>POLICY DRIVEN DATA PLACEMENT AND INFORMATION LIFECYCLE MANAGEMENT</title><author>Ganesh, Amit ; Mylavarapu, Ajit ; Gaharwar, Prashant ; Marwah, Vineet ; Lakshmanan, Hariharan</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_US2021149847A13</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2021</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>Ganesh, Amit</creatorcontrib><creatorcontrib>Mylavarapu, Ajit</creatorcontrib><creatorcontrib>Gaharwar, Prashant</creatorcontrib><creatorcontrib>Marwah, Vineet</creatorcontrib><creatorcontrib>Lakshmanan, Hariharan</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>Ganesh, Amit</au><au>Mylavarapu, Ajit</au><au>Gaharwar, Prashant</au><au>Marwah, Vineet</au><au>Lakshmanan, Hariharan</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>POLICY DRIVEN DATA PLACEMENT AND INFORMATION LIFECYCLE MANAGEMENT</title><date>2021-05-20</date><risdate>2021</risdate><abstract>A method, apparatus, and system for policy driven data placement and information lifecycle management in a database management system are provided. A user or database application can specify declarative policies that define the movement and transformation of stored database objects. The policies are associated with a database object and may also be inherited. A policy defines, for a database object, an archiving action to be taken, a scope, and a condition before the archiving action is triggered. Archiving actions may include compression, data movement, table clustering, and other actions to place the database object into an appropriate storage tier for a lifecycle phase of the database object. Conditions based on access statistics can be specified at the row level and may use segment or block level heatmaps. Policy evaluation occurs periodically in the background, with actions queued as tasks for a task scheduler.</abstract><oa>free_for_read</oa></addata></record>
fulltext fulltext_linktorsrc
identifier
ispartof
issn
language eng
recordid cdi_epo_espacenet_US2021149847A1
source esp@cenet
subjects CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
title POLICY DRIVEN DATA PLACEMENT AND INFORMATION LIFECYCLE MANAGEMENT
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-02-10T09%3A49%3A31IST&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=Ganesh,%20Amit&rft.date=2021-05-20&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3EUS2021149847A1%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