JP2000082001A - Data management device and method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To early restore a system without lowering the retrieval speed and despite breakdown of a hierarchical structure by storing the multimedia data as a file in a hierarchical area of the hierarchical structure corresponding to a record and retrieving and reading out a relevant position in the hierarchical structure in a read mode. SOLUTION: A prescribed data base management system is used and the records which manage every contents are stored in a contents data base 84a of a contents server 84. At the same time, a directory structure accordant with the field data on every record is formed in a file system and the contents data including the image data, etc., are managed under the control of the directory. In a read mode of the contents data, a position of the directory structure is retrieved and the contents data are read out of the corresponding position. If a record stored in the base 84a or the directory structure is broken, the broken data are restored based on the data on the other non-broken one.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

The present invention relates to a data management apparatus and a data management method, and more particularly to a data management apparatus and a data management method for managing a record composed of a plurality of field data including multimedia data.

[0002]

2. Description of the Related Art DBMS (DataBase Mana)
In the case where a record composed of a plurality of fields is managed by a management system (data management system), a type of each field is defined in advance, and a record composed of field data corresponding to the type definition is stored. As the field type definition here, for example, a character data type, a numerical data type, a date data type, and the like are prepared, and the type of each field is defined according to a record format to be actually used.

In recent years, with the spread of the Internet and the like, the need to manage records including multimedia data such as image data and audio data has been increasing.
Therefore, many DBMSs can manage such records, and in this case, they are used for storing binary data as a type definition of a field in which multimedia data is stored. Define the raw data type to be used.

[0004]

The above-mentioned conventional data management apparatus has the following problems. Multimedia data has a large data amount compared to normal character data and numerical data, and of course, because it is variable length data, the load on the DBMS at the time of retrieval etc. must be large, resulting in As a result, the search speed and the like are significantly reduced. Further, when the multimedia data is composed of a plurality of types of data such as image data and audio data, the management by the DBMS has to be complicated.

In this regard, multimedia data can be managed under a directory of a file system. That is, a directory is formed hierarchically according to a search key at the time of search, and multimedia data is stored under the directory. At the time of search, the directory structure is searched based on a desired search key to obtain multimedia data. Indeed, with such a configuration, even if the multimedia data is composed of a plurality of types of data such as image data and audio data, they can be managed as separate files, and it can be said that there is no troublesome management. However, when the search process is executed step by step, the directory structure must be searched each time, so that the efficiency is low and the search speed may be reduced as a whole.

Further, when a record is destroyed in the former method, the only way to restore the system is to restore the data using the backup data of the database. In the latter case, the directory structure is destroyed. Similarly, the only way to restore the system is to restore it using backup data, and any of the methods could not restore the system early in the event of data corruption.

SUMMARY OF THE INVENTION The present invention has been made in view of the above-mentioned problems, and in managing a record composed of a plurality of field data including multimedia data, it is necessary to prevent a search speed from being lowered, It is an object of the present invention to provide a data management device and a data management method capable of recovering a system at an early stage.

According to one aspect of the present invention, there is provided a data management apparatus for managing a record composed of a plurality of field data including multimedia data, comprising: Multimedia data hierarchical management means for storing the multimedia data as a file in a hierarchical area corresponding to a field of the multimedia data while forming a hierarchical structure corresponding to the record for a storage medium which can be managed by; Multimedia data reading and supplying means for inputting the multimedia data reference request, searching for the location in the hierarchical structure, reading and supplying the multimedia data from the corresponding location.

[0008] In the invention according to claim 1 configured as described above, when managing a record composed of a plurality of field data including multimedia data, the multimedia data hierarchical management means manages the record in a hierarchical structure. The multimedia data is stored as a file in a hierarchical area corresponding to the field of the multimedia data while forming a hierarchical structure corresponding to the record on a possible storage medium, and a request for referring to the multimedia data is issued. When issued, the multimedia data reading and supplying means searches for the location in the hierarchical structure, and reads out and supplies the multimedia data from the corresponding location.

As a specific management system, for example, “a,
b, c, d "(where", "is a field delimiter) when managing a record consisting of four fields,
"D" is assumed to be composed of multimedia data. In this case, "a, b,
In addition to managing the record of “c”, a directory “a / b / c” (“/” is a directory delimiter) may be constructed in the file system, and multimedia data “d” may be stored as a file under the directory. Applicable.

[0010] Here, "a,
In the record “b, c”, for example, it is assumed that the field data “c” is destroyed and cannot be read. In such a case, the record is usually repaired by using the backup data of the database, but if the directory structure of “a / b / c” remains in the file system, this directory structure is used. The record can be repaired. On the other hand, "a / b /
The same applies to the case where the directory structure of “c” is destroyed. If the record of “a, b, c” remains in the database, the directory structure can be repaired without backup data.

