JP2000125189A - Compiler and program edit device - Google Patents

Abstract

PROBLEM TO BE SOLVED: To obtain a program edit device or the like that more efficiently, more quickly and more accurately produces an execution program for a digital broadcast program that consists of moving picture and audio data and of additional information including on-screen display graphics whose contents are subject to change. SOLUTION: The program edit device edits and compiles a digital broadcast program and is provided with a scene edit section 301/a source program generating section 302 that generate a source program including a database query relating to retrieval of replacement object data stored in a database and with a compile section 303 that compiles the source program. Then the compile section 303 includes a database access section 3031 that retrieves replacement object data from the database according to the database query and a data replacement section 3032 that replaces the database query in the source program with the retrieved replacement object data.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a compiler for producing an execution program, and a program editing apparatus for producing an execution program for a digital broadcast program. The present invention relates to a technique for producing an execution program of a digital broadcast program, which comprises an audio program and audio and additional information including on-screen display graphics.

[0002]

2. Description of the Related Art In recent years, digital satellite broadcasting and the like have exploded with the progress of digital technology such as moving image compression, and television broadcasting which has been conventionally broadcast in analog has been digitized. MP as video compression method
EG (Moving Picture Image Coding Experts Group)
The standardized format is widely used, and all of the digital satellite broadcasts already commercialized adopt a transmission format conforming to the MPEG2 transport stream standard.

In the MPEG2 transport stream standard, data of various additional information can be multiplexed in addition to moving image and audio data. Typical additional information includes on-screen display graphics (O
SD). This is information on character strings and bitmaps to be superimposed and displayed on the video, such as button figures for receiving selection operations (interactive operations) by the user, commentary on video scenes (multimedia data), and the like.
Each display position and each display timing are shown.

In order to produce a digital broadcast program in which such additional information is multiplexed, a digital broadcast program editing device having a multimedia editing function is required. On the other hand, a multimedia editing apparatus having a multimedia editing function using a randomly accessible disk medium such as a CD-ROM is disclosed in Japanese Patent Laid-Open No. 5089/1990.

This multimedia editing apparatus creates a window for creating layout information by editing the display position and size of multimedia data on a screen, and creates timing information by editing the display timing on a time axis. So-called scenario information including a window and layout information and timing information corresponding to each multimedia data is created.

When the multimedia presentation including the scenario information produced here is reproduced, each multimedia data is sequentially read from the disk medium based on the scenario information, and the corresponding layout is displayed at the display timing indicated by the corresponding timing information. The read multimedia data is displayed at the display position indicated by the information. In addition, a device that reproduces MPEG video information as multimedia data has been developed.

[0007] Such a multimedia editing apparatus generally has a position and a size of a character string or a bit map to be displayed.
It is designed so that the user can easily edit the display timing and the like. In order to perform such editing more easily, there is a method of dividing the configuration of the multimedia editing apparatus into two functional blocks. The first function block creates layout information and timing information. The scenario information created here is output as a source program. The second function block converts (compiles) the source program into the final transmission format data format
I do.

[0008] By constructing the multimedia editing apparatus with such two functional blocks, when repeatedly producing a standard presentation having different contents, the user is an output of the first functional block in another presentation. A target presentation can be easily produced based on the source program only by changing only the parts having different contents directly or by using a dedicated conversion program or the like, so that the production time can be greatly reduced.

As an example of such a method, an ISO
/ IEC 13522-5 (Information
Technology-Coding of Mu
ltmedia and Hypermedia I
nformation Part5-Suppor
t for base-level Interact
live Applications)
HEG-5 (Multimedia and Hyper)
rmedia Coding ExpertGroup
Part 5) A source program format for application description of the standard is exemplified.

For example, when producing a weather forecast program,
It is not very efficient to re-edit the entire program every time the weather forecast information changes. Therefore, the multimedia editing function provided in the digital broadcast program editing device is provided by the above-mentioned 2
With the first functional block, the editor previously produces a source program of a weather forecast program based on arbitrary weather forecast information in the first functional block, and every time the weather forecast information changes, the editor changes the temperature. Character strings such as
And change only the forecast weather bitmap, etc.
By compiling with a functional block, the efficiency of program production can be improved.

[0011]

However, even with such a digital broadcast program editing apparatus, when a program such as a weather forecast program that is a fixed form but whose contents change every moment is produced. However, despite the fact that program production is being streamlined, it is necessary to change the source program every time it changes, the work is complicated, and the original information is reflected after being updated There is a problem that there is a delay until that time, and there is a possibility of a correction error.

Accordingly, the present invention provides a compiler, a program editing apparatus, and a computer recording these programs, which more efficiently, more quickly, and more accurately produce an executable program whose contents change in a fixed form. To provide a readable storage medium

[0013]

SUMMARY OF THE INVENTION A compiler according to the present invention is a compiler for compiling a source program, comprising: an obtaining means for obtaining a source program including a database question sentence relating to a search for replacement target data stored in a database; Searching means for searching the database for the replacement target data in accordance with the database question sentence, data replacement means for replacing the database question sentence in the source program with the searched replacement target data, and replacing the database question sentence with the replacement target data. Compiling means for compiling the replaced source program.

Thus, the source program can be compiled while the replacement target data is retrieved from the database in accordance with the database question sentence. Therefore,
More efficient, faster, and more accurate execution programs can be created. Further, a program editing apparatus according to the present invention is a program editing apparatus for editing and compiling a digital broadcast program, wherein the source program generates a source program including a database question sentence relating to a search for replacement target data stored in a database. A compiling unit for compiling the source program, wherein the compiling unit comprises: acquiring means for acquiring the source program; and retrieving means for retrieving the replacement target data from the database according to the database query. Data replacement means for replacing the database question sentence in the source program with the searched replacement data, and compiling means for compiling a source program in which the database question sentence has been replaced with the replacement target data are included.

Thus, the source program can be generated by replacing the undetermined data with the database question sentence in advance, and the source program can be compiled while directly searching the determined data from the database.
Therefore, an execution program of a digital broadcast program can be produced more efficiently, more quickly, and more accurately.

[0016]

Embodiments of the present invention will be described below with reference to the drawings. The compiler included in the program editing apparatus according to the present invention retrieves the latest information from the database by executing the database question sentence embedded in the source program at the time of compilation, and easily produces the latest execution program. (Configuration) FIG. 1 is a block diagram schematically showing a digital broadcast program editing apparatus according to an embodiment of the present invention.

The digital broadcast program editing apparatus 100 is constituted by a general personal computer, a work station or the like. Therefore, the digital broadcast program editing apparatus 100 includes a CPU 101, a memory 102, a display 103, a keyboard 104, a mouse 105, a hard disk 106, a serial input port 107, a serial output port 108, and a parallel output port 109.
And a system in which basic software such as an operating system and an application program for realizing functions unique to the present invention are mounted on these hardware.

An application program for realizing functions unique to the present invention is stored in the hard disk 106, transferred to the memory 102 in response to a user operation, and executed by the CPU 101. FIG. 2 is a diagram illustrating an example of a display screen in a digital broadcast program. On the screen 200, the on-screen display graphics 20 of the weather forecast information, which is additional information, is superimposed on the movie moving image stream 201 as the main information.
2 is displayed.

Here, a digital broadcast program is a moving image,
The broadcast program is composed of audio and on-screen display graphics, and main information including a video stream and an audio stream and additional information including on-screen display graphics to be superimposed on the video stream are digitized and multiplexed. It is a program that is converted and broadcast.

FIG. 3 is a module configuration diagram of an application program according to the embodiment of the present invention. The application program includes a scene editing unit 301, a source program generating unit 302, a compiling unit 303, and a compiler starting unit 304.

The scene editing unit 301 edits the contents of individual scenes constituting a program according to a user's editing operation.
For example, the contents of the on-screen display may be changed according to the user's editing operation to specify the position and size of a character string or a bitmap to be superimposed and displayed as an on-screen display on the video stream which is the main information, the display timing, and the like. To edit.

The scene editing unit 301 includes a position specifying unit 301
1. Type selection unit 3012, fixed character string input unit 301
3 and a question sentence input unit 3014. The position specifying unit 3011 is a module that controls display of a mouse cursor, for example, and allows the user to specify a display position on the screen of a character string to be displayed as an on-screen display.

