CN111737291A - Method, device and database for inquiring equipment information - Google Patents
Method, device and database for inquiring equipment information Download PDFInfo
- Publication number
- CN111737291A CN111737291A CN202010531434.XA CN202010531434A CN111737291A CN 111737291 A CN111737291 A CN 111737291A CN 202010531434 A CN202010531434 A CN 202010531434A CN 111737291 A CN111737291 A CN 111737291A
- Authority
- CN
- China
- Prior art keywords
- data
- device attribute
- user
- information
- query
- 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
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2471—Distributed queries
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Abstract
The application relates to the technical field of information query and discloses a method for querying equipment information. The method for inquiring the equipment information comprises the following steps: the server obtains the device attribute and a pre-created query interface of the set data, and queries the device attribute value in the query interface of the set data according to the device attribute, wherein the set data is stored in a partial data table of a database, the partial data table corresponds to the authority of an authorized user, and the data table comprises the device attribute and the device attribute value corresponding to the device attribute. The method for inquiring the equipment information can reduce the time consumption of the inquiry process. The application also discloses a device for inquiring the equipment information and a database for storing the equipment information.
Description
Technical Field
The present application relates to the field of information query technologies, and for example, to a method, an apparatus, and a database for querying device information.
Background
At present, most products for querying data can query device data in a one-to-one targeted manner, that is, only one type of data of one device can be queried at a time. However, in practical applications, a large amount of data is often required to be queried, in order to implement the query of batch data, in the prior art, a plurality of query instructions are combined into one query form and sent to the query form, after the server receives the query form, the server splits the query instructions, sequentially queries in a database according to the query instructions, and then returns a query result.
In the process of implementing the embodiments of the present disclosure, it is found that at least the following problems exist in the related art:
this method of querying device information is time consuming.
Disclosure of Invention
The following presents a simplified summary in order to provide a basic understanding of some aspects of the disclosed embodiments. This summary is not an extensive overview nor is intended to identify key/critical elements or to delineate the scope of such embodiments but rather as a prelude to the more detailed description that is presented later.
The embodiment of the disclosure provides a method, a device and a database for inquiring equipment information, so as to solve the technical problems of long time consumption and poor real-time performance in the process of inquiring batch information.
In some optional embodiments, the method for querying device information is applied to a server, and the method for querying device information includes:
obtaining the equipment attribute and a query interface of pre-created setting data;
inquiring the attribute value of the equipment in an inquiry interface of the set data according to the attribute of the equipment;
the setting data is stored in a partial data table of a database, the partial data table corresponds to the authority of an authorized user, and the data table comprises the device attribute and a device attribute value corresponding to the device attribute.
Optionally, the query interface for setting data is created by:
obtaining the authority of an authorized user;
matching each authority of the authorized user with the description information of a data structure, and determining the set data;
establishing a query interface;
establishing a mapping relation between the query interface and the set data;
and setting a preset inquiry rule of the inquiry interface.
Optionally, obtaining the right of the authorized user includes:
obtaining user information;
matching the user information in an authorized user list, and judging whether the user information is authorized user information;
and under the condition that the user information is authorized user information, inquiring the authority of the authorized user in a setting interface according to the user information.
Optionally, querying a device attribute value in a query interface of the set data according to the device attribute includes:
adjusting the device attribute to a preset query structure; the preset query structure is matched with a preset query rule of a query interface of the set data;
and inquiring the equipment attribute value at the inquiry interface of the set data according to the preset inquiry structure.
Optionally, obtaining device attributes comprises:
obtaining an Identity Document (ID);
and reading the device attribute according to the device ID.
Optionally, reading the device attribute according to the device ID includes:
reading the device attribute in a Remote Dictionary service (Redis) according to the device ID;
and under the condition that the device attribute cannot be successfully read in the Redis, reading the device attribute in a database according to the device ID.
In some optional embodiments, a method for querying device information is applied to a terminal, and the method for querying device information includes:
sending the device ID to a server; wherein the device ID is used for inquiring device attributes;
receiving a device attribute value sent by a server; the device attribute value is inquired in an inquiry interface of set data according to the device attribute, the set data is stored in a partial data table of a database, the partial data table corresponds to the authority of an authorized user, and the data table comprises the device attribute and a device attribute value corresponding to the device attribute;
and displaying the equipment attribute value.
Optionally, before receiving the device attribute value sent by the server, the method for querying the device information further includes:
obtaining user information;
sending the user information to the server; the user information is used for judging whether the current user has the authority of accessing the data.
In some optional embodiments, the database for storing device information comprises:
a configuration structure module configured to generate a query interface of the setting data;
and the data structure module stores setting data, and the setting data comprises equipment attributes and corresponding equipment attribute values.
Optionally, the database for storing device information further comprises:
the authorization structure module stores the user authority and an authorization data structure corresponding to the user authority;
the data structure module stores authorization data, and the authorization data structure and the authorization data have a mapping relation;
the configuration structure module is also configured to determine all authorization data corresponding to the specific user authority as setting data.
In some optional embodiments, the apparatus for querying device information is applied to a server, and the apparatus for querying device information includes:
a first obtaining module configured to obtain a device attribute and a query interface of pre-created setting data;
the query module is configured to query the device attribute value at the query interface of the set data according to the device attribute;
the setting data is stored in a partial data table of a database, the partial data table corresponds to the authority of an authorized user, and the data table comprises the device attribute and a device attribute value corresponding to the device attribute.
Optionally, the first obtaining module includes:
a first obtaining unit configured to obtain a right of an authorized user;
the matching unit is configured to match each authority of the authorized user with the description information of a data structure and determine the setting data;
a first creating unit configured to create a query interface;
the second creating unit is configured to establish a mapping relation between the query interface and the setting data;
a setting unit configured to set a preset query rule of the query interface.
Optionally, the first obtaining unit is specifically configured to:
obtaining user information;
matching the user information in an authorized user list, and judging whether the user information is authorized user information;
and under the condition that the user information is authorized user information, inquiring the authority of the authorized user in a setting interface according to the user information.
Optionally, the query module includes:
an adjusting unit configured to adjust the device attribute to a preset query structure; the preset query structure is matched with a preset query rule of a query interface of the set data;
and the query unit is configured to query the device attribute value in a query interface of the set data according to the preset query structure.
Optionally, the first obtaining module includes:
a second obtaining unit configured to obtain the device ID;
a reading unit configured to read the device attribute according to the device ID.
Optionally, the reading unit is specifically configured to:
reading the device attribute in Redis according to the device ID;
and under the condition that the device attribute cannot be successfully read in the Redis, reading the device attribute in a database according to the device ID.
In some optional embodiments, the apparatus for querying device information is applied to a terminal, and the apparatus for querying device information includes:
a first transmitting module configured to transmit the device ID to the server; wherein the device ID is used for inquiring device attributes;
the first receiving module is configured to receive the device attribute value sent by the server; the device attribute value is inquired in an inquiry interface of set data according to the device attribute, the set data is stored in a partial data table of a database, the partial data table corresponds to the authority of an authorized user, and the data table comprises the device attribute and a device attribute value corresponding to the device attribute;
a display module configured to display the device attribute values.
Optionally, the apparatus for querying device information further includes:
a second obtaining module configured to obtain the user information before receiving the device attribute value sent by the server;
a second transmitting module configured to transmit the user information to the server; the user information is used for judging whether the current user has the authority of accessing the data.
The method, the device and the database for querying the equipment information provided by the embodiment of the disclosure can achieve the following technical effects:
when the device attribute value needs to be inquired, the inquiry interface of the set data is inquired according to the device attribute, the device attribute value can be obtained only by accessing the data table for storing the set data, and the whole database does not need to be accessed, so that the time consumption of the inquiry process is reduced.
The foregoing general description and the following description are exemplary and explanatory only and are not restrictive of the application.
Drawings
One or more embodiments are illustrated in drawings corresponding to, and not limiting to, embodiments in which elements having the same reference number designation are illustrated as similar elements and in which:
fig. 1 is an environment schematic diagram of an actual environment involved in a method for querying device information provided by an embodiment of the present disclosure;
fig. 2 is a schematic diagram of a method for querying device information according to an embodiment of the present disclosure;
FIG. 3 is a schematic diagram of a query interface for creating provisioning data according to an embodiment of the present disclosure;
FIG. 4 is a schematic diagram of a method for obtaining rights of an authorized user according to an embodiment of the disclosure;
FIG. 5 is a schematic diagram of a query interface for querying device attribute values in setting data according to an embodiment of the present disclosure;
fig. 6 is a schematic diagram of a method for querying device information according to an embodiment of the present disclosure;
fig. 7 is a schematic diagram of a method for querying device information according to an embodiment of the present disclosure;
fig. 8 is a schematic diagram of a method for querying device information according to an embodiment of the present disclosure;
fig. 9 is a schematic diagram of a method for querying device information according to an embodiment of the present disclosure;
FIG. 10a is a schematic diagram of a database for storing device information provided by an embodiment of the present disclosure;
FIG. 10b is a schematic diagram of a database for storing device information provided by an embodiment of the present disclosure;
fig. 11a is a schematic diagram of an apparatus for querying device information according to an embodiment of the present disclosure;
fig. 11b is a schematic diagram of an apparatus for querying device information according to an embodiment of the present disclosure;
fig. 11c is a schematic diagram of an apparatus for querying device information according to an embodiment of the present disclosure;
fig. 11d is a schematic diagram of an apparatus for querying device information according to an embodiment of the present disclosure;
fig. 12a is a schematic diagram of an apparatus for querying device information according to an embodiment of the present disclosure;
fig. 12b is a schematic diagram of an apparatus for querying device information according to an embodiment of the present disclosure;
fig. 13 is a schematic diagram of an apparatus for querying device information according to an embodiment of the present disclosure.
Detailed Description
So that the manner in which the features and elements of the disclosed embodiments can be understood in detail, a more particular description of the disclosed embodiments, briefly summarized above, may be had by reference to the embodiments, some of which are illustrated in the appended drawings. In the following description of the technology, for purposes of explanation, numerous details are set forth in order to provide a thorough understanding of the disclosed embodiments. However, one or more embodiments may be practiced without these details. In other instances, well-known structures and devices may be shown in simplified form in order to simplify the drawing.
The terms "first," "second," and the like in the description and in the claims, and the above-described drawings of embodiments of the present disclosure, are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It should be understood that the data so used may be interchanged under appropriate circumstances such that embodiments of the present disclosure described herein may be made. Furthermore, the terms "comprising" and "having," as well as any variations thereof, are intended to cover non-exclusive inclusions.
The term "plurality" means two or more unless otherwise specified.
In the embodiment of the present disclosure, the character "/" indicates that the preceding and following objects are in an or relationship. For example, A/B represents: a or B.
The term "and/or" is an associative relationship that describes objects, meaning that three relationships may exist. For example, a and/or B, represents: a or B, or A and B.
At present, most products for querying data can query device data in a one-to-one targeted manner, that is, only one type of data of one device can be queried at a time. In the embodiment of the disclosure, in order to realize batch query of information of devices, a terminal sends a device ID to a server, the server obtains a device attribute according to the device ID, and queries a device attribute value in a query interface of set data in batch according to the device attribute, and only one query instruction needs to be executed to obtain a plurality of messages of the devices, without executing the query device attribute value one by one, thereby reducing the number of times of executing the query instruction, reducing query time, and improving the real-time performance of the process of querying batch information.
Referring to fig. 1, an environment diagram of an actual environment involved in a method for querying device information is provided in an embodiment of the present disclosure. The implementation environment includes a terminal 110 and a server 120.
The terminal 110 is an electronic device having a network access function and a man-machine interaction function. The terminal 110 may be a smart phone, a tablet Computer, an Ultra-mobile Personal Computer (UMPC), a netbook, a Personal Digital Assistant (PDA), and the like, but is not limited thereto. A terminal has a specific Application (APP) installed thereon. The terminal 110 may be provided on the device or may be provided independently.
The server 120 may be a single server, or a server cluster consisting of several servers, or a distributed server consisting of several servers.
In some practical applications, the server 120 is a distributed server, and the deployment of the server 120 conforms to the service concurrency principle, the service classification principle, and the service based on the authorization and service extension principle. Service Nodes (Nodes) are distributed at a user side and an equipment side, and the Nodes respond to a real-time service request through a reliable coordination system (ZooKeeper) of the distributed system.
As shown in fig. 2, an embodiment of the present disclosure provides a method for querying device information. The method for querying device information in this embodiment is exemplified by being applied to the server shown in fig. 1. The method for inquiring the equipment information comprises the following steps:
s201, obtaining the equipment attribute and the query interface of the pre-created setting data.
Wherein, the device attribute refers to an attribute of the device to which data can be recorded. For example, the device attributes include one or more of device details, device operating curves, device real-time status, and device faults.
The device details may include: the device comprises one or more of device offline time, device installation time, first binding time, device installation address, device production factory, device accumulated online time, device startup time, device accumulated operation time, device accumulated failure alarm times, user ID, user last login time and user last login terminal name.
The plant operating curve is the time-dependent variation of a specific environmental variable that the plant can accommodate. For example, the air conditioner may adjust the indoor temperature, and the device operation curve may include a time-varying curve of the indoor temperature; the refrigerator may adjust the temperature of the refrigerating chamber and the temperature of the freezing chamber, and the apparatus operation curve may include a time-varying curve of the temperature of the refrigerating chamber or a time-varying curve of the temperature of the freezing chamber.
The real-time state of the device is the real-time operating state of each actuator in the device, such as the real-time operating state of a buzzer, or the real-time operating state of a refrigerator/air conditioner compressor, or the opening and closing state of a door of the device.
The equipment failure may include a fault code, a fault description, and a time at which the fault occurred.
The device attribute may be directly received, for example, the terminal directly sends the device attribute to the server, and the server directly obtains the device attribute.
Alternatively, the device attribute is indirectly obtained, for example, a device ID (device ID transmitted by the receiving terminal) is obtained, and the device attribute is read based on the device ID. Therefore, the terminal only needs to send the equipment ID to the server, namely, the user only needs to select/input the equipment ID in the terminal, and the service can obtain all the equipment attribute values, so that the user operation is reduced, and the user experience is improved.
Optionally, reading the device attribute according to the device ID includes: reading the device attribute in Redis according to the device ID; in the case where the device attribute cannot be successfully read in Redis, the device attribute is read in the database according to the device ID. Reading the device attribute in Redis can improve the reading speed, further shorten the time consumption for inquiring the batch information of the device and improve the real-time property of inquiring the batch information.
Correspondingly, when the device attribute changes, the server receives the new device attribute of the device and updates the new device attribute of the device to Redis. Facilitating the next reading.
Optionally, the set data includes one or more of device detail data, device operating curve data, device real-time status data, and device fault data.
The query interface for setting data can be obtained by: determining a query interface of the set data corresponding to the equipment ID according to the equipment ID; or acquiring the user information, and determining the query interface of the setting data corresponding to the user information according to the user information.
In some practical applications, when a user logs in for the first time and inquires equipment information for the first time, an inquiry interface for setting data is established, and then the equipment attribute and the inquiry interface for setting data are obtained; when a user logs in and inquires equipment information for a non-initial time, the equipment attribute is obtained and the inquiry interface of the set data is directly inquired.
In some practical applications, when the authority of the authorized user changes, the query interface for setting data is created again, and then the device attribute and the query interface for setting data are obtained.
In some practical applications, the server is a distributed server, such as a multi-machine deployed binary distributed service framework (libbo) server, and the query interface for setting data may be a Remote Procedure Call (RPC) interface. Service concurrence can be realized by adopting the Dubbo server deployed by multiple machines.
And S202, inquiring the attribute value of the equipment in an inquiry interface of the set data according to the attribute of the equipment.
The setting data is stored in a partial data table of the database, the partial data table corresponds to the authority of the authorized user, namely, the partial data table is a data table of the database in which the authorized user has access authority, and the data table comprises the device attribute and the device attribute value corresponding to the device attribute.
The device attribute value is a specific value corresponding to the device attribute. For example, the device attribute values include one or more of device detail values, device operational curve values, device real-time status values, and device fault values.
The device detail values may include: the terminal name value comprises one or more of a device offline time value, a device installation time value, a first binding time value, a device installation address value, a device production factory value, a device accumulated online time value, a device startup time value, a device accumulated operation time value, a device accumulated failure alarm time value, a user ID value, a user last login time value and a user last login terminal name value.
The plant operating curve values are the values over time of the specific environmental variables that the plant can adjust. For example, the air conditioner may adjust the indoor temperature, then the device operating curve values may include indoor temperature values over time; the refrigerator may adjust the refrigerating chamber temperature and the freezing chamber temperature, and the apparatus operation curve may include a refrigerating chamber temperature value or a freezing chamber temperature value varying with time.
The equipment real-time state value includes a real-time operation state value of a buzzer, or a real-time operation state value of a refrigerator/air conditioner compressor, or an opening and closing state value of an equipment door.
The equipment fault values may include fault code values, fault description values, and fault occurrence time values. Wherein, the fault code value and the fault description value are predefined and are in one-to-one correspondence. The fault description value can be an electricity fault alarm, an equipment internal fault alarm or an equipment environment alarm. Or the fault description value can be power supply overvoltage/low-voltage protection alarm and leakage alarm; or, compressor abnormity alarm and fan abnormity alarm are carried out; or, the alarm for over-high/over-low ambient temperature and over-high ambient humidity.
And sending a query instruction of a preset query structure to a query interface of the set data, wherein the query interface can return the attribute value of the equipment. In some implementations, the query interface may dynamically invoke the provisioning data.
When the device attribute value needs to be inquired, the inquiry interface of the set data is inquired according to the device attribute, the device attribute value can be obtained only by accessing the data table for storing the set data, and the whole database does not need to be accessed, so that the time consumption of the inquiry process is reduced.
In some application scenarios, when a plurality of terminals send a plurality of query instructions to a server, the server obtains the priority of each terminal and the priority of each query service, and provides the query service with high priority to the terminal with high priority.
As shown in fig. 3, the query interface for setting data is created by:
s301, obtaining the authority of the authorized user.
The authority here refers to the authority of a user to access data (attribute values of each device), and the data security is improved by setting the access authority of the data.
The rights may include: one or more of a device allowed to access, a data attribute of the device allowed to access, and a time period allowed to access. For example, a first user is allowed to access the a device and the B device, the first user is not allowed to access the C device, a second user is allowed to access the B device and the C device, and the second user is not allowed to access the a device; or allowing the first user to access the device details of the A device, disallowing the first user to access the device operation curve, the device real-time state and the device fault of the A device, allowing the second user to access the device details and the device fault of the A device, and disallowing the second user to access the device operation curve and the device real-time state of the A device; or, the first user is allowed to access the device attribute values of the A device for the last week, and the second user is allowed to access the device attribute values of the A device for the last half month.
The authority of the authorized user can be directly sent to the server through the terminal;
or the terminal sends user information to the server, in the server, one interface exposes the authority of a single user, and the server can inquire the authority of an authorized user through the interface.
S302, matching each authority of the authorized user with the description information of the data structure, and determining the setting data.
The description information of the data structure comprises equipment membership information of the stored data, attribute information of the stored data and time information of the stored data in the data table.
Each authority of the authorized user is matched with one or more data structures, one or more data structures can be matched through the authority of the authorized user, data stored in a data table corresponding to one or more data structures is authorized data, and the authorized data is set data in the steps.
In some practical applications, the server is a distributed server, for example, a multi-machine deployed Dubbo server, and a metadata center of the multi-machine deployed Dubbo server internally manages description information of all openable data, and exposes an open RPC interface of the data structure to the outside. The description information of all data structures can be inquired through the RPC interface of the data structures.
The server reads the device attributes by the device ID, and can obtain all the device attributes. Often, a user is only allowed to access the attribute values of some device attributes, i.e. the setting data includes some device attributes and their corresponding device attribute values. The device attribute values obtained by querying the device attributes in the query interface of the setting data are only the device attribute values (not the attribute values corresponding to all the device attributes) that the user is authorized to access. In the process of obtaining the device attribute value, the terminal sends the device ID to the server, and the server can return the device attribute value accessible to the user to the terminal, obviously, network consumption is reduced; meanwhile, the user can obtain the device attribute value accessible to the user only by providing the device ID, and the user experience is also improved.
S303, establishing a query interface.
For example, a variable is created to represent the query interface.
S304, establishing a mapping relation between the query interface and the set data.
For example, a Uniform Resource Locator (URL) of the binding setting data and the variable are set.
S305, setting a preset query rule of the query interface.
For example, the request type, entry parameters, and return parameters of the query interface are set. The request type includes GET or POST, the entry parameter includes one or more device attributes, and the return parameter includes a device attribute value corresponding to the one or more device attributes (entry parameter).
In order to improve data security, access rights are typically set in the database. In the above steps, the data table for storing the setting data is the setting data accessible to the authorized user, which is convenient for the authorized user to read the setting data in batch, further reduces the time consumption for inquiring batch information, and improves the real-time property for inquiring batch information.
In some practical application scenarios, there are multiple device attributes, and the device attribute values for different user requirements are different. For example, the device attributes include a, b, and c, and the first user only needs the a value and the second user only needs the b and c values. In this case, the rights of the authorized user are user-defined, i.e., the rights of the authorized user are a part of the maximum rights of the authorized user. For example, in theory, a first user can access a and b, but in the using process, the first user can only access a, then, the maximum authority of the first user is to access a and b, and the authority of the first user is to access a and not to access b in the practical application process; in theory, the second user can access a, b and c, in practical application, the second user can only access b and c, then, the maximum authority of the second user is to access a, b and c, and the authority of the second user is to access b and c in practical application. Setting the authority of the first user to ensure that the value returned to the first user only comprises the value a (does not comprise the value b and the value c); similarly, by setting the authority of the second user, the value returned to the second user only comprises the b value and the c value (not comprising the a value), so that the setting of the authority of the user can not only improve the safety of data, but also configure the query result meeting the requirements of the user for different users without transmitting all the device attribute values, thereby improving the use experience of the user; and meanwhile, the network consumption is also reduced.
As shown in fig. 4, obtaining the right of the authorized user includes:
s401, obtaining user information.
The terminal reads the user information input by the user, and the terminal sends the user information to the server, so that the server can obtain the user information. Or the query request sent by the terminal to the server includes the user information, and the server receives the query request and then analyzes the user information.
Before the user is authorized, the user information comprises a user password or the user password and a user ID, the terminal sends the user information to the server, and the server receives the user information. Optionally, the terminal sends the user information to the server through the authentication interface. For example, in a distributed server, the terminal sends user information to the server through an authenticated RPC interface.
After the user obtains authorization, the user information comprises a user password, or a user ID, or the user password and the user ID, the server reads an inquiry request sent by the terminal, and the user information is analyzed in the inquiry request.
S402, matching the user information in the authorized user list and judging whether the user information is authorized user information.
The authorized user list stores authorized user information, and if the user information is successfully matched in the authorized user list, the user information is the authorized user information; and if the user information cannot be matched in the authorized user list, the user information is unauthorized user information.
And S403, under the condition that the user information is authorized user information, inquiring the authority of the authorized user in the setting interface according to the user information.
The setting interface exposes the authority of a single user, and the authority of an authorized user can be inquired through the setting interface.
The authority of the authorized user can be obtained through the steps.
Referring to fig. 5, querying the device attribute value in the query interface of the setting data according to the device attribute includes:
s501, adjusting the device attribute to be a preset query structure.
The preset query structure is matched with the preset query rule of the query interface of the set data.
The preset query structure comprises one or more conditions, and each datum in the query result meets the conditions.
In some specific applications, the preset query structure includes a query mode, a table name, a query condition, and the like, where the query mode may be a fuzzy query or a sorting query, and the query condition may be a time filtering or an upper and lower limit filtering, and the like.
And S502, inquiring the attribute value of the equipment in the inquiry interface of the set data according to the preset inquiry structure.
And after the set data query interface receives a query instruction of a preset query structure, returning a query result corresponding to the query instruction.
Through the steps, a plurality of information corresponding to the device attributes can be obtained.
As shown in fig. 6, an embodiment of the present disclosure provides a method for querying device information. The method for querying device information in this embodiment is applied to the terminal shown in fig. 1 for example. The method for inquiring the equipment information comprises the following steps:
s601, sending the equipment ID to a server; wherein the device ID is used to query the device attributes.
The device ID includes a device number or a Media Access control address (MAC). In practical applications, the device ID may be all or part of the device number, or the device ID may be all or part of the device MAC.
After receiving the device ID, the server may read the device attribute in the Redis according to the device ID; in the case where the device attribute cannot be successfully read in Redis, the device attribute is read in the database according to the device ID.
The device attribute refers to an attribute of the device to which data can be recorded. For example, the device attributes include one or more of device details, device operating curves, device real-time status, and device faults.
And S602, receiving the device attribute value sent by the server.
The device attribute value is inquired in an inquiry interface of the set data according to the device attribute, the set data is stored in a partial data table in a database, and the set data comprises the device attribute and a device attribute value corresponding to the device attribute.
The device attribute refers to an attribute of the device to which data can be recorded. For example, the device attributes include one or more of device details, device operating curves, device real-time status, and device faults.
The device details may include: the device comprises one or more of device offline time, device installation time, first binding time, device installation address, device production factory, device accumulated online time, device startup time, device accumulated operation time, device accumulated failure alarm times, user ID, user last login time and user last login terminal name.
The plant operating curve is the time-dependent variation of a specific environmental variable that the plant can accommodate. For example, the air conditioner may adjust the indoor temperature, and the device operation curve may include a time-varying curve of the indoor temperature; the refrigerator may adjust the temperature of the refrigerating chamber and the temperature of the freezing chamber, and the apparatus operation curve may include a time-varying curve of the temperature of the refrigerating chamber or a time-varying curve of the temperature of the freezing chamber.
The real-time state of the device is the real-time operating state of each actuator in the device, such as the real-time operating state of a buzzer, or the real-time operating state of a refrigerator/air conditioner compressor, or the opening and closing state of a door of the device.
The equipment failure may include a fault code, a fault description, and a time at which the fault occurred.
The device attribute value is a specific value corresponding to the device attribute. For example, the device attribute values include one or more of device detail values, device operational curve values, device real-time status values, and device fault values.
The device detail values may include: the terminal name value comprises one or more of a device offline time value, a device installation time value, a first binding time value, a device installation address value, a device production factory value, a device accumulated online time value, a device startup time value, a device accumulated operation time value, a device accumulated failure alarm time value, a user ID value, a user last login time value and a user last login terminal name value.
The plant operating curve values are the values over time of the specific environmental variables that the plant can adjust. For example, the air conditioner may adjust the indoor temperature, then the device operating curve values may include indoor temperature values over time; the refrigerator may adjust the refrigerating chamber temperature and the freezing chamber temperature, and the apparatus operation curve may include a refrigerating chamber temperature value or a freezing chamber temperature value varying with time.
The equipment real-time state value includes a real-time operation state value of a buzzer, or a real-time operation state value of a refrigerator/air conditioner compressor, or an opening and closing state value of an equipment door.
The equipment fault values may include fault code values, fault description values, and fault occurrence time values. Wherein, the fault code value and the fault description value are predefined and are in one-to-one correspondence. The fault description value can be an electricity fault alarm, an equipment internal fault alarm or an equipment environment alarm. Or the fault description value can be power supply overvoltage/low-voltage protection alarm and leakage alarm; or, compressor abnormity alarm and fan abnormity alarm are carried out; or, the alarm for over-high/over-low ambient temperature and over-high ambient humidity.
Optionally, before receiving the device attribute value sent by the server, the method for querying the device information further includes: and obtaining a screening time period and sending the screening time period to the server.
In some application scenarios, the terminal includes a touch screen, the user inputs the screening time period in the touch screen, and the terminal reads the operation of the user on the touch screen to obtain the screening time period.
In other practical application scenarios, the terminal includes a display screen and an input device (e.g., a keyboard or a mechanical operation panel), the user inputs the screening time period through the input device, and the terminal reads the operation of the user on the input device to obtain the screening time period.
And S603, displaying the device attribute values.
The terminal displays the device attribute values in the form of a table, for example, the terminal displays device details, device implementation status information, and device failures in the form of a table.
Alternatively, the terminal displays the device attribute values in the form of a curve, for example, a terminal display device operation curve.
When the device attribute value needs to be inquired, the inquiry interface of the set data is inquired according to the device attribute, the device attribute value can be obtained only by accessing the data table for storing the set data, and the whole database does not need to be accessed, so that the time consumption of the inquiry process is reduced.
As shown in fig. 7, before receiving the device attribute value sent by the server, the method for querying the device information further includes:
and S701, obtaining user information.
The terminal reads the user information input by the user, and the terminal sends the user information to the server, so that the server can obtain the user information. The user information includes a user password, or a user password and a user ID.
In some practical application scenarios, the terminal includes a touch screen, a user inputs user information in the touch screen, and the terminal reads an operation of the user on the touch screen to obtain the user information.
In other practical application scenarios, the terminal includes a display screen and an input device (e.g., a keyboard or a mechanical operation panel), the user inputs user information through the input device, and the terminal reads the operation of the input device by the user to obtain the user information.
S702, sending the user information to the server.
The server can judge whether the current user has the authority of accessing the data according to the user information. The data security is improved.
As shown in fig. 8, an embodiment of the present disclosure provides a method for querying device information. The present embodiment exemplifies a method for querying device information from the perspective of information interaction between a terminal and a server. The method for inquiring the equipment information comprises the following steps:
s801, the terminal sends an equipment ID to the server;
s802, the server obtains the device attribute according to the device ID;
s803, the server obtains a query interface of the set data;
s804, the server inquires the attribute value of the equipment in an inquiry interface of the set data according to the attribute of the equipment;
s805, the terminal receives the equipment attribute value sent by the server;
and S806, displaying the device attribute value by the terminal.
As shown in fig. 9, an embodiment of the present disclosure provides a method for querying device information. The present embodiment exemplifies a method for querying device information from the perspective of information interaction between a terminal and a server. The method for inquiring the equipment information comprises the following steps:
s901, the terminal obtains user information;
s902, the terminal sends user information to the server;
s903, the server matches the user information in an authorized user list and judges whether the user information is authorized user information;
s904, under the condition that the user information is authorized user information, the terminal sends the equipment ID to the server;
s905, the server obtains the equipment attribute according to the equipment ID;
s906, the server obtains a query interface of the set data;
s907, the server inquires the equipment attribute value at the inquiry interface of the set data according to the equipment attribute;
s908, the terminal receives the device attribute value sent by the server;
and S909, displaying the device attribute value by the terminal.
In some practical application scenarios, a user logs in at a login interface, the user selects a device ID and a time period at a selection interface, the user clicks on a confirmation, and the interface displays one or more of device details, operating curves, real-time status, and fault push.
As shown in connection with fig. 10a, an embodiment of the present disclosure provides a database for storing device information. The database for storing device information includes a configuration structure module 1001 and a data structure module 1002, wherein the configuration structure module 1001 is configured as a query interface for generating setting data; the data structure module 1002 stores setting data, which includes device attributes and device attribute values corresponding to the device attributes.
In the database, the device attribute and the device attribute value corresponding to the device attribute are used as independent modules with query interfaces, so that set data can be conveniently and independently accessed, when the device attribute value needs to be queried, the query interface of the set data is queried according to the device attribute, the device attribute value can be obtained only by accessing a data table for storing the set data, all databases do not need to be accessed, and the time consumption of the query process is reduced.
As shown in connection with fig. 10b, the database for storing device information also includes an authorization structure module 1003. The authorization structure module 1003 stores the user authority and the corresponding authorization data structure; the data structure module 1002 stores authorization data, and the authorization data structure and the authorization data have a mapping relation; the configuration structure module 1001 is further configured to determine all authorization data corresponding to a specific user authority as setting data.
The models of the database can be arranged on the same service or different servers.
The configuration structure module 1001 may store data via a relational table, for example, using a KeyValue structure or a Json structure. The configuration structure module 1001 may also include Redis.
The data structure module 1002 may store data via a relational table, for example, using a KeyValue structure or a Json structure. The data structure module 1002 may also include Redis.
The authorization structure module 1003 may store data through a relational table, for example, using a KeyValue structure or a Json structure. The authorization structure module 1003 may also include Redis.
In some embodiments, the database for storing device information further comprises an active management module, wherein the active management module stores interface access records, authorization monitoring and call latency.
Optionally, the database for storing device information further includes a Cache module, which is connected to configuration structure module 1001 and an effective management module. After the configuration structure module 1001 or the effective management module changes data, the changed data is synchronized to the Cache module, and the pressure of the database can be reduced.
As shown in fig. 11a, an embodiment of the present disclosure provides an apparatus for querying device information. The apparatus for querying device information may be implemented by software, hardware or a combination of both as all or part of the server shown in fig. 1. The apparatus for querying device information includes a first obtaining module 1110 and a querying module 1120, wherein the first obtaining module 1110 is configured as a querying interface for obtaining device attributes and pre-created setting data; the query module 1120 is configured to query the device attribute values according to the device attributes in a query interface of the setting data, and the setting data is stored in a partial data table of the database, where the partial data table corresponds to the authority of the authorized user, and the data table includes the device attributes and the device attribute values corresponding to the device attributes.
As shown in connection with fig. 11b, the first obtaining module 1110 includes a first obtaining unit 1111, a matching unit 1112, a first creating unit 1113, a second creating unit 1114, and a setting unit 1115, wherein the first obtaining unit 1111 is configured to obtain the right of the authorized user; the matching unit 1112 is configured to match each right of the authorized user with the description information of the data structure, determining the setting data; the first creating unit 1113 is configured to establish a query interface; the second creating unit 1114 is configured to establish a mapping relationship between the query interface and the setting data; the setting unit 1115 is configured to set a preset query rule of the query interface.
Optionally, the first obtaining unit is specifically configured to:
obtaining user information;
matching user information in the authorized user list, and judging whether the user information is authorized user information;
and under the condition that the user information is authorized user information, inquiring the authority of the authorized user in the setting interface according to the user information.
As shown in fig. 11c, the query module 1120 includes an adjusting unit 1121 and a query unit 1122, where the adjusting unit 1121 is configured to adjust the device attribute to a preset query structure, and the preset query structure is adapted to a preset query rule of a query interface of the set data; the querying unit 1122 is configured to query the device attribute values at the query interface of the setting data according to a preset query structure.
As shown in connection with fig. 11d, the first obtaining module 1110 comprises a second obtaining unit 1114 and a reading unit 1115, wherein the second obtaining unit 1114 is configured to obtain the device ID; the reading unit 1115 is configured to read the device attribute according to the device ID.
Optionally, the reading unit is specifically configured to: reading the device attribute in Redis according to the device ID; in the case where the device attribute cannot be successfully read in Redis, the device attribute is read in the database according to the device ID.
As shown in fig. 12a, an embodiment of the present disclosure provides an apparatus for querying device information. The apparatus for querying device information may implement all or a portion of the terminal shown in fig. 1 through software, hardware, or a combination of both. The apparatus for querying device information includes a first transmitting module 1210, a first receiving module 1220, and a display module 1230, wherein the first transmitting module 1210 is configured to transmit a device ID to a server; the device ID is used for inquiring the device attribute; the first receiving module 1220 is configured to receive the device attribute value transmitted by the server; the device attribute value is inquired in an inquiry interface of the set data according to the device attribute, the set data is stored in a partial data table of a database, the partial data table corresponds to the authority of an authorized user, and the data table comprises the device attribute and the device attribute value corresponding to the device attribute; the display module 1230 is configured to display the device attribute values.
As shown in fig. 12b, the apparatus for querying device information further includes a second obtaining module 1240 and a second sending module 1250, where the second obtaining module 1240 is configured to obtain the user information before receiving the device attribute value sent by the server; the second transmitting module 1250 is configured to transmit the user information to the server; the user information is used for judging whether the current user has the authority of accessing the data.
Optionally, the second obtaining module 1240 is further configured to obtain a screening period; the second sending module 1250 is further configured to send the screening period to the server.
In some embodiments, an apparatus for querying device information includes a processor and a memory storing program instructions, the processor being configured to execute, when executing the program instructions, the method for querying device information provided by the foregoing embodiments.
As shown in fig. 13, an embodiment of the present disclosure provides an apparatus for querying device information. The apparatus for inquiring equipment information includes:
a processor (processor)131 and a memory (memory)132, and may further include a Communication Interface 133 and a bus 134. The processor 131, the communication interface 133, and the memory 132 may communicate with each other through the bus 134. The communication interface 133 may be used for information transfer. The processor 131 may call logic instructions in the memory 132 to perform the method for querying device information provided by the foregoing embodiments.
Furthermore, the logic instructions in the memory 132 may be implemented in software functional units and stored in a computer readable storage medium when sold or used as a stand-alone product.
The memory 132 is a computer-readable storage medium, and can be used for storing software programs, computer-executable programs, such as program instructions/modules corresponding to the methods in the embodiments of the present disclosure. The processor 131 executes the functional application and data processing by executing the software program, instructions and modules stored in the memory 132, that is, implements the method in the above-described method embodiments.
The memory 132 may include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required for at least one function; the storage data area may store data created according to the use of the terminal device, and the like. Further, the memory 132 may include a high-speed random access memory, and may also include a non-volatile memory.
The embodiment of the disclosure provides a storage medium, which stores computer-executable instructions configured to execute the method for querying device information provided by the foregoing embodiment.
The disclosed embodiments provide a computer program product comprising a computer program stored on a computer-readable storage medium, the computer program comprising program instructions that, when executed by a computer, cause the computer to perform the method for querying device information provided by the foregoing embodiments.
The computer-readable storage medium described above may be a transitory computer-readable storage medium or a non-transitory computer-readable storage medium.
The technical solution of the embodiments of the present disclosure may be embodied in the form of a software product, where the computer software product is stored in a storage medium and includes one or more instructions to enable a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method in the embodiments of the present disclosure. And the aforementioned storage medium may be a non-transitory storage medium comprising: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes, and may also be a transient storage medium.
The above description and drawings sufficiently illustrate embodiments of the disclosure to enable those skilled in the art to practice them. Other embodiments may incorporate structural, logical, electrical, process, and other changes. The examples merely typify possible variations. Individual components and functions are optional unless explicitly required, and the sequence of operations may vary. Portions and features of some embodiments may be included in or substituted for those of others. Furthermore, the words used in the specification are words of description only and are not intended to limit the claims. As used in the description of the embodiments and the claims, the singular forms "a", "an" and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise. Similarly, the term "and/or" as used in this application is meant to encompass any and all possible combinations of one or more of the associated listed. Furthermore, the terms "comprises" and/or "comprising," when used in this application, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method or device comprising the element. In this document, each embodiment may be described with emphasis on differences from other embodiments, and the same and similar parts between the respective embodiments may be referred to each other. For methods, products, etc. of the embodiment disclosures, reference may be made to the description of the method section for relevance if it corresponds to the method section of the embodiment disclosure.
Those of skill in the art would appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware or combinations of computer software and electronic hardware. Whether such functionality is implemented as hardware or software may depend upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the disclosed embodiments. It can be clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working processes of the system, the apparatus and the unit described above may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the embodiments disclosed herein, the disclosed methods, products (including but not limited to devices, apparatuses, etc.) may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, a division of a unit may be merely a division of a logical function, and an actual implementation may have another division, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form. Units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to implement the present embodiment. In addition, functional units in the embodiments of the present disclosure may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit.
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). In some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. Each block of the block diagrams and/or flowchart illustrations, and combinations of blocks in the block diagrams and/or flowchart illustrations, can be implemented by special purpose hardware-based systems that perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
Claims (11)
1. A method for inquiring equipment information is applied to a server, and is characterized in that the method comprises the following steps:
obtaining the equipment attribute and a query interface of pre-created setting data;
inquiring the attribute value of the equipment in an inquiry interface of the set data according to the attribute of the equipment;
the setting data is stored in a partial data table of a database, the partial data table corresponds to the authority of an authorized user, and the data table comprises the device attribute and the device attribute value corresponding to the device attribute.
2. The method of claim 1, wherein the query interface for the provisioning data is created by:
obtaining the authority of an authorized user;
matching each authority of the authorized user with the description information of a data structure, and determining the set data;
establishing a query interface;
establishing a mapping relation between the query interface and the set data;
and setting a preset inquiry rule of the inquiry interface.
3. The method of claim 2, wherein obtaining the rights of the authorized user comprises:
obtaining user information;
matching the user information in an authorized user list, and judging whether the user information is authorized user information;
and under the condition that the user information is authorized user information, inquiring the authority of the authorized user in a setting interface according to the user information.
4. The method of claim 1, wherein querying the device attribute value in a query interface of the setting data according to the device attribute comprises:
adjusting the device attribute to a preset query structure; the preset query structure is matched with a preset query rule of a query interface of the set data;
and inquiring the equipment attribute value at the inquiry interface of the set data according to the preset inquiry structure.
5. The method of any of claims 1 to 4, wherein obtaining device attributes comprises:
obtaining a device ID;
and reading the device attribute according to the device ID.
6. The method of claim 5, wherein reading the device attribute according to the device ID comprises:
reading the device attribute in Redis according to the device ID;
and under the condition that the device attribute cannot be successfully read in the Redis, reading the device attribute in a database according to the device ID.
7. A method for inquiring equipment information is applied to a terminal, and is characterized in that the method comprises the following steps:
sending the device ID to a server; wherein the device ID is used for inquiring device attributes;
receiving a device attribute value sent by a server; the device attribute value is inquired in an inquiry interface of set data according to the device attribute, the set data is stored in a partial data table of a database, the partial data table corresponds to the authority of an authorized user, and the data table comprises the device attribute and the device attribute value corresponding to the device attribute;
and displaying the equipment attribute value.
8. A database for storing device information, comprising:
a configuration structure module configured to generate a query interface of the setting data;
and the data structure module stores setting data, and the setting data comprises equipment attributes and corresponding equipment attribute values.
9. The database of claim 8, further comprising:
the authorization structure module stores the user authority and an authorization data structure corresponding to the user authority;
the data structure module stores authorization data, and the authorization data structure and the authorization data have a mapping relation;
the configuration structure module is also configured to determine all authorization data corresponding to the specific user authority as setting data.
10. An apparatus for querying device information, applied to a server, the apparatus comprising:
a first obtaining module configured to obtain a device attribute and a query interface of pre-created setting data;
the query module is configured to query the device attribute value at the query interface of the set data according to the device attribute;
the setting data is stored in a partial data table of a database, the partial data table corresponds to the authority of an authorized user, and the data table comprises the device attribute and the device attribute value corresponding to the device attribute.
11. An apparatus for querying device information, applied to a terminal, the apparatus comprising:
a first transmitting module configured to transmit the device ID to the server; wherein, the device ID is used for inquiring the device attribute;
the first receiving module is configured to receive the device attribute value sent by the server; the device attribute value is inquired in an inquiry interface of set data according to the device attribute, the set data is stored in a partial data table of a database, the partial data table corresponds to the authority of an authorized user, and the data table comprises the device attribute and the device attribute value corresponding to the device attribute;
a display module configured to display the device attribute values.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010531434.XA CN111737291B (en) | 2020-06-11 | 2020-06-11 | Method, device and database for inquiring equipment information |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010531434.XA CN111737291B (en) | 2020-06-11 | 2020-06-11 | Method, device and database for inquiring equipment information |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111737291A true CN111737291A (en) | 2020-10-02 |
| CN111737291B CN111737291B (en) | 2023-07-21 |
Family
ID=72650144
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010531434.XA Active CN111737291B (en) | 2020-06-11 | 2020-06-11 | Method, device and database for inquiring equipment information |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111737291B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112699146A (en) * | 2020-12-31 | 2021-04-23 | 新奥数能科技有限公司 | Data pushing method and device based on general information model, server and storage medium |
Citations (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6366915B1 (en) * | 1998-11-04 | 2002-04-02 | Micron Technology, Inc. | Method and system for efficiently retrieving information from multiple databases |
| CN101030175A (en) * | 2006-02-28 | 2007-09-05 | 国际商业机器公司 | Universal serial bus storage device and access control method thereof |
| CN106649772A (en) * | 2016-12-27 | 2017-05-10 | 上海上讯信息技术股份有限公司 | Method and equipment for accessing data |
| CN107545047A (en) * | 2017-08-17 | 2018-01-05 | 平安科技（深圳）有限公司 | The querying method and terminal device of user right data |
| US20180025174A1 (en) * | 2016-07-21 | 2018-01-25 | Salesforce.Com, Inc. | Access controlled queries against user data in a datastore |
| CN108804944A (en) * | 2018-06-04 | 2018-11-13 | 北京奇虎科技有限公司 | Access authorization for resource configuration method based on tables of data and device |
| CN108830101A (en) * | 2018-06-04 | 2018-11-16 | 北京奇虎科技有限公司 | Application permission configuration method and device based on tables of data |
| CN110298189A (en) * | 2018-03-23 | 2019-10-01 | 华为技术有限公司 | Data base authority management method and equipment |
| CN110399747A (en) * | 2019-07-18 | 2019-11-01 | 佳都新太科技股份有限公司 | A kind of user right correlating method, querying method and device |
| CN110704833A (en) * | 2019-10-10 | 2020-01-17 | 北京字节跳动网络技术有限公司 | Data permission configuration method, device, electronic device and storage medium |
| CN110704872A (en) * | 2019-09-24 | 2020-01-17 | 天津卓朗科技发展有限公司 | Data query method and device, electronic equipment and computer readable storage medium |
| CN110795485A (en) * | 2019-10-29 | 2020-02-14 | 杭州求是优脉科技有限公司 | Database access method, device and equipment |
| US20200118076A1 (en) * | 2008-01-15 | 2020-04-16 | Sciquest, Inc. | User-Specific Rule-Based Database Querying |
| CN111177789A (en) * | 2020-01-07 | 2020-05-19 | 江苏满运软件科技有限公司 | Authority management method, system, device and storage medium |
| CN111177671A (en) * | 2019-12-16 | 2020-05-19 | 北京淇瑀信息科技有限公司 | Data management platform and method and electronic equipment |
-
2020
- 2020-06-11 CN CN202010531434.XA patent/CN111737291B/en active Active
Patent Citations (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6366915B1 (en) * | 1998-11-04 | 2002-04-02 | Micron Technology, Inc. | Method and system for efficiently retrieving information from multiple databases |
| CN101030175A (en) * | 2006-02-28 | 2007-09-05 | 国际商业机器公司 | Universal serial bus storage device and access control method thereof |
| US20200118076A1 (en) * | 2008-01-15 | 2020-04-16 | Sciquest, Inc. | User-Specific Rule-Based Database Querying |
| US20180025174A1 (en) * | 2016-07-21 | 2018-01-25 | Salesforce.Com, Inc. | Access controlled queries against user data in a datastore |
| CN106649772A (en) * | 2016-12-27 | 2017-05-10 | 上海上讯信息技术股份有限公司 | Method and equipment for accessing data |
| CN107545047A (en) * | 2017-08-17 | 2018-01-05 | 平安科技（深圳）有限公司 | The querying method and terminal device of user right data |
| CN110298189A (en) * | 2018-03-23 | 2019-10-01 | 华为技术有限公司 | Data base authority management method and equipment |
| CN108830101A (en) * | 2018-06-04 | 2018-11-16 | 北京奇虎科技有限公司 | Application permission configuration method and device based on tables of data |
| CN108804944A (en) * | 2018-06-04 | 2018-11-13 | 北京奇虎科技有限公司 | Access authorization for resource configuration method based on tables of data and device |
| CN110399747A (en) * | 2019-07-18 | 2019-11-01 | 佳都新太科技股份有限公司 | A kind of user right correlating method, querying method and device |
| CN110704872A (en) * | 2019-09-24 | 2020-01-17 | 天津卓朗科技发展有限公司 | Data query method and device, electronic equipment and computer readable storage medium |
| CN110704833A (en) * | 2019-10-10 | 2020-01-17 | 北京字节跳动网络技术有限公司 | Data permission configuration method, device, electronic device and storage medium |
| CN110795485A (en) * | 2019-10-29 | 2020-02-14 | 杭州求是优脉科技有限公司 | Database access method, device and equipment |
| CN111177671A (en) * | 2019-12-16 | 2020-05-19 | 北京淇瑀信息科技有限公司 | Data management platform and method and electronic equipment |
| CN111177789A (en) * | 2020-01-07 | 2020-05-19 | 江苏满运软件科技有限公司 | Authority management method, system, device and storage medium |
Non-Patent Citations (4)
| Title |
|---|
| JAYAPANDIAN M 等: "Automated creation of a forms-based database query interface", PROCEEDINGS OF THE VLDB ENDOWMENT, vol. 1, no. 1, pages 695 - 709, XP058376001, DOI: 10.14778/1453856.1453932 * |
| 申宝成 等: "加强数据库应用安全的权限分级方法及应用", 太原重型机械学院学报, no. 02, pages 162 - 165 * |
| 申彦: "大规模数据集高效数据挖掘算法研究", 中国博士学位论文全文数据库信息科技辑, no. 08, pages 138 - 159 * |
| 邓庆彬: "ESB数据操纵控制器的设计与实现", 中国优秀硕士学位论文全文数据库信息科技辑, no. 01, pages 139 - 159 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112699146A (en) * | 2020-12-31 | 2021-04-23 | 新奥数能科技有限公司 | Data pushing method and device based on general information model, server and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111737291B (en) | 2023-07-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10735551B2 (en) | Method and system for generating behavior profiles for device members of a network | |
| US10637888B2 (en) | Automated lifecycle system operations for threat mitigation | |
| US11848966B2 (en) | Parametric analysis of integrated operational technology systems and information technology systems | |
| US20220078210A1 (en) | System and method for collaborative cybersecurity defensive strategy analysis utilizing virtual network spaces | |
| CN105009131B (en) | Promote the multilayer authentication method communicated between intelligent home equipment and server based on cloud | |
| CN101090402B (en) | Thin client system using session managing server and session managing method | |
| EP2987090B1 (en) | Distributed event correlation system | |
| CN107733863B (en) | Log debugging method and device under distributed hadoop environment | |
| WO2019210484A1 (en) | Analysis device, method and system for operational technology system and storage medium | |
| KR101814544B1 (en) | Methods and systems for remote management of security systems | |
| WO2015100278A1 (en) | System and method for automotive diagnostic tool data collection and analysis | |
| CN104813685A (en) | Subscription-notification mechanisms for synchronization of distributed states | |
| CN109086182A (en) | The method and terminal device of database auto-alarming | |
| EP1999625A2 (en) | Auto-detection capabilities for out of the box experience | |
| CN103516701A (en) | Data processing method and password management system | |
| EP3667526B1 (en) | Rapid file authentication on automation devices | |
| CN111737291B (en) | Method, device and database for inquiring equipment information | |
| CN101821748A (en) | Device data management system | |
| Hansson et al. | Analyzing Internet-connected industrial equipment | |
| CN116668259A (en) | Method and apparatus for detecting anomalies in infrastructure in a network | |
| Iskhakova et al. | Automatic search of the malicious messages in the internet of things systems on the example of an intelligent detection of the unnatural agents requests | |
| US10063664B2 (en) | Network system and control device | |
| CN114499964B (en) | Equipment control method and device, storage medium and electronic device | |
| CN104618190A (en) | Shell-based network bandwidth testing method under cluster environment | |
| Lo et al. | Design of a Cloud-based Service Platform for the IoT. |
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 |