Of course, since one record is composed of four fields “a, b, c, d”, if the record “a, b, c” is deleted in the DBMS, the multimedia data “D” is also deleted. At this time, the directory “a / b / c” may also be deleted. Further, it is not necessary to strictly form a hierarchical structure corresponding to each field data. For example, the multimedia data “d” may be stored as a file under the directory “a / c”. Even in this case, with respect to at least the field data “a” and “c”, the record managed by the DBMS and the directory structure formed in the file system can be mutually repaired.

Here, the multimedia data is:
It widely includes variable-length data such as binary data, and specifically includes image data and audio data. Of course, the substantial form is not particularly limited, and can take various forms, such as being composed of image data alone or composed of audio data alone. As one example, the invention according to claim 2 is the data management device according to claim 1, wherein the multimedia data layering management means converts multimedia data composed of a plurality of types of data into a plurality of types corresponding to the types. It is configured to save as a file.

[0013] In the invention according to claim 2 configured as described above, the multimedia data is composed of a plurality of types of data, and the multimedia data hierarchical management means saves the data as a plurality of files corresponding to the type. I do. For example, when the multimedia data includes image data and audio data, the multimedia data is stored as an image data file and an audio data file.

The multimedia data read / supply means only needs to be able to search for the location of the multimedia data by inputting a reference request for the multimedia data, and to read and supply the multimedia data from the corresponding location. Various methods can be applied as a simple search method. As one example, the invention according to claim 3 is the data management device according to claim 1 or 2, wherein the multimedia data reading and supplying means is:
The record is searched and the hierarchical structure is detected from the correspondence of the field data referred to, and the multimedia data is read.

In the invention according to claim 3 configured as described above, when a multimedia data reference request is issued, the multimedia data read / supply means searches the record and refers to the correspondence of the field data. The multimedia data is read and supplied by detecting the hierarchical structure from the correspondence. For example, in the example described above, “a, b,
c) and retrieves “a” from each field data.
This corresponds to a case where the directory structure of “/ b / c” is detected and multimedia data is read.

According to a fourth aspect of the present invention, in the data management apparatus according to the third aspect, the record includes field data indicating the location of the multimedia data. The multimedia data read / supply means detects field data indicating the location of the multimedia data and reads the multimedia data.

That is, the record obtained by the search includes field data indicating the location of the multimedia data, and the multimedia data read / supply means detects the field data and, based on the location, detects the multimedia data. Read data. For example, in the above-described example, the field data "a / b / c"
The multimedia data is read directly from the field data included in the record managed by the.

The invention according to claim 5 is an example of another method for reading multimedia data by the multimedia data reading and supplying means.
In the data management device according to any one of the above, the multimedia data read / supply means is configured to retrieve from the hierarchical structure and read the corresponding multimedia data in response to the multimedia data reference request.

In the invention according to claim 5 configured as described above, when a reference request for multimedia data is issued, the multimedia data reading / supplying means searches from the hierarchical structure and reads the corresponding multimedia data. . For example, in the above-described example, when the multimedia data in which the data “c” is stored in the third field is collectively read, the directory “c” is searched on the file system without going through the DBMS, and the It can be said that the efficiency is high if the multimedia data stored under the subordinate is collectively read.

In managing a record composed of a plurality of field data including multimedia data, a multimedia data field is formed on a storage medium which can be managed in a hierarchical structure while forming a hierarchical structure corresponding to the record. The method of saving the multimedia data as a file in a hierarchical area corresponding to the above is not necessarily limited to a substantial device. As an example,
According to a sixth aspect of the present invention, there is provided a data management method for managing a record composed of a plurality of field data including multimedia data. The multimedia data is stored as a file in a hierarchical area corresponding to a field of the multimedia data while forming a structure, and a reference request for the multimedia data is input to search for a location in the hierarchical structure, and the corresponding location is searched. And reads and supplies the multimedia data. That is, there is no difference that the method is not necessarily limited to a substantial device and is effective as a method.

[0021]

As described above, according to the present invention, when managing a record composed of a plurality of field data including multimedia data, the multimedia data is stored as a file in a hierarchical area having a hierarchical structure corresponding to the record. However, at the time of reading, the location in the hierarchical structure is searched, and the multimedia data is read from the corresponding location, without lowering the search speed.
Further, it is possible to provide a data management device capable of recovering the system at an early stage even when the hierarchical structure is destroyed.

Further, according to the invention of claim 2, a plurality of types of multimedia data may be managed as a plurality of files according to the type, and the management system can be simplified.

Further, according to the third aspect of the present invention,
Since the multimedia data is read out by detecting the hierarchical structure from the correspondence between the field data referred by searching the records, it is possible to improve the search speed when performing a search process using a plurality of search keys. it can.