The type selection unit 3012 displays a type (fixed type) in which a character string to be displayed is already determined at the time of editing.
The user is asked to select a type (variable type) that is not determined at the time of editing and is determined later. The fixed character string input unit 3013 is activated when the result of selection by the type selection unit 3012 is “fixed type”, and accepts input of the content of the character string to be displayed from the user.

The question input unit 3014 is a type selection unit 3
It is started when the result of the selection in 012 is “variable type”, and receives from the user specific information for specifying the character string to be displayed in the database in order to search the contents of the character string to be displayed from the database. The source program generation unit 302 generates a source program according to a predetermined format using the editing result of the scene editing unit 301, and stores the source program in the hard disk.

The source program generation unit 302 includes a question sentence output unit 3021. The question sentence output unit 3021
The specific information received by the question sentence input unit 3014 is output as a database question sentence in a predetermined format at the position of the corresponding character string to be displayed in the source program. Here, the database question sentence includes information on a search for a character string to be displayed, and is used to search a character string to be displayed from the database.

The compiling section 303 reads the source program generated by the source program generating section 302 from the hard disk, converts the source program into stream data in a broadcastable format, and sends the stream data from the parallel output port 109 to external broadcasting equipment. The compiling unit 303
Database access unit 3031, data replacement unit 303
2 and an update notification unit 3033.

The database access unit 3031 accesses an external database and searches for a character string to be displayed according to a database question sentence embedded in the source program at the time of compilation. Data replacement unit 30
Numeral 32 replaces the database question sentence embedded in the source program with the character string to be displayed searched by the database access unit 3031.

The compiling unit 303 includes the data replacing unit 30
At 32, the source program in which the database question sentence has been replaced with the character string to be displayed is compiled. Update notification unit 30
33 sends an end signal indicating that the compilation is completed and the broadcastable stream data can be sent from the parallel output port 109 to the external broadcasting equipment via the serial output port 108.

The compiler activation section 304 activates the compilation section 303 independently. The compiler activation unit 304
An activation trigger detection unit 3041 is included. Activation trigger detection unit 3
Reference numeral 041 receives via the serial input port 107 an update notification that the contents of the target database have been updated. The compiler activation unit 304 activates the compilation unit 303 alone when there is an instruction from the user and when the activation trigger detection unit 3041 receives the update notification.

The question input unit 3014 includes a type selection unit 3
It is started when the result of the selection in 012 is “variable type”, and receives from the user specific information for specifying the character string to be displayed in the database in order to search the contents of the character string to be displayed from the database. Here, the database stores at least one or more tables in which one or more records each being a data set for each of a plurality of fields are described.

FIG. 4A shows an example of a character string to be displayed stored in the database. The field means the vertical column of the table, and each item name is described at the top. In FIG. 4A, the item name of the field 401 is “region”, the item name of the field 402 is “weather”, the item name of the field 403 is “temperature”, and the item name of the field 404 is “precipitation probability”.

The record in FIG. 4A is a set of data in one row on the side of the table. FIG. 4B is a detailed module configuration diagram of the question sentence input unit 3014.
The question sentence input unit 3014 includes a database specifying unit 3014.
1, table selection unit 30142, field selection unit 3014
3. Search key input unit 30144 and question sentence generation unit 3
0145.

The database specifying unit 30141 receives an input from a user and specifies a target database. The table selection unit 30142 includes the database identification unit 30
The table in the database designated by 141 is displayed as a list, and one of the tables is selected by the user. The field selection unit 30143 displays a list of fields in the table designated by the table selection unit 30142, and allows the user to select one of them.

The search key input section 30144 is provided in the table selection section 3
The input of the condition for specifying the record in the table designated by 0142 is accepted. The search key input unit 301
Reference numeral 44 may display a list of field information indicating the fields of the table specified by the table selection unit 30142 and allow the user to select the field information, or may display a list of the contents of the selected field and allow the user to select the field. .

The question generating section 30145 includes the table selecting section 30
142, a database question sentence is automatically generated based on the results selected and input by the field selection unit 30143 and the search key input unit 30144. (Operation) FIGS. 5A to 5D are diagrams sequentially showing display screens when the scene editing unit 301 edits a fixed type character string.

