Information device and storage device account management system

Abstract

The invention relates to the technical field of enterprise asset management, in particular to management work of enterprise information equipment and the like, in particular to an information equipment and storage equipment account management system which comprises database table design and program design. The database table design comprises table structure design and trigger design, and a computer table, a storage medium table, an external equipment table, an office automation equipment table and an acoustic image equipment table are established in the table structure design; the trigger design is that newly added and updated triggers are established on the basis of a computer table, a storage medium table, an external equipment table, an office automation equipment table and an acoustic image equipment table; the program design is divided into interface design and program development, and the program development comprises equipment number directory tree structure generation, equipment maintenance page, report summarization and ledger query. According to the system, daily maintenance state management of a computer, a storage medium, external equipment, office automation equipment and the like is realized, and various equipment ledger reports are generated regularly.

Description

Technical Field

[0001] The present invention relates to the technical field of enterprise asset management, and in particular to the management of enterprise information equipment, etc., specifically to an information equipment and storage equipment ledger management system, which is used for daily management of information equipment and storage equipment ledgers and report generation. Background Art

[0002] With the continuous advancement of enterprise informatization, information technology has played an immeasurable role in improving enterprise work efficiency and promoting information sharing. However, faced with the management of a large number of information devices, including computers, peripherals, and office equipment, the traditional manual or simple computer editing operations are extremely inconvenient for information management. Furthermore, due to the limitations of the software tools themselves and their lack of network support, it is not conducive to the sharing of device information, resulting in a lot of repetitive and complex work in device management.

[0003] Enterprise informatization requires the creation of a master ledger for computers, peripherals, storage media, and office automation equipment. Each department should establish separate ledgers, and the ledger information needs to be reviewed semi-annually. Traditional paper-based ledger management methods make the aggregation, review, and search of ledger information difficult and cumbersome, and human error is inevitable during the review process. Therefore, a management method is urgently needed for the daily maintenance of information equipment and storage device ledgers. Summary of the Invention

[0004] In order to solve the problem that the traditional paper ledger management method is difficult and cumbersome in summarizing, checking and searching ledger information, the present invention provides an information equipment and storage device ledger management system.

[0005] The present invention is implemented by adopting the following technical solutions: an information equipment and storage equipment ledger management system includes database table design, which includes table structure design and trigger design.

[0006] The specific process of table structure design is as follows: according to the classification of information equipment and storage devices in the database, a computer table is established to store information related to computer ledgers; a storage medium table is used to store information related to storage medium ledgers; an external device table is used to store information related to external device ledgers; an office automation equipment table is used to store information related to office automation equipment ledgers; and an audio-visual equipment table is used to store information related to audio-visual equipment ledgers. In addition, corresponding computer log tables, storage medium log tables, external device log tables, office automation equipment log tables, and audio-visual equipment log tables are established for each information equipment and storage device data table to store data on information changes in different types of equipment. The specific process of trigger design is: based on the computer table, storage media table, external device table, office automation equipment table, and audio-visual equipment table, new and updated triggers are established to realize log records in the information equipment and storage equipment ledgers.

[0007] The above-mentioned information equipment and storage equipment ledger management system also includes program design, which is divided into interface design and program development. The entire interface is composed of three parts. The table header is divided into a menu bar, which displays the device category. The left part displays different numbers according to the device category selected in the menu bar. The right part displays detailed information according to the selected device number. Program development includes the generation of equipment number directory tree structure, maintenance page for information equipment, report summary and ledger query; (1) Generate a device number directory tree structure: When the page is displayed, first obtain the device category selected by the user as the root node of the directory tree, and then obtain the device number of this category from this category data table and display it in a tree structure; (2) Maintenance page for information equipment: On the maintenance page, the equipment administrator can add, modify, and query equipment; (3) Report summary: including equipment ledger summary table and equipment ledger detailed table. The equipment ledger summary table summarizes the number of non-confidential, Internet, confidential, secret, and internal equipment according to equipment category and unit; the equipment detailed table generates detailed ledgers for different equipment categories of each unit; (4) Ledger query: Users can query based on different equipment attributes.

[0008] Based on confidentiality requirements and combined with the actual needs of enterprise computer and other equipment ledger management, this invention develops a B / S structured information equipment and storage equipment ledger management system to achieve daily maintenance status management of computers, storage media, external devices, office automation equipment, etc., and regularly generate various equipment ledger reports. BRIEF DESCRIPTION OF THE DRAWINGS

[0009] Figure 1 Design diagram for database table structure.

[0010] Figure 2 It is the main interface of the information equipment and storage equipment inventory management system.

[0011] Figure 3 Summarize reports for information devices and storage devices. DETAILED DESCRIPTION

[0012] Based on the enterprise confidentiality requirements and the actual needs of enterprise computer and other equipment ledger management, this paper develops an information equipment and storage equipment ledger management system using a B / S structure. Its main functions are as follows: 1) Implement ledger management for computers, external devices, office automation equipment, storage media, and other equipment. Based on confidentiality requirements, it also generates reports such as the summary of the general ledger and detailed equipment ledgers for each unit. 2) To further ensure the accuracy of data and accountability, the system provides a log recording function for computer and other equipment ledger management operations, recording the ledger change process and ensuring the accuracy and effectiveness of information; 3) In order to facilitate users to quickly and accurately retrieve information on the inventory of computers and other equipment in their daily work, a general inventory information query function has been developed. Users can freely combine query conditions according to actual needs, so as to quickly and accurately find the current status information of equipment in the equipment library and its historical change process information.

[0013] Information equipment and storage equipment management systems include database table design and program design.

[0014] Database table design 1) Table structure design Based on the classification of devices in the database, we established the following tables: JiSJ (Computer table: used to store information related to computer ledgers), CunCJZ (Storage medium table: used to store information related to storage medium ledgers), WaiBSB (External device table: used to store information related to external devices such as printers), BanGZDHSB (Office automation equipment table: used to store information related to office automation equipment such as card readers and all-in-one computers), and ShengXSB (Audio-visual equipment table: used to store information related to audio-visual equipment such as cameras, projectors, smart TVs, and dedicated monitors). Furthermore, corresponding tables for computer logs, storage medium logs, external device logs, office automation equipment logs, and audio-visual equipment were established for each device data table to store data related to changes in different types of device information.

[0015] 2) Trigger design Based on the JiSJ, CunCJZ, WaiBSB, BanGZDHSB, ShengXSB and other tables, new and update triggers are established to realize log records in the equipment ledger.

[0016] Programming 1) Interface design The entire interface of this system consists of three parts. The table header is divided into a menu bar (displaying the device category). The left part displays different numbers according to the device category selected in the menu bar, and the right part displays detailed information according to the selected device number.

[0017] 2) Program Development The program development of this system focuses on four aspects: equipment number directory tree structure generation, equipment maintenance page, report summary and ledger query. The following mainly explains the program development of these four aspects.

[0018] (1) Generate a device number directory tree structure description. When the page is displayed, first obtain the device category selected by the user as the root node of the directory tree, and then obtain the device number of this category from this category data table and display it in a tree structure.

[0019] (2) Equipment maintenance page. The maintenance page is mainly used by equipment administrators to add, modify, and query equipment. During program development, in order to make administrator operations more convenient and simple, an intelligent search function was developed for units, models, brands, system categories, confidential attributes, usage, etc. That is, when users enter this information, they can directly click on the link to display the data saved in the ledger for selection.

[0020] (3) Report summary. This section mainly includes the equipment ledger summary table and the equipment ledger detailed table. The equipment ledger summary table mainly summarizes the number of various types of information equipment, such as non-confidential, Internet, confidential, secret, and internal, according to equipment category and unit; the equipment detailed table mainly generates ledger details for different equipment categories in each unit.

[0021] (4) Ledger Query. This module is mainly designed to facilitate users to query based on different equipment attributes. This query is relatively flexible. Even if new equipment categories are added to the backend database, the module content does not need to be changed and can still be queried directly. Users can query the backend data in real time by adding their own query conditions and can export the query results to Excel.

[0022] The system of the present invention realizes the change information management of computers, external devices, office automation equipment, storage media and other equipment from the beginning of use to the final scrapping; uses database triggers to realize the recording of various operation logs in the process of information equipment ledger management; and according to the requirements of confidentiality qualification recognition standards, realizes the automatic generation of a general ledger and detailed tables and summary tables of each unit's ledger.

[0023] Through the information management of computer and other equipment ledgers, the difficulty of ledger maintenance is reduced, the efficiency of ledger information query is improved, the search for historical operation records of ledger management is facilitated, and the semi-annual ledger verification work is simplified. At the same time, the time for information equipment ledger verification and data preparation in the early stage of risk assessment and military confidentiality qualification certification is greatly reduced.

[0024] Different operating interfaces are provided for different types of equipment management due to their different device attributes, especially in the report generation interface. When adding new equipment categories in the later stage, there is no need to modify the report interface or change the program. The new equipment category information can be automatically extracted to generate a summary table, which greatly reduces the workload of modifying the program, simplifies the program scale, and improves the accuracy, applicability and simplicity of the program.

Claims

1. Information equipment and storage equipment ledger management system, characterized by: Including database table design, database table design includes table structure design and trigger design, The specific process of table structure design is as follows: according to the classification of information equipment and storage devices in the database, a computer table is established to store information related to computer ledgers; a storage medium table is used to store information related to storage medium ledgers; an external device table is used to store information related to external device ledgers; an office automation equipment table is used to store information related to office automation equipment ledgers; and an audio-visual equipment table is used to store information related to audio-visual equipment ledgers. In addition, corresponding computer log tables, storage medium log tables, external device log tables, office automation equipment log tables, and audio-visual equipment log tables are established for each information equipment and storage device data table to store data on information changes in different types of equipment. The specific process of trigger design is: based on the computer table, storage media table, external device table, office automation equipment table, and audio-visual equipment table, new and updated triggers are established to realize the log recording of information equipment and storage equipment ledgers.

2. The information equipment and storage equipment inventory management system according to claim 1, characterized in that: It also includes programming, which is divided into interface design and program development. The entire interface is composed of three parts. The table header is divided into a menu bar, which displays the device category. The left part displays different numbers according to the device category selected in the menu bar. The right part displays detailed information according to the selected device number. Program development includes the generation of equipment number directory tree structure, equipment maintenance page, report summary and ledger query; (1) Generate a device number directory tree structure: When the page is displayed, first obtain the device category selected by the user as the root node of the directory tree, and then obtain the device number of this category from this category data table and display it in a tree structure; (2) Equipment maintenance page: On the maintenance page, the equipment administrator can add, modify, and query equipment; (3) Report summary: including equipment ledger summary table and equipment ledger detailed table. The equipment ledger summary table summarizes the number of non-confidential, Internet, confidential, secret, and internal equipment according to equipment category and unit; the equipment detailed table generates detailed ledgers for different equipment categories of each unit; (4) Ledger query: Users can query based on different equipment attributes.

Images