CA2701173A1 - Systeme et procede pour distribuer des demandes a un groupe de bases de donnees et accelerer un acces a des donnees - Google Patents
Systeme et procede pour distribuer des demandes a un groupe de bases de donnees et accelerer un acces a des donnees Download PDFInfo
- Publication number
- CA2701173A1 CA2701173A1 CA2701173A CA2701173A CA2701173A1 CA 2701173 A1 CA2701173 A1 CA 2701173A1 CA 2701173 A CA2701173 A CA 2701173A CA 2701173 A CA2701173 A CA 2701173A CA 2701173 A1 CA2701173 A1 CA 2701173A1
- Authority
- CA
- Canada
- Prior art keywords
- databases
- database
- query
- fractional
- building
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Abandoned
Links
- 238000000034 method Methods 0.000 title claims abstract description 55
- 230000001133 acceleration Effects 0.000 claims abstract description 5
- 230000008569 process Effects 0.000 claims description 12
- 238000005070 sampling Methods 0.000 claims description 12
- 238000013459 approach Methods 0.000 claims description 10
- 238000012358 sourcing Methods 0.000 claims description 9
- 230000004044 response Effects 0.000 claims description 8
- 238000009826 distribution Methods 0.000 claims description 7
- 230000015654 memory Effects 0.000 description 9
- 230000008901 benefit Effects 0.000 description 7
- 230000006870 function Effects 0.000 description 7
- 238000012545 processing Methods 0.000 description 5
- 238000013507 mapping Methods 0.000 description 4
- 238000004891 communication Methods 0.000 description 3
- 230000007246 mechanism Effects 0.000 description 3
- 238000005457 optimization Methods 0.000 description 3
- 238000007405 data analysis Methods 0.000 description 2
- 230000001419 dependent effect Effects 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- BASFCYQUMIYNBI-UHFFFAOYSA-N platinum Chemical compound [Pt] BASFCYQUMIYNBI-UHFFFAOYSA-N 0.000 description 2
- 230000008859 change Effects 0.000 description 1
- 239000002131 composite material Substances 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- JEIPFZHSYJVQDO-UHFFFAOYSA-N ferric oxide Chemical compound O=[Fe]O[Fe]=O JEIPFZHSYJVQDO-UHFFFAOYSA-N 0.000 description 1
- PCHJSUWPFVWCPO-UHFFFAOYSA-N gold Chemical compound [Au] PCHJSUWPFVWCPO-UHFFFAOYSA-N 0.000 description 1
- 239000010931 gold Substances 0.000 description 1
- 229910052737 gold Inorganic materials 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 230000005055 memory storage Effects 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 229910052697 platinum Inorganic materials 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
- 230000003442 weekly effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24534—Query rewriting; Transformation
- G06F16/24539—Query rewriting; Transformation using cached or materialised query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24553—Query execution of query operations
- G06F16/24554—Unary operations; Data partitioning operations
- G06F16/24556—Aggregation; Duplicate elimination
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Probability & Statistics with Applications (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Applications Claiming Priority (5)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| US86380106P | 2006-10-31 | 2006-10-31 | |
| US60/863,801 | 2006-10-31 | ||
| US11/929,789 US9747349B2 (en) | 2006-10-30 | 2007-10-30 | System and method for distributing queries to a group of databases and expediting data access |
| US11/929,789 | 2007-10-30 | ||
| PCT/US2007/083164 WO2008055202A2 (fr) | 2006-10-31 | 2007-10-31 | Système et procédé pour distribuer des demandes à un groupe de bases de données et accélérer un accès à des données |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CA2701173A1 true CA2701173A1 (fr) | 2008-05-08 |
Family
ID=39345071
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CA2701173A Abandoned CA2701173A1 (fr) | 2006-10-31 | 2007-10-31 | Systeme et procede pour distribuer des demandes a un groupe de bases de donnees et accelerer un acces a des donnees |
Country Status (3)
| Country | Link |
|---|---|
| EP (1) | EP2082317A4 (fr) |
| CA (1) | CA2701173A1 (fr) |
| WO (1) | WO2008055202A2 (fr) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8774561B2 (en) * | 2010-09-01 | 2014-07-08 | Apple Inc. | Consolidating information relating to duplicate images |
| US9818141B2 (en) | 2014-01-13 | 2017-11-14 | International Business Machines Corporation | Pricing data according to provenance-based use in a query |
| US10509788B2 (en) | 2016-12-30 | 2019-12-17 | Dev Gupta | Systems and methods for lossy data compression using key artifacts and dynamically generated cycles |
| CN113392130B (zh) * | 2020-03-13 | 2022-04-29 | 阿里巴巴集团控股有限公司 | 数据处理方法、装置及设备 |
Family Cites Families (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5978788A (en) * | 1997-04-14 | 1999-11-02 | International Business Machines Corporation | System and method for generating multi-representations of a data cube |
| US6912524B2 (en) * | 1998-05-20 | 2005-06-28 | Lucent Technologies, Inc. | Join synopsis-based approximate query answering |
| US20030033179A1 (en) * | 2001-08-09 | 2003-02-13 | Katz Steven Bruce | Method for generating customized alerts related to the procurement, sourcing, strategic sourcing and/or sale of one or more items by an enterprise |
| US7895191B2 (en) * | 2003-04-09 | 2011-02-22 | International Business Machines Corporation | Improving performance of database queries |
| US7937319B2 (en) * | 2005-03-21 | 2011-05-03 | Oversight Technologies, Inc. | Methods and systems for compliance monitoring knowledge base |
| WO2005103956A1 (fr) * | 2004-04-02 | 2005-11-03 | Microsoft Corporation | Cadre d'adaptation pour integration d'applications de secteurs d'activite |
| US20080270363A1 (en) * | 2007-01-26 | 2008-10-30 | Herbert Dennis Hunt | Cluster processing of a core information matrix |
-
2007
- 2007-10-31 EP EP07871310A patent/EP2082317A4/fr not_active Withdrawn
- 2007-10-31 WO PCT/US2007/083164 patent/WO2008055202A2/fr active Application Filing
- 2007-10-31 CA CA2701173A patent/CA2701173A1/fr not_active Abandoned
Also Published As
| Publication number | Publication date |
|---|---|
| WO2008055202A3 (fr) | 2008-08-14 |
| EP2082317A4 (fr) | 2010-10-06 |
| EP2082317A2 (fr) | 2009-07-29 |
| WO2008055202A2 (fr) | 2008-05-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9747349B2 (en) | System and method for distributing queries to a group of databases and expediting data access | |
| US20230376487A1 (en) | Processing database queries using format conversion | |
| US10860598B2 (en) | Systems and methods for interest-driven business intelligence systems including event-oriented data | |
| JP6617117B2 (ja) | 半構造データのためのスケーラブルな分析プラットフォーム | |
| Pereira et al. | Efficient matching for web-based publish/subscribe systems | |
| US8700605B1 (en) | Estimating rows returned by recursive queries using fanout | |
| US8924373B2 (en) | Query plans with parameter markers in place of object identifiers | |
| US20090249125A1 (en) | Database querying | |
| US7324991B1 (en) | Sampling in a multidimensional database | |
| US20120246154A1 (en) | Aggregating search results based on associating data instances with knowledge base entities | |
| Ashayer et al. | Predicate matching and subscription matching in publish/subscribe systems | |
| US20090024654A1 (en) | Multi-value property storage and query support | |
| Roy et al. | Towards automatic association of relevant unstructured content with structured query results | |
| US7925617B2 (en) | Efficiency in processing queries directed to static data sets | |
| CA2701173A1 (fr) | Systeme et procede pour distribuer des demandes a un groupe de bases de donnees et accelerer un acces a des donnees | |
| CN107430633B (zh) | 用于数据存储的***及方法和计算机可读介质 | |
| US20230342360A1 (en) | Preferred storage of aggregate data items | |
| Wu et al. | POLYTOPE: a flexible sampling system for answering exploratory queries | |
| US20090198643A1 (en) | Apparatus and method for utilizing density metadata to process multi-dimensional data | |
| US10311049B2 (en) | Pattern-based query result enhancement | |
| CN115658680A (zh) | 数据存储方法、数据查询方法和相关装置 | |
| Villarroya et al. | Enabling efficient distributed spatial join on large scale vector-raster data lakes | |
| Gupta et al. | Efficiently querying archived data using hadoop | |
| Zaman et al. | Modeling and querying multidimensional data sources in siebel analytics: A federated relational system | |
| Yiu et al. | Extracting k most important groups from data efficiently |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| FZDE | Dead |
Effective date: 20131031 |