User Charge Estimation in Numeric Online Databases: A Methodology |
From inside the book
Results 1-3 of 7
Page 15
... original attribute selectivity . Consider , for example , the attribute TRADEMARK in the PRODUCTS file . Its selectivity is estimated by the expression g ( r - card ( P , ( TYPE , = , 19500 ) ) , s ( TRADEMARK ) , CARD ( P ) ) = g ( 15 ...
... original attribute selectivity . Consider , for example , the attribute TRADEMARK in the PRODUCTS file . Its selectivity is estimated by the expression g ( r - card ( P , ( TYPE , = , 19500 ) ) , s ( TRADEMARK ) , CARD ( P ) ) = g ( 15 ...
Page 17
... original range , as can be read from the file description . The restriction on the MARKETS file would yield some 125000 records containing the original attributes but allowing only the values TAHITI and 1984 for the attributes COUNTRY ...
... original range , as can be read from the file description . The restriction on the MARKETS file would yield some 125000 records containing the original attributes but allowing only the values TAHITI and 1984 for the attributes COUNTRY ...
Page 25
... original ranges . On the basis of the FD component , it is obvious that the key of the result would be the attribute PRODUCT - NO . The cost of the operation would be about 710 ms . The restriction on the MARKETS file would yield some ...
... original ranges . On the basis of the FD component , it is obvious that the key of the result would be the attribute PRODUCT - NO . The cost of the operation would be about 710 ms . The restriction on the MARKETS file would yield some ...
Contents
USER CHARGING | 13 |
THE RELATIONAL DATA MODEL | 20 |
CARDINALITY ESTIMATION IN NUMERIC ONLINE | 32 |
Copyright | |
7 other sections not shown
Common terms and phrases
A-names access strategy Appendix approach attribute description set attribute name set attribute selectivity attribute values attributes PRODUCT-NO basis BDBs candidate keys cardinality estimation charging methods CODATA components computed connect-time considered constructed data model database files Database Management Database Management Systems database user developed elementary predicates English Summary example expression F1 and F2 FD-set file design file organization file structures Finland functional dependencies implementation information retrieval Information Science intermediate files inverted file Järvelin join attribute join predicate julkaisuja manipulation MANUF-NO MARKET-SHARE methodology n-tuple NDBs Numeric Databases online databases operand file description procedure cost model processing cost PRODUCTS file QSALES query cardinality query cost modelling query negotiation query optimization query processing query results r-card r-description RA operations records relational algebra relational data model restriction predicate result file description SIGMOD sort-key storage parameters Systems TAHITI TRADEMARK TYPE unit charges University of Tampere upper bound user charge estimation vendor