CN110580148A - Integration-oriented EPC project management platform - Google Patents

Abstract

The invention relates to the technical field of hydropower and hydraulic engineering management, in particular to an integrated EPC project management platform, which is logically divided into a display layer, an application layer and a data layer from the technical realization, an EOS platform is used as a development tool, an Oracle database is used for storing and managing data, and software can run on Weblogic middleware on a Linux or Windows operating system; the invention is used as an integrated EPC management platform, fully utilizes the characteristics of the BIM such as intuition, analyzability, sharability and manageability, provides accurate and timely basic data and technical analysis means for each business of project management, combines a professional BIM design model with engineering construction, runs through the digital management of the whole life cycle of the project, improves the effect of the project management, can display massive geographic information data and dense BIM data on a common hardware carrier on the basis of a digital earth, can summarize design data and project management data, and realizes the capacity of 'auxiliary planning and design'.

Description

Integration-oriented EPC project management platform

Technical Field

The invention relates to the technical field of hydropower and hydraulic engineering management, in particular to an integrated EPC project management platform.

Background

Engineering construction is a typical capital concentration process with high investment and high risk elements, a building project with poor quality not only causes the increase of investment cost, but also seriously affects operation and production, the delay of construction period also causes huge loss, and the BIM technology can improve the delay of delivery of each project and the increase of investment cost caused by incomplete construction documents, design changes or inaccurate design drawings. The cooperative function of the system can support workers to see the result of each step in the design process, and check whether the building saves resources through calculation or not, or consider how much influence is generated on resource saving by utilizing an information technology. The method not only enables an engineering construction team to experience the engineering in advance before the physical construction is completed, but also generates an intelligent database and provides support throughout the whole life cycle of the building. The method can make each stage more transparent and accurate in budget, and can be used as an important tool for preventing corruption, particularly applied to government engineering.

However, BIM is now encountering the bottleneck of development, and not all enterprises can identify the economic benefit and social benefit brought by BIM, and the main problem is the lack of BIM standard. No software in China or abroad can meet the design and construction integration, and each system plays a role in different periods, so that BIM software application forms an information island in each stage. Although information can be shared, stored, and exchanged within each "information island", information faults are easily formed between the "islands" and a phenomenon of information asymmetry occurs. Especially, the problem of information isolated island and splitting among various organizations such as project stages, professions, general packages and sub-packages is more common. Such problems and phenomena often result in inefficiencies, deviations, or even mistakes in management and decision making.

At present, the national standard of the BIM technology is not officially promulgated and implemented, and a standardization system with strong applicability is urgently sought, so that an integrated EPC project management platform based on modern information technologies such as BIM and the like is urgently needed to be developed, and the cooperation management of the EPC project construction in the whole stage is mainly realized.

disclosure of Invention

In order to achieve the above object, the invention provides an integrated EPC project management platform, which is based on a B/S architecture, can be applied to various management modes of domestic and foreign EPC projects, and can realize the full-life-cycle management of the EPC projects through the flexible configuration of the platform no matter the EPC projects designed as a faucet, the EPC projects constructed as a faucet, or the project management modes of foreign engineering companies. The information completeness, information relation, information consistency, coordination, simulation and visualization of the BIM technology are fully utilized, business data such as progress, contract, cost, process and quality are associated on the basis of a design model, a comprehensive BIM model is formed, a support is provided for key elements such as progress management, site coordination and cost control of a project, a foundation is provided for data collaboration of all business phases (including project starting phase, project initial phase, project design, purchasing and construction phase, project trial operation, acceptance and ending phase) of the project management, the problems of data island, information asymmetry, unsmooth communication and the like caused by a traditional management mode are solved, collaboration of the whole process, the whole system and the whole elements of an EPC project is realized, and the efficiency of project management is improved. The specific technical scheme is as follows:

An integrated EPC project management platform is logically divided into a display layer, an application layer and a data layer from technical realization, an EOS platform is used as a development tool, an Oracle database is used for storing and managing data, and software which can run on Weblogic middleware on a Linux or Windows operating system:

The display layer is a graphical interface for providing application services for the client, which is helpful for the user to understand and efficiently locate the application services, and the specific implementation result can be divided into three client forms: 1) WEB client, 2) Applet program embedded in Web page, 3) Graphical User Interface (GUI) established by Swing or Abstract Window Toolkit (AWT) API. At the client, only the IE browser is needed to work. That is, a user may work with a desktop computer and various handheld terminals, including wired and wireless terminals. The direct access mode of the IE browser supporting LAN/Intranet. And the IE browser supporting the Internet user accesses the HTTP server through the DMZ. And an IE browser access mode of VPN users or dial-up VPN user connection is supported.

