CN111737291B - Method, device and database for inquiring equipment information - Google Patents
Method, device and database for inquiring equipment information Download PDFInfo
- Publication number
- CN111737291B CN111737291B CN202010531434.XA CN202010531434A CN111737291B CN 111737291 B CN111737291 B CN 111737291B CN 202010531434 A CN202010531434 A CN 202010531434A CN 111737291 B CN111737291 B CN 111737291B
- Authority
- CN
- China
- Prior art keywords
- data
- information
- equipment
- attribute
- 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.)
- Active
Links
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 querying the device information comprises the following steps: the server obtains the equipment attribute and the query interface of the pre-established setting data, and queries the equipment attribute value at the query interface of the setting data according to the equipment attribute, wherein the setting data is stored in a part of data table of the database, the part of data table corresponds to the authority of the authorized user, and the data table comprises the equipment attribute and the corresponding equipment attribute value. The method for inquiring the equipment information can reduce the time consumption of the inquiring 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, for example, to a method, an apparatus, and a database for querying device information.
Background
Currently, most products for querying data can query device data one-to-one, i.e., only one type of data of one device at a time. However, in practical application, a large amount of data is often required to be queried, in order to realize the query of batch data, in the prior art, a plurality of query instructions are combined into a query form, the query form is sent, after the server receives the query form, each query instruction is split, and the query instructions are sequentially queried in a database according to each query instruction, and then a query result is returned.
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, and is intended to neither identify key/critical elements nor delineate the scope of such embodiments, but is intended as a prelude to the more detailed description that follows.
The embodiment of the disclosure provides a method, a device and a database for inquiring equipment information, which are used for solving the technical problems of long time consumption and poor real-time performance in the process of inquiring batch information.
In some alternative embodiments, the method for querying device information is applied to a server, and the method for querying device information includes:
a query interface for obtaining equipment attributes and pre-created setting data;
inquiring the equipment attribute value at an inquiring interface of the set data according to the equipment attribute;
the setting data are stored in a part of data table of a database, the part of data table corresponds to the authority of the authorized user, and the data table comprises the equipment attribute and the corresponding equipment attribute value.
Optionally, the query interface of the setting data is created by:
obtaining the authority of an authorized user;
matching each authority of the authorized user with the description information of the data structure, and determining the setting data;
establishing a query interface;
establishing a mapping relation between the query interface and the setting data;
and setting a preset query rule of the query interface.
Optionally, obtaining the authority 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 or not;
and inquiring the authority of the authorized user in a setting interface according to the user information under the condition that the user information is the authorized user information.
Optionally, querying the device attribute value at the query interface of the setting data according to the device attribute includes:
adjusting the equipment attribute to a preset query structure; wherein, the preset query structure is adapted to a preset query rule of a query interface of the set data;
and inquiring the equipment attribute value at an inquiry interface of the set data according to the preset inquiry structure.
Optionally, obtaining the device attribute includes:
Obtaining a device identification number (Identity document, ID);
and reading the equipment attribute according to the equipment ID.
Optionally, reading the device attribute according to the device ID includes:
reading the device attributes in a remote dictionary service (Remote Dictionary Server, redis) according to the device ID;
and under the condition that the equipment attribute cannot be successfully read in the Redis, the equipment attribute is read in a database according to the equipment ID.
In some alternative embodiments, a method for querying device information is applied to a terminal, the method for querying device information including:
transmitting the device ID to the server; wherein, the device ID is used for inquiring the device attribute;
receiving an equipment attribute value sent by a server; the device attribute values are inquired at an inquiry interface of set data according to the device attributes, the set data are stored in partial data tables of a database, the partial data tables correspond to the authority of an authorized user, and the data tables comprise the device attributes and the corresponding device attribute values;
and displaying the device 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;
transmitting the user information to the server; the user information is used for judging whether the current user has the right to access the data or not.
In some alternative embodiments, the database for storing device information includes:
a configuration structure module configured to generate a query interface for setting data;
the data structure module stores setting data, wherein the setting data comprises equipment attributes and corresponding equipment attribute values.
Optionally, the database for storing device information further includes:
the authorization structure module stores user rights and corresponding authorization data structures;
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 further configured to determine all authorization data corresponding to the specific user rights as setting data.
In some optional embodiments, the means for querying device information is applied to a server, and the means for querying device information includes:
the first obtaining module is configured to obtain a query interface of the device attribute and the pre-created setting data;
the query module is configured to query the device attribute value at a query interface of the set data according to the device attribute;
The setting data are stored in a part of data table of a database, the part of data table corresponds to the authority of the authorized user, and the data table comprises the equipment attribute and the corresponding equipment attribute value.
Optionally, the first obtaining module includes:
a first obtaining unit configured to obtain rights of an authorized user;
the matching unit is configured to match each authority of the authorized user with the description information of the data structure and determine the setting data;
a first creation unit configured to create a query interface;
the second creation unit is configured to create a mapping relation between the query interface and the setting data;
and the setting unit is configured to set preset query rules 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 or not;
and inquiring the authority of the authorized user in a setting interface according to the user information under the condition that the user information is the authorized user information.
Optionally, the query module includes:
an adjusting unit configured to adjust the device attribute to a preset query structure; wherein, the preset query structure is adapted to a preset query rule of a query interface of the set data;
And the query unit is configured to query the device attribute value at a query interface of the setting data according to the preset query structure.
Optionally, the first obtaining module includes:
a second obtaining unit configured to obtain a device ID;
and a reading unit configured to read the device attribute according to the device ID.
Optionally, the reading unit is specifically configured to:
reading the equipment attribute in Redis according to the equipment ID;
and under the condition that the equipment attribute cannot be successfully read in the Redis, the equipment attribute is read in a database according to the equipment ID.
In some alternative embodiments, the means for querying device information is applied to a terminal, and the means for querying device information includes:
a first transmission 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 at an inquiry interface of set data according to the device attribute, the set data is stored in a part of data table of a database, the part of data table corresponds to the authority of an authorized user, and the data table comprises the device attribute and the corresponding device attribute value;
And a display module configured to display the device attribute values.
Optionally, the apparatus for querying device information further includes:
the second obtaining module is configured to obtain user information before receiving the device attribute value sent by the server;
a second transmission module configured to transmit the user information to the server; the user information is used for judging whether the current user has the right to access the data or not.
The method, the device and the database for inquiring the equipment information provided by the embodiment of the disclosure can realize the following technical effects:
when the device attribute value needs to be queried, the device attribute value can be obtained by querying the query interface of the set data according to the device attribute only by accessing the data table storing the set data, and the time consumption of the query process is reduced without accessing all databases.
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 by way of example and not limitation in the figures of the accompanying drawings, in which like references indicate similar elements, and in which:
FIG. 1 is an environmental schematic 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 provided by an embodiment of the present disclosure;
FIG. 3 is a schematic diagram of a query interface for creating settings data provided by an embodiment of the present disclosure;
FIG. 4 is a schematic diagram of one embodiment of the present disclosure for obtaining rights of an authorized user;
FIG. 5 is a schematic diagram of a query interface for querying device attribute values at a query interface for setup data provided by an embodiment of the present disclosure;
FIG. 6 is a schematic diagram of a method for querying device information provided by an embodiment of the present disclosure;
FIG. 7 is a schematic diagram of a method for querying device information provided by an embodiment of the present disclosure;
FIG. 8 is a schematic diagram of a method for querying device information provided by an embodiment of the present disclosure;
FIG. 9 is a schematic diagram of a method for querying device information provided by 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 provided by an embodiment of the present disclosure;
FIG. 11b is a schematic diagram of an apparatus for querying device information provided by an embodiment of the present disclosure;
FIG. 11c is a schematic diagram of an apparatus for querying device information provided by an embodiment of the present disclosure;
FIG. 11d is a schematic diagram of an apparatus for querying device information provided by an embodiment of the present disclosure;
FIG. 12a is a schematic diagram of an apparatus for querying device information provided by an embodiment of the present disclosure;
FIG. 12b is a schematic diagram of an apparatus for querying device information provided by 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 techniques of the disclosed embodiments can be understood in more detail, a more particular description of the embodiments of the disclosure, briefly summarized below, may be had by reference to the appended drawings, which are not intended to be limiting of the embodiments of the disclosure. 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 still be practiced without these details. In other instances, well-known structures and devices may be shown simplified in order to simplify the drawing.
The terms first, second and the like in the description and in the claims of the embodiments of the disclosure and in the above-described figures are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate in order to describe embodiments of the present disclosure. Furthermore, the terms "comprise" and "have," as well as any variations thereof, are intended to cover a non-exclusive inclusion.
The term "plurality" means two or more, unless otherwise indicated.
In the embodiment of the present disclosure, the character "/" indicates that the front and rear objects are an or relationship. For example, A/B represents: a or B.
The term "and/or" is an associative relationship that describes an object, meaning that there may be three relationships. For example, a and/or B, represent: a or B, or, A and B.
Currently, most products for querying data can query device data one-to-one, i.e., only one type of data of one device at a time. In the embodiment of the disclosure, in order to realize batch inquiry of equipment information, a terminal sends an equipment ID to a server, the server obtains equipment attribute according to the equipment ID, and the equipment attribute value is inquired in batch in one time in an inquiry interface of set data according to the equipment attribute, so that a plurality of messages of the equipment can be obtained by only executing an inquiry instruction once, and the equipment attribute value is not required to be inquired one by one, thereby reducing the times of executing the inquiry instruction, reducing inquiry time and improving the instantaneity of the batch information inquiry process.
Referring to fig. 1, an embodiment of the present disclosure provides an environmental schematic of an actual environment involved in a method for querying device information. 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, a Ultra mobile personal computer (Ultra-mobile Personal Computer, UMPC), a netbook, a personal digital assistant (Personal Digital Assistant, PDA), or the like, but is not limited thereto. The 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 server, or a server cluster composed of several servers, or a distributed server composed of several servers.
In some implementations, the server 120 is a distributed server, and the deployment of the server 120 conforms to the principles of service concurrency, service classification, service based authorization and service extension. Service Nodes (Nodes) are distributed on the user side and the equipment side, and the Nodes respond to real-time service requests through a reliable coordination system (ZooKeeper) of the distributed system.
As shown in connection with fig. 2, an embodiment of the present disclosure provides a method for querying device information. This embodiment is exemplified by the application of the method for querying device information to the server shown in fig. 1. The method for querying the device information comprises the following steps:
s201, obtaining a query interface of the device attribute and the pre-created setting data.
Wherein the device attributes refer to attributes of the device that can be recorded with data. 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: one or more of equipment offline time, equipment installation time, first binding time, equipment installation address, equipment production factory, equipment accumulated online time, equipment startup time, equipment accumulated running time, equipment accumulated fault alarm times, user ID, user last login time and user last login terminal name.
The plant operating curve is a curve of the time-dependent change of a particular environmental variable that the plant can adjust. For example, the air conditioner may adjust the indoor temperature, and the device operating curve may include a curve of the indoor temperature over time; the refrigerator may adjust the refrigerating chamber temperature and the freezing chamber temperature, and the apparatus operation curve may include a curve of a temperature of the refrigerating chamber with time or a curve of a temperature of the freezing chamber with time.
The real-time state of the device is the real-time running state of each actuator in the device, such as the real-time running state of a buzzer, or the real-time running state of a refrigerator/air conditioner compressor, or the opening and closing state of a device door.
The device failure may include a failure code, a failure description, and a failure occurrence time.
The device attributes may be received directly, e.g., the terminal sends the device attributes directly to the server, which obtains the device attributes directly.
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 device ID to the server, namely, the user only needs to select/input the device ID in the terminal, the service can obtain all the device attribute values, 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 case that the device attribute cannot be successfully read in the Redis, the device attribute is read in the database according to the device ID. The equipment attribute is read in Redis, so that the reading speed can be improved, the time consumption for inquiring the equipment batch information is further shortened, and the real-time property of inquiring the batch information is improved.
Correspondingly, in the case that 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. And the next reading is convenient.
Optionally, the setting data includes one or more of equipment detail data, equipment operating curve data, equipment real-time status data, and equipment fault data.
The query interface for setting data may be obtained by: determining a query interface of setting data corresponding to the equipment ID according to the equipment ID; or obtaining the user information, and determining a 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 created, and then equipment attributes and the inquiry interface for setting data are obtained; when the user logs in for no first time and inquires the equipment information, the equipment attribute is obtained and the inquiry interface of the setting data is directly inquired.
In some practical applications, when the authority of the authorized user changes, the query interface of the setting data is recreated, and then the device attribute and the query interface of the setting data are obtained.
In some practical applications, the server is a distributed server, for example, an open-element distributed service framework Dubbo server deployed by multiple machines, and the query interface for setting data may be a remote procedure call (Remote Procedure Call, RPC) interface. Service concurrency can also be achieved with a multi-machine deployed Dubbo server.
S202, inquiring the device attribute value at an inquiring interface of the set data according to the device attribute.
The setting data are stored in a part of data table of the database, the part of data table corresponds to the authority of the authorized user, namely, the part of data table is the data table with the access authority of the authorized user in the database, and the data table comprises equipment attributes and corresponding equipment attribute values.
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 operating curve values, device real-time status values, and device fault values.
The device detail values may include: 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 length value, a device startup time length value, a device accumulated running time length value, a device accumulated fault 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 value is a time-dependent value of a particular environmental variable that the plant can adjust. For example, the air conditioner may adjust the indoor temperature, and the device operating curve value may include an indoor temperature value that varies with time; the refrigerator may adjust the refrigerating chamber temperature and the freezing chamber temperature, and the appliance operation curve may include a refrigerating chamber temperature value or a freezing chamber temperature value that varies with time.
The real-time status value of the device comprises a real-time running status value of the buzzer, or a real-time running status value of the refrigerator/air conditioner compressor, or a switching status value of the device door.
The device fault values may include fault code values, fault description values, and fault time-to-occurrence values. Wherein the fault code value and the fault description value are predefined and correspond to each other one by one. 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 a power supply overvoltage/low voltage protection alarm and a leakage alarm; or, the abnormal alarm of the compressor and the abnormal alarm of the fan; or the alarm of too high/too low ambient temperature and the alarm of too 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 equipment attribute value. In some implementations, the query interface may dynamically invoke the settings data.
When the device attribute value needs to be queried, the device attribute value can be obtained by querying the query interface of the set data according to the device attribute only by accessing the data table storing the set data, and the time consumption of the query process is reduced without accessing all databases.
In some application scenarios, when a plurality of terminals send a plurality of inquiry instructions to a server, the server obtains the priority of each terminal and the priority of each inquiry service, and provides the inquiry service with a high priority to the terminal with a high priority.
Referring to fig. 3, the query interface for setting data is created by:
s301, obtaining the authority of the authorized user.
The authority refers to the authority of a user to access data (attribute values of all devices), and the data security is improved by setting the access authority of the data.
The rights may include: one or more of a device that is allowed access, a data attribute of the device that is allowed access, and a time period that is allowed access. For example, allowing a first user to access the a device and the B device, not allowing the first user to access the C device, allowing a second user to access the B device and the C device, not allowing the second user to access the a device; or allowing the first user to access the equipment details of the A equipment, not allowing the first user to access the equipment running curve, the equipment real-time state and the equipment failure of the A equipment, allowing the second user to access the equipment details of the A equipment and the equipment failure, and not allowing the second user to access the equipment running curve and the equipment real-time state of the A equipment; alternatively, the first user is allowed to access the device attribute value of the a device for approximately one week, and the second user is allowed to access the device attribute value of the a device for approximately half a month.
The authority of the authorized user can be directly sent to the server through the terminal;
or the terminal sends the 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, the description information of each authority of the authorized user and the data structure is matched, and setting data are determined.
The description information of the data structure includes device membership information of the stored data in the data table, attribute information of the stored data, and time information of the stored data.
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 the authorized data, and the authorized data is the setting 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 manages description information of all openable data, and externally exposes an open data structure RPC interface. The description information of all the data structures can be queried through the data structure RPC interface.
The server reads the device attributes through the device ID and can obtain all the device attributes. One user is often only allowed to access the attribute values of part of the device attributes, i.e. the setting data comprises part of the device attributes and their corresponding device attribute values. The device attribute values obtained by inquiring the inquiry interface of the setting data according to the device attributes are only the device attribute values (not all the attribute values corresponding to the device attributes) which the user is authorized to access. In the process of obtaining the equipment attribute value, the terminal sends the equipment ID to the server, and the server can return the equipment attribute value accessible to the user to the terminal, so that obviously, the 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 use experience of the user is improved.
S303, establishing a query interface.
For example, a variable is created that represents the query interface.
S304, establishing a mapping relation between the query interface and the setting data.
For example, a uniform resource locator (Uniform Resource Locator, URL) of the binding setting data and the aforementioned one variable.
S305, setting preset query rules of a query interface.
For example, request type, entry parameters, and return parameters of the query interface are set. The request type comprises GET or POST, the entry parameter comprises one or more device attributes, and the return parameter comprises device attribute values corresponding to the one or more device attributes (entry parameter).
In order to improve data security, access rights are generally set in a database. In the step, the data tables for storing the setting data are all setting data accessible to the authorized user, so that the authorized user can conveniently read the setting data in batches, the time consumption for inquiring batch information is further reduced, and the instantaneity for inquiring batch information is improved.
In some practical application scenarios, there are multiple device attributes, and the device attribute values of different user requirements are different. For example, the device attributes include a, b, and c, the first user only needs a value, and the second user only needs 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 part of the maximum rights of the authorized user. For example, in theory, the first user can access a and b, but in the use process, the first user can only access a, and then the maximum authority of the first user is that the first user can access a and b, and in the actual application process, the authority of the first user is that the first user can access a and b, and the first user can not access b; in theory, the second user can access a, b and c, in practical application, the second user can only access b and c, and then the maximum authority of the second user can access a, b and c, and in practical application, the authority of the second user can access b and c. By setting the authority of the first user, the value returned to the first user only comprises an a value (not comprises a b value and a c value); 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 (excluding the a value), so that the authority of the user is set, the data security can be improved, the query results meeting the user requirements can be configured for different users, all equipment attribute values are not required to be transmitted, and the use experience of the user is improved; and simultaneously, the network consumption is reduced.
As shown in connection with fig. 4, obtaining the rights 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 inquiry request sent by the terminal to the server comprises the user information, and the server analyzes the user information after receiving the inquiry request.
Before the user is authorized, the user information includes a user password, or the user password and the user ID, the terminal transmits the user information to the server, and the server receives the user information. Optionally, the terminal sends the user information to the server through an authentication interface. For example, in a distributed server, the terminal sends user information to the server through an authentication RPC interface.
After the user is authorized, the user information comprises a user password or a user ID or both the user password and the user ID, the server reads a query request sent by the terminal, and the user information is analyzed in the query request.
S402, matching user information in an authorized user list, and judging whether the user information is authorized user information.
The authorized user list stores authorized user information, and if the authorized user information is successfully matched with the user information in the authorized user list, the user information is the authorized user information; if the user information cannot be matched in the authorized user list, the user information is unauthorized user information.
S403, inquiring the authority of the authorized user in the setting interface according to the user information under the condition that the user information is the authorized user information.
The setting interface exposes the authority of a single user, and the authority of the 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, referring to a device attribute value at a query interface of setting data according to a device attribute includes:
s501, adjusting the device attribute to a preset query structure.
The preset query structure is adapted to a preset query rule of a query interface of the set data.
The preset query structure comprises one or more conditions, and each data 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, wherein the query mode can be fuzzy query or ordered query, and the query condition can be time screening or upper and lower limit screening, and the like.
S502, inquiring the attribute value of the equipment at an inquiry interface of the set data according to a preset inquiry structure.
After receiving a query instruction of a preset query structure, the set data query interface returns a query result corresponding to the query instruction.
Through the steps, a plurality of pieces of information corresponding to the device attributes can be obtained.
As shown in connection with 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 illustration. The method for querying the device information comprises the following steps:
s601, sending a device ID to a server; wherein the device ID is used to query the device attributes.
Wherein the device ID comprises a device number or a device media access control address (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 can read the device attribute in Redis according to the device ID; in case that the device attribute cannot be successfully read in the Redis, the device attribute is read in the database according to the device ID.
The device attribute refers to an attribute of the device in 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.
S602, receiving the device attribute value sent by the server.
The device attribute value is queried according to the device attribute at a query interface of the setting data, the setting data comprises a part of data table stored in a database, and the setting data comprises the device attribute and the corresponding device attribute value.
The device attribute refers to an attribute of the device in 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: one or more of equipment offline time, equipment installation time, first binding time, equipment installation address, equipment production factory, equipment accumulated online time, equipment startup time, equipment accumulated running time, equipment accumulated fault alarm times, user ID, user last login time and user last login terminal name.
The plant operating curve is a curve of the time-dependent change of a particular environmental variable that the plant can adjust. For example, the air conditioner may adjust the indoor temperature, and the device operating curve may include a curve of the indoor temperature over time; the refrigerator may adjust the refrigerating chamber temperature and the freezing chamber temperature, and the apparatus operation curve may include a curve of a temperature of the refrigerating chamber with time or a curve of a temperature of the freezing chamber with time.
The real-time state of the device is the real-time running state of each actuator in the device, such as the real-time running state of a buzzer, or the real-time running state of a refrigerator/air conditioner compressor, or the opening and closing state of a device door.
The device failure may include a failure code, a failure description, and a failure occurrence time.
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 operating curve values, device real-time status values, and device fault values.
The device detail values may include: 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 length value, a device startup time length value, a device accumulated running time length value, a device accumulated fault 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 value is a time-dependent value of a particular environmental variable that the plant can adjust. For example, the air conditioner may adjust the indoor temperature, and the device operating curve value may include an indoor temperature value that varies with time; the refrigerator may adjust the refrigerating chamber temperature and the freezing chamber temperature, and the appliance operation curve may include a refrigerating chamber temperature value or a freezing chamber temperature value that varies with time.
The real-time status value of the device comprises a real-time running status value of the buzzer, or a real-time running status value of the refrigerator/air conditioner compressor, or a switching status value of the device door.
The device fault values may include fault code values, fault description values, and fault time-to-occurrence values. Wherein the fault code value and the fault description value are predefined and correspond to each other one by one. 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 a power supply overvoltage/low voltage protection alarm and a leakage alarm; or, the abnormal alarm of the compressor and the abnormal alarm of the fan; or the alarm of too high/too low ambient temperature and the alarm of too 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 the screening time period and sending the screening time period to the server.
In some application scenarios, the terminal includes a touch screen, a user inputs a 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), and the user inputs the screening period through the input device, and the terminal reads the operation of the input device by the user to obtain the screening period.
S603, displaying the attribute value of the equipment.
The terminal displays the device attribute values in the form of a table, for example, the terminal displays the device details, the device implementation state information, and the device failure in the form of a table.
Alternatively, the terminal displays the device attribute values in the form of a curve, e.g., the terminal displays a device operating curve.
When the device attribute value needs to be queried, the device attribute value can be obtained by querying the query interface of the set data according to the device attribute only by accessing the data table storing the set data, and the time consumption of the query process is reduced without accessing all databases.
As shown in connection with fig. 7, before receiving the device attribute value sent by the server, the method for querying the device information further includes:
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 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), through which a user inputs user information, and the terminal reads the operation of the input device by the user to obtain the user information.
S702, user information is sent to a server.
The server can judge whether the current user has the authority to access the data according to the user information. The data security is improved.
As shown in connection with fig. 8, an embodiment of the present disclosure provides a method for querying device information. The method for querying the device information is illustrated in the embodiment in terms of information interaction between the terminal and the server. The method for querying the device information comprises the following steps:
s801, a terminal sends a device ID to a server;
s802, the server obtains equipment attributes according to the equipment ID;
s803, a server obtains a query interface of the setting data;
s804, the server queries the device attribute value at a query interface of the set data according to the device attribute;
s805, the terminal receives the equipment attribute value sent by the server;
s806, the terminal displays the attribute value of the equipment.
As shown in connection with fig. 9, an embodiment of the present disclosure provides a method for querying device information. The method for querying the device information is illustrated in the embodiment in terms of information interaction between the terminal and the server. The method for querying the device information comprises the following steps:
S901, a terminal obtains user information;
s902, the terminal sends user information to a server;
s903, the server matches the user information in an authorized user list and judges whether the user information is authorized user information;
s904, the terminal sends a device ID to the server under the condition that the user information is authorized user information;
s905, the server obtains the equipment attribute according to the equipment ID;
s906, a server obtains a query interface of setting data;
s907, the server queries the device attribute value at a query interface of the set data according to the device attribute;
s908, the terminal receives the equipment attribute value sent by the server;
s909, the terminal displays the device attribute value.
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, and the user clicks to confirm, the interface displays one or more of device details, operation curves, real-time status, and fault pushing.
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 to generate a query interface for setting data; the data structure module 1002 stores setting data, which includes device attributes and their corresponding device attribute values.
In the database, the equipment attribute and the corresponding equipment attribute value are used as independent modules with query interfaces, so that the set data can be conveniently and independently accessed, when the equipment attribute value needs to be queried, the query is performed on the query interfaces of the set data according to the equipment attribute, and the equipment attribute value can be obtained by only accessing the data table storing the set data without accessing all the databases, so that 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 user rights and corresponding authorization data structures; the data structure module 1002 stores authorization data, and the authorization data structure has a mapping relationship with the authorization data; 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 on different servers.
The configuration structure module 1001 may store data through a relational table, for example, using a KeyValue structure or a Json structure. Configuration structure module 1001 may also include Redis.
The data structure module 1002 may store data through a relational table, for example, using a KeyValue structure or a Json structure. The data structure module 1002 may also include a Redis.
The grant structure module 1003 can store data through a relational table, for example, using a KeyValue structure or a Json structure. Authorization structure module 1003 may also include Redis.
In some embodiments, the database for storing device information further includes an active management module in which interface access records, authorization monitors, and call delays are stored.
Optionally, the database for storing device information also includes a Cache module, which is connected to the configuration structure module 1001 and the 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, so that the pressure of the database can be reduced.
As shown in connection with fig. 11a, an embodiment of the present disclosure provides an apparatus for querying device information. The means for querying device information may be implemented in 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 to obtain a query interface of device attributes and pre-created setting data; the query module 1120 is configured to query the device attribute value at a query interface of the setting data according to the device attribute, the setting data is stored in a part of a data table of the database, the part of the data table corresponds to the authority of the authorized user, and the data table includes the device attribute and the corresponding device attribute value.
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 rights of an authorized user; the matching unit 1112 is configured to match each authority of the authorized user with the description information of the data structure, and determine setting data; the first creation unit 1113 is configured to create a query interface; the second creating unit 1114 is configured to create 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 or not;
and inquiring the authority of the authorized user at the setting interface according to the user information under the condition that the user information is the authorized user information.
Referring to 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 setting data; the query 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 includes a second obtaining unit 1114 and a reading unit 1115, wherein the second obtaining unit 1114 is configured to obtain a 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 case that the device attribute cannot be successfully read in the Redis, the device attribute is read in the database according to the device ID.
As shown in connection with fig. 12a, an embodiment of the present disclosure provides an apparatus for querying device information. The means for querying device information may be implemented in software, hardware or a combination of both in all or part of the terminal shown in fig. 1. 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; wherein, the device ID is used for inquiring the device attribute; the first receiving module 1220 is configured to receive the device attribute value sent by the server; the device attribute values are inquired at an inquiry interface of set data according to the device attributes, the set data are stored in partial data tables of a database, the partial data tables correspond to the authority of an authorized user, and the data tables comprise the device attributes and the corresponding device attribute values; the display module 1230 is configured to display device attribute values.
As shown in connection with fig. 12b, the apparatus for querying device information further comprises a second obtaining module 1240 and a second transmitting module 1250, wherein the second obtaining module 1240 is configured to obtain user information before receiving the device attribute values transmitted 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 right to access the data or not.
Optionally, the second obtaining module 1240 is further configured to obtain a screening period; the second transmitting module 1250 is further configured to transmit 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 perform the method for querying device information provided by the previous embodiments when the program instructions are executed.
As shown in connection with fig. 13, an embodiment of the present disclosure provides an apparatus for querying device information. The apparatus for querying device information includes:
a processor (processor) 131 and a memory (memory) 132, and may also include a communication interface (Communication Interface) 133 and a bus 134. The processor 131, the communication interface 133, and the memory 132 may communicate with each other via the bus 134. The communication interface 133 may be used for information transfer. The processor 131 may invoke logic instructions in the memory 132 to perform the method for querying device information provided by the previous embodiments.
Further, the logic instructions in the memory 132 described above may be implemented in the form of 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 that may be used to store a software program, a computer-executable program, and program instructions/modules corresponding to the methods in the embodiments of the present disclosure. The processor 131 executes functional applications and data processing by running software programs, instructions and modules stored in the memory 132, i.e. implements the methods in the method embodiments described above.
The memory 132 may include a storage program area that may store an operating system, at least one application program required for functions, and a storage data area; the storage data area may store data created according to the use of the terminal device, etc. In addition, memory 132 may include high-speed random access memory, and may also include non-volatile memory.
The disclosed embodiments provide a storage medium storing computer-executable instructions configured to perform the method for querying device information provided by the foregoing embodiments.
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 which, when executed by a computer, cause the computer to perform the method for querying device information provided by the previous embodiments.
The computer readable storage medium may be a transitory computer readable storage medium or a non-transitory computer readable storage medium.
The aspects of the disclosed embodiments may be embodied in a software product stored on a storage medium, including one or more instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of a method in an embodiment of the disclosure. And the aforementioned storage medium may be a non-transitory storage medium including: a plurality of media capable of storing program codes, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (Random Access Memory, RAM), a magnetic disk, or an optical disk, or a transitory storage medium.
The above description and the drawings illustrate embodiments of the disclosure sufficiently to enable those skilled in the art to practice them. Other embodiments may involve structural, logical, electrical, process, and other changes. The embodiments represent only 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. Moreover, the terminology used in the present application is for the purpose of describing embodiments only and is not intended to limit the claims. As used in the description of the embodiments and the claims, the singular forms "a," "an," and "the" (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, when used in this application, the terms "comprises," "comprising," and/or "includes," and variations thereof, mean that the stated features, integers, steps, operations, elements, and/or components are present, but that the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof is not precluded. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method or apparatus comprising such elements. In this context, each embodiment may be described with emphasis on the differences from the other embodiments, and the same similar parts between the various embodiments may be referred to each other. For the methods, products, etc. disclosed in the embodiments, if they correspond to the method sections disclosed in the embodiments, the description of the method sections may be referred to for relevance.
Those of skill in the art will 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 depends upon the particular application and design constraints imposed on the solution. The skilled person may use different methods for each particular application to achieve the described functionality, but such implementation should not be considered to be beyond the scope of the embodiments of the present disclosure. It will be clearly understood by those skilled in the art that, for convenience and brevity of description, specific working procedures of the above-described systems, apparatuses and units may refer to corresponding procedures in the foregoing method embodiments, which are not described herein again.
In the embodiments disclosed herein, the disclosed methods, articles of manufacture (including but not limited to devices, apparatuses, etc.) may be practiced in other ways. For example, the apparatus embodiments described above are merely illustrative, e.g., the division of elements may be merely a logical functional division, and there may be additional divisions when actually implemented, e.g., multiple elements or components may be combined or integrated into another system, or some features may be omitted or not performed. In addition, the coupling or direct coupling or communication connection shown or discussed with each other may be through some interface, device or unit indirect coupling or communication connection, which may be in electrical, mechanical or other form. The units described as separate units may or may not be physically separate, and units shown as units may or may not be physical units, may be located in one place, or may be distributed over a plurality of network units. Some or all of the units may be selected according to actual needs to implement the present embodiment. In addition, each functional unit in the embodiments of the present disclosure may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit.
The flowcharts 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 illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
Claims (10)
1. A method for querying device information, applied to a server, comprising:
a query interface for obtaining equipment attributes and pre-created setting data; the query interface of the setting data is created by: obtaining the authority of an authorized user; matching each authority of the authorized user with the description information of the data structure, and determining the setting data; establishing a query interface; establishing a mapping relation between the query interface and the setting data; setting a preset query rule of the query interface; the description information of the data structure comprises equipment membership information of the stored data in the data table, attribute information of the stored data and time information of the stored data;
Inquiring the equipment attribute value at an inquiring interface of the set data according to the equipment attribute;
the setting data are stored in a part of data table of a database, the part of data table corresponds to the authority of the authorized user, and the data table comprises the equipment attribute and the corresponding equipment attribute value.
2. The method of claim 1, 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 or not;
and inquiring the authority of the authorized user in a setting interface according to the user information under the condition that the user information is the authorized user information.
3. The method of claim 1, wherein querying the device attribute value at the query interface of the setup data based on the device attribute comprises:
adjusting the equipment attribute to a preset query structure; wherein, the preset query structure is adapted to a preset query rule of a query interface of the set data;
and inquiring the equipment attribute value at an inquiry interface of the set data according to the preset inquiry structure.
4. A method according to any one of claims 1 to 3, wherein obtaining device attributes comprises:
obtaining a device ID;
and reading the equipment attribute according to the equipment ID.
5. The method of claim 4, wherein reading the device attribute from the device ID comprises:
reading the equipment attribute in Redis according to the equipment ID;
and under the condition that the equipment attribute cannot be successfully read in the Redis, the equipment attribute is read in a database according to the equipment ID.
6. A method for querying device information, applied to a terminal, the method comprising:
transmitting the device ID to the server; wherein, the device ID is used for inquiring the device attribute;
receiving an equipment attribute value sent by a server; the device attribute values are inquired at an inquiry interface of set data according to the device attributes, the set data are stored in partial data tables of a database, the partial data tables correspond to the authority of an authorized user, and the data tables comprise the device attributes and the corresponding device attribute values; the query interface of the setting data is created by: obtaining the authority of an authorized user; matching each authority of the authorized user with the description information of the data structure, and determining the setting data; establishing a query interface; establishing a mapping relation between the query interface and the setting data; setting a preset query rule of the query interface; the description information of the data structure comprises equipment membership information of the stored data in the data table, attribute information of the stored data and time information of the stored data;
And displaying the device attribute value.
7. A database for storing device information, comprising:
a configuration structure module configured to generate a query interface for setting data; the query interface of the setting data is created by: obtaining the authority of an authorized user; matching each authority of the authorized user with the description information of the data structure, and determining the setting data; establishing a query interface; establishing a mapping relation between the query interface and the setting data; setting a preset query rule of the query interface; the description information of the data structure comprises equipment membership information of the stored data in the data table, attribute information of the stored data and time information of the stored data;
the data structure module stores setting data, wherein the setting data comprises equipment attributes and corresponding equipment attribute values.
8. The database of claim 7, further comprising:
the authorization structure module stores user rights and corresponding authorization data structures;
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 further configured to determine all authorization data corresponding to the specific user rights as setting data.
9. An apparatus for querying device information, for use with a server, the apparatus comprising:
the first obtaining module is configured to obtain a query interface of the device attribute and the pre-created setting data; the query interface of the setting data is created by: obtaining the authority of an authorized user; matching each authority of the authorized user with the description information of the data structure, and determining the setting data; establishing a query interface; establishing a mapping relation between the query interface and the setting data; setting a preset query rule of the query interface; the description information of the data structure comprises equipment membership information of the stored data in the data table, attribute information of the stored data and time information of the stored data;
the query module is configured to query the device attribute value at a query interface of the set data according to the device attribute;
the setting data are stored in a part of data table of a database, the part of data table corresponds to the authority of the authorized user, and the data table comprises the equipment attribute and the corresponding equipment attribute value.
10. An apparatus for querying device information, applied to a terminal, comprising:
a first transmission 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 queried at a query interface of set data according to the device attribute, the set data is stored in a part of data table of a database, the part of data table corresponds to the authority of an authorized user, and the data table comprises the device attribute and the corresponding device attribute value; the query interface of the setting data is created by: obtaining the authority of an authorized user; matching each authority of the authorized user with the description information of the data structure, and determining the setting data; establishing a query interface; establishing a mapping relation between the query interface and the setting data; setting a preset query rule of the query interface; the description information of the data structure comprises equipment membership information of the stored data in the data table, attribute information of the stored data and time information of the stored data;
And 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 CN111737291A (en) | 2020-10-02 |
| CN111737291B true 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) |
Families Citing this family (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 (13)
| 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 |
| 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 |
| 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 |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US11663647B2 (en) * | 2008-01-15 | 2023-05-30 | Sciquest, Inc. | User-specific rule-based database querying |
| US10372934B2 (en) * | 2016-07-21 | 2019-08-06 | Salesforce.Com, Inc. | Access controlled queries against user data in a datastore |
-
2020
- 2020-06-11 CN CN202010531434.XA patent/CN111737291B/en active Active
Patent Citations (13)
| 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 |
| 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 |
|---|
| Automated creation of a forms-based database query interface;Jayapandian M 等;Proceedings of the VLDB Endowment;第1卷(第1期);695-709 * |
| ESB数据操纵控制器的设计与实现;邓庆彬;中国优秀硕士学位论文全文数据库信息科技辑(第01期);I139-159 * |
| 加强数据库应用安全的权限分级方法及应用;申宝成 等;太原重型机械学院学报(第02期);162-165 * |
| 大规模数据集高效数据挖掘算法研究;申彦;中国博士学位论文全文数据库信息科技辑(第08期);I138-159 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111737291A (en) | 2020-10-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10735551B2 (en) | Method and system for generating behavior profiles for device members of a network | |
| US8738594B2 (en) | Method and system of interacting with a server, and method and system for generating and presenting search results | |
| EP3190765A1 (en) | Sensitive information processing method, device, server and security determination system | |
| CN107733863B (en) | Log debugging method and device under distributed hadoop environment | |
| WO2015100278A1 (en) | System and method for automotive diagnostic tool data collection and analysis | |
| CN104813685A (en) | Subscription-notification mechanisms for synchronization of distributed states | |
| CN107277162B (en) | Intelligent home management system and method based on network cloud | |
| CN112333290A (en) | Data access control method, device, storage medium and content distribution network system | |
| CN105991565A (en) | Reading and writing separation method and system and database agent server | |
| CN110457612B (en) | Terminal page access method and system | |
| CN102621949A (en) | Remote monitoring device and method | |
| CN111737291B (en) | Method, device and database for inquiring equipment information | |
| CN107491463B (en) | Optimization method and system for data query | |
| CN103516701A (en) | Data processing method and password management system | |
| CN111934899A (en) | Configuration method and device of user information of Internet of things and computer equipment | |
| CN112910904A (en) | Login method and device of multi-service system | |
| CN108986807A (en) | The control method and device of equipment, storage medium, electronic device | |
| CN112445873B (en) | List display processing method, related device, equipment and medium | |
| CN107205094B (en) | Control method and device, electronic equipment, the terminal of equipment | |
| CN107861958B (en) | Metadata synchronization method and device | |
| CN105354769A (en) | Data processing method and device used for power distribution network equipment | |
| CN111427972A (en) | Method and device for searching service data, service searching system and storage medium | |
| CN111597584A (en) | Privacy protection and data sharing method, device and equipment based on block chain | |
| US9276930B2 (en) | Device for controlling network user data | |
| US11621828B1 (en) | Privately querying a database with private set membership using succinct filters |
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 |