KR19980040474A - Method and apparatus for searching records in a subscriber management system for Windows using a template - Google Patents

Abstract

In order to efficiently perform various record inquiries in the subscriber management system, the present invention is configured such that ( ₁ , ₂ , ..., _N ) And a template table in which a pair of N field values are configured in one template unit, and a record query device in the subscriber management system using the template constructs a template for loading and listing templates in the template table in response to an inquiry start command signal A target template storage module for temporarily storing the selected template as a target template, and a target template in the target template storage module to the user visually Editable According to the target template in the template editing module and the target template storage module that stores the command signal includes a template storing module for storing the template table.

Description

Method and apparatus for searching records in a subscriber management system for Windows using a template

The present invention relates to a database system, and more particularly, to a method and apparatus for searching multiple condition records in a subscriber management system for Windows.

A record inquiry method in a conventional subscriber management system uses a record inquiry method in a general database application program. In other words, a specific field of the target database table - the value (s) or range (s) of the information item (s) (item) It is to do. The process will be described with reference to the flowchart of FIG.

First, in step 10, an administrator selects a field to specify an item value or a range. When the designated field is displayed by a display means such as a window according to this selection, the administrator inputs a new value or a value to be updated to each item of the record of the specified field (step 20). Finally, if it is determined that all the item values of the desired fields have been designated, the retrieval of the records is completed by storing the values in the database table (step 30).

However, if complex query conditions are used repeatedly frequently or with minor modifications, you must specify these values each time. This designation may not only make administrators of the subscriber management system cumbersome, but may also prevent proper response when prompt response to the inquiry result is required.

Therefore, the present invention stores and manages record search conditions frequently used when a record is retrieved in a subscriber management system as a template, thereby managing subscriber management using a template for a variety of records in the subscriber management system And to provide a record query device in a system.

According to the present invention for achieving the above object, the N field value of the N _{(value 1, value 2, ...} , value N) of the field _{(field 1, field 2, ...} , field N) There is provided an apparatus for inquiring a template table of a subscriber management system in which a pair of a plurality of templates are configured in units of one template, the apparatus comprising: a template table storing and storing the template; A target template storing module for temporarily storing the selected template as a target template; a target template storing module for storing a target template stored in the target template storing module; Provides a visual representation of the template to the user and allows the user to edit it And a template storage module for visually presenting the target template stored in the target template storage module to the user and storing the template in the template table according to the storage command signal.

1 is a flowchart illustrating a record inquiry method in a subscriber management system according to the related art;

2 is a block diagram of an apparatus for inquiring a template table of a subscriber management system using a template according to a preferred embodiment of the present invention

FIG. 3 is a diagram illustrating a subscriber record inquiry process executed in the template table inquiry apparatus of the subscriber management system shown in FIG. 2 on a window

Description of the Related Art

20: template table 22: template load module

24: Template selection module 26: Template temporary storage module

28: Template editing module 30: Template storing module

These and other objects and advantages of the present invention will become more apparent from the following detailed description of the present invention when taken in conjunction with the accompanying drawings.

Hereinafter, preferred embodiments of the present invention will be described in detail with reference to the accompanying drawings.

2 is a block diagram of an apparatus for multi-condition record query in a subscriber management system according to a preferred embodiment of the present invention.

The apparatus of the present invention comprises a template table 20 for storing a template, a module 22 for loading a template, a module 24 for temporarily storing a loaded template, a module 28 for editing a template And a module 30 for saving a template.

The template table 20 may be a database table as a place where templates used to store and manage frequently used query conditions are stored and stored. The template is a template table (20), which is a unit of template units, in which a specific query condition is integrated into one target database table as a target of a query.

Specifically, if the target database table to be searched consists of N fields (field ₁ , field ₂ , ..., field _N ) and each field contains N values (value ₁ , value ₂ , ...). ., value _N ), one query condition will consist of the condition values of up to N fields. Here, the term condition value refers to a string representing a constraint condition that can be interpreted as SQL (standard query language) and constitute a recordset in the database. Therefore, the following template table is created to manage the pair of N field values of N values (value ₁ , value ₂ , ..., value _N ) as one template unit.

