Database management program, a database managing method and an apparatus therefor

Inactive Publication Date: 2005-02-10
HITACHI LTD
View PDF7 Cites 15 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Benefits of technology

[0003] In the above-mentioned conventional technique, description is made on a method for optimizing and storing the order of columns, the order of lines and the necessity of creating an index in a database on the basis of access frequency. Such processing is carried out automatically routinely, and information is not disclosed to any user. Therefore, the user does not know what standard is used and what is optimized. Thus, classification between the case to optimize an

Problems solved by technology

Therefore, the user does not know what standard is used and what is optimized.
Thus, classification between th

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
  • Database management program, a database managing method and an apparatus therefor
  • Database management program, a database managing method and an apparatus therefor
  • Database management program, a database managing method and an apparatus therefor

Examples

Experimental program
Comparison scheme
Effect test

second embodiment

[0071] Next, description will be made of the present invention.

[0072] According to the second embodiment, in the access log edition / aggregation processing program 104, access log data is extracted, translated and aggregated in a period from the time when an object was created till the time when the object was deleted. Thus, optimization of the access to a database is supported to reflect the result of analyzing the life cycle of the object.

[0073]FIG. 24 shows the configuration of a database managing system according to the second embodiment of the present invention. The configuration of the system as a whole is the same as that in FIG. 1. However, only the access log edition / aggregation processing program 104 in the computer 3 is different. Particularly, the access log edition / aggregation processing program in this embodiment has a life cycle analyzing process 117.

[0074]FIG. 25 shows a flow chart of the life cycle analyzing process 117.

[0075] In the life cycle analyzing process, ...

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

Database optimizing method and system are provided to optimally locate data. Only data satisfying conditions desired by a user is extracted among an access log. Values of a part of the data are translated on the basis of a translation table, and aggregated on the basis of aggregation condition rules. The obtained aggregation result is presented to the user. In addition, data in the database are optimally relocated on the basis of the obtained aggregation result.

Description

BACKGROUND OF THE INVENTION [0001] The present invention relates to a database, and particularly relates to a database management program, a database managing method and a database managing system for carrying out rearrangement of a database or the like on the basis of log information showing access status to data. [0002] As a conventional database optimizing system based on trace information, there is a database optimizing / rearranging system as disclosed in JP-A-5-2515. In this system, information of a method for gaining access to a database at data operation requests issued from respective user programs is accumulated as trace information. When the database is rearranged at regular time intervals, the optimum storage order of data in the database and the necessity of an index are determined with reference to the accumulated trace information. Thus, buffer quantity assignment parameters are created for securing a buffer quantity required for rearranging the database. SUMMARY OF THE...

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
IPC IPC(8): G06F11/34G06F7/00G06F12/00G06F17/30
CPCY10S707/99942G06F17/30368G06F17/30339G06F16/2358G06F16/2282
Inventor SEKI, YUMIKOKAMEDA, MASAMIFUJII, TAKESHIYAMASHITA, YOSHIFUMI
Owner HITACHI LTD
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