CN113535734B - Data storage method, data query method and computing device - Google Patents
Data storage method, data query method and computing device Download PDFInfo
- Publication number
- CN113535734B CN113535734B CN202110845231.2A CN202110845231A CN113535734B CN 113535734 B CN113535734 B CN 113535734B CN 202110845231 A CN202110845231 A CN 202110845231A CN 113535734 B CN113535734 B CN 113535734B
- Authority
- CN
- China
- Prior art keywords
- data
- index
- index number
- actual
- standard
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2474—Sequence data queries, e.g. querying versioned data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Software Systems (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Probability & Statistics with Applications (AREA)
- Computational Linguistics (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a data storage method, a data query method and computing equipment, wherein the data storage method comprises the following steps: acquiring data to be stored; inquiring the corresponding relation between the actual index number corresponding to the version number of each actual index number and the standard index number from the index number corresponding table; converting each actual index number into a corresponding standard index number according to the corresponding relation between the actual index number and the standard index number, and obtaining converted data to be stored; and storing the converted data to be stored into a data storage table. According to the method, even if the equipment indexes are not uniform, the corresponding relation between the actual index numbers and the standard index numbers is determined only from the index number corresponding table by setting the index number corresponding table, and the index numbers are expanded by changing the corresponding relation between the actual index numbers and the standard index numbers on the premise of not increasing the number of the standard index numbers, so that the expansibility of the index numbers is improved.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a data storage method, a data query method, a computing device, and a storage medium.
Background
In the field of industrial equipment, data is typically uploaded in batches, i.e. a piece of equipment generates a large amount of data at the same time. In order to improve the data storage efficiency, it is generally considered to sort data, store different types of data separately, and design data storage tables of different structures for the different types of data when storing the data. However, some types of data are often not single-existing, i.e., there may actually exist a plurality of types of data, such as index data, in one type of data.
In the prior art, index data is stored in two ways, namely, the data is stored in rows, namely, the data is disassembled and stored in a plurality of rows, but in the manner of storing in rows, information such as equipment names, acquisition time and the like is redundant for the same equipment, so that the inquiry performance is low. The other is to store according to columns, namely, the number of columns is set according to the index data amount to be stored at the same time when designing the data storage table, the method stores all index data in one row, and the index field number is fixed, but the method is inconvenient to expand because the index field number is fixed, and the number of columns of the data table is more difficult to control along with the larger difference of the devices, meanwhile, for a single device, invalid data is obviously increased, and the storage space utilization rate is greatly reduced.
Disclosure of Invention
To this end, the present invention provides a data storage method in an effort to solve or at least alleviate the above-identified problems.
According to an aspect of the present invention, there is provided a data storage method executed in a computing device, in which a data storage table and an index number correspondence table are stored, wherein the index number correspondence table includes a standard index number and a plurality of versions of actual index numbers corresponding to the standard index number, each version of actual index numbers corresponding to one version number, the method comprising:
acquiring data to be stored, wherein the data to be stored comprises a plurality of data items, each data item comprises index data and a version number of an actual index number, and the index data comprises the actual index number and an index value corresponding to the actual index number;
inquiring the corresponding relation between the actual index number corresponding to the version number of each actual index number and the standard index number from the index number corresponding table;
converting each actual index number into a corresponding standard index number according to the corresponding relation between the actual index number and the standard index number, and obtaining converted data to be stored;
and storing the converted data to be stored into a data storage table.
Optionally, each data item to be stored further includes device information and sampling time, the device information includes a measurement point ID, and the method further includes the steps of:
counting all index data of the same measuring point ID at the same sampling time to obtain a plurality of groups of statistical index data;
according to the corresponding relation between the actual index numbers and the standard index numbers, converting each actual index number into a corresponding standard index number, and obtaining the converted data to be stored comprises the following steps:
according to the corresponding relation between the actual index number and the standard index number, converting the actual index number of each group of statistical index data into the corresponding standard index number, and obtaining a plurality of groups of converted statistical index data.
Optionally, the step of storing the converted data to be stored in the data storage table includes:
and storing the equipment information, the sampling time and a group of converted statistical index data corresponding to the sampling time into a data storage table as one line of data.
Optionally, each data item in the data to be stored further includes an index attribute, and the method further includes the steps of:
counting all index attributes of the same measuring point ID at the same sampling time to obtain a plurality of groups of statistical index attributes;
And converting the actual index number in each group of statistical index attributes into a corresponding standard index number according to the corresponding relation between the actual index number and the standard index number, so as to obtain a plurality of groups of converted statistical index attributes.
Optionally, the step of storing the converted data to be stored in the data storage table includes:
and storing the equipment information, the sampling time, a group of converted statistical index data corresponding to the sampling time and a group of converted statistical index attributes corresponding to the sampling time into a data storage table as one line of data.
Optionally, the device information further includes a component ID, the data storage table includes one or more of a component ID field, a measurement point ID field, a sampling time field, a version number field of an actual index number, a converted statistical index data field, and a converted statistical index attribute field, all converted index data of the same measurement point ID at the same sampling time are stored in the converted statistical index data field, and all converted attribute information of the same measurement point ID at the same sampling time is stored in the converted statistical index attribute.
Optionally, the data type of any one of the converted sets of statistical index data is a UDT data type.
Optionally, any of the converted sets of statistical index data is a set of key-value pairs.
Optionally, any of the converted statistical indicator attributes is a set of key-value pairs.
Alternatively, the station ID is unique.
Optionally, the method further comprises the steps of:
when the actual index number is newly defined, the newly defined actual index number is stored in the index number corresponding table according to the corresponding relation with the standard index number.
Optionally, after storing the data to be stored in the data storage table, the method further comprises the steps of:
determining equipment information, an actual index number and a version number of the actual index number of the data to be updated;
inquiring the corresponding relation between the actual index number corresponding to the version number of the actual index number and the standard index number from the index number corresponding table;
determining the standard index number of the data to be updated according to the corresponding relation between the found actual index number and the standard index number;
and inquiring data items corresponding to the equipment information, the standard index number and the version number of the actual index number of the data to be updated from the data storage table, and updating the found data items.
According to another aspect of the present invention, there is provided a data query method executed in a computing device, in which a data storage table and an index number correspondence table are stored, wherein the data storage table is obtained according to the data storage method described above, the index number correspondence table includes a standard index number and a plurality of versions of actual index numbers corresponding to the standard index number, and the actual index number of each version corresponds to a version number, the method including:
Determining equipment information, an actual index number and a version number of the actual index number of index data to be queried, and distinguishing measuring points of all parts of all equipment in all enterprises through the equipment information;
inquiring the corresponding relation between the actual index number corresponding to the version number of the actual index number and the standard index number from the index number corresponding table;
determining the standard index number of the index data to be queried according to the corresponding relation between the found actual index number and the standard index number;
and searching the data to be queried from the data storage table through the equipment information, the version number of the actual index number and the standard index number of the index data to be queried.
According to one aspect of the present invention, there is provided a computing device comprising: at least one processor; and a memory storing program instructions, wherein the program instructions are configured to be adapted to be executed by the at least one processor, the program instructions comprising instructions for performing the method as described above.
According to one aspect of the present invention, there is provided a readable storage medium storing program instructions which, when read and executed by a computing device, cause the computing device to perform a method as described above.
According to the technical scheme of the invention, a data storage method is provided, by which even if the condition of non-uniform equipment indexes occurs, the indexes of equipment 1 are assumed to be 6, the indexes of equipment 2 are assumed to be 5, and the indexes of equipment 1 and equipment 2 are completely different, but 11 columns are not required to be created, the corresponding relation between the actual index number and the standard index number is determined from an index number corresponding table, and the index number is extended by changing the corresponding relation between the actual index number and the standard index number on the premise of not increasing the number of the standard index numbers, so that the expansibility of the index number is improved.
Secondly, under the condition that the equipment indexes are not uniform, the fields (all are standard index numbers) in the index corresponding table are unchanged, and only the actual index numbers corresponding to the standard index numbers in different index number versions are different, which is equivalent to the reusable standard index numbers, and the occupied storage space is the storage space occupied by the standard index numbers, so that the fields cannot be continuously and limitlessly increased, namely the occupation of the storage space cannot be increased, and the utilization rate of the storage space is improved.
In addition, in the data storage table, all index data of the same measuring point and the same sampling time are stored in the same field, namely, all index data of the same measuring point and the same sampling time are stored in one column of the data storage table, so that the occupied storage space is reduced, and the space utilization rate is improved. Compared with the prior art that the number of columns is continuously increased along with the continuous increase of the index, in the invention, the number of columns of the data storage table is not increased along with the increase of the index data because the index data is stored in one column, namely, the number of columns of the data storage table is fixed, so that the data storage table is easier to maintain.
In addition, all index data of the same measuring point and the same sampling time are stored in one column, so that the index data can be rapidly inquired according to the standard index number, the inquiring efficiency of the index data is improved, and the change of service requirements can be more flexibly adapted.
The foregoing description is only an overview of the present invention, and is intended to be implemented in accordance with the teachings of the present invention in order that the same may be more clearly understood and to make the same and other objects, features and advantages of the present invention more readily apparent.
Drawings
To the accomplishment of the foregoing and related ends, certain illustrative aspects are described herein in connection with the following description and the annexed drawings, which set forth the various ways in which the principles disclosed herein may be practiced, and all aspects and equivalents thereof are intended to fall within the scope of the claimed subject matter. The above, as well as additional objects, features, and advantages of the present disclosure will become more apparent from the following detailed description when read in conjunction with the accompanying drawings. Like reference numerals generally refer to like parts or elements throughout the present disclosure.
FIG. 1 illustrates a schematic diagram of a data storage system 100, according to one embodiment of the invention;
FIG. 2 shows a schematic diagram of a computing device 200 according to one embodiment of the invention;
FIG. 3 illustrates a flow chart of a data storage method 300 according to one embodiment of the invention;
FIG. 4 illustrates a flow chart of a data update method 400 according to one embodiment of the invention; and
FIG. 5 illustrates a flow chart of a data query method 500 according to one embodiment of the invention.
Detailed Description
Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.
The index data is a batch of data items calculated according to the collected original data, and the original data is collected by measuring points of all parts in all equipment of an enterprise. In general, index data is stored in two ways, that is, the data is stored in rows, that is, the data is divided into a plurality of rows, but in the manner of storing in rows, information such as a device name, a collection time and the like is redundant for the same device, and when all index data of a certain device needs to be queried or when data exists in the certain device, query performance is low.
The other is to store the data in columns, namely, the number of columns is set according to the data amount to be stored at the same time when designing the data storage table, the method stores all index data in one row, and the number of index fields is fixed, but the method is inconvenient to expand because the number of index fields is fixed. In addition, if the device indexes are not uniform when the device indexes are stored in columns, assuming that the device indexes are 6 for the device 1 and 5 for the device 2, if the device indexes are completely different from the device indexes of the device 1, 11 columns (i.e. fields) are required to be designed for storing the data, the number of columns of the data table is more difficult to control as the difference of the devices is larger, and meanwhile, invalid data is obviously increased for a single device, so that the storage space utilization rate is greatly reduced.
In order to solve the above-mentioned problems, the present invention proposes a data storage system 100, and fig. 1 shows a schematic diagram of the data storage system 100 according to an embodiment of the present invention. As shown in fig. 1, the data storage system 100 includes a computing device 200 and a storage device 110, the computing device 200 being communicatively coupled to the storage device 110, such as by a wired or wireless network connection.
The storage device 110 stores an index number correspondence table and a data storage table. The data storage table is used to store data, such as index data. The index number corresponding table comprises standard index numbers and a plurality of versions of actual index numbers corresponding to the standard index numbers, and each version of actual index number corresponds to one version number. It should be noted that, the index numbers in the data storage table are all standard index numbers after conversion (the actual index numbers are converted into standard index numbers according to the corresponding relationship between the actual index numbers and the standard index numbers in the index number correspondence table). The index number correspondence table has a part of the contents as shown in table 1:
TABLE 1
Table 1 shows the actual index numbers of the three versions. As can be seen from table 1, the actual index numbers of the version 1 are respectively 1, 2, 3, … … and 395, the corresponding standard index numbers are respectively t1, t2, t3, … … and t395, the actual index numbers of the version 2 are respectively t1, t2, t3, … …, 395 and t396, the corresponding standard index numbers are respectively t1, t2, t3, … …, t395 and t396, the actual index numbers of the version 3 are respectively 401, 2, 3, … …, 395, 396, 397, 398 and 399 and 400, and the corresponding standard index numbers are respectively t1, t2, t3, … …, t395, t396, t397, t398, t399 and t400.
In one embodiment, in order to meet the data amount requirement of index data of different components, the standard index number includes t1 to t400, which corresponds to a case of meeting 400 index data, but according to an actual scene, the index data amount included in one component does not exceed 400, so that the standard index number configured by the present invention can meet the actual application scene.
In one implementation, computing device 200 may be implemented as a server, such as an application server, web server, or the like; but not limited to, desktop computers, notebook computers, processor chips, tablet computers, and the like. The computing device 200 may be connected to the storage 110 and store the index data into a data storage table in the storage 110, and may also query an index number correspondence table in the storage 110. For example, the computing device 200 may directly read the index number correspondence table in the storage device 110, write the index data to the data storage table of the storage device 110 (when the storage device 110 is a local database of the computing device 200), or access the internet through a wired or wireless manner, and read the index number correspondence table in the storage device 110 through a data interface, and write the index data to the data storage table of the storage device 110.
In one embodiment, the storage device 110 may be a database, further, the database may be a relational database, for example MYSQL, sqlServer, ACCESS, etc., the database of the storage device 110 may be a local database residing in the computing device 200, or may be a distributed database, for example Hbase, etc., disposed at a plurality of geographic locations; the storage device 110 may also be a cache, such as a redis cache, etc., and in any case the storage device 110 is configured to store an index number correspondence table and a data storage table. The present invention is not limited to the specific deployment and configuration of storage device 110.
The data storage method of the present invention may be implemented in computing device 200. FIG. 2 illustrates a block diagram of a computing device 200 according to one embodiment of the invention. As shown in FIG. 2, in a basic configuration 202, a computing device 200 typically includes a system memory 206 and one or more processors 204. A memory bus 208 may be used for communication between the processor 204 and the system memory 206.
Depending on the desired configuration, the processor 204 may be any type of processing including, but not limited to: a microprocessor (μp), a microcontroller (μc), a digital information processor (DSP), or any combination thereof. Processor 204 may include one or more levels of cache, such as a first level cache 210 and a second level cache 212, a processor core 214, and registers 216. The example processor core 214 may include an Arithmetic Logic Unit (ALU), a Floating Point Unit (FPU), a digital signal processing core (DSP core), or any combination thereof. The example memory controller 218 may be used with the processor 204, or in some implementations, the memory controller 218 may be an internal part of the processor 204.
Depending on the desired configuration, system memory 206 may be any type of memory including, but not limited to: volatile memory (such as RAM), non-volatile memory (such as ROM, flash memory, etc.), or any combination thereof. The system memory 206 may include an operating system 220, one or more applications 222, and program data 224. In some implementations, the application 222 can be arranged to operate on an operating system with program data 224. The program data 224 includes instructions and in the computing device 200 according to the invention the program data 224 contains instructions for performing the data storage method 300, the data update method 400 and the data query method 500.
Computing device 200 also includes a storage device 232, where storage device 232 includes removable storage 236 and non-removable storage 238, where removable storage 236 and non-removable storage 238 are each connected to storage interface bus 234. In the present invention, the data related to each event occurring during the execution of the program and the time information indicating the occurrence of each event may be stored in the storage device 232, and the operating system 220 is adapted to manage the storage device 232. Wherein the storage device 232 may be a magnetic disk.
Computing device 200 may also include an interface bus 240 that facilitates communication from various interface devices (e.g., output devices 242, peripheral interfaces 244, and communication devices 246) to basic configuration 202 via bus/interface controller 230. The exemplary output device 242 includes an image processing unit 248 and an audio processing unit 250. They may be configured to facilitate communication with various external devices, such as a display or speakers, via one or more a/V ports 252. The example peripheral interface 244 may include a serial interface controller 254 and a parallel interface controller 256, which may be configured to facilitate communication via one or more I/O ports 258 and external devices such as input devices (e.g., keyboard, mouse, pen, voice input device, touch input device) or other peripherals (e.g., printer, scanner, etc.). The example communication device 246 may include a network controller 260 that may be arranged to facilitate communication with one or more other computing devices 262 over a network communication link via one or more communication ports 264.
The network communication link may be one example of a communication medium. Communication media may typically be embodied by computer readable instructions, data structures, program modules, and may include any information delivery media in a modulated data signal, such as a carrier wave or other transport mechanism. A "modulated data signal" may be a signal that has one or more of its data set or changed in such a manner as to encode information in the signal. By way of non-limiting example, communication media may include wired media such as a wired network or special purpose network, and wireless media such as acoustic, radio Frequency (RF), microwave, infrared (IR) or other wireless media. The term computer readable media as used herein may include both storage media and communication media.
Computing device 200 may be implemented as a server, such as a file server, database server, application server, WEB server, etc., as part of a small-sized portable (or mobile) electronic device, such as a cellular telephone, personal Digital Assistant (PDA), personal media player device, wireless WEB-watch device, personal headset device, application-specific device, or a hybrid device that may include any of the above functions. Computing device 200 may also be implemented as a personal computer including desktop and notebook computer configurations. In some embodiments, the applications 222 stored in the system memory 206 in the computing device 200 are configured to perform the data storage method 300, the data update method 400, and the data query method 500 according to the present invention.
FIG. 3 illustrates a flow chart of a data storage method 300 according to one embodiment of the invention. The method 300 is adapted to be executed in a computing device 200 (a computing device as described above), the method 300 comprising steps S301 to S308, the method 300 starting at step S301. In step S301, a data storage table and an index number correspondence table are created. Specifically, the standard index numbers are set, and the standard index numbers can be set according to the actual application scenario, which is not limited in the present invention, for example, the standard index numbers shown in table 1 are t1 to t400. And determining the corresponding relation between the actual index number and the standard index number to obtain an index number corresponding table, wherein part of the content of the index number corresponding table is shown in table 1 and is not repeated here. When the new defined actual index number appears, the corresponding relation between the new defined actual index number and the standard index number is determined, and the new defined actual index is stored in the index number corresponding table according to the corresponding relation with the standard index number.
And sets the fields of the data storage table, which in one embodiment includes the fields: component ID (part ID), measurement point ID (estimated), sampling time (measured), version number of actual index number (version), converted statistical index data (value), converted statistical index attribute (properties), thereby creating a data storage table with empty content.
Wherein the component ID is an identification of each component in the device. The data type of the station ID is a universal unique identification code (Universally Unique Identifier, UUID for short), and the purpose of the UUID is to enable all elements in the distributed system to have unique identification information, so that the station ID is unique. The sampling time is the actual time of the data acquisition of the measuring points. The version number of the actual index number is the version number shown in table 1, and the corresponding relation between the actual index number and the standard index number can be found from the index number corresponding table according to the version number of the actual index number, so that the actual meaning of each index data is determined.
The converted statistical index data is a set of all index data calculated according to the data acquired by the same measuring point at the same sampling time. In one embodiment, the data type of the converted statistical index data is a UDT type, the UDT is a user-defined data type, and the UDT data type stores a batch of data, that is, the UDT stores a batch of data as one data. That is, in the present invention, all index data of the same sampling time and the same measuring point are stored in one field, that is, all index data of the same sampling time and the same measuring point are stored as one data set in one column of the data storage table, the data set includes a plurality of data items, and each data item includes a standard index number and an index value corresponding to the standard index number. The definition of the UDT data structure is as follows:
In one embodiment, all index data of the same sampling time and the same measuring point are taken as one data set, but the data set is one key value pair set. That is, all index data of the same sampling time and the same measuring point are stored in one key value pair set, and the key (key) of each key value pair in the key value pair set is a standard index number and the key value (value) is an index value.
In one embodiment, the converted statistical index attribute includes attribute information of an index and waveform information of the index, and the waveform information of the index is a waveform of the index. The converted index attribute is a key value pair set, and when the index attribute is the attribute information of the index, the key (key) of each key value pair in the key value pair set is the standard index number, and the key value (value) is the attribute information corresponding to the standard index number. When the index attribute is the waveform information of the index, the key (key) of each key value pair in the key value pair set is a speed waveform identifier, a low acceleration waveform identifier and a high acceleration waveform identifier, and the key value (value) is a speed waveform ID, a low acceleration waveform ID and a high acceleration waveform ID respectively corresponding to the speed waveform identifier, the low acceleration waveform identifier and the high acceleration waveform identifier, and the corresponding speed waveform data, the low acceleration waveform data and the high acceleration waveform data can be found through the speed waveform ID, the low acceleration waveform ID and the high acceleration waveform ID.
It can be seen that each row in the data storage table stores a component ID, a measurement point ID, a sampling time, a version number of an actual index number, a set of all index data calculated from data acquired at the same measurement point and the same sampling time (the number corresponding to any index value in the set is a standard index number), and an index attribute set of all index data calculated from data acquired at the same measurement point and the same sampling time (the number corresponding to any attribute information in the set is a standard index number).
It should be noted that, an enterprise corresponds to a data storage table, where the enterprise includes one or more devices, each device includes one or more components, each component includes one or more measurement points, and the measurement point ID is unique, but since there is a case where one measurement point collects data of two components at the same time, the measurement point of the enterprise can be uniquely located by the measurement point ID and the component ID.
After the data storage table and the index number correspondence table are created, in step S302, the created data storage table and the index number correspondence table are stored, specifically, the created data storage table and the index number correspondence table are stored into the storage 110 communicatively connected to the computing apparatus 200.
Step S303 is then performed to obtain the data to be stored. The data to be stored comprises a plurality of data items, wherein each data item comprises equipment information, a version number of an actual index number, sampling time, index data and index attributes. The equipment information comprises an enterprise ID, an enterprise area, an equipment ID, a component ID and a measuring point ID, the enterprise can be determined according to the enterprise ID and the enterprise area, the equipment of the enterprise is determined according to the equipment ID, the component of the equipment is determined according to the component ID, and the specific measuring point of the component is determined according to the measuring point ID. The version number of the actual index number may be any character, so long as the actual index number versions of different versions are distinguished, the invention is not limited to this, for example, the version number of the actual index number is 1, 2, 3, etc. The sampling time is the actual time when the current measuring point collects the data of the component where the current measuring point is located, and the sampling time can comprise year, month, day, time, minute and second, for example 2021/7/14:21:02:08.
The index data is data calculated according to the data collected by each measuring point, and the data comprises an actual index number and an index value corresponding to the actual index number. The index attribute (i.e., attribute information of the index), the index may or may not have attribute information, and if there is no attribute information, the index attribute of the index is null. The index attribute includes an attribute value of an index and waveform information of the index, the waveform information of the index being a waveform of the index. The index attribute is data including an actual index number and attribute information corresponding to the actual index number when the index attribute is attribute information of the index. When the index attribute is waveform information of the index, the data includes a speed waveform identifier, a low acceleration waveform identifier, a high acceleration waveform identifier, and a speed waveform ID, a low acceleration waveform ID, a high acceleration waveform ID corresponding to the speed waveform identifier, the low acceleration waveform identifier, the high acceleration waveform identifier, respectively.
Step S304 is then executed to query the index number correspondence table for the correspondence between the actual index number corresponding to the version number of each actual index number and the standard index number. Step S305 is continuously executed, where multiple sets of statistical index data are obtained from all index data of the same sampling time of the same measuring point ID in the data to be stored, where each set of statistical index data includes one or more data items, and each data item includes an actual index number and an index value corresponding to the actual index number. In step S306, a plurality of sets of statistical index attributes are obtained from the attribute information of all index data of the same sampling time of the same measuring point ID counted by the data to be stored.
In one embodiment, each set of statistical index attributes is a set of key-value pairs, each set of key-value pairs includes one or more key-value pairs, and when the index attribute is the attribute information of the index, the key (key) of each key-value pair in the set of key-value pairs is the actual index number, and the key value (value) is the attribute information corresponding to the actual index number. When the index attribute is waveform information of the index, keys (keys) of each key value pair in the key value pair set are speed waveform identification, low acceleration waveform identification and high acceleration waveform identification, and key values (values) are speed waveform ID, low acceleration waveform ID and high acceleration waveform ID respectively corresponding to the speed waveform identification, the low acceleration waveform identification and the high acceleration waveform identification.
In step S307, the actual index number of each set of statistical data is converted into the standard index number according to the correspondence between the actual index number and the standard index number, so as to obtain the converted statistical index data and the converted statistical index attribute. Specifically, the actual index numbers in each set of the statistical index data obtained in step S305 and each set of the statistical index attributes obtained in step S306 are converted into step index numbers, and the converted statistical index data and the converted statistical index attributes are obtained.
For example, if the version number of the actual index number corresponding to the first set of statistical index data is 1, as shown in table 1, the actual index numbers with version numbers of 1 are respectively 1, 2, 3, … …, 395, and the corresponding standard index numbers are respectively t1, t2, t3, … …, t395, that is, the actual index numbers 1, 2, 3, … …, 395 corresponding to the first set of statistical index data are respectively converted into t1, t2, t3, … …, t395. If the version number of the actual index number corresponding to the second set of statistical index data is 2, as shown in table 1, the actual index numbers with the version number of 2 are respectively t1, t2, t3, … …, t395 and t396, and the corresponding standard index numbers are respectively t1, t2, t3, … …, t395 and t396, that is, the actual index numbers corresponding to the second set of statistical index data are respectively t1, t2, t3, … …, t395 and t396.
After converting the actual index numbers of the respective sets of statistical index data and statistical index attributes into standard index numbers, step S308 is performed, where a part ID (part ID) and a measurement point ID (integrated), a sampling time (measured), a version number (version) of the actual index numbers, a set of converted statistical index data (value) corresponding to the sampling time, and a set of converted statistical index attributes (properties) corresponding to the sampling time are stored as one line of data in a data storage table, that is, all index data of the same measurement point and the same sampling time are stored in a value field of the data storage table, and all index attributes of the same measurement point and the same sampling time are stored in a properties field of the data storage table. The partial contents of the data storage table storing the index data are as shown in table 2:
TABLE 2
As shown in Table 2, the first row data has station IDs d2411b3b-ca3f-e44a-9253-f04358181619, component IDs 14, and sample times 2021-07-14 21:02: 08. the actual index number version number is 1, the converted statistical index data is a data set { t1: -13.23156, t2:14.23438, t3: -17.44837, t4:null, t5:null } comprising 5 index data, and the converted statistical index attribute is a key value pair set { ' condition id ' comprising 3 key value pairs } -1', ' stock status '0', ' waveDataSource '0 '. Wherein, standard index numbers in the converted statistical index data are t1, t2, t3, t4 and t5 respectively, and the actual index number version number is 1, then the corresponding relationship between the standard index number with the index number version 1 and the actual index number is found from the table 1: the standard index numbers are t1, t2, t3, t4 and t5, and the actual index numbers are 1, 2, 3, 4 and 5. Therefore, the actual index numbers of the index data fields converted in the first row data in table 2 can be determined to be 1, 2, 3, 4, 5, respectively. The remaining data in table 2 are also analyzed in the manner described above and will not be described in detail herein.
From the above, even if the device indexes are not uniform, assuming that the device 1 has 6 indexes and the device 2 has 5 indexes, the indexes of the device 1 and the device 2 are completely different, in the invention, 11 columns do not need to be created, but the corresponding relation between the actual index number and the standard index number is determined from the index number corresponding table, and the expansibility of the index number is improved by changing the corresponding relation between the actual index number and the standard index number on the premise of not increasing the number of the standard index numbers. Secondly, under the condition that the equipment indexes are not uniform, the fields (all are standard index numbers) in the index corresponding table are unchanged, and only the actual index numbers corresponding to the standard index numbers in different index number versions are different, which is equivalent to the reusable standard index numbers, and the occupied storage space is the storage space occupied by the standard index numbers, so that the fields cannot be continuously and limitlessly increased, namely the occupation of the storage space cannot be increased, and the utilization rate of the storage space is improved.
In the data storage table, all index data of the same measuring point and the same sampling time are stored in the same field, namely, all index data of the same measuring point and the same sampling time are stored in one column of the data storage table, so that the occupied storage space is reduced, and the space utilization rate is improved. In addition, compared with the continuous increase of the number of columns along with the continuous increase of the index in the prior art, in the invention, the number of columns of the data storage table cannot be increased along with the increase of the index data because the index data are stored in one column, namely, the number of columns of the data storage table is fixed, so that the data storage table is easier to maintain.
The steps S301 to S308 are the complete process of creating the data storage table, the index number correspondence table and the stored data, and if the data storage table and the index number correspondence table are already created when the data is stored, then steps S303 to S308 are only required to be executed.
When it is desired to update data in a data storage table, as shown in FIG. 4, FIG. 4 shows a flow chart of a data update method 400 according to one embodiment of the invention. The method 400 includes steps S401 to S404.
In step S401, the device information, the actual index number, and the version number of the actual index number of the data to be updated are determined, and step S402 is executed, in which the correspondence between the actual index number corresponding to the version number of the actual index number and the standard index number is queried from the index number correspondence table, then in step S403, the standard index number of the data to be updated is determined according to the queried correspondence between the actual index number and the standard index number, and finally in step S404, the data item corresponding to the device information, the standard index number, and the version number of the actual index number of the data to be updated is queried from the data storage table, and the queried data item is updated, so that all the data in one column of the data storage table is updated, that is, all the index data in the same measuring point ID and the same sampling time can be updated once, and the data updating efficiency is improved.
FIG. 5 illustrates a flow chart of a data query method 500 according to one embodiment of the invention. The method 500 is suitable for being executed in the computing device 200 (the computing device described above), where the computing device 200 stores a data storage table and an index number correspondence table, where the data storage table is obtained by the method 300, the index data is stored in one field of the index data table, that is, all index times of the same measurement point and the same sampling time are stored in one column, and part of the content of the index number correspondence table is shown in table 1, which is not described herein again.
The method 500 includes steps S501 to S504, and the method 500 starts at step S501. In step S501, device information, an actual index number, and a version number of the actual index number of index data to be queried are determined, and measurement points of each component of each device in each enterprise can be distinguished by the device information. Step S502 is executed to query the corresponding relation between the actual index number corresponding to the version number of the actual index number and the standard index number from the index number corresponding table, and in step S503, the standard index number of the index data to be queried is determined according to the found corresponding relation between the actual index number and the standard index number, step S504 is executed to find the data to be queried from the data storage table through the equipment information, the version number of the actual index number and the standard index number of the index data to be queried.
From the above, since all index data of the same measuring point and the same sampling time are stored in one column, the index data can be rapidly searched according to the standard index number, the searching efficiency of the index data is improved, and the change of the service requirement can be more flexibly adapted.
A8 the method of A2, wherein any of the converted statistical index data is a set of key-value pairs.
The method of A9 to A4, wherein any one of the converted statistical indicator attributes is a set of key-value pairs.
The method of any one of A1 to A9, wherein the station ID is unique.
The method of any one of A1 to a10, a11 further comprising the step of:
when the actual index number is newly defined, the newly defined actual index number is stored in the index number corresponding table according to the corresponding relation with the standard index number.
A12 the method of any of A1 to a11, after storing the data to be stored to the data storage table, the method further comprising the steps of:
determining the equipment information, the actual index number and the version number of the actual index number of the data to be updated;
inquiring the corresponding relation between the actual index number corresponding to the version number of the actual index number and the standard index number from the index number corresponding table;
Determining the standard index number of the data to be updated according to the corresponding relation between the found actual index number and the standard index number;
and inquiring data items corresponding to the equipment information, the standard index number and the version number of the actual index number of the data to be updated from the data storage table, and updating the found data items.
The various techniques described herein may be implemented in connection with hardware or software or, alternatively, with a combination of both. Thus, the methods and apparatus of the present invention, or certain aspects or portions of the methods and apparatus of the present invention, may take the form of program code (i.e., instructions) embodied in tangible media, such as removable hard drives, U-drives, floppy diskettes, CD-ROMs, or any other machine-readable storage medium, wherein, when the program is loaded into and executed by a machine, such as a computer, the machine becomes an apparatus for practicing the invention.
In the case of program code execution on programmable computers, the computing device will generally include a processor, a storage medium readable by the processor (including volatile and non-volatile memory and/or storage elements), at least one input device, and at least one output device. Wherein the memory is configured to store program code; the processor is configured to execute the data storage method and the data query method of the present invention in accordance with instructions in said program code stored in the memory.
By way of example, and not limitation, readable media comprise readable storage media and communication media. The readable storage medium stores information such as computer readable instructions, data structures, program modules, or other data. Communication media typically embodies computer readable instructions, data structures, program modules or other data in a modulated data signal such as a carrier wave or other transport mechanism and includes any information delivery media. Combinations of any of the above are also included within the scope of readable media.
In the description provided herein, algorithms and displays are not inherently related to any particular computer, virtual system, or other apparatus. Various general-purpose systems may also be used with examples of the invention. The required structure for a construction of such a system is apparent from the description above. In addition, the present invention is not directed to any particular programming language. It will be appreciated that the teachings of the present invention described herein may be implemented in a variety of programming languages, and the above description of specific languages is provided for disclosure of enablement and best mode of the present invention.
In the description provided herein, numerous specific details are set forth. However, it is understood that embodiments of the invention may be practiced without these specific details. In some instances, well-known methods, structures and techniques have not been shown in detail in order not to obscure an understanding of this description.
Similarly, it should be appreciated that in the foregoing description of exemplary embodiments of the invention, various features of the invention are sometimes grouped together in a single embodiment, figure, or description thereof for the purpose of streamlining the disclosure and aiding in the understanding of one or more of the various inventive aspects. However, the disclosed method should not be construed as reflecting the intention that: i.e., the claimed invention requires more features than are expressly recited in each claim. Rather, as the following claims reflect, inventive aspects lie in less than all features of a single foregoing disclosed embodiment. Thus, the claims following the detailed description are hereby expressly incorporated into this detailed description, with each claim standing on its own as a separate embodiment of this invention.
Those skilled in the art will appreciate that the modules or units or components of the devices in the examples disclosed herein may be arranged in a device as described in this embodiment, or alternatively may be located in one or more devices different from the devices in this example. The modules in the foregoing examples may be combined into one module or may be further divided into a plurality of sub-modules.
Those skilled in the art will appreciate that the modules in the apparatus of the embodiments may be adaptively changed and disposed in one or more apparatuses different from the embodiments. The modules or units or components of the embodiments may be combined into one module or unit or component and, furthermore, they may be divided into a plurality of sub-modules or sub-units or sub-components. Any combination of all features disclosed in this specification (including any accompanying claims, abstract and drawings), and all of the processes or units of any method or apparatus so disclosed, may be used in combination, except insofar as at least some of such features and/or processes or units are mutually exclusive. Each feature disclosed in this specification (including any accompanying claims, abstract and drawings), may be replaced by alternative features serving the same, equivalent or similar purpose, unless expressly stated otherwise.
Furthermore, those skilled in the art will appreciate that while some embodiments described herein include some features but not others included in other embodiments, combinations of features of different embodiments are meant to be within the scope of the invention and form different embodiments. For example, in the following claims, any of the claimed embodiments can be used in any combination.
Furthermore, some of the embodiments are described herein as methods or combinations of method elements that may be implemented by a processor of a computer system or by other means of performing the functions. Thus, a processor with the necessary instructions for implementing the described method or method element forms a means for implementing the method or method element. Furthermore, the elements of the apparatus embodiments described herein are examples of the following apparatus: the apparatus is for carrying out the functions performed by the elements for carrying out the objects of the invention.
As used herein, unless otherwise specified the use of the ordinal terms "first," "second," "third," etc., to describe a general object merely denote different instances of like objects, and are not intended to imply that the objects so described must have a given order, either temporally, spatially, in ranking, or in any other manner.
While the invention has been described with respect to a limited number of embodiments, those skilled in the art, having benefit of the above description, will appreciate that other embodiments are contemplated within the scope of the invention as described herein. Furthermore, it should be noted that the language used in the specification has been principally selected for readability and instructional purposes, and may not have been selected to delineate or circumscribe the inventive subject matter. Accordingly, many modifications and variations will be apparent to those of ordinary skill in the art without departing from the scope and spirit of the appended claims. The disclosure of the present invention is intended to be illustrative, but not limiting, of the scope of the invention, which is defined by the appended claims.
Claims (15)
1. A data storage method executed in a computing device, where a data storage table and an index number correspondence table are stored in the computing device, where the index number correspondence table includes a standard index number and a plurality of versions of actual index numbers corresponding to the standard index number, and each version of actual index number corresponds to a version number, the method comprising:
acquiring data to be stored, wherein the data to be stored comprises a plurality of data items, each data item comprises index data and a version number of an actual index number, and the index data comprises the actual index number and an index value corresponding to the actual index number;
inquiring the corresponding relation between the actual index number corresponding to the version number of each actual index number and the standard index number from the index number corresponding table;
converting each actual index number into a corresponding standard index number according to the corresponding relation between the actual index number and the standard index number, and obtaining converted data to be stored;
and storing the converted data to be stored into the data storage table.
2. The method of claim 1, wherein each data item in the data to be stored further comprises device information, a sampling time, the device information comprising a site ID, the method further comprising the steps of:
Counting all index data of the same measuring point ID at the same sampling time to obtain a plurality of groups of statistical index data;
the step of converting each actual index number into a corresponding standard index number according to the corresponding relation between the actual index number and the standard index number to obtain converted data to be stored comprises the following steps:
and converting the actual index number of each group of statistical index data into the corresponding standard index number according to the corresponding relation between the actual index number and the standard index number, and obtaining a plurality of groups of converted statistical index data.
3. The method of claim 2, wherein storing the converted data to be stored in the data storage table comprises:
and storing the equipment information, the sampling time and a group of converted statistical index data corresponding to the sampling time into the data storage table as one row of data.
4. A method as claimed in claim 3, wherein each data item in the data to be stored further comprises an index attribute, the method further comprising the steps of:
counting all index attributes of the same measuring point ID at the same sampling time to obtain a plurality of groups of statistical index attributes;
And converting the actual index number in each group of the statistical index attributes into the corresponding standard index number according to the corresponding relation between the actual index number and the standard index number, so as to obtain a plurality of groups of converted statistical index attributes.
5. The method of claim 4, wherein storing the converted data to be stored in the data storage table further comprises:
and storing the equipment information, the sampling time, a group of converted statistical index data corresponding to the sampling time and a group of converted statistical index attributes corresponding to the sampling time into the data storage table as one line of data.
6. The method of claim 4, wherein the device information further includes a component ID, and the data storage table includes one or more of a component ID field, a station ID field, a sampling time field, a version number field of an actual index number, a converted statistical index data field, and a converted statistical index attribute field, where the converted statistical index data field stores all converted index data at the same sampling time of the same station ID, and the converted statistical index attribute stores all converted attribute information at the same sampling time of the same station ID.
7. The method of claim 2, wherein the data type of any one of the converted sets of statistical indicator data is a UDT data type.
8. The method of claim 2, wherein any of said converted statistical index data is a set of key-value pairs.
9. The method of claim 4, wherein any one of the converted statistical indicator attributes is a set of key-value pairs.
10. A method according to any one of claims 2 to 9, wherein the station ID is unique.
11. The method of any one of claims 1 to 9, further comprising the step of:
when the actual index number is newly defined, the newly defined actual index number is stored in the index number corresponding table according to the corresponding relation with the standard index number.
12. The method according to any one of claims 1 to 9, further comprising, after storing the data to be stored to the data storage table, the steps of:
determining equipment information, an actual index number and a version number of the actual index number of the data to be updated;
inquiring the corresponding relation between the actual index number corresponding to the version number of the actual index number and the standard index number from the index number corresponding table;
Determining the standard index number of the data to be updated according to the corresponding relation between the found actual index number and the standard index number;
and inquiring data items corresponding to the equipment information, the standard index number and the version number of the actual index number of the data to be updated from the data storage table, and updating the found data items.
13. A data query method performed in a computing device, in which a data storage table and an index number correspondence table are stored, wherein the data storage table is obtained according to the method of any one of claims 1 to 12, the index number correspondence table includes a standard index number and a plurality of versions of actual index numbers corresponding to the standard index number, and the actual index number of each version corresponds to a version number, the method comprising:
determining equipment information, an actual index number and a version number of the actual index number of index data to be queried, and distinguishing measuring points of all parts of all equipment in all enterprises through the equipment information;
inquiring the corresponding relation between the actual index number corresponding to the version number of the actual index number and the standard index number from the index number corresponding table;
Determining the standard index number of the index data to be queried according to the corresponding relation between the found actual index number and the standard index number;
and searching the data to be queried from the data storage table through the equipment information, the version number of the actual index number and the standard index number of the index data to be queried.
14. A computing device, comprising:
at least one processor; and
a memory storing program instructions, wherein the program instructions are configured to be adapted to be executed by the at least one processor, the program instructions comprising instructions for performing the method of any of claims 1-13.
15. A readable storage medium storing program instructions which, when read and executed by a mobile terminal, cause the mobile terminal to perform the method of any of claims 1-13.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110845231.2A CN113535734B (en) | 2021-07-26 | 2021-07-26 | Data storage method, data query method and computing device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110845231.2A CN113535734B (en) | 2021-07-26 | 2021-07-26 | Data storage method, data query method and computing device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113535734A CN113535734A (en) | 2021-10-22 |
| CN113535734B true CN113535734B (en) | 2023-07-07 |
Family
ID=78089014
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110845231.2A Active CN113535734B (en) | 2021-07-26 | 2021-07-26 | Data storage method, data query method and computing device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113535734B (en) |
Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2017071525A1 (en) * | 2015-10-30 | 2017-05-04 | 北京国双科技有限公司 | Data storage method and apparatus and data query method and apparatus |
| CN108287668A (en) * | 2018-01-25 | 2018-07-17 | 深圳市智物联网络有限公司 | Processing method and processing device, computer installation and the readable storage medium storing program for executing of device data |
| CN109033174A (en) * | 2018-06-21 | 2018-12-18 | 北京国网信通埃森哲信息技术有限公司 | A kind of power quality data cleaning method and device |
| CN109272215A (en) * | 2018-08-31 | 2019-01-25 | 平安科技（深圳）有限公司 | Project development quality control method, device, computer equipment and storage medium |
| WO2019203693A1 (en) * | 2018-04-16 | 2019-10-24 | Ооо "Регул+" | Method of designing information space topology for a management information system |
| CN110619465A (en) * | 2019-09-16 | 2019-12-27 | 上海移远通信科技有限公司 | Data storage method, data query method, data storage system, data query system, electronic equipment and storage medium |
| WO2020088344A1 (en) * | 2018-10-31 | 2020-05-07 | 北京数聚鑫云信息技术有限公司 | Api version control method, apparatus, device, and medium |
| CN111352955A (en) * | 2020-02-23 | 2020-06-30 | 中国平安财产保险股份有限公司 | Index data query method and device, electronic equipment and storage medium |
| CN112307017A (en) * | 2020-09-16 | 2021-02-02 | 北京沃东天骏信息技术有限公司 | Data storage method, query method, related equipment and storage medium |
| CN112633761A (en) * | 2020-12-31 | 2021-04-09 | 中国平安财产保险股份有限公司 | Index data query method, device, equipment and storage medium |
| CN112765163A (en) * | 2020-12-31 | 2021-05-07 | 蔚来汽车科技(安徽)有限公司 | Data index storage method, system and device capable of extending dimensionality at will |
| CN112860695A (en) * | 2021-02-08 | 2021-05-28 | 北京百度网讯科技有限公司 | Monitoring data query method, device, equipment, storage medium and program product |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080059492A1 (en) * | 2006-08-31 | 2008-03-06 | Tarin Stephen A | Systems, methods, and storage structures for cached databases |
-
2021
- 2021-07-26 CN CN202110845231.2A patent/CN113535734B/en active Active
Patent Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2017071525A1 (en) * | 2015-10-30 | 2017-05-04 | 北京国双科技有限公司 | Data storage method and apparatus and data query method and apparatus |
| CN108287668A (en) * | 2018-01-25 | 2018-07-17 | 深圳市智物联网络有限公司 | Processing method and processing device, computer installation and the readable storage medium storing program for executing of device data |
| WO2019203693A1 (en) * | 2018-04-16 | 2019-10-24 | Ооо "Регул+" | Method of designing information space topology for a management information system |
| CN109033174A (en) * | 2018-06-21 | 2018-12-18 | 北京国网信通埃森哲信息技术有限公司 | A kind of power quality data cleaning method and device |
| CN109272215A (en) * | 2018-08-31 | 2019-01-25 | 平安科技（深圳）有限公司 | Project development quality control method, device, computer equipment and storage medium |
| WO2020088344A1 (en) * | 2018-10-31 | 2020-05-07 | 北京数聚鑫云信息技术有限公司 | Api version control method, apparatus, device, and medium |
| CN110619465A (en) * | 2019-09-16 | 2019-12-27 | 上海移远通信科技有限公司 | Data storage method, data query method, data storage system, data query system, electronic equipment and storage medium |
| CN111352955A (en) * | 2020-02-23 | 2020-06-30 | 中国平安财产保险股份有限公司 | Index data query method and device, electronic equipment and storage medium |
| CN112307017A (en) * | 2020-09-16 | 2021-02-02 | 北京沃东天骏信息技术有限公司 | Data storage method, query method, related equipment and storage medium |
| CN112633761A (en) * | 2020-12-31 | 2021-04-09 | 中国平安财产保险股份有限公司 | Index data query method, device, equipment and storage medium |
| CN112765163A (en) * | 2020-12-31 | 2021-05-07 | 蔚来汽车科技(安徽)有限公司 | Data index storage method, system and device capable of extending dimensionality at will |
| CN112860695A (en) * | 2021-02-08 | 2021-05-28 | 北京百度网讯科技有限公司 | Monitoring data query method, device, equipment, storage medium and program product |
Non-Patent Citations (5)
| Title |
|---|
| A system for the rapid design and implementation of Personalized Agricultural Key Performance Indicators issued from sensor data;Sandro Bimonte 等;Computers and Electronics in Agriculture;1-12 * |
| Storage and Retrieval Architecture based on Key-Value Solid State Device Key-Value Solid State Device;Sun Yu Xiang 等;The Journal of the Korea institute of electronic communication sciences(第1期);45-52 * |
| 物联网感知大数据分层存储和查询技术研究;蔺春华;中国优秀硕士学位论文全文数据库 信息科技辑(第5期);I136-352 * |
| 面向舰船识别应用的大数据存储与查询技术;黄亮;中国优秀硕士学位论文全文数据库 工程科技Ⅱ辑(第1期);C036-162 * |
| 面向金融行业的大数据迁移的研究与实现;王永超 等;计算机工程与应用(第13期);93-99 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113535734A (en) | 2021-10-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102567421B (en) | Document retrieval method and device | |
| CN108932286B (en) | Data query method and device | |
| CN113704243A (en) | Data analysis method, data analysis device, computer device, and storage medium | |
| CN104811424A (en) | Malicious user identification method and device | |
| CN109656986A (en) | A kind of householder method that business datum summarizes, device and electronic equipment | |
| CN110737747A (en) | data operation method, device and system | |
| CN113704307A (en) | Data query method, device, server and computer readable storage medium | |
| CN115145871A (en) | File query method and device and electronic equipment | |
| CN114564620A (en) | Graph data storage method and system and computer equipment | |
| CN111090649A (en) | Data information paging query method and device, computer equipment and storage medium | |
| CN111159183A (en) | Report generation method, electronic device and computer readable storage medium | |
| CN113609128A (en) | Method and device for generating database entity class, terminal equipment and storage medium | |
| CN113535734B (en) | Data storage method, data query method and computing device | |
| CN110795920B (en) | Document generation method and device | |
| CN117390011A (en) | Report data processing method, device, computer equipment and storage medium | |
| CN116186337A (en) | Business scene data processing method, system and electronic equipment | |
| CN111782661B (en) | Data storage method, data query method and device | |
| CN114648010A (en) | Data table standardization method, device, equipment and computer storage medium | |
| CN113722296A (en) | Agricultural information processing method and device, electronic equipment and storage medium | |
| CN102567420B (en) | Document retrieval method and device | |
| CN113536188A (en) | Data storage method, data query method, computing device and storage medium | |
| CN113515504B (en) | Data management method, device, electronic equipment and storage medium | |
| CN117113090B (en) | Data source label marking method and device and electronic equipment | |
| CN113535770B (en) | Data query method and device | |
| CN115408491B (en) | Text retrieval method and system for historical data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |