Custom ocean observation data storage method, device, equipment and medium

Abstract

The invention discloses a self-defined ocean observation data storage method, device and equipment and a medium, and relates to the technical field of data processing, and the method comprises the steps: creating and maintaining an ocean environment element data label library which can be edited by a user in a database; the element data label library is used for storing and managing predefined marine environment element data labels; based on the label library, responding to the selection operation, and constructing a database table template of a set structure through the selected data labels and the self-defined fields; the ocean observation equipment to be accessed is associated and bound with the constructed database table template; and in response to the association binding, automatically generating a data storage table corresponding to the marine observation equipment according to the associated database table template so as to receive and store observation data of the marine observation equipment and form a marine environment data knowledge base decoupled from the marine observation equipment. According to the method, the storage capacity of the multi-source heterogeneous data of the marine environment data management system is improved.

Description

Technical Field

[0001] This invention relates to the field of data processing technology, and in particular to a custom marine observation data storage method, apparatus, equipment, and medium. Background Technology

[0002] Ocean observation involves a wide variety of information, encompassing surface meteorological data, underwater hydrological data such as temperature, salinity, ocean currents, and sound speed, as well as multi-source data on seawater quality, chemical elements, and ionic composition. Furthermore, the equipment used in ocean observation is extremely diverse, with different devices and even different manufacturers employing vastly different data protocols and structures, resulting in highly heterogeneous ocean observation data in terms of structure and format. Acquiring ocean observation data is difficult and costly. Therefore, establishing a marine environmental data management system to integrate and store multi-source, heterogeneous data from various ocean environmental data observation devices and channels has significant social and economic value for collecting and utilizing this hard-won marine environmental data.

[0003] Marine environmental data management systems in related technologies are generally developed for specific observation equipment or systems. The required data types and structures are determined at the initial design stage, and the data management system's information access, storage, and display are designed based on these requirements. The limitations of this conventional, on-demand customized system are: the system cannot be expanded to include new environmental monitoring equipment; the system cannot adapt to the upgrading and expansion of environmental monitoring equipment and new functions; and each time new equipment information is integrated, the data management system requires secondary upgrades and development, increasing system upgrade and maintenance costs. This not only increases the maintenance costs throughout the system's lifecycle but also objectively shortens the system's effective lifespan. Summary of the Invention

[0004] This invention provides a custom marine observation data storage method, device, equipment, and medium, which solves the problem of insufficient scalability of storage capacity for multi-source heterogeneous data in marine environmental data management systems.

[0005] To achieve the above objectives, this application adopts the following technical solution: Firstly, a custom method for storing ocean observation data is provided, including: Create and maintain a user-editable marine environmental element data tag library in the database; the element data tag library is used to store and manage predefined marine environmental element data tags; Based on the tag library, in response to the selection operation, a database table template with a set structure is constructed using the selected data tags and custom fields; The marine observation equipment to be connected is associated and bound to a completed database table template; In response to the association binding, a data storage table corresponding to the marine observation equipment is automatically generated based on the associated database table template, so as to receive and store the observation data of the marine observation equipment and form a marine environmental data knowledge base decoupled from the marine observation equipment.

[0006] Furthermore, the method also includes: Based on the data tags, cross-table queries and / or statistical analyses are performed on data of the same type in data storage tables generated from different database table templates.

[0007] Furthermore, each of the marine environmental element data tags includes: tag name, data type, and data length information.

[0008] Furthermore, each of the marine environmental element data tags also includes: tag description and tag example information.

[0009] Furthermore, the custom fields include data sequence number and / or data status identifier fields.

[0010] Secondly, a custom-designed ocean observation data storage device is provided, comprising: The tag library construction module is used to create and maintain a user-editable marine environmental element data tag library in the database; the element data tag library is used to store and manage predefined marine environmental element data tags; The database table template construction module is used to construct a database table template with a set structure based on the tag library and in response to the selection operation, using the selected data tags and custom fields. The device association and binding module is used to associate and bind the marine observation equipment to be connected with a completed database table template; The database table generation and knowledge base construction module is used to respond to the association binding and automatically generate a data storage table corresponding to the marine observation equipment according to the associated database table template, so as to receive and store the observation data of the marine observation equipment and form a marine environmental data knowledge base decoupled from the marine observation equipment.

[0011] Thirdly, an electronic device is provided, comprising: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the computer program, when executed by the processor, implements the steps of the custom marine observation data storage method as described in the first aspect.

[0012] Fourthly, a readable storage medium is provided, on which a program or instructions are stored, which, when executed by a processor, implement the steps of the custom marine observation data storage method as described in the first aspect. Attached Figure Description

