Apparatus and method for using database knowledge to optimize a computer program

a database and computer program technology, applied in the field of computer systems, can solve the problems of not addressing many aspects of the code, the execution time of the computer program increases, and the modem software becomes very complex when compared to the early computer program, so as to remove unnecessary loops, remove unnecessary database operations, and remove unnecessary calls.

Inactive Publication Date: 2007-08-07
INT BUSINESS MASCH CORP
View PDF16 Cites 31 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Modem software has become very complex when compared to early computer programs.
Thus, as the size and complexity of computer programs increase, the execution time of the computer program increases as well.
While these types of optimizers effectively improve the performance of the code, they do not address many aspects of the code that could benefit from further improvements.
Without improved apparatus and methods for optimizing a computer program that take into account characteristics of a database referenced in the computer program, the computer industry will continue to suffer from computer code that has not been fully optimized.

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
  • Apparatus and method for using database knowledge to optimize a computer program
  • Apparatus and method for using database knowledge to optimize a computer program
  • Apparatus and method for using database knowledge to optimize a computer program

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025]As stated in the Background section, optimizers are known that use profile data to optimize a computer program. One example of a prior art optimization method that uses profile data is shown in FIG. 2. Method 200 begins by collecting profile data while a computer program runs (step 210). Collecting profile data includes the steps of generating executable code for the computer program, then executing the code under conditions that simulate the assumed run-time environment. Profile data may be collected as the computer program runs using a number of different techniques, including instrumenting the computer program with code that increments counters, collecting a run-time trace that indicates which instructions were executed, etc. Once the profile data is collected, an optimizing compiler (or optimizer) may use the collected profile data to make optimizations to the computer program (step 220).

[0026]Prior art method 200 as shown in FIG. 2 is an effective way to optimize a comput...

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 code optimizer is used to optimize a computer program that references a database by determining the characteristics of the database and making suitable optimizations based on the characteristics of the database. By taking into account the characteristics of a database referenced in the computer program, the optimizer may make suitable optimizations to the computer program. Such optimizations include, without limitation, removing unnecessary calls to the database, removing unnecessary loops, removing unnecessary database operations, providing compile-time errors, and replacing dynamic calls with static data.

Description

BACKGROUND OF THE INVENTION[0001]1. Technical Field[0002]This invention generally relates to computer systems, and more specifically relates to ways to optimize computer programs.[0003]2. Background Art[0004]Since the dawn of the computer age, computer systems have evolved into extremely sophisticated devices, and computer systems may be found in many different settings. Dramatic advances in both hardware and software (e.g., computer programs) have drastically improved the performance of computer systems. Modem software has become very complex when compared to early computer programs. Many modem computer programs have tens or hundreds of thousands of instructions. The execution time (and hence, performance) of a computer program is very closely related to the number of instructions that are executed as the computer program runs. Thus, as the size and complexity of computer programs increase, the execution time of the computer program increases as well.[0005]Unlike early computer pro...

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
Patent Type & Authority Patents(United States)
IPC IPC(8): G06F9/45
CPCG06F8/443
Inventor BARSNESS, ERIC LAWRENCEDETTINGER, RICHARD DEANSANTOSUOSSO, JOHN MATTHEW
Owner INT BUSINESS MASCH 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