Be used for computer system and method that company information is integrated
Technical field
The present invention relates to be applicable to digital calculating equipment or the data processing equipment or the data processing method of specific function, specifically be meant to be used for computer system and the method that company information is integrated.
Background technology
Fast development along with modern society, the continuous expansion of scope of the enterprise, in the day-to-day operation process of enterprise, will produce a large amount of information, various notices as the issue of higher level department at some of the staff or personnel, the various publications that intra-company publishes, between the employee or between the superior and the subordinate at the record of the discussion that particular problem carried out, company personnel's address list, data that exchange mutually between all departments and transmit or the like, numerous numerous and diverse data like this, usually accept or reject respectively separately by all departments and file processing, therefore, inquire about and obtain these data is extremely to be difficult for.
This be because: data are managed respectively by all departments respectively, need accept or reject by this department, and lot of data exists with the form of paper spare, thereby may there be disappearance in data; There is certain distance in all departments on the geographic position, even may be or not same city, thereby delaying on the transmission life period of data; Data are quite scattered, and inquiry has certain degree of difficulty, causes the data sharing degree quite low, and therefore many important and useful data can not get sufficient utilization.
In addition, exist a large amount of existing ERP system, mailing system, production line automatic control system, supervisory system or the like in the enterprise, these systems all are independently, and the contact between not having laterally is unfavorable for that very the supvr utilizes the data in each system to make a strategic decision.
At present, existing numerous enterprise adopts LAN (Local Area Network) and Internets to carry out data transfer, has solved delaying of data transfer time that geographic distance causes to a certain extent, but still can not solve data scattered and not manageability and the problem obtained.
Thereby, be necessary to develop and a kind ofly various data, each existed system of enterprise can be optimized integration, make various data be convenient to the computer system of managing and being convenient to obtain.
Summary of the invention
The invention provides a kind of computer system and method that company information is integrated that be used for, its fundamental purpose be to change the various DATA DISTRIBUTION that produce in the present enterprise day-to-day operation scattered, be difficult to unified management, situation that the data sharing degree is low, and with various data, each existed system be optimized integration, make various data be convenient to manage and the platform being convenient to obtain and solve various available datas, how information enters this platform.
The present invention adopts following technical scheme: be used for the computer system that company information is integrated, comprise database server, WEB application server and numerous user terminals, database server, WEB application server and numerous user terminal agreements Network Based are connected to each other, wherein:
Database server comprises the plurality of data library module, and storage is used to discern user's identifying information and the data through integrating respectively;
User terminal allows by browser input identifying information, and the WEB application server is verified this identifying information, if identifying information is correct, and the particular data request that the further permission of user terminal is associated with this customer identification information by the browser input;
The WEB application server comprises the plurality of data processing module, receives and respond the particular data request of user terminal, calls particular data from database server, and carry out accordingly and operate, execution result is shown in the browser of user terminal, if desired, then deposits database server in.
The user terminal of aforementioned computer system comprises based on the user terminal of LAN (Local Area Network) with based on the user terminal of Internet.
The database module of aforementioned computer system comprises subscriber information module, be used to store customer identification information, authorized user message and user account information, described data processing module comprises user management module, the customer identification information of user management module checking user terminal input, and execution is to inquiry, increase, modification and the deletion action of the customer identification information in the subscriber information module, authorized user message and user account information.
Aforementioned computer system comprises that also agreement Network Based connects the DB2 data base set J2EE application server of unifying, and described WEB application server calls data in the DB2 Database Systems by the J2EE application server.
The DB2 Database Systems of aforementioned computer system are connected to an ERP system.
Aforementioned computer system comprises that also agreement Network Based connects the Domino data base set J2EE application server of unifying, and described WEB application server calls data in the Domino Database Systems by the J2EE application server.
The Domino Database Systems of aforementioned computer system are connected to a mail server.
Aforementioned computer system also comprises sql server, J2EE application server, and described WEB application server calls data in the sql database server by the J2EE application server.
The sql server of aforementioned computer system is connected to one and controls production line automatically, and controls the automatic control data of production line collection automatically from this.
The WEB application server of aforementioned computer system is connected to a supervisory system, gathers video data from supervisory system, is shown in the browser of user terminal.
Method with computer system application is integrated in company information may further comprise the steps:
1) is used for discerning user's identifying information and data storage in a database server through integrating;
2) import customer identification information by the browser of user terminal, by a WEB application server customer identification information of user terminal browser input is verified, if by checking, then allow the browser of user terminal further to import the particular data request that is associated with this customer identification information;
3) further import particular data request by the browser of user terminal, receive and respond this particular data request by the WEB application server, call particular data from database server, and carry out accordingly and operate, execution result is shown in the browser of user terminal, if desired, then deposit database server in.
By above-mentioned description to technical solution of the present invention as can be known, compare with prior art, the present invention has following advantage: data can be safely, intactly preserve; The transmission of data and acquisition can not produce because of the distance on the space and postpone and mistake, and the user can carry out data transfer whenever and wherever possible as required and obtain; All departments or each employee press the authority access data of oneself, the shared safety more of data and convenient; On identical platform, can call the data in each existed system.
Description of drawings
Fig. 1 is an architectural schematic of the present invention;
Fig. 2 is data flow figure of the present invention;
Fig. 3 is logical architecture figure of the present invention;
Fig. 4 is a user terminal browser homepage of the present invention;
Fig. 5 is a news browser interface of the present invention;
Fig. 6 is the present invention's checking frame of giving a news briefing;
Fig. 7 is the present invention interface of giving a news briefing.
Embodiment
The specific embodiment of the present invention, referring to figs. 1 through Fig. 3, be used for the computer system that company information is integrated, comprise database server 1, WEB application server 2 and numerous user terminals 4, database server 1, WEB application server 2 and numerous user terminal 4 agreements Network Based are connected to each other, database server 1 comprises the plurality of data library module, and storage is used to discern user's identifying information and the data through integrating respectively; User terminal 4 allows by browser input identifying information, and 2 pairs of these identifying informations of WEB application server verify, if identifying information is correct, user terminal 4 further allows the particular data request that is associated with this customer identification information by the browser input; WEB application server 2 comprises the plurality of data processing module, receives and respond the particular data request of user terminal 4, calls particular data from database server 1, and carry out accordingly and operate, execution result is shown in the browser of user terminal 4, if desired, then deposits database server 1 in.Wherein user terminal 4 comprises based on the user terminal of LAN (Local Area Network) with based on the user terminal of Internet 3.
WEB application server 2 is connected to a J2EE server 9, J2EE server 9 is connected to DB2 Database Systems 5, Domino Database Systems 6 and sql server 7, and therefrom call data, use for WEB application server 2, with the request of data of response user terminal 4 browsers.DB2 Database Systems 5 are connected with the ERP system 51 of enterprise, carry out the ERP exchanges data, and Domino Database Systems 6 are connected with mail server 61, call mail data, and sql server 7 is connected with automatic control production line 71, gathers the data of automatic control process.WEB application server 2 is also connected to the supervisory system 8 of enterprise, gathers video data, shows according to the request of user terminal 8.
Aforementioned DB2 Database Systems 5, Domino Database Systems 6, sql server 7 are not limited to aforesaid application, and can be connected to the enterprises that meets its data format standard program, thereby more existing system can be incorporated into this computer system.
Database module in the database server 1 comprises subscriber information module, be used to store customer identification information, authorized user message and user account information, data processing module comprises user management module, the customer identification information of user management module checking user terminal input, and execution is to inquiry, increase, modification and the deletion action of the customer identification information in the subscriber information module, authorized user message and user account information.
Database module in the database server 1 also comprises the news module, is used to store enterprise's news, and data processing module also comprises the news processing module, and the news processing module is carried out inquiry, increase, modification and deletion action to the enterprise's news in the news module.
Database module in the database server 1 also comprises notification module, be used to store the enterprises notice, data processing module also comprises notification handler module, and notification handler module is carried out inquiry, increase, modification and deletion action to the notice of the enterprises in the notification module.
Database module in the database server 1 also comprises the electronic publication module, be used to store the enterprises publication, data processing module also comprises the electronic publication processing module, and the electronic publication processing module is carried out inquiry, increase, modification and deletion action to the enterprises publication in the electronic publication module.
Database module in the database server 1 also comprises the address list module, be used to store all departments of enterprise, personnel's contact details, data processing module also comprises the address list processing module, and the address list processing module is carried out inquiry, increase, modification and deletion action to the contact details in the address list module.
Database module in the database server 1 also comprises library module, be used to store the data of transmitting mutually in the enterprise, data processing module also comprises the database processes module, and the database processes module is carried out inquiry, increase, modification and deletion action to the data in the library module.
Database module in the database server 1 also comprises Web-based instruction data module, be used to store the enterprises learning materials, data processing module also comprises Web-based instruction data processing module, and Web-based instruction data processing module is carried out inquiry, increase, modification and deletion action to the data in the network resources material module.
Database module in the database server 1 also comprises forum's data module, be used to store the interchange between the enterprises employee, data processing module also comprises forum's data processing module, and forum's data processing module is carried out inquiry, increase, modification and deletion action to the data in forum's data module.
The logical architecture of this system comprises three-decker, as shown in Figure 3, be client layer 10, application layer 20 and database layer 30, client layer 10 is presented as that the user carries out various operations on the browser of user terminal 4, import various request of data, application layer 20 is presented as the execution of the 2 couples of users of WEB application server operation, and the calling of 9 pairs of various Database Systems data of J2EE application server, and database layer 30 is presented as that Database Systems carry out classified and stored to various data.
Below with reference to Fig. 4 to Fig. 7, illustrate how the user inquires about in 4 pairs of enterprise's news of user terminal in the native system, increase, modification and deletion action.Fig. 4 is the homepage of native system browser, clicks " Xiahua's news " in the navigation bar on this page top, carries out the page of enterprise's news, Fig. 5 has shown enterprise's news pages, the right at this interface has shown the title of various thematic news, clicks this each title, can show relevant news.Under Xiahua's news retrieval in the upper left corner, import key word, click " retrieval " button, then can show the news that comprises this key word.If release news, then need to login, selection will be issued below Xiahua's news briefing in the homepage lower left corner Special Topics in Journalism and affiliated function, and input password, Fig. 6 is the enlarged drawing of user rs authentication frame, click issue, the news briefing interface then appears, as shown in Figure 7, news briefing provides powerful information editing's function with the form of WEB editing machine, and the setting of paragraph format, font size, color is supported in the operation of the similar Word file of interface operation, can insert form, picture file is connected with super, content typing click " interpolation " button that finishes gets final product.
Also comprise " notice ", " electronic publication ", " Xiahua forum ", " address list ", " data bank " in the navigation bar of homepage, all provide to relevant information inquire about, increase, modification and deletion action.
The right of homepage also comprises provides the full-text search inlet, and input needs the key word of retrieval below full-text search, selects range of search, and click is searched, and can retrieve the article that comprises this key word in range of search.
With reference to Fig. 4, in native system browser homepage, also include the inlet of each system, be used for the dynamic data of existing each system of inquiring enterprise.The Xiahua's distribution system, Xiahua's ERP system, the display ERP system that comprise the left side, and the fax searching system on right side, leader's inquiry system, quality control system, customer support and service management system, integrated service inquiry system, these inlets allow the data in aforementioned each system of user inquiring, promptly allow the user to pass through the various Database Systems of J2EE application server access.