[0013] Figure 1 A schematic flowchart illustrating a customized marine observation data storage method provided in this application embodiment; Figure 2 A schematic flowchart illustrating another customized marine observation data storage method provided in this application embodiment; Figure 3 This is a schematic diagram of a custom database architecture provided in an embodiment of this application. Detailed Implementation

[0014] To further illustrate the technical means and effects adopted by the present invention to achieve its intended purpose, the technical solutions in the embodiments of this application are clearly described. Obviously, the described embodiments are only some embodiments of this application, not all embodiments. Based on the embodiments in this application, all other embodiments obtained by those skilled in the art are within the scope of protection of this application.

[0015] The terms "first," "second," etc., used in the specification and claims of this application are used to distinguish similar objects and not to describe a specific order or sequence. It should be understood that such terms can be used interchangeably where appropriate so that embodiments of this application can be implemented in orders other than those illustrated or described herein, and the objects distinguished by "first," "second," etc., are generally of the same class and the number of objects is not limited; for example, a first object can be one or more. Furthermore, in the specification, "and / or" indicates at least one of the connected objects, and the character " / " generally indicates that the preceding and following objects are in an "or" relationship.

[0016] The steps described in the specification and the flowcharts in the accompanying drawings of this invention are not necessarily strictly executed according to the step numbers; the execution order of the method steps can be changed. Furthermore, certain steps can be omitted, multiple steps can be combined into one step, and / or one step can be broken down into multiple steps.

[0017] Databases are the foundation of data management systems. The general design and development sequence of a data management system is to first determine the data structure and format of the data management system, and then design the table structure required for data transfer and storage based on this. The database is thus solidified and serves as the basis for system design and development.

[0018] The fixed database structure clarifies the content and storage format of software information interaction, but it also means that once a system is developed, it cannot flexibly access equipment information outside the design during application. This results in insufficient compatibility, universality, and scalability of the data management system. This shortcoming is not prominent in the relatively mature and stable meteorological field where data protocols have been standardized, but it obviously faces great application obstacles in the field of marine observation where equipment and data protocols are not standardized. As a result, the current marine observation data management, especially multi-source data management, is very fragmented, and there is no system that can be compatible with accessing online or offline data from different marine environments.

[0019] Based on this, this specification provides a custom marine observation data storage method, and also relates to a custom marine observation data storage device, a computer device, and a computer-readable storage medium. It solves the problems of multi-source data access, storage, and statistical analysis at the database level, realizes the multi-source observation processing capability of the marine observation data management system, and improves the goal of universal storage and processing of marine observation data. The following describes each aspect in detail with reference to the accompanying drawings and preferred embodiments.

[0020] Please see Figure 1-2 This application provides a customized marine observation data storage system, such as... Figure 1-2 As shown, it includes: Step S1: Create and maintain a user-editable marine environmental element data tag library in the database; the element data tag library is used to store and manage predefined marine environmental element data tags; Step S2: Based on the tag library, respond to the selection operation and construct a database table template with a set structure using the selected data tags and custom fields; Step S3: Associate and bind the marine observation equipment to be connected with a completed database table template; Step S4: In response to the association binding, automatically generate a data storage table corresponding to the marine observation equipment according to the associated database table template, so as to receive and store the observation data of the marine observation equipment and form a marine environmental data knowledge base decoupled from the marine observation equipment.

[0021] In some possible implementations, based on data tags in a tag library, cross-table queries and / or statistical analyses are performed on data of the same type in data storage tables generated from different database table templates.

[0022] This application proposes a custom database architecture based on a user-defined data tag library and database table templates, such as... Figure 3As shown, this approach shifts away from the conventional design philosophy of customizing database table structures in marine data management systems. Instead, it transforms the design of database table structures into the design of a user-defined, editable platform, thereby enabling the access and storage of any multi-source marine observation data.

[0023] Therefore, the foundation for the design and development of the data management system is no longer a fixed series of database table structures, but a customizable template framework for database table structures. This transforms the software's operations on database tables into operations on editable and configurable database table templates. Consequently, the correspondence between conventional device data and database table operations becomes a relationship where users can create database table templates based on the device data structure and then associate information. This enables the system to accept device data types as needed and allows users to create database tables, thus solving the problem of storing multi-source heterogeneous information in the system.

[0024] Considering the need for classification, statistics, and display of marine environmental data elements, the system database is designed with a marine environmental data element tag library. The tag library is editable by users and used to build database table templates. This enables the querying and statistical management of data information in the corresponding fields of all database tables. It can also form a pure marine environmental data knowledge base decoupled from the equipment, thus creating marine environmental data products.

[0025] Furthermore, each of the marine environmental element data tags includes: tag name, data type, and data length information; in some possible implementations, each of the marine environmental element data tags also includes tag description and tag example information.

