CN102867247B - The office automation system of rapid deployment file security outgoing and method - Google Patents
The office automation system of rapid deployment file security outgoing and method Download PDFInfo
- Publication number
- CN102867247B CN102867247B CN201210331706.7A CN201210331706A CN102867247B CN 102867247 B CN102867247 B CN 102867247B CN 201210331706 A CN201210331706 A CN 201210331706A CN 102867247 B CN102867247 B CN 102867247B
- Authority
- CN
- China
- Prior art keywords
- server
- file
- outgoing
- database
- rapid deployment
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Storage Device Security (AREA)
Abstract
The invention discloses a kind of office automation system and method for rapid deployment file security outgoing, this system comprises Web server, file server and the database server and first server and second server that connect successively; Described first server is connected with this Web server and file server respectively, and described first server is also connected with second server.The method of described rapid deployment file security outgoing comprises the newly-built trigger of INSERT order for database, the new executive routine that one realizes file unloading function is stored in file server, be modified in the Download Script on Web server, the content to be downloaded in first server is made first to send to second server before downloading, be safe outgoing form via this file of second server process, then send to user.This invention simplifies traditional scheme, simple and effectively achieve in the improvement functionally of file outgoing, for enterprise has saved cost.
Description
Technical field
The present invention relates to a kind of office automation system and method, particularly Policies of Office Automation In Enterprises and information security field of rapid deployment file security outgoing.
Background technology
Office automation (OfficeAutomation, be called for short OA) system is that enterprise utilizes computer network to realize the information processing platform of virtual collaborative work, and by this office platform, enterprise can realize that office is with no paper, information sharing and the scientification of decision-making.OA system help all departments can carry out comprehensively perfect coordinated management to office work, also save clerical cost, by popularization and application in enterprise while increasing work efficiency.Wherein, be widely used in enterprise by the OA system that Web server, file server and database server are integrated.The OA system of this framework accepts client-access by Web server, is stored in file server by all file contents uploaded, and the attribute of file and address is stored in database server.
Along with deepening constantly of enterprise's internal reform and development, problem faced by enterprise work is day by day complicated, OA system as Company Knowledge information storage center and management support platform, while network information technology develop rapidly, enterprise to its performance requirement also raising.Especially in the information security issue day by day highlighted, downloaded by undelegated personnel as stored file on the server, the sensitive content of file the event such as illegally to be read and is taken place frequently, and compromises the data security of enterprise greatly.Nowadays, a large amount of enterprise needs to carry out safe handling when file download to file, retrains the file of download by unordered transmission with the form of safe outgoing.Traditional scheme is that the existing OA service end source code of amendment recompilates, and with in file download service end integrated file outgoing module, but there is the drawbacks such as technical sophistication degree is high, the construction cycle is long.On the other hand, the speed of development of enterprise and network technique is more and more faster, and the time that enterprise upgrades OA system also progressively shortens, and enterprise wishes that conveniently scheme is to upgrade the OA system of oneself, to improve necessary function as improved security etc.The source code of amendment OA system, no doubt can improve OA system, but by software copyright protection, the improvement of this mode must have the participation of OA system developer, limits the improvement of OA system to a certain extent.
Summary of the invention
In view of this, the technical problem to be solved in the present invention is the office automation system and the method that provide a kind of rapid deployment file security outgoing, the present invention adds first server and second server on the basis of original OA system, compared to traditional scheme, avoid the participation of OA system developer, also can realize OA system in the improvement functionally of file outgoing, technical difficulty is low, construction cycle is short, for enterprise has saved cost.
For solving the problems of the technologies described above, technical scheme of the present invention is achieved in that a kind of office automation system of rapid deployment file security outgoing, comprise the Web server, file server and the database server that connect successively, it is the second server of safe outgoing form that the described office automation system also comprises for the first server of unloading file and process file; Described first server is connected with described Web server and file server respectively, is also connected with described second server simultaneously.
Another kind of technical scheme provided by the invention: a kind of method of rapid deployment file security outgoing, said method comprising the steps of:
A. being the newly-built trigger of INSERT order of described database server, in described file server, storing one for realizing the new execution of unloading upload file function;
B. user sends upload file request to Web server;
C.Web server acknowledge by files passe in file server; Send corresponding SQL statement to database server, database server is by this statement write into Databasce, and this process is caught by the oracle listener of database, activates as the newly-built trigger of INSERT order simultaneously;
D. perform and call the new execution be stored on file server;
E. this execution makes file server that the content of upload file is sent to first server, this file content afterwards on deleted file server, and the file content unloading realizing uploading is to first server;
F. the Download Script on described Web server is revised;
G. user sends download file request to Web server;
H.Web server performs described Download Script, and the file content deposited thereon is sent to second server by request first server;
I. second server receives this file and returns to first server after being treated to safe outgoing form;
J. the file of outgoing form is sent to user by Web server by first server.
Preferably, for the newly-built trigger of DELETE and UPDATE order of described database server, the corresponding new execution for realizing file erase and modify feature is stored in described file server, after described newly-built trigger is activated, the execution that data base call correspondence is deleted and revised, the file be stored in described first server is operated, realizes deletion and the amendment of file.
Preferably, described download file can set username and password.
Preferably, described download file can limit and open frequency of reading, exceedes file self-destruction described in number of times.
The technique effect that the present invention reaches is as follows: the office automation system and the method for rapid deployment file security outgoing of the present invention greatly simplify traditional technical scheme, there is the advantage of low technical complexity and short construction cycle, greatly reduce manpower and time cost that enterprise improves OA system.
Accompanying drawing explanation
Fig. 1 is the topological diagram of the office automation system of rapid deployment file security outgoing of the present invention;
Fig. 2 is the office automation system upload procedure schematic diagram of rapid deployment file security outgoing of the present invention;
Fig. 3 is the office automation system downloading process schematic diagram of rapid deployment file security outgoing of the present invention.
Embodiment
Be illustrated in figure 1 the topological diagram of the office automation system of rapid deployment file security outgoing of the present invention, this office automation system comprises Web server 1, file server 2, database server 3, first server 4 and second server 5; Web server 1, file server 2, database server 3 connect successively, and first server 4 is connected with Web server 1 and file server 2 respectively, and are connected with second server 5.The upload file that first server 4 unloading is new, it is outgoing form that second server 5 processes file to be downloaded.
At INSERT order increase trigger of the lane database of database server 3, when trigger is activated, database can perform the new executive routine calling and be stored in file server 2 li, realizes newly uploading of file; And revise the Download Script of Web server 1, realize Web server 1 and ask when receiving download request first server 4 that file to be downloaded is sent to second server 5.
Be illustrated in figure 2 the office automation system upload procedure schematic diagram of rapid deployment file security outgoing of the present invention.At the newly-built trigger of INSERT order of the lane database of database server 3, the executive routine that storage one is new in file server 2; When user 6 to send out to Web server 1 go out upload file request after, Web server 1 is replied and by files passe in file server 2, send corresponding SQL statement to database server 3 simultaneously, database server 3 is by this statement write into Databasce, this process is caught by the oracle listener of database, activates described trigger; Database performs and calls the described new executive routine being stored in file server 2; This new executive routine makes file server 2 that the content of upload file is sent to first server 4, first server 4 unloading file content, file content simultaneously on deleted file server 2, realizes files passe and the memory function of the office automation system of rapid deployment file security outgoing.
Be illustrated in figure 3 the office automation system downloading process schematic diagram of rapid deployment file security outgoing of the present invention.First the Download Script on OA system web server 1 is revised; After user 6 sends the request of download file to Web server 1, Web server 1 performs described amended Download Script, and the file content deposited thereon is sent to second server 5 by request first server 4; Second server 5 receives this file and returns to first server 4 after this file is treated to safe outgoing form; The file of outgoing form is sent to user 6 by Web server 1 by first server 4.When user 6 opens the safe outgoing document of download, after the username and password that input is correct, show the plaintext with watermark, and limit the number of times opening reading, exceed number of times then file self-destruction.
In the office automation system of rapid deployment file security outgoing of the present invention, the file newly uploaded will only be stored in newly-increased first server 4, and all first server 4 file that will download will be carried out safe outgoing process by second server 5 before downloading and sent to user 6 again.
Similar, also can as above operate about the amendment of file, deletion action, by the newly-built trigger of DELETE and UPDATE order for lane database, the corresponding new execution for realizing file erase and modify feature is stored in file server 2, after described newly-built trigger is activated, the execution that data base call correspondence is deleted and revised, the file be stored in described first server 4 is operated, realize deletion and the amendment of file, thus realize the improvement of former function and the increase of New function.Download Script on amendment Web server 1, makes the safe outgoing process that file to be downloaded is different on second server 5, also can reach the security intensity of different stage flexibly.
The above, be only preferred embodiment of the present invention, be not intended to limit protection scope of the present invention.
Claims (4)
1. the method for a rapid deployment file security outgoing, it is applied to a kind of office automation system of rapid deployment file security outgoing, this office automation system comprises Web server, file server, database server, first server and second server; This Web server, file server, database server connect successively, and this first server is connected with Web server and file server respectively, and is connected with second server; The upload file that this first server unloading is new, this second server process file to be downloaded is outgoing form; It is characterized in that, said method comprising the steps of:
For the newly-built trigger of INSERT order of described database server, in described file server, store one for realizing the new execution of unloading upload file function;
User sends upload file request to Web server;
Web server response and by files passe in file server; Send corresponding SQL statement to database server, database server is by this statement write into Databasce, and this process is caught by the oracle listener of database, activates as the newly-built trigger of INSERT order simultaneously;
Perform and call the new execution be stored on file server;
This execution makes file server that the content of upload file is sent to first server, this file content afterwards on deleted file server, and the file content unloading realizing uploading is to first server;
Revise the Download Script on described Web server;
User sends download file request to Web server;
Web server performs described Download Script, and the file content deposited thereon is sent to second server by request first server;
Second server receives this file and returns to first server after being treated to safe outgoing form;
The file of outgoing form is sent to user by Web server by first server.
2. the method for rapid deployment file security outgoing according to claim 1, it is characterized in that, for the newly-built trigger of DELETE and UPDATE order of described database server, the corresponding new execution for realizing file erase and modify feature is stored in described file server, after described newly-built trigger is activated, the execution that data base call correspondence is deleted and revised, the file be stored in described first server is operated, realizes deletion and the amendment of file.
3. the method for rapid deployment file security outgoing according to claim 1, it is characterized in that, described download file can set username and password.
4. the method for rapid deployment file security outgoing according to claim 1, it is characterized in that, described download file can limit and open frequency of reading, exceedes file self-destruction described in number of times.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210331706.7A CN102867247B (en) | 2012-09-10 | 2012-09-10 | The office automation system of rapid deployment file security outgoing and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210331706.7A CN102867247B (en) | 2012-09-10 | 2012-09-10 | The office automation system of rapid deployment file security outgoing and method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102867247A CN102867247A (en) | 2013-01-09 |
| CN102867247B true CN102867247B (en) | 2015-12-09 |
Family
ID=47446108
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210331706.7A Active CN102867247B (en) | 2012-09-10 | 2012-09-10 | The office automation system of rapid deployment file security outgoing and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102867247B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106600216A (en) * | 2016-11-30 | 2017-04-26 | 包卫华 | Office automation system and method |
| CN108958751B (en) * | 2018-06-01 | 2020-09-04 | 优刻得科技股份有限公司 | Method, device, system and storage medium for software deployment or maintenance |
| CN110874260B (en) * | 2018-09-04 | 2023-03-10 | 北京奇虎科技有限公司 | File processing method and device based on multi-user machine |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101072163A (en) * | 2007-03-31 | 2007-11-14 | 腾讯科技（深圳）有限公司 | Network file automatic dump method and system |
-
2012
- 2012-09-10 CN CN201210331706.7A patent/CN102867247B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101072163A (en) * | 2007-03-31 | 2007-11-14 | 腾讯科技（深圳）有限公司 | Network file automatic dump method and system |
Non-Patent Citations (1)
| Title |
|---|
| 《基于B/S的电子政务系统及其安全性研究》;张峰;《中国优秀硕士论文电子期刊网》;20050930;正文第I138－153页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102867247A (en) | 2013-01-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105677250B (en) | The update method and updating device of object data in object storage system | |
| EP2820539B1 (en) | Distribution of application files | |
| CN109685511B (en) | Block chain-based data use right transaction method | |
| US9047228B2 (en) | Systems and methods for data privacy and destruction | |
| CN104021145B (en) | The method and apparatus that a kind of mixed service concurrently accesses | |
| US20070168350A1 (en) | Management of non-traditional content repositories | |
| US9245256B2 (en) | Assigning and managing reviews of a computing file | |
| CN103988199A (en) | Removal of data remanence in deduplicated storage clouds | |
| CN103959264A (en) | Managing redundant immutable files using deduplication in storage clouds | |
| CN102629247A (en) | Method, device and system for data processing | |
| CN109597640B (en) | Account management method, device, equipment and medium for application program | |
| CN104239041B (en) | A kind of method and apparatus generating processing scheme and configuration | |
| CN110659259B (en) | Database migration method, server and computer storage medium | |
| US20070174289A1 (en) | Management of non-traditional content repositories | |
| CN105183384B (en) | It is a kind of directly to entangle the implementation method deleted and device | |
| CN107656729A (en) | Updating device, method and the computer-readable recording medium of List View | |
| CN107918621A (en) | Daily record data processing method, device and operation system | |
| CN109739828B (en) | Data processing method and device and computer readable storage medium | |
| CN102393889A (en) | Permissions configuration management system | |
| CN102693388A (en) | Data safety protection processing system, method and storage medium | |
| CN102867247B (en) | The office automation system of rapid deployment file security outgoing and method | |
| CN106357791A (en) | Method, device and system for processing services | |
| CN104461826A (en) | Object flow monitoring method, device and system | |
| CN106021566A (en) | Method, device and system for improving concurrent processing capacity of single database | |
| CN104537012B (en) | Data processing method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |