CN115374109A - Data access method, device, computing equipment and system - Google Patents

Data access method, device, computing equipment and system Download PDF

Info

Publication number
CN115374109A
CN115374109A CN202210908140.3A CN202210908140A CN115374109A CN 115374109 A CN115374109 A CN 115374109A CN 202210908140 A CN202210908140 A CN 202210908140A CN 115374109 A CN115374109 A CN 115374109A
Authority
CN
China
Prior art keywords
attribute
combined
data
data table
target
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.)
Granted
Application number
CN202210908140.3A
Other languages
Chinese (zh)
Other versions
CN115374109B (en
Inventor
贺承汉
黄凯耀
胡正策
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Huawei Technologies Co Ltd
Original Assignee
Huawei Technologies Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Huawei Technologies Co Ltd filed Critical Huawei Technologies Co Ltd
Priority to CN202210908140.3A priority Critical patent/CN115374109B/en
Publication of CN115374109A publication Critical patent/CN115374109A/en
Application granted granted Critical
Publication of CN115374109B publication Critical patent/CN115374109B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2455Query execution
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/248Presentation of query results
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/258Data format conversion from or to a database

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Software Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The application relates to the technical field of computers, and discloses a data access method, a device, a computing device and a system, wherein the method comprises the following steps: if an object access request is received, acquiring an object data table corresponding to a target object according to a target object identifier of the target object indicated by the object access request, wherein the object data table comprises attribute values of the target object under multiple attributes, and the attribute values of the target object under the multiple attributes are obtained by processing reported information corresponding to the attributes according to a data processing mode corresponding to the attributes indicated by an object model corresponding to the target object; and sending the object data table of the target object to the client. According to the scheme, the attribute values of the object under multiple attributes can be acquired through one request, and the data acquisition efficiency is improved.

Description

Data access method, device, computing equipment and system
Technical Field
The present application relates to the field of computers, and in particular, to a data access method, apparatus, computing device, and system.
Background
Under the scene of industrial internet of things, a large-scale device may need a plurality of sensors to detect parameters of the device in various aspects, for example, for a numerical control machine, the temperature needs to be detected by a temperature sensor, the rotating speed is detected by a rotating speed sensor, and the like. In the related art, the reported information detected by each sensor is generally stored in a database. On the basis, if the temperature and the rotating speed of the data machine tool need to be acquired, the temperature and the rotating speed are acquired from the database according to the equipment identification of the sensor from which the temperature and the rotating speed of the numerical control machine tool are derived, then the temperature and the rotating speed are integrated, and finally the integrated data are sent to an access party. The data storage mode has the problem of low data acquisition efficiency.
Disclosure of Invention
The application provides a data access method, a data access device, computing equipment and a data access system, and aims to solve the problem of low data acquisition efficiency in the related technology.
In a first aspect, a data access method is provided, including: if an object access request is received, acquiring an object data table corresponding to a target object according to a target object identifier of the target object indicated by the object access request, wherein the object data table comprises attribute values of the target object under multiple attributes, and the attribute values of the target object under the multiple attributes are obtained by processing reported information corresponding to the attributes according to a data processing mode corresponding to the attributes indicated by an object model corresponding to the target object; and sending the object data table of the target object to the client.
In the scheme of the application, the data processing modes corresponding to the multiple attributes of the object are indicated through the object model of the object, the reported information corresponding to the attributes is processed according to the data processing mode corresponding to each attribute, the attribute values of each attribute are correspondingly obtained, and then the attribute values of the object under the multiple attributes are stored in the object data table in an associated mode. On the basis, after an object access request initiated by a client is received, an object data table of a target object requested to be accessed is correspondingly obtained, and the object data table is sent to the client.
In a possible implementation manner, before the object data table corresponding to the target object is obtained, the method further includes: acquiring an object model configured for an object, wherein the object model indicates a plurality of attributes defined for the object and data processing modes corresponding to the attributes; processing the reported information corresponding to each attribute of the object according to the data processing mode corresponding to each attribute to obtain the attribute value of the object under each attribute; and integrating the attribute values of the object under the plurality of attributes into an object data table corresponding to the object.
Based on the possible implementation manner, the attribute values of the object under the multiple attributes are stored in the object data table after the reported information is processed, so that after the data related to the object needs to be accessed, the reported information does not need to be processed and data integration is not needed after a request is received, the response time of the access request of the object is greatly shortened, the data acquisition efficiency is further ensured, and the user experience is improved.
In a possible implementation, the object model further indicates source device identifiers corresponding to the attributes of the object; according to the data processing mode corresponding to each attribute, processing the reported information corresponding to each attribute of the object, and before obtaining the attribute value of the object under each attribute, the method also comprises the following steps: and acquiring the reported information corresponding to each attribute of the object in the reported data set according to the source equipment identifier corresponding to each attribute.
In one possible implementation, the data processing mode indicates a conversion mode between an original data format and a target data format; according to the data processing mode corresponding to each attribute, processing the reported information corresponding to each attribute of the object to obtain the attribute value of the object under each attribute, comprising: determining an original data format to which reported information corresponding to an attribute belongs; and carrying out format conversion on the reported information corresponding to the attribute according to a conversion mode between the original data format and the target data format to obtain an attribute value of the attribute corresponding to the target data format.
In one possible implementation, the data processing mode indicates an extraction mode of the attribute value; according to the data processing mode corresponding to each attribute, processing the reported information corresponding to each attribute of the object to obtain the attribute value of the object under each attribute, comprising: and according to the extraction mode of the attribute value indicated by the data processing mode, extracting the attribute value corresponding to the attribute from the report information corresponding to the attribute.
In a possible implementation manner, the reported information in the reported data set is stored in a partition mode according to the source equipment; in this case, the report information corresponding to each attribute may be obtained according to the following procedure: matching the equipment identifiers according to the corresponding relation between the equipment identifiers and the storage positions and the source equipment identifiers corresponding to the attributes to determine the storage positions of the reported information corresponding to the attributes; and acquiring the reporting information corresponding to each attribute from the storage position of the reporting information corresponding to each attribute.
Based on the possible implementation manner, since the reporting information is stored in a partitioned manner according to the source device, the orderly storage of the reporting information is facilitated, and the reporting information corresponding to each attribute is rapidly acquired based on the source device identifier corresponding to each attribute.
In a second aspect, a data access method is provided, including: receiving a combined object access request, wherein the combined object access request comprises a target combined identifier of a target combined object; acquiring a combined object view of the target combined object according to the target combined identifier; sending a combined object view of the target combined object to the client; the combined object view of the target combined object is generated according to the object data table of the plurality of objects included in the target combined object and the incidence relation among the plurality of objects included in the target combined object; the object data table of the object comprises attribute values of the object under a plurality of attributes, and the attribute values of the object under the plurality of attributes are obtained by processing the reported information corresponding to each attribute according to the data processing mode corresponding to each attribute indicated by the object model corresponding to the object.
In the above possible implementation manner, on the basis of generating the combined object view for the combined object, the combined object view of the target combined object may be returned to the client in response to the combined object access request initiated by the client, so that data of multiple objects associated with the combined object may be obtained by initiating a request once, and the data acquisition efficiency is improved.
In one possible implementation, the method further includes: acquiring a combined object model configured for the combined object, wherein the combined object model indicates a plurality of objects included in the combined object and an incidence relation among the plurality of objects; acquiring an object data table corresponding to each object included in the combined object; and generating a combined object view corresponding to the combined object according to the incidence relation among the objects and the object data table corresponding to the objects included in the combined object.
Based on the above possible implementation manner, on the basis of taking the object as a unit of data storage, the object data tables of multiple objects are further integrated through the configured combined object model to obtain a combined object view of the combined object, so that an access service of the combined object view can be provided for the client based on the generated combined object view.
In one possible implementation, the method further includes: generating an access interface, wherein the access interface comprises at least one of a first access interface of an object data table corresponding to an object and a second access interface of a combined object view corresponding to a combined object; and issuing the generated access interface. Based on the issued access interface, when data related to the object needs to be accessed, the object data table of the object can be acquired through the first access interface, and when data related to the combined object needs to be accessed, the combined object view of the combined object can be acquired through the second access interface.
In one possible implementation, the method further includes: and synchronizing the object data table corresponding to the object and the combined object view corresponding to the combined object to a database at the cloud end. Based on the possible implementation manners, the client may also access the database of the cloud to obtain the object data table of the object and the combined object view of the combined object.
In a third aspect, there is provided a data access apparatus comprising means for performing the data access method of the first aspect or any one of the possible designs of the first aspect; or the data access apparatus comprises means for performing the data access method of the second aspect or any one of the possible designs of the second aspect.
In a fourth aspect, there is provided a processor for performing the operational steps of the data access method of the first aspect or any one of the possible designs of the first aspect; or for performing the operational steps of the data access method of the second aspect or any one of the possible designs of the first aspect.
In a fifth aspect, a computing device is provided that includes at least one processor and a memory for storing a set of computer instructions; when the processor executes a set of computer instructions as an execution device in any one of the possible implementations of the first aspect or the first aspect, the operational steps of the data access method in any one of the possible implementations of the first aspect or the first aspect are performed; alternatively, when the processor executes a set of computer instructions as an execution device in any one of the possible implementations of the second aspect or the second aspect, the operational steps of the data access method in any one of the possible implementations of the second aspect or the second aspect are performed
In a sixth aspect, a computer-readable storage medium is provided, comprising: comprising a memory and a processor, the memory for storing a set of computer instructions; implementing the operational steps of the data access method as in the first aspect or any one of the possible implementations of the first aspect when a processor executes a set of computer instructions; or implementing the operational steps of the data access method as in the second aspect or any one of the possible implementations of the second aspect.
In a seventh aspect, a data access system is provided, including: the data acquisition equipment is used for acquiring the reported information of the object under the attributes and sending the reported information to the computing equipment; the computing device is configured to implement, for example, the data access method in the first aspect or any one of possible implementation manners of the first aspect, according to the report information of the object under the multiple attributes; or implementing a data access method as in the second aspect or any one of the possible implementations of the second aspect.
In an eighth aspect, a computer program product is provided, which, when run on a computing device, causes the computing device to perform the operational steps of the data access method as described in the first aspect or any one of the possible implementations of the first aspect; alternatively, the operational steps of the data access method according to the second aspect or any one of the possible implementations of the second aspect are performed.
The present application can further combine to provide more implementations on the basis of the implementations provided by the above aspects.
Drawings
FIG. 1 is a schematic diagram of a data access system provided herein;
FIG. 2 is a flow chart of a data access method provided herein;
FIG. 3 is a schematic diagram of creating an object data table and generating an access interface according to an object model according to the present application;
FIG. 4 is a flow chart of a method for generating a combined object view provided herein;
FIG. 5 is a schematic diagram of generating a combined object view and generating an access interface from a combined object model according to the present application;
FIG. 6 is a schematic diagram of a data access system provided herein;
FIG. 7 is a flow chart of a data processing provided herein;
FIG. 8 is a block diagram of a data access device provided herein;
fig. 9 is a schematic structural diagram of a computing device provided in the present application.
Detailed Description
For ease of understanding, the terms referred to in this application will first be described specifically:
object: it may be an actual thing or a logical concept, and for example, the object may be an industrial device, a base station, a server cluster, a smart home system, an in-vehicle system, or the like.
Combining the objects: for example, if a smart television, a smart speaker, and a smart light bulb are respectively used as one object, a smart home system including the smart television, the smart speaker, and the smart light bulb may be regarded as one combined object.
View: refers to a virtual table in a database whose contents are defined by a Query, and may also be understood as a view that is a Structured Query Language (SQL) statement of a Query stored in the database. As with a real data table, a view includes a series of row and column data with names, but the view does not exist in the database in the form of stored data values, and the row and column data in the view come from the data table to which the query defining the view applies, and are dynamically generated as the view is applied. The real data table only uses physical storage space, the view does not occupy the physical storage space, the view is only the existence of a logic concept, the data table can be modified instantly, but the view can be modified only by modifying the created statement.
In an industrial internet of things scene, if attribute values detected by each sensor for equipment are respectively stored in a database, under the condition that attribute values of multiple attributes of the equipment need to be acquired, the database needs to be accessed for multiple times, and even further, the attribute values of the multiple attributes of the equipment acquired by accessing the database for multiple times are integrated, so that the problem of low data acquisition efficiency exists. In order to solve the problem, the scheme of the application is provided.
In the scheme of the application, the data processing modes corresponding to the multiple attributes of the object are indicated through the object model of the object, the reported information corresponding to the attributes is processed according to the data processing mode corresponding to each attribute, the attribute values of each attribute are correspondingly obtained, and then the attribute values of the object under the multiple attributes are stored in the object data table in an associated mode. On the basis, after an object access request initiated by a client is received, an object data table of a target object requested to be accessed is correspondingly obtained, and the object data table is sent to the client.
The technical scheme to be protected by the application is detailed in the following with reference to the attached drawings.
Fig. 1 is a schematic diagram illustrating a data access system according to an embodiment of the present application, and as shown in fig. 1, the data access system includes a terminal 110 and a server 120 communicatively connected to the terminal 110. The terminal 110 may be a smart phone, a tablet computer, a notebook computer, a desktop computer, a vehicle-mounted device, a service terminal, etc., and is not particularly limited herein. The server 120 may be a physical server or a cloud server.
The server 120 is deployed with a database, and the database stores data such as an object data table of an object, based on which, the server 120 may provide a data access service related to the object to the terminal, that is, after receiving an object access request initiated by the terminal 110, the server 120 obtains the object data table corresponding to the target object from the database according to a target object identifier indicated by the object access request, and returns the object data table of the target object to the terminal 110.
In the present application, the data table of the object stored in the database includes attribute values of the object under a plurality of attributes. The attribute values of the object under the attributes are obtained by processing the reported information corresponding to the attributes according to the data processing mode configured for each attribute in the object model corresponding to the object.
The property of the object refers to a parameter for describing the object, and for example, the property may be temperature, humidity, operating time, rotational speed, or the like. An object can be described under multiple attributes. For example, if the object is a numerical control machine, the attribute of the object may be temperature, humidity, rotation speed, operating voltage, operating current, continuous operating time, and the like.
The object model of the object may be obtained by performing model configuration at the administrator client, that is, the user may define the attributes used for describing the object and the data processing modes corresponding to the attributes at the administrator client, and then the administrator client uploads the configured object model to the server 120 correspondingly.
The data access system further includes a data acquisition device 130, where the reported information corresponding to each attribute of the object may be obtained by data acquisition performed by the data acquisition device, and the data acquisition device 130 is, for example, various sensors (temperature sensor, humidity sensor, and rotation speed sensor), an image acquisition device, an ammeter, a voltmeter, and a flowmeter. After the data acquisition device 130 reports the report information to the server, the server 120 may process the report information corresponding to each attribute according to the object model configured for the object and the data processing mode corresponding to each attribute, so as to obtain the attribute value corresponding to the object under each attribute; and then correspondingly integrating the attribute values of the object under the plurality of attributes into an object data table of the object.
On this basis, the server 120 may provide a data access service to the terminal based on the object data table of the stored object, and if the server 120 receives the object access request sent by the terminal 110, the server correspondingly acquires the object data table of the requested access object from the database, and since the object data table includes attribute values of the object under multiple attributes, the terminal 110 may acquire the attribute values of the object under multiple attributes by initiating an access request once, thereby improving data acquisition efficiency.
Further, the user may configure a combined object model of the combined object at the administrator client, the combined object model indicating a plurality of objects included in the combined object and an association relationship between the plurality of objects. After the administrator client sends the combined object model of the combined object to the server 120, the server 120 may correspondingly obtain the object data table of each object included in the combined object according to the plurality of objects included in the combined object indicated by the combined object model, and generate the combined object view of the combined object according to the object data table of each object included in the combined object and the association relationship between the plurality of objects indicated by the combined object model. Thus, if the terminal 110 initiates a combined object access request to the server 120, the server 120 may obtain a combined object view of the combined object and send the combined object view to the terminal 110. In this way, the terminal 110 may acquire data of a plurality of objects associated with the combined object by initiating an access request once, thereby improving data acquisition efficiency.
Fig. 2 is a flowchart of a data access method provided in the present application, where the data access method may be executed by the server in fig. 1, and may also be executed by other computing devices with processing capability. As shown in fig. 2, the method includes at least steps 210-230, described in detail below:
step 210, receiving an initiated object access request, where the object access request includes a target object identifier of a target object.
The object access request refers to a request for accessing data related to an object, in the present application, an object corresponding to the data requested to be accessed by the object access request is referred to as a target object, and the target object identifier is used for uniquely identifying the target object.
Step 220, according to the target object identifier, an object data table corresponding to the target object is obtained, where the object data table includes attribute values of the target object under multiple attributes, and the attribute values of the target object under the multiple attributes are obtained by processing the reported information corresponding to each attribute according to the data processing mode corresponding to each attribute indicated by the object model corresponding to the target object.
The attribute of the object refers to a parameter for describing the object, and correspondingly, the attribute value of the object under the attribute can also be understood as a parameter value of the corresponding parameter; such as temperature, humidity, rotational speed, etc. Different objects, there are also differences in the attributes used to describe the objects.
Generally, information acquisition is carried out on an object by data acquisition equipment such as a sensor and the like, so that corresponding reported information of the object under each attribute is obtained; the reported information corresponding to the attribute can also be understood as the collected information used for indicating the corresponding attribute value and collected in the data collection device. The data acquisition device can send the acquired report information to the server for temporary storage, so that the report information can be further processed based on the data processing mode corresponding to each attribute in the object model.
In this case, the reported information corresponding to the attribute may need to be further processed, and a processing result obtained by the further processing may be used as the attribute value corresponding to the attribute. The processing mode from the reported information corresponding to the attribute value is called a data processing mode corresponding to the attribute. The data processing method is, for example, a conversion method of converting a celsius temperature into a fahrenheit temperature, and is, for example, a conversion method of converting a floating point type data into an integer type data.
In the present application, a plurality of attributes of an object and a corresponding data processing method configured for each attribute may be defined in advance according to actual needs, for example, an attribute to be focused on for each object, a data storage format required by a database, a format and a unit of data acquired by a data acquisition device, and the like. The process that the user defines a plurality of attributes of the object as required and configures the corresponding data processing mode for each attribute is the process of configuring the object model of the object. In particular embodiments, the carrier of the object model may be a configuration file in JSON format, and the configured object model is then sent to the server.
In some embodiments, the following processes of steps 201 to 203 may be performed to determine the attribute values of the object under the attributes according to the report information corresponding to the attributes, and update the attribute values under multiple attributes to the data table corresponding to the object. Specifically, the method comprises the following steps:
step 201, obtaining an object model of an object; the object model indicates a plurality of attributes defined for the object and a data processing mode corresponding to each attribute.
The object model of the object can be configured at the administrator client, and then the object model of the object and the object identifier of the object are stored in the server in an associated manner, and then the object model of the object can be acquired from the server according to the object identifier of the object.
Fig. 2 exemplarily shows a plurality of attributes defined for an object in an object model (i.e., attribute 1 to attribute m, m being an integer greater than 1) and data processing manners configured for the respective attributes (i.e., data processing manners B1 to Bm). In a specific embodiment, the attributes configured for the object in the object model and the data processing mode of the object may be configured according to actual needs. Further, the object model shown in fig. 2 also defines a type corresponding to each attribute, where the type is used to indicate a data type of an attribute value corresponding to the attribute in the object data table, and the data type includes an integer type and a floating point type, so that after the attribute value corresponding to each attribute is determined, the attribute value can be stored in the object data table of the object according to the type corresponding to each attribute indicated by the object model.
Step 202, according to the data processing mode corresponding to each attribute, processing the reported information corresponding to each attribute of the object to obtain the attribute value of the object under each attribute.
As described above, the reporting information corresponding to the attribute may be collected by the data collection device and reported to the server by the collection device. Therefore, the server can correspondingly acquire the reported information corresponding to each attribute.
In some embodiments of the present application, the object model further indicates source device identifiers corresponding to the attributes of the object; before step 202, the method further comprises: and acquiring the reported information corresponding to each attribute of the object in the reported data set according to the source equipment identifier corresponding to each attribute.
The source device identifier corresponding to the attribute refers to a device identifier of a source device from which the report information corresponding to the attribute is obtained. And associating each piece of reported information in the reported data set with the equipment identifier of the source equipment, and performing equipment identifier matching based on the source equipment identifier corresponding to each attribute in the object model and the equipment identifier of the source equipment from which each piece of reported information in the reported data set is obtained, so as to determine the reported information corresponding to each attribute.
In some embodiments of the present application, the reporting information in the reported data set is stored in a partitioned manner according to the source device; in this embodiment, the report information corresponding to each attribute may be obtained according to the following process: determining a storage position of the reported information corresponding to each attribute based on the corresponding relation between the equipment identifier and the storage position and the source equipment identifier corresponding to each attribute; and acquiring the reporting information corresponding to each attribute from the storage position of the reporting information corresponding to each attribute.
That is, the storage location of the report information of each device in the server is preset, and the storage location set for the device and the device identifier corresponding to the device are stored in an associated manner. And after receiving the report information sent by the equipment, the server correspondingly stores the report information to the corresponding storage position. On the basis, based on the source device identifier corresponding to each attribute in the object model, the reporting information corresponding to the attribute is acquired from the storage position associated with the source device identifier.
In some embodiments, the data processing manner corresponding to the attribute may be a conversion manner between data formats, that is, the data processing manner indicates a conversion manner between an original data format and a target data format; in this embodiment, step 202 includes: determining an original data format to which the reported information corresponding to an attribute belongs; and carrying out format conversion on the reported information corresponding to the attribute according to a conversion mode between the original data format and the target data format to obtain an attribute value of the attribute corresponding to the target data format.
In some embodiments, the data processing manner may indicate a conversion manner between multiple original data formats and a target data format, and in this case, the original data format to which the report information corresponding to an attribute belongs may be identified first, and then format conversion may be performed on the report information corresponding to the attribute according to the conversion manner between the original data format to which the report information corresponding to the attribute belongs and the target format, so as to obtain an attribute value corresponding to the attribute.
In other embodiments, the data processing manner may indicate a conversion manner between an original data format and a target data format, and in this case, if the server determines that the data format to which the report information corresponding to the attribute belongs is the original data format indicated by the data processing manner corresponding to the attribute, format conversion is performed according to the conversion manner indicated by the data processing manner, so as to obtain the attribute value corresponding to the attribute correspondingly. Otherwise, if the server determines that the data format to which the reported information corresponding to the attribute belongs is not the original data format indicated by the data processing mode corresponding to the attribute, the server may send a prompt message to the administrator client. It can be understood that if the data format to which the report information corresponding to the attribute belongs is not the original data format indicated by the data processing manner corresponding to the attribute, but format conversion is still performed according to the conversion manner indicated by the data processing manner, the obtained attribute value is inaccurate.
In other embodiments, the data processing mode corresponding to the attribute may be an extraction mode for extracting an attribute value from the corresponding report information. In this case, step 202 comprises: and according to the extraction mode corresponding to the attribute, extracting the attribute value corresponding to the attribute from the reported information corresponding to the attribute.
For example, in some indoor environments, such as a laboratory, the working states (corresponding to the object and the attribute of the test equipment) of a plurality of test equipment or the state of a certain component in the test equipment may need to be concerned, and an image acquisition device for acquiring an image is deployed in the laboratory, so that the reported information corresponding to the working states is an image acquired by the image acquisition device and includes the test equipment; in this case, the data processing manner corresponding to the attribute may be an identification manner that identifies the operating state of the test device from an image including the test device. In a specific embodiment, the reporting information corresponding to different attributes may be the same, that is, the attribute values of at least two attributes are extracted from the same reporting information.
For another example, based on the image containing the test device, in addition to the operating state of the test device, it is possible to identify the degree of corrosion of the test device (which has a positive correlation with the size of the area of the corroded area in the test device), and the state of the lubricating oil of the test device; in this case, the attribute values of three attributes, which are the operating state of the test equipment, the corrosion degree of the test equipment, and the state of the lubricating oil in the test equipment, are extracted from the reported information including the image of the test equipment. In other embodiments, the reporting information corresponding to different attributes may also be different.
In a specific embodiment, the report information corresponding to an attribute may originate from one data acquisition device or from multiple data acquisition devices. And under the condition that the reported information corresponding to one attribute comes from a plurality of data acquisition devices, further processing and calculating the plurality of reported information corresponding to the attribute in a data processing mode corresponding to the attribute to obtain an attribute value corresponding to the attribute.
Step 203, integrating the attribute values of the object under the plurality of attributes into the object data table corresponding to the object.
The object data table corresponding to the object is constructed according to the object model of the object. Specifically, an attribute field for indicating each attribute of the object and a field for indicating an attribute value may be set in the object data table according to a plurality of attributes of the object set in the object model, so that, after obtaining attribute values of the object under the plurality of attributes, the attribute values may be stored under the fields for indicating the attribute values. Further, if the object model further indicates the source device id corresponding to the attribute, the device id from which the attribute value is stored may also be correspondingly stored in the object data table.
In a specific embodiment, the data acquisition device may acquire information at intervals and continuously send the report information to the server, where the report information carries a timestamp, and the timestamp is used to indicate a time when the data acquisition device acquires the report information. In this case, the time stamp and the attribute value association of the plurality of attributes under the time stamp may also be integrated into the object data table.
In some embodiments of the present application, after an object data table of an object is created according to an object model corresponding to the object, an access interface of the object data table may be generated, where the access interface of the object data table may also be understood as a Uniform Resource Locator (URL) of the object data table. And then, issuing an access interface of the object data table corresponding to the object to the outside, and storing the access interface and the object identifier of the object in an associated manner. On the basis, in step 220, the access interface associated with the target object identifier may be obtained according to the target object identifier of the target object, and the object data table of the target object may be correspondingly obtained according to the access interface associated with the target object identifier. Therefore, the access address of the object data table corresponding to the object is provided directly, so that the access address of the object data table can be obtained according to the target object identifier in the object access request, and the data table identifier (such as the data table name) of the object data table does not need to be searched first, and then the access address of the data table is searched through the data table identifier, so that the efficiency of accessing the object data table can be further improved.
Fig. 3 is a schematic diagram of creating an object data table and generating an access interface according to an object model according to the present application. As shown in fig. 3, the object model 310 defines attributes of each object and data types corresponding to each attribute, for example, for the attribute of "temperature", the data type corresponding to the attribute is set to "int", the object model further defines a data processing manner corresponding to each attribute, then, based on the object model, a first SQL statement 320 for creating an object data table is generated, and then, the first SQL statement 320 is executed to create an object data table 330 of the object; in this way, in step 203 according to the corresponding embodiment in fig. 2, the attribute values of the obtained object under multiple attributes may be integrated into the object data table established for the object. Then, an access interface of the object data table 330 is generated; thus, in step 220 of the corresponding embodiment in fig. 2, an access interface associated with the target object identifier may be determined based on the target object identifier, and an object data table of the target object may be obtained according to the access interface.
After receiving the new reported information stream 340, processing each reported information in the reported information stream 340 according to the data processing mode corresponding to each attribute indicated by the object model of the object, so as to obtain the attribute value of the object under each attribute. After that, the attribute values of the plurality of attributes of the object under the same time stamp are integrated into the object data table 330 to update the data in the object data table.
Step 230, sending the object data table of the target object to the client.
Because the object data table comprises the attribute values of the object under a plurality of attributes, the user can know the information of the target object in various aspects according to the object data table received by the client.
In the scheme of the application, the data processing modes corresponding to the multiple attributes of the object are indicated through the object model of the object, the reported information corresponding to the attributes is processed according to the data processing mode corresponding to each attribute, the attribute values of each attribute are correspondingly obtained, and then the attribute values of the object under the multiple attributes are stored in the object data table in an associated mode. On the basis, after an object access request initiated by a client is received, an object data table of a target object requested to be accessed is correspondingly obtained, and the object data table is sent to the client. Moreover, the attribute values are stored in the object data table after the reported information is processed, so that the reported information does not need to be processed and data integration is carried out after a request is received after the information related to the object needs to be accessed, the response time of the access request of the object is greatly shortened, the data acquisition efficiency is further ensured, and the user experience is improved.
In some application scenarios, a data processing device for collecting report information may be newly added according to actual needs, and in such a case, if a data storage manner in the prior art is adopted, a program in a server needs to be updated to ensure that the program in the server is adapted to the newly added data collecting device, for example, it is ensured that the server can accurately analyze report information reported by the new data collecting device. In other words, according to the existing data storage manner, it may be necessary to perform end-to-end adaptation and software upgrade on a server to support access to the reported information acquired by the newly added data acquisition device, which causes problems of high online difficulty and long online period of the new data acquisition device.
The scheme of the application can effectively solve the problem, and the object model of the object is updated correspondingly under the condition that the data acquisition equipment needs to be newly added, so that the report information corresponding to the new data acquisition equipment, the attribute corresponding to the report information of the newly added data acquisition equipment and the corresponding data processing mode are updated, and thus, the data format of the report information acquired by the newly added data acquisition equipment and the format of the attribute value of the attribute corresponding to the report information in the object data table can be defined in advance through the object model, and the server can analyze and further process the report information after receiving the report information acquired by the newly added data acquisition equipment. It can be seen that, by adopting the scheme of the application, the server does not need to be updated on a large scale, and the object model of the object is updated according to the requirement, so that the problems of high online difficulty and long online period of new data acquisition equipment in the prior art can be effectively solved.
In the solution of the present application, a plurality of attributes defined in an object model and a data processing manner corresponding to each attribute may be configured according to actual needs, so the solution of the present application may be applicable to different application scenarios, and has a wide application range.
Based on the object data table of each object generated in the embodiment corresponding to fig. 2, the combined object view of the combined object may also be generated according to the association relationship between the multiple objects included in the combined object indicated by the combined object model of the combined object and the object data table of the multiple objects included in the combined object, and the combined object view of the combined object and the combined object identifier are stored in association, so that the data access service related to the combined object may be provided to the terminal. Fig. 4 is a flowchart of generating a combined object view of combined objects according to the present application, and in fig. 4, each object data table in the database may be generated according to steps 201 to 203 of the embodiment corresponding to fig. 2 or steps 310 to 330 of the embodiment corresponding to fig. 3. As shown in fig. 4, the method further includes:
in step 410, a combined object model configured for the combined object is obtained, where the combined object model indicates a plurality of objects included in the combined object and an association relationship between the plurality of objects.
The association relationship between the plurality of objects may be a parent-child relationship, a parallel relationship, or the like, and is not particularly limited herein, but it is needless to say that the hierarchical relationship between each object and the combined object may be further determined by the association relationship between the plurality of objects. For example, for a power grid system of city a, city a includes an area A1 and an area A2, and when the power grid system of city a is taken as a combined object, the power grid system of area A1 and the power grid system of area A1 may be regarded as two objects included in the combined object, where the association between the power grid system of area A1 and the power grid system of area A2 is a parallel relationship, and the parallel relationship is determined according to the administrative division of area A1 and area A1.
A schematic diagram of a combined object model is illustrated in FIG. 4, which, as shown in FIG. 4, indicates that the combined object includes object C1, object C2, \8230, object Cp (where p is a positive integer), and object C2-1, object C2-2 and object C2-3, where object C1, object C2, \8230, object Cp is in a side-by-side relationship, and object C2 is in a parent-child relationship with object C2-1, object C2-2 and object C2-3. Further, object C1, object C2, \ 8230, object Cp may also be understood as the primary sub-object of the combined object, and object C2-1, object C2-2 and object C2-3 may also be understood as the secondary sub-objects of the combined object.
Step 420, an object data table corresponding to each object included in the combined object is obtained.
Since the combined object model indicates a plurality of objects included in the combined object, the object data table of each object included in the combined object can be obtained from the database according to the object identifiers of the plurality of objects. The establishment of the object data table and the obtaining of the attribute values of the objects in the object data table under each attribute refer to the description of the embodiment corresponding to fig. 2, and are not described herein again.
Step 430, generating a combined object view corresponding to the combined object according to the association relationship among the plurality of objects and the object data table respectively corresponding to the plurality of objects included in the combined object.
In some embodiments, the SQL statement for generating the combined object view may be generated in advance according to the objects included in the combined object indicated by the combined object model and the association relationships between the objects, and in step 430, the SQL statement for generating the combined object view may be invoked to generate the combined object view corresponding to the combined object using the association relationships between the objects and the object data tables corresponding to the objects, respectively.
If the association relationship among the objects is established based on one or more attributes, the attribute dependent on the association relationship is called the attribute corresponding to the association relationship. Thus, the association actually indicates the attribute to be presented in the combined object view, that is, the attribute to be presented is the attribute corresponding to the association. On the basis, line data or column data used for indicating the attribute value under the attribute is acquired from the object data table of each object based on the attribute corresponding to the association relation, and then a combined object view of the combined object is generated according to the line data or column data acquired from the object data tables of the multiple objects and used for indicating the attribute value under the attribute.
In some embodiments of the present application, after generating the combined object view corresponding to the combined object, an access interface corresponding to the combined object view is generated and the access interface is published, and correspondingly, in a case that the client needs to access the combined object, the combined object view of the combined object may be obtained based on the access interface corresponding to the combined object.
The object data tables of a plurality of objects are further integrated through the configured combined object model on the basis that the objects are used as the data storage units, so that a combined object view of the combined objects is obtained, and the access service of the combined object view can be provided for the client side based on the generated combined object view.
Specifically, the data access service for providing the object view of the combined object for the client through the following process specifically includes: receiving a combined object access request; the combined object access request comprises a target combined identifier of a target combined object; acquiring a combined object view of the target combined object according to the target combined identifier; a combined object view of the target combined object is sent to the client. The combined object view may be generated according to steps 410 to 430 in the embodiment corresponding to fig. 4 based on the object data table stored in the database, and the object data tables of the multiple objects included in the combined object may be generated according to steps 201 to 203 in fig. 2, which is specifically described above and is not described herein again.
A combined object access request refers to a request to access data associated with a combined object. In the present application, a combined object corresponding to data requested to be accessed by a combined object access request is referred to as a target combined object.
In some embodiments, if the access interface corresponding to the combined object view is published, the access interface corresponding to the target combined object may be determined according to the target combination identifier, and then the combined object view of the target combined object is obtained according to the access interface corresponding to the target combined object.
In some embodiments, on the basis of configuring the object model for the object and configuring the combined object model for the combined object, the access interface may be generated only for the object data table, may also be generated only for the combined object view, and may also be generated for both the object data table and the combined object view, which may be specifically set according to actual needs.
FIG. 5 is a diagram illustrating generation of a combined object view from a combined object model and generation of an access interface according to an embodiment of the application. In step 430 of the corresponding embodiment of fig. 4, a combined object view may be generated in accordance with the process shown in fig. 5. As shown in fig. 5, based on the combined object model 510 configured for the combined object, then according to the association relationship between the objects indicated by the combined object model, a second SQL statement 520 for creating the combined object view corresponding to the combination is generated, so as to generate the combined object view of the combined object based on the second SQL statement 520. Then, a second access interface 530 corresponding to the combined object view is generated, and the second access interface 530 is published. Therefore, in a case that the client needs to access the data related to the combined object, a second access interface associated with the combined object identifier may be determined according to the combined object identifier of the target combined object requested to be accessed, and then the combined object view of the target combined object requested to be accessed is correspondingly obtained through the second access interface 530.
In some embodiments of the present application, the method further comprises: and synchronizing the object data table corresponding to the object and the combined object view corresponding to the combined object to a cloud database.
The data access method provided by the application can be executed by the edge computing device located at the side, and correspondingly, the database is also deployed on the edge computing device. In this case, the edge computing device may synchronize the object data table and the combined object view of each combined object to the database in the cloud, so that the client may obtain the object data table of the object and/or the combined object view of the combined object by accessing the database in the edge computing device or the database in the cloud.
Fig. 6 is a schematic diagram of a data access system provided in the present application, and based on the object data table of the provided objects in the embodiments corresponding to fig. 2 and fig. 3 and the combined object view of the provided combined object in the embodiments corresponding to fig. 4 and fig. 5, a data access service of object related data and a data access service of combined object related data may be provided to a client according to the embodiment shown in fig. 6.
As shown in fig. 6, the data access system includes a first access subsystem 610 and a second access subsystem 620. The first access subsystem 610 is deployed on the edge side and the second access subsystem 620 is deployed on the cloud side. The first access subsystem 610 includes a plurality of data acquisition devices (data acquisition devices K1, K2, \8230; kn are shown by way of example in FIG. 6) and an edge computing device 611, each data acquisition device communicatively coupled to the edge computing device 611. The multiple data acquisition devices are configured to perform data acquisition and send the acquired report information to the edge computing device 611.
The edge computing device 611 is provided with a data buffer area, and the data buffer area is used for storing the report information reported by the data acquisition device. Specifically, in the data cache region, the data may be stored in a partitioned manner according to the data acquisition device from which each piece of reported information originates. The edge computing device 611 may periodically obtain the report information corresponding to each attribute from the data buffer.
Also deployed in the edge computing device 611 are a first model repository for storing object models configured for objects and a first database for storing combined object models configured for combined objects. The first database is used for storing an object data table of the objects and a combined object view of the combined objects.
The edge computing device 611 may perform the basic object processing steps based on the object model of the object. In the basic object processing step, the edge computing device 611 generates an object data table of the object according to the object model of the object, stores the object data table in the first database, and generates a first access interface of the object data table according to a storage location of the object data table in the first database. Further, in the basic object processing step, the edge computing device 611 further obtains the report information corresponding to each attribute from the data cache according to the source device identifier corresponding to each attribute indicated by the object model, and executes steps 202 to 203, where the implementation details of the steps 202 to 203 refer to the above description.
Further, the edge computing device 611 may also filter the reported information and perform data backfill in the basic object processing step, so as to implement processing of the reported information that is missed in the historical time period, obtain the corresponding attribute value in the historical time period, and update the attribute value into the object data table of the object according to the timestamp corresponding to the attribute value, thereby ensuring the integrity of the data in the object data table.
The edge computing device 611 may perform the combined object processing steps based on the combined object model of the combined object. The combined object processing step includes steps 410-430 as above, resulting in a combined object view of the combined object; thereafter, the combined object view is stored in the first database, and a second access interface for the combined object view is generated and published. In a particular embodiment, the second access interface and the first access interface may be REST (Representational State Transfer) interfaces.
Further, the edge computing device 611 may also synchronize the object data table and the combined object view in the first database to the second database in the second access subsystem 620. Further, a second model library may also be deployed in the second access subsystem 620, where the second model library is used to store a second combined object model of a second combined object, and the second combined object may be obtained by further combining objects and/or combined objects in the first model library. On this basis, the cloud server may perform the steps of combined object processing, namely: and generating a second combined object view of the second combined object according to each second combined object model in the second model library and the object data table and the combined object view in the second database, wherein the process of generating the second combined object view is similar to the steps 410-430 and is not repeated herein.
After data synchronization, the client may access the first database or the second database to obtain the object data table of the object and the combined object view of the combined object.
Fig. 7 is a flowchart of a data access method provided in the present application. As shown in fig. 7, the flow of the data processing includes a configuration process 710, a caching process 720, a data integration process 730, and a data access process 740, wherein the four processes may be performed by the server 120 shown in fig. 1 or the edge computing device 611 shown in fig. 6. The object models of the objects in the embodiments corresponding to fig. 2, fig. 3, and fig. 6, and the combined object model of the combined object in the embodiments corresponding to fig. 4, fig. 5, and fig. 6 may be configured according to the configuration process 710 shown in fig. 7.
As shown in fig. 7, in the configuration process 710, after obtaining the object model and the object combination object model configured by the administrator user or the developer at the administrator client, the edge computing device stores the object model and the combination object model in the object model configuration file. Thereafter, a base object processing step and a combined object processing step are performed. In the basic object processing step, reading the object model from the object model configuration file, creating an object data table of the object in the first database according to the object model, and issuing a first access interface corresponding to the object data table to the data access interface. In the step of processing the combined object, the combined object model is obtained from the object model configuration file, the combined object view corresponding to the combined object is created in the first database, and the second orientation interface corresponding to the combined object view is issued to the data access interface.
In the caching process 720, after the edge computing device receives the data stream from the data acquisition device, the data stream is cached according to the data source partition, that is, the corresponding reporting information is stored in the storage partition corresponding to the source device identifier according to the source device identifier corresponding to each reporting information in the data stream.
In the data integration process 730, basic object processing steps are performed. Specifically, in the basic object processing step, the following steps are sequentially performed to the report information in the access cache periodically: acquiring reporting information corresponding to each attribute according to the source equipment identifier corresponding to each attribute; and performs steps 201-203 above. Further, after completing a period of data integration process, the edge computing device may synchronize the object data table and the combined object view in the first database to the second database in the cloud, so that the cloud server may perform further combination based on the object data table or the combined object view.
In the data access process 740, if an object access request is received, a first access interface corresponding to a target object identifier is determined according to the target object identifier carried by the object access request; then, converting the object access request into a data table access request according to the determined first access interface; sending a data table access request to a first database; thereafter, the first database returns the object data table of the target object to the client.
In the data access process 740, if a combined object access request is received, according to a target combined identifier carried by the combined object access request, determining a second access interface corresponding to the target combined identifier; then, according to the determined second access interface, converting the combined object access request into a combined object view access request, and sending the combined object view access request to the first database; thereafter, the first database returns the combined object view of the target combined object to the client.
In the embodiment of the present application, an object is established as a unit of basic processing, and specifically, according to a data processing manner corresponding to each attribute indicated in a configured object model, the reported information of the object under multiple attributes is processed to obtain an attribute value of the object under each attribute, and the attribute values of the object under multiple attributes are correspondingly integrated into an object data table of the object, so as to implement instantiation of the object model. In addition, an access interface of the object data table is provided, so that the object data table of the object can be accessed according to the access interface in the data access process. In the application, in the data access process, the reported information does not need to be processed, then the multiple attribute values are integrated, and the reported information is processed and integrated before being stored, which is equivalent to moving down the processing logic of data processing and attribute value integration performed in the application layer to the data layer in the prior art, so that the client can access the attribute values of the object under the multiple attributes based on one request without performing additional processing, thereby realizing application and data separation and improving the efficiency of data access.
The method claimed in the present application is described in detail above with reference to the accompanying drawings, and the apparatus and computing device claimed in the present application, which may be used to execute the method in the above embodiments of the present application, are further described below with reference to fig. 8 and 9. For details which are not disclosed in the embodiments of the apparatus of the present application, reference is made to the above-described embodiments of the method of the present application.
Fig. 8 is a block diagram of a data access apparatus provided in the present application, where the data access apparatus may be deployed in the server 120 shown in fig. 1 or the edge computing device 611 shown in fig. 6, and as shown in fig. 8, the data access apparatus 800 includes: an object access request receiving module 810, configured to receive an object access request, where the object access request includes a target object identifier of a target object; an object data table obtaining module 820, configured to obtain, according to the target object identifier, an object data table corresponding to the target object, where the object data table includes attribute values of the target object under multiple attributes, and the attribute values of the target object under the multiple attributes are obtained by processing, according to a data processing manner corresponding to each attribute indicated by an object model corresponding to the target object, reported information corresponding to each attribute; the object data table sending module 830 is configured to send the object data table of the target object to the client.
In some embodiments of the present application, the data access device 800 further comprises: the object model acquisition module is used for acquiring an object model configured for the object, and the object model indicates a plurality of attributes defined for the object and data processing modes corresponding to the attributes; the processing module is used for processing the reported information corresponding to each attribute of the object according to the data processing mode corresponding to each attribute to obtain the attribute value of the object under each attribute; and the integration module is used for integrating the attribute values of the object under the multiple attributes into the object data table corresponding to the object.
In some embodiments of the present application, the data access device 800 further comprises: the access interface generating module is used for generating an access interface, and the access interface comprises at least one of a first access interface of a combined object view corresponding to the combined object and a second access interface of an object data table corresponding to the object; and the access interface publishing module is used for publishing the generated access interface.
In some embodiments of the present application, the object model further indicates source device identifiers corresponding to the attributes of the object; the data access device 800 further comprises: and the report information acquisition module is used for acquiring report information corresponding to each attribute of the object in the report data set according to the source equipment identifier corresponding to each attribute.
In some embodiments of the present application, the data processing manner indicates a conversion manner between an original data format and a target data format; the processing module is further to: determining an original data format to which reported information corresponding to an attribute belongs; and carrying out format conversion on the reported information corresponding to the attribute according to a conversion mode between the original data format and the target data format to obtain an attribute value of the attribute corresponding to the target data format.
In some embodiments of the present application, the reporting information in the reported data set is stored in a partitioned manner according to the source device; the reported information obtaining module is further used for: determining a storage position of the reported information corresponding to each attribute based on the corresponding relation between the equipment identifier and the storage position and the source equipment identifier corresponding to each attribute; and acquiring the reporting information corresponding to each attribute from the storage position of the reporting information corresponding to each attribute.
In some embodiments of the present application, the data access device 800 further comprises: and the synchronization module is used for synchronizing the object data table corresponding to the object and the combined object view corresponding to the combined object to the database of the cloud.
In another aspect of the present application, there is provided a data access apparatus including: a combined object access request receiving module, configured to receive a combined object access request, where the combined object access request includes a target combined identifier of a target combined object; the combined object view acquisition module is used for acquiring a combined object view of the target combined object according to the target combined identifier; the combined object view of the target combined object is generated according to the object data table of the plurality of objects included in the target combined object and the incidence relation among the plurality of objects included in the target combined object; the object data table of the object comprises attribute values of the object under a plurality of attributes, and the attribute values of the object under the plurality of attributes are obtained by processing the reported information corresponding to each attribute according to the data processing mode corresponding to each attribute indicated by the object model corresponding to the object; and the combined object view sending module is used for sending the combined object view of the target combined object to the client.
In some embodiments of the present application, the data access device further comprises: a combined object model obtaining module configured to obtain a combined object model configured for the combined object, the combined object model indicating a plurality of objects included in the combined object and an association relationship between the plurality of objects; the object data table acquisition module is used for acquiring an object data table corresponding to each object included in the combined object; and the combined object view generating module is used for generating a combined object view corresponding to the combined object according to the incidence relation among the objects and the object data tables respectively corresponding to the objects included in the combined object.
In some embodiments of the present application, the data access device further comprises: the access interface generating module is used for generating an access interface, and the access interface comprises at least one of a first access interface of a combined object view corresponding to the combined object and a second access interface of an object data table corresponding to the object; and the access interface publishing module is used for publishing the generated access interface.
It should be understood that the data access device in the embodiment of the present application may correspond to perform the data access method described in the embodiment of the present application, and operations and/or functions of each module in the data access device are respectively for implementing corresponding flows of each method in the above method embodiments, and are not described herein again for brevity.
Fig. 9 is a schematic structural diagram of a computing device 900 according to this embodiment, where the computing device may be the server in fig. 1, for example, an edge computing device or a cloud server in a cloud end, and the computing device may be configured to execute the data access method provided in this application. As shown in fig. 9, computing device 900 includes a processor 910, a bus 920, a memory 930, a memory unit 950 (which may also be referred to as a main memory unit), and a communication interface 940. The processor 910, storage 930, memory unit 950, and communication interface 940 are coupled by a bus 920.
It should be understood that in the present embodiment, the processor 910 may be a CPU, and the processor 910 may also be other general purpose processors, DSPs, ASICs, FPGAs, or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, or the like. The general purpose processor may be a microprocessor or any conventional processor or the like. The communication interface 940 is used to enable communication of the computing device 900 with external devices or apparatuses.
Bus 920 may include a path for communicating information between the above components, such as processor 910, memory unit 950, and storage 930. The bus 920 may include a power bus, a control bus, a status signal bus, and the like, in addition to a data bus. But for clarity of illustration the various busses are labeled as bus 920 in the figures. The bus 920 may be a Peripheral Component Interconnect Express (PCIE) bus, an Extended Industry Standard Architecture (EISA) bus, a unified bus (UBs or UBs), a computer Express link (CXL), a cache coherent Interconnect protocol (CCIX) bus, or the like.
As one example, computing device 900 may include multiple processors. The processor may be a multi-core (multi-CPU) processor. A processor herein may refer to one or more devices, circuits, and/or computational units for processing data (e.g., computer program instructions).
It is worth noting that fig. 9 only illustrates that the computing device 900 includes 1 processor 910 and 1 memory 930, where the processor 910 and the memory 930 are respectively used for indicating a type of device or apparatus, and in a specific embodiment, the number of each type of device or apparatus may be determined according to business requirements.
Memory unit 950 can be either volatile memory or nonvolatile memory, or can include both volatile and nonvolatile memory. The non-volatile memory may be a read-only memory (ROM), a Programmable ROM (PROM), an Erasable PROM (EPROM), an Electrically Erasable PROM (EEPROM), or a flash memory. Volatile memory can be Random Access Memory (RAM), which acts as external cache memory. By way of example, but not limitation, many forms of RAM are available, such as static random access memory (static RAM, SRAM), dynamic Random Access Memory (DRAM), synchronous Dynamic Random Access Memory (SDRAM), double data rate synchronous dynamic random access memory (DDR SDRAM), enhanced synchronous SDRAM (ESDRAM), synchronous Link DRAM (SLDRAM), and direct bus RAM (DR RAM).
Specifically, in the solution of the present application, the memory unit 950 may store an object model of an object and a combined object model of a combined object; further, the method can be used for storing an object data table created based on the object model and a combined object view created based on the combined object model.
The memory 930 may be used for computer readable instructions that, when executed by the processor 910, implement the data access methods provided herein. The memory 930 may be a solid state disk or a mechanical hard disk.
It should be appreciated that the computing device 900 described above may be a DPU. The data access apparatus 800 in the foregoing may be configured in the computing device 900 to implement the data access method provided in the present application.
As a possible implementation manner, the present application also protects a computer device cluster, where the computer device cluster includes two or more computer devices, a structure of each computer device may refer to the computer device 900 shown in fig. 9, and the computer devices in the computer device cluster are used to implement the operation steps of the methods shown in fig. 2 to fig. 7, and for brevity, no further description is given here.
The method steps in this embodiment may be implemented by hardware, or may be implemented by software instructions executed by a processor. The software instructions may consist of corresponding software modules that may be stored in Random Access Memory (RAM), flash memory, read-only memory (ROM), programmable ROM, erasable PROM (EPROM), electrically EPROM (EEPROM), registers, a hard disk, a removable hard disk, a CD-ROM, or any other form of storage medium known in the art. An exemplary storage medium is coupled to the processor such the processor can read information from, and write information to, the storage medium. Of course, the storage medium may also be integral to the processor. The processor and the storage medium may reside in an ASIC. Additionally, the ASIC may reside in a computing device. Of course, the processor and the storage medium may reside as discrete components in a network device or a terminal device.
In the above embodiments, the implementation may be wholly or partially realized by software, hardware, firmware, or any combination thereof. When implemented in software, may be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer programs or instructions. When the computer program or instructions are loaded and executed on a processor in a computing device, the computing device performs the procedures or functions of the embodiments of the present application, in whole or in part. The computing device may be a general purpose computer, special purpose computer, computer network, network appliance, user equipment, or other programmable apparatus.
The computer program or instructions may be stored in a computer readable storage medium or transmitted from one computer readable storage medium to another computer readable storage medium, for example, the computer program or instructions may be transmitted from one website site, computer, server, or data center to another website site, computer, server, or data center by wire or wirelessly. A computer-readable storage medium may be any available medium that can be accessed by a computer or a data storage device such as a server, data center, etc. that incorporates one or more available media. The available media may be magnetic media, such as floppy disks, hard disks, magnetic tape; or an optical medium, such as a Digital Video Disc (DVD); it may also be a semiconductor medium, such as a Solid State Drive (SSD).
It is understood that, in order to implement the functions in the above method embodiments, the computing device includes corresponding hardware structures and/or software modules for executing the respective functions. Those of skill in the art will readily appreciate that the various illustrative elements and method steps described in connection with the embodiments disclosed herein may be implemented as hardware or combinations of hardware and computer software. Whether a function is performed as hardware or computer software driven hardware depends on the particular application scenario and design constraints imposed on the solution.
In the embodiments of the present application, words such as "exemplary" or "for example" are used to mean serving as an example, instance, or illustration. Any embodiment or design described herein as "exemplary" or "such as" is not necessarily to be construed as preferred or advantageous over other embodiments or designs. Rather, use of the word "exemplary" or "such as" is intended to present concepts related in a concrete fashion.
In the description of the embodiments of the present application, the meaning of "a plurality" means two or more unless otherwise specified. For example, a plurality of processing units refers to two or more processing units; a plurality of systems refers to two or more systems. In the embodiment of the present application, the term "and/or" is only one kind of association relationship describing an associated object, and means that three relationships may exist, for example, a and/or B may mean: a exists alone, A and B exist simultaneously, and B exists alone.
The terms "first" and "second," and the like in the description and in the claims of the embodiments of the present application, are used for distinguishing between different objects and not for describing a particular order of the objects. For example, the first reference resistance and the second reference resistance, etc. are used to distinguish between different reference resistances, rather than to describe a particular order of reference resistances.
The above description is only for the specific embodiments of the present application, but the scope of the present application is not limited thereto, and any person skilled in the art can easily think of various equivalent modifications or substitutions within the technical scope of the present application, and these modifications or substitutions should be covered within the scope of the present application. Therefore, the protection scope of the present application shall be subject to the protection scope of the claims.

Claims (14)

1. A method of data access, comprising:
receiving an object access request, wherein the object access request comprises a target object identifier of a target object;
acquiring an object data table corresponding to the target object according to the target object identifier, wherein the object data table comprises attribute values of the target object under multiple attributes, and the attribute values of the target object under the multiple attributes are obtained by processing reported information corresponding to each attribute according to a data processing mode corresponding to each attribute indicated by an object model corresponding to the target object;
and sending the object data table of the target object to a client.
2. The method according to claim 1, wherein before the obtaining of the object data table corresponding to the target object according to the target object identifier, the method further comprises:
acquiring an object model configured for an object, wherein the object model indicates a plurality of attributes defined for the object and a data processing mode corresponding to each attribute;
processing the reported information corresponding to each attribute of the object according to the data processing mode corresponding to each attribute to obtain the attribute value of the object under each attribute;
and integrating the attribute values of the object under the attributes into an object data table corresponding to the object.
3. The method of claim 2, wherein the data processing mode indicates a conversion mode between an original data format and a target data format;
the processing the reported information corresponding to each attribute of the object according to the data processing mode corresponding to each attribute to obtain the attribute value of the object under each attribute includes:
determining an original data format to which reported information corresponding to an attribute belongs;
and according to the conversion mode between the original data format and the target data format, carrying out format conversion on the reported information corresponding to the attribute to obtain an attribute value of the attribute corresponding to the target data format.
4. The method of claim 2, further comprising:
acquiring a combined object model configured for a combined object, wherein the combined object model indicates a plurality of objects included in the combined object and association relations among the plurality of objects;
acquiring an object data table corresponding to each object included in the combined object;
and generating a combined object view corresponding to the combined object according to the incidence relation among the objects and an object data table respectively corresponding to the objects included in the combined object.
5. The method of claim 4, further comprising:
generating an access interface, wherein the access interface comprises at least one of a first access interface of an object data table corresponding to an object and a second access interface of a combined object view corresponding to the combined object;
publishing the generated access interface to obtain an object data table of an object based on the first access interface or to obtain a combined object view of a combined object based on the second access interface.
6. The method of claim 3, further comprising:
and synchronizing the object data table corresponding to the object and the combined object view corresponding to the combined object to a database at the cloud end.
7. A data access device, comprising:
an object access request receiving module, configured to receive an object access request, where the object access request includes a target object identifier of a target object;
an object data table obtaining module, configured to obtain an object data table corresponding to the target object according to the target object identifier, where the object data table includes attribute values of the target object under multiple attributes, and the attribute values of the target object under the multiple attributes are obtained by processing, according to a data processing manner corresponding to each attribute indicated by an object model corresponding to the target object, reported information corresponding to each attribute;
and the object data table sending module is used for sending the object data table of the target object to the client.
8. The apparatus of claim 7, further comprising:
the object model acquisition module is used for acquiring an object model configured for an object, wherein the object model indicates a plurality of attributes defined for the object and data processing modes corresponding to the attributes;
the processing module is used for processing the reported information corresponding to each attribute of the object according to the data processing mode corresponding to each attribute to obtain the attribute value of the object under each attribute;
and the integration module is used for integrating the attribute values of the object under the attributes into the object data table corresponding to the object.
9. The apparatus of claim 7, wherein the data processing mode indicates a conversion mode between an original data format and a target data format; the processing module is used for:
determining an original data format to which the reported information corresponding to an attribute belongs;
and carrying out format conversion on the reported information corresponding to the attribute according to a conversion mode between the original data format and the target data format to obtain an attribute value of the attribute corresponding to the target data format.
10. The apparatus of claim 7, further comprising:
a combined object model obtaining module, configured to obtain a combined object model configured for a combined object, where the combined object model indicates a plurality of objects included in the combined object and an association relationship between the plurality of objects;
the object data table acquisition module is used for acquiring an object data table corresponding to each object included in the combined object;
and the combined object view generating module is used for generating a combined object view corresponding to the combined object according to the incidence relation among the plurality of objects and the object data tables respectively corresponding to the plurality of objects included in the combined object.
11. The apparatus of claim 10, further comprising:
an access interface generating module, configured to generate an access interface, where the access interface includes at least one of a first access interface of an object data table corresponding to an object and a second access interface of a combined object view corresponding to the combined object;
and the access interface publishing module is used for publishing the generated access interface so as to acquire the object data table of the object based on the first access interface or acquire the combined object view of the combined object based on the second access interface.
12. The apparatus of claim 10, further comprising:
and the synchronization module is used for synchronizing the object data table corresponding to the object and the combined object view corresponding to the combined object to a database at the cloud end.
13. A computing device comprising a memory and a processor, the memory for storing a set of computer instructions; the method of any of claims 1-6, when executed by the processor.
14. A data access system, comprising:
the data acquisition equipment is used for acquiring the reported information of the object under the attributes and sending the reported information to the computing equipment;
the computing device is configured to implement the data access method according to any one of claims 1 to 6, according to the report information of the object under the multiple attributes.
CN202210908140.3A 2022-07-29 2022-07-29 Data access method, device, computing equipment and system Active CN115374109B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202210908140.3A CN115374109B (en) 2022-07-29 2022-07-29 Data access method, device, computing equipment and system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202210908140.3A CN115374109B (en) 2022-07-29 2022-07-29 Data access method, device, computing equipment and system

Publications (2)

Publication Number Publication Date
CN115374109A true CN115374109A (en) 2022-11-22
CN115374109B CN115374109B (en) 2023-09-01

Family

ID=84063045

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202210908140.3A Active CN115374109B (en) 2022-07-29 2022-07-29 Data access method, device, computing equipment and system

Country Status (1)

Country Link
CN (1) CN115374109B (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117708218A (en) * 2024-02-05 2024-03-15 成都秦川物联网科技股份有限公司 Industrial Internet of things data access method and database system based on service sub-platform

Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2003123082A (en) * 2001-10-12 2003-04-25 Sony Corp Device and method for image processing and computer program
CN1794238A (en) * 2004-12-20 2006-06-28 达索系统公司 Process and system for rendering an object in a view using a product lifecycle management database
CN101872305A (en) * 2010-06-08 2010-10-27 用友软件股份有限公司 UI (User Interface) performance and service logic separation method and system
JP2015018326A (en) * 2013-07-09 2015-01-29 日本電信電話株式会社 Three-dimensional object identification space, three-dimensional object generation device, method and program
CN108123842A (en) * 2017-12-22 2018-06-05 武汉虹信技术服务有限责任公司 A kind of adaption system and method that can access more plant equipments based on KNX agreements
CN110874534A (en) * 2018-08-31 2020-03-10 阿里巴巴集团控股有限公司 Data processing method and data processing device
CN114490651A (en) * 2022-01-19 2022-05-13 阿里云计算有限公司 Data storage method and device
CN114661830A (en) * 2022-03-09 2022-06-24 苏州工业大数据创新中心有限公司 Data processing method, device, terminal and storage medium

Patent Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2003123082A (en) * 2001-10-12 2003-04-25 Sony Corp Device and method for image processing and computer program
CN1794238A (en) * 2004-12-20 2006-06-28 达索系统公司 Process and system for rendering an object in a view using a product lifecycle management database
CN101872305A (en) * 2010-06-08 2010-10-27 用友软件股份有限公司 UI (User Interface) performance and service logic separation method and system
JP2015018326A (en) * 2013-07-09 2015-01-29 日本電信電話株式会社 Three-dimensional object identification space, three-dimensional object generation device, method and program
CN108123842A (en) * 2017-12-22 2018-06-05 武汉虹信技术服务有限责任公司 A kind of adaption system and method that can access more plant equipments based on KNX agreements
CN110874534A (en) * 2018-08-31 2020-03-10 阿里巴巴集团控股有限公司 Data processing method and data processing device
CN114490651A (en) * 2022-01-19 2022-05-13 阿里云计算有限公司 Data storage method and device
CN114661830A (en) * 2022-03-09 2022-06-24 苏州工业大数据创新中心有限公司 Data processing method, device, terminal and storage medium

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117708218A (en) * 2024-02-05 2024-03-15 成都秦川物联网科技股份有限公司 Industrial Internet of things data access method and database system based on service sub-platform
CN117708218B (en) * 2024-02-05 2024-05-03 成都秦川物联网科技股份有限公司 Industrial Internet of things data access method and database system based on service sub-platform

Also Published As

Publication number Publication date
CN115374109B (en) 2023-09-01

Similar Documents

Publication Publication Date Title
US11550829B2 (en) Systems and methods for load balancing in a system providing dynamic indexer discovery
US20170102986A1 (en) Automatic correlation of dynamic system events within computing devices
CN108647357B (en) Data query method and device
TW201905733A (en) Multi-source data fusion method and device
TW201800967A (en) Method and device for processing distributed streaming data
CN110134738B (en) Distributed storage system resource estimation method and device
CN107528904B (en) Method and apparatus for data distributed anomaly detection
CN107404417A (en) A kind of processing method of monitoring data, processing unit and processing system
US10657099B1 (en) Systems and methods for transformation and analysis of logfile data
CN104462606A (en) Method for determining diagnosis treatment measures based on log data
CN112395157A (en) Audit log obtaining method and device, computer equipment and storage medium
CN115374109B (en) Data access method, device, computing equipment and system
CN115883407A (en) Data acquisition method, system, equipment and storage medium
CN105930354B (en) Storage model conversion method and device
CN109471901B (en) Data synchronization method and device
CN105786990B (en) The method and device of database data storage and quick search
CN107894942B (en) Method and device for monitoring data table access amount
CN112579552A (en) Log storage and calling method, device and system
US10169083B1 (en) Scalable method for optimizing information pathway
CN115269519A (en) Log detection method and device and electronic equipment
CN110955709B (en) Data processing method and device and electronic equipment
CN114357001A (en) Multi-cluster data query method and device, monitoring platform and storage medium
CN112199426B (en) Interface call management method, device, server and medium under micro-service architecture
CN108897748A (en) A kind of HBase system monitoring method and HBase system
CN107679093B (en) Data query method and device

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