Ship repair cost acquisition method and acquisition system

Abstract

The present invention provides a ship repair cost acquisition method and acquisition system, wherein the statistical method comprises the following steps: performing a term search on an Oracle database according to a preset ship repair cost input item, recording the retrieved data into the ship repair cost input item, marking the ship repair cost input item for which data has been acquired as a first input item; marking the ship repair cost input item for which data has not been acquired as a second input item; performing a term search on a preset data warehouse, acquiring the update time of the warehouse data, and if the difference between the update time and the real-time time is less than a preset first threshold, recording the warehouse data into the second input item; inputting the corresponding ship repair cost input item into a preset ship repair cost model, obtaining the value of the corresponding ship repair cost output item; and displaying the ship repair cost output item as a report and / or icon result. The ship repair cost acquisition method and acquisition system of the present invention can acquire data related to the ship repair cost across systems, thereby improving the acquisition efficiency of data related to the ship repair cost.

Description

Technical Field

[0001] The present invention relates to the field of ship technology, and in particular to a method and system for obtaining ship repair costs. Background Art

[0002] With the continuous development and growth of the ship repair industry, ship repair cost information is scattered among various ship repair management systems and other management systems, forming isolated data. Collecting, sorting and analyzing the cost information in these data requires a lot of manpower and material resources, and has a certain lag, which is not conducive to the real-time analysis of costs and guiding the current cost work. Summary of the invention

[0003] The purpose of the present invention is to overcome the shortcomings and deficiencies in the prior art and to provide a ship repair cost acquisition method and acquisition system, which can acquire data related to the ship repair cost across systems and improve the efficiency of acquiring cost-related data.

[0004] An embodiment of the present invention provides a method for obtaining ship repair costs, comprising:

[0005] According to the preset ship repair cost input item, an Oracle database storing the ship repair cost is searched for an entry; if data corresponding to the ship repair cost input item is retrieved from the Oracle database, the retrieved data is recorded in the ship repair cost input item, and the ship repair cost input item for which the data is obtained is marked as a first input item; if the Oracle database cannot retrieve data corresponding to the ship repair cost input item, the corresponding ship repair cost input item is marked as a second input item;

[0006] Performing a term search on a preset data warehouse according to the second input item; if warehouse data corresponding to the second input item is retrieved in the data warehouse, obtaining the update time of the warehouse data, and if the difference between the update time and the real time is less than a preset first threshold, recording the warehouse data into the second input item;

[0007] Inputting corresponding ship repair cost input items into a preset ship repair cost model to obtain the values ​​of corresponding ship repair cost output items; wherein the ship repair cost model includes operation model rules between the ship repair cost input items and the ship repair cost output items;

[0008] The ship repair cost output items are displayed as report forms and / or graphical results.

[0009] Compared with the prior art, the ship repair cost acquisition method of the present invention performs entry retrieval on the Oracle database and data warehouse storing the ship repair cost respectively, so as to obtain data corresponding to the cost input items, wherein the data warehouse is connected with various ship repair data registration systems, and can quickly and timely obtain data across systems, thereby improving the efficiency of obtaining ship repair costs, avoiding the tedious steps of manual acquisition and statistical data, and saving labor.

[0010] Furthermore, if the difference between the update time and the real-time time is greater than or equal to the first threshold, the real-time data of the ship repair data registration system corresponding to the warehouse data is counted through a preset conversion template, the warehouse data is updated according to the real-time data, and the updated warehouse data is recorded in the second input item, so as to ensure the accuracy of the acquired warehouse data.

[0011] Furthermore, if the warehouse data corresponding to the second input item cannot be retrieved in the data warehouse, the second input item is marked as the third input item, the ship repair cost model related to the third input item is searched, and the third input item and the related ship repair cost model are generated into a data missing report and displayed, which is helpful for customers to quickly understand the impact of data missing.

[0012] Further, the construction of the conversion template includes the following steps:

[0013] Acquire the data type of the warehouse data and the preset associated words corresponding to the data type;

[0014] Acquire a statistical template of each ship repair acquisition system, wherein the statistical template includes a data item name of the corresponding ship repair acquisition system and statistical data corresponding to the data item name;

[0015] Performing an associated word search on the data item name of the statistical template, and associating the data item name with the data type of the warehouse data according to the search result;

[0016] The associated data item name, data type, statistical data corresponding to the data item name, and conversion coefficient of warehouse data corresponding to the data type are obtained and saved.

[0017] Further, if the difference between the update time and the real-time time is greater than or equal to the first threshold, real-time data of the ship repair data registration system corresponding to the warehouse data is counted through a preset conversion template, and the warehouse data is updated according to the real-time data, including the following steps:

[0018] Acquire the data type of the warehouse data;

[0019] Searching for the data item name associated with the data type in each ship repair acquisition system according to the data type;

[0020] Obtaining real-time statistical data corresponding to the found data item name;

[0021] The real-time statistical data is converted by a conversion coefficient, and the data warehouse obtains the converted value. The value of the corresponding data is accurately obtained by the conversion coefficient.

[0022] Further, the displaying of the ship repair cost output item as a report and / or icon result comprises the following steps:

[0023] Get the login user information sent by the terminal device;

[0024] Acquire the job information of the logged-in user from the information of the logged-in user;

[0025] Get the access permission of the logged-in user according to the job information of the logged-in user;

[0026] Extracting the corresponding output item of the ship repair cost according to the review authority;

[0027] Displaying the extracted ship repair cost output items as report forms and / or graphic results;

[0028] The report and / or icon are sent to the terminal device. The corresponding output items of the ship repair cost are displayed on the terminal device according to the position information to prevent leakage.

[0029] An embodiment of the present invention further provides a ship repair cost acquisition system, comprising:

[0030] a database search module, which searches an Oracle database storing the ship repair cost according to a preset ship repair cost input item, and if data corresponding to the ship repair cost input item is retrieved from the Oracle database, the retrieved data is recorded in the ship repair cost input item, and the ship repair cost input item for which the data is obtained is marked as a first input item; if the Oracle database cannot retrieve data corresponding to the ship repair cost input item, the corresponding ship repair cost input item is marked as a second input item;

[0031] a data warehouse retrieval module, which performs a term search on a preset data warehouse according to the second input item; if warehouse data corresponding to the second input item is retrieved in the data warehouse, obtains the update time of the warehouse data, and if the difference between the update time and the real time is less than a preset first threshold, records the warehouse data into the second input item;

[0032] An output item value acquisition module is used to input a corresponding ship repair cost input item into a preset ship repair cost model to obtain a value of a corresponding ship repair cost output item; wherein the ship repair cost model includes a calculation model rule between the ship repair cost input item and the ship repair cost output item;

[0033] The display module displays the output items of the ship repair cost as reports and / or icon results.

[0034] Compared with the prior art, the ship repair cost acquisition system of the present invention respectively performs entry retrieval on the Oracle database and data warehouse storing the ship repair cost, so as to obtain data corresponding to the cost input items, wherein the data warehouse is connected with various ship repair data registration systems, and can quickly and timely obtain data across systems, thereby improving the efficiency of obtaining ship repair costs, avoiding the tedious steps of manual acquisition and statistical data, and saving labor.

[0035] Furthermore, the data warehouse retrieval module also performs the following judgment: if the difference between the update time and the real-time time is greater than or equal to the first threshold, the real-time data of the ship repair data registration system corresponding to the warehouse data is counted through a preset conversion template, the warehouse data is updated according to the real-time data, and the updated warehouse data is recorded in the second input item. The accuracy of the acquired warehouse data can be ensured.

[0036] Furthermore, it also includes a data missing report module: if the warehouse data corresponding to the second input item cannot be retrieved in the data warehouse, the second input item is marked as the third input item, the ship repair cost model related to the third input item is searched, and the third input item and the related ship repair cost model are used to generate a data missing report and display it. This is helpful for customers to quickly understand the impact caused by data missing.

[0037] Furthermore, the conversion template includes the following submodules:

[0038] A first data acquisition submodule is used to acquire data types of warehouse data of the data warehouse and preset associated words corresponding to the data types;

[0039] The second data acquisition submodule acquires a statistical template of each ship repair acquisition system, wherein the statistical template includes a data item name of the corresponding ship repair acquisition system and statistical data corresponding to the data item name;

[0040] An associated word search submodule performs an associated word search on the data item name of the statistical template, and associates the data item name with the data type of the warehouse data according to the search result;

[0041] The data preservation submodule obtains and preserves the related data item names, data types, statistical data corresponding to the data item names, and conversion coefficients of warehouse data corresponding to the data types.

[0042] In order to more clearly understand the present invention, the specific implementation of the present invention will be described below with reference to the accompanying drawings. BRIEF DESCRIPTION OF THE DRAWINGS

[0043] Figure 1 The present invention is a flowchart of a method for obtaining ship repair costs according to an embodiment of the present invention.

[0044] Figure 2 The present invention is a flowchart of a method for obtaining ship repair costs according to an embodiment of the present invention for updating warehouse data according to real-time data.

[0045] Figure 3 The present invention is a flowchart of constructing a conversion template of a method for obtaining ship repair costs according to an embodiment of the present invention.

[0046] Figure 4 The figure is a flowchart showing a method for obtaining ship repair costs according to an embodiment of the present invention. DETAILED DESCRIPTION

[0047] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0048] See also Figure 1 , which is a flow chart of a method for obtaining ship repair costs according to an embodiment of the present invention. The method for obtaining ship repair costs can obtain data related to ship repair costs across systems, thereby improving the efficiency of obtaining data related to ship repair costs, and includes the following steps:

[0049] S1: An Oracle database storing the ship repair cost is searched for entries according to a preset ship repair cost input item. If data corresponding to the ship repair cost input item is retrieved from the Oracle database, the retrieved data is recorded in the ship repair cost input item, and the ship repair cost input item for which the data is obtained is marked as a first input item; if data corresponding to the ship repair cost input item cannot be retrieved from the Oracle database, the corresponding ship repair cost input item is marked as a second input item.

[0050] Preferably, after the Oracle database retrieves the data corresponding to the ship repair cost input item, the data is further processed according to preset extraction rules and integration rules.

[0051] The Oracle database is a relational database management system and is currently the most widely used database management system in the world. As a general database system, it has complete data management functions; as a relational database, it is a complete relational product; as a distributed database, it implements distributed processing functions.

[0052] The Oracle database includes but is not limited to the following modules:

[0053] The user management module is a module used to provide management of user login accounts, department names, user role allocations, and authority control.

[0054] The ship entry notification management module is used to provide relevant information about the ship's entry into the factory, such as the time of entry, the amount of repair work, the assigned project number, the start time, etc.

[0055] The dispatch management module arranges specific personnel management for the specific ship that needs to be repaired based on the engineering number of the single ship, such as sales representatives, project managers, professional supervisors, quota personnel, settlement representatives, construction units, etc., and dispatches the work according to the engineering item number when necessary. The dispatch of the dispatch management module determines the personnel who fill in the later engineering order, the authority of the personnel who write the quota order, and the filling of the construction unit of the construction content.

[0056] The team management module is used to manage team information, including the nature of the team's work, team personnel management, team department, team settlement tax rate, etc.

[0057] The demand application form management module manages the information of material procurement involved in the repair process of the ship corresponding to the ship repair project order number.

[0058] The material warehouse management module provides purchased or stocked materials to individual ships for use based on production needs, and records the relevant receipt records.

[0059] The single ship engineering order management module records the details of the single ship repair under the engineering order number, based on the single ship engineering number and engineering item number. It records the management of work content, specifications, quantity, construction unit and other information.

[0060] The outsourcing order management module outsources work when a single ship repair project requires external assistance, and records the specific details of the outsourcing process, including the outsourcing object, work content and cost. The outsourcing object is a qualified supplier.

[0061] The single ship quota management module obtains the content of the engineering order and the corresponding quota standard, speeds up the single ship cost accounting work, and provides cost reference for ship settlement.

[0062] The single ship project settlement management module conducts single ship project settlement based on the construction unit of the single ship.

[0063] Ship settlement management module, the sales representative prepares the external settlement bill based on the content of the engineering order.

[0064] The basic profile management module is used to calculate the weight of materials of specified specifications and models in the engineering order and the weight of basic profiles involved in the quota order.

[0065] The quota standard management module customizes different quota standards for different types of ships, different locations, different processing methods, etc. In the single ship quota management module, by obtaining the relevant code, the specified quota standard can be automatically applied to compile the quota.

[0066] The working time management module is used to record the construction content and working hours of the construction team members on each ship every day as the basis for successful working time assessment.

[0067] The ship repair cost input items are data directly or indirectly related to the ship repair cost, and after calculation, and / or conversion, and / or screening, data directly reflecting the cost information can be output, such as the cost of materials collected by a single ship in the warehouse management module, the working hours and unit prices entered daily by the construction unit in the working hours management module, and the working hours, unit prices and outsourcing fees entered daily by the outsourcing unit in the outsourcing order management module.

[0068] First, a term search is performed in the corresponding Oracle database to obtain the data of the ship repair cost input items in the local database, and the ship repair cost input items for which the data cannot be obtained are marked so that the ship repair cost input items for which the data cannot be obtained can be uniformly processed.

[0069] S2: According to the second input item, a data warehouse that is preset and connected to each ship repair data registration system is searched for entries; if warehouse data corresponding to the second input item is retrieved in the data warehouse, the update time of the warehouse data is obtained, and if the difference between the update time and the real time is less than a preset first threshold, the warehouse data is recorded in the second input item.

[0070] Preferably, after retrieving the warehouse data corresponding to the second input item in the data warehouse, the warehouse data is further filtered according to preset filtering rules, and the warehouse data with inconsistent formats or descriptions is cleaned and converted according to preset conversion rules.

[0071] Each ship repair data registration system is a registration system that contains the same ship repair project order number and the data corresponding to the order number; each ship repair data registration system includes but is not limited to a material purchase registration system, a material requisition registration system, an outsourcing order registration system, an invoice registration system and a construction team registration system.

[0072] The data warehouse is a structured data environment for decision support systems (DSS) and online analytical application data sources, organized according to certain subject domains, where the subject refers to the key aspects that users are concerned about when using the data warehouse to make decisions. For example, in this embodiment, the subject of the data warehouse is cost data.

[0073] The warehouse data is data obtained and stored by the data warehouse after systematic processing, aggregation and organization based on the extraction and cleaning of original scattered database data. The data type of the warehouse data is consistent with the subject of the data warehouse.

[0074] In step S2, if the difference between the update time and the real-time time is greater than or equal to the first threshold, the real-time data of the ship repair data registration system corresponding to the warehouse data is counted through a preset conversion template, the warehouse data is updated according to the real-time data, and the updated warehouse data is recorded in the second input item.

[0075] The first threshold is the data update cycle of the corresponding ship repair data registration system. If the corresponding ship repair data registration system does not have a fixed update cycle, the first threshold is set by the user, and its minimum value can be set to 0. For example, if the data update cycle of the corresponding ship repair data registration system is 24 hours, the first threshold is 24 hours; if the corresponding ship repair data registration system does not have a fixed data update cycle, the user can set the first threshold to 0, 30 minutes, 8 hours or other time values. By comparing the difference between the update time and the real-time time with the first threshold, the accuracy of the acquired warehouse data can be ensured, and the number of data updates can be reduced to prevent the life of the hardware equipment from being affected by too frequent data updates.

[0076] See also Figure 2 , using a preset conversion template to count the real-time data of the ship repair data registration system corresponding to the warehouse data, and updating the warehouse data according to the real-time data includes the following steps:

[0077] S21: Acquire the data type of the warehouse data;

[0078] S22: searching for the data item name associated with the data type in each ship repair acquisition system according to the data type;

[0079] S23: Obtaining real-time statistical data corresponding to the found data item name;

[0080] S24: The real-time statistical data is converted using a conversion coefficient, and the data warehouse obtains the converted value.

[0081] The conversion coefficient is obtained based on the data unit of the real-time statistical data and the data unit of the warehouse data. Specifically, the conversion ratio can be found online or obtained from the local data, and the conversion ratio is used as the conversion coefficient.

[0082] See also Figure 3 , the construction of the conversion template includes the following steps:

[0083] B1: Acquire the data type of the warehouse data and the preset associated words corresponding to the data type;

[0084] B2: Obtaining a statistical template of each ship repair acquisition system, wherein the statistical template includes a data item name of the corresponding ship repair acquisition system and statistical data corresponding to the data item name;

[0085] B3: performing an associated word search on the data item name of the statistical template, and associating the data item name with the data type of the warehouse data according to the search results;

[0086] B4: Obtain and save the associated data item name, data type, statistical data corresponding to the data item name, and conversion coefficient of warehouse data corresponding to the data type.

[0087] In step S2, if the warehouse data corresponding to the second input item cannot be retrieved in the data warehouse, the second input item is marked as the third input item, the ship repair cost model related to the third input item is searched, and a data missing report is generated for the third input item and the related ship repair cost model and displayed. Among them, the ship repair cost input item marked as the third input item is determined to be unable to retrieve data, and by sorting out the ship repair cost model related to the third input item, it is helpful for customers to quickly understand the impact caused by data missing.

[0088] S3: Inputting corresponding ship repair cost input items into a preset ship repair cost model to obtain the values ​​of corresponding ship repair cost output items; wherein the ship repair cost model includes operation model rules between the ship repair cost input items and the ship repair cost output items.

[0089] The cost output items include but are not limited to single ship quotation cost, target cost, incurred cost, expected cost, and sales cost.

[0090] The calculation model rules are rules for data processing of the ship repair cost input items, including but not limited to data processing methods such as calculation, and / or conversion, and / or screening. The calculation model rules can be existing data processing rules, or data processing rules set by the user according to the association between the cost input items and the cost output items.

[0091] S4: Displaying the ship repair cost output item as a report and / or icon result.

[0092] See also Figure 4 , the step S4 comprises the following steps:

[0093] S41: Obtaining the login user information sent by the terminal device;

[0094] S42: Acquire the job position information of the logged-in user from the information of the logged-in user;

[0095] S43: Obtaining the browsing authority of the logged-in user according to the job information of the logged-in user;

[0096] S44: extracting the corresponding output item of the ship repair cost according to the review authority;

[0097] S45: Displaying the extracted ship repair cost output items as a report and / or icon result;

[0098] S46: Send the report and / or icon to the terminal device.

[0099] Among them, the terminal device is an electronic device with a display that can obtain information data through wired or wireless connection, such as a BI cockpit, computer, mobile phone and tablet computer.

[0100] Through step S4, the corresponding output items of the ship repair cost can be displayed on the terminal device according to the position information to prevent leakage.

[0101] Compared with the prior art, the ship repair cost acquisition method of the present invention can obtain real-time statistical data related to the ship repair cost from other ship repair acquisition systems, thereby quickly and timely obtaining the output values ​​of various ship repair cost output items of the ship repair cost, avoiding the tedious steps of manual acquisition and statistical data, and saving labor. In addition, the cost data that can be consulted can be determined according to the position, which can reduce the risk of cost data leakage.

[0102] One embodiment of the present invention further provides a ship repair cost acquisition system, which executes the steps of the above ship repair cost acquisition method when in operation. The ship repair cost acquisition system comprises:

[0103] a database search module, which searches an Oracle database storing the ship repair cost according to a preset ship repair cost input item, and if data corresponding to the ship repair cost input item is retrieved from the Oracle database, the retrieved data is recorded in the ship repair cost input item, and the ship repair cost input item for which the data is obtained is marked as a first input item; if the Oracle database cannot retrieve data corresponding to the ship repair cost input item, the corresponding ship repair cost input item is marked as a second input item;

[0104] a data warehouse retrieval module, which performs a term search on a preset data warehouse according to the second input item; if warehouse data corresponding to the second input item is retrieved in the data warehouse, obtains the update time of the warehouse data, and if the difference between the update time and the real time is less than a preset first threshold, records the warehouse data into the second input item;

[0105] An output item value acquisition module is used to input a corresponding ship repair cost input item into a preset ship repair cost model to obtain a value of a corresponding ship repair cost output item; wherein the ship repair cost model includes a calculation model rule between the ship repair cost input item and the ship repair cost output item;

[0106] The display module displays the output items of the ship repair cost as reports and / or icon results.

[0107] Compared with the prior art, the ship repair cost acquisition system of the present invention can obtain real-time statistical data related to the calculation of ship repair costs from other ship repair acquisition systems, so as to quickly and timely obtain the output values ​​of various ship repair cost output items of the ship repair costs, avoiding the tedious steps of manual acquisition and statistical data, and saving labor.

[0108] In a feasible embodiment, the data warehouse retrieval module also performs the following judgment: if the difference between the update time and the real-time time is greater than or equal to the first threshold, the real-time data of the ship repair data registration system corresponding to the warehouse data is counted through a preset conversion template, the warehouse data is updated according to the real-time data, and the updated warehouse data is recorded in the second input item.

[0109] The first threshold is the data update cycle of the corresponding ship repair data registration system. If the corresponding ship repair data registration system does not have a fixed update cycle, the first threshold is set by the user, and its minimum value can be set to 0. For example, if the data update cycle of the corresponding ship repair data registration system is 24 hours, the first threshold is 24 hours; if the corresponding ship repair data registration system does not have a fixed data update cycle, the user can set the first threshold to 0, 30 minutes, 8 hours or other time values. By comparing the difference between the update time and the real-time time with the first threshold, the accuracy of the acquired warehouse data can be ensured, and the number of data updates can be reduced to prevent the life of the hardware equipment from being affected by too frequent data updates.

[0110] The conversion template includes the following submodules:

[0111] A first data acquisition submodule is used to acquire data types of warehouse data of the data warehouse and preset associated words corresponding to the data types;

[0112] The second data acquisition submodule acquires a statistical template of each ship repair acquisition system, wherein the statistical template includes a data item name of the corresponding ship repair acquisition system and statistical data corresponding to the data item name;

[0113] An associated word search submodule performs an associated word search on the data item name of the statistical template, and associates the data item name with the data type of the warehouse data according to the search result;

[0114] The data preservation submodule obtains and preserves the related data item names, data types, statistical data corresponding to the data item names, and conversion coefficients of warehouse data corresponding to the data types.

[0115] In a feasible embodiment, the ship repair cost acquisition system of the present invention further includes a data missing report module: if the warehouse data corresponding to the second input item cannot be retrieved in the data warehouse, the second input item is marked as a third input item, the ship repair cost model related to the third input item is searched, and a data missing report is generated and displayed for the third input item and the related ship repair cost model. The ship repair cost input item marked as the third input item is determined to be unable to retrieve data, and by sorting out the ship repair cost model related to the third input item, it is helpful for customers to quickly understand the impact caused by data missing.

[0116] In a feasible embodiment, when the display module displays the ship repair cost output item as a report and / or icon result, steps such as steps S41 to S46 are executed.

[0117] Although embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that various changes, modifications, substitutions and variations may be made to the embodiments without departing from the principles and spirit of the present invention, and that the scope of the present invention is defined by the appended claims and their equivalents.

Claims

1. A method for obtaining ship repair costs, characterized in that: include: According to the preset ship repair cost input item, an Oracle database storing the ship repair cost is searched for an entry; if data corresponding to the ship repair cost input item is retrieved from the Oracle database, the retrieved data is recorded in the ship repair cost input item, and the ship repair cost input item for which the data is obtained is marked as a first input item; if the Oracle database cannot retrieve data corresponding to the ship repair cost input item, the corresponding ship repair cost input item is marked as a second input item; According to the second input item, a data warehouse connected to each ship repair data registration system is searched for entries; If warehouse data corresponding to the second input item is retrieved in the data warehouse, the update time of the warehouse data is obtained, and if the difference between the update time and the real time is less than a preset first threshold, the warehouse data is recorded in the second input item; If the difference between the update time and the real-time time is greater than or equal to the first threshold, the real-time data of the ship repair data registration system corresponding to the warehouse data is counted through a preset conversion template, the warehouse data is updated according to the real-time data, and the updated warehouse data is recorded in the second input item; The warehouse data is the data obtained and stored by the data warehouse after systematic processing, aggregation and arrangement based on the extraction and cleaning of the original scattered database data; Inputting corresponding ship repair cost input items into a preset ship repair cost model to obtain the values ​​of corresponding ship repair cost output items; wherein the ship repair cost model includes operation model rules between the ship repair cost input items and the ship repair cost output items; The ship repair cost output items are displayed as report forms and / or graphical results.

2. A method for obtaining ship repair costs according to claim 1, characterized in that: If the warehouse data corresponding to the second input item cannot be retrieved in the data warehouse, the second input item is marked as the third input item, and the ship repair cost model related to the third input item is searched, and a data missing report is generated for the third input item and the related ship repair cost model and displayed.

3. A method for obtaining ship repair costs according to claim 2, characterized in that: The construction of the conversion template includes the following steps: Acquire the data type of the warehouse data and the preset associated words corresponding to the data type; Acquire a statistical template of each ship repair acquisition system, wherein the statistical template includes a data item name of the corresponding ship repair acquisition system and statistical data corresponding to the data item name; Performing an associated word search on the data item name of the statistical template, and associating the data item name with the data type of the warehouse data according to the search result; The associated data item name, data type, statistical data corresponding to the data item name, and conversion coefficient of warehouse data corresponding to the data type are obtained and saved.

4. A method for obtaining ship repair costs according to claim 3, characterized in that: If the difference between the update time and the real-time time is greater than or equal to the first threshold, real-time data of the ship repair data registration system corresponding to the warehouse data is counted through a preset conversion template, and the warehouse data is updated according to the real-time data, including the following steps: Acquire the data type of the warehouse data; searching, according to the data type, in each ship repair acquisition system for the data item name associated with the data type; Obtaining real-time statistical data corresponding to the found data item name; The real-time statistical data is converted using the conversion coefficient, and the data warehouse obtains the converted value.

5. A method for obtaining ship repair costs according to claim 4, characterized in that: The method of displaying the ship repair cost output item as a report and / or icon result comprises the following steps: Get the login user information sent by the terminal device; Acquire the job position information of the logged-in user from the information of the logged-in user; Get the access permission of the logged-in user according to the job information of the logged-in user; Extracting the corresponding output item of the ship repair cost according to the review authority; Displaying the extracted ship repair cost output items as report forms and / or graphic results; The report and / or icon is sent to the terminal device.

6. A ship repair cost acquisition system, characterized in that: include: a database search module, which searches an Oracle database storing the ship repair cost according to a preset ship repair cost input item; if data corresponding to the ship repair cost input item is retrieved from the Oracle database, the retrieved data is recorded in the ship repair cost input item, and the ship repair cost input item for which the data is obtained is marked as a first input item; if data corresponding to the ship repair cost input item cannot be retrieved from the Oracle database, the corresponding ship repair cost input item is marked as a second input item; A data warehouse search module, which searches for entries in a preset data warehouse according to the second input item; If warehouse data corresponding to the second input item is retrieved in the data warehouse, the update time of the warehouse data is obtained, and if the difference between the update time and the real time is less than a preset first threshold, the warehouse data is recorded in the second input item; If the difference between the update time and the real-time time is greater than or equal to the first threshold, the real-time data of the ship repair data registration system corresponding to the warehouse data is counted through a preset conversion template, the warehouse data is updated according to the real-time data, and the updated warehouse data is recorded in the second input item; The warehouse data is the data obtained and stored by the data warehouse after systematic processing, aggregation and arrangement based on the extraction and cleaning of the original scattered database data; An output item value acquisition module is used to input a corresponding ship repair cost input item into a preset ship repair cost model to obtain a value of a corresponding ship repair cost output item; wherein the ship repair cost model includes a calculation model rule between the ship repair cost input item and the ship repair cost output item; The display module displays the output items of the ship repair cost as reports and / or icon results.

7. A ship repair cost acquisition system according to claim 6, characterized in that: It also includes a data missing report module: if the warehouse data corresponding to the second input item cannot be retrieved in the data warehouse, the second input item is marked as a third input item, and the ship repair cost model related to the third input item is searched, and a data missing report is generated for the third input item and the related ship repair cost model and displayed.

8. A ship repair cost acquisition system according to claim 7, characterized in that: The conversion template includes the following submodules: A first data acquisition submodule is used to acquire data types of warehouse data of the data warehouse and preset associated words corresponding to the data types; The second data acquisition submodule acquires a statistical template of each ship repair acquisition system, wherein the statistical template includes a data item name of the corresponding ship repair acquisition system and statistical data corresponding to the data item name; An associated word search submodule performs an associated word search on the data item name of the statistical template, and associates the data item name with the data type of the warehouse data according to the search result; The data preservation submodule obtains and preserves the related data item names, data types, statistical data corresponding to the data item names, and conversion coefficients of warehouse data corresponding to the data types.

Images