the application layer provides the link between client applications and data services, and the main functions are to execute application policies and package application patterns, and present the packaged patterns to the client applications, which can be specifically classified into three types of enterprise-level component technologies: 1) sessionbeans, 2) entitybeans, 3) message-drivers beans. A sessionbean describes an ephemeral session with the client. When the execution of the client is completed, sessionbean and its data will disappear. In contrast, an entitybean describes a row of persistent, robust data stored in a table of a database. If the client terminates or the service ends, the underlying service may be responsible for storing the entitybean data. A message-driver bean combines the functions of a sessionbean and a Java information service (JMS) message listener, which allows a business component to asynchronously accept JMS messages.

The data layer comprises a database server for storing data and a Bean for processing and caching the data. In the JEE technology system, a database link pool technology is adopted to provide database links required by applications, and a large amount of used data is put into a cache of the system so as to provide an efficient data access and processing mechanism. In the J2EE technology architecture, JDBCAPI is provided that provides application developers with a unified API that is database independent. This API provides a standard of writing and a standard of considering all different application designs. Its secret is a set of Java interfaces implemented by drivers. The driver is responsible for the specific call transitions required by the standard JDBC call to the supported database.

Furthermore, the data layer is the bottom layer in the three-layer mode and is used for defining, maintaining, accessing and updating data and managing and meeting the requirements of application services on the data, the application layer uploads various professional BIM models to a unified integrated project management platform by means of an intelligent algorithm and BIM visual display, and the requirements for displaying, counting and managing project management elements are met by combining the professional unified application through the integrated system platform. The specific design scheme comprises the following steps: 1) designing a conceptual structure; 2) designing a logic structure; 3) designing a physical structure; 4) designing a data dictionary; 5) view, storage process, function, trigger design; 6) designing user authority; 7) and (4) designing security and secrecy so as to guide the development of business functions.

Furthermore, unified application combining all specialties is realized through an integrated system platform. The method comprises the steps of integrating electronic sand table application of a plurality of information such as professional progress, quality safety, data and the like, integrating field scheduling and virtual construction application of any time period of simulation of design, plan and actual construction data, comparing the plan with the progress according to WBS, quality safety sand table application based on a BIM model, data sand table, material tracking, drawing review and digital handover application combined with the BIM model and the like, wherein the specific function description is as follows:

1) Setting a foundation: the method is used for setting various basic data, and the basic setting is the basis of system application and provides support for various functional applications.

2) And (5) reviewing drawings: by marking problem points in the three-dimensional view, the process of reviewing drawings is completed more intuitively.

3) Field scheduling: the method is used for making working condition animations and provides auxiliary support for field scheduling according to simulation conditions.

4) Material tracking: the material is shown in the three-dimensional view, and the current stage and detailed information of the material can be inquired.

5) the process method comprises the following steps: the material is shown in the three-dimensional view, and the current stage and detailed information of the material can be inquired.

6) Technical background matching: and the intuitive technical bottom-crossing display is completed by displaying related components of the construction scheme in a three-dimensional manner and displaying the construction scheme by movable pictures.

7) Virtual construction: the method is used for simulating the engineering construction process and visually displaying the engineering construction attention information.

8) Progress sand table: the three-dimensional progress sand table is used for comparing and displaying the design and construction progress and the actual and planned progress in the three-dimensional progress sand table, and can be used for visually reporting the progress condition through the three-dimensional progress sand table.

9) a sand table for quality safety: the method is used for positioning and inquiring problem data of quality and safety in the three-dimensional quality safety sand table and processing the situation.

10) A material sand table: the method is used for positioning, inquiring and designing various data generated in the engineering construction process in the three-dimensional data sand table.

11) Electronic sand table: the method is used for positioning and comprehensively displaying and inquiring data information such as various specials, quality, safety, data and the like in the engineering construction process in the three-dimensional electronic sand table.

12) Digital handover: and (3) integrally displaying all information related to engineering construction by taking the three-dimensional system integrated with the BIM as a carrier to form a complete integrated digital system result and finish the digital transfer work.

Further, in the physical environment of the Oracle database, the Oracle RAC cluster component includes:

1) An Oracle cluster;

2) An Oracle kernel component;

3) A shared disk system: the Oracle kernel component in the Oracle RAC environment is an additional set of background processes in each instance. The buffer cache and shared pool become global in the Oracle RAC environment, and special processing is needed to manage resources without conflict and damage. Mainly comprising the following processes and services;

4) A global resource directory GRD;

5) The global caching service GCS and the global queuing service GES manage resources using the following processes:

