Liaohe Oilfield Union Online Collaborative Office System Design And Implementation

Enter the twenty-first Century, with the rapid development of informationtechnology, more and more enterprises have to carry out a variety of business on theInternet, the Internet has become the human society is an indispensable part of life.Based on the Web application service has gradually become the mainstream of Internetservice. Whether in China or in other countries, the development of Web applicationpersonnel, Web application scope is broad, other industry cannot compete. Fromtraditional industries to the emerging e-commerce, the application based on Webtechnology is a rapid rate of change in the traditional service mode, Web has become animportant platform for the exchange of social information.Workflow management is a groupware technology, as the collaborative officesystem implementation provides a strong technical support and security. Construction ofcooperative OA system, its goal is to use Web service architecture based on WorkflowTechnology in application, operation and data management for clues, combined withdaily office application, support staff’s comprehensive group collaboration and real-timecommunication, final implementation include business management, process approvaldocument flow, exchange of technology, such as daily work series of businessintelligent office system.Query optimization strategy is affecting the database application systemperformance and life cycle is one of the main factors, online collaborative office on thedatabase query operation efficiency is raised very tall requirement, focusing onthroughout the life cycle of the system, not only in the development of comprehensivequery optimization design, to meet the existing demand, must solve as user data is input,the database size grows, the query response time and system performance impact.Based on the JAVA and database theory, combined with the application of" LiaoheOilfield union online collaborative office system", to explore the Internet collaborativework methods and realize the query optimization technology in the system application.In a detailed analysis of online collaborative office and database query efficiency and other aspects on the basis of demand, based on the Web workflow managementtechnology and the database query optimization technology research, proposed the Webworkflow design, SQL rules of optimization solutions in Liaohe oil field, and union ofcooperative OA system development process from first to last to be able to carry out,solved some practical problems, for the application system to achieve higherperformance provides a strong guarantee.