CA2390697A1 - Systemes et procedes de collecte, de stockage et d'analyse des statistiques d'une base de donnees - Google Patents

Systemes et procedes de collecte, de stockage et d'analyse des statistiques d'une base de donnees Download PDF

Info

Publication number
CA2390697A1
CA2390697A1 CA002390697A CA2390697A CA2390697A1 CA 2390697 A1 CA2390697 A1 CA 2390697A1 CA 002390697 A CA002390697 A CA 002390697A CA 2390697 A CA2390697 A CA 2390697A CA 2390697 A1 CA2390697 A1 CA 2390697A1
Authority
CA
Canada
Prior art keywords
database
data
analysis
server
statistics
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Abandoned
Application number
CA002390697A
Other languages
English (en)
Inventor
Brent David Tucker
James Frederick Koopmann
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
DBDOCTOR Inc
Original Assignee
Individual
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Individual filed Critical Individual
Publication of CA2390697A1 publication Critical patent/CA2390697A1/fr
Abandoned legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28—Databases characterised by their database models, e.g. relational or object models
    • G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21—Design, administration or maintenance of databases
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/30—Monitoring
    • G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
    • G06F11/3466—Performance evaluation by tracing or monitoring
    • G06F11/3495—Performance evaluation by tracing or monitoring for systems

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Computer And Data Communications (AREA)
  • Debugging And Monitoring (AREA)

Abstract

L'invention concerne un système et un procédé permettant de rassembler, de stocker, de récupérer et d'analyser des données statistiques d'une base de données. Un agent de collecte installé sur le serveur d'une base de données interroge la base de données à un intervalle défini afin de déterminer l'état de la base de données, et de dériver des statistiques sur la performance, les structures et l'utilisation de la base de données. Ces données statistiques sont stockées dans une base de données de collecte comme données historiques. Périodiquement, les données historiques sont déchargées de la base de données de collecte, transférées via un protocole de transfert à un serveur de dépôt de données, et chargées dans ledit serveur. Un résumé des données et une analyse des tendances sont effectués sur les données, et les résultats stockés dans le dépôt de données en stockage rémanent. Périodiquement, le serveur d'une application interroge le dépôt de données sur la base de données analysée, et génère une série de rapports présentant des données sur les tendances, la fiabilité et la performance de la base de données en formats graphique, textuel et tabulaire.
CA002390697A 1999-11-09 2000-11-09 Systemes et procedes de collecte, de stockage et d'analyse des statistiques d'une base de donnees Abandoned CA2390697A1 (fr)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US16417099P 1999-11-09 1999-11-09
US60/164,170 1999-11-09
PCT/US2000/030784 WO2001035256A2 (fr) 1999-11-09 2000-11-09 Systemes et procedes de collecte, de stockage et d'analyse des statistiques d'une base de donnees

Publications (1)

Publication Number Publication Date
CA2390697A1 true CA2390697A1 (fr) 2001-05-17

Family

ID=22593291

Family Applications (1)

Application Number Title Priority Date Filing Date
CA002390697A Abandoned CA2390697A1 (fr) 1999-11-09 2000-11-09 Systemes et procedes de collecte, de stockage et d'analyse des statistiques d'une base de donnees

Country Status (4)

Country Link
EP (1) EP1428140A2 (fr)
AU (1) AU1591201A (fr)
CA (1) CA2390697A1 (fr)
WO (1) WO2001035256A2 (fr)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108334641A (zh) * 2018-03-21 2018-07-27 上海精数信息科技有限公司 采集用户行为数据的方法、系统、电子设备、存储介质