The global cache service process LMS. The LMS is a process used in cache fusion and can transfer a consistent copy of a data block from the buffer of the instance where the data block is located to the buffer cache of the requesting instance without a disk write. It may also obtain a request from a server queue established by the LMD to perform the requested lock operation. The LMS process manages "lock management server" requests in response to GCS resources and sends them to the service queue and global lock deadlock detection handled by the LMS process and monitors the timeout status of the lock session.

A global queue service monitor LMON. LMON is a lock monitor process that manages GES.

The global queue service daemon LMD. The LMD is a daemon that manages GES requests for the GCS.

The instance queue process LCK 0. LCK0 manages instance resource requests and cross instance call operations to shared resources.

6) the diagnostic daemon DIAG. All diagnostic requirements for one instance in the RAC environment.

Further, the data relationship between the services in the data layer is described as follows: 1) the system takes main contract information as main data; 2) the basic information of the main contract is derived from the basic information of the project; 3) the business such as quality, technology, scientific research, health and fitness ring, mechanical equipment, materials, fund, progress and the like needs to determine the main contract to which the data belongs; 4) and summarizing and counting process data of each item related to the main contract to generate a report for exporting or printing.

Further, the general EPC project requires that a "production database" for project management be installed on a site server, according to the needs of database usage efficiency and convenience of maintenance management. Therefore, the data content is synchronized between the field production database and the engineering data center in the data layer in real time or regularly in a data interface mode; when the business data is subjected to adding, modifying and deleting operations, an interface or a plug-in of the data center is called to transmit the parameters to the data center, and the data center performs corresponding data synchronization operations. The components of the data interface include: 1) excel import and export modules, 2) Project import and export modules, 3) P3 and P6 import and export modules. Seamless integration with other software systems can be achieved very easily with these components.

Further, technology selection is a complex, systematic management practice activity that should follow principles of technology advancement and applicability, economy, and reliability. Therefore, on the basis of absorbing external experience and understanding the prior art, by clarifying market demands, describing technical concepts, selecting various necessary technologies, finally realizing the use value of the technologies, reasonably allocating resources, reducing development cost, and necessary technical supports for the implementation of the EPC project management platform include:

Basic environment

The establishment of hardware environment and software environment of construction engineering project is the material basis of information sharing, and the hardware facility includes: computer, server, switch, basic software includes: operating systems, databases, middleware, etc.

(1) Hardware and software environment

(2) Network deployment

The network is the basis of information communication, and the building site generally does not have mature network or computer lab, and operation maintenance is inconvenient, and for some remote areas or areas with underdeveloped networks, should encourage internet access positively, the department of project visits the intranet of enterprise through VPN access account number as required.

(3) User side environment

BIM technique

BIM is a datamation tool applied to engineering design and construction, which takes a single component in a construction engineering project as a basic element, integrates various information such as geometric data and physical characteristics describing the basic element to form a data base of the whole project, and the data keep a logical relationship with each other to form a digitalized building of a virtual space. The concept of BIM technology cooperation and integration is highly integrated with the idea of building integrated construction, particularly under the EPC project general contract management mode, the function and the advantage of building informatization application based on BIM are more prominent, the development condition of the BIM technology is combined, and information barriers of all links, all specialties and all participants of the hydropower project EPC general contract project are opened by means of information technologies such as BIM and the like. BIM information management under the EPC project general contract mode relates to information application of related specialties, related links and related services of a project, purchasing, cost, progress, contract, material, quality and safety of the whole process of building design, production and assembly can be achieved through the BIM technology-based EPC general contract project, and effective configuration of the whole process of project resources is finally achieved.

(III) visualization techniques

The visualization technology can enable the development of the work such as design, construction, real-time monitoring, later maintenance and the like to be more vivid and specific, the intuition of the operation is increased, and the visualization technology enables managers to effectively master information and realize transparent and visual management. The visual management is a breakthrough for driving various work innovations and upgrades of enterprises implementing project management. By means of modern information technology and project management concepts, clear interfaces are established aiming at success factors and problems of project management implementation, internal and external resources are effectively integrated, and strategic goals are achieved. Specifically, visualization management is performed by using a visualization technology, and the continuous success of the project is realized under the guidance of strategic targets by occupying sufficient information, reasonably distributing resources, comprehensively planning the project operation flow.

(1) And developing the overall plan of visual management. And (4) from the whole, all units find out the factors of mutual connection and mutual restriction and carry out overall planning on the integrated management and control mode. The overall planning of visual management, namely, the work is carried out on the aspects of strategic guidance, organizational structure support, unit culture construction, project operation, daily business operation, resource management, information processing and the like, so that the effective operation of visual project management is ensured.

