JP2784880B2 - Editing method and apparatus for karaoke software database - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001] The present invention relates to editing of a karaoke software database.

[0002]

2. Description of the Related Art In recent years, so-called karaoke has gained great popularity not only in Japan but also in other countries, and has been established as one of the important leisure activities. Along with the rise of karaoke, many karaoke software companies (karaoke software suppliers) have created sets of karaoke software, each with its own ingenuity, in the form of laser disks, compact disks, etc. Provided by

[0003] Restaurants, karaoke houses, and the like that provide karaoke services to customers (hereinafter collectively referred to as karaoke houses) meet the needs of each karaoke house and meet the needs of the customers. The company selects and purchases a set of existing karaoke software that contains as many requested songs as possible, and provides karaoke services to customers. In recent years, in many karaoke houses, large-scale karaoke stations having a plurality of changer mechanisms capable of simultaneously playing separate songs in a plurality of rooms.
There are many examples of installing systems.

In such a karaoke house,
In view of the fact that the same song is requested at the same time or different songs stored on the same disc are often requested at the same time, multiple sets of the same karaoke software set are prepared, Purchase multiple karaoke software sets of different types and set them to be playable in your karaoke system.
It has responded to customer requests.

[0005]

However, in such a case,
Even if multiple sets of the same karaoke software set are prepared, the number of tunes that can be provided at the request of the customer is limited to the range of the tunes stored in the karaoke software set, and -The number of tunes that can be provided does not always increase according to the number of karaoke software discs set in the system. In addition, multiple karaoke companies of different types from multiple karaoke companies
Even if the software set is prepared, the customer's request is made according to the respective code numbers on the music list issued and provided by the respective karaoke companies, so that the same music corresponding to the same code number is simultaneously performed. If requested, it will not be possible to respond. Also, in this case,
There is a trouble that a plurality of types of music lists must be kept in each room.

[0006]

SUMMARY OF THE INVENTION Accordingly, the present invention provides a unique code number corresponding to each music title on a one-to-one basis for all the music of the karaoke software provided by a plurality of karaoke software suppliers. , And priorities are assigned to a plurality of kinds of software related to the same song provided from a plurality of karaoke software suppliers, and a karaoke software data base based on the code number is assigned. To provide karaoke services to customers
When a song set of a unique karaoke software corresponding to each house request is selected and edited from the database, and there is a request for a song in the edited karaoke software set The karaoke software to which the highest priority is given is selected, and if there is a request for the same song during the performance, the karaoke software with the next highest priority is selected. The above-mentioned problem was solved by providing a method of editing a karaoke software database.

[0007]

Next, an embodiment of the present invention will be described with reference to the drawings.

FIG. 1 shows an example of a part of a music title corresponding list of a representative code according to the present invention. In this list, all the songs of karaoke software provided by multiple karaoke software companies are uniquely assigned a representative code corresponding to one-to-one, and each karaoke software company has set a song with the same name. The song title code of the song is associated with the representative code according to the priority order.

In accordance with this correspondence list, for example, when a song title "A-summer vacation" (representative code is assigned 1A1) is requested, the karaoke apparatus is provided by a specific karaoke software company. The maker code (72B
9) is selected and played. Next, when the same song is accidentally requested from another room, since the first priority 72B9 is already playing, the BBB9 relating to the same song of another karaoke software company having the second priority is already performed. Will be played on the device in the room.

FIG. 2 is a diagram simply showing the outline of the hardware configuration of the karaoke software editing apparatus according to the present invention. The data base of karaoke software is usually
It is stored in a disk device such as a hard disk in the form of a data file. In response to data input or operation from an input device such as a keyboard, a CPU (central processing unit) newly registers, updates, and searches for data items in a data base.・ Maintenance is performed. At the request of each karaoke house, the karaoke software provided by the store to the customer by selecting any karaoke software set provided by the karaoke software company and selecting it based on the tune genre, singer name etc. The set is edited, and the original music list of the store is formed by the printing device in the order of music title (FIG. 6) or singer name (FIG. 7) and printed out. In FIG. 3, the names of the data files constituting the data base of the karaoke software according to the present invention are displayed. The song information file includes a song information file, a singer file, song information, a board information, and a maker information file. The song information file is associated with the song information file by a representative code (this is the song book request number). The song information file and the board information file are based on the board index code, the board information file and the maker information file are based on the maker code, and the singer file is based on the singer name Kana code. Each file is associated with a file, thereby enabling it to be handled as one data base.