The operation of editing a fixed type character string will be described with reference to FIGS. 5 (a) to 5 (d). (1) First, the user uses the position specifying unit 3011 to specify a position where a character string is to be displayed as shown in FIG. More specifically, for example, the user operates the mouse 105 while referring to the arrow 501 shown in FIG. 4A, starts dragging from the upper left corner of the position to be displayed, and releases the mouse at the lower right corner. A rectangular dashed line 502 is displayed on the display device 103, and a position where a character string is to be displayed is specified.

(2) When the position where the character string is to be displayed is specified, the type selection unit 3012 displays a window shown in FIG. 5B, and uses whether the character string to be displayed is a fixed type or a variable type. Let others choose. Here, it is assumed that the user has selected the fixed type. (3) When the fixed type is selected, the fixed character string input unit 3
Reference numeral 013 displays the window shown in FIG. 5C, and accepts input of the content of the character string to be displayed from the user. Here, an example in which the user inputs “Tokyo” is shown.

(4) When the input of the character string to be displayed is received, the scene editing unit 301 displays the editing screen shown in FIG. 5D, and the editing of one fixed type character string is completed. (5) The user repeats the above operations (1) to (4),
For example, as shown in FIG. 2, other fixed type character strings "Osaka", "Tomorrow's weather", "Temperature", and "Precipitation probability"
Are sequentially edited.

FIGS. 6A to 6E show the scene editing unit 30.
FIG. 1 is a diagram sequentially showing a display screen when a character string of a variable type is edited. The operation of editing a variable type character string will be described with reference to FIGS. (1) The designation of the display position of the character string is the same as that in FIG.

(2) When the position where the character string is to be displayed is designated, the type selection unit 3012 displays the window shown in FIG. 6A, and uses whether the character string to be displayed is a fixed type or a variable type. Let others choose. Here, it is assumed that the user has selected the variable type. (3) When the variable type is selected, the database specifying unit 30141 displays a window shown in FIG.
Let the user select the target database from the list of available databases. Here, "weather", "stock price", and "exchange rate" are listed as available databases, and it is assumed that the user has selected the "weather" database.

(4) When a database is selected, the table selecting unit 30142 displays a window shown in FIG. 6C, and selects a target from a list of tables included in the database selected by the database specifying unit 30141. Is selected by the user. Here, as a selectable table, “the day forecast” and “next day forecast” are displayed in a list, and it is assumed that the user has selected the “next day forecast” table.

(5) When a table is selected, the field selection unit 30143 displays the window shown in FIG. 6D, and selects the last field from the list of fields constituting the table selected by the table selection unit 30142. The user is caused to select a field storing character string data to be displayed on the screen. Here, the available fields are "Region"
"Weather", "Temperature" and "Precipitation probability" are listed,
Assume that the user has selected the "weather" field.

(6) When a field is selected, the search key input unit 30144 displays the window shown in FIG. 6E, and from the list of fields constituting the table selected by the table selection unit 30142. Let the user select the field to be used as the search key and let the user specify its value. Here, the available fields are "Region"
"Weather", "Temperature" and "Precipitation probability" are listed,
It is assumed that the user has selected the "region" field and has designated the value as "Tokyo".

(7) When all the selections and designations are completed, the question sentence generation unit 30145 generates a database question sentence based on the contents specified in the above (3) to (6) and stores it in the memory 102. I do. FIG. 7 is a diagram showing an example of the database question sentence generated in the above (7). The database question sentence shown in FIG. 7 is described as text data using the Shift-JIS character code system, and is a search command according to a general SQL grammar.
In FIG. 7, the first line indicates that the target database is the “weather” database, and the second line indicates that the value of the “region” field in the “next day forecast” table in the target database is This indicates that a record "Tokyo" is searched, and the value of the "weather" field of the record is retrieved.

(8) The user repeats the above operations (1) to (7), and as shown in FIG. 2, for example, character strings of other variable types such as "temperature of Tokyo", "probability of precipitation in Tokyo",
"Osaka tomorrow's weather", "Osaka temperature", and "Osaka precipitation probability" are sequentially edited. The user edits the scene editing unit 30
After performing the above-described series of editing operations using No. 1, the source program generation unit 302 is activated.

The source program generation unit 302 started by the user refers to each database question sentence stored in the memory 102, generates a source program in a format that can be input to the compilation unit 303, and stores the source program in the hard disk 106. Remember. FIG. 8 is a diagram illustrating a part of a program list of a source program output by the source program generation unit 302. In FIG. 8, a line number is added at the beginning for convenience of explanation.

Line number 1 in the source program of FIG.
8 are portions corresponding to the fixed type character string "Tokyo" shown in FIG. “<TEXT” in line number 1 is a tag that declares that it is the first definition of a character string to be displayed on the on-screen display. Line number 2 "P
“OSITION = 32 400” indicates the position on the screen where this character string should be displayed in XY coordinates, and the coordinate value (32, 400) of the drag start position designated by the position designation unit 3011 is output here. ing.

Similarly, “SIZE = 32” in line number 3
"16" indicates the width and height of the area in which this character string is displayed in XY coordinates, and here, the difference between the drag start position and the drag end position specified by the position specifying unit 3011 (3
2, 16) are output. Line number 4 "DYNAM
“IC_FLAG = 0” indicates whether or not this character string is a variable type. Here, “0” is set according to the selection result in the type selection unit 3012. It shows that it is a fixed type.

If this string is not a variable type,
The source programs on line numbers 5 and 6 have no particular meaning. “STRINGS =“ Tokyo ”” in line number 7 indicates the value of the fixed type character string itself, and the input result “Tokyo” by the fixed character string input unit 3013 is output here.

">" In line number 8 is a tag declaring that it is the last of the definition of the character string to be displayed on the on-screen display. Line numbers 10 to 17 in the source program of FIG. 8 are portions corresponding to the variable type character string "Tomorrow's weather in Tokyo" shown in FIG. Here, the line numbers 10 to 12 and 17 are the same as in the case of the fixed type character string, and the description is omitted.

Line number 13 "DYNAMIC_FLAG
= 1 "indicates whether or not this character string is a variable type, as in the case of the line number 4. Here, the type selection unit 3012
Is set to "1" in accordance with the selection result in "1", indicating that this character string is a variable type. Line number 14
The database question sentence generated by the question sentence generation unit 30145 is output to the parts of ~ 15. Here is Figure 7
Is output.

If this character string is not a fixed type,
The source program at line number 16 has no particular meaning.
The same applies to other character strings, so the description is omitted. The above-described scene editing and source program generation are performed only once before the broadcast of the program, and the source program obtained here is stored in the hard disk 106. .

FIG. 9 is a flowchart showing the compile operation after the variable type character string is determined. The operation at the time of compilation after the character string of the variable type is determined will be described with reference to FIG. (1) The activation trigger detection unit 3041 constantly monitors an input signal from the serial input port 107 of the device (step S1).

(2) Upon receiving an input signal from the serial input port 107, the activation trigger detection unit 3041 determines whether the input signal is an update notification indicating that the contents of the target database have been updated. (Step S
2). Here, it is assumed that a notification that the content of the “weather” database has been updated is received. (3) If the input signal is an update notification indicating that the content of the target database has been updated, the compiler activation unit 3
04 activates the compiling unit 303 alone (step S3).

(4) Database access unit 3031
However, it is determined whether there is an unprocessed database question sentence (step S4). (5) If it is determined that there is an unprocessed database question sentence, the database access unit 3031 detects a database question sentence embedded in the source program (step S5). Here, in the source program, the definition of the character string in which “DYNAMIC_DATA” is set to “1” is searched.
The database question sentence shown in 4 to 15 is detected.

(6) Database access unit 3031
However, an external database is accessed according to the detected database question sentence to search for a character string to be displayed (step S6). Here, the weather database is accessed to search for the character string "Hare" to be displayed in accordance with the database question sentence indicated by the line numbers 14 to 15 in FIG. (7) The data replacement unit 3032 replaces the detected database question sentence with “STRING” including the searched character string.
Although it is replaced with the "S" line, the database question sentence is stored in preparation for another search (step S7). Here, as a result, “ST” including the searched character string “
The "RINGS" line is replaced with the "STRI" line indicated by line number 16 in FIG.
NGS "line.

FIG. 10 is a diagram showing a part of the program list processed in the above (7) based on FIG. (8) The above processes (4) to (7) are repeated until there is no unprocessed database question sentence (steps S4 to S4).
7). Here, for example, as shown in FIG. 2, the character strings of other variable types “Tokyo temperature”, “Tokyo rain probability”, “Tomorrow weather in Osaka”, “Osaka temperature”, and “Osaka rain probability” Is performed on the database question sentence corresponding to "."