(2) And carrying out safety production visual management. The method proposes that each unit uses each achievement of safety production management through a visual means, so that the information transmission of an executor is smooth, the instruction is easy to accept and understand, the operation and supervision execution is in place, the system is in place, the behavior is in accordance with the standard, and the overall safety production management level of an enterprise is improved. The visualization shows that the current safety production management results are as follows: the system comprises a management flow, management indexes, a management system, general standards and specifications, operation standards, emergency plans and the like, and is capable of accurately, quickly and intuitively transmitting the indexes, probabilities, charts, images, sounds, videos and the like to safety production personnel through intuitive and popular and understandable forms, so that the occupational skills and execution capacity of the safety production personnel are improved, the probability of accidents is reduced, and the safety production management level is integrally improved.

(3) And building a visual management platform. Aiming at system integration, resource integration and information sharing, all levels of managers are required to access from a unified portal to acquire required information; and forming a personalized visual interface according to the characteristics of each monitoring grid and the difference of the roles of the personnel, and realizing the timely processing of events and messages by pushing the task-type to-be-handled items and the early warning information in real time.

1) And establishing a workflow management module. The workflow management module can provide visual design of the construction project flow, manage and control the operation of the business flow, and dynamically start the business flow in the actual execution process of the project. The project flow includes not only the four stages of start-up, planning, execution and finalization, which describe the entire process from project selection, project implementation, project handoff to customer service, thus requiring a close fit for the business segment before and after project implementation.

2) And constructing a risk assessment module. On the basis of risk identification, according to the specific conditions of a hydropower EPC project and objective and unified standards and scientific and effective methods, main risk sources, key risk factors, risk areas, risk sequencing and acceptable risk benchmarks are determined, and a risk index is established on the basis of the main risk sources, the key risk factors, the risk areas, the risk sequencing and the acceptable risk benchmarks to determine the degree and the level of influence. And the project management integrated platform automatically pushes the post basic information, post risk points, post risk levels, risk precautionary measures and other data information after final verification to the platform for internal display.

(4) And establishing an enterprise IT system. The IT system is established by each unit according to actual requirements, managers can effectively master information, management transparence and visualization are achieved, management efficiency can permeate into links of manpower resources, supply chains and customer management, internal information of each unit can be visualized, effective transmission is achieved, and management transparence is achieved.

(5) The problems of concept and capital guarantee are solved. The ideological concept and skill level of safety management personnel must be adapted to the requirements of information management, and sufficient funds must be provided to ensure the basic construction and operation and maintenance of platform hardware and software.

(IV) intelligent technology

The intelligent technology is mainly applied to the aspects of construction engineering planning decision, coordination and unification of multi-target realization in the implementation process and project implementation monitoring and early warning. The decision making by adopting the intelligent technology is a complex informatization process, and relates to the transmission and sharing of a large amount of data information, wherein the data information comprises design information, project plan information, construction process information and the like.

(1) management assisted by intelligent software

1) The designer carries out batch drawing, editing and modifying on the construction drawing and the graph in the design scheme through the drawing function of intelligent software, and the drawing quality and the drawing efficiency in the design work are greatly improved.

2) in the aspect of cost management, by utilizing multiple functions of bidding quotation, budget management, expense prediction, budget comparison and the like provided by intelligent software, all expense units in the whole life cycle of an engineering project are decomposed, analyzed and managed, and the dynamic tracking management and control of expenses are realized.

3) In the aspect of progress management, intelligent software is adopted to compile a progress plan, and each unit can optimize and adjust the construction period of the building project conveniently at any time.

(2) And constructing an intelligent knowledge base and a model base. The project department establishes an intelligent knowledge base and a model base according to the characteristics of the project department, and through the schemes of continuously processing and feeding back information, screening out redundant information, evaluating and checking design, construction and the like according to the resources accumulated in the knowledge base and the model base, the information can more correctly guide all the participants to make decisions, so that the management of the construction quality, progress, design change and the like of the project is promoted, and the smooth development of the project construction is guided.

(3) Establishing a safety supervision system

Construction sites are diversified, processing work of sudden situations needs to be done, all units need to establish a real-time monitoring system by using intelligent technologies such as digital image processing, three-dimensional linkage, site real-scene monitoring and the like, potential safety hazards and defect problems existing in engineering projects are prompted and warned in time, and intelligent site construction safety management is achieved.

(4) constructing an early warning processing system

The early warning system is established by each unit according to the actual situation, the working rules, the related system and the working process are operated according to the power standard, the red, yellow and blue early warnings are sent out aiming at the risk points such as the abnormal working program, the abnormal index and the like through the intelligent judgment of the system, the relevant departments or posts timely feed back the situation according to the requirements after receiving the early warning information, and the rectification measures are made.

Further, the EPC project management platform has the following technical characteristics: 1) the method comprises the steps of 2) fast loading technology of mass BIM data, 2) safe reliability, 3) advanced maturity, 4) openness and expandability, 5) flexibility, 6) fault tolerance, 7) applicability and 8) usability.

1) mass BIM data rapid loading technology

the BIM model data volume of the design construction stage is large, a graphic workstation which needs high configuration is opened through traditional BIM browsing software, and a light engine is needed to solve the problem that a large amount of BIM data can be opened quickly on a common machine. Generally, in the process of surveying and designing of EPC engineering, a large amount of geographic information data is needed for supporting, the traditional BIM browsing software cannot load the geographic information data in a digital earth mode, and cannot be effectively fused with the BIM data, and the EPC project management platform provides a GIS + BIM lightweight engine to fuse the GIS and the BIM data for carrying out data lightweight display:

(1) Standard engineering information model lightweight is built to electricity based on IFC

And performing light weight processing on the electricity building format BIM model based on the engineering information model standard model example provided by the second project. The processing mode fully considers different organization dimensions of layers, specialties, directory structures, spaces, time and the like of GIS and BIM data, a scientific spatial data organization structure is formulated according to the OGC standard and the electric construction engineering information model standard, and the structure meets the requirement of lightweight rendering of a client.

(2) Light rendering

The GIS + BIM lightweight technology is researched, and through a plug-in or WEBGL technology, the spatial geographic information data, the EPC engineering data and various service data of the EPC project management platform engineering data switching center are displayed on a browser in a picture mode. And customizing an intuitive data display mode according to different characteristics of EPC data of each specialty.

(3) Multiple rendering optimization

The LOD (level of detail model) technology is researched, and the loading amount of rendering data is reduced by displaying the automatic dynamic level of detail model generation of the loading data, so that the rendering efficiency is improved.

(4) Dynamic loading technique

Dynamic loading and unloading of GIS and BIM data are automatically scheduled, normal operation of the system is guaranteed, and data loading amount in a memory is reduced.

(5) Model referencing techniques

And performing reference optimization on a large number of multiplexing models, reducing IO of a disk, reducing the loading of a memory and performing unified optimization on rendered batches.

(6) Research model automatic cutting technology

Aiming at the large containing and shielding relation of the BIM data, the BIM model is automatically divided and cut, so that the internal model information is not loaded when the outer surface of the BIM model is observed, and the required display data is dynamically loaded when the outer surface information of the BIM model is hidden or enters the interior of the model.

2) Safety and reliability

The EPC project management platform is designed according to the principle of reliability, safety protection is mainly carried out on the aspects of identity authentication, configuration management, parameter operation, exception management, log and audit and application interaction safety of a user in the platform technical architecture design, the phenomenon that normal business cannot be normally carried out due to information infrastructure faults (for example, the phenomenon that the user cannot access a levying and managing system and further cannot carry out normal business due to server or network faults and the like) is reduced as much as possible, meanwhile, the construction of an information safety system is emphasized in the design, the overall safety of the information infrastructure is improved, and the data safety is further ensured.

3) Advanced maturity of

The EPC project management platform should be designed with product and technology advances that are guarantees of future system performance. Products and technologies selected in the technical architecture design of the integrated EPC project management platform have certain prospective and can meet the requirements of service requirements and technology development changes in a period of time in the future. Meanwhile, the maturity of products and technologies is considered as much as possible, and the overall stability of the information infrastructure is enhanced.

4) Open and extensible

The integrated EPC project management platform technical architecture selects an open technology to meet the requirement of flexible information interaction between systems. Meanwhile, the expandability is fully considered, and the requirements of continuously developing and changing services and technologies in the future of the China electrical construction group are met.

5) Flexibility

The integrated EPC project management platform system architecture and the software system architecture have prospective properties, the development and the management change of future services are considered, and the expansion of new services and new requirements is facilitated.

6) Fault tolerance

The integrated EPC project management platform has good fault tolerance, error detection and correction functions, and ensures the correctness, consistency and integrity of data.

7) Applicability of the invention

The integrated EPC project management platform is based on the actual requirements of the China electric power construction group hydropower EPC project management, fully considers the characteristics of the China electric power construction group management and the unit management of each level, realizes the dynamic connection with the existing system and management system, and comprehensively improves the management level of the China electric power construction group.

8) Ease of use

combines the cultural habits of users, and has friendly interface and convenient use. Ensures that operators at all levels can quickly master the operation, and is simple and easy to use.

Compared with the conventional hydropower engineering EPC management platform, the invention has the beneficial effects that:

1) BIM-based EPC project management platform: the integrated EPC management platform fully utilizes the characteristics of the BIM such as intuitiveness, analyzability, sharability and manageability, provides accurate and timely basic data and technical analysis means for each business of project management, and is matched with management means such as a process of project management and statistical analysis, so that a complete management closed loop of data generation, data use, process approval, dynamic statistics and decision analysis is realized, and the process of project comprehensive management capability and management efficiency is improved.

2) Full life cycle cooperative management: the integrated EPC project management platform combines a professional BIM design model with engineering construction, runs through the digital management of the whole life cycle (planning, researching, designing, constructing, operating and maintaining) of the engineering, and improves the efficiency of engineering management.

3) The lightweight engine: massive geographic information data and dense BIM data can be displayed on a common hardware carrier on a map based on a digital earth, and the engine is compatible with an OGC standard and an IFC extension standard based on subject two. Aiming at the characteristics of the trial and sales projects and the promotion projects, the lightweight engine has a WEB-based plug-in version and a brand-new plug-in-free version.

4) Auxiliary planning and designing capacity: the integrated EPC project management platform can summarize design data and project management data, realize the capacity of 'aided planning and design', superpose large-scale maps, high-precision satellite remote sensing images and surrounding environment elements by using a GIS means, refine route selection, reduce changes and improve the project amount and the precision of investment estimation. A unified auxiliary design platform based on G-BIM is provided for scheme evaluation, environment assessment, safety audit and the like, integrated and visual collaborative design is carried out, and conflicts among various specialties and between professional design results and the surrounding environment are reduced.

5) Digital handover: the method provides complete basic data of the processes of engineering design, construction, installation and the like for the operation of the power station, comprehensively improves the project commissioning speed, and greatly shortens the transitional running-in period of capital construction-operation. Good technical reserve and three-dimensional digital data foundation are laid for the engineering companies to provide power plant or other facility full-life-cycle management consultation services for power station owners in the future.

6) Promote the information integration and promote the information construction of enterprises. An integrated EPC project management platform needs to integrate data from nodes such as design, bid and bid, project construction management, digital delivery, and the like. As a platform, a standardized universal interface needs to be established to realize data cleaning and intercommunication interconnection. The information processing from bottom to top is performed on the standards of upstream data, the degree of information transmission of upstream information, and the like.

Drawings

FIG. 1 is an overall framework of the present invention;

fig. 2 is a system overall data flow diagram of the present invention.

Detailed Description

To further illustrate the manner in which the present invention is made and the effects achieved, the following description of the present invention will be made in detail and completely with reference to the accompanying drawings.

Application example

As shown in fig. 1, an EPC project management platform oriented to integration is logically divided into a display layer, an application layer, and a data layer from technical implementation, an EOS platform is used as a development tool, an Oracle database is used to store management data, and software can run on Weblogic middleware on Linux or Windows operating system.

The display layer is a graphical interface for providing application services for the client, which is helpful for the user to understand and efficiently locate the application services, and the specific implementation result can be divided into three client forms: 1) WEB client, 2) Applet program embedded in Web page, 3) Graphical User Interface (GUI) established by Swing or Abstract Window Toolkit (AWT) API. At the client, only the IE browser is needed to work. That is, a user may work with a desktop computer and various handheld terminals, including wired and wireless terminals. The direct access mode of the IE browser supporting LAN/Intranet. And the IE browser supporting the Internet user accesses the HTTP server through the DMZ. And an IE browser access mode of VPN users or dial-up VPN user connection is supported.

the application layer provides the link between client applications and data services, and the main functions are to execute application policies and package application patterns, and present the packaged patterns to the client applications, which can be specifically classified into three types of enterprise-level component technologies: 1) sessionbeans, 2) entitybeans, 3) message-drivers beans. A sessionbean describes an ephemeral session with the client. When the execution of the client is completed, sessionbean and its data will disappear. In contrast, an entitybean describes a row of persistent, robust data stored in a table of a database. If the client terminates or the service ends, the underlying service may be responsible for storing the entitybean data. A message-driver bean combines the functions of a sessionbean and a Java information service (JMS) message listener, which allows a business component to asynchronously accept JMS messages.

Wherein, the data layer comprises a database server for storing data and a Bean for processing and caching data. In the JEE technology system, a database link pool technology is adopted to provide database links required by applications, and a large amount of used data is put into a cache of the system so as to provide an efficient data access and processing mechanism. In the J2EE technology architecture, JDBCAPI is provided that provides application developers with a unified API that is database independent. This API provides a standard of writing and a standard of considering all different application designs. Its secret is a set of Java interfaces implemented by drivers. The driver is responsible for the specific call transitions required by the standard JDBC call to the supported database.

The data layer is the bottom layer in the three-layer mode and is used for defining, maintaining, accessing and updating data and managing and meeting the requirements of application services on the data, the application layer uploads various professional BIM models to a unified integrated project management platform by means of an intelligent algorithm and BIM visual display, and the requirements for displaying, counting and managing project management elements are met by combining the professional unified application through the integrated system platform. The specific design scheme is as follows:

Concept structure design

It mainly includes the following services: contract management, metering payment, HSE management, quality management, technical management, scientific research project management, design document management, design/construction optimization progress management, purchase management financial management and authority management.

as shown in fig. 2, the data flow of the whole system is described, and the data relationship between the services is described as follows: the system takes main contract information as main data; the basic information of the main contract is derived from the basic information of the project; the business such as quality, technology, scientific research, health and fitness ring, mechanical equipment, materials, fund, progress and the like needs to determine the main contract to which the data belongs; and summarizing and counting process data of each item related to the main contract to generate a report for exporting or printing.

(II) logic structure design

the method mainly comprises the following steps: contract management, metering payment, HSE management, quality management, technical management, scientific research project management, design document management, design/construction optimization progress management, purchase management financial management and authority management. The specific naming rule is as follows:

(III) physical Structure design

The storage structure of the database is divided into: logical storage structures and physical storage structures.

A logic storage structure: tablespaces, segments, regions, blocks.

a block is the smallest database management unit and corresponds to a certain corresponding size of disk space. All I/O operations of the database are in block units. Because the minimum unit of the I/O operation of the operating system is the operating system block, the database block is integral multiple of the operating system block, and the creation and deletion are supported.

Physical storage structure: is the actual storage structure of the database. Is composed of operating system files. The method comprises the steps of controlling files, data files, redoing log files, and supporting creation, deletion and movement.

TABLE 1 database storage hardware configuration

table 2 table space division situation table

table 3 table spatial data file location table

(IV) data dictionary design

The design of the data dictionary specifically comprises: contract management, metering payment, HSE management, quality management, technical management, scientific research project management, design document management, design construction/optimization progress management, purchase management, financial management and system management.

(V) view, storage process, function, trigger design

(1) View of the drawing

1)4.2.2.1 materials management: and (4) annual warehousing and ex-warehouse ledger: VIEW _ PRP _ WZGL _ NDCRKTZ, which VIEW is applicable to the function;

2)4.2.2.2 code production function look-up table fields: the VIEW _ TABLE _ CLM _ SHOW is used in the code production function, is displayed on a page when configuring TABLE fields and attributes, and is convenient for configuring database fields;

3)4.2.2.3 materials management: and (4) annual warehousing and ex-warehouse ledger: WFBIZ _ CALEPARTI _ VIEW, which VIEW is for a function.

(2) Storing procedure

1) the code in the system is automatically generated: GEN _ APPLYCODE;

2) Fund management-engineering payment application-quarterly settlement: PRP _ XJ _ ZJGL _ GCZSQJD, calculation Settlement

Amount, prepayment, material money, quality reserve money, deduction of water and electricity fee, safety guarantee money and wage guarantee

The payment, the paid amount, the amount to be paid, and others, and updating;

3) Fund management-other settlement fund payment applications: prp _ xj _ zjgl _ qtjspbb _ update, calculates and updates the settlement amount, the advance payment, the quality reserve, the paid amount, the due payment amount, and others.

(3) Function(s)

Is free of

(4) Flip-flop

the triggers are not used in the database for a while and all data logic processing is implemented in the system.

(VI) user permission design

DBA: all privileges are owned, the highest privilege of the system, and only DBA can create the database structure.

RESOURCE: users with Resource rights can only create entities and cannot create database structures.

CONNECT: a user with the Connect right can only log in Oracle, cannot create an entity, and cannot create a database structure.

The common user: and granting connect, resource authority.

The DBA manages users: and granting connect, resource, dba rights.

Table 4 database user authority table

(VII) Security privacy settings

1) System operation safety

a. Method for preventing user from directly operating database

The database server is deployed in an intranet, so that direct operation of an external user on the database server is prevented, the oracle default user name password sid and the port are modified, database information is prevented from being leaked, and the safety of the database environment is guaranteed.

b. Encrypting a user password for a system

In software systems, protection of data, licensing of business operations is accomplished by identifying user identities and rights. And comparing the user passwords, distributing the operation authority of the user to the user by the same telephone system, and operating the system by the user according to the distributed authority. As known from the above processes, the user password is easy to be stolen and leaked in the transmission process, and in addition, if the database is illegally accessed, the password stored in the database can be illegally viewed. Therefore, the password record field in the transmission process and the database should not be transmitted and stored by using the plaintext, and the encryption algorithm described by the encryption part of the transmission data should be encrypted by using the effective mainstream technology for the plaintext password before the password is transmitted, and then the encrypted password is transmitted to the system. The system compares the encrypted passwords stored in the encrypted password data submitted by the user, and if the encrypted passwords are consistent, the system performs subsequent operation. Through the above measures and processes, it is verified that the original password cannot be obtained even if the encrypted password is stolen.

2) System information security

a. User identification and authentication

In the computer system we use, the security measures are layered, and user identification and authentication are the outermost layers of security protection that the system can provide. The method is that the system provides a certain mode and rule for the user to make the user identify the name or identity of the user, so that the legal user information recorded in the database can be compared when the user logs in the system each time, and the database can be accessed through the verification party.

The identity and authentication information of the user in the ORACLE database is stored in the dba _ users table, and the application program compares the user name and password input by the user with the database each time the user logs in the system, so as to determine whether the user is legal.

b. Access control

The most important aspect of database security is to ensure that only qualified users are allowed to access a particular table or data in the database, primarily through access control of the database system. The purpose is to rank the user rights into a data dictionary. The user only accesses data to which he has access. When a user carries out operations such as inquiry, insertion, modification, deletion and the like of certain data, the user is firstly checked, the operation authority of the user is mainly checked, and if the operation request of the user exceeds or does not accord with the authority defined by the system, the system refuses the user to carry out the operation.

The user of the system is mainly EPC system, and accesses the database through the data user, and the CREATE PROCEDURE, UNLIMITED TABLESSPACE, CREATE VIEW, CREATE TABLE, CREATESION are authorized at present. The authority control is strict, and the database cannot be fatally damaged.

in addition, system and system users must be strictly managed, and data information administrators must modify their default passwords to prohibit building useless database application objects with the users. When configuration is required by using the administrator account, careful operation is required to avoid irreparable loss.

Claims (7)

1. An integrated EPC project management platform is logically divided into a display layer, an application layer and a data layer from technical realization, and is characterized in that the EPC project management platform takes an EOS platform as a development tool, uses an Oracle database to store management data, and can be used as management software running on Weblogic middleware on a Linux or Windows operating system;

The display layer is a graphical interface for providing application services for the client, which is helpful for the user to understand and efficiently locate the application services, and the specific implementation result can be divided into three client forms: 1) a Web client; 2) an Applet program embedded in a Web page; 3) a Graphical User Interface (GUI) built with Swing or Abstract Window Toolkit (AWT) APIs;

The application layer provides the link between client applications and data services, and the main functions are to execute application policies and package application patterns, and present the packaged patterns to the client applications, which can be specifically classified into three types of enterprise-level component technologies: 1) sessionbeans; 2) entitybeans; 3) message-drivers;

The data layer comprises a database server for storing data and a Bean for processing the data and caching the data, is the lowest layer in a three-layer mode, is used for defining, maintaining, accessing and updating the data and managing and meeting the request of application service for the data, and realizes the function of the data layer through the construction of the database so as to guide the development of business functions.

2. The integrated EPC project management platform according to claim 1, wherein the application layer uploads various professional BIM models to the unified integrated project management platform by means of intelligent algorithm and BIM visual display, and the unified application of various professionals is combined through the integrated system platform, so that the display, statistics and management requirements of project management elements are met.

3. The integrated EPC project management platform of claim 1, wherein the specific construction scheme of the database is as follows: 1) designing a conceptual structure; 2) designing a logic structure; 3) designing a physical structure; 4) designing a data dictionary; 5) view, storage process, function, trigger design; 6) designing user authority; 7) and (5) designing security.

4. The integrated EPC project management platform of claim 2, wherein the functions of the BIM model include: 1) the method comprises the following steps of basic setting, 2) drawing review, 3) field scheduling, 4) material tracking, 5) a process engineering method, 6) technical settlement, 7) virtual construction, 8) a progress sand table, 9) a quality safety sand table, 10) a data sand table, 11) an electronic sand table and 12) digital transfer.

5. The unified EPC project management platform according to claim 1, wherein in the physical environment of the Oracle database, the Oracle RAC cluster component comprises: 1) oracle cluster, 2) Oracle kernel component, 3) shared disk system, 4) global resource directory GRD, 5) global caching service GCS and global queuing service GES, 6) diagnostic daemon DIAG.

6. The integrated EPC project management platform of claim 1, wherein data contents are synchronized between a field production database and an engineering data center in the data layer in real time or periodically by means of a data interface, an interface or a plug-in of the data center is called to transmit parameters to the data center when business data is subjected to addition, modification and deletion operations, and the data center performs corresponding data synchronization operations; the components of the data interface include: 1) excel import and export modules, 2) Project import and export modules, 3) P3 and P6 import and export modules.

7. The integrated EPC project management platform of claim 1, wherein the necessary technical support required for platform implementation includes 1) base environment, 2) BIM technology, 3) visualization technology, and 4) intelligent technology.