US Patent 7797286 System and method for externally providing database optimizer statistics

Patent 7797286 was granted and assigned to SAP on September, 2010 by the United States Patent and Trademark Office.

Overview Structured Data Issues Contributors Activity

Is a

Patent

Patent attributes

Current Assignee

SAP

Patent Jurisdiction

United States Patent and Trademark Office

Patent Number

7797286

Date of Patent

September 14, 2010

Patent Application Number

10851013

Date Filed

May 21, 2004

Patent Primary Examiner

‌

Jean B Fleurantin

Patent abstract

The present invention relates to a method and system for using an external program to generate and update statistical information used by a database optimizer for at least one of a database and a database management system, at least one table of data being replicated from the database to the external program, the external program generating statistical information on the replicated data and sending the generated statistical information back to the database for use with the optimizer. The replicated data residing with the external program may also be used by an application for the execution of database queries instead of the database itself with the application using a list of replicated tables or replicated data to determine where to target its queries.

Timeline

No Timeline data yet.

Further Resources

Title

Author

Link

Type

Date

No Further Resources data yet.

References

Find more entities like US Patent 7797286 System and method for externally providing database optimizer statistics

Use the Golden Query Tool to find similar entities by any field in the Knowledge Graph, including industry, location, and more.

Open Query Tool

Access by API