Further, according to the invention according to claim 4,
Since field data indicating the location of the multimedia data is included in the record, and the multimedia data is accessed using the field data, a higher-speed access can be performed.

Further, according to the invention of claim 5,
Since the corresponding multimedia data is read out by searching from the hierarchical structure in response to the multimedia data reference request, the efficiency is high when, for example, the multimedia data satisfying one search key is read collectively.

Further, according to the invention according to claim 6,
Similarly, without slowing down the search speed,
It is possible to provide a data management method capable of recovering the system early even when the hierarchical structure is destroyed.

[0027]

Embodiments of the present invention will be described below with reference to the drawings. FIG. 1 is a schematic block diagram showing a system configuration to which a data management device according to an embodiment of the present invention is applied. Referring to FIG. 1, it can be seen that a terminal connection server 20, a map information server 30, a GPS server 40, and the like are connected to the Internet network 10. Here, the terminal connection server 20 connects the user's PC 60 or the like via the public line 50 to the Internet network 10 by dial-up connection or 32 kb.
The PDA (Personal Digital Assistant) 70 having a digital communication function of Ps is connected to the Internet 10 and the PC 60 and the PDA 70 are connected to the terminal connection server 2.
0 is accessible to the Internet network 10.

On the other hand, the map information server 30 has image data relating to map information, and
The map information can be obtained from. Also, PDA
70 is provided with a so-called GPS function.
The location of the PDA 70 can be specified by the PS function. Although a specific configuration is not described in detail, it is assumed that unique identification information is assigned to each PDA 70 in advance, and the location of each PDA 70 is managed by the GPS server 40 based on the identification information.

Further, as can be seen from the figure, the Internet network 10 has the We
b server 81, member management server 82, grouping server 83 and content server 84 are connected,
These servers are configured as shown in FIG. In the figure, a Web server 81 includes a CGI program group 81a including a plurality of CGI programs, and each CG program group.
A bulletin board library 81b including a plurality of APIs appropriately called from the I program is provided.
Then, each AP constituting the bulletin board library 81b
According to I, processes such as accessing the member management database 82a of the member management server 82, the grouping database 83a of the grouping server 83, and the content database 84a of the content server 84 are executed. Although not shown, these member management servers 8
2. Grouping server 83 and content server 8
Reference numeral 4 is provided with a predetermined DBMS and manages each database.

The system provider 80 in the present embodiment
Provides a bulletin board that can be used from the PC 60 or the PDA 70, and requests a URL for a desired CGI program from the PC 60 or the PDA 70 to the Web server 81 according to the HTTP protocol. Then, the CGI program is executed on the Web server 81 side and a predetermined A
After the PI is called and the API executes processes such as access to the member management database 82a, the grouping database 83a, and the content database 84a, the processing result is displayed on the PC 6 as a bulletin board.
0 or displayed on the PDA 70. Next, a specific configuration for displaying such a bulletin board will be described in detail using a case where the PDA 70 is used as an example.

The PDA 70 is formed in a substantially rectangular box shape as shown in FIG. 3, and a liquid crystal display panel 71 is embedded in the front of the PDA 70 to enable screen display. Digital communication is possible, and connection to the Internet network 10 is made via the terminal connection server 20 as described above. Then PDA
The URL for the predetermined CGI program of the Web server 81 is requested from the Web server 81, and then the data is transferred from the Web server 81 to the PDA 70, and the liquid crystal display panel 71 displays a screen as shown in FIG.

Referring to FIG. 3, "ID", "Pass"
It can be seen that three items of “word input” and “LOGIN” are displayed. Here, each item is displayed so as to be selectable and inputtable. However, as for “ID”, an ID unique to the terminal is set as an initial value, so the user selects “Password input” and inputs a password. When the input is completed, "LOGIN"
Select Then, the Web server 81 inputs the ID and the password set here to the next CGI.
The program is executed.

This CGI program uses the input ID
The user authentication process is performed using the password and the password. Specifically, in the member management database 82a of the member management server 82, the terminal-specific ID and the user ID of the user are used.
And personal information such as passwords are managed.
The member management database 82a by the GI program
To determine whether the input ID and password are consistent. Here, if the input ID and password are found to be consistent, login is permitted and the user ID is acquired from the member management database 82a. Further, group information such as a group ID to which each user belongs is managed in a grouping database 83a of the grouping server 83, and after acquiring the user ID as described above, the grouping database 8a
The group ID to which the user belongs is acquired from 3a. Of course, if the input ID and password do not match, login is not permitted.

When the user authentication process is completed as described above, data is similarly transferred from the Web server 81 to the PDA 70, and a bulletin board top page as shown in FIG. Referring to FIG.
Three items of "personal bulletin board", "group bulletin board" and "user setting" are displayed, and each of these items can be selected and inputted. In the present embodiment, various user settings can be made by selecting the item “user setting”, and it is assumed that such user settings have been made in advance. Here, when "Personal Bulletin Board" is selected, the next CGI program is further activated, and a display map selection screen as shown in FIG.

This display map selection screen is a selection screen for selecting desired map information from the map information server 30, and includes "display the position of the last displayed bulletin board" and "display the position where the current location plotted last." The four items of “display”, “display with current location plot” and “select from map” are displayed in a selectable manner. Here, it can be seen that "JR Shibuya station square" is displayed below the item "display the position of the last displayed bulletin board". This means that the last displayed map information is “JR Shibuya Station”, and when this item is selected, a predetermined CGI program is activated and the map information of the JR Shibuya Station is sent from the map information server 30 to the WWW.
PDA after being acquired by the eb server 81 and appropriately processed
The data is transferred to 70 and displayed on the screen. In addition, under the item "Display the position where the current location was plotted last", "Shibuya Center Street" is displayed. Even when this item is selected, a predetermined CGI program is started and the Shibuya Center is started. The map information of the town is obtained from the map information server 30 by the Web server 81, similarly processed as appropriate, and then transferred to the PDA 70 and displayed on the screen.

More specifically, as shown in FIG.
When the CGI program for displaying the display map selection screen is started in the server 81, the content server 8
A search request for No. 4 is issued. As can be seen from the figure, the content database 84a of the content server 84 has "first history position information" representing the position of the bulletin board displayed last for each user in a predetermined three-dimensional coordinate system.
Field and a "first history address information" field representing the address, and a "second history location information" field representing the location where the current location was plotted in a three-dimensional coordinate system and a "second history address information" representing the address. Second History Address Information "
A history information management table including fields is managed. Therefore, if the history information management table is searched using the user ID, the position of the bulletin board displayed last by the user and the position where the current location plot was last performed are also determined, and the Web server 81 determines the search result. , The corresponding map information is transferred to the PDA 70 and displayed on the screen.

On the other hand, a predetermined CGI program is also executed when the item "present location plot and display" is selected. In this case, the PDA is
70 is obtained from the GPS server 40, and corresponding map information is obtained from the map information server 30 based on the position information, and is appropriately processed.
Transfer data to and display it on the screen. Further, when "select from map" is selected, a predetermined CGI program is executed in the same manner. In this case, small-scale map information is acquired from the map information server 30 and transferred to the PDA 70 by data transfer. It is displayed on the screen. Here, when the user selects a desired position on the display screen of the PDA 70, the map information is sequentially narrowed down and large-scale map information is acquired from the map information server 30, and similarly, the PDA 70 is obtained.
Is displayed on the screen.

FIG. 8 shows a PDA in a state where a desired item is selected on the display map selection screen and a personal bulletin board is displayed.
70 shows a display screen. Referring to the figure, it can be seen that an icon of a human figure is displayed on the displayed map. This icon means that the content has been registered by the user. When the “upload” item shown in FIG. 8 is selected, a predetermined CGI program is started, and the content registration process is performed according to the flowchart of FIG. Done. Here, the content is composed of data such as image data and text data, and can be registered at a desired position on a map by a user.

In FIG. 9, since a dedicated editor is opened in step S110, as shown in FIG. 10, the user performs the input of the title and the text of the body, the pasting of the image data, and the like on the editor. Here, as the image data to be pasted, data prepared in advance on the server side may be used, or the user may register his / her own face photograph or the like. Thereafter, when "SEND" is selected at the lower right of the screen, the header information as shown in FIG. 11 is displayed in step S130 via step S120. In the figure, the title that is actually input is displayed in the item of “title”, the destination to which the content is to be transmitted is displayed in the item of “destination”, and the content is registered in the item of “location”. Is displayed. After changing each item as necessary, select “Post”. Then, step S140 is performed via step S140.
At 150, record registration processing is performed on the user content management table of the content database 84a.

This user content management table is configured as shown in FIG. Here, “content number” is a number uniquely assigned to the content registered by the user, and “group I”
“D” is uniformly set to “0”, and “User I”
“D” stores the user ID of each user. In addition, for "Creation Date" and "Update Date", the creation and update dates are respectively obtained from the system date and stored, and for "Title", the title of the content actually entered is stored Is done. In addition, "location information"
Is stored in the three-dimensional coordinate system of the position where the content is to be registered, and the data path is in accordance with the rule of (user content management root directory) / (initial of user ID) / (user ID) / (content number). A path is generated and stored. Note that the user content management root directory here can be set arbitrarily, but in the present embodiment, “/ home /
user ".

After the record registration process is completed, necessary directories and files are created on a hard disk (not shown) of the content server 84 in the next step S160. That is, as shown in FIG. 13, a directory corresponding to the above data path is constructed, and image data and text inputted by the editor are stored as files under the content number directory which is the terminal directory. Although not described above, an audio data file can also be registered as a content, and an audio data file (WAV sound file) is also stored in the audio data file shown in FIG. And audio data file form one content data.

C for displaying the personal bulletin board shown in FIG.
The GI program processes the original map information acquired from the map information server 30 so that the icon for the content registered as described above is pasted, transfers the data to the PDA 70, and performs the screen display. As shown in the flowchart of FIG. In the figure, in step S210, the original map information for the item selected by the user on the display map selection screen in FIG. 6 is acquired from the map information server 30, and the next step S22
At 0, position information consisting of a three-dimensional coordinate system at four corners is detected in the original map information as shown in FIG. Then, in step S230, the user content management table is searched in order from the top record using the user ID of the user and the position information of the detected original map information as a search key, and the corresponding content registered on the original map information to be displayed is displayed. Is detected.

If the content is detected, the data path name of the record corresponding to the content is obtained in step S240, and the image data file stored under the terminal directory is obtained based on the data path name. In the next step S250, the same image data file is pasted as a thumbnail at the position indicated by the position information of the content and processed. Thereafter, when the corresponding content is detected in the same manner, the map information is processed by pasting it in the same manner as a thumbnail, and when all the corresponding contents have been detected, the map information processed in step S260 is converted to the PDA.
Transfer to 70. Then, on the PDA 70 receiving this, the map information with the icon attached is displayed as shown in FIG.

The displayed icons can be selected. When a desired icon is selected, a predetermined CGI program is started, and the processing is executed according to the flowchart of FIG. In the figure, in a step S310, the user content management table is searched to obtain a data path of the content for the selected icon.
Then, in step S320, content data such as an image data file or a text file stored under the terminal directory is acquired based on the same data path,
After generating predetermined screen information in the next step S330, the same screen information is transmitted to the PDA 70 in step S340. Then, the PDA 70 that has acquired the screen information displays the registered content as shown in FIG.

The method of using this content is roughly as follows. For example, if a user finds a favorite store or the like, the user registers the content with a memo or the like. Then, the next time the map information in the vicinity is displayed, the registered content is displayed as an icon. Therefore, if the icon is selected and the content is displayed, a favorite shop or the like can be found. Of course, this is only an example of a usage method, and it can be used for another purpose, and it can be said that it is easy for a user to understand if the registered image data is changed according to the purpose.

Referring to FIG. 8, it can be seen that there is a portion where a plurality of icons are displayed so as to overlap. This means that a plurality of pieces of content are registered in a plurality of pieces of proximity information or a place having the same piece of location information. When these icons are selected, a predetermined CGI program is activated and overlaps. The content is detected, and as shown in FIG. 18, the image data of each content is displayed as a thumbnail, and the registered title is displayed. Then, when "PREV / NEXT" is appropriately selected on the content list screen and a desired content is selected, the selected content is displayed in the same manner.

On the other hand, when "content list" is selected on the display screen shown in FIG. 8, a content list screen as shown in FIG. 18 is displayed by a predetermined CGI program. A list of all registered contents is displayed. Specifically, (user content management root directory) / (user I
All image data files are obtained under the directory of (initial letter D) / (user ID), and are pasted as thumbnails on the display screen while being sorted in the order of content numbers. On the other hand, a search is performed using the user ID of the user in the user content management table of the content database 84a as a search key, and the obtained records are sorted by content number, and the titles are similarly pasted on the display screen in the same manner. .

That is, since it is necessary to acquire all the contents registered by the user for the image data file, the contents database 84a
It can be said that the search efficiency is better if all the image data files are acquired collectively while tracing under the directory of the user ID of the user without searching for. On the other hand, since the title is the information stored in the content database 84a,
Will be retrieved and retrieved. As described above, by setting different search modes in each search routine, the search speed is improved as a whole.

Further, when "change map scale" is selected on the display screen shown in FIG. 8, a map whose scale is changed is displayed, and the map is selected by selecting an arrow in eight directions. It is possible to display a map that has transitioned in the direction of the arrow. That is, the map information is formed in a grid shape as shown in FIG. 19 according to the scale, and the map information in the selected arrow direction is newly acquired from the map information server 30.

On the other hand, when "group bulletin board" is selected on the bulletin board top page shown in FIG. 5, a predetermined CGI program is similarly executed, and the group bulletin board top page shown in FIG. 20 is displayed. In the figure,
“Group A” and “Group B” are groups created by selecting the item “Group setting / management”. Although not described in detail, you can add members of each group by selecting "Group setting / management"
And can be deleted. Less than,
The function of the group bulletin board will be described assuming that the item of “group A” is selected for convenience of explanation. Of course, the same applies to a case where an item of another group such as “group B” is selected.

FIG. 21 shows a group bulletin board displayed when the item "group A" is selected. In the same figure, it can be seen that an icon is displayed on the map in this case as well. These icons also mean that the content registered by the user exists, and are registered by selecting the item of “upload” as in the case of the personal bulletin board described above. However, since the content registered here is a content as a group and is assumed to be shared by users belonging to the same group, the management system is different from the above-described user content.

For example, FIG. 22 shows a group content management table in the content database 84a for managing such group content. Each field of the group content management table is the same as the above-described user content management table, but differs in data to be actually stored. That is, in the above-mentioned user content management table, “0” is stored uniformly in “group ID”, but in the group content management table, the group ID to which the user belongs is stored.

For the data path, (group content management root directory) / (end of group ID) / (group ID) / (initial of user ID) /
A path is generated and stored according to the (user ID) / (content number) rule. Note that the group content management root directory here can also be set arbitrarily, but in the present embodiment, “/ home / gr” is used.
"up". Needless to say, the directory constructed on the hard disk is also different from the case of the user content as shown in FIG. 23, but the content data including the image data file and the text file is stored under the content number directory which is the terminal directory. Is similar.

Therefore, the processing procedure of the CGI program for displaying the group bulletin board shown in FIG. 21 is almost the same as that of the flowchart shown in FIG. 14, but differs in the database search processing in step S230. In other words, the table to be searched is the group content management table, and its search key is the group ID “100” and the position information of the original map information. Of course, the processing procedure of the CGI program when an icon is selected in the group bulletin board of FIG. 21 is the same as that of the flowchart shown in FIG. 16, but the table to be searched is not the group content management table. Needless to say.

Further, when "content list" is selected on the group bulletin board shown in FIG.
The GI program is executed, and a list screen of group contents in the same group is displayed in the same manner as in the case of the personal bulletin board described above. Of course, in this case, (group content management root directory) / (group ID
All image data files are acquired while tracing the directory structure under the directory of (end of) / (group ID), sorted in the order of content number, and pasted on the display screen as thumbnails. On the other hand, a search is performed using the group ID of the user in the group content management table of the content database 84a as a search key, the obtained records are sorted by content number, and the titles are sequentially pasted on the display screen.

On the other hand, it can be seen that the item "member present location" is displayed on the group bulletin board in FIG.
This item is also displayed so as to be selectable. When the item is actually selected, a predetermined CGI program is executed, and the current position of members of the same group present on the displayed map is displayed as an icon. I have. Specifically, since the position ID management table shown in FIG. 7 manages the group ID to which each user belongs and the “second history position information” indicating the position where each user last plotted the current position. By searching these field data, members existing on the displayed map and their positions are detected, and a face photograph or the like of each member recorded in advance is displayed as a thumbnail.

As described above, when the information for managing the content is managed in the content database 84a and the actual content data is managed in an area outside the content database 84a, the following will occur. Characteristic effects can be obtained.

First, when the directory structure in the file system is destroyed, the directory structure can be restored by referring to each record in the content database 84a. Because
Since the directory structure corresponds to the field data of each record, the directory structure can be determined to some extent by referring to the field data of all the records. Second, the content database 84a
In the event that is destroyed, a partial database recovery can be performed without a database backup. For example, in the user content management table shown in FIG. 12, when the data path of the record with the content number “2000” cannot be read due to damage of a data block or the like, “/ home / us
The directory "2000" may be searched under "er", and its path name may be replaced with field data of the data path that cannot be read.

Next, the operation of the present embodiment configured as described above will be described. When a PDA 70 equipped with a 32 kbps digital communication function is connected to the Internet 10 via the terminal connection server 20, a URL request for a predetermined CGI program in the CGI program group 81a of the Web server 81 is transmitted from the PDA 70 according to the HTTP protocol. You. Then W
The data is transferred from the eb server 81 to the PDA 70, and the PDA 70 displays the login screen shown in FIG.

Here, as for the “ID”, since an ID unique to the terminal is set as an initial value, the user selects “Password input” and inputs a password. When the input is completed, "LOGIN"
Select Then, the Web server 81 inputs the ID and the password set here to the next CGI.
The program is executed to perform a user authentication process.

When the login is permitted and the user authentication process is completed, the Web server 81 similarly sends the PDA 70
Is transferred to a message board top page as shown in FIG. If "Personal Bulletin Board" is selected here, the next CGI program is started, and a display map selection screen as shown in FIG. 6 is displayed on the liquid crystal display panel 71, so that the user selects a desired item. Then, a predetermined CGI program is further activated, and the original map information for the item selected by the user on the display map selection screen of FIG. 6 is acquired from the map information server 30 (step S).
210), position information consisting of a three-dimensional coordinate system at the four corners is detected from the same map information (step S220). Thereafter, the user content management table is searched in order from the top record using the user ID of the user and the position information of the detected original map information as a search key, and the corresponding content registered on the original map information is detected (step S2).
30).

