System and method for real time statistics collection for use in the automatic management of a database system

a database system and real-time statistics technology, applied in the field of database management systems, can solve the problems of tens of thousands of tables and indexes, significant challenges in the number of objects in the database, and complex schemas for these solutions

Inactive Publication Date: 2007-02-20
IBM CORP
View PDF5 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Benefits of technology

This patented technology allows for precise tracking of changes made by users on their own systems without having to manually check each table's spaces or allocate them with more storage capacity than what they are supposed to use.

Problems solved by technology

The technical problem addressed in this patent text relates to managing and monitoring database usage in order to prevent issues like outage and overload caused by frequent maintenance requests. Current methods involve manually checking each object separately, but it becomes difficult if more than one object needs to be maintained simultaneously due to the lack of visibility between them. Additionally, existing methodologies have limitations in terms of efficiency and accuracy, leading to unnecessary expenses and delays in response times.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • System and method for real time statistics collection for use in the automatic management of a database system
  • System and method for real time statistics collection for use in the automatic management of a database system
  • System and method for real time statistics collection for use in the automatic management of a database system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0060]The following definitions and explanations provide background information pertaining to the technical field of the present invention, and are intended to facilitate the understanding of the present invention without limiting its scope:

[0061]Daemon: A program that runs continuously in the background until it is activated by a particular event.

[0062]Externalize: To take statistics stored in memory and aggregate those statistics to the appropriate values in the real-time statistics table.

[0063]Internet: A collection of interconnected public and private computer networks that are linked together with routers by a set of standards protocols to form a global, distributed network.

[0064]Partition: Partition represents the physical data set(s) that make up the logical table space; partitions can be, for example 1 to 255.

[0065]SQL: Structured Query Language, a standardized query language for requesting information from a database.

[0066]Table: Data arranged in rows and columns. A spreadshee

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

A computer program product provides accurate statistics in real time. These statistics can be used to determine if a table space in a database management system (DBMS) requires maintenance operations such as reorganization, back up, fresh access path statistics, and/or larger disk space allocation. The DBMS maintains a set of values that provide indications of whether that operation is due on that object. The indicators are asynchronously externalized in dedicated database tables either periodically in user-specified intervals or at some predefined event such as stopping the database. When the user performs a database administration operation, the database management system resets the associated indicators, and reports objects that are in an exception state based on the indicators collected as described for each operation.

Description

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Owner IBM CORP
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap