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 6,594,669 B2
• Filed: 05/08/2002
• Issued: 07/15/2003
• Est. Priority Date: 09/09/1998
• Status: Expired due to Fees

• Current Assignee: Hitachi, Ltd.
• Original Assignee: Hitachi, Ltd.
• Inventors: Shimizu, Tomoto, Yamamoto, Youichi, Kamegi, Yoshito, Asami, Masato
• Primary Examiner(s): Corrielus, Jean M.
• Application Number:
  US10/140,103
• Publication Number:
  US 20020123991A1
• Time in Patent Office: 433 Days
• Field of Search: 707/3, 707/2, 707/103, 707/4, 707/101, 707/100, 707/102, 707/9, 709/203, 709/201, 345/853, 345/968, 711/117
• US Class Current: 1/1
• 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.