KR19990034705A - Hangul Supportable Video Subscriber Management Database System - Google Patents

Abstract

The present invention relates to an on-demand video subscriber management database system capable of supporting Hangul to solve the problem that the Hangul name of an object of the on-demand video subscriber database is not supported. A table information table for storing a list of Korean characters and a field information table for storing a list of query condition fields to designate a query condition among the fields of the query target database as a list of Korean characters to be displayed on the screen are displayed. The target subscriber database and the inquiry condition field to be specified from this database are displayed in Korean on the screen.

Description

Hangul Supportable Video Subscriber Management Database System

The present invention relates to a subscriber management system for video on demand (hereinafter referred to as a VOD) that can look up various information using a single lookup table, and more particularly, to a subscriber database entity in a VOD subscriber management system. The present invention relates to a VOD subscriber management database system capable of supporting Korean in Korean.

In recent years, with the rapid development of the semiconductor and information and communication industries, the construction of the high-speed information and communication infrastructure, which started from the super highway concept of information, is rapidly spreading, and the information is provided in an interactive and active manner rather than simply receiving the information passively. The desire of the user to obtain a trend is increasing.

As a way to meet these needs, the development of interactive cable television (I-CATV), an advanced form of cable television (CATV), is now being accelerated by leading companies in the world, including South Korea, the United States, and Japan. have.

On the other hand, using the digital interactive cable television service technology instead of the analog method enables a VOD service that enables the television viewer to immediately receive the information (eg, video information) required by the television viewer at a desired time.

In order to realize such an on-demand video service, an information provider consisting of a large capacity server capable of storing and transmitting information, a service provider such as a television broadcasting station, and information required by a service provider through a network at a high speed can be obtained. There is a need for a delivery system provider and a television user to use (or use) service information provided from a delivery system provider for simultaneous delivery to multiple television users.

As described above, a service that can be realized as an on-demand video includes, for example, Movies On Demand (MOD), information that can be immediately obtained by title or field of news, and a service such as news summary or headline can be provided. NOD (News On Demand), remote shopping that provides a video catalog for users to purchase desired products, or a user to browse the showcase, transmission of X-ray images, and end user To store or analyze the transmitted data and transmit the diagnosis and prescribed data to other end users, telemedicine diagnostics, games, home banking, video conferencing, and users that provide general banking services. Agreement services that provide information to and provide services to enable users to transact using this information, Internet can be the Internet access service for a connection with.

The VOD subscriber management system for managing multiple subscribers to the VOD service basically consists of an application using a character-based database. Currently, database management systems that are widely used use structured query language (SQL) statements. Relational database management system.

In such a conventional VOD subscriber management database system, in order to enable a user to search for data corresponding to a specific condition, a separate query module must be implemented for each database table. Therefore, the development of the database system is complicated. In the user's point of view, the inconvenience of having to repeat the cumbersome inquiry process for each database table each time. In addition, many of them do not support Korean characters in database table names or table field names. Therefore, the subscriber management system cannot display information about tables or fields in Korean.

One way to solve this problem is to put a resource file such as a Korean dictionary of database object information in English so that the program can refer to it whenever necessary. However, this method has a problem of changing and re-distributing the database-related resource files whenever the structure of the database changes or changes even a little, or if the database is intact but the Korean content to be displayed for a specific database object changes. .

Since the subscriber management system has a lot of different subscriber management systems accessing a single database server and sharing the same data through a network, the above problems have significant disadvantages in maintenance and maintenance management. will be.

Accordingly, the present invention is to solve the above-described problems of the prior art, the on-demand type so that the information that needs to be displayed on the screen in relation to the database to be queried can be displayed on the screen regardless of the database system or language The purpose is to provide a video subscriber management database system.

In order to achieve the above object, an on-demand video subscriber management database system according to the present invention includes: a first field for storing a list of real names of various subscriber databases to be queried and an actual name of the queried target database to be displayed on a screen; A database information table comprising a second field for storing a list of values; A first field for storing a list of actual names of the database to be queried, a second field for storing names of query condition fields to designate a query condition among fields of the database to be queried, and a query condition among fields of the queried database A field information table comprising a third field for storing a value to be displayed on a screen, wherein the inquiry condition field to designate a fourth field; and a fourth field for storing values of the inquiry condition specified fields; A database list loading module for extracting a list of first and second fields of databases to be queried from the database information table when the inquiry start signal is applied; A database list storage module for storing a list of first and second fields extracted by the database list load module; The query target specified in accordance with a list selection signal for visually displaying a list of the first and second fields stored in the database list storage module, and selectively specifying a query condition of the query target database from the displayed list. A database selection module for extracting a list of query condition designating fields of a database from the table information table; A query condition specifying field storage module for storing a list of query condition specifying fields extracted from the field information table by the database selection module; Display the displayed values of the list of inquiry condition specification fields stored in the inquiry condition specification field storage module and the inquiry condition values for them on the screen, and change the inquiry condition in the displayed table according to the edit signal generated from the user. An inquiry condition editing module for editing with an inquiry condition; An inquiry execution module that executes inquiry conditions edited by the inquiry condition editing module in response to an execution signal from a user; An inquiry result storage module for storing an inquiry result executed by the inquiry execution module; And a result display module configured to display contents stored in the inquiry result storage module on a screen, wherein a list of values to be displayed in the table information table and the second field and the third field of the field information table is configured in Korean. Should be.

1 is a block diagram showing the configuration of an on-demand video subscriber management database management system according to a preferred embodiment of the present invention;

2 is a diagram illustrating a structure of a database information table shown in FIG. 1;

3 is a diagram illustrating a structure of a field information table shown in FIG. 1;

4 is a diagram illustrating a structure of a database list extracted from the database information table shown in FIG. 1;

FIG. 5 is a diagram illustrating a structure of a field list extracted from the field information table shown in FIG. 3;

6 is a diagram illustrating a result screen of executing an on-demand video subscriber management database system according to the present invention.

<Description of the code | symbol about the principal part of drawing>

100: information table 110: field information table

120: list load module 130: list storage module

140: selection module 150: lookup condition specification field storage module

160: query condition editing module 170: query execution module

180: query result storage module 190: result display module

The above objects and various advantages of the present invention will become more apparent from the preferred embodiments of the present invention described below with reference to the accompanying drawings.

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

1 is a block diagram of an on-demand video subscriber management database system having a database system capable of inquiring various information using one lookup table according to a preferred embodiment of the present invention.

On-demand video subscriber management database system according to the present invention is a database table information table 100, field information table 110, database list load module 120, list storage module 130, database selection module 140, query conditions The designated field storage module 150, the inquiry condition editing module 160, the inquiry execution module 170, the inquiry result storage module 180, and the result display module 190 are included.

The database information table 100 is located in a database management system that manages a database for a subscriber management system, and includes a name field and a caption field. The Name field is a field in which names of various subscriber database tables (not shown) to be queried are stored. In this field, actual names commonly used in the database management system are stored. The Caption field is a field in which the caption, which is the name of the database to be searched, is displayed on the screen. According to the present invention, Caption includes a Hangul name.

FIG. 2A shows a detailed configuration of the table information table. The actual names of the database tables to be queried in the Name field are M of name (1), name (2), ..., name (M). The displayed value caption (i) (i = 1, 2, ..., M) of the i th query target database table name (i).

The field information table 110 is a database table having a list of searchable target databases, that is, a name and a caption field, and information of fields to specify a search condition for each query target database. This field information table 110 is composed of Owner, Name, Caption, and IsString fields. The Owner field is a variable length string type field and stores the name of a database table to be queried. The Name field is a field in which the name of an inquiry condition field to specify an inquiry condition among the fields of a query target database is stored. In this field, a name, which is an actual name commonly used in the database management system, is stored. The Caption field is a field for storing a caption which is a value to be displayed on the screen among the fields of a database table to be searched. According to the present invention, Caption includes a Hangul name. The IsString field stores the value of the specified field. In addition, the IsString field further stores information on the type of the value of the query condition designation field. Each field type information described above indicates whether the value of the query condition field is a string type or a non-string such as a number. It has one of the fixed length values "Y" or "N" indicating whether it is a type.

According to such a field type, when a database query is performed, the search result for each field is different. For example, a value of "1234" is stored in a specific field, and the corresponding field type of the database information table 100 is stored. If the value of "Y" is stored, the value "1234" stored in the field is recognized as a string without the unit 1234 (one or two or three), and the field is searched only when the search condition input from the user is specified as a string when multiple queries are made. It is included in the output.

If the "N" value is stored in the above-described field type, the field is recognized in the search result only if the search condition input from the user is designated as the non-string when recognized as the number 1234 (12,300). Will be output. Accordingly, such field type information is stored together in the database information table 120.

3 shows a detailed configuration of the field information table 110, in which all fields of a field of a specific query target database table owner (i) in the field information table 110 to specify an inquiry condition are all n _i (i = 1, 2, ..., M), where Names are name (i, 1), name (i, 2), ..., name (i, n _i ), and Captions are caption (i, j, respectively) )to be. If the value of the IsString field of the j (j = 1, 2, ..., n _i ) th query target field name (i, j) of the i th query target database table is value (i, j), and is a string type, Has a value of "Y", otherwise "N".

The database list load module 120 extracts a list of databases to be searched from the table information table 100, that is, the Name field and the Caption field, when the search start signal for starting the search is applied. After storing in the list storage module 130, it is presented to the user. For example, the above-mentioned inquiry start signal may be written in the following SQL statement, where "SELECT Name, Caption FROM info_tables", and "info_tables" in the SQL statement indicate the name of the table information table 100.

The query target database list storage module 130 stores or stores the Name field and the Caption field extracted by the database list load module 120 as a temporary result table. The inquiry target database list storage module 130 is a means corresponding to the main memory of the computer, and maintains the stored table while the inquiry is executed, and terminates the stored table when the inquiry ends.

The database selection module 140 visually displays a database list stored in the query target database list storage module 130 and causes the displayed database list to be selected / designated according to a selection signal generated from a user. At this time, the query condition designation fields of the query target database selected / specified by the user are extracted from the table information table 110 and provided to the query condition designation field storage module 150. For example, the above-described user selection signal may be written as the following SQL statement, and "SELECT Name, Caption, IsString FROM info_tables WHERE Owner = selected_table", and "selected_table" in the SQL statement indicates the name of the database table selected by the user. Indicates.

The query condition specification field storage module 150 stores or stores the query condition specification fields provided from the database selection module 140 as a temporary result table as shown in FIG. The query condition designation field storage module 150 is a means corresponding to the main memory of the computer, and maintains the temporary result table stored while the query is executed, and terminates the stored table when the query ends.

The query condition editing module 160 displays the captions of the fields stored in the query condition specifying field storage module 150 and the query condition values thereof in the form of a two-dimensional table as shown in FIG. 4. The inquiry condition within can be edited with a new or different inquiry condition according to the edit signal generated from the user. The inquiry condition edited by the inquiry condition editing module 160 is provided to the inquiry execution module 170.

The query execution module 170 converts the query conditions edited through the query condition editing module 160 into SQL statements, executes the query condition converted to SQL statements in response to the execution signal from the user, and displays the query results accordingly. Provided to the search result storage module 180. At this time, the search result is composed of a temporary result table as shown in FIG. 5, and the temporary result table of FIG. 5 is each field (field name) corresponding to the search condition input by the user and a value recorded in each field. It is composed. In addition, for each field, if the IsString value is "Y" (that is, if the field is a string type) by referring to the IsString value in the Lookup Criteria Field Preservation module, the SQL statement is enclosed in " Otherwise, the condition value entered by the user is included in the SQL character. For example, for a string type field StringField and a numeric type field NumberField, when the user specifies the values "one to three" and "1234", the SQL statement is specified as follows:

