CN102724424B - A kind of method that teletext packaging scene switching is carried out using data file - Google Patents

Abstract

The invention discloses a method for using data files to switch TV graphics and text packaging scenes, which specifically includes: receiving a first TV graphics and text packaging scene file and a second TV graphics and text packaging scene file, and obtaining a first data item; receiving a database file It includes a format mark; the first data item obtains data through a database file; by judging whether there is a format mark in the first data item, the scene switching of the TV graphics and text packaging is performed, which solves the problem of playing data in the TV graphics and text packaging playback system. The problem of switching scenes shortens the production cycle of scene switching, at the same time, reduces the production cost due to scene switching, increases the use of format data, and makes the scene switching function more flexible in the TV graphic packaging playback system.

Description

A Method for Switching TV Graphics and Text Packaging Scenes Using Data Files

technical field

The invention relates to the field of production and data processing of high-standard-definition three-dimensional television graphic-text packaging programs, and is applied to the production and broadcasting of high-standard-definition three-dimensional television graphic-text packaging programs, and particularly relates to a method for switching scenes of television graphic-text packaging by using data files .

Background technique

The application of the graphic system covers all aspects of TV programs, including live news programs, studio interview programs, variety show programs, live sports programs, financial information programs, weather and geography programs, and the production and management of movies and TV dramas. Broadcasting; the application occasions include both live broadcast and post-production, and the applied positions include editing domain, studio and broadcast line. Virtual studio technology is the most successful application example of computer three-dimensional graphics rendering technology in the field of broadcasting and television. Its main application is in news, sports and financial programs, using computer three-dimensional graphics technology controlled by camera lens displacement and video keying and other processing technologies to generate virtual studio scenes, combining the host and physical scenes in front of the camera with The integration of virtual scenes; effectively solves the time and cost problems of studio construction, and can produce more and better visual effects, especially suitable for column production with strong timeliness or large geographical migration. With computer graphics, With the continuous development of image and video technology, coupled with the compatibility and transition between standard definition and high definition in the broadcasting industry, TV production and broadcasting units have put forward higher and newer requirements for TV graphics. It is mainly reflected in rich graphics and text broadcasting effects, professional graphics and text packaging products, and high-definition compatibility. In the existing technology, the graphics and text packaging system will make the scene files that need to be used and broadcasted, and formulate them through control instructions. The switching of each scene meets the needs of broadcasting. In a system that only needs to broadcast scenes, since the switching of scenes cannot be edited, the broadcasting sequence cannot be modified.

In the inventor's process of realizing the present invention, it is found that the prior art has the following defects. In the prior art, the TV graphics and text packaging playback system cannot implement the internal scene program and control commands in the process of playing the graphics and text packaging files. Therefore, the play order of the scenes cannot be adjusted, and the above scene switching function can only be realized by re-generating the play program in the TV graphic packaging system. Therefore, the production cycle of the program is increased, and at the same time, the Production costs.

Contents of the invention

Aiming at the defects in the prior art, the present invention solves the problem of switching scenes by playing data in a TV graphic-text package playing system.

In order to solve the above technical problems, the present invention provides a method for switching teletext packaging scenes by using data files, which specifically includes:

receiving a first teletext scene file and a second teletext scene file, wherein the first teletext scene file includes a scene description file;

Acquiring a first data item according to the scene description file;

receiving a database file, wherein the database file includes formatting marks;

The first data item acquires data through the database file;

Judging whether there is a format identifier in the first data item, if so, playing through the second teletext scene file, otherwise, playing according to the first teletext scene file.

Wherein, the teletext packaging scene file is specifically: a Mariana.5D teletext packaging scene file, and the scene file may include at least one Mariana.5D teletext packaging template.

Wherein, the format mark specifically includes:

Paragraph markers, end markers, section break markers, tab markers, manual line break markers, and white space markers.

Wherein, the step of receiving the database file specifically includes:

Receive a list of database servers;

A database file is received according to the list, and the database file includes the list information.

Wherein, the steps of the first TV graphics scene file and the second TV graphics scene file specifically include:

receiving a first teletext scene file and a second teletext scene file, wherein the first teletext scene file and the second teletext scene file include scene hierarchy information;

Receive TV graphic packaging special effect files;

The teletext special effect file is imported into the first teletext scene file and the second teletext scene file.

Wherein, the first teletext scene file and the second teletext scene file specifically include: corresponding data pool files.

Wherein, the step of obtaining data of the first data item through the external database file specifically includes:

Perform operations according to the data content in the database file described in the SQL statement to obtain the data file after the operation;

The first data item acquires data through the calculated data file.

Wherein, the operation is performed according to the data content in the database file described in the SQL statement, and the step of obtaining the data file after the operation specifically includes:

Perform query operations on row units and/or column units in the database file according to the SQL statement to obtain data.

Wherein, the operation is performed on the data content in the database file according to the SQL statement, and the step of obtaining the calculated data file specifically includes: performing SQL function operations on the row unit and/or column unit in the database file according to the SQL statement ,retrieve data.

Compared with the prior art, the embodiment of the present invention has the following advantages: it realizes the function of switching broadcasting scenes through the identification of the external database file format mark in the TV graphics and text packaging playback system, and reads the scene file Adding SQL statements to edit the database file can obtain more output data as needed, shorten the production cycle of scene switching, and at the same time, reduce the production cost due to scene switching, increase the use of format data, and make TV The scene switching function in the graphic packaging playback system is more flexible.

Description of drawings

In order to more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the following will briefly introduce the drawings that need to be used in the description of the embodiments or the prior art. Obviously, the accompanying drawings in the following description are only These are some embodiments of the present invention. For those skilled in the art, other drawings can also be obtained according to these drawings without any creative effort.

Figure 1: is a schematic diagram of a method for switching teletext packaging scenes using data files in Embodiment 1 of the present invention;

Fig. 2 is a schematic diagram of another method for switching teletext packaging scenes by using data files in Embodiment 2 of the present invention.

detailed description

The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, but not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

Embodiment 1 of the present invention provides a method for using data files to switch between TV graphics and text packaging scenes, as shown in Figure 1, comprising the following steps:

S101: Receive a first scene file and a second scene file;

This step specifically includes: receiving a first teletext scene file and a second teletext scene file, wherein the first teletext scene file includes a scene description file;

S102: Acquiring data items;

This step specifically includes: acquiring a first data item according to the scene description file;

S103: receiving the database file;

This step specifically includes: receiving a database file, wherein the database file includes a format mark;

S104: acquire data;

This step specifically includes: the first data item acquires data through the database file;

S105: Perform scene switching;

This step specifically includes: judging whether there is a format identifier in the first data item, and if so, playing through the second teletext scene file; otherwise, playing according to the first teletext scene file.

Embodiment 2 of the present invention provides another method for using data files to switch teletext packaging scenes, as shown in Figure 2, comprising the following steps:

S201: Receive a first scene file and a second scene file;

This step specifically includes: receiving a first teletext scene file and a second teletext scene file, wherein the first teletext scene file includes a scene description file; and the teletext scene file is specifically: A Mariana.5D teletext packaging scene file, the scene file may include at least one Mariana.5D teletext packaging template. Wherein, the first teletext scene file and the second teletext scene file specifically include: corresponding data pool files.

The steps of the first TV graphics scene file and the second TV graphics scene file specifically include step S2011: receiving the special effect file:

Receive the first teletext scene file and the second teletext scene file, the first teletext scene file and the second teletext scene file include scene level information; receive the teletext special effect files; importing the teletext special effect file into the first teletext scene file and the second teletext scene file.

S202: Acquiring data items;

This step specifically includes: acquiring a first data item according to the scene description file;

S203: receiving the database file;

This step specifically includes: receiving a database file, wherein the database file includes a format mark;

The step of receiving the database file specifically includes:

Receive a list of database servers;

A database file is received according to the list, and the database file includes the list information.

The format mark specifically includes:

Paragraph markers, end markers, section break markers, tab markers, manual line break markers, and white space markers.

S204: acquire data;

This step specifically includes: the first data item acquires data through the database file;

