CN112100654A - Terminal-based equipment database resource management method - Google Patents
Terminal-based equipment database resource management method Download PDFInfo
- Publication number
- CN112100654A CN112100654A CN202010911644.1A CN202010911644A CN112100654A CN 112100654 A CN112100654 A CN 112100654A CN 202010911644 A CN202010911644 A CN 202010911644A CN 112100654 A CN112100654 A CN 112100654A
- Authority
- CN
- China
- Prior art keywords
- database
- information
- terminal
- resources
- management
- 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
Images
Classifications
-
- 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
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/285—Clustering or classification
-
- 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/602—Providing cryptographic facilities or services
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Health & Medical Sciences (AREA)
- Bioethics (AREA)
- General Health & Medical Sciences (AREA)
- Computer Hardware Design (AREA)
- Computer Security & Cryptography (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a terminal-based equipment database resource management method, which comprises the following steps: the terminal user accesses, the authorized user logs in the system through the terminal, and the data transmission is transmitted through SSL encryption network link; database management, namely performing operations of creating, querying, deleting, backing up, recovering and renaming on a database; the user acquires the related authority after logging in, and can manage the database, which specifically comprises the following steps: checking a database list, database backup, deleting a database, database backup, database recovery and editing the database; for the classified management of equipment resources, a real-time resource management method and a power-down storage classified management method are adopted; and the database classification system is utilized to realize the high-efficiency management of the data resources. The method can solve the problem of embedded equipment data resource management, is used for configuring management equipment information through remote transmission terminal access equipment, and can effectively meet the requirement of remote resource management through the flexible use mode.
Description
Technical Field
The invention relates to the field of resource allocation management of embedded equipment, in particular to a terminal-based equipment database resource management method.
Background
In the original equipment management resource system, when the C/S mode is adopted to complete the supervision of equipment interface resources, services and running states, the mode needs a user to install a client, and equipment resource management is realized through client software. The method adopts the B/S mode to realize the resource management of the equipment database, namely the browser server mode, and the mode does not need any client side installed by a user, can realize system login and inquiry and downloading of equipment resource information as long as the user can surf the internet, reduces the requirement of software application on the configuration of a computer, provides convenience for remotely accessing the resource of the user database, greatly improves the operation efficiency and can effectively reduce the maintenance cost.
Disclosure of Invention
The invention aims to solve the technical problems of authorized access of a user terminal, resource management and control system architecture design, equipment resource classification, database management and the like.
The invention provides a terminal-based equipment database resource management method, which comprises the following steps:
s1, end user access
An authorized user logs in the system through a terminal, and data transmission is transmitted through SSL encryption network link;
s2, database management
Performing operations of creating, querying, deleting, backing up, recovering and renaming on the database; the user acquires the related authority after logging in, and can manage the database, which specifically comprises the following steps: checking a database list, database backup, deleting a database, database backup, database recovery and editing the database;
s3, managing the device resource by classification
A real-time resource management method and a power-down storage classification management method are adopted; the database classification system is utilized to realize the high-efficiency management of the data resources; the method comprises the steps of classifying and storing equipment resources, and realizing storage management of power-down storage resources, real-time state resources and parameter file resources by means of a database and a file system; the information in the resource library is stored in a data object in a predefined data structure in an entity form, and the power failure parameter in the resource library is stored in the data object in the predefined data structure in a file data format.
The end user access described in step S1 specifically includes the following steps:
s11, authorizing the user to log in through the terminal, encrypting and transmitting the user information to the system by the terminal, executing the user authentication, and executing the step S2 if the user authentication is passed; otherwise, go to step S12;
and S12, if the authentication fails, prompting the user to re-input, and if the authentication fails for three times, prohibiting the same terminal from repeatedly logging in within two hours.
In the step S3, for the classified management of device resources, the basic information resources of the device database are stored in the pre-packaged memory data object of the database in a text and data storage manner, the extensible storage text file of the extensible information resources is stored in the file system, and the corresponding file address is also stored in the data object.
Step S3, classifying and managing the equipment resources, classifying the attributes needing to be reset each time the equipment is powered on into a power-down storage class, storing the power-down storage class into a hard disk, and reloading the hard disk with the next start of the equipment; and the attribute changed along with the change of the external environment is classified as a real-time storage class and is put into a memory file system.
Step S3 describes the classification management of device resources, the independent table establishment of the basic information and the power failure information, and the association of the extended table entry, which is used to store real-time data.
Step S3, classifying and managing the device resource, using double information management node technology to divide each node into two parts; for the basic information, performing classification management to accommodate the resource characteristics of the whole database; and for the classification description of the equipment parameter information or the extended information of the equipment parameters, the definition of the table entry and the data type is realized in a mode of self-defining the node.
For query data, firstly, searching target information in basic information according to input conditions, and if the target information is not hit, returning prompt query failure information; if yes, outputting basic information, and then giving a choice whether to continue to acquire the extended information; and if the real-time state information is associated with the information, acquiring and outputting the resource information from the RAM file system for storing the real-time information.
The beneficial effects of the invention include:
1. and managing the equipment resources aiming at the parameter file class. In the invention, the proportion of the parameter file resource management in the database sharing management of the equipment resource management system is large, and the functions of resource management and power failure storage are emphasized. Meanwhile, resource management must be performed in a targeted manner. The basic information resources must be stored in the pre-packaged memory data objects of the database in a text and data storage manner. Meanwhile, the extensible storage text file of the extended information resource is stored in the file system, and the corresponding file address must be stored in the data object. This has the advantage that the speed of data object or browsing discovery and reading is greatly increased, once needed or necessary.
2. And managing resources aiming at the real-time state. The real-time state resources mainly reflect the running states of resources of the current equipment, and the resources have high storage access frequency, so that information is directly encapsulated into a defined data structure and stored into a memory attribute table entry of data, and the data can disappear after the equipment is powered off. The invention improves the reliability of resource management by carrying out classified management on equipment resources and adopting a real-time resource management method and a power-down storage classified management method according to actual resource classification.
Drawings
FIG. 1 is a schematic diagram of the overall architecture of the present invention.
FIG. 2 is a resource classification diagram of the present invention.
FIG. 3 is a diagram of a resource data structure of the present invention.
Fig. 4 is a resource storage diagram of the present invention.
FIG. 5 is a detailed flow chart of resource query according to the present invention.
Detailed Description
For a better understanding of the present disclosure, an example is given here.
The invention provides a terminal-based equipment database resource management method, which comprises the following steps:
s1, the terminal user accesses, authorizes the user to log in the system through the terminal, and transmits data through SSL encryption network link;
s2, managing a database, and performing operations of creating, querying, deleting, backing up, recovering and renaming the database; the user acquires the related authority after logging in, and can manage the database, which specifically comprises the following steps: checking a database list, database backup, deleting a database, database backup, database recovery and editing the database;
s3, managing the device resources in a classified manner by adopting a real-time resource management method and a power-down storage classified management method; the database classification system is utilized to realize the high-efficiency management of the data resources; the method comprises the steps of classifying and storing equipment resources, and realizing storage management of power-down storage resources, real-time state resources and parameter file resources by means of a database and a file system; the information in the resource library is stored in a data object in a predefined data structure in an entity form, and the power failure parameter in the resource library is stored in the data object in the predefined data structure in a file data format. FIG. 1 is a schematic diagram of the overall architecture of the present invention.
The end user access described in step S1 specifically includes the following steps:
s11, authorizing the user to log in through the terminal, encrypting and transmitting the user information to the system by the terminal, executing the user authentication, and executing the step S2 if the user authentication is passed; otherwise, go to step S12;
and S12, if the authentication fails, prompting the user to re-input, and if the authentication fails for three times, prohibiting the same terminal from repeatedly logging in within two hours.
FIG. 2 is a resource classification diagram of the present invention. In the step S3, for the classified management of device resources, the basic information resources of the device database are stored in the pre-packaged memory data object of the database in a text and data storage manner, the extensible storage text file of the extensible information resources is stored in the file system, and the corresponding file address is also stored in the data object.
Step S3, classifying and managing the equipment resources, classifying the attributes needing to be reset each time the equipment is powered on into a power-down storage class, storing the power-down storage class into a hard disk, and reloading the hard disk with the next start of the equipment; and the attribute changed along with the change of the external environment is classified as a real-time storage class and is put into a memory file system.
Step S3 describes the classification management of device resources, the independent table establishment of the basic information and the power failure information, and the association of the extended table entry, which is used to store real-time data.
Step S3, classifying and managing the device resource, using double information management node technology to divide each node into two parts; for the basic information, performing classification management to accommodate the resource characteristics of the whole database; and for the classification description of the equipment parameter information or the extended information of the equipment parameters, the definition of the table entry and the data type is realized in a mode of self-defining the node.
For query data, firstly, searching target information in basic information according to input conditions, and if the target information is not hit, returning prompt query failure information; if yes, outputting basic information, and then giving a choice whether to continue to acquire the extended information; and if the real-time state information is associated with the information, acquiring and outputting the resource information from the RAM file system for storing the real-time information.
For the management of the device resources, in the design of the resource library, the device resource management system is an important component, and the effective resource management function is the basic function of the resource library. In the management of the equipment resources, the most important is to realize efficient management by means of a classification system. According to the actual resource classification, the real-time resource management method and the power-down storage classification management method, the management efficiency can be effectively improved, and the management responsibility can be realized. The specific classification is shown in fig. 2. The method comprises the following steps that parameters such as interface physical rate, mode and the like, attributes needing to be reset when equipment is powered on each time are classified into power-down storage types, and the attributes are stored in a hard disk and reloaded when the equipment is started next time; the amount of the statistics of the interface receiving and sending packets and the change of the self-adaptive mode along with the change of the external environment is classified as real-time storage and is put into a memory file system, so that the quick search is facilitated.
The final purpose of the classification is to perform storage, which is the core work of database resource management. Therefore, the final purpose of managing the power failure storage information, the real-time state and the statistical information is achieved. Therefore, what way to sort the different types of information is adopted becomes a key factor. In contrast, the present design method employs a data structure as shown in fig. 3. And the basic information power failure information is independently tabulated and is associated with the extended table entry and used for storing real-time data.
The final purpose of classifying the database resources is storage, which is also the core technology of the resource management database. By means of classification techniques, efficient management and querying of parametric textual information as well as various real-time status information should be achieved in some way chosen as the ultimate goal of each database design. Therefore, the classification criteria become an important technical factor for classification design. In the invention, the device resources are classified and managed, and each node is divided into two parts by using a dual-information management node technology. For the basic information, classification management is performed to accommodate resource characteristics and the like of the entire database. These classification management must facilitate access to and statistics of the basic information, and must also describe complete header information, keywords, power-down storage parameters, statistical parameters, state parameters, and other information. For the classification description of the device parameter information or the extended information (such as interface state) of the device parameter, the definition of the table entry and the data type is realized by a mode of self-defining the node. Detailed resource records are kept for the extension information so as to facilitate the extension management in the future and define the node types.
In a terminal-based device database resource management method, on the one hand, information in a resource base is in the form of entities in data objects in a defined data structure. On the other hand, the power-down parameters in the resource library are stored in a data object in a well-defined data structure in the format of file data. The resource storage map of the present invention is shown in fig. 4.
According to the characteristics of the equipment resource management system, the storage management of real-time state resources and parameter file resources is realized by means of the database and the file system.
In the terminal-based device database resource management method, the query data flow is as shown in fig. 5. For query data, firstly, searching target information in basic information according to input conditions, and if the target information is not hit, returning prompt query failure information; if yes, basic information is output, and then whether to continue to acquire the extension information is selected. And if the information is associated with the real-time state information, acquiring the resource information from the RAM file system for storing the real-time information and outputting the resource information.
The above description is only an example of the present application and is not intended to limit the present application. Various modifications and changes may occur to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.
Claims (7)
1. A terminal-based equipment database resource management method is characterized by comprising the following steps:
s1, end user access
An authorized user logs in the system through a terminal, and data transmission is transmitted through SSL encryption network link;
s2, database management
Performing operations of creating, querying, deleting, backing up, recovering and renaming on the database; the user acquires the related authority after logging in, and can manage the database, which specifically comprises the following steps: checking a database list, database backup, deleting a database, database backup, database recovery and editing the database;
s3, managing the device resource by classification
A real-time resource management method and a power-down storage classification management method are adopted; the database classification system is utilized to realize the high-efficiency management of the data resources; the method comprises the steps of classifying and storing equipment resources, and realizing storage management of power-down storage resources, real-time state resources and parameter file resources by means of a database and a file system; the information in the resource library is stored in a data object in a predefined data structure in an entity form, and the power failure parameter in the resource library is stored in the data object in the predefined data structure in a file data format.
2. The terminal-based device database resource management method according to claim 1, wherein the terminal user access in step S1 specifically includes the following steps:
s11, authorizing the user to log in through the terminal, encrypting and transmitting the user information to the system by the terminal, executing the user authentication, and executing the step S2 if the user authentication is passed; otherwise, go to step S12;
and S12, if the authentication fails, prompting the user to re-input, and if the authentication fails for three times, prohibiting the same terminal from repeatedly logging in within two hours.
3. The method as claimed in claim 1, wherein the step S3 is performed to classify and manage the device resources, the basic information resources of the device database are stored in the pre-packaged memory data object of the database in a text and data storage manner, the extensible storage text file of the extended information resources is stored in the file system, and the corresponding file address is also stored in the data object.
4. The terminal-based device database resource management method according to claim 1, wherein in the step S3, the device resources are managed in a classified manner, and the attributes that need to be reset each time the device is powered on are classified as a power-down storage class, stored in the hard disk, and reloaded when the device is started next time; and the attribute changed along with the change of the external environment is classified as a real-time storage class and is put into a memory file system.
5. The method for managing database resources of terminal-based devices according to claim 1, wherein step S3 is implemented by classifying and managing device resources, separately tabulating basic information and power-down information, and associating extended table entries for storing real-time data.
6. The terminal-based device database resource management method according to claim 1, wherein the step S3 classifies and manages the device resources, and uses a dual-information management node technique to divide each node into two parts; for the basic information, performing classification management to accommodate the resource characteristics of the whole database; and for the classification description of the equipment parameter information or the extended information of the equipment parameters, the definition of the table entry and the data type is realized in a mode of self-defining the node.
7. The terminal-based equipment database resource management method according to claim 1, wherein for the query data, firstly, the target information is searched in the basic information according to the input condition, and if no hit occurs, the query failure prompting information is returned; if yes, outputting basic information, and then giving a choice whether to continue to acquire the extended information; and if the real-time state information is associated with the information, acquiring and outputting the resource information from the RAM file system for storing the real-time information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010911644.1A CN112100654A (en) | 2020-09-02 | 2020-09-02 | Terminal-based equipment database resource management method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010911644.1A CN112100654A (en) | 2020-09-02 | 2020-09-02 | Terminal-based equipment database resource management method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112100654A true CN112100654A (en) | 2020-12-18 |
Family
ID=73757679
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010911644.1A Pending CN112100654A (en) | 2020-09-02 | 2020-09-02 | Terminal-based equipment database resource management method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112100654A (en) |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103268336A (en) * | 2013-05-13 | 2013-08-28 | 刘峰 | Fast data and big data combined data processing method and system |
| CN104063766A (en) * | 2014-07-03 | 2014-09-24 | 广州智业节能科技有限公司 | Building energy efficiency management system based on cloud computing and big data technology |
| US20150046494A1 (en) * | 2013-08-12 | 2015-02-12 | Dhwanit Shah | Main-memory based conceptual framework for file storage and fast data retrieval |
| US20160291977A1 (en) * | 2015-03-30 | 2016-10-06 | International Business Machines Corporation | Adaptive map-reduce pipeline with dynamic thread allocations |
| CN106055590A (en) * | 2016-05-23 | 2016-10-26 | 环球大数据科技有限公司 | Power grid data processing method and system based on big data and graph database |
| CN107862762A (en) * | 2017-10-27 | 2018-03-30 | 天津津航计算技术研究所 | A kind of airplane data Quick Acquisition and storage system |
| US20180203874A1 (en) * | 2017-01-18 | 2018-07-19 | International Business Machines Corporation | Space-efficient secondary indexing on distributed data stores |
| CN109255531A (en) * | 2018-08-28 | 2019-01-22 | 中金数据系统有限公司 | A kind of data center's intelligence operation management system |
| CN110032460A (en) * | 2019-04-26 | 2019-07-19 | 珠海市掌业科技有限公司 | A kind of application work platform and its implementation method based on B/S framework |
| CN111026798A (en) * | 2019-12-05 | 2020-04-17 | 苏州中车建设工程有限公司 | Electromechanical equipment database system and control method thereof |
-
2020
- 2020-09-02 CN CN202010911644.1A patent/CN112100654A/en active Pending
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103268336A (en) * | 2013-05-13 | 2013-08-28 | 刘峰 | Fast data and big data combined data processing method and system |
| US20150046494A1 (en) * | 2013-08-12 | 2015-02-12 | Dhwanit Shah | Main-memory based conceptual framework for file storage and fast data retrieval |
| CN104063766A (en) * | 2014-07-03 | 2014-09-24 | 广州智业节能科技有限公司 | Building energy efficiency management system based on cloud computing and big data technology |
| US20160291977A1 (en) * | 2015-03-30 | 2016-10-06 | International Business Machines Corporation | Adaptive map-reduce pipeline with dynamic thread allocations |
| CN106055590A (en) * | 2016-05-23 | 2016-10-26 | 环球大数据科技有限公司 | Power grid data processing method and system based on big data and graph database |
| US20180203874A1 (en) * | 2017-01-18 | 2018-07-19 | International Business Machines Corporation | Space-efficient secondary indexing on distributed data stores |
| CN107862762A (en) * | 2017-10-27 | 2018-03-30 | 天津津航计算技术研究所 | A kind of airplane data Quick Acquisition and storage system |
| CN109255531A (en) * | 2018-08-28 | 2019-01-22 | 中金数据系统有限公司 | A kind of data center's intelligence operation management system |
| CN110032460A (en) * | 2019-04-26 | 2019-07-19 | 珠海市掌业科技有限公司 | A kind of application work platform and its implementation method based on B/S framework |
| CN111026798A (en) * | 2019-12-05 | 2020-04-17 | 苏州中车建设工程有限公司 | Electromechanical equipment database system and control method thereof |
Non-Patent Citations (1)
| Title |
|---|
| 韦安: "一种嵌入式Linux下混合文件系统的实现技术", 《计算机工程》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11822640B1 (en) | User credentials verification for search | |
| CN108133008B (en) | Method, device, equipment and storage medium for processing service data in database | |
| CN110716910B (en) | Log management method, device, equipment and storage medium | |
| US7805416B1 (en) | File system query and method of use | |
| US9009139B2 (en) | Query pipeline | |
| US8930402B1 (en) | Systems and methods for automatic collection of data over a network | |
| US9166989B2 (en) | Storing log data efficiently while supporting querying | |
| US7783615B1 (en) | Apparatus and method for building a file system index | |
| JP4648723B2 (en) | Method and apparatus for hierarchical storage management based on data value | |
| US9031916B2 (en) | Storing log data efficiently while supporting querying to assist in computer network security | |
| CN107911249B (en) | Method, device and equipment for sending command line of network equipment | |
| US8135763B1 (en) | Apparatus and method for maintaining a file system index | |
| US20030131093A1 (en) | System for generating usage data in a distributed information processing environment and method therefor | |
| US11429566B2 (en) | Approach for a controllable trade-off between cost and availability of indexed data in a cloud log aggregation solution such as splunk or sumo | |
| US11947614B1 (en) | Method and system for centralized multi-instance deployment consolidation | |
| CN105574054A (en) | Distributed cache range query method, apparatus and system | |
| KR100714504B1 (en) | System and method for searching contents in personal terminals using wired and wireless internet | |
| CN112100654A (en) | Terminal-based equipment database resource management method | |
| CN102932468B (en) | Share data access method | |
| CN107977381B (en) | Data configuration method, index management method, related device and computing equipment | |
| CN110798222B (en) | Data compression method and device | |
| WO2020144816A1 (en) | History management device, search processing device, history management method, search processing method, and program | |
| US7260615B2 (en) | Apparatus and method for analyzing remote data | |
| CN101930451B (en) | For storing the method and apparatus of at least one inquiry data element of efficiently searching | |
| US11537559B2 (en) | Client generated aggregated indices |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20201218 |