Engineering companies design database-based management

Thread Content

During the first two years of my career, I worked in an engineering company on process system and pipeline design, and I’ve always had the idea of managing design data in a database format； Why do such thoughts arise? In design institutes, different specialties need to exchange data with one another. The core specialty is process engineering; often the same set of data has to be provided to multiple specialties, which requires filling out numerous data forms. The larger the project scale, the more mechanical and repetitive the work becomes, and errors are more likely to occur. Data entry forms must be checked many times to prevent mistakes in the data, which demands care and a sense of responsibility ； Although I am not a computer science specialist, I have some knowledge of the VB language and basic database concepts. A data management system can achieve the following functions: First, it creates a data input interface that allows users to convert process package data into tables in the format used by design institutes. The data in the data table is automatically transferred to the database and linked to other department-level tables (various data tables and conditional tables for different specialties), enabling automatic data entry and modification. For example, if the dimensions of a device change, I only need to modify the data in the equipment database specific to the process engineering department; the conditions related to that device in the civil engineering documents, as well as those in the instrumentation-related documents, all need to be updated as well ； II: Different levels of management permissions for databases ； Designers, reviewers, and approvers from different specialties have varying levels of management permissions ； III: Create a table output interface; when conditions need to be specified, a table of those conditions is generated. After it is confirmed by the reviewer and approver, the data is locked and printed in paper form to be handed over to other departments (paper versions of the conditions are more appropriate for clarifying design responsibilities among different departments), while other departments can obtain the electronic version of the condition table from the data management system. If the data needs to be modified, the reviewer or approver must unlock the data in order to make the changes. Fourthly, the conditions for returning to other specialties are also handled through the data system, which automatically identifies which data has been modified ； V: The association between CAD drawings and databases ； For example, in the properties of a vertical storage tank in CAD, there is a field for diameter that is linked to the database; when designers modify the diameter in CAD, the data in the database changes, and the data in all tables also changes. I have used the Autocad P&Id software, which already provides this functionality, and it should be possible to integrate it with 3D graphics. I believe that, aside from providing for one’s family, it’s best to do a job that one enjoys and finds meaningful ； I believe a data management system that implements the aforementioned functions could free a large number of designers from mechanical, repetitive tasks, allowing them to focus on more meaningful work. As far as I know, some of Sinopec’s engineering companies do not yet have similar systems, and this area seems to hold market potential. Why doesn’t their IT department develop similar systems? There should be some software companies working on development in this area, but I don’t know which ones Do any of you sea friends know?