A method, device, equipment and medium for integrated display of access records of multi-brand access control

Abstract

The present invention provides a method, device, equipment and medium for integrating and displaying access records of multi-brand access control systems, belonging to the technical field of multi-brand access control integration, and the method comprises the following steps: exporting access records from access control systems of different brands and converting them into a unified target format; analyzing the exported access records of access control systems of various brands, identifying and extracting common fields, eliminating difference fields, and obtaining unified record content and format; defining the display form and database structure of the display platform according to the unified record content and format; obtaining the real-time access records of access control systems of various brands, and automatically importing them into the database of the display platform after processing; displaying the access records of access control systems of various brands in the database through the pages of the display platform, and optimizing the pages. The present invention realizes the unified management of access records of multi-brand access control systems, avoids the tediousness of managers logging into multiple systems for querying separately, and improves management efficiency.

Description

Background Art

[0002] Access control systems are widely used as an important part of security management in various office spaces, residential areas and commercial facilities. However, due to the large number of access control manufacturers, different brands of access control systems use different technical standards and protocols, which makes it difficult for access control systems to be interconnected. Specifically, the current status of different brands of access control systems is that each access control system is independently networked and cannot access and share data with each other, which not only increases management costs, but also limits the overall efficiency and intelligence level of the access control system.

[0003] At present, different brands of access control systems have various recording methods, inconsistent recording contents, and different display methods. When regulatory authorities need to view the access records of multiple access control systems, they have to log in to each access control system separately and query them one by one, which is inefficient and prone to errors. In addition, due to the lack of unified data standards for access control systems of different brands, data integration and analysis have become extremely difficult, and cannot provide strong data support for security management.

[0004] In summary, since access control systems of multiple brands are not interoperable, it is impossible to display the records of all access control systems on a unified display platform at the same time, resulting in waste of various resources, information asynchrony and single function.

[0005] This is a shortcoming of the prior art. Therefore, in view of the above-mentioned defects in the prior art, it is very necessary to provide a method, device, equipment and medium for integrating and displaying access records of multi-brand access control systems. Summary of the invention

[0006] In view of the fact that the above-mentioned multi-brand access control systems are not interoperable, it is impossible to simultaneously display the records of all access control systems on a unified display platform, resulting in waste of various resources, information asynchrony and single functional defects. The present invention provides a multi-brand access control access record integrated display method, device, equipment and medium to solve the above-mentioned technical problems.

[0007] In a first aspect, the present invention provides a method for integrating and displaying access records of multi-brand access control systems, comprising the following steps:

[0008] S1. Export access records from access control systems of different brands and convert each access record into a unified target format;

[0009] S2. Analyze the exported access records of various brands of access control systems, identify and extract the common fields of each access record, remove the difference fields, and obtain a unified record content and format;

[0010] S3. Define the display form and database structure of the display platform according to the unified record content and format;

[0011] S4. Obtain the real-time access records of each brand's access control system, standardize them according to a unified record format, and automatically import them into the database of the display platform;

[0012] S5. The access records of the access control systems of various brands in the database are displayed through the page of the display platform, and the page is optimized.

[0013] Furthermore, the specific steps of step S1 are as follows:

[0014] S11. Determine the access control systems of various brands whose access records are to be displayed, and determine that the target format is xlsx;

[0015] S12. Export the access records of each access control system and identify the file format of each access record;

[0016] If the file format is xlsx, go to step S2;

[0017] If the file format is csv, go to step S13;

[0018] S13. Use the pandas library tool of Python to read the access records in csv format and save them as an Excel file in xlsx format.

[0019] Furthermore, the specific steps of step S2 are as follows:

[0020] S21. Obtain access records of access control systems of different brands in the target format and identify each field;

[0021] S22. Identify fields with the same meaning in different access records and record the remaining fields;

[0022] S23. Analyze the meaning of the remaining fields in different access records to determine whether the meaning of the same remaining fields in different access records has a hierarchical subordination relationship;

[0023] If yes, go to step S24;

[0024] If not, proceed to step S25;

[0025] S24. The two remaining fields with hierarchical subordination are retained with the highest level, and the process proceeds to step S26;

[0026] S25. Delete the remaining fields;

[0027] S26. Integrate fields with the same meaning and the remaining reserved fields into a unified record content and format.

[0028] Furthermore, the specific steps of step S26 are as follows:

[0029] S261. Select any format of the fields with the same meaning as the record format;

[0030] S262. Select the format used by the remaining fields to be retained as the record format;

[0031] S263. Integrate the fields with the same meaning and the remaining reserved fields to obtain a unified record content, and determine the record format as the unified record format.

[0032] Furthermore, the specific steps of step S3 are as follows:

[0033] S31. Obtain the display requirements of the display platform;

[0034] S32. Select a field from the unified record content as the required field according to the display requirements, and determine the attributes and size of the required field according to the unified record format;

[0035] S33. Design the database structure of the display platform according to the required fields, their attributes and sizes;

[0036] S34. Determine the display format according to the functional requirements of the display platform, the display format includes a real-time monitoring interface, a historical access record query interface and a statistical interface;

[0037] S35. Establish associations between each interface and the database structure.

[0038] Furthermore, the specific steps of step S4 are as follows:

[0039] S41. Obtain the real-time access records of each brand of access control system, and identify the fields in the database that have corresponding relationships in the access records;

[0040] S42. Determine whether the format of the identified field is the same as the corresponding required field;

[0041] If yes, go to step S44;

[0042] If not, proceed to step S43;

[0043] S43. Convert the record format of the identified fields in the access record according to the format of the required fields in the database;

[0044] S44. Filter out the newly added record content corresponding to the identified fields from the access records and import it into the database of the display platform.

[0045] Furthermore, the specific steps of step S5 are as follows:

[0046] S51. After the display platform responds to the login request of the management user, it enters the real-time monitoring interface by default;

[0047] S52. Filter out the access records within the set time range from the current time period, and display them in the real-time monitoring interface in accordance with the preset display mode;

[0048] S53. When the query request of the management user is identified, the historical access record query interface is started, and the query condition corresponding to the demand field entered by the management user is used to query the historical access record;

[0049] S54. Respond to the management user to prioritize the historical access records queried based on the selected demand field;

[0050] S55. When the statistical request of the management user is recognized, the statistical interface is started, and the preset statistical quantities are displayed in a graphical form according to a preset display report.

[0051] In a second aspect, the present invention provides an access record integrated display device for multi-brand access control, comprising:

[0052] The access record export and format conversion module is used to export access records from access control systems of different brands and convert each access record into a unified target format;

[0053] The module for exporting unified record content and format is used to analyze the exported access records of various brands of access control systems, identify and extract the common fields of each access record, remove the difference fields, and obtain unified record content and format;

[0054] The display platform definition module is used to define the display form and database structure of the display platform according to the unified record content and format;

[0055] The access record content import module is used to standardize the access records of various brands of access control systems according to a unified record format and import them into the database of the display platform;

[0056] The access record display module is used to display the access records of access control systems of various brands in the database through the page of the display platform and optimize the page.

[0057] In a third aspect, the present invention provides an electronic device, including a processor and a memory;

[0058] The memory is used to store a computer program, and the processor is used to call and run the computer program from the memory, so that the electronic device executes the method described in the first aspect above.

[0059] In a fourth aspect, the present invention provides a storage medium,

[0060] The storage medium stores instructions, which, when executed on a computer, enable the computer to execute the method described in the first aspect.

[0061] The beneficial effects of the present invention are:

[0062] The access record integration and display method, device, equipment and medium for multi-brand access control provided by the present invention realize unified management and integration of multi-brand access control records by integrating access records of access control systems of different brands, thus avoiding the tediousness of managers logging into multiple systems for query separately and improving management efficiency; through a unified data format and display platform, a basis is provided for the intelligent upgrade of the access control system; a variety of display forms are used to meet the needs of different users.

[0063] It can be seen that compared with the prior art, the present invention has outstanding substantive features and significant progress, and the beneficial effects of its implementation are also obvious. BRIEF DESCRIPTION OF THE DRAWINGS

[0064] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, for ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0065] Figure 1 It is a flow chart of the method for integrating and displaying access records of multi-brand access control systems of the present invention.

[0066] Figure 2 It is a schematic diagram of the access record integration display device of the multi-brand access control system of the present invention. DETAILED DESCRIPTION

[0067] The access record integration and display method of multi-brand access control can be applied to one or more electronic devices, wherein the electronic device is a device that can automatically perform numerical calculations and / or information processing according to pre-set or stored instructions, and its hardware includes but is not limited to microprocessors, application specific integrated circuits (ASIC), programmable gate arrays (FPGA), digital processors (DSP), embedded devices, etc.

[0068] An electronic device may be any electronic product that can interact with a user, such as a personal computer, a tablet computer, a smart phone, a personal digital assistant (PDA), an interactive network television (IPTV), etc. The network in which the electronic device is located includes but is not limited to the Internet, a wide area network, a metropolitan area network, a local area network, a virtual private network (VPN), etc.

[0069] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present invention.

[0070] See also Figure 1 The figure shows a method for integrating and displaying access records of multi-brand access control systems in a specific implementation, including the following steps:

[0071] S1. Export access records from access control systems of different brands and convert each access record into a unified target format;

[0072] S2. Analyze the exported access records of various brands of access control systems, identify and extract the common fields of each access record, remove the difference fields, and obtain a unified record content and format;

[0073] S3. Define the display form and database structure of the display platform according to the unified record content and format;

[0074] S4. Obtain the real-time access records of each brand's access control system, standardize them according to a unified record format, and automatically import them into the database of the display platform;

[0075] S5. The access records of the access control systems of various brands in the database are displayed through the page of the display platform, and the page is optimized.

[0076] In this embodiment, the specific steps of step S1 are as follows:

[0077] S11. Determine the access control systems of various brands whose access records are to be displayed, and determine that the target format is xlsx;

[0078] S12. Export the access records of each access control system and identify the file format of each access record;

[0079] If the file format is xlsx, go to step S2;

[0080] If the file format is csv, go to step S13;

[0081] S13. Use the pandas library tool of Python to read the access records in csv format and save them as an Excel file in xlsx format;

[0082] You can also use EXCEL tool software, WORD tool software, etc. to convert csv format to xlsx format;

[0083] The specific steps of step S2 are as follows:

[0084] S21. Obtain access records of access control systems of different brands in the target format and identify each field;

[0085] S22. Identify fields with the same meaning in different access records and record the remaining fields;

[0086] For example, the access records for brand A’s access control system are as follows:

[0087] Timestamp: 2023-04-01 08:00:00, Employee ID: 123, Door ID: FrontDoor, Status: Entered

[0088] Timestamp: 2023-04-01 17:30:00, Employee ID: 123, Door ID: BackDoor, Status: Exited

[0089] The access records of Brand B’s access control system are as follows:

[0090] Time: 2023-04-01T08:00:00, EmployeeNumber: 456, Gate: Entrance, Status: IN

[0091] Time: 2023-04-01T17:30:00, EmployeeNumber: 456, Gate: Exit, Status: OUT

[0092] The timestamp field and the Time field, the employee ID and the EmployeeNumber, and the status and the Status are fields with the same meaning, while the gate number and the Gate are fields with different meanings;

[0093] S23. Analyze the meaning of the remaining fields in different access records to determine whether the meaning of the same remaining fields in different access records has a hierarchical subordination relationship;

[0094] If yes, go to step S24;

[0095] If not, proceed to step S25;

[0096] S24. The two remaining fields with hierarchical subordination are retained with the highest level, and the process proceeds to step S26;

[0097] S25. Delete the remaining fields;

[0098] For example, if the access control system of brand A has a group field and the access control system of brand B has a company field, the group field of brand A's access control system should be selected for unification. The fields with hierarchical affiliation can be unified by determining the group to which the company belongs through the relevant external data table.

[0099] S26. Integrate the fields with the same meaning and the remaining fields into a unified record content and format; the specific steps of step S26 are as follows:

[0100] S261. Select any format of the fields with the same meaning as the record format;

[0101] S262. Select the format used by the remaining fields to be retained as the record format;

[0102] S263. Integrate the fields with the same meaning and the remaining fields to obtain a unified record content, and determine the record format as a unified record format;

[0103] The specific steps of step S3 are as follows:

[0104] S31. Obtain the display requirements of the display platform;

[0105] S32. Select a field from the unified record content as the required field according to the display requirements, and determine the attributes and size of the required field according to the unified record format;

[0106] For example, if the employee ID is purely numeric, use INT, and if it is alphabetic or special characters, use VARCHAR(N), where N is set according to the maximum possible length of the employee ID, such as VARCHAR(20);

[0107] S33. Design the database structure of the display platform according to the required fields, their attributes and sizes;

[0108] S34. Determine the display format according to the functional requirements of the display platform, the display format includes a real-time monitoring interface, a historical access record query interface and a statistical interface;

[0109] S35. Establish association between each interface and database structure;

[0110] The specific steps of step S4 are as follows:

[0111] S41. Obtain the real-time access records of each brand of access control system, and identify the fields in the database that have corresponding relationships in the access records;