(9) When there is no unprocessed database question sentence, the compiling unit 303 causes the database access unit 3031 and the data replacing unit 3032 to execute the above (1).
The source program after the processing of (8) is performed is converted into stream data of a format that can be broadcast, and transmitted from the parallel output port 109 to external broadcasting equipment (step S8). In FIG. 10, row numbers 2 and 11
“POSITION” line, line numbers 3 and 12 “SIZ”
The “E” line and the “STRINGS” lines with line numbers 7 and 16 are targets of the compile processing.

(10) When the compilation is completed, the update notifying unit 3033 sends an end signal indicating that the compilation has been completed and broadcastable stream data can be output from the parallel output port 109 to the serial output port 108.
(Step S9). (11) Thereafter, the external broadcasting equipment which has received the end signal reads the stream data and multiplexes it with main information composed of a moving image stream and an audio stream to broadcast.

(12) Each time the contents of the target database are updated, the above processing is repeated. As described above, the digital broadcast program editing apparatus according to the present embodiment generates a source program by replacing undetermined data in advance with a database query, and is updated directly from the database every time data is updated. Since the source program is compiled while searching for the data, it is possible to always produce a program based on the latest information.

Although the digital broadcast program editing apparatus according to the present invention has been described based on the embodiments, it is needless to say that the present invention is not limited to these embodiments. (1) In the present embodiment, the dynamically changeable presentation object is character string data. However, any data may be used. For example, text data, bitmap data, and a color for specifying a display color may be used. It may be data or the like.

(2) In the present embodiment, the database question sentence conforms to the SQL grammar, but any grammar may be used. (3) In the present embodiment, compilation is started every time data is updated. However, compilation is started at any time from the time data is updated to the time of broadcasting, or the compilation is started periodically at a predetermined time. It may be one that starts compilation. For example, in a program related to weather information, compilation is started at a predetermined time several times a day and at the time when a warning or a warning is announced by the Japan Meteorological Agency. May be always started to update the program, and flexible operation is possible according to the content of the program.

(4) In the present embodiment, scene editing is executed interactively. However, such a scene editing function is not essential to the present invention, and a user can generally edit a source program including a database question sentence. It may be directly described by a typical text editor. (5) In the present embodiment, the question sentence input unit includes the database specifying unit and the table selecting unit. However, when only one database can be used, the database specifying unit can be omitted.
When only one table can be used, the table selecting unit can be omitted.

[0064]

(A) A compiler according to the present invention is a compiler for compiling a source program, and means for obtaining a source program including a database question sentence relating to a search for replacement target data stored in a database; Searching means for searching the database for the replacement target data in accordance with the database question sentence, data replacement means for replacing the database question sentence in the source program with the searched replacement target data, and replacing the database question sentence with the replacement target data And a compiling means for compiling the selected source program.

As a result, the source program can be compiled while the replacement target data is searched from the database in accordance with the database question sentence. Therefore,
More efficient, faster, and more accurate execution programs can be created. (B) In addition, in (A), the database contains one record as a data set for each of a plurality of fields.
One or more tables are stored, and the database question sentence includes table information for specifying one of the tables, a search key for specifying one of the records included in the table, and one of the fields. Specifying the field information specified by the search key in the table indicated by the table information from the database as the replacement target data. Can also be characterized.

As a result, the data to be replaced can be held efficiently and can be searched quickly. (C) A program editing apparatus according to the present invention is a program editing apparatus that edits and compiles a digital broadcast program, and generates a source program including a database question sentence relating to a search for replacement target data stored in a database. A program generation unit, and a compiler unit for compiling the source program, wherein the compiler unit obtains the source program, and searches for the replacement target data from the database according to the database query.
Data replacement means for replacing a database question sentence in the source program with replacement target data searched out, and compile means for compiling a source program in which the database question sentence has been replaced with the replacement target data.

Thus, the source program can be compiled while searching for the determined data directly from the database. Therefore, an execution program of a digital broadcast program can be produced more efficiently, more quickly, and more accurately. (D) Further, the source program generating unit of (C) includes a specific information receiving unit that receives an input of specific information for specifying data to be replaced in the database instead of the undetermined data; Alternatively, the information processing apparatus may further include a replacement generating unit that generates a source program using a database question sentence corresponding to the specific information received by the specific information receiving unit.