Families Citing this family (15)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7240112B2 (en) 2000-05-26 2007-07-03 Ipass Inc. Service quality monitoring process
DE10308851A1 (de) * 2003-02-27 2004-09-30 Software Engineering Gmbh Echtzeitwartung einer relationalen Datenbank
ATE350715T1 (de) 2003-05-15 2007-01-15 Targit As Methode und benutzerschnittstelle für das bilden einer darstellung von daten mit meta-morphing
US7779018B2 (en) 2003-05-15 2010-08-17 Targit A/S Presentation of data using meta-morphing
US8468444B2 (en) 2004-03-17 2013-06-18 Targit A/S Hyper related OLAP
EP1591928A1 (fr) * 2004-04-30 2005-11-02 Daktronics, Inc. Système et procédé pour la transmission et le traitement d'information de jeu à travers un réseau longue
DE602004027507D1 (de) * 2004-11-17 2010-07-15 Targit As Datenbank mit Verlaufsspeicher
US7774295B2 (en) 2004-11-17 2010-08-10 Targit A/S Database track history
DK176532B1 (da) 2006-07-17 2008-07-14 Targit As Fremgangsmåde til integration af dokumenter med OLAP ved brug af sögning, computerlæsbart medium og computer
US8640033B2 (en) 2007-06-29 2014-01-28 Microsoft Corporation Unified user experience using contextual information, data attributes and data models
IL195956A0 (en) 2008-12-15 2009-09-01 Hyperroll Israel Ltd Automatic data store architecture detection
IL197961A0 (en) 2009-04-05 2009-12-24 Guy Shaked Methods for effective processing of time series
US9934255B2 (en) 2013-11-11 2018-04-03 International Business Machines Corporation End of retention processing using a database manager scheduler
CN105069134B (zh) * 2015-08-18 2018-07-27 上海新炬网络信息技术股份有限公司 一种Oracle统计信息自动收集方法
CN117633074A (zh) * 2023-11-24 2024-03-01 国任财产保险股份有限公司 一种基于财务数据的处理系统

Family Cites Families (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5701471A (en) * 1995-07-05 1997-12-23 Sun Microsystems, Inc. System and method for testing multiple database management systems
US5819066A (en) * 1996-02-28 1998-10-06 Electronic Data Systems Corporation Application and method for benchmarking a database server
US5852818A (en) * 1996-12-23 1998-12-22 Oracle Corporation Non-recursive method for parameter evaluation within an information management system

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108334641A (zh) * 2018-03-21 2018-07-27 上海精数信息科技有限公司 采集用户行为数据的方法、系统、电子设备、存储介质
CN108334641B (zh) * 2018-03-21 2020-10-16 上海精数信息科技有限公司 采集用户行为数据的方法、系统、电子设备、存储介质

Also Published As

Publication number Publication date
WO2001035256A2 (fr) 2001-05-17
WO2001035256A3 (fr) 2004-04-01
EP1428140A2 (fr) 2004-06-16
AU1591201A (en) 2001-06-06

Similar Documents

Publication Publication Date Title
US9940373B2 (en) Method and system for implementing an operating system hook in a log analytics system
US7526508B2 (en) Self-managing database architecture
US7941524B2 (en) System and method for collecting and storing event data from distributed transactional applications
US7500150B2 (en) Determining the level of availability of a computing resource
US7418461B2 (en) Schema conformance for database servers
EP2471014B1 (fr) Systèmes et procédés de collecte de données à distance
US6141699A (en) Interactive display system for sequential retrieval and display of a plurality of interrelated data sets
US6070190A (en) Client-based application availability and response monitoring and reporting for distributed computing environments
US6321263B1 (en) Client-based application availability
US6901536B2 (en) Service quality monitoring system and method
CA2390697A1 (fr) Systemes et procedes de collecte, de stockage et d'analyse des statistiques d'une base de donnees
US7617201B1 (en) System and method for analyzing statistics in a reporting system
US8983966B2 (en) Method and system to monitor a diverse heterogeneous application environment
US20100088197A1 (en) Systems and methods for generating remote system inventory capable of differential update reports
WO2007036932A2 (fr) Systeme de gestion de table de donnees et methodes associes
US7779300B2 (en) Server outage data management
US11892976B2 (en) Enhanced search performance using data model summaries stored in a remote data store
CN110928930B (zh) 一种软件开发行为监控系统
CN117725122A (zh) 一种业务管理平台的订单同步方法
US10305738B2 (en) System and method for contextual clustering of granular changes in configuration items
CN107104806A (zh) 话单处理方法、装置及系统
US7457991B1 (en) Method for scanning windows event logs on a cellular multi-processor (CMP) server
Lingrand et al. Analyzing the EGEE production grid workload: application to jobs submission optimization
Shaila et al. Support automation connectivity system for big data applications
CN117271183A (zh) 数据库异常作业调度重试策略的获取方法及其装置

Legal Events

Date Code Title Description
EEER Examination request
FZDE Dead