Method for querying a database in which a query statement is issued to a database management system for which data types can be defined

• US 20020123991A1
• Filed: 05/08/2002
• Published: 09/05/2002
• Est. Priority Date: 09/09/1998
• Status: Active Grant

• Current Assignee: Masato Asami, Tomoto Shimizu, Yoshito Kamegi, Youichi Yamamoto
• Original Assignee: Masato Asami, Tomoto Shimizu, Yoshito Kamegi, Youichi Yamamoto
• Inventors: Shimizu, Tomoto, Yamamoto, Youichi, Kamegi, Yoshito, Asami, Masato
• Granted Patent: US 6,594,669 B2
• Time in Patent Office: Days
• US Class Current: 707/3
• CPC Class Codes: G06F 16/235 Update request formulation
• CPC Class Codes: G06F 16/2423 Interactive query statement specification based on a database schema
• CPC Class Codes: G06F 16/2448 for particular applications; for extensibility, e.g. user defined types
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation

Abstract

A newly defined data type is added to a database management system. Information about a query component assisting in querying data belonging to the newly defined data type is registered along with data type information in a query component information. If the data type being queried is the newly added data type, the query component information is searched to find a query component for assisting queries to data belonging to the particular data type. The matching query component is activated and a screen is displayed to input information needed to the query data belonging to the data type. The information is input and a query statement is generated using the inputted information. The generated query statement is issued to the database management system and query results are obtained.

Claims

1. A method for querying a database in which a query statement is issued to a database management system for which a data type can be defined and query results are acquired, said method comprising the steps of:

selecting at least one of query components used to assist queries to the database based on input information;

generating at least one of templates for activating said selected at least one of query components, said templates including a query editing template, a query condition entry template and a search result template;

generating and displaying a page for editing a query based on said generated query editing template;

generating and displaying a page for inputting a search condition based on said generated query condition entry template; and

generating and displaying a page for displaying a search result based on said generated search result template.

2. A method for querying a database in which a query statement is issued to a database management system for which a data type can be defined and query results are acquired, said method comprising the steps of:

generating a template for activating a query component used to assist queries to a database in which a new data type has been defined as well as information about said data type;

referring to said template if a queried data type is said newly defined data type;

searching for a query component for assisting querying data belonging to the queried data type;

when the query component for assisting querying belonging to the data type is found, activating said query component to assist querying said data type and generating a page for entry of information needed to query data of said data type and handling entry of said information, based on said generated template; and

generating query statement based on said generated template and issuing said generated query statements to said database management system.