CN112527770A - Data management method and device for multi-authority escalator monitoring database - Google Patents
Data management method and device for multi-authority escalator monitoring database Download PDFInfo
- Publication number
- CN112527770A CN112527770A CN202011452520.8A CN202011452520A CN112527770A CN 112527770 A CN112527770 A CN 112527770A CN 202011452520 A CN202011452520 A CN 202011452520A CN 112527770 A CN112527770 A CN 112527770A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- escalator
- uploaded
- authority
- 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.)
- Pending
Links
- 238000012544 monitoring process Methods 0.000 title claims abstract description 40
- 238000000034 method Methods 0.000 title claims abstract description 39
- 238000013523 data management Methods 0.000 title claims abstract description 17
- 238000007726 management method Methods 0.000 claims abstract description 30
- 230000036541 health Effects 0.000 claims abstract description 9
- 230000015654 memory Effects 0.000 claims description 25
- 238000013500 data storage Methods 0.000 claims description 21
- 238000012545 processing Methods 0.000 claims description 17
- 230000005236 sound signal Effects 0.000 claims description 12
- 238000004590 computer program Methods 0.000 claims description 8
- 239000011159 matrix material Substances 0.000 claims description 5
- 238000001514 detection method Methods 0.000 claims description 3
- 230000006870 function Effects 0.000 description 10
- 238000012423 maintenance Methods 0.000 description 8
- 238000004891 communication Methods 0.000 description 7
- 238000013461 design Methods 0.000 description 5
- 238000010586 diagram Methods 0.000 description 5
- 230000003287 optical effect Effects 0.000 description 4
- 230000008569 process Effects 0.000 description 4
- 230000002159 abnormal effect Effects 0.000 description 3
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000004519 manufacturing process Methods 0.000 description 3
- 230000004927 fusion Effects 0.000 description 2
- 238000011900 installation process Methods 0.000 description 2
- 238000010606 normalization Methods 0.000 description 2
- 230000006978 adaptation Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000009434 installation Methods 0.000 description 1
- 230000007257 malfunction Effects 0.000 description 1
- 239000000463 material Substances 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000009877 rendering Methods 0.000 description 1
- 238000013024 troubleshooting Methods 0.000 description 1
- 239000002699 waste material Substances 0.000 description 1
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/21—Design, administration or maintenance of databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/604—Tools and structures for managing or administering access control systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
- G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2221/00—Indexing scheme relating to security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F2221/21—Indexing scheme relating to G06F21/00 and subgroups addressing additional information or applications relating to security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F2221/2141—Access rights, e.g. capability lists, access control lists, access tables, access matrices
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Bioethics (AREA)
- Software Systems (AREA)
- Computer Security & Cryptography (AREA)
- Computer Hardware Design (AREA)
- General Health & Medical Sciences (AREA)
- Health & Medical Sciences (AREA)
- Automation & Control Theory (AREA)
- Data Mining & Analysis (AREA)
- Escalators And Moving Walkways (AREA)
Abstract
The invention discloses a data management method and device for a multi-authority escalator monitoring database. The data management method of the multi-authority escalator monitoring database comprises the steps of classifying and standardizing data to be uploaded to obtain stored data, and uploading the stored data to the database; setting access authority for the stored data according to the category of the stored data, and setting authority level for the current registered user according to the access authority; and when detecting data calling information sent by a user side, calling the stored data according to the authority level of the user side. According to the scheme, the user sides can call corresponding different data in the database according to different authority access levels, so that manufacturers, operation management departments and users can check the health condition of the escalator, the escalator is better operated and managed, and the fault rate of the escalator is reduced.
Description
Technical Field
The invention relates to the field of escalator monitoring database management, in particular to a data management method and device of a multi-authority escalator monitoring database.
Background
At present, an escalator is one of important devices of urban rail transit, is a transportation tool for transporting pedestrians in a transportation belt mode, and needs to be monitored in real time in order to guarantee the safety of passengers and reduce the occurrence probability of accidents. At present, one escalator is usually adopted to correspond to one monitoring database, and in the mode, because each monitoring database is independent, data sharing cannot be carried out, the utilization rate of data is reduced, the escalator fault library cannot be accurately and perfectly established, and the accuracy of escalator fault identification is reduced. Simultaneously, because an automatic escalator corresponds a monitoring database, do not establish many authorities automatic escalator monitoring database through many user data fusion, lead to the producer can't in time know the easy trouble problem that appears of the automatic escalator of selling out, and then can not provide higher quality automatic escalator, the designer can not provide more humanized design, cause the data waste, the manufacturing and the cost of maintenance that have increased automatic escalator, and then lead to consumeing plenty of time and expense, thereby influence the normal use that comes into operation of automatic escalator.
Disclosure of Invention
In order to solve the above problems, embodiments of the present invention provide a data management method and apparatus for a multi-authority escalator monitoring database.
In a first aspect, an embodiment of the present invention provides a data management method for a multi-authority escalator monitoring database, where the method includes:
classifying and standardizing the data to be uploaded to obtain stored data, and uploading the stored data to a database;
setting access authority for the stored data according to the category of the stored data, and setting authority levels for currently registered users according to the access authority, wherein the currently registered users comprise designers, manufacturers, operation management departments, database management departments and purchasing units of escalators, and the database stores the stored data uploaded by all the currently registered users;
and when detecting data calling information sent by a user side, calling the stored data according to the authority level of the user side.
Preferably, the classifying and normalizing the data to be uploaded comprises:
acquiring data to be uploaded, and classifying the data to be uploaded;
and respectively carrying out standardized processing on the divided data to be uploaded based on the category of the data to be uploaded.
Preferably, the normalizing the divided data to be uploaded based on the category of the data to be uploaded includes:
determining the category of the data to be uploaded;
if the type of the data to be uploaded is equipment information data, standardizing the equipment information data to be equipment model, equipment component health degree and equipment operation data;
if the type of the data to be uploaded is monitoring signal data, standardizing the monitoring signal data to be a fault signal characteristic matrix;
if the type of the data to be uploaded is user information data, standardizing the user information data to be user basic information, user purchase information and user feedback information.
Preferably, the uploading the stored data to a database includes:
when the storage data is the equipment information data, uploading the storage data to an equipment data storage library in a database;
when the stored data is the monitoring signal data, uploading the stored data to a historical data storage library in the database;
and when the storage data is the user information data, uploading the storage data to a user data storage library in the database.
Preferably, when detecting data call information sent by a user, the method for calling the stored data according to the permission level of the user includes:
when detecting data calling information sent by a user side, acquiring the authority level of a user corresponding to the data calling information;
judging whether the permission level contains the access permission of the storage data to be called;
if so, calling and displaying the stored data corresponding to the data calling information;
and if not, generating and sending access application information to the database management terminal, wherein the access application information is used for representing that the user side wants to access the storage data corresponding to the data calling information.
Preferably, the method further comprises:
acquiring escalator data of an escalator, and sending the escalator data to a database;
and comparing the escalator data in the database to determine whether the escalator is in failure.
Preferably, the step of comparing the escalator data in the database to determine whether the escalator is in fault includes:
comparing the temperature signal, the vibration signal and the audio signal of the escalator data with a temperature signal storage library, a vibration signal storage library and an audio signal storage library in the database respectively by a data comparison center in the database, and determining whether a difference value between at least one signal and any data in the storage libraries is larger than a preset difference value;
if yes, determining that the escalator data are fault data, and storing the fault data into a fault signal storage library in the database;
if not, determining that the escalator data are normal data, and storing the normal data into a historical data storage library in the database.
In a second aspect, an embodiment of the present invention provides a data management apparatus for a multi-authority escalator monitoring database, where the apparatus includes:
the classification module is used for classifying and standardizing the data to be uploaded to obtain stored data and uploading the stored data to a database;
the authority setting module is used for setting access authority for the stored data according to the category of the stored data and setting authority level for the currently registered user according to the access authority, the currently registered user comprises a designer, a manufacturer, an operation management department, a database management department and a purchasing unit of the escalator, and the database stores the stored data uploaded by all the currently registered users;
and the detection module is used for calling the stored data according to the authority level of the user side when detecting data calling information sent by the user side.
In a third aspect, an embodiment of the present invention provides an electronic device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, where the processor executes the computer program to implement the steps of the method according to the first aspect or any one of the possible implementation manners of the first aspect.
In a fourth aspect, an embodiment of the present invention provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the method as provided in the first aspect or any one of the possible implementations of the first aspect.
The invention has the beneficial effects that: 1. the data of different user ends of multiple designers, multiple manufacturers, multiple operation management departments and multiple users are stored in the same database, so that a data platform which can be called by multiple user ends is established, and the data sharing of the escalator is realized. 2. Each user side can call corresponding different data in the database according to different authority access levels, so that manufacturers, operation management departments and users can check the health condition of the escalator, and the escalator is better operated and managed; designers can call database information, design a more reasonable escalator installation process, provide more humanized design and reduce the failure rate of the escalator. 3. By monitoring the data of the escalator in real time and comparing and calculating the data of the escalator with the temperature signal storage library, the vibration signal storage library and the audio signal storage library respectively in the data comparison center, the corresponding escalator fault is intelligently identified, and the maintenance efficiency of the escalator is improved. 4. Through uploading to the unified database platform through multi-data fusion, and carrying out multi-authority access setting, the maximum utilization data material perfects the specifications of manufacturing, installation, management and operation and the like of the escalator, reduces the fault rate of the escalator, and ensures that passengers take the escalator safely.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed to be used in the embodiments will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art that other drawings can be obtained according to these drawings without creative efforts.
Fig. 1 is a schematic flow chart of a data management method for a multi-authority escalator monitoring database according to an embodiment of the present invention;
fig. 2 is an exemplary schematic diagram of a multi-authority escalator monitoring database provided in an embodiment of the present invention;
FIG. 3 is a diagram illustrating an example of data classification normalization provided by an embodiment of the present invention;
fig. 4 is a schematic structural diagram of a data management device of a multi-authority escalator monitoring database according to an embodiment of the present invention;
fig. 5 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
The technical solution in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention.
In the following description, the terms "first" and "second" are used for descriptive purposes only and are not intended to indicate or imply relative importance. The following description provides embodiments of the invention, which may be combined with or substituted for various embodiments, and the invention is thus to be construed as embracing all possible combinations of the same and/or different embodiments described. Thus, if one embodiment includes feature A, B, C and another embodiment includes feature B, D, then the invention should also be construed as including embodiments that include one or more of all other possible combinations of A, B, C, D, even though such embodiments may not be explicitly recited in the following text.
The following description provides examples, and does not limit the scope, applicability, or examples set forth in the claims. Changes may be made in the function and arrangement of elements described without departing from the scope of the disclosure. Various examples may omit, substitute, or add various procedures or components as appropriate. For example, the described methods may be performed in an order different than the order described, and various steps may be added, omitted, or combined. Furthermore, features described with respect to some examples may be combined into other examples.
Referring to fig. 1, fig. 1 is a schematic flow chart of a data management method for a multi-authority escalator monitoring database according to an embodiment of the present invention. In an embodiment of the present invention, the method comprises:
s101, after data to be uploaded are classified and standardized, storage data are obtained and uploaded to a database.
The execution subject of the embodiment of the invention can be a data cloud platform.
The data to be uploaded can be understood as data to be uploaded to a database by user terminals such as designers, manufacturers, operation management departments, users and the like in the embodiment of the invention.
The stored data can be understood as data which is finally uploaded to a database for storage after classification and standardization processing in the embodiment of the invention.
Specifically, as shown in fig. 2, the multi-authority escalator monitoring database can be divided into two parts, namely data calling and data storage. The data calling part is divided into: designer, manufacturer, operation management department, database management department and user. The data storage part is divided into: the device comprises a temperature signal storage library, a vibration signal storage library, an audio signal storage library, a video signal storage library, a fault signal storage library, a data comparison calculation library, a history data storage library, a device data storage library and a user data storage library.
In the embodiment of the invention, in order to facilitate better classification management of the data uploaded to the database, the data to be uploaded is classified and standardized to obtain the uniform and standard storage data, and the storage data is uploaded and stored into the database according to the categories.
In one possible implementation, the classifying and normalizing the data to be uploaded in step S101 includes:
acquiring data to be uploaded, and classifying the data to be uploaded;
and respectively carrying out standardized processing on the divided data to be uploaded based on the category of the data to be uploaded.
In the embodiment of the invention, after the data to be uploaded are classified, different standardization processing is respectively carried out on the data to be uploaded in different categories according to the different categories, so that each category of data has a special standard for the subsequent data calling and viewing.
In an implementation manner, the normalizing the divided data to be uploaded based on the category of the data to be uploaded includes:
determining the category of the data to be uploaded;
if the type of the data to be uploaded is equipment information data, standardizing the equipment information data to be equipment model, equipment component health degree and equipment operation data;
if the type of the data to be uploaded is monitoring signal data, standardizing the monitoring signal data to be a fault signal characteristic matrix;
if the type of the data to be uploaded is user information data, standardizing the user information data to be user basic information, user purchase information and user feedback information.
In the embodiment of the present invention, as shown in fig. 3, the data to be uploaded may be specifically classified into device information data, monitoring signal data, and user information data, and different data are standardized based on different standards. The equipment information data is mainly used for calling and checking the health condition of the escalator for manufacturers, operation management departments and users, so that the equipment information data is standardized into equipment models, equipment component health degrees and equipment operation data. The monitoring signal data is mainly used for enabling equipment manufacturers to call the monitored escalator fault data so as to improve the escalator production quality and reduce the fault rate of the escalator, and therefore the monitoring signal data is standardized into a fault signal characteristic matrix. The user information data is mainly used for enabling designers to provide more accurate equipment products for users according to the use feedback conditions of the users, so that the user information data is standardized into user basic information, user purchase information and user feedback information.
In one embodiment, the uploading the stored data to a database includes:
when the storage data is the equipment information data, uploading the storage data to an equipment data storage library in a database;
when the stored data is the monitoring signal data, uploading the stored data to a historical data storage library in the database;
and when the storage data is the user information data, uploading the storage data to a user data storage library in the database.
In the embodiment of the invention, the storage data is obtained by classifying and standardizing the data to be uploaded, namely the storage data is also classified into several large classes of data. According to the embodiment of the invention, the different types of storage data are uploaded to different storage libraries in the database according to the specific types of the storage data, so that the subsequent access authority can be conveniently set.
S102, setting access authority for the stored data according to the category of the stored data, and setting authority levels for currently registered users according to the access authority, wherein the currently registered users comprise designers, manufacturers, operation management departments, database management departments and purchasing units of escalators, and the stored data uploaded by all the currently registered users are stored in the database.
In the embodiment of the invention, since the stored data are classified, and different types of stored data are expected to be accessed by different user groups such as manufacturers, designers and the like, that is, each user group has the type of the stored data which can be accessed by the user group, it is not expected that each user group can freely access the stored data due to the fact that the data related to the escalator are stored in one database. Therefore, different access authorities are set for different types of storage data, different authority levels are set for the currently registered account users according to user groups of the account users, and each account user can only access the storage data corresponding to the access authority contained in the authority level.
Possibly, when a new account is registered, a user side registering the new account sends an access authority level application to the data cloud platform, and a database management department gives corresponding authority levels after approval.
S103, when detecting data calling information sent by a user side, calling the stored data according to the authority level of the user side.
In one possible embodiment, step S103 includes:
when detecting data calling information sent by a user side, acquiring the authority level of a user corresponding to the data calling information;
judging whether the permission level contains the access permission of the storage data to be called;
if so, calling and displaying the stored data corresponding to the data calling information;
and if not, generating and sending access application information to the database management terminal, wherein the access application information is used for representing that the user side wants to access the storage data corresponding to the data calling information.
In the embodiment of the invention, when data calling information sent by a user side is detected, that is, the user of the user side wants to call and view the stored data in the database at the moment, the data cloud platform firstly determines the authority level of the account user and determines whether the authority level can access the access authority of the stored data requested to be called, if the authority level can be accessed, the corresponding stored data is called and displayed to the user side, and if the authority level cannot be accessed, the access platform under the corresponding level puts forward an access application to wait for a database management department to check the access user and the data to be accessed.
In one embodiment, the method further comprises:
acquiring escalator data of an escalator, and sending the escalator data to a database;
and comparing the escalator data in the database to determine whether the escalator is in failure.
In the embodiment of the invention, the escalator data of the escalator is obtained in real time and is sent to the database for comparison, so that the health condition and the fault condition of the escalator are monitored in real time.
Specifically, the maintenance process that the escalator breaks down at present is that after the escalator breaks down, a user who buys the escalator finds the escalator fault, the user feeds back the escalator fault condition to a manufacturer, and the manufacturer arranges personnel to go to maintenance. In the embodiment of the invention, the data sharing is carried out by sharing one database, and when the escalator data of the escalator is monitored in real time and the escalator is judged to have a fault, the data cloud platform sends the fault prompt information to the user end of the manufacturer, so that the problem of the escalator of the manufacturer is reminded at the first time, and the manufacturer is reminded to arrange personnel to go to maintenance.
In one embodiment, the data comparing the escalator data in the database to determine whether the escalator is faulty includes:
comparing the temperature signal, the vibration signal and the audio signal of the escalator data with a temperature signal storage library, a vibration signal storage library and an audio signal storage library in the database respectively by a data comparison center in the database, and determining whether a difference value between at least one signal and any data in the storage libraries is larger than a preset difference value;
if yes, determining that the escalator data are fault data, and storing the fault data into a fault signal storage library in the database;
if not, determining that the escalator data are normal data, and storing the normal data into a historical data storage library in the database.
In the present embodiment, the malfunction of the escalator will generally be determined by detecting its temperature signal, vibration signal, audio signal. The temperature signal storage library, the vibration signal storage library and the audio signal storage library in the database store the range of each data when the escalator is in a normal working state, if the difference value between at least one signal and any data in the storage libraries is larger than a preset difference value, the signal is considered to be in an abnormal range, and then the escalator fault is determined.
Specifically, when the escalator data are determined to be fault data, namely the escalator data are abnormal, the fault data are stored in the fault signal storage library, relevant personnel of a manufacturer can call the data in the fault signal storage library according to the authority levels of the personnel to quickly know what the escalator is abnormal, and accordingly the escalator can be maintained in a targeted mode, the situation that in the traditional maintenance process, due to the fact that a database is not shared, maintenance personnel need to perform troubleshooting after going to the fault escalator is avoided, and the fault maintenance efficiency is improved. When the escalator data are determined to be normal data, namely the escalator is in normal operation, the normal data are stored in the historical data storage library, designers can design a more reasonable escalator installation process by calling the data in the historical data storage library, a more humanized design is provided, and the failure rate of the escalator is reduced.
The data management device of the multi-authority escalator monitoring database provided by the embodiment of the invention will be described in detail with reference to fig. 4. It should be noted that, the data management device of the multi-authority escalator monitoring database shown in fig. 4 is used for executing the method of the embodiment shown in fig. 1 of the present invention, for convenience of description, only the portion related to the embodiment of the present invention is shown, and details of the specific technology are not disclosed, please refer to the embodiment shown in fig. 1 of the present invention.
Referring to fig. 4, fig. 4 is a data management device of a multi-authority escalator monitoring database according to an embodiment of the present invention. As shown in fig. 4, the apparatus includes:
the classification module 401 is configured to classify and standardize data to be uploaded to obtain stored data, and upload the stored data to a database;
an authority setting module 402, configured to set an access authority for the stored data according to the category of the stored data, and set an authority level for a currently registered user according to the access authority, where the currently registered user includes a designer, a manufacturer, an operation management department, a database management department, and a purchasing unit of an escalator, and the database stores the stored data uploaded by all currently registered users;
the detecting module 403 is configured to, when data call information sent by a user end is detected, call the stored data according to the permission level of the user end.
In one possible implementation, the classification module 401 includes:
the device comprises an acquisition unit, a storage unit and a processing unit, wherein the acquisition unit is used for acquiring data to be uploaded and classifying the data to be uploaded;
and the standardization unit is used for respectively carrying out standardization processing on the divided data to be uploaded based on the category of the data to be uploaded.
In one embodiment, the normalization unit is specifically configured to:
determining the category of the data to be uploaded;
if the type of the data to be uploaded is equipment information data, standardizing the equipment information data to be equipment model, equipment component health degree and equipment operation data;
if the type of the data to be uploaded is monitoring signal data, standardizing the monitoring signal data to be a fault signal characteristic matrix;
if the type of the data to be uploaded is user information data, standardizing the user information data to be user basic information, user purchase information and user feedback information.
In one embodiment, the classification module 401 further comprises:
a first uploading unit, configured to upload the storage data to a device data repository in a database when the storage data is the device information data;
the second uploading unit is used for uploading the stored data to a historical data storage library in the database when the stored data is the monitoring signal data;
and a third uploading unit, configured to upload the storage data to a user data repository in the database when the storage data is the user information data.
In one possible implementation, the detection module 403 includes:
the receiving unit is used for acquiring the authority level of the user corresponding to the data calling information when the data calling information sent by the user side is detected;
the judging unit is used for judging whether the authority level contains the access authority of the storage data to be called; if so, calling and displaying the stored data corresponding to the data calling information; and if not, generating and sending access application information to the database management terminal, wherein the access application information is used for representing that the user side wants to access the storage data corresponding to the data calling information.
In one embodiment, the apparatus further comprises:
the system comprises a sending module, a database and a data processing module, wherein the sending module is used for acquiring escalator data of an escalator and sending the escalator data to the database;
and the comparison module is used for comparing the escalator data in the database to determine whether the escalator is in fault.
In one embodiment, the alignment module is specifically configured to:
comparing the temperature signal, the vibration signal and the audio signal of the escalator data with a temperature signal storage library, a vibration signal storage library and an audio signal storage library in the database respectively by a data comparison center in the database, and determining whether a difference value between at least one signal and any data in the storage libraries is larger than a preset difference value;
if yes, determining that the escalator data are fault data, and storing the fault data into a fault signal storage library in the database;
if not, determining that the escalator data are normal data, and storing the normal data into a historical data storage library in the database.
It is clear to a person skilled in the art that the solution according to the embodiments of the invention can be implemented by means of software and/or hardware. The "unit" and "module" in this specification refer to software and/or hardware that can perform a specific function independently or in cooperation with other components, where the hardware may be, for example, a Field-Programmable Gate Array (FPGA), an Integrated Circuit (IC), or the like.
Each processing unit and/or module according to the embodiments of the present invention may be implemented by an analog circuit that implements the functions described in the embodiments of the present invention, or may be implemented by software that executes the functions described in the embodiments of the present invention.
Referring to fig. 5, a schematic structural diagram of an electronic device according to an embodiment of the present invention is shown, where the electronic device may be used to implement the method in the embodiment shown in fig. 1. As shown in fig. 5, the electronic device 500 may include: at least one central processor 501, at least one network interface 504, a user interface 503, a memory 505, at least one communication bus 502.
Wherein a communication bus 502 is used to enable connective communication between these components.
The user interface 503 may include a Display screen (Display) and a Camera (Camera), and the optional user interface 503 may also include a standard wired interface and a wireless interface.
The network interface 504 may optionally include a standard wired interface, a wireless interface (e.g., WI-FI interface), among others.
The central processor 501 may include one or more processing cores. The central processor 501 connects various parts within the entire terminal 500 using various interfaces and lines, and performs various functions of the terminal 500 and processes data by executing or executing instructions, programs, code sets, or instruction sets stored in the memory 505 and calling data stored in the memory 505. Optionally, the central Processing unit 501 may be implemented in at least one hardware form of Digital Signal Processing (DSP), Field-Programmable Gate Array (FPGA), and Programmable Logic Array (PLA). The Central Processing Unit 501 may integrate one or a combination of a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), a modem, and the like. Wherein, the CPU mainly processes an operating system, a user interface, an application program and the like; the GPU is used for rendering and drawing the content required to be displayed by the display screen; the modem is used to handle wireless communications. It is to be understood that the modem may not be integrated into the central processing unit 501, and may be implemented by a single chip.
The Memory 505 may include a Random Access Memory (RAM) or a Read-Only Memory (Read-Only Memory). Optionally, the memory 505 includes a non-transitory computer-readable medium. The memory 505 may be used to store instructions, programs, code sets, or instruction sets. The memory 505 may include a stored program area and a stored data area, wherein the stored program area may store instructions for implementing an operating system, instructions for at least one function (such as a touch function, a sound playing function, an image playing function, etc.), instructions for implementing the various method embodiments described above, and the like; the storage data area may store data and the like referred to in the above respective method embodiments. The memory 505 may alternatively be at least one memory device located remotely from the aforementioned central processor 501. As shown in fig. 5, memory 505, which is a type of computer storage medium, may include an operating system, a network communication module, a user interface module, and program instructions.
In the electronic device 500 shown in fig. 5, the user interface 503 is mainly used as an interface for providing input for a user, and acquiring data input by the user; and the processor 501 may be configured to invoke a data management application of the multi-authority escalator monitoring database stored in the memory 505, and specifically perform the following operations:
classifying and standardizing the data to be uploaded to obtain stored data, and uploading the stored data to a database;
setting access authority for the stored data according to the category of the stored data, and setting authority levels for currently registered users according to the access authority, wherein the currently registered users comprise designers, manufacturers, operation management departments, database management departments and purchasing units of escalators, and the database stores the stored data uploaded by all the currently registered users;
and when detecting data calling information sent by a user side, calling the stored data according to the authority level of the user side.
The invention also provides a computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the steps of the above-mentioned method. The computer-readable storage medium may include, but is not limited to, any type of disk including floppy disks, optical disks, DVD, CD-ROMs, microdrive, and magneto-optical disks, ROMs, RAMs, EPROMs, EEPROMs, DRAMs, VRAMs, flash memory devices, magnetic or optical cards, nanosystems (including molecular memory ICs), or any type of media or device suitable for storing instructions and/or data.
It should be noted that, for simplicity of description, the above-mentioned method embodiments are described as a series of acts or combination of acts, but those skilled in the art will recognize that the present invention is not limited by the order of acts, as some steps may occur in other orders or concurrently in accordance with the invention. Further, those skilled in the art should also appreciate that the embodiments described in the specification are preferred embodiments and that the acts and modules referred to are not necessarily required by the invention.
In the foregoing embodiments, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.
In the embodiments provided in the present invention, it should be understood that the disclosed apparatus can be implemented in other manners. For example, the above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units is only one type of division of logical functions, and there may be other divisions when actually implementing, for example, a plurality of units or components may be combined or may be integrated into another system, or some features may be omitted, or not implemented. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection of some service interfaces, devices or units, and may be an electrical or other form.
The 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 achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present invention 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 integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable memory. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a memory and includes several instructions for causing a computer device (which may be a personal computer, a server, a network device, or the like) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned memory comprises: various media capable of storing program codes, such as a usb disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic disk, or an optical disk.
Those skilled in the art will appreciate that all or part of the steps in the methods of the above embodiments may be implemented by a program, which is stored in a computer-readable memory, and the memory may include: flash disks, Read-Only memories (ROMs), Random Access Memories (RAMs), magnetic or optical disks, and the like.
The above description is only an exemplary embodiment of the present disclosure, and the scope of the present disclosure should not be limited thereby. That is, all equivalent changes and modifications made in accordance with the teachings of the present disclosure are intended to be included within the scope of the present disclosure. Embodiments of the present disclosure will be readily apparent to those skilled in the art from consideration of the specification and practice of the disclosure herein. This application is intended to cover any variations, uses, or adaptations of the disclosure following, in general, the principles of the disclosure and including such departures from the present disclosure as come within known or customary practice within the art to which the disclosure pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the disclosure being indicated by the following claims.
Claims (10)
1. A data management method of a multi-authority escalator monitoring database is characterized by comprising the following steps:
classifying and standardizing the data to be uploaded to obtain stored data, and uploading the stored data to a database;
setting access authority for the stored data according to the category of the stored data, and setting authority levels for currently registered users according to the access authority, wherein the currently registered users comprise designers, manufacturers, operation management departments, database management departments and purchasing units of escalators, and the database stores the stored data uploaded by all the currently registered users;
and when detecting data calling information sent by a user side, calling the stored data according to the authority level of the user side.
2. The method of claim 1, wherein the classifying and normalizing the data to be uploaded comprises:
acquiring data to be uploaded, and classifying the data to be uploaded;
and respectively carrying out standardized processing on the divided data to be uploaded based on the category of the data to be uploaded.
3. The method according to claim 2, wherein the normalizing the divided data to be uploaded based on the category of the data to be uploaded comprises:
determining the category of the data to be uploaded;
if the type of the data to be uploaded is equipment information data, standardizing the equipment information data to be equipment model, equipment component health degree and equipment operation data;
if the type of the data to be uploaded is monitoring signal data, standardizing the monitoring signal data to be a fault signal characteristic matrix;
if the type of the data to be uploaded is user information data, standardizing the user information data to be user basic information, user purchase information and user feedback information.
4. The method of claim 3, wherein uploading the stored data to a database comprises:
when the storage data is the equipment information data, uploading the storage data to an equipment data storage library in a database;
when the stored data is the monitoring signal data, uploading the stored data to a historical data storage library in the database;
and when the storage data is the user information data, uploading the storage data to a user data storage library in the database.
5. The method according to claim 1, wherein the invoking the stored data according to the authority level of the user side when detecting data invoking information sent by the user side comprises:
when detecting data calling information sent by a user side, acquiring the authority level of a user corresponding to the data calling information;
judging whether the permission level contains the access permission of the storage data to be called;
if so, calling and displaying the stored data corresponding to the data calling information;
and if not, generating and sending access application information to the database management terminal, wherein the access application information is used for representing that the user side wants to access the storage data corresponding to the data calling information.
6. The method of claim 1, further comprising:
acquiring escalator data of an escalator, and sending the escalator data to a database;
and comparing the escalator data in the database to determine whether the escalator is in failure.
7. The method of claim 6, wherein said comparing the escalator data in the database to determine if the escalator is malfunctioning comprises:
comparing the temperature signal, the vibration signal and the audio signal of the escalator data with a temperature signal storage library, a vibration signal storage library and an audio signal storage library in the database respectively by a data comparison center in the database, and determining whether a difference value between at least one signal and any data in the storage libraries is larger than a preset difference value;
if yes, determining that the escalator data are fault data, and storing the fault data into a fault signal storage library in the database;
if not, determining that the escalator data are normal data, and storing the normal data into a historical data storage library in the database.
8. A data management device for a multi-authority escalator monitoring database, the device comprising:
the classification module is used for classifying and standardizing the data to be uploaded to obtain stored data and uploading the stored data to a database;
the authority setting module is used for setting access authority for the stored data according to the category of the stored data and setting authority level for the currently registered user according to the access authority, the currently registered user comprises a designer, a manufacturer, an operation management department, a database management department and a purchasing unit of the escalator, and the database stores the stored data uploaded by all the currently registered users;
and the detection module is used for calling the stored data according to the authority level of the user side when detecting data calling information sent by the user side.
9. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the steps of the method according to any of claims 1-7 are implemented when the computer program is executed by the processor.
10. A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the steps of the method according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011452520.8A CN112527770A (en) | 2020-12-12 | 2020-12-12 | Data management method and device for multi-authority escalator monitoring database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011452520.8A CN112527770A (en) | 2020-12-12 | 2020-12-12 | Data management method and device for multi-authority escalator monitoring database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112527770A true CN112527770A (en) | 2021-03-19 |
Family
ID=74998865
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011452520.8A Pending CN112527770A (en) | 2020-12-12 | 2020-12-12 | Data management method and device for multi-authority escalator monitoring database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112527770A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113722324A (en) * | 2021-08-30 | 2021-11-30 | 平安国际智慧城市科技股份有限公司 | Report generation method and device based on artificial intelligence, electronic equipment and medium |
| CN116054312A (en) * | 2022-11-22 | 2023-05-02 | 江苏为恒智能科技有限公司 | Authority control method for grading safety of battery energy storage system |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104537315A (en) * | 2014-12-27 | 2015-04-22 | 宁波江东恒冠信息技术有限公司 | File usage authority management method, device and system |
| CN110135172A (en) * | 2019-04-01 | 2019-08-16 | 深圳市豪斯特力节能环保科技有限公司 | A kind of device data management method, storage medium and its intelligent terminal |
| CN110806730A (en) * | 2019-10-22 | 2020-02-18 | 重庆川仪自动化股份有限公司 | Big data operation and maintenance platform, server and storage medium |
| CN111651508A (en) * | 2020-04-27 | 2020-09-11 | 平安城市建设科技(深圳)有限公司 | Operation and maintenance data management method and device, electronic equipment and storage medium |
| CN213958054U (en) * | 2020-12-12 | 2021-08-13 | 南京地铁建设有限责任公司 | Data management device of multi-authority escalator monitoring database |
-
2020
- 2020-12-12 CN CN202011452520.8A patent/CN112527770A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104537315A (en) * | 2014-12-27 | 2015-04-22 | 宁波江东恒冠信息技术有限公司 | File usage authority management method, device and system |
| CN110135172A (en) * | 2019-04-01 | 2019-08-16 | 深圳市豪斯特力节能环保科技有限公司 | A kind of device data management method, storage medium and its intelligent terminal |
| CN110806730A (en) * | 2019-10-22 | 2020-02-18 | 重庆川仪自动化股份有限公司 | Big data operation and maintenance platform, server and storage medium |
| CN111651508A (en) * | 2020-04-27 | 2020-09-11 | 平安城市建设科技(深圳)有限公司 | Operation and maintenance data management method and device, electronic equipment and storage medium |
| CN213958054U (en) * | 2020-12-12 | 2021-08-13 | 南京地铁建设有限责任公司 | Data management device of multi-authority escalator monitoring database |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113722324A (en) * | 2021-08-30 | 2021-11-30 | 平安国际智慧城市科技股份有限公司 | Report generation method and device based on artificial intelligence, electronic equipment and medium |
| CN113722324B (en) * | 2021-08-30 | 2023-08-18 | 深圳平安智慧医健科技有限公司 | Report generation method and device based on artificial intelligence, electronic equipment and medium |
| CN116054312A (en) * | 2022-11-22 | 2023-05-02 | 江苏为恒智能科技有限公司 | Authority control method for grading safety of battery energy storage system |
| CN116054312B (en) * | 2022-11-22 | 2024-06-11 | 江苏为恒智能科技有限公司 | Authority control method for grading safety of battery energy storage system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10769722B1 (en) | Heuristic credit risk assessment engine | |
| US9084937B2 (en) | Faults and performance issue prediction | |
| CN110221145B (en) | Power equipment fault diagnosis method and device and terminal equipment | |
| US20200342690A1 (en) | Method for establishing communicable connection with tire pressure monitoring system, apparatus thereof and electronic device | |
| CN112527770A (en) | Data management method and device for multi-authority escalator monitoring database | |
| CN107193714B (en) | Alarm display method and device | |
| CN112579621A (en) | Data display method and device, electronic equipment and computer storage medium | |
| CN113911872B (en) | Fault processing method and system and early warning rescue system | |
| CN115964272A (en) | Transaction data automatic testing method, device, equipment and readable storage medium | |
| CN111209153A (en) | Abnormity detection processing method and device and electronic equipment | |
| US20220035621A1 (en) | Software query information management system and software query information management method | |
| CN113849330A (en) | Method, equipment and storage medium for monitoring and analyzing application fault reasons | |
| US11544783B1 (en) | Heuristic credit risk assessment engine | |
| CN112085611A (en) | Asynchronous data verification method and device, electronic equipment and storage medium | |
| CN117149569A (en) | Board running state early warning method and device and electronic equipment | |
| CN112887355A (en) | Service processing method and device for abnormal server | |
| CN114968696A (en) | Index monitoring method, electronic equipment and chip system | |
| CN111552631A (en) | System testing method, device and computer readable storage medium | |
| CN111651652A (en) | Emotional tendency recognition method, device, equipment and medium based on artificial intelligence | |
| CN116449810B (en) | Fault detection method and device, electronic equipment and storage medium | |
| CN117271286A (en) | Performance evaluation method, device, apparatus, medium, and program product | |
| CN114328487A (en) | Quality inspection evaluation method and device | |
| CN114997435A (en) | Work order processing method and device | |
| CN117196307A (en) | Method, device, equipment and storage medium for detecting running state of wind control model | |
| CN116629960A (en) | Vehicle information auditing method, device, server and computer readable storage medium |
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 |