東華大學圖書館 |

Language: English

Help

回圖書館首頁

手機版館藏查詢

Back

Switch To: Labeled | MARC Mode | ISBD

The efficacy of multidimensional con...

Cardwell, Leslie K.

Linked to FindBook

Google Book

Amazon

博客來

The efficacy of multidimensional constraint keys in database query performance.

Record Type:	Language materials, printed : Monograph/item
Title/Author:	The efficacy of multidimensional constraint keys in database query performance./
Author:	Cardwell, Leslie K.
Description:	84 p.
Notes:	Source: Dissertation Abstracts International, Volume: 74-01(E), Section: A.
Contained By:	Dissertation Abstracts International74-01A(E).
Subject:	Information Science. -
Online resource:	http://pqdd.sinica.edu.tw/twdaoapp/servlet/advanced?query=3525515
ISBN:	9781267577146

The efficacy of multidimensional constraint keys in database query performance.
Cardwell, Leslie K.

The efficacy of multidimensional constraint keys in database query performance. - 84 p.

Source: Dissertation Abstracts International, Volume: 74-01(E), Section: A.

Thesis (D.C.S.)--Colorado Technical University, 2012.

This work is intended to introduce a database design method to resolve the two-dimensional complexities inherent in the relational data model and its resulting performance challenges through abstract multidimensional constructs. A multidimensional constraint is derived and utilized to implement an indexed Multidimensional Key (MK) to abstract a logically partitioned subset by reading a single overriding index on a relation (table), without the need to traverse the domain (path) hierarchy. The Multidimensional Key can then be utilized for the purposes of improving the efficiencies and performance in both production and data warehouse environments, often mitigating the need for commonly used denormalization techniques. The results of this research demonstrate a performance increase that outweighs the cost of the MK index can be obtained in circumstances where the query execution is frequent.

ISBN: 9781267577146Subjects--Topical Terms:

1017528
Information Science.

The efficacy of multidimensional constraint keys in database query performance.
LDR:01846nam a2200301 4500 001 1958450
005 20140421080355.5
008 150210s2012 ||||||||||||||||| ||eng d
020 $a 9781267577146
035 $a (MiAaPQ)AAI3525515
035 $a AAI3525515
040 $a MiAaPQ $c MiAaPQ
100 1 $a Cardwell, Leslie K. $3 2093542
245 1 4 $a The efficacy of multidimensional constraint keys in database query performance.
300 $a 84 p.
500 $a Source: Dissertation Abstracts International, Volume: 74-01(E), Section: A.
500 $a Adviser: Bo Sanden.
502 $a Thesis (D.C.S.)--Colorado Technical University, 2012.
520 $a This work is intended to introduce a database design method to resolve the two-dimensional complexities inherent in the relational data model and its resulting performance challenges through abstract multidimensional constructs. A multidimensional constraint is derived and utilized to implement an indexed Multidimensional Key (MK) to abstract a logically partitioned subset by reading a single overriding index on a relation (table), without the need to traverse the domain (path) hierarchy. The Multidimensional Key can then be utilized for the purposes of improving the efficiencies and performance in both production and data warehouse environments, often mitigating the need for commonly used denormalization techniques. The results of this research demonstrate a performance increase that outweighs the cost of the MK index can be obtained in circumstances where the query execution is frequent.
520 $a (Abstract shortened by UMI.).
590 $a School code: 1271.
650 4 $a Information Science. $3 1017528
650 4 $a Information Technology. $3 1030799
650 4 $a Computer Science. $3 626642
690 $a 0723
690 $a 0489
690 $a 0984
710 2 $a Colorado Technical University. $3 1031996
773 0 $t Dissertation Abstracts International $g 74-01A(E).
790 $a 1271
791 $a D.C.S.
792 $a 2012
793 $a English
856 4 0 $u http://pqdd.sinica.edu.tw/twdaoapp/servlet/advanced?query=3525515