US Patent No: 7,606,792

Number of patents in Portfolio can not be more than 2000

System and method for efficient evaluation of a query that invokes a table valued function

2 Status Updates

Stats

ALSO PUBLISHED AS: 20050209988
ATTORNEY / AGENT: (SPONSORED)
 

Importance

Loading Importance Indicators... loading....

Abstract

The present invention describes an efficient and fast framework for implementing table-valued functions (TVF's) in a relational database server. The framework provides desirable extensibility properties and has the ability to minimize performance degradations by integrating tightly with the optimization infrastructure in a query processor. The present invention also enables a managed execution environment (MEE) such as the Common-Language-Runtime (CLR), to efficiently and dynamically extend the logic of the database engine with user-supplied code.

Loading the Abstract Image... loading....

First Claim

Related Publications

Loading Related Publications... loading....

Patent Owner(s)

Patent OwnerAddressTotal Patents
MICROSOFT CORPORATIONREDMOND, WA24226

International Classification(s)

  • [Classification Symbol]
  • [Patents Count]

Inventor(s)

Inventor Name Address # of filed Patents Total Citations
Cunningham, Conor Redmond, WA 11 49
Sezgin, Beysim Redmond, WA 32 100
Venkatesh, Ramachandran Bellevue, WA 55 316

Cited Art

Patent Info (Count) # Cites Year
 
ORACLE INTERNATIONAL CORPORATION (6)
6,496,819 Rewriting a query in terms of a summary based on functional dependencies and join backs, and based on join derivability 70 1998
6,351,742 Method and mechanism for database statement optimization 29 1999
6,370,522 Method and mechanism for extending native optimization in a database system 42 1999
6,401,083 Method and mechanism for associating properties with objects and instances 22 1999
7,103,590 Method and system for pipelined database table functions 25 2001
2005/0120,000 Auto-tuning SQL statements 17 2004
 
MICROSOFT CORPORATION (5)
6,360,214 Automatic database statistics creation 22 1998
6,460,043 Method and apparatus for operating on data with a conceptual data manipulation language 93 1999
6,738,968 Unified data type system and method 25 2000
6,778,977 Method and system for creating a database table index using multiple processors 33 2001
7,330,848 Method and apparatus for generating statistics on query expressions for optimization 9 2003
 
INTERNATIONAL BUSINESS MACHINES CORPORATION (3)
5,875,334 System, method, and program for extending a SQL compiler for handling control statements packaged with SQL query statements 91 1995
5,822,750 Optimization of correlated SQL queries in a relational database management system 100 1997
6,609,123 Query engine and method for querying data using metadata model 187 2000
 
HEWLETT-PACKARD DEVELOPMENT COMPANY, L.P. (2)
5,544,355 Method and apparatus for query optimization in a relational database system having foreign functions 78 1993
6,282,581 Mechanism for resource allocation and for dispatching incoming calls in a distributed object environment 70 1997
 
SUN MICROSYSTEMS, INC. (2)
6,496,833 System and method for generating code for query object interfacing 70 1999
7,506,329 Method and system for targeting profile gathering through real-time data 2 2004
 
TERADATA US, INC. (2)
6,594,651 Method and apparatus for parallel execution of SQL-from within user defined functions 19 1999
6,505,189 Aggregate join index for relational databases 19 2000
 
CALIFORNIA INSTITUTE OF TECHNOLOGY (1)
7,319,945 Automated methods for simulating a biological network 3 2001
 
CANON KABUSHIKI KAISHA (1)
4,664,496 Camera system 8 1986
 
CODEWIDGET, INC. (1)
2005/0204,340 Attribute-based automated business rule identifier and methods of implementing same 10 2004
 
EBEST!, INC. (1)
6,567,819 Run time objects 16 2000
 
FINSBURY SOLUTIONS LIMITED (1)
2003/0172,368 System and method for autonomously generating heterogeneous data source interoperability bridges based on semantic modeling derived from self adapting ontology 97 2002
 
GOOGLE INC. (1)
7,302,422 Query workload statistics collection in a database management system 16 2004
 
SYBASE, INC. (1)
6,823,329 Database system providing methodology for acceleration of queries involving functional expressions against columns having enumerated storage 23 2002
 
TELEFONAKTIEBOLAGET LM ERICSSON (PUBL) (1)
5,864,862 System and method for creating reusable components in an object-oriented programming environment 189 1996
 
THE TRUSTEES OF THE UNIVERSITY OF PENNSYLVANIA (1)
6,567,802 Systematic approach to query optimization 40 2000

Patent Citation Ranking

Forward Cites

Patent Info (Count) # Cites Year
 
HEWLETT-PACKARD DEVELOPMENT COMPANY, L.P. (1)
8,046,373 Structured parallel data intensive computing 0 2009
 
INTERNATIONAL BUSINESS MACHINES CORPORATION (1)
7,890,480 Processing of deterministic user-defined functions using multiple corresponding hash tables 1 2008
 
PRECISE SOFTWARE SOLUTIONS, INC. (1)
8,438,276 Method of monitoring network and application performance by analyzing web clients and web servers 0 2010
 
SYMANTEC ISRAEL LTD. (1)
7,702,642 Method, system and computer-readable code for instrumenting code for logging database-related strings 3 2005
 
OTHER [CHECK PATENT PROFILE FOR ASSIGNMENT INFORMATION] (1)
8,447,743 Techniques for processing database queries including user-defined functions 0 2004

Maintenance Fees

Fee Large entity fee small entity fee micro entity fee due date
3.5 Year Payment $1600.00 $800.00 $400.00 Apr 20, 2013
7.5 Year Payment $3600.00 $1800.00 $900.00 Apr 20, 2017
11.5 Year Payment $7400.00 $3700.00 $1850.00 Apr 20, 2021
Fee Large entity fee small entity fee micro entity fee
Surcharge - 3.5 year - Late payment within 6 months $160.00 $80.00 $40.00
Surcharge - 7.5 year - Late payment within 6 months $160.00 $80.00 $40.00
Surcharge - 11.5 year - Late payment within 6 months $160.00 $80.00 $40.00
Surcharge after expiration - Late payment is unavoidable $700.00 $350.00 $175.00
Surcharge after expiration - Late payment is unintentional $1,640.00 $820.00 $410.00