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 PDF

Info

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
Application number
CN201210331706.7A
Other languages
Chinese (zh)
Other versions
CN102867247A (en
Inventor
景奕昕
韩敏
余鹏飞
唐威
廖巍
叶香莲
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
WUHAN KINESISK LABORERS ANDING INFORMATION TECHNOLOGY Co Ltd
Original Assignee
WUHAN KINESISK LABORERS ANDING INFORMATION TECHNOLOGY Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by WUHAN KINESISK LABORERS ANDING INFORMATION TECHNOLOGY Co Ltd filed Critical WUHAN KINESISK LABORERS ANDING INFORMATION TECHNOLOGY Co Ltd
Priority to CN201210331706.7A priority Critical patent/CN102867247B/en
Publication of CN102867247A publication Critical patent/CN102867247A/en
Application granted granted Critical
Publication of CN102867247B publication Critical patent/CN102867247B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

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

The office automation system of rapid deployment file security outgoing and method
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.
CN201210331706.7A 2012-09-10 2012-09-10 The office automation system of rapid deployment file security outgoing and method Active CN102867247B (en)

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)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101072163A (en) * 2007-03-31 2007-11-14 腾讯科技(深圳)有限公司 Network file automatic dump method and system

Patent Citations (1)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
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