JP4518612B2 - Database creation management system and database - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a database in which print data used for printing is subjected to typesetting processing, layout editing, and printing, and a database creation management system for creating and managing the database.
[0002]
[Prior art]
In recent years, in the plate making process in printing, digital plate making by so-called DTP (Desktop Publishing) using a computer has been performed. In addition, the typesetting process is automatically performed as the performance of the computer improves. In this way, even if the efficiency of the printing process has been improved, if there is a change or update in one of the print data, the whole has to be re-edited. It is desired that efficiency be improved.
[0003]
Conventionally, as a means for creating a printed plate, automatic typesetting processing using variable data such as a database (DB) by a program has been performed. In such a plate making process, print data (text data) necessary for plate making is acquired from an original DB in which data relating to printing is stored, and data processing such as sorting according to the typesetting conditions is performed. Based on this data, an automatic typesetting process is performed on the page layout (frame) to create page layout data for all pages, print on paper or film, or output a data file. After the above-described page layout processing for all pages is performed, the page layout data is edited by handling in a portion that is not automatically formatted, for example, when allocation is difficult.
[0004]
[Problems to be solved by the invention]
However, when the print contents are changed periodically, if there is a need to perform the above-mentioned automatic typesetting process every regular cycle, or if there is an update such as addition or deletion of variable data, or processing such as the number of pages Under conditions such as when the amount is large or when correction work occurs during page layout, the correction work must be performed each time after automatic composition, which causes a problem of quality degradation and increased time and labor. .
Therefore, the present invention has been made in view of the above problems, and provides a database creation management system and database that facilitate page layout editing, maintain quality even when re-editing is required, and improve processing efficiency. For the purpose.
[0005]
[Means for Solving the Problems]
In order to solve the above-mentioned problems, in the invention of claim 1, plate making is performed by editing data related to printing of the contents of a list form such as a list collection, a table of contents, and an index on a page layout to be image data on each page. A database creation management system for creating a database used for printing, acquiring data related to printing from predetermined information, and including at least the text data related to the list form among the acquired data on each page and related data for one record amount corresponding to at least one line of each stage in the predetermined number of multi-column layout, each of the relevant data corresponding to at least one line of each page of at least one row of the page layout Data processing means for editing the size, and editing each page on the page layout At least the created print data created by imaging each related data as one record content corresponding to at least one line of each stage image data, edited by said data processing means for configuration by causing location means, created by the print data creating means, the is intended for storing each image data of the associated data of at least one line that constitutes each page as one record content, and outputs the image data by request And a database for creating page layout data in which the image data is arranged on each page on the page layout.
[0006]
In the invention of claim 2 to 4, "the data processing means includes means for applying respective pre-Symbol to relevant data attribute data the corresponding at least one line in each page, the print data generating means, The related data managed by the attribute data is set as image data.
“When the print data creating means images the related data, the related data created by the data processing means is incorporated into a frame corresponding to at least one row of each stage in each page, and image data and To be configured,
The configuration includes “editing means for editing the image data created by the print data creating means or editing the image data stored in the database”.
[0009]
As described above, among the data relating to the printing of the contents of the list form such as the list, the table of contents, and the index , the text data related to the list form is at least one of each stage in a predetermined number of columns on the page layout of each page The related data for one record corresponding to the row is stored in the database as each image data constituting the page layout data of each page. In other words, since page layout editing is performed with at least one line of image data, editing becomes easy, and even if re-editing is necessary, quality can be maintained and processing work can be made more efficient. .
[0010]
DETAILED DESCRIPTION OF THE INVENTION
Hereinafter, preferred embodiments of the present invention will be described with reference to the drawings.
FIG. 1 shows a configuration explanatory diagram of a database creation management system according to the first embodiment of the present invention. The database creation management system 11 shown in FIG. 1 shows a case where it is applied when printing a music list collection used for so-called karaoke. 1A is a block diagram of the database creation management system 11, and FIG. 1B is a conceptual diagram of a data structure stored in the database.
[0011]
The database creation management system 11 in FIG. 1A creates a database that is used when printing and printing is performed by editing data related to printing on a page layout and using it as image data on each page. The data processing unit 12, the print data creation unit 13, and the print database (DB) 14 as the database of the present invention are included.
[0012]
Although the details will be described later, the data processing means 12 obtains data related to the printing of the song list collection from the original DB 15 storing all data (text data) related to karaoke as predetermined information under predetermined processing conditions. Relevant data among the acquired data is related data corresponding to at least one row of each stage in a predetermined number of columns of the page layout of each page, with appropriate attribute data, and corresponding to each row of each page Edit each of the relevant data. Here, the processing conditions include data conditions necessary for printing, output data structure, size conditions, data arrangement conditions, and the like, which will be described later.
[0013]
The print data creation means 13 is image data for configuring each page by editing and arranging it on the page layout, and the image data is related data at least for each line edited by the data processing means 12. Is appropriately incorporated into a frame corresponding to each row to create an image. This image data includes, for example, imaged data for printing a headline as one display by combining a predetermined number, and includes image data corresponding to a blank portion constituting each page.
[0014]
The database 14 is for generating page layout data in which each page is configured by outputting predetermined image data upon request, and each image data created by the print data creation means 13 is appropriately attributed to attribute data. Manage and store with. That is, related data corresponding to at least one row of each column in a predetermined number of columns on the page layout of each page among the data related to printing is stored as each image data constituting the page layout data of each page. To do.
[0015]
Each image data stored in the database 14 is image data 16 (16A, 16B...) Having a size corresponding to one row of each stage of each page, as shown in FIG. Yes, as attribute data, for example, a flag (which may be a file name or ID (identifier)) 17 (17A, 17B...) Is assigned and managed. For example, the image data titled “A”, the image data titled “Song Title, Request No., Encounter, Singer Name, etc.”, each specific song name, Request No., Encounter, Singer Name, etc. Are stored in the database 14 respectively. It should be noted that the frame of each image data 17 in FIG. 1B is made easy to recognize on the drawing and is not originally included as data.
[0016]
Here, FIG. 2 shows a block diagram of the data processing means of FIG. 1, and FIG. 3 shows a block diagram of the print data creation means of FIG. The data processing means 12 shown in FIG. 2 includes at least a data acquisition means 21, a data editing means 22, an attribute data giving means 23, and a sort output means 24. The data acquisition means 21 obtains the necessary print data (text data) from the original DB 15 in addition to the title data, the song name, the request number, the search, the singer name related data in the above example. Acquired by conditional processing that extracts only the necessary amount.
[0017]
The data editing means 22 is the data sequentially acquired by the data acquisition means 21, for example, related data (for example, the song title, Each related data is edited under the processing conditions of request NO, scoop out, and singer name data as related data). For example, if the printing paper is A4 large (width 210 mm, length 297 mm), and horizontal writing, the upper margin is 12 mm and the lower margin is 15 mm (inner margin 16 mm, outer margin 15 mm). Therefore, the related data is edited so as to fall within an area of 9 mm width and 179 mm length as the data for one row. Even in vertical writing, the same data size editing process may be performed in consideration of each margin. This one related data becomes one record.
[0018]
The attribute data assigning means 23 assigns, for example, a flag 17 as shown in FIG. 1B as attribute data to each related data for one line created by the data editing means 22. The sort output means 24 is provided as necessary, and sorts the related data for one row to which the flag 17 is assigned according to processing conditions such as order (for example, in the order of 50 notes). The data is sequentially sent to the print data processing means 13.
[0019]
3 includes at least a data development unit 31, a data separation unit 32, an image data creation unit 33, a buffer 34, and a template 35 in which a predetermined pattern frame is stored in advance. The data expansion means 31 expands each related data sequentially sent from the data processing means 12 on the work area. The data separating means 32 separates the flag 17 of each expanded related data and the main data (related data).
[0020]
The image data creation means 33 reads the corresponding pattern frame (corresponding frame for one row) from the template 35, incorporates each separated related data (main data) into the frame, and converts it into image data. For example, it is assumed to be bitmap data. The buffer 34 temporarily stores each of the image data 16 to which the flag 17 as shown in FIG. 1B is assigned and stores them in the print DB 14 respectively. The image data 16 stored in the print DB 14 includes the image data 16 that is combined as described above to form one heading and the blank image data 16 that is responsible for the blank portion of each page. included.
[0021]
Here, FIG. 4 shows a processing flowchart of the data processing means and the print data creation means in FIG. 2 and FIG. FIG. 4A is a processing flowchart of the data processing unit 12, and FIG. 4B is a processing flowchart of the print data creation unit 13. In FIG. 4 (A), the data processing means 12 first requires the data acquisition means 21 to obtain each piece of data related to the song title, request number, name and singer name in addition to the title data from the original DB 15. Print data (text data) necessary for printing the karaoke song list collection based on the condition processing for extracting the data for the amount of data obtained is acquired (step (S) 1).
[0022]
The acquired print data is specified by the data editing means 22 for the size of one record under the above-described processing conditions, and the acquired data is edited for size adaptation to obtain related data (record data) (S2). Each of the edited related data is assigned, for example, a flag 17 in the attribute data assigning means 23 (S3), and sorted in the sort output means 24 based on a processing condition for rearranging, for example, a song name and a singer name in the order of 50 notes (S4) Each record data is output to the print data creation means 13 (S5).
[0023]
In FIG. 4B, the print data creation means 13 acquires each record data sent from the data processing means 12 by the data development means 31 and sequentially develops it in the work area (S11). For each of the expanded record data, the data separation unit 32 separates the attribute data flag 17 and the main data (S12), and the image data creation unit 33 reads the separated main data from the template 35. It is incorporated into the pattern frame (frame as one line) and converted into image data (for example, bit map) (S13).
[0024]
Each record data converted into the image data (the state where the flag 17 is given) is temporarily stored in the buffer 34 (S14). When all the record data sent from the data processing means 12 developed by the data development means 31 are converted into image data and temporarily stored in the buffer 34 (S15), they are sequentially stored in the database and printed. DB14 is created (S16).
[0025]
Thus, among the data relating to printing, at least each row in the predetermined number of columns on the page layout of each page is associated with data corresponding to at least one row and is incorporated into the frame corresponding to the row. By storing the image data 16 constituting the page layout data of the page in the print DB 14, the page layout can be easily edited, the quality is maintained even if re-editing is necessary, and the efficiency of the processing work is improved. It is something that can be done.
[0026]
In the above-described embodiment, the conversion of related data into image data is performed for one line on the layout of each page, but it may be performed in units of two lines, and is set according to the data amount of the related data and the page layout. is there.
[0027]
FIG. 5 shows a schematic configuration diagram of a print processing system to which the database of the present invention is applied. FIG. 5A is a system block configuration diagram, and FIG. 5B shows a conceptual diagram of plate-making data. The print processing system 41 shown in FIG. 5 (A) is a case where the karaoke song list is printed. The layout processing data creation means 42, the layout processing means 43, the page print DB 44, the frame template 45, and the print At least processing means 46 is provided.
[0028]
The layout processing data creation means 42 uses the print DB 14 created by the database creation management system 11 based on the information (for example, text information) of each print data arrangement on each page layout from the page information as shown in FIG. The corresponding image data 16 as shown in B) is acquired in order, for example, by the flag 17 and matching is performed to determine whether or not the data contents match each other.
[0029]
The layout processing means 43 acquires a page layout frame 47 for each corresponding page as shown in FIG. 5B from the frame template 45, and sequentially receives the image data 16 acquired from the print DB 14 on the frame. Are sequentially incorporated into the editing process. The page print DB 44 stores the layout frames 48 for each page sequentially created by the layout processing means 43 in the order of pages as shown in FIG.
[0030]
Then, the print processing unit 46 prints the entire page layout frame stored in the created page print DB 44 as a printing plate, prints on paper, film, or the like, or prints as a predetermined file (for example, PDF file), and appropriately binds the book. Is to do.
[0031]
FIG. 6 shows a process flowchart of the print processing system shown in FIG. In FIG. 6, first, the layout processing data creation means 42 acquires corresponding record data from the print DB 14 based on the page information and performs data matching (S21). On the other hand, the layout processing means 43 acquires a page layout frame 47 for each corresponding page from the frame template 45 (S22), and the acquired record data (image data) that has been subjected to the data matching on the one page layout frame 47 is described above. The page layout frame 47 of the print data for each edited page is sequentially stored in the page print DB 44 (S24).
[0032]
Then, all page layout frames 48 for all pages are stored in the page print DB 44 (S25), and the print processing is performed using the page layout frames 48 for all pages stored in the page print DB 44 as printing plate making. The means 46 prints on paper, film, etc., or prints as a predetermined file (for example, PDF file), and performs bookbinding as appropriate (S26).
[0033]
By the way, when a new score or the like appears, the song list must be updated. At this time, the database creation management means 11 obtains print data relating to the data of the new music, makes it an image as described above, and newly stores it in the print DB 14. Then, the music list collection can be revised by obtaining the image data of the new music from the print DB 14 by the print processing system 41 as shown in FIG. 5 and editing it according to the page information.
[0034]
In other words, since the print data related to the existing music is already stored in the print DB 14, it is not necessary to newly create it, and the efficiency of the update processing work can be greatly improved. Is generated, and the quality can be maintained.
[0035]
Next, FIG. 7 shows a configuration explanatory diagram of a database creation management system according to the second embodiment of the present invention. FIG. 7A is a block diagram of the database creation management system 11, and FIG. 7B is a conceptual diagram of a data structure stored in the database. The database creation management system 11 shown in FIG. 7A is provided with an editing unit 51, and the other configuration is the same as that in FIG.
[0036]
The editing means 51 is for editing the image data created by the print data creating means 13 or editing the image data stored in the print DB 14. That is, when editing cannot be performed by converting the print data processing unit 13 into a data image, for example, when adding ruby as shown in FIG. 7B, editing is performed by the editing unit 51 in the print DB 14. To store. In addition, record data (image data) once stored in the print DB 14 can be read and re-edited. As a result, the quality can be maintained even during re-editing, and the efficiency of processing work can be improved.
[0037]
In each of the above-described embodiments, the case where a song list collection for karaoke is created is shown as an example. However, the present invention is also applicable to plate making for other list collections, table of contents of books, magazines, etc., index making, etc. Of course you can.
[0038]
【The invention's effect】
As described above, according to the first and third aspects of the invention, at least the text data related to the list form among the data related to the printing of the list form, such as the list collection, the table of contents, the index, etc. The related data for one record corresponding to at least one row of each stage in a predetermined number of columns on the layout is stored in the database as each image data that is appropriately incorporated into a frame and constitutes page layout data of each page. This facilitates page layout editing, maintains quality even when re-editing is necessary, and improves processing efficiency.
[0039]
According to the invention of claim 2 , attribute data is assigned to each related data corresponding to at least one line in each page, and each image data stored in the database is managed by the attribute data. This makes it easy to search for the corresponding image data, and prevents duplicate data from being generated. As a result, page layout editing becomes easy, maintaining quality even when re-editing is necessary, and improving processing efficiency. It is done.
[0040]
According to the fourth aspect of the present invention, the image data created by the print data creation means or the image data stored in the database is provided with editable editing means, so that even when re-editing is performed. The quality is maintained, and the efficiency of processing work is improved.
[Brief description of the drawings]
FIG. 1 is an explanatory diagram of a database creation management system and data configuration according to a first embodiment of the present invention.
FIG. 2 is a block configuration diagram of data processing means in FIG. 1;
FIG. 3 is a block configuration diagram of print data creation means in FIG. 1;
4 is a processing flowchart of data processing means and print data creation means in FIGS. 2 and 3. FIG.
FIG. 5 is a schematic configuration diagram of a print processing system to which the database of the present invention is applied.
FIG. 6 is a process flowchart of the print processing system in FIG. 5;
FIG. 7 is a configuration explanatory diagram of a database creation management system according to a second embodiment of the present invention.
[Explanation of symbols]
11 Database creation management system 12 Data processing means 13 Print data creation means 14 Print database (DB)
15 Original DB
16 Image data 17 Flag 22 Data editing means 23 Attribute data giving means 33 Image data creation means 41 Print processing system 43 Layout processing means 44 Page print DB 45
45 Print processing means 51 Editing means