Template table

Template Name Value of field _One Value of field ₂ .... Value of field _N template _One value ₁₁ value ₁₂ .... value _1N template ₂ .... value ₂₁ .... value ₂₂ .... .... .... value _2N ....

The template table consists of a Template Name field and fields representing the condition values of each field in the target database table. The Template Name field is a unique name to be used as the template identifier, which is automatically assigned by the subscriber management system or assigned by the subscriber management system administrator. The field of Value of Field _i (i = 1, 2, ..., N) is a lookup value of the i-th field of the target database table. If the subscriber management system administrator designates the value, If it is not a field, it is left blank. One record in the template table represents one template.

That is, the template name template ₁ has a field to field ₁ of the first condition value of the _N field, value _11, value _12, ..., _1N and the value is assigned, the template name template _2, the field ₁ to field values of the second field _N, value ₂₁ , value ₂₂ , ..., value _2N are allocated.

The template load module 22 loads the templates in the template table 20 and lists the loaded templates when receiving an external command signal from the subscriber management system manager or the user.

The template selection module 24 allows the user to select a desired template from the list of listed templates. The selected template is registered in the target template storage module 26 as the target template.

The target template storage module 26 is used to temporarily store one template, i.e., the target template selected by the user, as an internal storage location in the main memory.

The template edit module 28 performs the function of visually presenting the target template stored in the target template storage module 26 to the user and allowing the user to edit it.

The template save module 30 performs the function of storing the target template stored in the target template storage module 26 in the template table 20 according to the user's save command signal.

Referring to FIG. 3, there is shown a window implemented on a window, the result being executed by the record query device using the template shown in FIG. In this regard, Visual Basic 4.0 Enterprise Version was used as the development tool and Microsoft Access 7.0 was used as the database system.

Templates in the template table 20 are loaded and listed in the COMBO BOX 46 by clicking on the Start Query button 42 on the window as shown and by pressing the arrow of the combo box 46, Are listed sequentially one by one. The user closes the visible item selection button 54 on the menu bar 48 so that the currently listed template is selected as the target template and the field value is listed in the list box 60. [

The field values listed in this manner are selected by the vertical movement arrows and moved to the edit value edit edit box 58, and the values of the items in the selected field in the edit box 58 are edited. The field values of the edited target template are edited by clicking on the save button 62 by clicking the delete button 64 and the new designation button 66 selected by the user, 20).

As described above, the retrieval conditions used repeatedly by using the template are stored and have the following advantages whenever they are utilized.

It is possible to more quickly respond to a specific inquiry processing request, thereby increasing the operational performance of the subscriber management system and reducing the input error that may occur during the key input of the same contents, so that the accuracy of the inquiry operation can be enhanced. In addition, it is possible to increase the psychological satisfaction of the user by allowing the user to avoid simple repetitive tasks.

Claims (2)

If the database consists of N fields of (field ₁ , field ₂ , ..., field _N ), and each field contains N field values (value ₁ , value ₂ , ..., value _N ) In a database of an established subscriber management system, A template table in which pairs of N field values of (value ₁ , value ₂ , ..., value _N ) are configured in one template unit so that specific query conditions can be configured as one unit and managed for each constituent unit Wherein the template table comprises a template identifier field and fields indicating condition values of the respective fields of the database. A subscriber management system in which pairs of field values of _N (value ₁ , value ₂ , ..., value _N ) fields of N (field ₁ , field ₂ , ..., field _N ) A template table inquiry apparatus A template table in which the templates are stored and stored; A template load module that loads the templates in the template table according to the inquiry start command signal and lists the loaded templates; A template selection module for selecting a desired template from the listed templates; A target template storage module for temporarily storing the selected template as a target template; A template editing module for visually presenting a target template stored in the target template storing module to a user and allowing a user to edit the target template; And a template storage module for storing the target template stored in the target template storage module in the template table according to a storage command signal.