Thus, the source program can be generated by replacing the undetermined data with the database question sentence in advance. (E) In (D), the database stores one record as a data set for each of a plurality of fields.
At least one table described above is stored, the specific information receiving unit is a table selecting unit that allows a user to select one of tables stored in the database, and a field of the table specified by the table selecting unit. Field selection means for allowing the user to select one of the following, search key input means for allowing the user to input a search key for specifying a record included in the table specified by the table selection means, table selection means, field selection means And a question sentence generating means for generating a database question sentence based on the result selected and inputted by the search key input means.

This eliminates the need for the user to learn the description format of the source program or to design and input a complicated program, so that anyone can easily edit the program and perform rework due to programming mistakes. Can be suppressed. (F) Further, in (E), the table selecting means displays a list of the tables stored in the database and allows the user to select the list, and the field selecting means displays a field of the table specified by the table selecting means. The information is displayed in a list to allow the user to select, and the search key input means displays the field information indicating the field of the table designated by the table selecting means in a list and allows the user to select and use the contents of the selected field. It is also possible to have the user input.

This allows the user to set search conditions through interactive operations, eliminating the need to learn the grammar of a database question sentence, and determining what information is stored in the database. You can edit while checking. (G) Further, in any one of (C) to (F), the program editing apparatus may include main information including a moving image stream and an audio stream, and additional information including on-screen display graphics to be superimposed on the moving image stream. And editing the additional information in producing a digital broadcast program multiplexed with the above. The undetermined data is any one of the text data for on-screen display graphics, bitmap data, and color data. It can also be characterized by.

Thus, the program editing apparatus according to the present invention multiplexes and broadcasts the main information including the moving picture stream and the audio stream and the additional information including the on-screen display graphics to be superimposed on the moving picture stream. Digital broadcast programs can be edited by the user, and a variety of additional information such as weather forecasts, stock price information, and exchange rate bulletins can be broadcast along with ordinary programs.

(H) Further, the compiler unit of any one of (C) to (G) can be started independently. Thus, once a source program is generated, compilation can be performed any number of times without re-editing the source program each time the contents of the database change, and the latest stream data in a format that can be broadcast is shortened. It can be generated in time.

(I) The compiler unit of (H) further includes an update notification receiving means for receiving an update notification indicating that the contents of the database have been updated, and an update notification receiving means for receiving the update notification. In such a case, it may be characterized in that it includes a starting means that starts independently. Thus, when the target database is updated, the compilation can be automatically started, and automation and real-time of the entire system can be achieved.

(J) Further, the compiler unit of (I) may further include an end notification transmitting means for transmitting an end notification indicating that the compilation has been completed to the broadcasting equipment. As a result, when the compilation is completed, the result can be automatically read by the broadcast facility, and the entire system can be automated and real-time.

(K) A computer-readable storage medium according to the present invention is characterized by recording a program for causing a computer to function as the device according to any one of (A) to (J). Thereby, the same effects as those of the above (A) to (J) can be obtained.

[Brief description of the drawings]

FIG. 1 is a block diagram schematically showing a digital broadcast program editing apparatus according to an embodiment of the present invention.

FIG. 2 is a diagram showing an example of a display screen in a digital broadcast program.

FIG. 3 is a module configuration diagram of an application program according to the embodiment of the present invention.

FIG. 4A is a diagram illustrating an example of a character string to be displayed stored in a database. FIG. 4 (b)
FIG. 14 is a detailed module configuration diagram of a question sentence input unit 3014.

FIGS. 5A to 5D are diagrams sequentially showing display screens when the scene editing unit 301 edits a fixed type character string.

FIGS. 6A to 6E are diagrams sequentially showing display screens when the scene editing unit 301 edits a variable type character string.

FIG. 7 is a diagram showing an example of a database question sentence.

FIG. 8 is a diagram showing a part of a program list of a source program.

FIG. 9 is a diagram illustrating an operation flowchart of compilation after a character string of a variable type is determined.

FIG. 10 is a diagram showing a part of a program list.