[0112] S42. Determine whether the format of the identified field is the same as the corresponding required field;

[0113] If yes, go to step S44;

[0114] If not, proceed to step S43;

[0115] S43. Convert the record format of the identified fields in the access record according to the format of the required fields in the database;

[0116] S44. Filter out the identified fields from the access records and import the newly added record content into the database of the display platform;

[0117] The specific steps of step S5 are as follows:

[0118] S51. After the display platform responds to the login request of the management user, it enters the real-time monitoring interface by default;

[0119] S52. Filter out the access records within the set time range from the current time period, and display them in the real-time monitoring interface in accordance with the preset display mode;

[0120] For example, the real-time monitoring interface can display timestamps, employee IDs, employee names, door changes, and entry and exit status;

[0121] S53. When the query request of the management user is identified, the historical access record query interface is started, and the query condition corresponding to the demand field entered by the management user is used to query the historical access record;

[0122] For example, time range, employee ID, or door number can be used as query conditions;

[0123] S54. Respond to the management user to prioritize the historical access records queried based on the selected demand field;

[0124] S55. When the statistical request of the management user is recognized, the statistical interface is started, and the preset statistical quantity is displayed in a graphical form according to the preset display report;

[0125] For example, access records can be displayed in the form of a table, bar chart, or pie chart.

[0126] It should be understood that the order of execution of the steps in the above embodiment does not mean that the execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiment of the present invention.

[0127] The following is an embodiment of the access record integration and display device for multi-brand access control provided in the embodiments of the present disclosure. The device and the access record integration and display method for multi-brand access control in the above-mentioned embodiments belong to the same inventive concept. For details not fully described in the embodiment of the access record integration and display device for multi-brand access control, please refer to the embodiment of the access record integration and display method for multi-brand access control mentioned above.

[0128] like Figure 2 As shown, the device comprises:

[0129] The access record export and format conversion module is used to export access records from access control systems of different brands and convert each access record into a unified target format;

[0130] The module for exporting unified record content and format is used to analyze the exported access records of various brands of access control systems, identify and extract the common fields of each access record, remove the difference fields, and obtain unified record content and format;

[0131] The display platform definition module is used to define the display form and database structure of the display platform according to the unified record content and format;

[0132] The access record content import module is used to standardize the access records of various brands of access control systems according to a unified record format and import them into the database of the display platform;

[0133] The access record display module is used to display the access records of access control systems of various brands in the database through the page of the display platform and optimize the page.

[0134] The access record integration and display method for multi-brand access control provided by the present invention is a combination of the modules and algorithm steps of each example described in the embodiments disclosed herein, and can be implemented by electronic hardware, computer software, or a combination of the two. In order to clearly illustrate the interchangeability of hardware and software, the composition and steps of each example have been generally described in terms of function in the above description. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to exceed the scope of the present invention.

[0135] Those skilled in the art will appreciate that the various aspects of the access record integration and display method for multi-brand access control provided by the present invention can be implemented as a system, method or program product. Therefore, various aspects of the present disclosure can be specifically implemented in the following forms, namely: a complete hardware implementation, a complete software implementation (including firmware, microcode, etc.), or a combination of hardware and software, which can be collectively referred to as "circuit", "module" or "system" here.

[0136] In the non-transitory computer-readable storage medium storing the access record integration display method of multi-brand access control, it can be but not limited to electrical, magnetic, optical, electromagnetic, infrared, or semiconductor systems, devices or devices, or any combination of the above. More specific examples of readable storage media (non-exhaustive list) include: an electrical connection with one or more wires, a portable disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above.

[0137] Although the present invention has been described in detail with reference to the accompanying drawings and in combination with the preferred embodiments, the present invention is not limited thereto. Without departing from the spirit and essence of the present invention, a person of ordinary skill in the art may make various equivalent modifications or substitutions to the embodiments of the present invention, and these modifications or substitutions shall be within the scope of the present invention. Any person of ordinary skill in the art may easily think of changes or substitutions within the technical scope disclosed by the present invention, and these shall be within the scope of protection of the present invention.

Claims

1. A method for integrating and displaying access records of multi-brand access control systems, characterized in that: The steps include: S1. Export access records from access control systems of different brands and convert each access record into a unified target format; S2. Analyze the exported access records of each brand of access control system, identify and extract the common fields of each access record, remove the difference fields, and obtain a unified record content and format; the specific steps of step S2 are as follows: S21. Obtain access records of access control systems of different brands in the target format and identify each field; S22. Identify fields with the same meaning in different access records and record the remaining fields; S23. Analyze the meaning of the remaining fields in different access records to determine whether the meaning of the same remaining fields in different access records has a hierarchical subordination relationship; If yes, go to step S24; If not, proceed to step S25; S24. The two remaining fields with hierarchical subordination are retained with the highest level, and the process proceeds to step S26; S25. Delete the remaining fields; S26. Integrate the fields with the same meaning and the remaining fields to form a unified record content and format; S3. Define the display form and database structure of the display platform according to the unified record content and format; S4. Obtain the real-time access records of each brand's access control system, standardize them according to a unified record format, and automatically import them into the database of the display platform; S5. The access records of the access control systems of various brands in the database are displayed through the page of the display platform, and the page is optimized.

2. The method for integrated display of access records of multi-brand access control systems as claimed in claim 1, characterized in that: The specific steps of step S1 are as follows: S11. Determine the access control systems of various brands whose access records are to be displayed, and determine that the target format is xlsx; S12. Export the access records of each access control system and identify the file format of each access record; If the file format is xlsx, go to step S2; If the file format is csv, go to step S13; S13. Use the pandas library tool of Python to read the access records in csv format and save them as an Excel file in xlsx format.

3. The access record integration and display method of multi-brand access control as claimed in claim 2, characterized in that: The specific steps of step S26 are as follows: S261. Select any format of the fields with the same meaning as the record format; S262. Select the format used by the remaining fields to be retained as the record format; S263. Integrate the fields with the same meaning and the remaining reserved fields to obtain a unified record content, and use the determined record format as the unified record format.

4. The access record integration and display method of multi-brand access control as claimed in claim 2, characterized in that: The specific steps of step S3 are as follows: S31. Obtain the display requirements of the display platform; S32. Select a field from the unified record content as the required field according to the display requirements, and determine the attributes and size of the required field according to the unified record format; S33. Design the database structure of the display platform according to the required fields, their attributes and sizes; S34. Determine the display format according to the functional requirements of the display platform, the display format includes a real-time monitoring interface, a historical access record query interface and a statistical interface; S35. Establish associations between each interface and the database structure.

5. The access record integration and display method of multi-brand access control as claimed in claim 4, characterized in that: The specific steps of step S4 are as follows: S41. Obtain the real-time access records of each brand of access control system, and identify the fields in the database that have corresponding relationships in the access records; S42. Determine whether the format of the identified field is the same as the corresponding required field; If yes, go to step S44; If not, proceed to step S43; S43. Convert the record format of the identified fields in the access record according to the format of the required fields in the database; S44. Filter out the newly added record content corresponding to the identified fields from the access records and import it into the database of the display platform.

6. The method for integrated display of access records of multi-brand access control systems as claimed in claim 5, characterized in that: The specific steps of step S5 are as follows: S51. After the display platform responds to the login request of the management user, it enters the real-time monitoring interface by default; S52. Filter out the access records within the set time range from the current time period, and display them in the real-time monitoring interface according to the preset display mode; S53. When the query request of the management user is identified, the historical access record query interface is started, and the query condition corresponding to the demand field entered by the management user is used to query the historical access record; S54. Respond to the management user to prioritize the historical access records queried based on the selected demand fields; S55. When the statistical request of the management user is recognized, the statistical interface is started, and the preset statistical quantities are displayed in a graphical form according to a preset display report.

7. A device for implementing the method for integrating and displaying access records of multi-brand access control systems as described in any one of claims 1 to 6, characterized in that: include: The access record export and format conversion module is used to export access records from access control systems of different brands and convert each access record into a unified target format; The module for exporting unified record content and format is used to analyze the exported access records of various brands of access control systems, identify and extract the common fields of each access record, remove the difference fields, and obtain unified record content and format; The display platform definition module is used to define the display form and database structure of the display platform according to the unified record content and format; The access record content import module is used to standardize the access records of various brands of access control systems according to a unified record format and import them into the database of the display platform; The access record display module is used to display the access records of access control systems of various brands in the database through the page of the display platform and optimize the page.

8. An electronic device, characterized in that: including a processor and a memory; The memory is used to store a computer program, and the processor is used to call and run the computer program from the memory, so that the electronic device executes the method described in any one of claims 1 to 6.

9. A storage medium, characterized in that: The storage medium stores instructions, which, when executed on a computer, enable the computer to execute the method described in any one of claims 1 to 6.

Images