[0026] A tag library is created within the database. This tag library primarily defines the basic information that the marine environmental data management system needs to store, such as the data name, type, and length. The table structure is fixed, but users can create new tags as needed. As the basic unit for data operations in the system database, the tag library can be used to construct database table templates, and can also store system-wide variables such as device type and task type, for user and data statistical analysis and management. An example of the tag library table structure for marine environmental element data types is as follows: Table 1. Structure of the Data Type Tag Library for Marine Environmental Elements

[0027] Furthermore, the custom fields include data sequence number and / or data status identifier fields.

[0028] Based on the tag library, user-customizable database table templates can be built to create this type of measurement data. Taking the example tags in Table 1 (tag library table) as an example, tags from the tag library can be selected and some custom fields added to build a database table template for storing seawater temperature, salinity, and depth measurement data, as shown in Table 2: Table 2 Template for Seawater Temperature, Salinity, and Depth Measurement Database

[0029] After creating the database table template, the system can add new devices of this type for data storage. When adding a device, simply associate and bind the access device with the data storage template library, and the software will automatically create a database table to receive data from that device according to the database table template. In practice, data access can be achieved by configuring different data access interfaces to simultaneously receive multi-source heterogeneous data from various types of marine environmental data observation devices and different channels.

[0030] The construction of database table templates solves the problem that existing marine environmental data management systems cannot flexibly store marine environmental data with data structures outside the system design. This allows the database to be created and stored according to user needs, resolving compatibility issues related to multi-source data storage. Furthermore, the establishment of a tag library avoids data fragmentation caused by users arbitrarily creating database table templates, preventing the system from performing specialized data communication analysis. This ensures clear data separation and guarantees operations such as database data statistics and display.

[0031] Corresponding to the above-described embodiment of the customized marine observation data storage method, this application embodiment provides a customized marine observation data storage device, including: The tag library construction module is used to create and maintain a user-editable marine environmental element data tag library in the database; the element data tag library is used to store and manage predefined marine environmental element data tags; The database table template construction module is used to construct a database table template with a set structure based on the tag library and in response to the selection operation, using the selected data tags and custom fields. The device association and binding module is used to associate and bind the marine observation equipment to be connected with a completed database table template; The database table generation and knowledge base construction module is used to respond to the association binding and automatically generate a data storage table corresponding to the marine observation equipment according to the associated database table template, so as to receive and store the observation data of the marine observation equipment and form a marine environmental data knowledge base decoupled from the marine observation equipment.

[0032] Furthermore, the device also includes: The query and statistical analysis module is used to perform cross-table queries and / or statistical analysis on data of the same type in data storage tables generated by different database table templates, based on the data tags.

[0033] Furthermore, each of the marine environmental element data tags includes: tag name, data type, and data length information.

[0034] Furthermore, each of the marine environmental element data tags also includes: tag description and tag example information.

[0035] Furthermore, the custom fields include data sequence number and / or data status identifier fields.

[0036] The aforementioned custom marine observation data storage device implements the steps and processes of the aforementioned custom marine observation data storage method embodiment, and achieves the same technical effect. To avoid repetition, it will not be described again here.

[0037] Corresponding to the above-described custom marine observation data storage method embodiment, this application embodiment provides an electronic device, which includes: a memory, a processor, and a computer program stored in the memory and executable on the processor. When the computer program is executed by the processor, it implements the steps and processes of the above-described custom marine observation data storage method embodiment and achieves the same technical effect. To avoid repetition, it will not be described again here.

[0038] Memory can be used to store software programs and various data. Memory can primarily include a first storage area for storing programs or instructions and a second storage area for storing data. The first storage area can store the operating system, application programs or instructions required for at least one function (such as sound playback, image playback, etc.). Furthermore, memory can include volatile memory or non-volatile memory, or both. Non-volatile memory can be read-only memory (ROM), programmable read-only memory (PROM), erasable programmable read-only memory (EPROM), electrically erasable programmable read-only memory (EEPROM), or flash memory. Volatile memory can be random access memory (RAM), static random access memory (SRAM), dynamic random access memory (DRAM), synchronous dynamic random access memory (SDRAM), double data rate synchronous dynamic random access memory (DDRSDRAM), enhanced synchronous dynamic random access memory (ESDRAM), synchronous linked dynamic random access memory (Synchlink DRAM, SLDRAM), and direct memory bus RAM (DRRAM). The memory in the embodiments of this application includes, but is not limited to, these and any other suitable types of memory.

[0039] The processor may include one or more processing units; optionally, the processor integrates an application processor and a modem processor, wherein the application processor mainly handles operations related to the operating system, user interface, and applications, while the modem processor mainly handles wireless communication signals, such as a baseband processor. It is understood that the aforementioned modem processor may also not be integrated into the processor.

[0040] Corresponding to the above-described custom marine observation data storage method embodiment, this application embodiment also provides a readable storage medium storing a program or instructions. When the program or instructions are executed by a processor, they implement the steps and processes of the above-described custom marine observation data storage method embodiment and achieve the same technical effect. To avoid repetition, they will not be described again here.

[0041] The processor is the processor in the electronic device described in the above embodiments of this application. The readable storage medium includes a computer-readable storage medium, such as a computer read-only memory (ROM), random access memory (RAM), a magnetic disk, or an optical disk.

[0042] It should be noted that, in this document, the terms "comprising," "including," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such a process, method, article, or apparatus. Without further limitations, an element defined by the phrase "comprising one..." does not exclude the presence of other identical elements in the process, method, article, or apparatus that includes that element. Furthermore, it should be noted that the scope of the methods and apparatuses in the embodiments of this application is not limited to performing functions in the order shown or discussed, but may also include performing functions substantially simultaneously or in the reverse order, depending on the functions involved. For example, the described methods may be performed in a different order than described, and various steps may be added, omitted, or combined. Additionally, features described with reference to certain examples may be combined in other examples.

[0043] Through the above description of the embodiments, those skilled in the art can clearly understand that the methods of the above embodiments can be implemented by means of software plus necessary general-purpose hardware platforms. Of course, they can also be implemented by hardware, but in many cases the former is a better implementation method. Based on this understanding, the technical solution of this application, in essence, or the part that contributes to the prior art, can be embodied in the form of a computer software product. This computer software product is stored in a storage medium (such as ROM / RAM, magnetic disk, optical disk) and includes several instructions to cause a terminal (which may be a mobile phone, computer, server, or network device, etc.) to execute the methods described in the various embodiments of this application.

[0044] It is understood that the embodiments of this application have been described above in conjunction with the accompanying drawings. However, this application is not limited to the specific embodiments described above. The specific embodiments described above are merely illustrative and not restrictive. As those skilled in the art will know, various changes or equivalent substitutions can be made to these features and embodiments without departing from the spirit and scope of the invention. Furthermore, those skilled in the art, under the guidance or instruction of this application, can modify these features and embodiments to adapt to specific situations and materials without departing from the spirit and scope of the invention. Therefore, this invention is not limited to the specific embodiments disclosed herein, and all embodiments falling within the scope of the claims of this application are within the protection scope of this invention.

Claims

1. A customized method for storing ocean observation data, characterized in that, include: Create and maintain a user-editable marine environmental element data tag library in the database; the element data tag library is used to store and manage predefined marine environmental element data tags; Based on the tag library, in response to the selection operation, a database table template with a set structure is constructed using the selected data tags and custom fields; The marine observation equipment to be connected is associated and bound to a completed database table template; In response to the association binding, a data storage table corresponding to the marine observation equipment is automatically generated based on the associated database table template, so as to receive and store the observation data of the marine observation equipment and form a marine environmental data knowledge base decoupled from the marine observation equipment.

2. The customized marine observation data storage method according to claim 1, characterized in that, The method further includes: Based on the data tags, cross-table queries and / or statistical analyses are performed on data of the same type in data storage tables generated from different database table templates.

3. The customized ocean observation data storage method according to claim 1, characterized in that, Each marine environmental element data tag includes: tag name, data type, and data length information.

4. The customized marine observation data storage method according to claim 3, characterized in that, Each of the marine environmental element data tags also includes: tag description and tag example information.

5. The customized marine observation data storage method according to claim 1, characterized in that, The custom fields include data sequence number and / or data status identifier fields.

6. A custom-designed marine observation data storage device, characterized in that, include: The tag library construction module is used to create and maintain a user-editable marine environmental element data tag library in the database; the element data tag library is used to store and manage predefined marine environmental element data tags; The database table template construction module is used to construct a database table template with a set structure based on the tag library and in response to the selection operation, using the selected data tags and custom fields. The device association and binding module is used to associate and bind the marine observation equipment to be connected with a completed database table template; The database table generation and knowledge base construction module is used to respond to the association binding and automatically generate a data storage table corresponding to the marine observation equipment according to the associated database table template, so as to receive and store the observation data of the marine observation equipment and form a marine environmental data knowledge base decoupled from the marine observation equipment.

7. The customized marine observation data storage device according to claim 6, characterized in that, Each marine environmental element data tag includes: tag name, data type, and data length information.

8. The customized marine observation data storage method according to claim 6, characterized in that, The custom fields include data sequence number and / or data status identifier fields.

9. An electronic device, characterized in that, The electronic device includes: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the computer program, when executed by the processor, implements the steps of the custom marine observation data storage method as described in any one of claims 1 to 5.

10. A readable storage medium, characterized in that, The readable storage medium stores a program or instructions that, when executed by a processor, implement the steps of the custom marine observation data storage method as described in any one of claims 1 to 5.

Images