Materialized Query Table Matching With Query Expansion
Methods, apparatuses, and computer program products for materialized query table matching are provided that include receiving a database query, retrieving a materialized query table (MQT) from data storage accessible to a database management system, selecting a join in the materialized query table b...
Saved in:
| Main Author | |
|---|---|
| Format | Patent |
| Language | English |
| Published |
04.09.2008
|
| Subjects | |
| Online Access | Get full text |
Cover
Loading…
| Abstract | Methods, apparatuses, and computer program products for materialized query table matching are provided that include receiving a database query, retrieving a materialized query table (MQT) from data storage accessible to a database management system, selecting a join in the materialized query table between a table that is not invoked by the query and a table that is invoked in the query, determining whether the selected join is lossless, and expanding the query to include the lossless join if the selected join is lossless, expanding the query to include the lossless join. Determining whether the selected join is lossless may be carried out by losslessly joining the table that is not invoked by the query to the query, and determining whether the lossless join to the query matches the selected join of the materialized query table. |
|---|---|
| AbstractList | Methods, apparatuses, and computer program products for materialized query table matching are provided that include receiving a database query, retrieving a materialized query table (MQT) from data storage accessible to a database management system, selecting a join in the materialized query table between a table that is not invoked by the query and a table that is invoked in the query, determining whether the selected join is lossless, and expanding the query to include the lossless join if the selected join is lossless, expanding the query to include the lossless join. Determining whether the selected join is lossless may be carried out by losslessly joining the table that is not invoked by the query to the query, and determining whether the lossless join to the query matches the selected join of the materialized query table. |
| Author | DIETEL JOHN D |
| Author_xml | – fullname: DIETEL JOHN D |
| BookMark | eNrjYmDJy89L5WQw800sSS3KTMzJrEpNUQgsTS2qVAhJTMpJVQBKJGdk5qUrhGeWZEBlXCsKEvOKM_PzeBhY0xJzilN5oTQ3g7Kba4izh25qQX58anFBYnJqXmpJfGiwkYGBhZGhqam5haOhMXGqAD78MAY |
| ContentType | Patent |
| DBID | EVB |
| DatabaseName | esp@cenet |
| DatabaseTitleList | |
| Database_xml | – sequence: 1 dbid: EVB name: esp@cenet url: http://worldwide.espacenet.com/singleLineSearch?locale=en_EP sourceTypes: Open Access Repository |
| DeliveryMethod | fulltext_linktorsrc |
| Discipline | Medicine Chemistry Sciences Physics |
| ExternalDocumentID | US2008215578A1 |
| GroupedDBID | EVB |
| ID | FETCH-epo_espacenet_US2008215578A13 |
| IEDL.DBID | EVB |
| IngestDate | Fri Jul 19 14:57:19 EDT 2024 |
| IsOpenAccess | true |
| IsPeerReviewed | false |
| IsScholarly | false |
| Language | English |
| LinkModel | DirectLink |
| MergedId | FETCHMERGED-epo_espacenet_US2008215578A13 |
| Notes | Application Number: US20080106766 |
| OpenAccessLink | https://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20080904&DB=EPODOC&CC=US&NR=2008215578A1 |
| ParticipantIDs | epo_espacenet_US2008215578A1 |
| PublicationCentury | 2000 |
| PublicationDate | 20080904 |
| PublicationDateYYYYMMDD | 2008-09-04 |
| PublicationDate_xml | – month: 09 year: 2008 text: 20080904 day: 04 |
| PublicationDecade | 2000 |
| PublicationYear | 2008 |
| RelatedCompanies | INTERNATIONAL BUSINESS MACHINES CORPORATION |
| RelatedCompanies_xml | – name: INTERNATIONAL BUSINESS MACHINES CORPORATION |
| Score | 2.718268 |
| Snippet | Methods, apparatuses, and computer program products for materialized query table matching are provided that include receiving a database query, retrieving a... |
| SourceID | epo |
| SourceType | Open Access Repository |
| SubjectTerms | CALCULATING COMPUTING COUNTING ELECTRIC DIGITAL DATA PROCESSING PHYSICS |
| Title | Materialized Query Table Matching With Query Expansion |
| URI | https://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20080904&DB=EPODOC&locale=&CC=US&NR=2008215578A1 |
| hasFullText | 1 |
| inHoldings | 1 |
| isFullTextHit | |
| isPrint | |
| link | http://utb.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwfV3dS8MwED_G_HzTqvgxpaD0rVhJG7uHIq7tGEK36Vrd22jaFAvSjbXDj7_eS2h1T3u9g3BJ7pfLXe4uADdJygiJiaFb2R3VTZpxHc0w140k7WZxkpmMikLhYEgHkfk0taYt-GhqYWSf0E_ZHBERlSDeK3leL_6DWJ7MrSxvWY6k-UM_dDyt8Y5to4ub7vUcfzzyRq7muk400YYvkofWDfXzEX2lLXGRFp32_deeqEtZrBuV_gFsj3G8ojqEFi8U2HObv9cU2A3qJ28FdmSOZlIiscZheQQ0iCupOvkPT9XnFV9-q6EoglKRIbMj1be8eq85_hdCXkTFjuG674fuQEdRZn8zn0WTdbnJCbSLecFPQbUNJqBJCLXuTdwGm9t2xgi3mRUbJKVn0Nk00vlm9gXsN2kRhtmBdrVc8Uu0vRW7kkv2C1xeh6I |
| link.rule.ids | 230,309,786,891,25594,76903 |
| linkProvider | European Patent Office |
| linkToHtml | http://utb.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwfV3dT8JADG8IfuCbTg0q6hINb4sztx3jYTGyQVDZQNmUN7LbbnGJGQRG_Pjr7S6b8sRrm1x61_6uaa_tAVyHESMkIKqix7dU0WjMFXTDXFHDqB0HYawxmjcKOy7t-9rjRJ9U4KPshRFzQj_FcEREVIh4z8R9Pf9PYtmitnJ5wxIkze56nmk3y-jYUNuodLtjdkdDe2g1Lcv0x033RfDQu6F93mOstNXCoFAES6-dvC9lvu5UevuwPcL10uwAKjyVoGaVf69JsOsUT94S7IgazXCJxAKHy0OgTpAJ00l-eCQ_r_jiW_byJigZGaI6Un5LsveC0_1CyOdZsSO46nU9q6-gKNO_nU_98brc5Biq6SzldZANleXQJITqLQ3VYHDDiBnhBtMDlUT0BBqbVjrdzL6EWt9zBtPBg_t0BntliYSqNaCaLVb8HP1wxi7E8f0C2NiKjA |
| openUrl | ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Apatent&rft.title=Materialized+Query+Table+Matching+With+Query+Expansion&rft.inventor=DIETEL+JOHN+D&rft.date=2008-09-04&rft.externalDBID=A1&rft.externalDocID=US2008215578A1 |