Multidimensional data clustering scheme for query processing and maintenance in relational databases

Multidimensional data clustering scheme for query processing and maintenance in relational databases

Multidimensional clustered tables are provided for efficient processing and management in a relational database management system. A multidimensional clustered table is one whose data is simultaneously clustered along one or more independent dimensions, or clustering keys, and physically organized i...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: LAI TONY WEN HSUN, BHATTACHARJEE BISHWARANJAN, AGARWAL RAMESH C, MALKEMUS TIMOTHY R, HURAS MATTHEW A, PADMANABHAN SRIRAM K, CRANSTON LESLIE A
Format: Patent
Sprache:eng
Schlagworte:
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
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 LAI TONY WEN HSUN
BHATTACHARJEE BISHWARANJAN
AGARWAL RAMESH C
MALKEMUS TIMOTHY R
HURAS MATTHEW A
PADMANABHAN SRIRAM K
CRANSTON LESLIE A
description Multidimensional clustered tables are provided for efficient processing and management in a relational database management system. A multidimensional clustered table is one whose data is simultaneously clustered along one or more independent dimensions, or clustering keys, and physically organized into blocks or pages on disk. When such a table is created, one can specify one or more keys as dimensions along which to cluster the table's data. Each of the dimensions can consist of one or more columns. Further provided are efficient query processing and maintenance techniques for use in conjunction with multidimensional clustered tables.
format Patent
fullrecord <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_US7080081B2</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>US7080081B2</sourcerecordid><originalsourceid>FETCH-epo_espacenet_US7080081B23</originalsourceid><addsrcrecordid>eNqNjLEKAjEQBdNYiPoP-wPCqYVXK4qNlVofa_LOCySbmM0V_r0Igq3VFDPM1LjzGKp3PkLUJ-FAjiuTDaNWFC8PUjsggvpU6DmivCiXZKH6cSyOInupEBYL8kIFgevvdGeFzs2k56BYfDkzdDxc96clcuqgmS0Etbtdtk3bNO1qt978kbwB76A_dA</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Multidimensional data clustering scheme for query processing and maintenance in relational databases</title><source>esp@cenet</source><creator>LAI TONY WEN HSUN ; BHATTACHARJEE BISHWARANJAN ; AGARWAL RAMESH C ; MALKEMUS TIMOTHY R ; HURAS MATTHEW A ; PADMANABHAN SRIRAM K ; CRANSTON LESLIE A</creator><creatorcontrib>LAI TONY WEN HSUN ; BHATTACHARJEE BISHWARANJAN ; AGARWAL RAMESH C ; MALKEMUS TIMOTHY R ; HURAS MATTHEW A ; PADMANABHAN SRIRAM K ; CRANSTON LESLIE A</creatorcontrib><description>Multidimensional clustered tables are provided for efficient processing and management in a relational database management system. A multidimensional clustered table is one whose data is simultaneously clustered along one or more independent dimensions, or clustering keys, and physically organized into blocks or pages on disk. When such a table is created, one can specify one or more keys as dimensions along which to cluster the table's data. Each of the dimensions can consist of one or more columns. Further provided are efficient query processing and maintenance techniques for use in conjunction with multidimensional clustered tables.</description><language>eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2006</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=20060718&amp;DB=EPODOC&amp;CC=US&amp;NR=7080081B2$$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=20060718&amp;DB=EPODOC&amp;CC=US&amp;NR=7080081B2$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>LAI TONY WEN HSUN</creatorcontrib><creatorcontrib>BHATTACHARJEE BISHWARANJAN</creatorcontrib><creatorcontrib>AGARWAL RAMESH C</creatorcontrib><creatorcontrib>MALKEMUS TIMOTHY R</creatorcontrib><creatorcontrib>HURAS MATTHEW A</creatorcontrib><creatorcontrib>PADMANABHAN SRIRAM K</creatorcontrib><creatorcontrib>CRANSTON LESLIE A</creatorcontrib><title>Multidimensional data clustering scheme for query processing and maintenance in relational databases</title><description>Multidimensional clustered tables are provided for efficient processing and management in a relational database management system. A multidimensional clustered table is one whose data is simultaneously clustered along one or more independent dimensions, or clustering keys, and physically organized into blocks or pages on disk. When such a table is created, one can specify one or more keys as dimensions along which to cluster the table's data. Each of the dimensions can consist of one or more columns. Further provided are efficient query processing and maintenance techniques for use in conjunction with multidimensional clustered tables.</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>2006</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNqNjLEKAjEQBdNYiPoP-wPCqYVXK4qNlVofa_LOCySbmM0V_r0Igq3VFDPM1LjzGKp3PkLUJ-FAjiuTDaNWFC8PUjsggvpU6DmivCiXZKH6cSyOInupEBYL8kIFgevvdGeFzs2k56BYfDkzdDxc96clcuqgmS0Etbtdtk3bNO1qt978kbwB76A_dA</recordid><startdate>20060718</startdate><enddate>20060718</enddate><creator>LAI TONY WEN HSUN</creator><creator>BHATTACHARJEE BISHWARANJAN</creator><creator>AGARWAL RAMESH C</creator><creator>MALKEMUS TIMOTHY R</creator><creator>HURAS MATTHEW A</creator><creator>PADMANABHAN SRIRAM K</creator><creator>CRANSTON LESLIE A</creator><scope>EVB</scope></search><sort><creationdate>20060718</creationdate><title>Multidimensional data clustering scheme for query processing and maintenance in relational databases</title><author>LAI TONY WEN HSUN ; BHATTACHARJEE BISHWARANJAN ; AGARWAL RAMESH C ; MALKEMUS TIMOTHY R ; HURAS MATTHEW A ; PADMANABHAN SRIRAM K ; CRANSTON LESLIE A</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_US7080081B23</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2006</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>LAI TONY WEN HSUN</creatorcontrib><creatorcontrib>BHATTACHARJEE BISHWARANJAN</creatorcontrib><creatorcontrib>AGARWAL RAMESH C</creatorcontrib><creatorcontrib>MALKEMUS TIMOTHY R</creatorcontrib><creatorcontrib>HURAS MATTHEW A</creatorcontrib><creatorcontrib>PADMANABHAN SRIRAM K</creatorcontrib><creatorcontrib>CRANSTON LESLIE A</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>LAI TONY WEN HSUN</au><au>BHATTACHARJEE BISHWARANJAN</au><au>AGARWAL RAMESH C</au><au>MALKEMUS TIMOTHY R</au><au>HURAS MATTHEW A</au><au>PADMANABHAN SRIRAM K</au><au>CRANSTON LESLIE A</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Multidimensional data clustering scheme for query processing and maintenance in relational databases</title><date>2006-07-18</date><risdate>2006</risdate><abstract>Multidimensional clustered tables are provided for efficient processing and management in a relational database management system. A multidimensional clustered table is one whose data is simultaneously clustered along one or more independent dimensions, or clustering keys, and physically organized into blocks or pages on disk. When such a table is created, one can specify one or more keys as dimensions along which to cluster the table's data. Each of the dimensions can consist of one or more columns. Further provided are efficient query processing and maintenance techniques for use in conjunction with multidimensional clustered tables.</abstract><oa>free_for_read</oa></addata></record>
fulltext fulltext_linktorsrc
identifier
ispartof
issn
language eng
recordid cdi_epo_espacenet_US7080081B2
source esp@cenet
subjects CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
title Multidimensional data clustering scheme for query processing and maintenance in relational databases
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-02-09T00%3A37%3A45IST&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=LAI%20TONY%20WEN%20HSUN&rft.date=2006-07-18&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3EUS7080081B2%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