JP2007079685A - File sharing management system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a file sharing management system allowing sharing of one file between a plurality of folders and allowing generation (version) management while maintaining relationship of the file even when the file is updated. <P>SOLUTION: In this file sharing management system 1, a file information management database 2 storing file information and folder/file relationship information, a folder/file entity storage device 3 storing a folder entity and a file entity, a screen display part 4, and an input part 5 are connected to an information processor 6 freely communicatively. A database processing part 31 in the information processor 6 is provided with a copy source file information acquisition means, which acquires data from file information and folder/file relationship information of a copy source file, and a copy destination file information registration means generating and registering a new record as folder/file relationship information of a copy destination file. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

  The present invention relates to a file sharing management system for managing files by storing them in a folder, and more particularly to a file sharing management system for sharing and managing one file among a plurality of folders.

  Conventionally, a file system in an OS (Operating System) stores a file in a folder, and when the file is copied to another folder, the file entity is copied at that point. If you want to handle the same file in multiple folders, create a shortcut to the file you want to copy to the copy destination.

  Recently, as a document management system, in addition to the file system of the OS, a method with added value by managing logical information has been adopted.

The following patent document 1 is mentioned as a well-known technical document regarding this invention.
JP-A-10-269071

  In the conventional file management method, when a file is copied, only the actual file is copied. Therefore, even if the content is exactly the same, the capacity of the storage device is consumed for the file size, resulting in waste. Also, since the relationship between the copy source file and the copy destination file is cut off at the time of copying, if it is a file, manual, or technical document created by collaborative production, there is no similar relationship The file becomes random. In that case, when a file search is performed, a plurality of files having exactly the same contents are hit, and the user is confused about which file to update.

  For the above problem, in order to share files between multiple folders, you can maintain the relationship by creating a shortcut to the share source file in the share destination folder, but share it with the share destination You can only have files in exactly the same state, and you cannot manage files with different contents while maintaining the relationship between the sharing source and sharing destination.

  In view of the above situation, the present invention provides a file sharing management system capable of sharing one file among a plurality of folders and managing generations (versions) while maintaining the relevance of the file even when the file is updated. The purpose is to provide.

In order to solve the above problems, the present invention provides the following configurations.
The invention according to claim 1 includes a file information management database for storing file information and folder / file related information, a folder / file entity storage device for storing actual folders and files, a screen display unit, and an input unit. Is a file sharing management system communicatively connected to the information processing apparatus,
The file information management database includes a file management table for managing a file management record indicating file information including a file ID, a file version, an entity file path, and a last update date and time,
Stores a folder / file related table for managing a folder / file related record indicating a folder / file related information including a file path, a file ID, a file version, a file last updated date / time, and a link file last updated date / time. ,
The information processing apparatus processes a database processing unit for processing the file management record and a folder / file related record, an entity data processing unit for processing the entity folder and file, and display information sent to the screen display unit. A screen display processing unit,
The database processing unit acquires data indicating a file ID, a file version, and a last update date and time from a file management record of a copy source file of the file management table based on a copy request from the input unit; and Copy source file information acquisition means for acquiring data indicating the last update date / time of the link file from the folder / file related record of the copy source file in the folder / file related table;
A new record is created in the folder / file relation table, the absolute path of the copy destination file is set in the new record, and the data acquired by the copy source file information acquisition means is set and registered. The present invention provides a file sharing management system comprising an information registration means.

In the invention according to claim 2, when the file is updated, the database processing unit further acquires, from the folder / file relation table, a record that matches the file ID and file version of the file, and a plurality of the records are obtained. A file sharing determination means for determining that the file is not shared when the file is shared and the record is singular;
When it is determined that the file is shared, a new record obtained by copying the file management record of the copy source file is added to the file management table, the file version value of the new record is changed, and the updated file is updated. New record adding means to set the absolute path and last update date and time,
A record update means for overwriting the last update date and time for a record whose path matches the update file on the file management table when it is determined that the file is not shared;
In the folder / file relation table, the file last update date / time of the record in which the absolute path of the updated file matches the file path is updated, and the link file last update date / time of the record in which the file ID of the updated file matches is updated. Table updating means for updating,
The entity data processing unit includes entity file registration means for registering an updated entity file in a folder / file entity storage device when the file sharing determining means determines that the file is shared. The file sharing management system according to claim 1 is provided.

In the invention according to claim 3, the database processing unit further includes file information acquisition means for acquiring a record of the update file on the folder / file relation table,
Update determination means for determining that the file is shared and updated when the link file last update date and time of the acquired record is date and time information that is newer than the file last update date and time,
The screen display processing unit includes display means for displaying and notifying on the screen display section when it is determined by the update determining means that the file is shared and updated. A file sharing management system according to claim 2 is provided.

According to the first aspect of the present invention, a file information management database for storing file information and folder / file related information, a folder / file entity storage device for storing actual folders and files, and a screen display A file sharing management system in which the communication unit and the input unit are connected to the information processing apparatus in a communicable manner,
The file information management database includes a file management table for managing a file management record indicating file information including a file ID, a file version, an entity file path, and a last update date and time,
Stores a folder / file related table for managing a folder / file related record indicating a folder / file related information including a file path, a file ID, a file version, a file last updated date / time, and a link file last updated date / time. ,
The information processing apparatus processes a database processing unit for processing the file management record and a folder / file related record, an entity data processing unit for processing the entity folder and file, and display information sent to the screen display unit. A screen display processing unit,
The database processing unit acquires data indicating a file ID, a file version, and a last update date and time from a file management record of a copy source file of the file management table based on a copy request from the input unit; and Copy source file information acquisition means for acquiring data indicating the last update date / time of the link file from the folder / file related record of the copy source file in the folder / file related table;
A new record is created in the folder / file relation table, the absolute path of the copy destination file is set in the new record, and the data acquired by the copy source file information acquisition means is set and registered. Since the file sharing management system including the information registration means is provided, it is possible to provide a file sharing management system that can be shared among a plurality of folders without actually copying one file.

According to the invention described in claim 2, when the file is updated, the database processing unit further acquires a record that matches the file ID and file version of the file from the folder / file relation table, and A file sharing determination means for determining that the file is not shared when the file is shared and the record is singular;
When it is determined that the file is shared, a new record obtained by copying the file management record of the copy source file is added to the file management table, the file version value of the new record is changed, and the updated file is updated. New record adding means to set the absolute path and last update date and time,
A record update means for overwriting the last update date and time for a record whose path matches the update file on the file management table when it is determined that the file is not shared;
In the folder / file relation table, the file last update date / time of the record in which the absolute path of the updated file matches the file path is updated, and the link file last update date / time of the record in which the file ID of the updated file matches is updated. Table updating means for updating,
2. The entity data processing unit comprises entity file registration means for registering an updated entity file in a folder / file entity storage device when it is determined by the file sharing determination means that the file is shared. File sharing management system can be shared between multiple folders without actual copying, and generation (version) management can be performed while maintaining file relevance even if the file is updated. A file sharing management system can be provided.

According to the invention of claim 3, the database processing unit further includes file information acquisition means for acquiring a record of the update file on the folder / file relation table;
Update determination means for determining that the file is shared and updated when the link file last update date and time of the acquired record is date and time information that is newer than the file last update date and time,
The screen display processing unit includes a display unit that displays and notifies the screen display unit when the update determining unit determines that the file is shared and updated. In addition to the effect of the described invention, the user can grasp the update by notifying the update to the file having the relation with the updated file.

