CN117827799A

CN117827799A - Database establishment method and device, computer equipment and storage medium

Info

Publication number: CN117827799A
Application number: CN202311868512.5A
Authority: CN
Inventors: 胡纯; 杨铁成; 沙洪伟; 王钰
Original assignee: Beijing Branch Of China Guanghe Digital Technology Co ltd; Guangdong Nuclear Power Joint Venture Co Ltd
Current assignee: Beijing Branch Of China Guanghe Digital Technology Co ltd; Guangdong Nuclear Power Joint Venture Co Ltd
Priority date: 2023-12-29
Filing date: 2023-12-29
Publication date: 2024-04-05

Abstract

The application relates to the technical field of electromagnetic environment testing, and discloses a database establishing method, a database establishing device, computer equipment and a storage medium. The method comprises the following steps: acquiring electromagnetic environment data, wherein the electromagnetic environment data comprises test data, test grid information, three-dimensional point location information and spectrometer information, and the test data comprises variable data of the test grid information, the three-dimensional point location information and the spectrometer information in different electromagnetic environments; acquiring non-character data in the test data, and performing single-heat encoding operation on the non-character data to obtain corresponding single-heat data; and storing the independent heat quantity into a database according to the independent heat data and the association relation between the predetermined independent heat data, the test grid information, the three-dimensional point location information and the spectrometer information.

Description

Database establishment method and device, computer equipment and storage medium

Technical Field

The present invention relates to the field of electromagnetic environment testing, and in particular, to a method and apparatus for creating a database, a computer device, and a storage medium.

Background

When the electromagnetic test of each important factory building of the nuclear power plant is carried out, electromagnetic data can be acquired by using an electromagnetic probe, wherein the electromagnetic data comprises electromagnetic signal frequency, amplitude, position information, a wave band alarm source and the like, and under different electromagnetic environments, the electromagnetic environment data can be changed.

At present, electromagnetic environment data are limited to a test level, are not uniformly stored and summarized, and cannot be compared with electromagnetic environment changes.

Disclosure of Invention

Based on the foregoing, it is necessary to provide a method, an apparatus, a computer device, and a storage medium for creating a database.

In a first aspect, the present application provides a method for establishing a database. The method comprises the following steps:

acquiring electromagnetic environment data, wherein the electromagnetic environment data comprises test data, test grid information, three-dimensional point location information and spectrometer information, and the test data comprises variable data of the test grid information, the three-dimensional point location information and the spectrometer information in different electromagnetic environments;

acquiring non-character data in the test data, and performing single-heat encoding operation on the non-character data to obtain corresponding single-heat data;

and storing the independent heat quantity into a database according to the independent heat data and the association relation between the predetermined independent heat data, the test grid information, the three-dimensional point location information and the spectrometer information.

In one embodiment, the performing the one-hot encoding operation on the non-character data includes:

and converting the non-character data in the test data into corresponding binary features through the single-hot coding, wherein the binary features are single-hot data.

In one embodiment, the confirming of the association relationship includes:

classifying each binary feature according to the test grid information, the three-dimensional point location information and the spectrometer information, classifying the binary features obtained by converting the same data category into the same feature domain, and obtaining the association relation between the independent heat data and each feature domain.

In one embodiment, after the obtaining the corresponding single thermal data, the method further includes:

after the single-heat data is standardized, formatting operation is carried out on the standardized single-heat data based on the data processing rule of the database, and the processed data is stored in the database.

In one embodiment, the method further comprises:

acquiring new electromagnetic environment data after a preset time;

determining characteristic data of different new data types based on the independent heat data corresponding to the new test data;

and judging whether the electromagnetic environment is changed or not based on the distance between the characteristic data of the new different data types and the characteristic data of the historical different data types.

In one embodiment, the method further comprises:

and when the distance is larger than a preset distance threshold value, determining that the electromagnetic environment changes, and replacing the historical environment data with new electromagnetic environment data.

In a second aspect, the present application further provides a device for establishing a database, where the device includes:

the system comprises an acquisition module, a control module and a control module, wherein the acquisition module is used for acquiring electromagnetic environment data, the electromagnetic environment data comprises test data, test grid information, three-dimensional point location information and spectrometer information, and the test data comprises variable data of the test grid information, the three-dimensional point location information and the spectrometer information in different electromagnetic environments;

the conversion module is used for acquiring non-character data in the test data, and performing single-heat encoding operation on the non-character data to obtain corresponding single-heat data;

and the storage module is used for storing the independent heat quantity into a database according to the independent heat data and the association relation between the predetermined independent heat data, the test grid information, the three-dimensional point location information and the spectrometer information.

In a third aspect, the present disclosure also provides a computer device. The computer device comprises a memory storing a computer program and a processor implementing the steps of the method of creating a database when the processor executes the computer program.

In a fourth aspect, the present disclosure also provides a computer-readable storage medium. The computer readable storage medium has stored thereon a computer program which, when executed by a processor, implements the steps of a method of database creation.

In a fifth aspect, the present disclosure also provides a computer program product. The computer program product comprises a computer program which, when executed by a processor, implements the steps of a method of database creation.

The method for establishing the database at least comprises the following beneficial effects:

according to the embodiment scheme provided by the disclosure, the non-character data in the test data can be subjected to the independent heat coding operation to obtain the corresponding independent heat data, the independent heat quantity is stored in the database according to the independent heat data and the association relation between the independent heat data, the test grid information, the three-dimensional point location information and the spectrometer information, and whether the electromagnetic environment changes can be judged according to the independent heat data in the database.

It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the disclosure.

Drawings

In order to more clearly illustrate the technical solutions of the embodiments or the conventional techniques of the present disclosure, the drawings required for the descriptions of the embodiments or the conventional techniques will be briefly described below, and it is apparent that the drawings in the following description are only some embodiments of the present disclosure, and other drawings may be obtained according to the drawings without inventive effort to those of ordinary skill in the art.

FIG. 1 is an application environment diagram of a method of database creation in one embodiment;

FIG. 2 is a flow chart of a method of database creation in one embodiment;

FIG. 3 is a schematic diagram of test data in one embodiment;

FIG. 4 is a schematic diagram of test grid information in one embodiment;

FIG. 5 is a schematic diagram of three-dimensional point location information in one embodiment;

FIG. 6 is a schematic diagram of spectrum analyzer information in one embodiment;

FIG. 7 is a schematic diagram of a method of database creation in one embodiment;

FIG. 8 is a block diagram of the construction of a database building apparatus in one embodiment;

FIG. 9 is an internal block diagram of a computer device in one embodiment;

fig. 10 is an internal structural diagram of a server in one embodiment.

Detailed Description

In order to enable those skilled in the art to better understand the technical solutions of the present disclosure, the technical solutions of the embodiments of the present disclosure will be clearly and completely described below with reference to the accompanying drawings.

It should be noted that the terms "first," "second," and the like in the description and claims of the present disclosure and in the foregoing figures are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments of the disclosure described herein may be capable of operation in sequences other than those illustrated or described herein. The implementations described in the following exemplary examples are not representative of all implementations consistent with the present disclosure. Rather, they are merely examples of apparatus and methods consistent with some aspects of the present disclosure as detailed in the accompanying claims. The terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, it is not excluded that additional identical or equivalent elements may be present in a process, method, article, or apparatus that comprises a described element. For example, if first, second, etc. words are used to indicate a name, but not any particular order.

The embodiment of the disclosure provides a method for establishing a database, which can be applied to an application environment as shown in fig. 1. Wherein the terminal 102 communicates with the server 104 via a network. The data storage system may store data that the server 104 needs to process. The data storage system may be integrated on the server 104 or may be located on a cloud or other network server. The terminal 102 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, internet of things devices, and portable wearable devices, where the internet of things devices may be smart speakers, smart televisions, smart air conditioners, smart vehicle devices, and the like. The portable wearable device may be a smart watch, smart bracelet, headset, or the like. The server 104 may be implemented as a stand-alone server or as a server cluster of multiple servers.

In some embodiments of the present disclosure, as shown in fig. 2, a method for establishing a database is provided, and the method is applied to the server in fig. 1 to process electromagnetic environment data for example. It will be appreciated that the method may be applied to a server, and may also be applied to a system comprising a terminal and a server, and implemented by interaction of the terminal and the server. In a specific embodiment, the method may include the steps of:

s202: electromagnetic environment data are acquired, wherein the electromagnetic environment data comprise test data, test grid information, three-dimensional point location information and spectrometer information, and the test data comprise variable data of the test grid information, the three-dimensional point location information and the spectrometer information in different electromagnetic environments.

Electromagnetic environment data can be acquired through a positioning algorithm, a camera, a spectrometer and the like, and the electromagnetic environment data can comprise test data, test grid information, three-dimensional point location information and spectrometer information. Fig. 3 is a schematic diagram of test data in an embodiment, where the test data may include variable data of test grid information, three-dimensional point location information, and spectrometer information in different electromagnetic environments, for example, test time, grid size, spectrometer start frequency, spectrometer end frequency, lower left corner point location, upper right corner point location, and the like. FIG. 4 is a schematic diagram of test grid information in one embodiment, which may include grid point location information, grid maximum amplitude, etc. Fig. 5 is a schematic diagram of three-dimensional point location information in one embodiment, which may include an X-coordinate (abscissa), a Y-coordinate (ordinate), and the like. Fig. 6 is a schematic diagram of spectrum information in one embodiment, which may include frequency, amplitude, etc.

S204: and acquiring non-character data in the test data, and performing single-heat encoding operation on the non-character data to obtain corresponding single-heat data.

The non-character data in the test data can be non-numerical data, such as data of a model, an operator, notes and the like, and the non-character data is subjected to single-heat encoding operation to obtain corresponding single-heat data. Wherein, the One-Hot code (One-Hot code) mainly adopts N-bit state registers to code N states, each state is formed by independent register bits, and only One bit is valid at any time.

In the normal test environment, the starting data of the spectrometer is generally in a certain range, for example, a range can be randomly set from 400 hz to 700 hz, 100 hz is set as a value range, and the starting data of the spectrometer in the current range can be "1000", "0100", "0010", "0001" under the operation of single-heat coding and correspond to 400 hz, 500 hz, 600 hz and 700 hz respectively. If the starting data of the spectrometer in the current test data is 500 Hz, performing the single-heat encoding operation, and obtaining the corresponding single-heat data as '0100'.

S208: and storing the independent heat quantity into a database according to the independent heat data and the association relation between the predetermined independent heat data, the test grid information, the three-dimensional point location information and the spectrometer information.

The association relation between the predetermined independent heat data and the test grid information, the three-dimensional point location information and the frequency spectrograph information can be matched according to specific parameters, for example, the association relation can be matched manually by manpower, variable values in the three-dimensional point location information, the frequency spectrograph data and the test grid information data can be matched to test information variable names by adopting a Python programming method, and the variable values can be further matched with independent heat. For example, the single-heat data corresponding to the start data of the spectrometer in the test data is "0100", and as shown in fig. 5, the test grid information includes a spectrometer data set, and "0100" is associated with the test grid information and stored in the database.

In the method for establishing the database, the non-character data in the test data can be subjected to the independent heat coding operation to obtain the corresponding independent heat data, and the independent heat quantity is stored in the database according to the independent heat data and the association relation between the independent heat data, the test grid information, the three-dimensional point location information and the spectrometer information, and whether the electromagnetic environment changes can be judged according to the independent heat data in the database.

In some embodiments of the disclosure, the performing the one-hot encoding operation on the non-character data includes:

Where the numerical feature is not always a continuous value, but rather is likely to be a classified value, it may be represented using one-hot encoding to convert the discrete class labels into binary features.

In some embodiments of the present disclosure, the validation of the association relationship includes:

In this embodiment, the method may include 3 classification categories, that is, test grid information, three-dimensional point location information, and spectrometer information, where the test grid information, the three-dimensional point location information, and the spectrometer information may further include a plurality of data, and binary features obtained by converting the same data category may be classified into the same feature domain, so as to obtain an association relationship between the independent heat data and each feature domain.

In some embodiments of the present disclosure, after the obtaining the corresponding single thermal data, the method further includes:

And after the single-heat data are standardized, formatting according to the electromagnetic environment database data standard to obtain electromagnetic environment list data, and importing the electromagnetic environment list data into a database management system to establish an electromagnetic environment database.

In some embodiments of the present disclosure, the method further comprises:

acquiring new electromagnetic environment data after a preset time;

In machine learning algorithms, classification features are often encountered as discrete, unordered. In machine learning algorithms such as regression, classification, clustering, etc., calculation of distances between features or calculation of similarity are very important. The common distance or similarity calculation is the similarity calculation in the European space. The value of the discrete feature can be expanded to the European space by using the single thermal coding, and a certain value of the discrete feature corresponds to a certain point of the European space. Whether the electromagnetic environment changes can be judged according to the distance between the characteristic data of the new different data types and the characteristic data of the historical different data types.

In some embodiments of the present disclosure, the method further comprises:

And if the distance is greater than the preset distance threshold, determining that the electromagnetic environment changes, and replacing the historical environment data with the new electromagnetic environment data.

FIG. 7 is a schematic diagram of database creation in one embodiment, including the data processing process described above.

It should be understood that, although the steps in the flowcharts related to the embodiments described above are sequentially shown as indicated by arrows, these steps are not necessarily sequentially performed in the order indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps in the flowcharts described in the above embodiments may include a plurality of steps or a plurality of stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of the steps or stages is not necessarily performed sequentially, but may be performed alternately or alternately with at least some of the other steps or stages.

Based on the same inventive concept, the embodiment of the disclosure also provides a database building device for implementing the above related database building method. The implementation scheme of the solution provided by the device is similar to the implementation scheme described in the above method, so the specific limitation in the embodiment of the database creation device provided below can be referred to the limitation of the database creation method hereinabove, and will not be repeated here.

The apparatus may comprise a system (including a distributed system), software (applications), modules, components, servers, clients, etc. that employ the methods described in the embodiments of the present specification in combination with the necessary apparatus to implement the hardware. Based on the same innovative concepts, embodiments of the present disclosure provide for devices in one or more embodiments as described in the following examples. Because the implementation scheme and the method for solving the problem by the device are similar, the implementation of the device in the embodiment of the present disclosure may refer to the implementation of the foregoing method, and the repetition is not repeated. As used below, the term "unit" or "module" may be a combination of software and/or hardware that implements the intended function. While the means described in the following embodiments are preferably implemented in software, implementation in hardware, or a combination of software and hardware, is also possible and contemplated.

In one embodiment, as shown in fig. 8, a database creation apparatus 800 is provided, where the apparatus may be the aforementioned server, or a module, component, device, unit, etc. integrated with the server.

The apparatus 800 may include:

an obtaining module 802, configured to obtain electromagnetic environment data, where the electromagnetic environment data includes test data, test grid information, three-dimensional point location information, and spectrometer information, and the test data includes variable data of the test grid information, the three-dimensional point location information, and the spectrometer information in different electromagnetic environments;

the conversion module 804 is configured to obtain non-character data in the test data, and perform a single-heat encoding operation on the non-character data to obtain corresponding single-heat data;

and a storage module 806, configured to store the independent heat quantity into a database according to the independent heat data and the association relationship between the predetermined independent heat data and the test grid information, the three-dimensional point location information, and the spectrometer information.

The specific manner in which the various modules perform the operations in the apparatus of the above embodiments have been described in detail in connection with the embodiments of the method, and will not be described in detail herein.

The respective modules in the database-oriented building apparatus described above may be implemented in whole or in part by software, hardware, and combinations thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.

In one embodiment, a computer device is provided, which may be a server, and the internal structure of which may be as shown in fig. 9. The computer device includes a processor, a memory, and a network interface connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, computer programs, and a database. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The database of the computer device is for storing electromagnetic environment data. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a method of database creation.

In one embodiment, a computer device is provided, which may be a terminal, and an internal structure diagram thereof may be as shown in fig. 10. The computer device includes a processor, a memory, a communication interface, a display screen, and an input device connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The communication interface of the computer device is used for carrying out wired or wireless communication with an external terminal, and the wireless mode can be realized through WIFI, a mobile cellular network, NFC (near field communication) or other technologies. The computer program is executed by a processor to implement a method of database creation. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, can also be keys, a track ball or a touch pad arranged on the shell of the computer equipment, and can also be an external keyboard, a touch pad or a mouse and the like.

It will be appreciated by those skilled in the art that the structures shown in fig. 9 and 10 are merely block diagrams of portions of structures related to the disclosed aspects and do not constitute a limitation of the computer device to which the disclosed aspects may be applied, and that a particular computer device may include more or fewer components than shown, or may combine certain components, or have a different arrangement of components.

In one embodiment, a computer readable storage medium is provided, having a computer program stored thereon, which when executed by a processor, implements the method of any of the embodiments of the present disclosure.

In one embodiment, a computer program product is provided, comprising a computer program which, when executed by a processor, implements the method described in any of the embodiments of the present disclosure.

Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, database, or other medium used in embodiments provided by the present disclosure may include at least one of non-volatile and volatile memory, among others. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, high density embedded nonvolatile Memory, resistive random access Memory (ReRAM), magnetic random access Memory (Magnetoresistive Random Access Memory, MRAM), ferroelectric Memory (Ferroelectric Random Access Memory, FRAM), phase change Memory (Phase Change Memory, PCM), graphene Memory, and the like. Volatile memory can include random access memory (Random Access Memory, RAM) or external cache memory, and the like. By way of illustration, and not limitation, RAM can be in the form of a variety of forms, such as static random access memory (Static Random Access Memory, SRAM) or dynamic random access memory (Dynamic Random Access Memory, DRAM), and the like. The databases referred to in the various embodiments provided by the present disclosure may include at least one of a relational database and a non-relational database. The non-relational database may include, but is not limited to, a blockchain-based distributed database, and the like. The processors involved in the embodiments provided by the present disclosure may be general-purpose processors, central processing units, graphics processors, digital signal processors, programmable logic, quantum computing-based data processing logic, etc., without limitation thereto.

The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.

The foregoing examples have expressed only a few embodiments of the present disclosure, which are described in more detail and detail, but are not to be construed as limiting the scope of the present disclosure. It should be noted that variations and modifications can be made by those skilled in the art without departing from the spirit of the disclosure, which are within the scope of the disclosure. Accordingly, the scope of the present disclosure should be determined from the following claims.

Claims

1. A method of creating a database, the method comprising:

2. The method of claim 1, wherein the unicoding the non-character data comprises:

3. The method of claim 2, wherein the confirming of the association relationship comprises:

4. The method of claim 1, wherein after the obtaining the corresponding single-heat data, the method further comprises:

5. The method according to claim 1, wherein the method further comprises:

acquiring new electromagnetic environment data after a preset time;

6. The method of claim 5, wherein the method further comprises:

7. A database creation apparatus, the apparatus comprising:

8. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the method of any of claims 1 to 6 when the computer program is executed.

9. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 6.

10. A computer program product comprising a computer program, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 6.