JP2007534035A5 - - Google Patents
Download PDFInfo
- Publication number
- JP2007534035A5 JP2007534035A5 JP2006524117A JP2006524117A JP2007534035A5 JP 2007534035 A5 JP2007534035 A5 JP 2007534035A5 JP 2006524117 A JP2006524117 A JP 2006524117A JP 2006524117 A JP2006524117 A JP 2006524117A JP 2007534035 A5 JP2007534035 A5 JP 2007534035A5
- Authority
- JP
- Japan
- 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.)
- Granted
Links
Applications Claiming Priority (7)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| US49711103P | 2003-08-22 | 2003-08-22 | |
| US60/497,111 | 2003-08-22 | ||
| US49907803P | 2003-08-28 | 2003-08-28 | |
| US60/499,078 | 2003-08-28 | ||
| US10/796,217 US7356542B2 (en) | 2003-08-22 | 2004-03-08 | DML statements for densifying data |
| US10/796,217 | 2004-03-08 | ||
| PCT/US2004/027406 WO2005020105A1 (en) | 2003-08-22 | 2004-08-19 | Dml statements for densifying data in a relational database system |
Publications (3)
| Publication Number | Publication Date |
|---|---|
| JP2007534035A JP2007534035A (ja) | 2007-11-22 |
| JP2007534035A5 true JP2007534035A5 (https=) | 2008-01-10 |
| JP4747094B2 JP4747094B2 (ja) | 2011-08-10 |
Family
ID=34198989
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| JP2006524117A Expired - Lifetime JP4747094B2 (ja) | 2003-08-22 | 2004-08-19 | リレーショナルデータベースシステムでデータを緻密化するためのｄｍｌステートメント |
Country Status (6)
| Country | Link |
|---|---|
| US (1) | US7356542B2 (https=) |
| EP (1) | EP1658572A1 (https=) |
| JP (1) | JP4747094B2 (https=) |
| AU (1) | AU2004267850B2 (https=) |
| CA (1) | CA2534788C (https=) |
| WO (1) | WO2005020105A1 (https=) |
Families Citing this family (24)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7356542B2 (en) | 2003-08-22 | 2008-04-08 | Oracle International Corporation | DML statements for densifying data |
| US7539667B2 (en) * | 2004-11-05 | 2009-05-26 | International Business Machines Corporation | Method, system and program for executing a query having a union operator |
| US8645313B1 (en) * | 2005-05-27 | 2014-02-04 | Microstrategy, Inc. | Systems and methods for enhanced SQL indices for duplicate row entries |
| US20070094233A1 (en) * | 2005-10-24 | 2007-04-26 | Wolfgang Otter | Translating time-independent data using database operations |
| US8027969B2 (en) * | 2005-12-29 | 2011-09-27 | Sap Ag | Efficient calculation of sets of distinct results in an information retrieval service |
| US20090063527A1 (en) * | 2007-08-31 | 2009-03-05 | International Business Machines Corporation | Processing of database statements with join predicates on range-partitioned tables |
| IL195956A0 (en) | 2008-12-15 | 2009-09-01 | Hyperroll Israel Ltd | Automatic data store architecture detection |
| IL197961A0 (en) * | 2009-04-05 | 2009-12-24 | Guy Shaked | Methods for effective processing of time series |
| US8370316B2 (en) | 2010-07-12 | 2013-02-05 | Sap Ag | Hash-join in parallel computation environments |
| US8880503B2 (en) * | 2011-06-21 | 2014-11-04 | Microsoft Corporation | Value-based positioning for outer join queries |
| US8468150B2 (en) | 2011-10-31 | 2013-06-18 | International Business Machines Corporation | Accommodating gaps in database index scans |
| US8996544B2 (en) | 2012-09-28 | 2015-03-31 | Oracle International Corporation | Pruning disk blocks of a clustered table in a relational database management system |
| US9430550B2 (en) | 2012-09-28 | 2016-08-30 | Oracle International Corporation | Clustering a table in a relational database management system |
| US9507825B2 (en) | 2012-09-28 | 2016-11-29 | Oracle International Corporation | Techniques for partition pruning based on aggregated zone map information |
| US9275111B2 (en) | 2013-03-15 | 2016-03-01 | International Business Machines Corporation | Minimizing result set size when converting from asymmetric to symmetric requests |
| US10642837B2 (en) | 2013-03-15 | 2020-05-05 | Oracle International Corporation | Relocating derived cache during data rebalance to maintain application performance |
| US9892158B2 (en) * | 2014-01-31 | 2018-02-13 | International Business Machines Corporation | Dynamically adjust duplicate skipping method for increased performance |
| US10387395B2 (en) | 2014-11-03 | 2019-08-20 | Sap Se | Parallelized execution of window operator |
| US9852184B2 (en) * | 2014-11-03 | 2017-12-26 | Sap Se | Partition-aware distributed execution of window operator |
| US10157193B2 (en) | 2016-03-03 | 2018-12-18 | International Business Machines Corporation | Switching between a non-partitioned hash join and a partitioned hash join based on an amount of available memory |
| US10776349B2 (en) * | 2017-01-31 | 2020-09-15 | Salesforce.Com, Inc. | Systems, methods, and apparatuses for implementing dynamic macros within a multi-tenant aware structured query language |
| US10803062B2 (en) * | 2017-01-31 | 2020-10-13 | Salesforce.Com, Inc. | Systems, methods, and apparatuses for implementing a by partition command term within a multi-tenant aware structured query language |
| US11086876B2 (en) | 2017-09-29 | 2021-08-10 | Oracle International Corporation | Storing derived summaries on persistent memory of a storage device |
| US11954605B2 (en) * | 2020-09-25 | 2024-04-09 | Sap Se | Systems and methods for intelligent labeling of instance data clusters based on knowledge graph |
Family Cites Families (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JPH077422B2 (ja) | 1991-08-23 | 1995-01-30 | インターナショナル・ビジネス・マシーンズ・コーポレイション | コンピュータ処理データベース・システムにおけるジョインの実行方法及びシステム |
| US5423035A (en) * | 1992-12-23 | 1995-06-06 | Hughes Aircraft Company | Method for evaluating relational database queries with automatic indexing and ordering of join components |
| US6073134A (en) * | 1997-05-29 | 2000-06-06 | Oracle Corporation | Method article of manufacture, and apparatus for generating a multi-dimensional record management index |
| US5905985A (en) * | 1997-06-30 | 1999-05-18 | International Business Machines Corporation | Relational database modifications based on multi-dimensional database modifications |
| US6112198A (en) | 1997-06-30 | 2000-08-29 | International Business Machines Corporation | Optimization of data repartitioning during parallel query optimization |
| US6298342B1 (en) * | 1998-03-16 | 2001-10-02 | Microsoft Corporation | Electronic database operations for perspective transformations on relational tables using pivot and unpivot columns |
| US6625593B1 (en) * | 1998-06-29 | 2003-09-23 | International Business Machines Corporation | Parallel query optimization strategies for replicated and partitioned tables |
| US6397214B1 (en) | 1998-11-03 | 2002-05-28 | Computer Associates Think, Inc. | Method and apparatus for instantiating records with missing data |
| US5991754A (en) * | 1998-12-28 | 1999-11-23 | Oracle Corporation | Rewriting a query in terms of a summary based on aggregate computability and canonical format, and when a dimension table is on the child side of an outer join |
| US6282544B1 (en) * | 1999-05-24 | 2001-08-28 | Computer Associates Think, Inc. | Method and apparatus for populating multiple data marts in a single aggregation process |
| US6446063B1 (en) * | 1999-06-25 | 2002-09-03 | International Business Machines Corporation | Method, system, and program for performing a join operation on a multi column table and satellite tables |
| US6397204B1 (en) * | 1999-06-25 | 2002-05-28 | International Business Machines Corporation | Method, system, and program for determining the join ordering of tables in a join query |
| US6345272B1 (en) * | 1999-07-27 | 2002-02-05 | Oracle Corporation | Rewriting queries to access materialized views that group along an ordered dimension |
| US6665663B2 (en) * | 2001-03-15 | 2003-12-16 | International Business Machines Corporation | Outerjoin and antijoin reordering using extended eligibility lists |
| US6606621B2 (en) * | 2001-05-30 | 2003-08-12 | Oracle International Corp. | Methods and apparatus for aggregating sparse data |
| US7356542B2 (en) | 2003-08-22 | 2008-04-08 | Oracle International Corporation | DML statements for densifying data |
-
2004
- 2004-03-08 US US10/796,217 patent/US7356542B2/en not_active Expired - Lifetime
- 2004-08-19 AU AU2004267850A patent/AU2004267850B2/en not_active Expired
- 2004-08-19 JP JP2006524117A patent/JP4747094B2/ja not_active Expired - Lifetime
- 2004-08-19 CA CA002534788A patent/CA2534788C/en not_active Expired - Lifetime
- 2004-08-19 EP EP04781985A patent/EP1658572A1/en not_active Ceased
- 2004-08-19 WO PCT/US2004/027406 patent/WO2005020105A1/en not_active Ceased