Cable Book Management System

Abstract

The invention discloses a cable book management system. The management system comprises user information, a user login interface, a project information base and an authority management base. The user login interface is connected with the user information, and the project information base and the authority management base are connected with the user information and used for distributing login authorities by users in accordance with projects which the users belong to. The login interface is connected with a technical design management system which is connected with a cable management system and the authority management base, the cable management system comprises a general cable data base, namely a cable specification maintaining base, a project main database, a cable detailed list, cable laying and a laying log, the project information base is connected with the cable specification maintaining base and the project main database, and the user information is connected with the authority management base and the laying log. The cable book management system has the advantages that the multiple simultaneously online users process data and inquire local area network services.

Description

technical field [0001] The invention belongs to engineering application, and is dedicated to a multi-user, multi-project, multi-department simultaneous online editing and querying cable book software platform, and is applied to marine engineering construction and complex large-scale projects with many control and power systems. Background technique [0002] The cable book is a list report that provides construction basis for cable laying in the process of ship and offshore construction, including a large amount of production information such as equipment name, location, route and cable model. With this checklist, construction personnel can complete the cable laying work of the entire project in an orderly and planned manner. Generally, each cable contains the following information: serial number, system drawing number, drawing version number, cable code, cable specification, cable start equipment information (equipment code, equipment name, equipment location), termination e...

AI Technical Summary

Problems solved by technology

However, compared with software in the form of server databases, its stability and accuracy are far inferior

The reason is that this method requires multiple people to operate at the same time or not at the same time, share an Excel table, and each person is divided into an exclusive space, resulting in a geometric progression of useless space in the content of the table, greatly increasing the capacity of the table, and the table needs to occupy The system resources are several times larger than the computer memory required by the basic information of the cable book itself

Not only is the running speed very slow, but compared with the previous form, the spliced ​​Excel table is more prone to system crashes

Moreover, during the update process of the cable book, due to version errors, the summary information of multiple people will be inconsistent, resulting in frequent errors and rework)

[0009] 2.Excel VB or Access user sharing (compared to the previous Excel table form, compared with the previous one, it has obvious advantages in speed, accuracy and stability, and can provide some calculation functions according to needs, but compared with this patent There is still a big gap, mainly because of the fatal lack of data processing volume and processing speed, as well as the simultaneous operation of multiple projects and multiple users.

[0011] 1. The protection of a large amount of important information is extremely poor. Once there is a problem with the cable book itself or the computer storing the cable book, it may lead to the loss of work for weeks or even months

[0012] 2. The help of cost control is very limited. Since the cable length is measured one by one manually, it often happens that when one or more engineers measure the length of different cables in a similar area within a few working days apart, the given surplus amount varies, resulting in cable lengths "for reference only"

[0013] 3. Cable length estimation is slow

[0014] 4. Manual input of the cable path is slow and the train of thought is incoherent

[0015] 5. There is no detection function, the accuracy can only rely on on-site inspection, and the error is found too late

[0016] 6. The modification and update speed is slow, and it is easy to miss

[0017] 7. It cannot be traced back, and there are no reliable historical records for many complicated operations

[0018] 8. Unable to detect the deletion of the cable

Images