Hereinafter, embodiments of the present invention will be described with reference to the drawings showing examples.
In the figure, reference numeral 1 denotes a file sharing management system according to the present invention. The file sharing management system 1 includes a file information management database 2 for storing file information and folder / file related information, and an actual folder and file. A folder / file entity storage device 3 to be stored, a screen display unit 4 for visually confirming an operation result or file update presence, and an input unit 5 for a user to input a file operation or the like are provided in the information processing device 6. Connected freely.

  The file information management database 2 stores a file management table 7 for managing file information and a folder / file related table 8 for managing folder / file related information. As shown in FIG. 7 manages a file management record 15 indicating file information including a file ID 11, a file version 12, an entity file path 13, and a last update date and time 14. A folder / file relation table 8 includes a file path 21, A folder / file related record 26 indicating folder / file related information including a file ID 22, a file version 23, a file last update date / time 24, and a link file last update date / time 25 is managed.

  The file management record 15 is managed so as to have a one-to-one relationship with the entity file. The file ID 11 indicates an ID that is uniquely assigned to identify the file, and the file version 12 is a sequence number that is assigned when the file is updated while being shared by a plurality of folders within the same file ID 11. Is shown.

  As shown in FIG. 1, the information processing apparatus 6 includes a database processing unit 31 for processing the file management record 15 and the folder / file related record 26, and an entity data processing unit for processing the entity folder and file. 32 and a screen display processing unit 33 for processing display information to be sent to the screen display unit 4.

  Further, as shown in FIGS. 1 to 3, the database processing unit 31 receives the file ID 11 and the file ID from the file management record 15 of the copy source file of the file management table 7 based on the copy request from the input unit 5. Data indicating the version 12 and the last update date / time 14 is acquired, and data indicating the link file last update date / time 25 is acquired from the folder / file related record 26 of the copy source file in the folder / file related table 8. A new record is created in the copy source file information acquisition means 41 and the folder / file relation table 8, the absolute path of the copy destination file is set in the file path 21 in the new record, and the copy is made in the new record. Data acquired by the original file information acquisition means 41 Set, and a destination file information registration means 42 for registering.

  Furthermore, when the file is updated, the database processing unit 31 obtains a folder / file related record 26 that matches the file ID 22 and the file version 23 of the updated file from the folder / file related table 8. When there are a plurality of file related records 26, the file is shared, and when there is a single folder / file related record 26, the file sharing determining means 43 for determining that the file is not shared, and the file are shared If it is determined that the file management table 7 is copied, a new record obtained by copying the file management record 15 of the copy source file is added to the file management table 7, the value of the file version 12 of the new record is changed, and the updated file absolute path Is set to the entity file path 13 When it is determined that the file is not shared with the new record adding means 44 for setting the last update date and time 14, the file management record 15 in which the update file and the actual file path 13 match on the file management table 7 In the record update means 45 for overwriting the update date and time 14, and in the folder / file relation table 8, the file final update of the folder / file relation record 26 in which the file path 21 that matches the absolute path of the updated file is set. Table update means 46 is also provided for updating the date 24 and further updating the link file last update date 25 of the folder / file related record 26 whose file ID 22 matches the updated file.

  On the other hand, the entity data processing unit 32 registers the updated entity file in the folder / file entity storage device 3 when the file sharing determining unit 43 determines that the updated file is shared. It has.

  The database processing unit 31 further includes a file information acquisition unit 48 for acquiring the folder / file related record 26 of the update file on the folder / file related table 8, and a link file last of the acquired folder / file related record 26. Update date and time information that is newer than the file last update date and time 24, and an update determination unit 49 that determines that the file is shared and updated, and the screen display processing unit 33 further includes: When the update determination unit 49 determines that the file is shared and updated, the update determination unit 49 includes a display unit 50 that displays the file on the screen display unit 4 and notifies the update.

  Thus, the three functions of a copy (shared) process, a file content update process, and a file update notification for the file created in the file sharing management system 1 according to the flowcharts shown in FIGS. explain.

  FIG. 4 is a flowchart showing a file copy processing procedure in the file sharing management system 1.

  When the user performs a file copy operation from the input unit 5 to move the file to another folder or the like, the database processing unit 31 in the information processing apparatus 6 copies from the file management table 7 by the copy source file information acquisition unit 41. The file ID 11, the file version 12, and the last update date / time 14 are acquired as the original file information, and the link file last update date / time 25 is acquired from the folder / file relation table 8 based on the copy source file path (step S 1).

  Next, a new folder / file related record 26 is created on the folder / file related table 8 as copy destination information by the copy destination file information registration means 42.

  In this folder / file related record 26, the file path 21 is the absolute path of the copy destination file, the file ID 22 is the file ID 11 acquired in step S 1, the file version 23 is the file version 12 acquired in step S 1, and the file last update date / time 24. The link file last update date / time 25 acquired in step S1 is set as the last update date / time 14 acquired in step S1 and the link file last update date / time 25 (step S2).

  For example, as shown in FIG. 5A, when the file name “ABC.txt” is newly created, the file ID 11 is automatically assigned by the database processing unit 31 on the file management table 7 (here, “00000001”). The file version 12 is the initial value “0001”, the actual file path 13 is the path where the file is stored (here, “C: \ ABC.txt”), and the last update date 14 is the file “ABC” .txt ”is registered as the last update date and time (here,“ 2005/01/01 12:00:00 ”).

  At the same time, as shown in FIG. 5B, the absolute path of the file “ABC.txt” (the actual file path 13 “C: \ ABC. txt "), file ID 22 is" 00000001 "stored in file ID 11 on file management table 7, file version 23 is" 0001 "stored in file version 12 on file management table 7, and file last update date 24 is file management. “2005/01/01 12:00:00” stored at the last update date 14 on the table 7 is stored.

  Since the file is not shared when a new file is created, the same value as the file last update date 24 is set for the link file last update date 25.

  The file information copied by this processing is managed by the file information management database 2, and the actual file is not copied. When it is necessary to refer to the actual file, the file ID 22 and the file version 23 corresponding to the file path 21 to be referred to are obtained from the folder-file relation table 8, and the file ID 11 and the file version 12 on the file management table 7 match. The entity file indicated in the entity file path 13 of the management record 15 may be referred to.

  FIG. 6 is a flowchart showing a processing procedure when updating a file according to the present invention.

  First, the file sharing determination unit 43 of the database processing unit 31 determines whether or not the updated file is shared among a plurality of folders (step S11). In this determination, the file ID 22 and the file version 23 on the folder-file relation table 8 are acquired from the file path 21 of the updated file, and the number of folder / file related records 26 having the same file ID 22 and file version 23 is acquired. To do.

  As a result, when the number of records of the acquired folder / file related record 26 is one, the information is only stored in the file path 21 and thus is not shared. When the number of acquired records is two or more, it is shared by a plurality of file paths.

  If the file is shared by this determination, the entity file registration unit 47 registers the updated entity file in the folder / file entity storage device 3 (step S12). At the same time, the new record adding means 44 newly registers a file management record 15 having copy source file information on the file management table 7 (step S13).

  On the file management table 7, the file ID 11 stores the copy source file ID (the file ID 22 checked in step S11) as it is, and the file version 12 is the folder / file related record 26 of the same file ID 22 at that time. The maximum value + 1 of the file version 23 is stored. For example, if the maximum value of the file version 23 at that time is “0002”, “0003” is stored. This is to avoid having the same file ID 11 and file version 12 due to file copying.

  The entity file path 13 stores the absolute path of the file in which the updated file is stored. The last update date 14 stores the time when the file was updated.

  If the updated file is not shared, the record update unit 45 sets the last update date and time 14 to the file update date and time for the file management record 15 whose actual file path 13 matches the update file on the file management table 7. (Step S14).

  Finally, regardless of whether the file is shared or not, the table update means 46 updates the folder-file relation table 8. In this process, the file last update date 24 of the folder / file related record 26 in which the absolute path of the updated file matches the file path 21 is set as the update date of the update file. Further, the link file last update date / time 25 of the folder / file related record 26 having the same file ID 22 of the updated file is overwritten with the update date / time of the updated file (step S15).

  As a result, the link file last update date and time 25 is updated with respect to a file that is related to the updated file, that is, a file with a different file version 23.

  FIG. 7 is a flowchart showing a procedure for notifying file update in the present invention.

  The file information acquisition unit 48 acquires the folder / file related record 26 of the update file on the folder / file related table 8 (step S21).

  When the file is shared and updated in the acquired folder / file related record 26, the link file last update date / time 25 is set with the date / time information that is newer than the file last update date / time 24. This is due to step S15 in the flowchart at the time of file update in FIG.

  This determination is performed by the update determination means 49 in step S22, and when the link file last update date and time 25 is newer than the file last update date and time 24, the display means 50 of the screen display processing unit 33 can visually grasp the user side. An update notification is made by changing the icon displayed on the screen display unit 4 (step S23).

  Thus, the file sharing management system 1 of the present invention can provide a file sharing management system in which one file can be shared among a plurality of folders without actual copying by the above-described copying (sharing) processing.

  Also, a file sharing management system that can manage generations (versions) while maintaining file relevance even when files are updated by the above-described file update processing can be provided.

  Furthermore, the user can grasp the update by notifying the update to the file having the relation with the updated file by notifying the file update described above.

It is a block diagram which shows schematically the document management system by this invention. (A) It is a structure figure of the file management table managed by the file information management database of the document management system by this invention. (B) It is a structure figure of the folder file related table managed by the file information management database of the document management system by this invention. It is a detailed explanatory view of an information processing apparatus of the document management system according to the present invention. It is a flowchart which shows the procedure of the file copy process of the document management system by this invention. (A) It is explanatory drawing which shows the example of a data set with respect to the file management record in the file information management database of the document management system by this invention. (B) It is explanatory drawing which shows the example of a data set with respect to the folder file related record in the file information management database of the document management system by this invention. It is a flowchart which shows the procedure of the process at the time of the file update of the document management system by this invention. It is a flowchart which shows the procedure for notifying file update of the document management system by this invention.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 File sharing management system 2 File information management database 3 Folder / file substance storage device 4 Screen display part 5 Input part 6 Information processing apparatus 7 File management table 8 Folder / file relation table 8
11, 22 File ID
12, 23 File version 13 Entity file path 14 Last update date / time 15 File management record 21 File path 24 File last update date / time 25 Link file last update date / time 26 Folder / file related record 31 Database processing unit 32 Entity data processing unit 33 Screen display processing Unit 41 Copy source file information acquisition means 42 Copy destination file information registration means 43 File sharing determination means 44 New record addition means 45 Record update means 46 Table update means 47 Substantive file registration means 48 File information acquisition means 49 Update determination means 50 Display means

Claims (3)

File information management database for storing file information and folder / file related information, a folder / file entity storage device for storing actual folders and files, a screen display unit, and an input unit communicate with the information processing device A freely connected file sharing management system,
The file information management database includes a file management table for managing a file management record indicating file information including a file ID, a file version, an entity file path, and a last update date and time,
Stores a folder / file related table for managing a folder / file related record indicating a folder / file related information including a file path, a file ID, a file version, a file last updated date / time, and a link file last updated date / time. ,
The information processing apparatus processes a database processing unit for processing the file management record and a folder / file related record, an entity data processing unit for processing the entity folder and file, and display information sent to the screen display unit. A screen display processing unit,
The database processing unit acquires data indicating a file ID, a file version, and a last update date and time from a file management record of a copy source file of the file management table based on a copy request from the input unit; and Copy source file information acquisition means for acquiring data indicating the last update date / time of the link file from the folder / file related record of the copy source file in the folder / file related table;
A new record is created in the folder / file relation table, the absolute path of the copy destination file is set in the new record, and the data acquired by the copy source file information acquisition means is set and registered. A file sharing management system comprising an information registration means. The database processing unit further obtains a record that matches the file ID and file version of the file from the folder / file association table when the file is updated. File sharing determination means for determining that the file is not shared when the record is shared and the record is singular;
When it is determined that the file is shared, a new record obtained by copying the file management record of the copy source file is added to the file management table, the file version value of the new record is changed, and the updated file is updated. New record adding means to set the absolute path and last update date and time,
A record update means for overwriting the last update date and time for a record whose path matches the update file on the file management table when it is determined that the file is not shared;
In the folder / file relation table, the file last update date / time of the record in which the absolute path of the updated file matches the file path is updated, and the link file last update date / time of the record in which the file ID of the updated file matches is updated. Table updating means for updating,
The entity data processing unit includes entity file registration means for registering an updated entity file in a folder / file entity storage device when the file sharing determining means determines that the file is shared. The file sharing management system according to claim 1. The database processing unit further includes file information acquisition means for acquiring a record of the update file on the folder / file relation table;
Update determination means for determining that the file is shared and updated when the link file last update date and time of the acquired record is date and time information that is newer than the file last update date and time,
The screen display processing unit includes display means for displaying and notifying on the screen display section when it is determined by the update determining means that the file is shared and updated. The file sharing management system according to claim 2.

Images