The files are used for quick reference, search, and maintenance such as new registration, update, and deletion. The outline of each file is as follows.

(1) Song information One record is created for each song listed in the quick reference table, and necessary information is registered.

(2) Singer file This is a file for each singer name, which saves time and effort for input and prevents input errors (the same singer is input under a different name).

For example, "Miho Nakayama" and "Miho Nakayama" are treated as different names on the code.

(3) Maker information The maker name has a maker name assigned to codes 1 to 16 of the music piece information.

Reference is made when registering a board or outputting a list.

(4) Board information At the time of board registration, one record is created for one board.

Used when searching for a board for each manufacturer. It also has management information for each song.

(5) Song information When a board is registered, one record is created for one song.

Used when searching the contents of a board for each manufacturer. It also has management information for each song.

(6) Representative code The last representative code used is stored as a variable file, and is used for automatic numbering at the time of new registration of a music piece.

(7) Quick reference table output final representative code The final representative code output to the quick reference table as a variable file is used to output a list of newly registered tunes after printing the quick reference table.

FIGS. 4 and 5 show the contents of each of the files constituting the data base. The details of the processing contents in each file are summarized and described below.

(1) Board Information-Registration (1) A maker selection screen is displayed, and a maker code to be registered is selected.

(2) Input of board No. and print unnecessary category Duplication check of board No. by the same manufacturer is performed.

(3) When the registration of the board is selected, the registration date (system date) and the board index (maker code +
Then, a record is output as the board information, and the music information is registered ((4) and below).

(4) Enter the side and No of the song to be registered.

A duplicate check of side + No is performed on the same board.

(5) Input the representative code.

If the representative code is unknown in the existing music, the search for the music can be performed.

If the song is not an existing song, a new song can be registered.

(6) Searching for music a. Enter the song name Kana.

B. The songs starting with the entered kana are listed on the screen and selected.

C. Set the representative code of the selected song.

(7) After the registration of the music piece, the same processing as that of the music piece-registration is performed, and its representative code is set.

(8) The program information of the input or selected representative code is checked, and if it is already registered by the same maker, it cannot be registered.

(For example, when registering the maker code 06, if a value has already been set in the code 6, it cannot be registered in duplicate there.) (9) Input a voice multiplex section.

(10) When the registration of music is selected, a music index (board index + side + No) is set and a record is created in music information.

In addition, a corresponding portion (codes 1 to 1) of the music piece information
6), the code (board No. + side + No.)
Set [+ "%" (at Onda)] and update.

(2) Board Information-Update (1) Display the manufacturer selection screen and select the manufacturer code to be updated.

(2) The boards registered with the selected maker code are searched from the board information, and sorted and displayed in the order of the board numbers.

Select a board No.

(3) The tune of the selected board is searched from the tune information (matching the board index), and the contents of the board information and the tune information are displayed on the screen and updated.

(4) The items that can be updated in the board information are only the print unnecessary categories.

(5) When deletion of a board is selected: a. Delete record of board information.

B. For each song (record of song information retrieved in (3)) of this board, the own code is deleted from the record of the song information of the corresponding representative code and updated.

(For example, if the maker code to be deleted is 10
If so, delete the value set in code 10) c. Delete the song information record.

(6) The items that can be changed in the music information are only the representative code and the audio multiplex section.

A. When the representative code is changed, the own code is deleted from the music information of the old representative code and updated.
Next, the own code is set and updated in the music information of the new representative code.

However, if the new representative code has already been registered by the same manufacturer, it cannot be registered.

B. When the audio multiplex section is changed, the own code set in the music piece information is changed and updated.
(Add or delete “%”) (7) If deletion of music is selected, a. Delete the song information record.

B. The own code is deleted from the record of the corresponding music information and updated.

(8) In the music update process, search and registration of music can be performed in the same manner as at the time of registration. (Used when changing the representative code.) (3) Program-Registration (1) Obtain the final representative code from the variable file, calculate the next value, and display it on the input screen. (The representative code is automatically numbered and not changed.) (2) Enter the song title, song title kana, singing start, singer name kana, medley subtitle, non-printable category, and genre.

(3) The singer name is searched for singer files based on the input singer name kana, displayed in a list, and the selected one is set.

(4) If there is no corresponding singer name, it can be newly registered in the singer file.

(5) When registration is selected, a record is created in the music piece information, and the final representative code is updated.

(4) Program-Update (1) A record to be updated can be selected by inputting a song title kana or a representative code.

(2) Items that can be changed include song name, song name kana, singing, singer name (change and input singer name kana),
Subtitle, print unnecessary category, genre.

(3) If deletion of a music piece is selected, the record is deleted.

Only when codes 1 to 16 are empty, deletion is possible.

(5) Music-Search (1) Search conditions are entered for each input item of music information, and a list of music that matches the conditions is displayed.

(For example, when a search is performed under the condition that the duet flag is ON, a list of all duet songs is displayed.) (2) The displayed contents can be printed out.

(6) Singer-Registration (1) Enter the singer name and kana.

(2) When registration is selected, a record is output to the singer file.

(7) Singer-update (1) By inputting (a part of) kana, matching singer names are retrieved from the singer file and displayed in a list, and an updated record is selected.

(2) Change and input the singer name and kana, and update the record.

(3) If delete is selected, the record is deleted.

(8) Singer-Search (1) The singer name or kana (part of) is input as a search condition.

(2) A matching singer name is retrieved from the singer file and displayed in a list.

(9) Creation of database-print file (1) Checking whether or not to output a print file 1 Check all pieces of music information, and if any of codes 1 to 16 have a code set Set print use flag to O
N, and if any of the codes 1 to 16 is empty, the print use flag and the print use flag 2 are turned off.

(2) Check 2 If the record whose print use flag is ON and the first byte of the song title is other than “A” to “N”, the print use flag is turned OFF.

(3) Check 3 For records whose print use flag is ON and whose first byte of singer name Kana is "A" to "N", print use flag 2 is set to O.
N, and the others are turned off.

(4) Check 4 a. From the board information, a record whose print unnecessary section is ON is selected.

B. a. Select the song information that matches the board index of.

C. b. Of the print use flag and the print use flag 2 of the music information corresponding to the representative code of the music information
Change to F.

(5) Output of a file for a song-specific list a. The record of the music information is selected under the following conditions.

Print unnecessary section = OFF and print use flag = ON and medley section = OFF and halo section = OFF and animation section = OFF and nursery rhyme section = OFF b. As an end record, a song with a song title "." (Half-width kana) and a representative code "999999" is added.

C. The selected records are sorted in ascending order of song name kana, song name, singer name kana.

D. Output in TEXT format.

The file name is “list of songs.TXT”.

(6) Output of singer-specific list file a. The record of the music information is selected under the following conditions.

Print unnecessary section = OFF and print use flag 2 = ON and medley section = OFF and halo section = OFF and animation section = OFF and nursery rhyme section = OFF b. As an end record, a song whose name is "." (Half-width kana), whose singer is "." (Half-width kana), and whose representative code is "999999" is added.

C. The selected record, singer name Kana,
Sort by singer name, song name kana, song name in ascending order.

D. Output in TEXT format.

The file name is “singer list.TXT”.

(7) Output of duet list file a. The record of the music information is selected under the following conditions.

Unnecessary printing section = OFF and print use flag = ON and duet section = ON b. As an end record, a song with a song title "." (Half-width kana) and a representative code "999999" is added.

C. The selected records are sorted in ascending order of song name kana, song name, singer name kana.

D. Output in TEXT format.

The file name is “du list.TXT”.

(8) Output of Medley List File a. The record of the music information is selected under the following conditions.

Unnecessary printing section = OFF and print use flag = ON and medley section = ON b. As an end record, a song with a song title "." (Half-width kana) and a representative code "999999" is added.

C. The selected records are sorted in ascending order of song name kana, song name, singer name kana.