[Explanation of symbols]

 REFERENCE SIGNS LIST 100 digital broadcast program editing apparatus 101 CPU 102 memory 103 display 104 keyboard 105 mouse 106 hard disk 107 serial input port 108 serial output port 301 scene editing section 302 source program generation section 303 compilation section 304 compiler activation section 3011 position designation section 3012 type selection section 3013 Fixed character string input unit 3014 Question sentence input unit 3021 Question sentence output unit 3031 Database access unit 3032 Data replacement unit 3033 Update notification unit 3041 Activation trigger detection unit

 ──────────────────────────────────────────────────続 き Continued on the front page (72) Inventor Shigeaki Watanabe 1006 Kazuma Kadoma, Kadoma City, Osaka Prefecture Matsushita Electric Industrial Co., Ltd. F-term (reference) 5B075 ND16 PP02 PP03 PP12 PP30 PQ02 5C023 AA02 AA04 AA18 AA38 CA01 CA04 CA05 DA04 DA08

Claims (11)

[Claims] 1. A compiler for compiling a source program, comprising: obtaining means for obtaining a source program including a database question sentence relating to a search for replacement target data stored in a database; Search means for searching for replacement target data; data replacement means for replacing the database question sentence in the source program with the searched replacement target data; and compilation for compiling a source program in which the database question sentence has been replaced with replacement target data. And a compiler. 2. The database stores at least one or more tables in which one or more records each being a set of data for each of a plurality of fields are described. Table information to be specified, a search key to specify one of the records included in the table, and field information to specify one of the fields, wherein the search means indicates the table information from the database 2. The compiler according to claim 1, wherein data of a field specified by the field information in a record specified by the search key in a table is searched as replacement target data. 3. A program editing apparatus for editing and compiling a digital broadcast program, comprising: a source program generating unit for generating a source program including a database question sentence relating to a search for replacement target data stored in a database; A compiling unit for compiling a program, wherein the compiling unit comprises: obtaining means for obtaining the source program; searching means for searching the data to be replaced from the database according to the database query; and a database in the source program A program editing apparatus comprising: a data replacement unit that replaces a question sentence with replacement target data retrieved; and a compile unit that compiles a source program in which a database question sentence is replaced by the replacement target data. 4. The information processing apparatus according to claim 1, wherein the source program generating unit is configured to receive, in place of the undetermined data, input of specific information that specifies replacement target data in the database; Using a database question sentence corresponding to the specific information received by the specific information receiving means,
4. The program editing apparatus according to claim 3, further comprising replacement generation means for generating a source program. 5. The database stores at least one table in which at least one record that is a set of data for each of a plurality of fields is described. The specific information receiving unit stores the table. A table selecting means for allowing the user to select one of the tables, a field selecting means for allowing the user to select one of the fields of the table specified by the table selecting means, and a table included in the table specified by the table selecting means A search key input unit for allowing a user to input a search key for specifying a record, a table selection unit, a field selection unit, a selection by a search key input unit, and a query for generating a database question sentence based on the input result. 5. The program editing apparatus according to claim 4, further comprising a sentence generating means. 6. The table selection means displays a list of tables stored in the database and allows a user to select the list, and the field selection means lists field information indicating fields of the table specified by the table selection means. The search key input unit displays a list of field information indicating the fields of the table specified by the table selection unit, prompts the user to select, and allows the user to select the contents of the selected field. 6. The program editing device according to claim 5, wherein the program editing device inputs the information. 7. The program editing apparatus produces a digital broadcast program by multiplexing main information including a moving image stream and an audio stream and additional information including on-screen display graphics to be superimposed on the moving image stream. In doing so, the additional information is edited, and the undetermined data is any of the text data, bitmap data, and color data for the on-screen display graphics. The program editing apparatus according to claim 3. 8. The program editing apparatus according to claim 3, wherein said compiler unit is started independently. 9. The compiler unit further includes: an update notification receiving unit that receives an update notification indicating that the content of the database has been updated; and if the update notification receiving unit receives the update notification, the compiler unit is independently activated. 9. The program editing apparatus according to claim 8, further comprising: a starting unit. 10. The program editing apparatus according to claim 9, wherein the compiler unit further includes an end notification sending unit that sends an end notification indicating that the compilation has been completed to the broadcasting equipment. 11. A computer-readable storage medium in which a program for causing a computer to function as the device according to claim 1 is recorded.