| Patent | Date |
|---|
Function semantic based partition-wise SQL execution and partition pruning
Grant 11,442,933 - Bellamkonda , et al. September 13, 2 | 2022-09-13 |
Efficient Sql-based Graph Random Walk
App 20220222254 - Ziauddin; Mohamed ; et al. | 2022-07-14 |
Bitmap-based count distinct query rewrite in a relational SQL algebra
Grant 11,379,476 - Petride , et al. July 5, 2 | 2022-07-05 |
Efficient SQL-based graph random walk
Grant 11,334,567 - Ziauddin , et al. May 17, 2 | 2022-05-17 |
Efficient Compilation Of Graph Queries Involving Long Graph Query Patterns On Top Of Sql Based Relational Engine
App 20220129465 - Haprian; Vlad ; et al. | 2022-04-28 |
Efficient Compilation Of Graph Queries Including Complex Expressions On Top Of Sql Based Relational Engine
App 20220129461 - Haprian; Vlad ; et al. | 2022-04-28 |
Efficient Compilation Of Graph Queries On Top Of Sql Based Relational Engine
App 20220129451 - Haprian; Vlad ; et al. | 2022-04-28 |
Materialized view rewrite technique for one-sided outer-join queries
Grant 11,086,868 - Ahmed , et al. August 10, 2 | 2021-08-10 |
Materialized View Rewrite Technique For One-sided Outer-join Queries
App 20210124742 - Ahmed; Rafi ; et al. | 2021-04-29 |
Bitmap-based Count Distinct Query Rewrite In A Relational Sql Algebra
App 20210109930 - Petride; Sabina ; et al. | 2021-04-15 |
Efficient Sql-based Graph Random Walk
App 20210049171 - Ziauddin; Mohamed ; et al. | 2021-02-18 |
Automatic Generation Of Materialized Views
App 20210026847 - Ahmed; Rafi ; et al. | 2021-01-28 |
Efficient data retrieval based on aggregate characteristics of composite tables
Grant 10,776,363 - Ziauddin , et al. Sept | 2020-09-15 |
N-way hash join
Grant 10,733,186 - Amor , et al. | 2020-08-04 |
Scalable multistage processing of queries with percentile functions
Grant 10,719,516 - Sakamuri , et al. | 2020-07-21 |
Parallel execution of queries with a recursive clause
Grant 10,678,792 - Ziauddin , et al. | 2020-06-09 |
Sort-merge band join optimization
Grant 10,635,671 - Sheng , et al. | 2020-04-28 |
Scalable Multistage Processing Of Queries With Percentile Functions
App 20200065413 - Sakamuri; Venkatesh ; et al. | 2020-02-27 |
Redundant group by and distinct removal
Grant 10,558,660 - Ahmed , et al. Feb | 2020-02-11 |
In-memory cursor duration temp tables
Grant 10,452,655 - Lahorani , et al. Oc | 2019-10-22 |
Function Semantic Based Partition-wise Sql Execution And Partition Pruning
App 20190087457 - BELLAMKONDA; Srikanth ; et al. | 2019-03-21 |
Pruning disk blocks in a relational database management system
Grant 10,223,422 - Ziauddin , et al. | 2019-03-05 |
Redundant Group By And Distinct Removal
App 20190026332 - Ahmed; Rafi ; et al. | 2019-01-24 |
Efficient Data Retrieval Based On Aggregate Characteristics Of Composite Tables
App 20190005096 - Ziauddin; Mohamed ; et al. | 2019-01-03 |
Adaptive selection of a distribution method during execution of parallel join operations
Grant 10,019,481 - Jagtap , et al. July 10, 2 | 2018-07-10 |
Sort-merge Band Join Optimization
App 20180101573 - Sheng; Lei ; et al. | 2018-04-12 |
N-way Hash Join
App 20180075101 - Amor; Angela ; et al. | 2018-03-15 |
Parallel Execution Of Queries With A Recursive Clause
App 20170116276 - Ziauddin; Mohamed ; et al. | 2017-04-27 |
In-memory Cursor Duration Temp Tables
App 20170116266 - Lahorani; Janaki Latha ; et al. | 2017-04-27 |
Out-of-place materialized view refresh
Grant 9,454,572 - Ding , et al. September 27, 2 | 2016-09-27 |
Clustering a table in a relational database management system
Grant 9,430,550 - Ziauddin , et al. August 30, 2 | 2016-08-30 |
Scalable and adaptive evaluation of reporting window functions
Grant 9,390,129 - Li , et al. July 12, 2 | 2016-07-12 |
Pruning Disk Blocks In A Relational Database Management System
App 20150199407 - Ziauddin; Mohamed ; et al. | 2015-07-16 |
Pruning disk blocks of a clustered table in a relational database management system
Grant 8,996,544 - Ziauddin , et al. March 31, 2 | 2015-03-31 |
Using join dependencies for refresh
Grant 8,996,502 - Folkert , et al. March 31, 2 | 2015-03-31 |
Using relational structures to create and support a cube within a relational database system
Grant 8,868,544 - Witkowski , et al. October 21, 2 | 2014-10-21 |
Adaptive Selection Of A Distribution Method During Execution Of Parallel Join Operations
App 20140280023 - Jagtap; Unmesh ; et al. | 2014-09-18 |
Out-of-place Materialized View Refresh
App 20140280029 - Ding; Luping ; et al. | 2014-09-18 |
Scalable and Adaptive Evaluation of Reporting Window Functions
App 20140214754 - Li; Huagang ; et al. | 2014-07-31 |
Pruning Disk Blocks Of A Clustered Table In A Relational Database Management System
App 20140095520 - Ziauddin; Mohamed ; et al. | 2014-04-03 |
Clustering A Table In A Relational Database Management System
App 20140095502 - Ziauddin; Mohamed ; et al. | 2014-04-03 |
Using estimated cost to refresh a set of materialized views (MVS)
Grant 8,478,742 - Folkert , et al. July 2, 2 | 2013-07-02 |
Analytic enhancements to model clause in structured query language (SQL)
Grant 8,468,166 - Bozkaya , et al. June 18, 2 | 2013-06-18 |
Analytic enhancements to model clause in structured query language (SQL)
Grant 8,156,145 - Bozkaya , et al. April 10, 2 | 2012-04-10 |
Rewrite of queries containing rank or rownumber or min/max aggregate functions using a materialized view
Grant 8,103,689 - Gupta , et al. January 24, 2 | 2012-01-24 |
Using multidimensional access as surrogate for run-time hash table
Grant 8,001,112 - Dombroski , et al. August 16, 2 | 2011-08-16 |
Analytic enhancements to model clause in structured query language (SQL)
Grant 7,979,384 - Bozkaya , et al. July 12, 2 | 2011-07-12 |
Analytic Enhancements To Model Clause In Structured Query Language (sql)
App 20110167091 - Bozkaya; Tolga ; et al. | 2011-07-07 |
Incremental Materialized View Refresh With Enhanced Dml Compression
App 20110137875 - Ziauddin; Mohamed ; et al. | 2011-06-09 |
Rewrite of Queries Containing Rank or Rownumber or Min/Max Aggregate Functions Using a Materialized View
App 20110106790 - Gupta; Abhinav ; et al. | 2011-05-05 |
Rewrite of queries containing rank or rownumber or Min/Max aggregate functions using a materialized view
Grant 7,912,834 - Gupta , et al. March 22, 2 | 2011-03-22 |
Using estimated cost to schedule an order for refreshing a set of materialized views (MVS)
Grant 7,890,497 - Folkert , et al. February 15, 2 | 2011-02-15 |
Compile-time optimizations of queries with SQL spreadsheet
Grant 7,809,712 - Witkowski , et al. October 5, 2 | 2010-10-05 |
Run-time optimizations of queries with SQL spreadsheet
Grant 7,761,403 - Witkowski , et al. July 20, 2 | 2010-07-20 |
Choosing whether to use a delayed index maintenance depending on the portion of the materialized view (MV) changed
Grant 7,734,602 - Folkert , et al. June 8, 2 | 2010-06-08 |
Analytic Enhancements To Model Clause In Structured Query Language (sql)
App 20080208822 - Bozkaya; Tolga ; et al. | 2008-08-28 |
Union all rewrite for aggregate queries with grouping sets
Grant 7,379,933 - Witkowski , et al. May 27, 2 | 2008-05-27 |
Spreadsheet to SQL translation
Grant 7,299,223 - Namait , et al. November 20, 2 | 2007-11-20 |
Analytic enhancements to model clause in structured query language (SQL)
App 20070078826 - Bozkaya; Tolga ; et al. | 2007-04-05 |
Compile-time optimizations of queries with SQL spreadsheet
App 20070055661 - Witkowski; Andrew ; et al. | 2007-03-08 |
Compile-time optimizations of queries with SQL spreadsheet
Grant 7,177,855 - Witkowski , et al. February 13, 2 | 2007-02-13 |
Methods of navigating a cube that is implemented as a relational object
Grant 7,171,427 - Witkowski , et al. January 30, 2 | 2007-01-30 |
Rewrite of queries containing rank or rownumber or Min/Max aggregate functions using a materialized view
App 20060212436 - Gupta; Abhinav ; et al. | 2006-09-21 |
Incremental refresh of materialized views containing rank function, and rewrite of queries containing rank or rownumber or min/max aggregate functions using such a materialized view
Grant 7,111,020 - Gupta , et al. September 19, 2 | 2006-09-19 |
Evaluation of database hierarchical cubes by nesting rollup operators associated with multiple groupings
Grant 7,035,843 - Bellamkonda , et al. April 25, 2 | 2006-04-25 |
Using join dependencies for refresh
App 20060047622 - Folkert; Nathaniel Keith ; et al. | 2006-03-02 |
Performing spreadsheet-like calculations in a database system
Grant 6,985,895 - Witkowski , et al. January 10, 2 | 2006-01-10 |
Allocating CPU resources for a particular refresh schedule
App 20050234945 - Folkert, Nathaniel Keith ; et al. | 2005-10-20 |
Using estimated cost to schedule an order for refreshing a set of materialized views (MVS)
App 20050235004 - Folkert, Nathaniel Keith ; et al. | 2005-10-20 |
Choosing whether to use a delayed index maintenance depending on the portion of the materialized view (MV) changed
App 20050235003 - Folkert, Nathaniel Keith ; et al. | 2005-10-20 |
Using estimated cost to refresh a set of materialized views (MVS)
App 20050234971 - Folkert, Nathaniel Keith ; et al. | 2005-10-20 |
Spreadsheet to SQL translation
App 20050039114 - Naimat, Aman ; et al. | 2005-02-17 |
Using multidimensional access as surrogate for run-time hash table
App 20040260690 - Dombroski, Matthew ; et al. | 2004-12-23 |
Evaluation of rollups with distinct aggregates by using sequence of sorts and partitioning by measures
Grant 6,775,682 - Ballamkonda , et al. August 10, 2 | 2004-08-10 |
Evaluation of grouping sets by reduction to group-by clause, with or without a rollup operator, using temporary tables
Grant 6,775,681 - Ballamkonda , et al. August 10, 2 | 2004-08-10 |
Group pruning from cube, rollup, and grouping sets
Grant 6,775,662 - Witkowski , et al. August 10, 2 | 2004-08-10 |
Compile-time optimizations of queries with SQL spreadsheet
App 20040133568 - Witkowski, Andrew ; et al. | 2004-07-08 |
Run-time optimizations of queries with SQL spreadsheet
App 20040133567 - Witkowski, Andrew ; et al. | 2004-07-08 |
Using relational structures to create and support a cube within a relational database system
App 20040034616 - Witkowski, Andrew ; et al. | 2004-02-19 |
Methods of navigating a cube that is implemented as a relational object
App 20040006574 - Witkowski, Andrew ; et al. | 2004-01-08 |
Method and apparatus for optimizing computation of OLAP ranking functions
Grant 6,622,138 - Bellamkonda , et al. September 16, 2 | 2003-09-16 |
Techniques for eliminating database table joins based on a join index
Grant 6,615,206 - Jakobsson , et al. September 2, 2 | 2003-09-02 |
Rewriting a query in terms of a summary based on functional dependencies and join backs, and based on join derivability
Grant 6,496,819 - Bello , et al. December 17, 2 | 2002-12-17 |
Techniques for handling function-defined hierarchical dimensions
Grant 6,493,708 - Ziauddin , et al. December 10, 2 | 2002-12-10 |
Apparatus and method for aggregate indexes
Grant 6,487,546 - Witkowski November 26, 2 | 2002-11-26 |
Rewriting a query in terms of a summary based on one-to-one and one-to-many losslessness of joins
Grant 6,477,525 - Bello , et al. November 5, 2 | 2002-11-05 |
Method and apparatus for accessing previous rows of data in a table
Grant 6,457,000 - Witkowski , et al. September 24, 2 | 2002-09-24 |
Using materialized view to process a related query containing a one to many lossless join
Grant 6,449,609 - Witkowski September 10, 2 | 2002-09-10 |
Method and article for processing queries that define outer joined views
Grant 6,438,541 - Witkowski August 20, 2 | 2002-08-20 |
Performing spreadsheet-like calculations in a database system
App 20020059203 - Witkowski, Andrew ; et al. | 2002-05-16 |
System and method for processing queries having an inner query block containing a grouping operator
Grant 6,370,524 - Witkowski April 9, 2 | 2002-04-09 |
Concurrency control for transactions that update base tables of a materialized view using different types of locks
Grant 6,353,828 - Ganesh , et al. March 5, 2 | 2002-03-05 |
Rewriting queries to access materialized views that group along an ordered dimension
Grant 6,345,272 - Witkowski , et al. February 5, 2 | 2002-02-05 |
Incremental maintenance of materialized views containing one-to-one lossless joins
Grant 6,134,543 - Witkowski , et al. October 17, 2 | 2000-10-17 |
Incremental maintenance of materialized views containing one-to-N lossless joins
Grant 6,125,360 - Witkowski , et al. September 26, 2 | 2000-09-26 |
Incremental maintenance of an approximate histogram in a database system
Grant 5,870,752 - Gibbons , et al. February 9, 1 | 1999-02-09 |
Method for maintaining information in a database used to generate high biased histograms using a probability function, counter and threshold values
Grant 5,689,696 - Gibbons , et al. November 18, 1 | 1997-11-18 |
| 