D. Output in TEXT format.

The file name is “med list.TXT”.

(9) Output of a file for a list of new a. The record of the music information is selected under the following conditions.

Unnecessary printing section = OFF and print use flag = ON and new section = ON b. As an end record, a song with a song title "." (Half-width kana) and a representative code "999999" is added.

C. The selected records are sorted in ascending order of song name kana, song name, singer name kana.

D. Output in TEXT format.

The file name is assumed to be “Pixel list.TXT”.

(10) Output of animation list file a. The record of the music information is selected under the following conditions.

Printing unnecessary section = OFF and print use flag = ON and (animation section = ON Tamaya nursery rhyme section =
ON) b. As an end record, a song with a song title "." (Half-width kana) and a representative code "999999" is added.

C. The selected records are sorted in ascending order of song name kana, song name, singer name kana.

D. Output in TEXT format.

The file name is “ani list.TXT”.

(11) Setting of quick reference table output final representative code The final representative code of the variable file is set to the quick reference table output final representative code and updated.

(11) Maintenance-Output of music piece maintenance list (1) All pieces of music piece information are sorted in ascending SEQ No. order (representative code order) and displayed on the screen.

(2) When printing is selected, printer output is performed.

(12) Maintenance-board maintenance list output (1) A maker code to be output is input. (It is also possible to specify all manufacturers.) (2) Select the record of the matching manufacturer code, sort the manufacturer code and the board number in ascending order, and display them on the screen.

(3) When printing is selected, a printer output is performed.

(13) Maintenance—Output of music list for each board (1) Enter the maker code to be output + the board number.

It is possible to input only the maker code or to specify all cases.

(2) Records matching the input code are selected, sorted in ascending order of maker code, board No., side, and No, and displayed on the screen.

(3) When printing is selected, a printer output is performed.

(14) Maintenance—New Song List Output (1) The final representative code output to the songbook is imported from a variable file.

(2) Select a record (with a large SEQ No.) having a representative code larger than the representative code of (1).

(3) Codes 1 to 16 in the record of (2)
Is selected, and the code whose printing unnecessary section is OFF is selected.

(4) Music titles are sorted and displayed in kana order.

(5) When printing is selected, a printer output is performed.

(15) Maintenance—Manufacturer Information Registration (1) Enter the maker code and maker name.

(2) The manufacturer code cannot be duplicated.

(16) Maintenance—Update of Manufacturer Information (1) The manufacturer code cannot be changed.

(2) If delete is selected, the record is deleted.

Examples of the song book processed in the above-described manner and printed out based on the individual requirements of the individual karaoke houses are as follows. From FIG. 6 and FIG.
It describes in.

[0125]

As described above, the present invention assigns a unique code number corresponding to each song title of karaoke software provided from a plurality of karaoke software suppliers on a one-to-one basis, and Priorities are assigned to a plurality of types of software related to the same song provided by a karaoke software supplier, and a karaoke software data base based on the code numbers is created. Karaoke House's original karaoke software song set,
Providing an editing method that allows the user to arbitrarily select and edit the data base has the following remarkable effects.

(1) All pieces of music provided by a large number of kakaoke software suppliers (karaoke companies) can be provided. Further, the number of insertion boards can be reduced as compared with the number of music pieces. (2) In the karaoke house, even if multiple karaoke software suppliers only purchase one set of karaoke software released, and multiple requests are concentrated on the same song, they can be selected according to priority. Simultaneous performance of the selected songs is possible. Popular songs that are requested at the same time are included in many karaoke software.

(3) Insertion by song, song genre, and singer
Karaoke House can easily construct and provide original karaoke software unique to Karaoke House, which can be individually selected for deletion and is not limited to songs included in existing karaoke software.

(4) Since many types of song books issued by a plurality of suppliers are combined into one song book, the management of the song books and the use of the customer's quick reference table are greatly facilitated. Become. (5) It is easy to manage the data base of music, and it is possible to issue a quick-reference table immediately, provide new music information, and manage the number of boards appropriately.

[Brief description of the drawings]

FIG. 1 is a diagram exemplifying a part of a music title correspondence list of a representative code according to the present invention.

FIG. 2 is a diagram simply showing an outline of a hardware configuration of a karaoke software editing apparatus according to the present invention.

FIG. 3 shows data of karaoke software according to the present invention.
FIG. 4 is a diagram showing names of data files constituting a base.

FIG. 4 shows the contents of a music piece information file constituting a data base according to the present invention.

FIG. 5 shows the contents of a singer file, a maker information file, a board information file, and a music information file which constitute a data base according to the present invention.

FIG. 6 shows an example of a quick reference table of song titles in the order of eyewear issued and printed by editing according to the present invention.

FIG. 7 shows an example of a quick reference table in the order of the name of a singer, which is printed and issued by the editing according to the present invention, in the order of Iueo.

────────────────────────────────────────────────── ─── Continuation of the front page (56) References JP-A-4-191897 (JP, A) JP-A-2-249187 (JP, A) JP-A-2-220551 (JP, A) JP-A-4-199 60699 (JP, A) JP-A-2-216690 (JP, A) JP-A-4-32898 (JP, A) JP-A-58-133473 (JP, U) JP-A-4-135798 (JP, U) Hira 4-93985 (JP, U) (58) Fields investigated (Int. Cl. ⁶ , DB name) G06F 17/30 G10K 15/04 302 G11B 27/034 JICST file (JOIS)

Claims (7)

(57) [Claims] Claims: 1. A unique code number is newly assigned to each tune of karaoke software provided by a plurality of karaoke software suppliers for each tune name, and provided by a plurality of karaoke software suppliers. Data base of karaoke software based on the code number in which priority is given to a plurality of types of the same music software to be executed.
Create a karaoke service and tune the karaoke software for karaoke service from the data base according to the needs of each karaoke house that provides karaoke service. Edit the unique karaoke software set selected in the above, in the edited karaoke software set,
If there is a request for a certain song, karaoke software with the highest priority given is selected,
A method of editing a karaoke software database, wherein, if there is a request for the same song during the performance, karaoke software with the next priority is selected. 2. A karaoke system in the data base.
2. The method for editing a karaoke software database according to claim 1, wherein the assignment of software priorities is collectively set for each software set of the karaoke software supplier. 3. The method according to claim 1, wherein the selection is performed by selecting a karaoke software set of a karaoke software supplier, selecting a tune or a genre of tunes, selecting a singer name, and selecting any combination thereof. Karaoke
How to edit a soft database. 4. A unique code number is newly assigned to each music title of karaoke software provided by a plurality of karaoke software suppliers for each music title.
Karaoke software data base means for assigning priorities to a plurality of types of the same tune software based on the code number, and karaoke software target tunes of the karaoke service. Edits a unique karaoke software set arbitrarily selected from the data base according to the request of each karaoke house that provides karaoke service, and In the software set, if there is a request for a certain song, the karaoke software to which the highest priority is given is selected, and if there is a request for the same song during the performance, the next priority is given. An editing device for a karaoke software database, comprising: editing means for selecting a karaoke software to which a ranking is assigned. 5. The karaoke software database according to claim 4, wherein the prioritization of karaoke software in said data base means is collectively set for each software set of a karaoke software supplier. Editing equipment. 6. The editing by the editing means is performed by karaoke
The selection is made by selecting a karaoke software set of the software supplier, selecting a program or genre, or selecting a singer's name, and selecting any combination of these.
An apparatus for editing a karaoke software database according to claim 4. 7. A unique code number is assigned to each tune of a karaoke software provided by a plurality of karaoke software suppliers, and a plurality of karaoke software suppliers are provided by the plurality of karaoke software suppliers. A karaoke software data base based on the code number is created by assigning priorities to the same kind of music piece software, and the karaoke software targeted for the karaoke service is provided. Edits a unique karaoke software set arbitrarily selected from the data base according to the demand of each karaoke house providing karaoke service, In the set karaoke software set, if there is a request for a certain song, the karaoke software assigned the highest priority is selected, and during the performance, If there is a request for the same song, the karaoke software provided with the priority in the next order is configured to be selected, and based on the result of the editing, the unique karaoke house provides A karaoke software that prints and publishes the tune list for karaoke service.
How to edit the database.