The step of obtaining data of the first data item through the external database file specifically includes step S2041: performing operations on the data through SQL statements:

Perform operations according to the data content in the database file described in the SQL statement to obtain the data file after the operation;

The first data item acquires data through the calculated data file.

Wherein, the operation is performed on the data content in the database file according to the SQL statement, and the obtained data file after the operation is specifically: perform query operation on the row unit and/or column unit in the database file according to the SQL statement, and obtain the data . Or perform SQL function operations on row units and/or column units in the database file according to SQL statements to obtain data.

S205: Perform scene switching;

This step specifically includes: judging whether there is a format identifier in the first data item, and if so, playing through the second teletext scene file; otherwise, playing according to the first teletext scene file.

Through the above description of the embodiments, those skilled in the art can clearly understand that the present invention can be realized by hardware, or by software plus a necessary general hardware platform. Based on this understanding, the technical solution of the present invention can be embodied in the form of software products, which can be stored in a non-volatile storage medium (which can be CD-ROM, U disk, mobile hard disk, etc.), including several The instructions are used to make a computer device (which may be a personal computer, a server, or a network device, etc.) execute the methods described in various embodiments of the present invention.

Those skilled in the art can understand that the drawing is only a schematic diagram of a preferred embodiment, and the modules or processes in the drawing are not necessarily necessary for implementing the present invention.

Those skilled in the art can understand that the modules in the device in the embodiment can be distributed in the device in the embodiment according to the description in the embodiment, or can be located in one or more devices different from the embodiment according to corresponding changes. The modules in the above embodiments can be combined into one module, and can also be further split into multiple sub-modules.

The serial numbers of the above embodiments of the present invention are for description only, and do not represent the advantages and disadvantages of the embodiments.

The above disclosures are only a few specific embodiments of the present invention, however, the present invention is not limited thereto, and any changes conceivable by those skilled in the art shall fall within the protection scope of the present invention.

Claims (9)

1. A method for utilizing data files to switch teletext packaging scenes, characterized in that, comprising: receiving a first teletext scene file and a second teletext scene file, wherein the first teletext scene file includes a scene description file; Acquiring a first data item according to the scene description file; receiving a database file, wherein the database file includes formatting marks; The first data item acquires data through the database file; Judging whether there is a format mark in the first data item, if so, playing through the second teletext scene file, otherwise, playing according to the first teletext scene file. 2. The method as claimed in claim 1, wherein the teletext scene file is specifically: a Mariana.5D teletext scene file, and the scene file may include at least one Mariana.5D teletext scene file packaging template. 3. The method according to claim 1, wherein the format mark specifically comprises: Paragraph markers, end markers, section break markers, tab markers, manual line break markers, and white space markers. 4. The method according to claim 1, 2 or 3, wherein the step of receiving the database file specifically comprises: Receive a list of database servers; A database file is received according to the list, and the database file includes the list information. 5. The method according to claim 1, wherein the step of receiving the first teletext scene file and the second teletext scene file specifically comprises: receiving a first teletext scene file and a second teletext scene file, wherein the first teletext scene file and the second teletext scene file include scene hierarchy information; Receive TV graphic packaging special effect files; The teletext special effect file is imported into the first teletext scene file and the second teletext scene file. 6. The method according to claim 1 or 2, characterized in that, the first teletext scene file and the second teletext scene file specifically include: a corresponding data pool file. 7. The method according to claim 1, wherein the step of acquiring data for the first data item through the database file specifically includes: Perform operations according to the data content in the database file described in the SQL statement to obtain the data file after the operation; The first data item acquires data through the calculated data file. 8. The method as claimed in claim 7, wherein said data content in the database file according to the SQL statement is calculated, and the step of obtaining the calculated data file specifically includes: Perform query operations on row units and/or column units in the database file according to the SQL statement to obtain data. 9. The method as claimed in claim 7, wherein said data content in the database file according to the SQL statement is calculated, and the step of obtaining the calculated data file specifically includes: performing an operation on the database file according to the SQL statement The row unit and/or column unit in the SQL function operation to obtain data.