Title (en)

SYSTEMS AND METHODS FOR COLLECTING, STORING, AND ANALYZING DATABASE STATISTICS

Title (de)

SYSTEM UND VERFAHREN, UM DATENBANKSTATISTIKEN ZU SAMMELN, ZU SPEICHERN UND ZU ANALYSIEREN

Title (fr)

SYSTEMES ET PROCEDES DE COLLECTE, DE STOCKAGE ET D'ANALYSE DES STATISTIQUES D'UNE BASE DE DONNEES

Publication

EP 1428140 A2 20040616 (EN)

Application

EP 00978450 A 20001109

Priority

• US 0030784 W 20001109
• US 16417099 P 19991109

Abstract (en)

[origin: WO0135256A2] A system and method for collecting, storing, retrieving and analyzing database statistical information. A collection agent on a database server interrogates the database on a defined interval to determine the database state, and to derive statistics about database performance, structures, and usage. This statistical information is stored within a collection database as historical data. Periodically, the historical data is unloaded from the collection database, transferred via a Transfer Protocol to a data warehouse server, and loaded into said server. Summarization of the data, and Trends-based analysis, are performed against the data with results stored in the data warehouse as persistent storage. Periodically, an application server interrogates the data warehouse for the database being analyzed, and produces a series of reports which show database trends, reliability, and performance information in graphical, textual, and tabular formats.

IPC 1-7

G06F 17/30

IPC 8 full level

G06F 17/30 (2006.01); G06F 11/34 (2006.01)

CPC (source: EP)

G06F 16/21 (2018.12); G06F 16/283 (2018.12); G06F 11/3495 (2013.01)

Citation (search report)

See references of WO 0135256A2

Designated contracting state (EPC)

AT BE CH CY DE DK ES FI FR GB GR IE IT LI LU MC NL PT SE TR

DOCDB simple family (publication)

WO 0135256 A2 20010517; WO 0135256 A3 20040401; AU 1591201 A 20010606; CA 2390697 A1 20010517; EP 1428140 A2 20040616

DOCDB simple family (application)

US 0030784 W 20001109; AU 1591201 A 20001109; CA 2390697 A 20001109; EP 00978450 A 20001109