Crude oil data standardization processing method, system and equipment and storage medium
By constructing a crude oil molecular database and standardizing the processing, the problem of inconsistent crude oil data format is solved, unified data management and efficient query are realized, and work efficiency is improved.
Patent Information
- Application Number
- CN202311466516.0
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2023-11-06
- Publication Date
- 2025-05-06
AI Technical Summary
The format of crude oil data in different application fields is not uniform, which leads to difficulties in data management and query and affects work efficiency.
By constructing a crude oil molecular database, using standardized processing methods, the data format of the crude oil data to be entered is compared with the preset format, standardized processing is carried out, and the processed data is entered into the database.
It realizes unified and standardized processing of crude oil data, simplifies data management and query, improves work efficiency, and promotes the development of crude oil molecular management technology.
Smart Images

Figure CN119938744A_ABST
Abstract
Description
Technical Field
[0001] The present invention belongs to the field of crude oil data processing, and in particular relates to a crude oil data standardization processing method, system, equipment and storage medium. Background Art
[0002] People are used to calling unprocessed petroleum crude oil. Crude oil is a dark brown viscous oily liquid with green fluorescence and a special smell. It is a mixture of various liquid hydrocarbons such as alkanes, cycloalkanes, aromatic hydrocarbons and olefins.
[0003] Crude oil contains hundreds of different types of hydrocarbons, all mixed together. When using it, it is often necessary to separate the different types of hydrocarbons to extract the useful substances from them. In the prior art, oil refining is generally used for refining. The oil refining process starts with a fractionation column. As the length of the hydrocarbon chain increases, its boiling point will gradually increase, so it can be separated by distillation. This is what happens in the refinery - in one part of the refining process, the crude oil is heated, and at different evaporation temperatures, hydrocarbon chains of different lengths will be separated. Each chain of different lengths has different properties and corresponds to different uses. Commonly used gasoline, kerosene, diesel, etc. are all refined from crude oil.
[0004] As for the use of crude oil in different fields, the format of crude oil data is also different, and there is no unified standard. For example, the same crude oil data has different names in different application fields, or the same crude oil data has different units in different application fields, resulting in large differences in values. When unified management is required or staff need to query data, there is a problem of inconsistent data formats and difficulty in access and management. Summary of the invention
[0005] In view of the above problems, the technical solution adopted by the present invention is: a method for standardizing crude oil data, comprising the following steps:
[0006] Compare the data format of the crude oil data to be entered with the data format preset in the crude oil molecule database to determine whether the data formats are the same;
[0007] The crude oil molecule database is constructed through the following steps:
[0008] Prepare crude oil macroscopic physical property form and crude oil microscopic composition form according to the preset data format;
[0009] Correlate the crude oil macroscopic physical property table and the crude oil microscopic composition table to obtain a wax oil molecule database;
[0010] When the comparison results are different, the input crude oil data is standardized according to the data format preset in the crude oil molecule data;
[0011] The standardized crude oil data to be entered is entered into the crude oil molecule database, including:
[0012] Extracting the type of crude oil to be recorded from the crude oil data to be recorded;
[0013] Input the crude oil type to be entered into the crude oil molecule database;
[0014] Determine whether the crude oil type to be entered exists in the crude oil molecule database;
[0015] If it does not exist, a crude oil data storage template file with a preset data format is created in the crude oil molecule database, and the crude oil data to be entered is input into the newly created crude oil data storage template file;
[0016] If it exists, the crude oil data storage template file corresponding to the crude oil type to be entered is searched in the crude oil molecule database, and the crude oil data to be entered is input into the corresponding crude oil data storage template file.
[0017] Optionally, a vocabulary is provided in the crude oil molecule database; the step of standardizing the input crude oil data includes:
[0018] Input the name of each data item in the crude oil data to be entered into the vocabulary, and obtain the standard name corresponding to each data item in the vocabulary of the crude oil molecule database;
[0019] Modify each item of data to be entered into the crude oil data according to the obtained standard name.
[0020] Optionally, a unit conversion model is also provided in the crude oil molecule database; and the step of standardizing the input crude oil data further includes:
[0021] Input the values and units of various data in the crude oil data to be entered into the unit conversion model;
[0022] Based on the numerical standard units of various data, the numerical values of various data to be entered in the crude oil data are converted through a unit conversion model.
[0023] Optionally, the method further comprises the following steps:
[0024] If the data formats are the same, the crude oil data to be entered without standardization will be entered into the crude oil molecule database.
[0025] Optionally, each existing crude oil type in the crude oil molecule database includes multiple names; the step of determining whether there is a crude oil type to be entered in the crude oil molecule database includes:
[0026] Compare the names of the crude oil types to be entered with the existing crude oil types in the crude oil molecule database;
[0027] If the comparison result is that the name of the crude oil type to be entered is consistent with the name of the crude oil type already in the crude oil molecule database, it is determined that the crude oil type to be entered exists in the crude oil molecule database;
[0028] If the comparison result is that the name of the crude oil type to be entered is inconsistent with the names of the crude oil types already in the crude oil molecule database, it is determined that the crude oil type to be entered does not exist in the crude oil molecule database.
[0029] Optionally, the crude oil data to be entered include crude oil macroscopic physical property data and / or crude oil microscopic composition data; wherein,
[0030] The macroscopic physical property data of crude oil include physical properties of crude oil itself, properties of narrow fractions of crude oil, properties of naphtha fraction of crude oil, properties of kerosene fraction of crude oil, properties of diesel fraction of crude oil, properties of wax oil fraction of crude oil, properties of regular residue fraction of crude oil, properties of reduced residue fraction of crude oil, fraction volume yield information, and fraction mass yield information;
[0031] The crude oil microscopic composition data includes crude oil molecular composition, which includes crude oil molecules represented in the form of structure vectors and the corresponding content ratio of each crude oil molecule.
[0032] Optionally, the macroscopic physical property data of crude oil is obtained by an analytical detection method, and the molecular composition of crude oil is obtained by a molecular composition analysis method or an analytical detection method.
[0033] And, a crude oil data standardization processing system, comprising:
[0034] A format determination module is used to compare the data format of the crude oil data to be entered with the data format preset in the crude oil molecule database to determine whether the data formats are the same;
[0035] A data processing module, used for standardizing the input crude oil data according to the data format preset in the crude oil molecule data when the format judgment module judges that the data format is different;
[0036] The data entry module is used to enter the crude oil data to be entered after standardization into the crude oil molecule database.
[0037] Optionally, it also includes a crude oil molecular database creation module, which is used to prepare a crude oil macroscopic property form and a crude oil microscopic composition form according to a preset data format, and to relate the crude oil macroscopic property form and the crude oil microscopic composition form to each other to construct a crude oil molecular database.
[0038] Optionally, the crude oil molecule database is provided with a vocabulary, a name replacement model and a unit conversion model; wherein,
[0039] The name replacement model is used to replace the name of each data item to be input into the crude oil data according to the standard name of each data item in the vocabulary;
[0040] The unit conversion model is used to convert the values of various data in the crude oil data to be entered according to the standard units of the values of various data.
[0041] Optionally, the data entry module is further configured to enter the crude oil data to be entered that has not been standardized into the crude oil molecule database when the format determination module determines that the data formats are the same.
[0042] Optionally, when the data entry module enters the standardized crude oil data to be entered into the crude oil molecule database, it includes:
[0043] Extracting the type of crude oil to be recorded from the crude oil data to be recorded;
[0044] Input the crude oil type to be entered into the crude oil molecule database;
[0045] Determine whether the crude oil type to be entered exists in the crude oil molecule database;
[0046] If it does not exist, a crude oil data storage template file with a preset data format is created in the crude oil molecule database, and the crude oil data to be entered is input into the newly created crude oil data storage template file;
[0047] If it exists, the crude oil data storage template file corresponding to the crude oil type to be entered is searched in the crude oil molecule database, and the crude oil data to be entered is input into the corresponding crude oil data storage template file.
[0048] Optionally, the crude oil data to be entered include crude oil macroscopic physical property data and / or crude oil microscopic composition data; wherein,
[0049] The macroscopic physical property data of crude oil include physical properties of crude oil itself, properties of narrow fractions of crude oil, properties of naphtha fraction of crude oil, properties of kerosene fraction of crude oil, properties of diesel fraction of crude oil, properties of wax oil fraction of crude oil, properties of regular residue fraction of crude oil, properties of reduced residue fraction of crude oil, fraction volume yield information, and fraction mass yield information;
[0050] The crude oil microscopic composition data includes crude oil molecular composition, which includes crude oil molecules represented in the form of structure vectors and the corresponding content ratio of each crude oil molecule.
[0051] And, a crude oil data standardization processing device, comprising a processor, a communication interface and a memory; wherein,
[0052] Memory is used to store computer programs;
[0053] The processor is used to execute the computer program stored in the memory to implement the above-mentioned crude oil data standardization processing method.
[0054] And, a computer-readable storage medium, wherein the computer-readable storage medium stores one or more programs, and the one or more programs can be executed by one or more processors to implement the steps of the above-mentioned crude oil data standardization processing method.
[0055] The present invention adopts the above technical solution, so that it has the following beneficial effects: by adopting the method of unified management of crude oil molecule database, crude oil data of different data formats are uniformly standardized, which is convenient for staff to manage or query, thereby improving work efficiency. And the structure of standard data is conducive to the development of various simulation calculation programs, and the rapid realization of data mutual call between different program models, promoting the development of crude oil molecule management technology.
[0056] Other features and advantages of the present invention will be described in the following description, and partly become apparent from the description, or understood by practicing the present invention. The purpose and other advantages of the present invention can be realized and obtained by the structures pointed out in the description, claims and drawings. BRIEF DESCRIPTION OF THE DRAWINGS
[0057] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the following briefly introduces the drawings required for use in the embodiments or the description of the prior art. Obviously, the drawings described below are some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.
[0058] Figure 1 A flowchart showing the steps of a crude oil data standardization processing method according to an embodiment of the present invention is shown;
[0059] Figure 2 A module diagram of a crude oil data standardization processing system according to an embodiment of the present invention is shown;
[0060] Figure 3 A structural diagram of a crude oil data standardization processing device according to an embodiment of the present invention is shown. DETAILED DESCRIPTION
[0061] In order to make the purpose, technical solution and advantages of the embodiments of the present invention clearer, the technical solution in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are 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.
[0062] like Figure 1 The crude oil data standardization processing method according to the embodiment of the present invention comprises the following steps:
[0063] S1: Compare the data format of the crude oil data to be entered with the data format preset in the crude oil molecule database to determine whether the data formats are the same:
[0064] If the data formats are different, execute step S2;
[0065] If the data formats are the same, execute step S4;
[0066] S2: Standardize the input crude oil data according to the preset data format;
[0067] S3: Enter the standardized crude oil data to be entered into the crude oil molecule database.
[0068] S4: Enter the crude oil data that has not been standardized into the crude oil molecule database.
[0069] In this embodiment, the crude oil data to be entered include crude oil macroscopic physical property data and / or crude oil microscopic composition data; wherein, the crude oil macroscopic physical property data include the physical properties of the crude oil itself, the narrow fraction properties of the crude oil, the naphtha fraction properties of the crude oil, the kerosene fraction properties of the crude oil, the diesel fraction properties of the crude oil, the wax oil fraction properties of the crude oil, the regular residue fraction properties of the crude oil, the reduced residue fraction properties of the crude oil, the fraction volume yield information, the fraction mass yield information, etc.; the crude oil microscopic composition data include the crude oil molecular composition, and the crude oil molecular composition includes crude oil molecules represented in the form of structural vectors, and the corresponding content proportion of each crude oil molecule (percentage content is used in this embodiment).
[0070] Among them, the macroscopic physical property data of crude oil is obtained by analytical detection methods, and the molecular composition of crude oil is obtained by analytical methods or analytical detection methods. Among them, the analytical detection method can be performed by instruments, and the molecular composition analyzed by instruments is more accurate, but it takes more time and costs more; the analytical method is to analyze the molecular composition through macroscopic physical properties, and the method of model analysis is low-cost and time-consuming, but due to the characteristics of the model itself, the accuracy is low. For example, for some typical crude oils or representative crude oils, the macroscopic physical property data of crude oil and the molecular composition information of crude oil can be obtained by analytical detection methods; for other crude oils, the macroscopic physical property data of crude oil and the molecular composition of crude oil are obtained by analytical detection methods and analytical methods, respectively.
[0071] In this embodiment, the crude oil molecule database is constructed by the following steps:
[0072] S01: Prepare a crude oil macroscopic physical property form and a crude oil microscopic composition form according to a preset data format;
[0073] S02: Correlate the crude oil macroscopic physical property form and the crude oil microscopic composition form to obtain a crude oil molecular database.
[0074] In step S01, the crude oil macroscopic physical property form may be one form or multiple forms. That is, the physical properties of the crude oil itself, the narrow fraction properties of the crude oil, the naphtha fraction properties of the crude oil, the kerosene fraction properties of the crude oil, the diesel fraction properties of the crude oil, the wax oil fraction properties of the crude oil, the normal residue fraction properties of the crude oil, the reduced residue fraction properties of the crude oil, the fraction volume yield information, the fraction mass yield information, etc. may be placed on the same form, or one physical property may be placed on one form.
[0075] Preferably, the crude oil macroscopic physical property form and the crude oil microscopic composition form may also include modification date (or entry date), code, description information, remarks, etc.
[0076] It should be noted that, in the step of entering the crude oil data to be entered into the crude oil molecule database in step S3, if some crude oil macroscopic property data corresponding to the crude oil macroscopic property table in the crude oil data to be entered are missing, the corresponding items will be left blank.
[0077] In step S01, the preset data format includes the standard name and numerical standard unit of each crude oil data.
[0078] Specifically, the standard names and numerical standard units of various crude oil data in the crude oil molecule database are as follows:
[0079] The physical properties of crude oil are shown in Table 1:
[0080] Table 1
[0081]
[0082]
[0083] The properties of crude oil narrow fractions are shown in Table 2:
[0084] Table 2
[0085]
[0086]
[0087] The properties of naphtha fractions include: TBP initial distillation point (℃), TBP final distillation point (℃), fraction volume yield (%), fraction weight yield (%), 20℃ density (g / cm 3 ), acid value (mgKOH / g), acidity (mgKOH / 100mL), sulfur content (wt%), total nitrogen content (ppm), aniline point (℃), K value, related index, Raegle vapor pressure (kpa), mercaptan sulfur content (ppm), copper rot, modified olefin content (wt%), aromatic mass content (wt%), cycloalkane content (wt%), normal alkane (wt%), isoalkane (wt%), arsenic (ppb), lead (ppb), copper (ppm), moisture (wt%), benzene content (wt%), research octane number, Engler distillation initial distillation point (℃), 10% distillation temperature (℃) (recorded as distillation range: 10%, ℃ (℃)), 30% distillation temperature (℃) (recorded as distillation range: 30%, ℃ (℃)), 40 % distillation temperature (℃) (recorded as distillation range: 40%, ℃ (℃)), 50% distillation temperature (℃) (recorded as distillation range: 50%, ℃ (℃)), 70% distillation temperature (℃) (recorded as distillation range: 70%, ℃ (℃)), 90% distillation temperature (℃) (recorded as distillation range: 90%, ℃ (℃)), Englert distillation end point (℃), basic nitrogen content (ppm), average molecular weight (g / mol), paraffin mass content (wt%), alkane content (wt%), actual colloid (mg / 100mL), H content (wt%), C content (wt%), carbon-hydrogen ratio, chlorine (ppm), alkane volume content (v%), paraffin volume content (v%), cycloalkane volume content (v%), olefin volume content (v%), aromatic potential (%);
[0088] The properties of kerosene fractions include: TBP initial distillation point (℃), TBP final distillation point (℃), fraction volume yield (%), fraction weight yield (%), 20℃ density (g / cm 3 ), API degree, -20℃ kinematic viscosity (mm 2 / s), 20℃ kinematic viscosity (mm 2 / s), 40℃ kinematic viscosity (mm 2 / s), refractive index at 20℃, freezing point (℃), pour point (℃), acid value (mgKOH / g), acidity (mgKOH / 100mL), sulfur content (wt%), total nitrogen content (ppm), freezing point (℃), smoke point (mm), net calorific value (kJ / kg), Saybolt color, hexadecane index, diesel index, benzene content (wt%), aniline point (℃), K value, related index, closed cup flash point (℃), arsenic (ppb), mercaptan sulfur content (ppm), copper corrosion, modify and increase saturated hydrocarbon mass content (wt%), olefin content (wt%), aromatic hydrocarbon mass content (wt%), normal alkane (wt%), alkane volume content (v%), paraffin volume content (v%), cycloalkane volume content (v%), aromatic hydrocarbon volume content (v%), olefin volume content (v%), Englert distillation initial distillation point (℃), 10% distillation temperature (℃) (recorded as distillation range: 10%, ℃ (℃)), 30% distillation temperature (℃) (recorded as distillation range: 30%, ℃ (℃)), 40% distillation temperature (℃) (recorded as distillation range: 40%, ℃ (℃)), 50% distillation temperature (℃) (recorded as distillation range: 50%, ℃ (℃)), 70% distillation temperature (℃) (recorded as distillation range: 70%, ℃ (℃)), 90% distillation temperature (℃) (recorded as distillation range: 90%, ℃ (℃)), 95% distillation temperature (℃) (recorded as distillation range: 95%, ℃ (℃)), Englert distillation final distillation point (℃), dry point corresponding to distillation volume (v%), basic nitrogen content (ppm), cold filter point (℃), crystallization point (℃), H content (wt%), C content (wt%);
[0089] Diesel fraction properties include: TBP initial distillation point (℃), TBP final distillation point (℃), fraction volume yield (%), fraction weight yield (%), API degree, 20℃ density (g / cm 3 ), 20℃ kinematic viscosity (mm 2 / s), 40℃ kinematic viscosity (mm 2 / s), freezing point (℃), pour point (℃), acid value (mgKOH / g), acidity (mgKOH / 100mL), sulfur content (wt%), total nitrogen content (ppm), cold filter point (℃), color (D1500), copper corrosion, modified to increase aniline point (℃), K value, related index, closed cup flash point (℃), aromatic mass content (wt%), Engelhard distillation initial distillation point (℃), 10% distillation temperature (℃) (recorded as distillation range: 10%, ℃ (℃)), 30% distillation temperature (℃) (recorded as distillation range: 30%, ℃ (℃)), 40% distillation temperature (℃) (recorded as distillation range: 40%, ℃ (℃)), 50% distillation temperature ( ℃) (recorded as distillation range: 50%, ℃ (℃)), 70% distillation temperature (℃) (recorded as distillation range: 70%, ℃ (℃)), 90% distillation temperature (℃) (recorded as distillation range: 90%, ℃ (℃)), 95% distillation temperature (℃) (recorded as distillation range: 95%, ℃ (℃)), 98% distillation temperature (℃) (recorded as distillation range: 98%, ℃ (℃)), Englert distillation end point (℃), basic nitrogen content (ppm), 20℃ refractive index, 70℃ refractive index, cetane number, diesel index, cetane index, average molecular weight (g / mol), bromine value (gBr / 100mL), H content (wt%), C content (wt%);
[0090] The properties of wax oil fractions include: TBP initial distillation point (℃), TBP final distillation point (℃), fraction volume yield (%), fraction weight yield (%), API degree, 20℃ density (g / cm 3 ), 70℃ density (g / cm3), 40℃ kinematic viscosity (mm 2 / s), 80℃ kinematic viscosity (mm 2 / s), 100℃ kinematic viscosity (mm 2 / s), freezing point (℃), pour point (℃), acid value (mgKOH / g), acidity (mgKOH / 100mL), sulfur content (wt%), total nitrogen content (ppm), refractive index at 20℃, refractive index at 70℃, H content (wt%), C content (wt%), RT (total number of rings), RA (number of aromatic rings), RN (number of cycloalkane rings), number of aromatic C atoms, number of paraffin C atoms, number of cycloalkane C atoms, Englert distillation initial distillation point (℃), 10% distillation temperature (℃) (recorded as distillation range: 10%, ℃ (℃)), 30% distillation temperature (℃) (recorded as distillation range: 30%, ℃ (℃)), 50% distillation temperature (℃) (recorded as distillation range: 50%, ℃ (℃)), 70% distillation temperature (℃) (recorded as distillation range: 70%, ℃ (℃)), 90% distillation temperature ( ℃) (recorded as distillation range: 90%, ℃ (℃)), 95% distillation temperature (℃) (recorded as distillation range: 95%, ℃ (℃)), Englert distillation end point (℃), basic nitrogen content (ppm), average molecular weight (g / mol), viscosity constant, correlation index, K value, paraffin mass content (wt%), cycloparaffin mass content (wt%), saturated hydrocarbon mass content (wt%), aromatic hydrocarbon mass content (wt%), colloid (wt%), asphaltene content (wt%), iron (ppm), copper (ppm), sodium (ppm), nickel (ppm), vanadium (ppm), calcium (ppm), wax content (wt%), ash (wt%), Conradson residual carbon (wt%), paraffin volume content (v%), cycloparaffin volume content (v%), aromatic hydrocarbon volume content (v%);
[0091] The properties of the common slag fractions are shown in Table 3:
[0092] Table 3
[0093]
[0094]
[0095]
[0096] The properties of the reduced slag fraction are shown in Table 4:
[0097] Table 4
[0098]
[0099]
[0100] The fraction volume yield table records the cumulative yield of crude oil distilled at every 10°C. The system's arbitrary temperature fraction cutting function uses this data as the basis for estimating the volume yield.
[0101] The fraction mass yield table records the cumulative mass yield of crude oil at every 10°C. The system's arbitrary temperature fraction cutting function uses this data as the basis for estimating the mass yield.
[0102] The molecular composition of crude oil includes: the types of crude oil molecules represented by structural vectors, and the percentage content of the corresponding molecules. Specifically, there are a variety of crude oil molecules represented by 24 structural vectors (groups), and the corresponding percentage content of each crude oil molecule.
[0103] Correspondingly, the crude oil molecule database constructed by step S01 and step S02 includes a vocabulary for storing standard names and a unit conversion model for standard unit conversion.
[0104] Based on the above, in step S2, the step of standardizing the input crude oil data according to the standard name in the preset data format is specifically as follows:
[0105] S11: inputting the name of each data item in the crude oil data to be entered into the vocabulary, and obtaining the standard name corresponding to each data item in the vocabulary of the crude oil molecule database;
[0106] S12: Modify each item of data to be entered in the crude oil data according to the obtained standard name.
[0107] Furthermore, according to the numerical standard unit in the preset data format, the step of standardizing the data format of the crude oil data to be input is specifically as follows:
[0108] S21: inputting the values and units of various data in the crude oil data to be entered into the unit conversion model;
[0109] S22: Based on the numerical standard units of various data, the numerical values of various data in the crude oil data to be input are converted through a unit conversion model.
[0110] In step S3 and step S4, the crude oil data to be entered after / without standardization is entered into the crude oil molecule database as follows:
[0111] S31: extracting the type of crude oil to be recorded from the crude oil data to be recorded;
[0112] S32: inputting the crude oil type to be entered into the crude oil molecule database;
[0113] S33: Determine whether there is a crude oil type to be entered in the crude oil molecule database:
[0114] Among them, each existing crude oil type in the crude oil molecule database includes multiple names to ensure that all existing names are included to avoid misjudgment; in the step of judging whether there is a crude oil type to be entered in the crude oil molecule database, specifically: the name of the crude oil type to be entered is compared with the crude oil type already in the crude oil molecule database, including the following two situations:
[0115] If the comparison result is that the name of the crude oil type to be entered is consistent with a name of a crude oil type already in the crude oil molecule database, it is determined that the crude oil type to be entered exists in the crude oil molecule database, and step S35 is executed;
[0116] If the comparison result is that the name of the crude oil type to be entered is inconsistent with the name of the crude oil type already in the crude oil molecule database, it is determined that the crude oil type to be entered does not exist in the crude oil molecule database, and step S34 is executed.
[0117] S34: creating a crude oil data storage template file with a preset data format in the crude oil molecule database, and inputting the crude oil data to be entered into the newly created crude oil data storage template file;
[0118] S35: searching the crude oil molecule database for a crude oil data storage template file corresponding to the crude oil type to be entered, and inputting the crude oil data to be entered into the corresponding crude oil data storage template file to update the corresponding crude oil data storage template file.
[0119] Through the above method, various types of crude oil data to be entered or obtained from different channels are standardized for unified management.
[0120] In combination with the above-mentioned crude oil data standardization processing method, a crude oil data standardization processing system according to an embodiment of the present invention is further provided. Figure 2 The crude oil data standardization processing system module diagram shown includes a format judgment module, a data processing module and a data entry module. Specifically,
[0121] The format determination module is used to compare the data format of the crude oil data to be entered with the data format preset in the crude oil molecule database to determine whether the data formats are the same;
[0122] The data processing module is used to standardize the input crude oil data according to the preset data format in the crude oil molecule data when the format judgment module determines that the data format is different; in this embodiment, the crude oil molecule database is also provided with a vocabulary, a name replacement model and a unit conversion model; wherein the name replacement model is used to replace the name of each data item of the input crude oil data according to the standard name of each data item in the vocabulary; the unit conversion model is used to convert the value of each data item in the input crude oil data according to the standard unit of the value of each data item;
[0123] The data entry module is used to enter the standardized / unstandardized crude oil data to be entered into the crude oil molecule database.
[0124] In this embodiment, the system also includes: a crude oil molecular database creation module, which is used to create a crude oil molecular database. The specific steps are: preparing a crude oil macroscopic physical property form and a crude oil microscopic composition form according to a preset data format, and associating the crude oil macroscopic physical property form and the crude oil microscopic composition form to obtain a crude oil molecular database.
[0125] The implementation process of the functions and effects of each module unit in this system is specifically described in the implementation process of the corresponding steps in the above method, which will not be repeated here.
[0126] Based on the same inventive concept, Figure 3 The crude oil data standardization processing device structure diagram shown in the figure, the embodiment of the present invention provides a crude oil data standardization processing device, including a processor 1110, a communication interface 1120, a memory 1130 and a communication bus 1140, wherein the processor 1110, the communication interface 1120, and the memory 1130 communicate with each other through the communication bus 1140;
[0127] Memory 1130, used for storing computer programs;
[0128] The processor 1110 is used to implement the crude oil data standardization processing method as shown below when executing the program stored in the memory 1130:
[0129] Compare the data format of the crude oil data to be entered with the data format preset in the crude oil molecule database to determine whether the data formats are the same;
[0130] If the data format of the crude oil data to be entered is different from the preset data format, the crude oil data to be entered is standardized according to the preset data format, and the standardized crude oil data to be entered is entered into the crude oil molecule database.
[0131] The communication bus 1140 may be a Peripheral Component Interconnect (PCI) bus or an Extended Industry Standard Architecture (EISA) bus, etc. The communication bus 1140 may be divided into an address bus, a data bus, a control bus, etc. For ease of representation, only one thick line is used in the figure, but it does not mean that there is only one bus or one type of bus.
[0132] The communication interface 1120 is used for communication between the above electronic device and other devices.
[0133] The memory 1130 may include a random access memory (RAM) or a non-volatile memory, such as at least one disk memory. Optionally, the memory 1130 may also be at least one storage device located away from the processor 1110.
[0134] The above-mentioned processor 1110 can be a general-purpose processor, including a central processing unit (CPU), a network processor (NP), etc.; it can also be a digital signal processor (DSP), an application specific integrated circuit (ASIC), a field programmable gate array (FPGA) or other programmable logic devices, discrete gates or transistor logic devices, discrete hardware components.
[0135] Based on the same inventive concept, an embodiment of the present invention provides a computer-readable storage medium, which stores one or more programs. The one or more programs can be executed by one or more processors to implement the steps of the crude oil data standardization processing method in any possible implementation method mentioned above.
[0136] Alternatively, the storage medium may be a non-transitory computer-readable storage medium, for example, the non-transitory computer-readable storage medium may be a ROM, a random access memory (RAM), a CD-ROM, a magnetic tape, a floppy disk, an optical data storage device, and the like.
[0137] Based on the same inventive concept, an embodiment of the present invention further provides a computer program product, including a computer program, which, when executed by a processor, implements the steps of the crude oil data standardization processing method in any possible implementation manner described above.
[0138] In the above embodiments, it can be implemented in whole or in part by software, hardware, firmware or any combination thereof. When implemented using software, it can be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer instructions. When the computer program instructions are loaded and executed on a computer, the process or function according to the embodiment of the present invention is generated in whole or in part. The computer can be a general-purpose computer, a special-purpose computer, a computer network, or other programmable devices. The computer instructions can be stored in a computer-readable storage medium, or transmitted from one computer-readable storage medium to another computer-readable storage medium. For example, the computer instructions can be transmitted from a website site, a computer, a server or a data center by wired (e.g., coaxial cable, optical fiber, digital subscriber line (DSL)) or wireless (e.g., infrared, wireless, microwave, etc.) mode to another website site, computer, server or data center. The computer-readable storage medium can be any available medium that a computer can access or a data storage device such as a server or a data center that includes one or more available media integration. The available medium can be a magnetic medium (e.g., a floppy disk, a hard disk, a tape), an optical medium (e.g., a DVD), or a semiconductor medium (e.g., a solid-state hard disk Solid State Disk (SSD)), etc. The above is only a preferred embodiment of the present invention, and does not limit the present invention in any form. Although the present invention has been disclosed as a preferred embodiment as above, it is not used to limit the present invention. Any technician familiar with this profession can make some changes or modifications to equivalent embodiments of equivalent changes using the technical contents disclosed above without departing from the scope of the technical solution of the present invention. However, any simple modification, equivalent change and modification made to the above embodiments based on the technical essence of the present invention without departing from the content of the technical solution of the present invention still fall within the scope of the technical solution of the present invention.
Claims
1. A method for standardizing crude oil data, characterized in that: The following steps are involved: Compare the data format of the crude oil data to be entered with the data format preset in the crude oil molecule database to determine whether the data formats are the same; The crude oil molecule database is constructed through the following steps: Prepare crude oil macroscopic physical property form and crude oil microscopic composition form according to the preset data format; Correlate the crude oil macroscopic physical property table and the crude oil microscopic composition table to obtain a crude oil molecular database; When the comparison results are different, the input crude oil data is standardized according to the data format preset in the crude oil molecule data; The standardized crude oil data to be entered is entered into the crude oil molecule database, including: Extracting the type of crude oil to be recorded from the crude oil data to be recorded; Input the crude oil type to be entered into the crude oil molecule database; Determine whether the crude oil type to be entered exists in the crude oil molecule database; If it does not exist, a crude oil data storage template file with a preset data format is created in the crude oil molecule database, and the crude oil data to be entered is input into the newly created crude oil data storage template file; If it exists, the crude oil data storage template file corresponding to the crude oil type to be entered is searched in the crude oil molecule database, and the crude oil data to be entered is input into the corresponding crude oil data storage template file.
2. The crude oil data standardization processing method according to claim 1, characterized in that: The crude oil molecule database is provided with a vocabulary; the steps of standardizing the input crude oil data include: Input the name of each data item in the crude oil data to be entered into the vocabulary, and obtain the standard name corresponding to each data item in the vocabulary of the crude oil molecule database; Modify each item of data to be entered into the crude oil data according to the obtained standard name.
3. The crude oil data standardization processing method according to claim 1, characterized in that: The crude oil molecule database also has a unit conversion model; The steps for standardizing the input crude oil data also include: Input the values and units of various data in the crude oil data to be entered into the unit conversion model; Based on the numerical standard units of various data, the numerical values of various data to be entered in the crude oil data are converted through a unit conversion model.
4. The crude oil data standardization processing method according to claim 1, characterized in that: The following steps are also included: If the data formats are the same, the crude oil data to be entered without standardization will be entered into the crude oil molecule database.
5. The crude oil data standardization processing method according to claim 1, characterized in that: Each existing crude oil type in the crude oil molecule database includes multiple names; the step of determining whether there is a crude oil type to be entered in the crude oil molecule database includes: Compare the names of the crude oil types to be entered with the existing crude oil types in the crude oil molecule database; If the comparison result is that the name of the crude oil type to be entered is consistent with the name of the crude oil type already in the crude oil molecule database, it is determined that the crude oil type to be entered exists in the crude oil molecule database; If the comparison result is that the name of the crude oil type to be entered is inconsistent with the names of the crude oil types already in the crude oil molecule database, it is determined that the crude oil type to be entered does not exist in the crude oil molecule database.
6. The crude oil data standardization processing method according to any one of claims 1 to 5, characterized in that: The crude oil data to be entered include crude oil macroscopic physical property data and / or crude oil microscopic composition data; among which, The macroscopic physical property data of crude oil include physical properties of crude oil itself, properties of narrow fractions of crude oil, properties of naphtha fraction of crude oil, properties of kerosene fraction of crude oil, properties of diesel fraction of crude oil, properties of wax oil fraction of crude oil, properties of regular residue fraction of crude oil, properties of reduced residue fraction of crude oil, fraction volume yield information, and fraction mass yield information; The crude oil microscopic composition data includes crude oil molecular composition, which includes crude oil molecules represented in the form of structure vectors and the corresponding content ratio of each crude oil molecule.
7. The crude oil data standardization processing method according to claim 6, characterized in that: The macroscopic physical property data of the crude oil are obtained by an analytical detection method, and the molecular composition of the crude oil is obtained by a molecular composition analysis method or an analytical detection method.
8. A crude oil data standardization processing system, characterized in that: include: A format determination module is used to compare the data format of the crude oil data to be entered with the data format preset in the crude oil molecule database to determine whether the data formats are the same; A data processing module, used for standardizing the input crude oil data according to the data format preset in the crude oil molecule data when the format judgment module judges that the data format is different; The data entry module is used to enter the crude oil data to be entered after standardization into the crude oil molecule database.
9. The crude oil data standardization processing system according to claim 8, characterized in that: It also includes a crude oil molecular database creation module, which is used to prepare crude oil macroscopic physical property forms and crude oil microscopic composition forms according to a preset data format, and to relate the crude oil macroscopic physical property forms and crude oil microscopic composition forms to each other to construct a crude oil molecular database.
10. The crude oil data standardization processing system according to claim 8, characterized in that: The crude oil molecule database is provided with a vocabulary, a name replacement model and a unit conversion model; wherein, The name replacement model is used to replace the name of each data item to be input into the crude oil data according to the standard name of each data item in the vocabulary; The unit conversion model is used to convert the values of various data in the crude oil data to be entered according to the standard units of the values of various data.
11. The crude oil data standardization processing system according to claim 8, characterized in that: The data entry module is also used to enter the crude oil data to be entered without standardization into the crude oil molecule database when the format judgment module determines that the data formats are the same.
12. The crude oil data standardization processing system according to claim 8, characterized in that: When the data entry module enters the standardized crude oil data to be entered into the crude oil molecule database, it includes: Extracting the type of crude oil to be recorded from the crude oil data to be recorded; Input the crude oil type to be entered into the crude oil molecule database; Determine whether the crude oil type to be entered exists in the crude oil molecule database; If it does not exist, a crude oil data storage template file with a preset data format is created in the crude oil molecule database, and the crude oil data to be entered is input into the newly created crude oil data storage template file; If it exists, the crude oil data storage template file corresponding to the crude oil type to be entered is searched in the crude oil molecule database, and the crude oil data to be entered is input into the corresponding crude oil data storage template file.
13. The crude oil data standardization processing system according to any one of claims 8 to 12, characterized in that: The crude oil data to be entered include crude oil macroscopic physical property data and / or crude oil microscopic composition data; among which, The macroscopic physical property data of crude oil include physical properties of crude oil itself, properties of narrow fractions of crude oil, properties of naphtha fraction of crude oil, properties of kerosene fraction of crude oil, properties of diesel fraction of crude oil, properties of wax oil fraction of crude oil, properties of regular residue fraction of crude oil, properties of reduced residue fraction of crude oil, fraction volume yield information, and fraction mass yield information; The crude oil microscopic composition data includes crude oil molecular composition, which includes crude oil molecules represented in the form of structure vectors and the corresponding content ratio of each crude oil molecule.
14. A crude oil data standardization processing device, characterized in that: It includes a processor, a communication interface and a memory; wherein, Memory is used to store computer programs; The processor is used to execute the computer program stored in the memory to implement the crude oil data standardization processing method described in any one of claims 1-7.
15. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores one or more programs, and the one or more programs can be executed by one or more processors to implement the steps of the crude oil data standardization processing method described in any one of claims 1-7.