When the content is detected, the data path name of the record corresponding to the content is obtained, and the image data file stored under the terminal directory is obtained based on the data path name (step S240). Then, the same image data file is pasted as a thumbnail at the position indicated by the position information of the content and processed (step S250). Thereafter, when the corresponding content is detected in the same manner, the map information is processed by pasting it in the same manner as a thumbnail, and the processed map information is transferred to the PDA 70 when all the corresponding contents are detected (step S260). Then, PD which received this
As a result, a personal bulletin board as shown in FIG. 8 is displayed on the A70 side.

Further, in the personal bulletin board shown in FIG.
When a desired icon is selected, a predetermined CGI program is started, a user content management table is searched,
The data path of the content for the selected icon is obtained (step S310). Then, content data such as an image data file or a text file stored under the terminal directory is acquired based on the data path (step S320), and after generating predetermined screen information (step S330), the screen information is obtained. PDA7
0 (step S340). Then, the PDA 70 that has acquired the screen information displays the registered content as shown in FIG.

When registering such contents,
The item "upload" is selected on the personal bulletin board shown in FIG. Then, a predetermined CGI program is started and a dedicated editor is opened (step S
110), as shown in FIG. 10, the user inputs the title and text of the text, pastes image data, and the like on the editor. Thereafter, when "Send" is selected at the lower right of the screen, header information as shown in FIG. 11 is displayed (step S).
120, S130). In the figure, the title that is actually input is displayed in the item of “title”, the destination to which the content is to be transmitted is displayed in the item of “destination”, and the content is registered in the item of “location”. Is displayed. After changing each item as necessary, select “Post”. Then, the content database 84
A record registration process is performed on the user content management table a (steps S140 and S150).

