# US 2003/0208504 A1 · Computer program product for accessing database, recording medium recording database access program therein, and database access method

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2003/0208504 A1
- Document ID: US20030208504A1
- Status: Published application
- Kind: A1
- Application number: 10/405,699
- Filed: 2003-04-03
- Published: 2003-11-06
- Earliest claimed: 2002-04-15
- Assignees: Sumitomo Electric Industries, Ltd.
- Inventors: Nobuhiro Nakamura; Kazuhisa Ikeda
- Web page: https://patentgrep.com/patent/US20030208504A1

## CPC

- G06F 16/2428: {Query predicate definition using graphical user interfaces, including menus and forms (G06F16/2423 takes precedence)}
- Y10S 707/99934: Query formulation, input preparation, or translation
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- Y10S: TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS

## Abstract

A computer program product for accessing a database is a program product for accessing a database by allowing a computer to execute a plurality of screen components, including a step of designating order of the plurality of screen components to be executed by the computer. Each of the plurality of screen components includes: a step of generating a part except for a “where” clause in an SQL statement in accordance with definition given from the outside for each screen component; a step of generating a screen for inputting and/or outputting data; and a step of generating the “where” clause in the SQL statement in accordance with definition given from the outside for each screen component. Since the screen component as a part of the database access program processes the steps in accordance with definition given from the outside, the screen component can be used by another database access program. Thus, general versatility is obtained and development efficiency is improved.

## Claims

### Claim 1

A computer program product for accessing a database by allowing a computer to execute a plurality of screen components, comprising a step of:
designating order of said plurality of screen components to be executed by the computer, wherein
each of said plurality of screen components including the steps of:
generating a second part except for a first part for specifying data to be processed in a command for accessing said database in accordance with definition given from the outside for each screen component;
generating a screen for inputting and/or outputting data; and
generating the first part for specifying data to be processed in the command for accessing said database in accordance with definition supplied from the outside for each screen component.

### Claim 2 (depends on 1)

The computer program product according to claim 1, wherein
said screen generating step generates a screen in accordance with an item in said database given from the outside for each screen component.

### Claim 3 (depends on 1)

The computer program product according to claim 1, further comprising a step of:
designating an order to execute said steps included in each of said plurality of screen components so as to be executed in the same order in all of said plurality of screen components.

### Claim 4 (depends on 1)

The computer program product according to claim 1, wherein
each of said plurality of screen components further includes a step of checking obtained data in accordance with items of said database, given from the outside for each screen component.

### Claim 5 (depends on 1)

The computer program product according to claim 1, wherein
in said step of generating said first part, said first part in a command to be executed when the next screen component is implemented by said computer is generated.

### Claim 6 (depends on 4)

The computer program product according to claim 4, wherein
in said step of generating said first part, said first part in the command is generated on the basis of data checked in said check step.

### Claim 7 (depends on 1)

The computer program product according to claim 1, wherein
said step of generating said second part includes a process which does not generate said second part.

### Claim 8 (depends on 4)

The computer program product according to claim 4, wherein
said check step includes a process of checking nothing.

### Claim 9 (depends on 1)

The computer program product according to claim 1, wherein
said step of generating said first part includes a process which does not generate said first part.

### Claim 10 (depends on 1)

The computer program product according to claim 1, wherein
said screen component further includes a step of outputting the generated screen after said screen generating step.

### Claim 11 (depends on 1)

The computer program product according to claim 1, wherein
each one of said screen components further includes a step of executing a command determined by most recently generated one of said first parts and said second part after said step of generating said second part.

### Claim 12 (depends on 11)

The computer program product according to claim 11, further comprising a step of:
generating an HTML source after said step of executing the command determined by said first and second parts.

### Claim 13 (depends on 1)

The computer program product according to claim 1, wherein
said first and second parts are stored in a common area in a memory.

### Claim 14 (depends on 1)

The computer program product according to claim 1, wherein
definition given from the outside is described in an XML or CSV.

### Claim 15 (depends on 1)

The computer program product according to claim 1, wherein
said step of designating order includes the steps of:
receiving a page transition signal; and
executing said screen component in accordance with said received page transition signal.

### Claim 16 (depends on 1)

The computer program product according to claim 1, wherein
said step of generating said first part includes a step of generating a part except for a “where” clause in an SQL sentence, and
said step of generating said second part includes a step of generating the “where” clause in the SQL sentence.

### Claim 17 (depends on 1)

The computer program product according to claim 1, wherein
said step of generating said screen includes the steps of:
preparing, for each of items of said database, a form component item necessary for inputting or outputting the item with reference to an item object corresponding to the item; and
generating a source file according to a predetermined format for realizing a form component in which said form component items are arranged.

### Claim 18 (depends on 17)

The computer program product according to claim 17, wherein
said form component item preparing step includes a step of finding an item object corresponding to an item in said database given from the outside for each of said screen components.

### Claim 19

A computer-readable recording medium in which a program of accessing a database by allowing a computer to execute a plurality of screen components is recorded, comprising a step of:
designating order of said plurality of screen components to be executed by the computer, wherein
each of said plurality of screen components includes the steps of:
generating a second part except for a first part for specifying data to be processed in a command for accessing said database in accordance with definition given from the outside for each screen component;
generating a screen for inputting and/or outputting data; and
generating the first part for specifying data to be processed in the command for accessing said database in accordance with definition given from the outside for each screen component.

### Claim 20

A method of operating a database by allowing a computer to execute a plurality of screen components, comprising a step of:
designating order of said plurality of screen components to be executed by the computer, wherein
each of said plurality of screen components includes the steps of:
generating a second part except for a first part for specifying data to be processed in a command for accessing said database in accordance with definition given from the outside for each screen component;
generating a screen for inputting and/or outputting data; and
generating the first part for specifying data to be processed in the command for accessing said database in accordance with definition given from the outside for each screen component.