"SELECT StringFiled, NumberField FROM selected_table

WHERE StringField = "one two three companies" AND NumberField = 1234 "

The query result storage module 180 stores the query result table (see FIG. 5) generated by the query execution module 170. The search result storage module 180 is a means corresponding to the main memory of the computer. When the query is executed, the search result storage module 180 stores and maintains the execution result, and terminates the stored table when the query is finished.

The result display module 190 displays the table contents stored in the inquiry result storage module 180 in a two-dimensional table form on the screen.

6 illustrates a display screen implementing a query result executed on a window according to the system according to the present invention.

As shown, when the inquiry start signal is generated by clicking the inquiry start button 10 on the window and the inquiry is started, the database information table 100 is pressed by pressing the arrow 22 of the combo box 20. The Hangul names corresponding to the actual names of the Name field in the list are sequentially listed one by one, and the selection target 140 names are selected by the selection module 140 according to the user's selection signal. The Hangul name corresponding to the actual name of the inquiry condition field for the inquiry target thus selected is listed in the data item field 32 on the inquiry condition edit sheet 30.

Then, an edit is made to input a search condition in the search condition field 34 on the search condition edit sheet 30, and the search result is displayed on the search result display sheet area 50.

As described above, in the VOD subscriber management system connected to a database management system that does not support the Hangul name of the database object, the Hangul name corresponding to the real name is configured as the Caption field to display the database object in Korean. It offers the benefits of doing so. In addition, the VOD management system implemented in Korean has the effect of minimizing code changes related to the display of database objects when implemented in English or other language versions.

Claims (3)

In the on-demand video subscriber management system that can support on-demand video subscriber database object in Korean, A database information table (100) comprising a first field for storing a list of real names of various subscriber databases to be queried and a second field for storing a list of values for which the real name of the queried database is to be displayed on a screen; A first field for storing a list of actual names of the database to be queried, a second field for storing names of query condition fields to designate a query condition among fields of the database to be queried, and a query condition among fields of the queried database A field information table (110) comprising a third field for storing a value for which an inquiry condition field to specify is to be displayed on the screen and a fourth field for storing values of the inquiry condition specified fields; A database list loading module (120) for extracting a list of first and second fields of databases to be queried from the database information table (100) when the inquiry start signal is applied; A database list storage module 130 for storing a list of the first and second fields extracted by the database list load module 120; And visually displaying a list of the first and second fields stored in the database list keeping module 130, and designated according to a list selection signal for selectively specifying a query condition of the query target database from the displayed list. A database selection module 140 for extracting a list of query condition designation fields of the query target database from the table information table 110; A query condition specification field storage module (150) for storing a list of query condition specification fields extracted by the database selection module (140) from the field information table (110); Display the values to be displayed of the list of inquiry condition specification fields stored in the inquiry condition specification field storage module 150 and the inquiry condition values for them on the screen, and query in the displayed table according to the edit signal generated from the user. An inquiry condition editing module 160 for editing the condition into another inquiry condition; An inquiry execution module 170 for executing inquiry conditions edited by the inquiry condition editing module 160 in response to an execution signal from a user; A query result storage module 180 for storing a query result executed by the query execution module 170; And a result display module (190) for displaying the contents stored in the inquiry result storage module (180) on a screen. The on-demand video subscriber management database system of claim 1, wherein a list of values to be displayed of the second field and the third field of the table information table and the field information table is configured in Korean. The on-demand type of claim 1, wherein the fourth field of the field information table further includes information for distinguishing whether each field configured in each database is a string type or a non-string type such as a number. Video Subscriber Management Database System.