That is, in the “content number” of the user content management table, a number uniquely assigned to the content is stored, and for the “group ID”, “0” is uniformly set, and the “user ID” is set. Indicates the user ID of the user. In addition, "Creation date"
For "update date", the creation and update dates are acquired from the system date and stored, and for "title", the title of the actually input content is stored. Further, the "position information" stores the three-dimensional coordinate system of the position where the content is to be registered, and the data path is (user content management root directory) / (initial of user ID) / (user ID) / ( A path is generated and stored according to the rule of (content number).

When the record registration process is completed, necessary directories and files are created on a hard disk (not shown) of the content server 84 (step S160). That is, as shown in FIG. 13, a directory corresponding to the above data path is constructed, and image data, text, and the like input by the editor are stored as files under the content number directory which is the terminal directory.

Further, when "content list" is selected on the personal bulletin board shown in FIG.
The content list screen as shown in FIG. 18 is displayed by the program. In this case, a list of all the contents registered by the user is displayed. Specifically, all image data files are obtained under the directory of (user content management root directory) / (initial letter of user ID) / (user ID), and are pasted as thumbnails on the display screen while being sorted in order of content number. wear. On the other hand, a search is performed using the user ID of the user in the user content management table of the content database 84a as a search key, and the obtained records are sorted by content number, and the titles are similarly pasted on the display screen in the same manner. .

On the other hand, when "group bulletin board" is selected on the bulletin board top page shown in FIG. 5, a predetermined CGI program is similarly executed, and the group bulletin board top page shown in FIG. 20 is displayed. Here, it is assumed that the user has selected the item of “group A”. Then
A predetermined CGI program is executed, map information is processed in the same manner as in the case of the personal bulletin board described above, and the group bulletin board shown in FIG. However,
In this case, the table to be searched is the group content management table, and the search key is the group ID.
Needless to say, it becomes the position information of the barrel "100" and the original map information. When the icon is selected on the group bulletin board shown in FIG.
The program is started, and the corresponding content is displayed in the same manner as in the case of the personal bulletin board described above. Of course, the table to be searched in this case is the group content management table.

These contents are also registered by selecting the item of "upload" as in the case of the personal bulletin board described above. However, the content registered here is different from the above-described user content because it is assumed that the content is a group content and is shared by users belonging to the same group.

That is, each field of the group content management table in the content database 84a in which the record registration process is performed is the same as the above-described user content management table, but the “group ID” in the group content management table includes the user. Is stored, and for the data path, (group content management root directory) / (end of group ID) / (group ID) / (initial of user ID) / (user ID) / (content number) A path is generated and stored according to the rules. The storage of content data such as image data files and text files under the content number directory on the hard disk is the same as in the personal bulletin board described above.

Further, when "content list" is selected on the group bulletin board shown in FIG.
The GI program is executed, and a list screen of group contents in the same group is displayed in the same manner as in the case of the personal bulletin board described above. Of course, in this case, (group content management root directory) / (group ID
All image data files are acquired while tracing the directory structure under the directory of (end of) / (group ID), sorted in the order of content number, and pasted on the display screen as thumbnails. On the other hand, a search is performed using the group ID of the user in the group content management table of the content database 84a as a search key, the obtained records are sorted by content number, and the titles are sequentially pasted on the display screen.

As described above, a record for managing each content is stored in the content database 84a using a predetermined DBMS, and a directory structure corresponding to the field data of each record is constructed in the file system, and Content data such as image data is managed under the directory. When reading the content data, the location in the directory structure is searched and the content data is read from the corresponding location, and one of the record and the directory structure in the content database 84a is destroyed. In this case, the data destroyed based on the other data is restored, so that the retrieval speed of the content data is not reduced, and the system can be restored early even when the data is destroyed. .

[Brief description of the drawings]

FIG. 1 is a schematic block diagram showing a system configuration to which a data management device according to an embodiment of the present invention is applied.

FIG. 2 is a schematic block diagram illustrating a configuration of various servers.

FIG. 3 is a front perspective view showing an example of a PDA.

FIG. 4 is a view showing a login screen displayed on the PDA.

FIG. 5 is a diagram showing a bulletin board top page displayed on the screen of the PDA.

FIG. 6 is a diagram showing an example of a display map selection screen displayed on the PDA when “Personal Bulletin Board” is selected on the bulletin board top page.

FIG. 7 is a diagram showing a configuration for searching a content database from a Web server.

FIG. 8 is a diagram illustrating an example of a personal bulletin board displayed on a screen of a PDA.

FIG. 9 is a diagram showing a processing procedure of content registration processing.

FIG. 10 is a diagram showing an example of an editing screen of an editor used in a PDA.

FIG. 11 is a diagram illustrating an example of header information displayed on a screen of a PDA.

FIG. 12 is a diagram showing a user content management table.

FIG. 13 is a diagram showing a directory structure in which user content data is stored.

FIG. 14 is a flowchart illustrating a processing procedure of a personal bulletin board display process.

FIG. 15 is a view showing that coordinate values of four corners in an original map are obtained.

FIG. 16 is a flowchart illustrating a processing procedure of content display processing.

FIG. 17 is a diagram illustrating an example of content data displayed on a screen of a PDA.

FIG. 18 is a diagram showing a content list displayed on the screen of the PDA.

FIG. 19 is a diagram showing that map information is configured in a grid shape.

FIG. 20 is a diagram showing a group bulletin board top page displayed on the screen of the PDA.

FIG. 21 is a diagram showing an example of a group bulletin board displayed on a screen of a PDA.

FIG. 22 is a diagram showing a group content management table.

FIG. 23 is a diagram showing a directory structure in which group content data is stored.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 10 ... Internet network 20 ... Terminal connection server 30 ... Map information server 40 ... GPS server 50 ... Public line 60 ... PC 70 ... PDA 71 ... Liquid crystal display panel 72 ... Communication antenna 80 ... System provider 81 ... Web server 81a ... CGI program Group 81b: bulletin board library 82: member management server 82a: member management database 83: grouping server 83a: grouping database 84: content server 84a: content database

Claims (6)

[Claims] 1. A data management device for managing a record composed of a plurality of field data including multimedia data, wherein a hierarchical structure is formed on a storage medium that can be managed in a hierarchical structure in accordance with the record. Multimedia data hierarchical management means for storing the multimedia data as a file in a hierarchical area corresponding to the field of the multimedia data while inputting a reference request for the multimedia data to search for a location in the hierarchical structure And a multimedia data reading and supplying means for reading and supplying the multimedia data from a corresponding location. 2. The data management apparatus according to claim 1, wherein said multimedia data layering management means comprises:
A data management device for storing multimedia data composed of a plurality of types of data as a plurality of files corresponding to the types. 3. The data management device according to claim 1, wherein the multimedia data read / supply unit searches the record to determine the hierarchical level based on a correspondence relationship of field data referred to by the search. A data management device for detecting a structure and reading the multimedia data. 4. The data management device according to claim 3, wherein the record includes field data indicating the location of the multimedia data, and the multimedia data read / supply unit determines the location of the multimedia data. A data management device for detecting the field data shown and reading the multimedia data. 5. The data management device according to claim 1, wherein the multimedia data read / supply unit retrieves from the hierarchical structure in response to the multimedia data reference request. A data management device for reading out corresponding multimedia data 6. A data management method for managing a record composed of a plurality of field data including multimedia data, wherein a hierarchical structure is formed on a storage medium that can be managed in a hierarchical structure in accordance with the record. While storing the multimedia data as a file in a hierarchical area corresponding to the field of the multimedia data, a reference request for the multimedia data is input to search for a location in the hierarchical structure. A data management method for reading and supplying media data.