Claims (4)

Create a database to create a database to be used for printing and printing by editing the data related to printing of the contents of the list form such as list collection, table of contents, index, etc. on the page layout and making it image data on each page A management system,
Data related to printing is acquired from predetermined information, and text data related to the list form among the acquired data is at least one record corresponding to at least one row of each stage in the predetermined number of columns of the page layout of each page. Data processing means for editing each of the related data corresponding to at least one line of each page into the size of at least one line of the page layout, as related data;
The image data to be configured by arranging each page by editing on the page layout is related data as one record corresponding to at least one row of each stage edited by the data processing means. Print data creation means to create each image,
The image data of at least one line of related data constituting each page created by the print data creation unit is stored as one record, and the image data is output upon request to generate a page layout. A database for creating page layout data in which the image data is arranged on each page above,
A database creation management system characterized by comprising: The database creation management system according to claim 1,
It said data processing means includes means for applying respective attribute data before Symbol relevant data corresponding to at least one row in each of the pages,
The database creation management system, wherein the print data creation means uses the related data managed by the attribute data as image data. 3. The database creation management system according to claim 1, wherein the print data creation unit converts the relevant data created by the data processing unit into each level in each page when the relevant data is imaged. A database creation management system characterized in that the image data is incorporated into a frame corresponding to at least one line. 4. The database creation management system according to claim 1, wherein the image data created by the print data creation unit is edited, or each image data stored in the database is stored in the database. A database creation management system comprising an editing means for performing editing.

Images