RUN-TIME PERFORMANCE OF A DATABASE

RUN-TIME PERFORMANCE OF A DATABASE

Methods and systems are disclosed improving run-time performance of a database. A non-production database is accessed, at a computer system, during a design phase4 of the non-production database, wherein the non-production database will be converted to a production database after the design phase. D...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: HAWTON, Brett, PITTS, James B
Format: Patent
Sprache:eng
Schlagworte:
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:Methods and systems are disclosed improving run-time performance of a database. A non-production database is accessed, at a computer system, during a design phase4 of the non-production database, wherein the non-production database will be converted to a production database after the design phase. Data statistics are generated, at the computer system, based on performance metrics of how the non-production database would perform as the production database. The data statistics are displayed, at the computer system, to a developer of the non-production database during the design phase. At least one suggestion is offered to the developer, at the computer system, to implement into the SQL of the non-production database to improve a performance of the non-production database.