CN117575172B - Integrated social management informatization system with multi-level integration - Google Patents
Integrated social management informatization system with multi-level integration Download PDFInfo
- Publication number
- CN117575172B CN117575172B CN202410031673.7A CN202410031673A CN117575172B CN 117575172 B CN117575172 B CN 117575172B CN 202410031673 A CN202410031673 A CN 202410031673A CN 117575172 B CN117575172 B CN 117575172B
- Authority
- CN
- China
- Prior art keywords
- data
- application
- provincial
- module
- level
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 230000010354 integration Effects 0.000 title claims description 6
- 238000010276 construction Methods 0.000 claims abstract description 36
- 238000007619 statistical method Methods 0.000 claims abstract description 21
- 238000007726 management method Methods 0.000 claims description 75
- 238000000034 method Methods 0.000 claims description 58
- 230000008569 process Effects 0.000 claims description 36
- 238000004458 analytical method Methods 0.000 claims description 20
- 238000000586 desensitisation Methods 0.000 claims description 13
- 238000012795 verification Methods 0.000 claims description 9
- 238000004422 calculation algorithm Methods 0.000 claims description 8
- 238000004364 calculation method Methods 0.000 claims description 6
- 238000013500 data storage Methods 0.000 claims description 6
- 230000008520 organization Effects 0.000 claims description 6
- 230000036541 health Effects 0.000 claims description 3
- 238000011272 standard treatment Methods 0.000 claims description 3
- 230000009466 transformation Effects 0.000 abstract description 2
- 230000000007 visual effect Effects 0.000 abstract 2
- 238000011278 co-treatment Methods 0.000 abstract 1
- 238000012545 processing Methods 0.000 description 6
- 208000025174 PANDAS Diseases 0.000 description 3
- 208000021155 Paediatric autoimmune neuropsychiatric disorders associated with streptococcal infection Diseases 0.000 description 3
- 240000004718 Panda Species 0.000 description 3
- 235000016496 Panda oleosa Nutrition 0.000 description 3
- 125000004122 cyclic group Chemical group 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000008676 import Effects 0.000 description 2
- 238000003032 molecular docking Methods 0.000 description 2
- 230000004044 response Effects 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 1
- 230000004931 aggregating effect Effects 0.000 description 1
- 238000012550 audit Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000011835 investigation Methods 0.000 description 1
- 210000001503 joint Anatomy 0.000 description 1
- 239000000758 substrate Substances 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- 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/26—Visual data mining; Browsing structured data
-
- 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/30—Authentication, i.e. establishing the identity or authorisation of security principals
- G06F21/31—User authentication
- G06F21/32—User authentication using biometric data, e.g. fingerprints, iris scans or voiceprints
-
- 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
-
- 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
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/10—Services
- G06Q50/26—Government or public services
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Computer Security & Cryptography (AREA)
- Strategic Management (AREA)
- Computer Hardware Design (AREA)
- General Health & Medical Sciences (AREA)
- Tourism & Hospitality (AREA)
- Software Systems (AREA)
- Health & Medical Sciences (AREA)
- Economics (AREA)
- Bioethics (AREA)
- General Business, Economics & Management (AREA)
- Marketing (AREA)
- Entrepreneurship & Innovation (AREA)
- Educational Administration (AREA)
- Development Economics (AREA)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- Primary Health Care (AREA)
- Operations Research (AREA)
- Game Theory and Decision Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides an integrated social management informatization system with multiple layers of unified components, which is characterized in that a social management database module, a business application module, a multi-level user module, a data security module, a data calling module and a statistical analysis module are arranged to provide construction and access capability of each business application and realize data intercommunication and business coordination; the business application layer comprises self-built provincial common application, access provincial special application and access urban special application, supports the business work of provincial, urban, street village and town, community (village) and grid member multi-level daily social management, compacts the basic-level social management capability for accelerating the transformation of government, explores the basic-level management full-period management, constructs a basic-level social management new mode of co-building co-treatment sharing to provide assistance, thereby better making policies and taking measures to deeply mine and analyze data, simultaneously presents the data in a visual mode, and makes complex data become visual and easy to understand through a chart display form.
Description
Technical Field
The invention relates to the technical field of convenience service and urban management, in particular to an integrated social management informatization system combining multi-level statistics.
Background
The social management informatization platform adopts an innovative working concept, relies on a social management gridding management center, and along with the continuous promotion of urban management, the basic social management is not only subject to opportunities, but also meets unprecedented challenges. The expansion of the basic social treatment scope, the increase of the difficult problems of the basic social treatment and the increasing diversification of the requirements of common people force the basic social treatment to be innovated and transformed. In order to improve the basic-level treatment capacity, enrich basic-level working force, optimize grid management service, strengthen big data intelligent application, give authority to give energy to the basic-level, "reduce load and decompress", better provide support for basic-level social treatment by utilizing digital technology, and provide accurate, convenient and efficient information service for full basic-level treatment.
In exploring social governance practices, social governance informatization platforms built in each province are often the model of province-urban area hierarchical construction: the provincial platform is a statistical analysis summarizing platform and is used for supporting business application of urban platform self-construction of each urban classification. The hierarchical construction mode needs each urban area to establish an informationized platform by itself, each information system needs fund support, after establishment, the information system needs to be in butt joint with the provincial platform, the workload is large, the application is single, the management is inconvenient, and most users are single-level users. The informatization system simply built by the provincial level system often has a set of system which can not completely adapt to the situation of full-province business application due to different urban areas, and some business applications of urban area features can not be realized in the system. Therefore, a set of integrated social management system needs to be built in the whole province range, so that unified management of the whole province social management service is realized under the concept of 'system', and daily management service is carried out by supporting all levels of social management related staff in the whole province; and the access of the special application of each urban area can be realized under the concept of 'division'.
Disclosure of Invention
The invention provides an integrated social treatment informatization system with multiple layers of integral combination, which is comprehensively applied in the whole province range, covers various whole province common application and various urban characteristic application of the social treatment field, supports all layers of social treatment staff in the whole province to develop treatment business, and provides assistance for accelerating the transformation of government functions, compacting the social treatment capacity of a base layer, exploring the whole period management of the base layer and constructing a new mode of the base layer social treatment shared by co-construction.
In order to solve the above-mentioned purpose, the technical scheme provided by the invention is as follows:
an integrated social management informatization system with multiple layers of unified components comprises a social management database module, a platform supporting module, a business application module, a multi-level user module, a data security module, a data calling module and a statistical analysis module; the social management database module is used for converging social management business data, including people, houses, events and organization data; the platform supporting module is used for collecting all supporting platform functions, business applications, user use, data storage and the like into one layer; the business application module is used for constructing the commonality application in the provincial range, and evaluating the application quality coincidence coefficient in the provincial range; the multi-level user module is used for collecting and managing the management event data in the jurisdiction, evaluating the quality of the management event data and evaluating the quality coincidence coefficient of the management event data; the data security module is used for controlling, coordinating and managing the use security of the platform database data, evaluating the security of the platform database data and evaluating the security index of the platform database data; the data calling module is used for carrying out custom calling on the treatment event data and controlling calling fields and calling times; the statistical analysis module is used for carrying out statistical report analysis and comprehensive report display on the treatment event.
Optionally, the specific process of aggregating social administration business data, including people, rooms, events, and organization data, is as follows: event data of the types of public information, medical health, public education, social security, urban management and public safety reported and handled by the collection of gridding members, citizens and departments at all levels are written by using JavaScript, and the script is stored in a database, and related data or data service is provided in a form of a library table or an interface for comparison and analysis to form a social treatment database.
Optionally, the specific process of integrating all support platform functions, business applications, user use and data storage into one layer is as follows: the business application layer gathers all self-built applications, accessed applications, applications used in the whole province range and applications used in urban area level features into one layer, and the multi-level user layer gathers provinces, urban areas, streets, villages, communities (villages) and grid members of the using platform into one layer.
Optionally, the specific process of evaluating the application quality coincidence coefficient in the construction provincial range is as follows: common applications within the construction provincial scale include: the method comprises the steps of self-building provincial level commonality application, accessing provincial level special application and accessing urban area level special application; the self-built provincial commonality applications include: unit a, unit b, unit c, unit d, and unit e; the access provincial special application comprises: unit 1, unit 2, unit 3 and unit 4; accessing urban level feature applications includes: unit one, unit two and unit three; defining three list variables which are respectively used for storing a self-built provincial commonality application index, an access provincial special application index and an access urban characteristic application index; the calculation formula for estimating the application quality coincidence coefficient in the construction provincial range is as follows:
in the method, in the process of the invention,indicating the quality of application in the construction provincial scale according to the coefficient, < ->Indicating access provincial special application index, +.>Represents a self-established provincial commonality application index, < >>Indicating an access urban level feature application index, +.>Weight factor representing the application quality coincidence coefficient within the range of the access provincial level application index corresponding to the construction provincial level>Weight factor representing the application quality coincidence coefficient within the range of the corresponding construction province of the self-construction province-level commonality application index, +.>Weight factor representing the application quality coincidence coefficient within the range of the corresponding construction province of the application index of the access urban level feature, < ->，/>Representing natural constants.
Optionally, the specific process of collecting and managing intra-jurisdictional administration event data is as follows: connecting MySQL social governance database to create a cursor object comprising: provincial level users, urban level users, street village level users, community (village) level users, and grid member users, create a treatment event data field statement, collect treatment event data, insert the treatment event data field into a social treatment database, and query treatment event information in the social treatment database according to conditions
Optionally, the specific process of evaluating the quality of the abatement event data and estimating the quality compliance coefficient of the abatement event data is as follows: reading a CSV file of the composition_data.csv, storing the data in a data variable, removing repeated items in the data, filling the missing value into 0, creating a new Boolean type case_match, judging whether the treatment event data is consistent with the standard treatment event data, accumulating to obtain the correct number of the treatment event data fields by counting the number of the values in the case_match type case_match as Ture, evaluating the quality of the treatment event data based on the correct number of the treatment event data fields and the total field number of the treatment event data, and evaluating the quality coincidence coefficient of the treatment event data; the calculation process of the quality coincidence coefficient of the treatment event data is as follows:
in the method, in the process of the invention,representing a quality compliance factor for the abatement event data, +.>Indicating the total field number of the abatement event data, +.>Indicating the correct number of data fields for a abatement event, +.>Permissible value representing the number of errors in the data field of the abatement event,/->Representing natural constants.
Optionally, the specific process of controlling, coordinating and managing the safety of the database data of the platform is as follows: importing a face recognition algorithm, an encryption algorithm and log records, initializing an application program, repairing the problems in a deployment environment using a reverse proxy by using the middleware, encrypting information to be processed, desensitizing the information to be processed, defining a log_operation function, recording a user operation log, carrying out identity verification on an interface needing face recognition verification, defining a data access interface, acquiring user id and data, respectively encrypting, desensitizing and watermarking the data, recording the data access operation of a user, and acquiring the desensitization degree of the information to be processed and the encryption density of the information to be processed.
Optionally, the formula of the data security index of the estimation platform database is as follows:
in the method, in the process of the invention,representing the platform database data security index, +.>Indicating the degree of desensitization of the information to be processed, +.>Representing the density of the information to be processed,/->Weight factor representing the data security index corresponding to the degree of desensitization of the information to be processed, < >>Weight factor representing the encryption degree of the information to be processed corresponding to the data security index, +.>。
Optionally, the specific process of calling the treatment event data in a self-defined manner and controlling the calling field and the calling times is as follows: a CSV module importing Python, defining a dictionary list, storing event data, calling the abatement event data to a CSV file, and using a writers function in the CSV module, wherein the function comprises three parameters: the method comprises the steps of opening a file in a writing mode in a function, creating a writer object by using csv. DictWriter, designating a field name, writing data into the file by using a writers method, storing the field name required to be called for managing event data, and calling the event data into the event. Csv file according to the designated field.
Optionally, the specific process of carrying out statistical report analysis and comprehensive report display on the treatment event is as follows: the statistical report analysis comprises event type statistics, high-incidence type problem statistical analysis, high-incidence area statistical analysis and high-incidence period trend analysis; event type statistics: event report number, subject number and transaction number; statistical analysis of high-incidence problems: carrying out statistics ranking on various types of problems, and displaying the category of 5 types of problems before high-speed sending; statistical analysis of high-incidence areas: counting the problems of each region, and displaying the first 5 regions with high problems; trend analysis of high-incidence time periods; counting the events of each period, displaying the occurrence quantity of the problems of each period, and displaying the occurrence quantity in a graph; and (3) comprehensive report display: the CSV module of Python is imported, a CSV format data file is processed, mysql.connector functions are imported to connect with a MySQL social management database, a dictionary list is defined, management event data is stored, comprehensive reports are generated by the management event data, each data list is traversed in the functions, corresponding report rows are generated according to fields of each data item, the report rows are added into a report list, finally the generated comprehensive reports are returned, the management event and service application data are supported by an import platform, the comprehensive reports are generated, the results are stored in report variables, and the generated comprehensive reports are output through for cyclic traversal.
Compared with the prior art, the technical scheme has at least the following beneficial effects:
an integrated social management informatization system with multi-level integration is provided, which can realize comprehensive application in the whole province range on the basis of meeting the needs of the special work of each urban area by arranging a social management database module, a business application module, a multi-level user module, a data security module, a data export module and a statistical analysis module, and covers information of multiple fields and dimensions, thereby better formulating policies and taking measures to deeply mine and analyze data.
An integrated social management informatization system with multiple layers of integration is characterized in that data are visually presented, and complex data are visualized and easy to understand through charts, maps, dynamic display and the like. Therefore, decision makers and managers can be helped to better analyze and read data, discover problems and trends, effectively make decisions and intervenes, realize cross-department and cross-region cooperative linkage, create full-time full scenes of large data universe, and create a new paradigm of urban governance system and governance capability modernization.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required for the description of the embodiments will be briefly described below, and it is apparent that the drawings in the following description are only some embodiments of the present invention, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flow chart of an integrated social management informatization system with multi-level integration according to the present invention.
FIG. 2 is a flow chart of the present invention for estimating the applied quality compliance coefficients in the construction provincial range.
FIG. 3 is a flow chart of the invention for estimating sinking data security indexes of different departments.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention more clear, the technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings of the embodiments of the present invention. It will be apparent that the described embodiments are some, but not all, embodiments of the invention. All other embodiments, which can be made by a person skilled in the art without creative efforts, based on the described embodiments of the present invention fall within the protection scope of the present invention.
Unless defined otherwise, technical or scientific terms used herein should be given the ordinary meaning as understood by one of ordinary skill in the art to which this invention belongs. The terms "first," "second," and the like, as used herein, do not denote any order, quantity, or importance, but rather are used to distinguish one element from another. Likewise, the terms "a," "an," or "the" and similar terms do not denote a limitation of quantity, but rather denote the presence of at least one. The word "comprising" or "comprises", and the like, means that elements or items preceding the word are included in the element or item listed after the word and equivalents thereof, but does not exclude other elements or items. The terms "connected" or "connected," and the like, are not limited to physical or mechanical connections, but may include electrical connections, whether direct or indirect.
It should be noted that "upper", "lower", "left", "right", "front", "rear", and the like are used in the present invention only to indicate a relative positional relationship, and when the absolute position of the object to be described is changed, the relative positional relationship may be changed accordingly.
The invention provides an integrated social management informatization system combining multiple layers of level and fractions aiming at the problems of commonalities such as multiple filling of basic report forms, multiparty filling of data, repeated filling of data and the like based on basic layer field investigation.
As shown in FIG. 1, the embodiment of the invention provides an integrated social management informatization system with multiple layers of unified components, which comprises a social management database module, a platform supporting module, a business application module, a multi-level user module, a data security module, a data calling module and a statistical analysis module; the social management database module is used for converging social management business data, including people, houses, events and organization data; the platform supporting module is used for collecting all supporting platform functions, business applications, user use, data storage and the like into one layer; the business application module is used for constructing the commonality application in the provincial range, and evaluating the application quality coincidence coefficient in the provincial range; the multi-level user module is used for collecting and managing the management event data in the jurisdiction, evaluating the quality of the management event data and evaluating the quality coincidence coefficient of the management event data; the data security module is used for controlling, coordinating and managing the use security of the platform database data, evaluating the security of the platform database data and evaluating the security index of the platform database data; the data calling module is used for carrying out custom calling on the treatment event data and controlling calling fields and calling times; the statistical analysis module is used for carrying out statistical report analysis and comprehensive report display on the treatment event.
Specifically, the specific process of converging social administration business data, including people, houses, events and organization data, is as follows: event data of the types of public information, medical health, public education, social security, urban management and public safety reported and handled by the collection of gridding members, citizens and departments at all levels are written by using JavaScript, and the script is stored in a database, and related data or data service is provided in a form of a library table or an interface for comparison and analysis to form a social treatment database.
In this embodiment, by writing JavaScript script, public information, medical care, public education, social security, city management, public security department data are periodically acquired from each department and stored in a database. This step requires ensuring secure transmission and storage of the data and compliance with associated data protection regulations, and once the data is stored in the municipal administration event social administration database, it is necessary to provide the associated data or data services in the form of a library table or interface. This requires the provision of a unified data access interface and standardized data formats so that other departments or institutions can conveniently obtain the required data.
Specifically, the specific process of integrating all support platform functions, business applications, user use, data storage and the like into one layer is as follows: the business application layer gathers all self-built applications, accessed applications, applications used in the whole province range and applications used in urban area level features into one layer, and the multi-level user layer gathers provinces, urban areas, streets, villages, communities (villages) and grid members of the using platform into one layer.
In this embodiment, the platform support layer comprises: unified social governance database unit: the system is used for converging social management related business data, including data of people, houses, events, organizations and the like; unified subscriber center unit: for managing service user information including provincial level users, urban level users, street and town level users, community (village) level users, and grid member users, etc.; unified login portal unit: the system is used for integrating the self-built provincial common application, accessing provincial special application, accessing urban special application and other application computer end inlets to realize unified portal login; unified mobile terminal unit: the mobile terminal portal is used for integrating applications such as self-built provincial level commonality application, access provincial level special application, access urban area level special application and the like, and unified portal login is realized.
As shown in fig. 2, specifically, the specific procedure for evaluating the application quality compliance coefficient in the construction provincial range is as follows: common applications within the construction provincial scale include: the method comprises the steps of self-building provincial level commonality application, accessing provincial level special application and accessing urban area level special application; the self-built provincial commonality applications include: unit a, unit b, unit c, unit d, and unit e; the access provincial special application comprises: unit 1, unit 2, unit 3 and unit 4; accessing urban level feature applications includes: unit one, unit two and unit three; defining three list variables which are respectively used for storing a self-built provincial commonality application index, an access provincial special application index and an access urban characteristic application index; the calculation formula for estimating the application quality coincidence coefficient in the construction provincial range is as follows:
in the method, in the process of the invention,indicating the quality of application in the construction provincial scale according to the coefficient, < ->Indicating access provincial special application index, +.>Represents a self-established provincial commonality application index, < >>Indicating an access urban level feature application index, +.>Weight factor representing the application quality coincidence coefficient within the range of the access provincial level application index corresponding to the construction provincial level>Weight factor representing the application quality coincidence coefficient within the range of the corresponding construction province of the self-construction province-level commonality application index, +.>Weight factor representing the application quality coincidence coefficient within the range of the corresponding construction province of the application index of the access urban level feature, < ->，/>Representing natural constants.
In this embodiment, the self-built provincial commonality application module: and the common application of the application in the provincial range of the self-construction of the platform. Accessing provincial special application: and the common application is built by each provincial department and applied in the provincial range, and the common application is accessed to the platform in a system docking mode. Accessing urban level feature application: the special application built by each department of the urban area and applied in the range of the urban area is accessed to the platform in a system docking mode. And evaluating the application quality in the construction provincial range, if the application quality coincidence coefficient in the construction provincial range is lower than the threshold value of the application quality coincidence coefficient in the construction provincial range, analyzing the self-construction provincial common application, the access provincial special application and the access urban special application to more accurately find out the application problem, and finding out the problems and defects in the application program, such as: the condition that the performance of the application program is reduced when processing a large amount of data or complex operation, and the compatibility problem of the application program exists on different platforms or devices; the method has the advantages that the situation that part of users cannot normally use the application program is caused, the user experience is poor, the response time delay is long, and analysis and testing are carried out on the functions, the performances, the safety, the reliability and the like of the application program, so that the performances, the stability and the usability of the application program are improved, and the user experience and the satisfaction degree are enhanced.
Specifically, the specific process of collecting and managing intra-jurisdictional administration event data is as follows: connecting MySQL social governance database to create a cursor object comprising: provincial level users, urban level users, street village level users, community (village) level users and grid member users use the statement of creating the management event data field to create the management event data field, collect the management event data, insert the management event data field into the social management database, and inquire the management event information in the social management database according to the conditions.
In this embodiment, mysql.connector functions are used to connect to MySQL social administration database, which provide the functionality to connect and interact with MySQL database; by creating a cursor object cursor, the SQL statement can be executed and the execution result can be obtained. The cursor object is a tool for executing SQL sentences after being connected to the database; a abatement event data table is created using the CREATE TABLE IF NOT EXISTS statement. This statement will check if a table already exists and if not create a table. The management event field comprises a problem source, a reception time, an event type, a problem type, a major class name, a minor class name, a belonging street, a belonging community, a belonging grid, an address description, a problem description, a management unit and a responsibility unit; defining an insert_including_info function for inserting a governance event table into the social governance database, wherein the function can insert relevant information of governance event fields into the governance event table; a query_composition_info function is defined for querying governance events in the social governance database according to the conditions. This function may query the abatement event data table for relevant abatement event information in accordance with specified conditions.
Specifically, the specific process of evaluating the quality of the abatement event data and estimating the abatement event data quality compliance coefficient is as follows: reading a CSV file of the composition_data.csv, storing the data in a data variable, removing repeated items in the data, filling the missing value into 0, creating a new Boolean type case_match, judging whether the treatment event data is consistent with the standard treatment event data, accumulating to obtain the correct number of the treatment event data fields by counting the number of the values in the case_match type case_match as Ture, evaluating the quality of the treatment event data based on the correct number of the treatment event data fields and the total field number of the treatment event data, and evaluating the quality coincidence coefficient of the treatment event data; the calculation process of the quality coincidence coefficient of the treatment event data is as follows:
in the method, in the process of the invention,representing a quality compliance factor for the abatement event data, +.>Indicating the total field number of the abatement event data, +.>Indicating the correct number of data fields for a abatement event, +.>Permissible value representing the number of errors in the data field of the abatement event,/->Representing natural constants.
In this embodiment, a pandas library is imported: the first time a pandas library is introduced, which is a powerful library for data processing and analysis; the CSV file named resistor_data.csv is read using the pd.read_csv function and the data is stored in the data variable. The read_csv function may read the CSV file and convert it to a DataFrame object for pandas; the drop_duplex function is called to remove duplicate entries in the data. This function may delete duplicate rows in the DataFrame; filling the missing values with 0 using a filna function; the filena function may replace the missing value in the DataFrame with the specified value; creating a boolean column case_match: a new boolean column case match is created to determine whether the abatement event data is consistent with the given abatement event data. Specific comparison conditions may require further knowledge or be specified in the code; the correct number of the data fields of the treatment event is obtained in an accumulated mode by counting the number of True values in a case_match column; based on the correct number of the data fields of the treatment event and the total number of the data fields of the treatment event, the quality of the data of the treatment event is evaluated, the problem of data accuracy can be solved, such as data input errors, repeated data and missing data, and inaccurate, incomplete or inconsistent data can be identified, so that the used data is ensured to be accurate, and the accuracy and the reliability of the quality of the data of the treatment event are improved.
Specifically, the specific process of controlling, coordinating and managing the safe use of the platform database data is as follows: importing a face recognition algorithm, an encryption algorithm and log records, initializing an application program, repairing the problems in a deployment environment using a reverse proxy by using the middleware, encrypting information to be processed, desensitizing the information to be processed, defining a log_operation function, recording a user operation log, carrying out identity verification on an interface needing face recognition verification, defining a data access interface, acquiring user id and data, respectively encrypting, desensitizing and watermarking the data, recording the data access operation of a user, and acquiring the desensitization degree of the information to be processed and the encryption density of the information to be processed.
In the embodiment, professional security technologies including access control, transmission encryption, data encryption and the like are adopted to ensure the data security problem when two modules interact, a face_recognment library is firstly introduced for face recognition, a hashlib library is used for encryption algorithm, a logging library is used for log record, a flash library is used for constructing Web application, a CSRFProtect library is used for preventing cross-site request attack, and ProxyFix middleware is used for repairing reverse proxy URL problem; creating a flash application program for processing the request and the response; in a deployment environment, the URL may be modified if a reverse proxy is used. By using ProxyFix middleware, the problem can be repaired, and the URL can be correctly identified; an encryption_data function is written, and the information to be processed is encrypted. The function can realize the encryption function by using some encryption algorithms in the hashlib library, so that the security of data is ensured; a desense_data function is written for desensitizing the information to be processed. Specific desensitization modes may need to be designed according to actual requirements, such as replacement, deletion or blurring of information to be processed; log_operation functions are written for recording user operation logs. The function can record the operation behavior, the time stamp and other relevant information of the user for subsequent audit and tracking; and creating a decorator function face_recovery_required for identity verification of the interface needing face recognition verification. The decorator can conduct face recognition verification before the interface is called, so that only authenticated users can access sensitive data; various data access interfaces are implemented for obtaining the user ID and corresponding data. In the interfaces, operations such as encryption, desensitization treatment, watermarking and the like are carried out on the data so as to protect the security and privacy of the data; and calling a log_operation function in the data access interface, and recording the data access operation of the user. Thus, abnormal operation can be found in time and corresponding processing can be carried out; the degree of desensitization and the density of the information to be processed can be evaluated by analyzing the degree of the information to be processed after desensitization and encryption, so that the effectiveness of the data security measures is judged.
As shown in fig. 3, specifically, the formula for estimating the data security index of the platform database is as follows:
in the method, in the process of the invention,representing the platform database data security index, +.>Indicating the degree of desensitization of the information to be processed, +.>Representing the density of the information to be processed,/->Weight factor representing the data security index corresponding to the degree of desensitization of the information to be processed, < >>Weight factor representing the encryption degree of the information to be processed corresponding to the data security index, +.>。
Specifically, the specific processes of custom calling the treatment event data, controlling the calling field and the calling times are as follows: a CSV module importing Python, defining a dictionary list, storing event data, calling the abatement event data to a CSV file, and using a writers function in the CSV module, wherein the function comprises three parameters: the method comprises the steps of opening a file in a writing mode in a function, then creating a writer object by using a csv. DictWriter, designating a field name, writing data into the file by using a writers method, storing the field name required to be called for managing event data, and calling the event data into the event. Csv file according to the designated field; the writers function in the CSV module is a method in the CSV module for writing multiple rows of data to a CSV file.
In this embodiment, firstly, a CSV module of Python is imported to process a file in CSV format; two dictionary lists are created for storing abatement event data, respectively. Each dictionary represents a piece of data, and key values represent field names and corresponding values; a function named export_data is written, which is used to call data into the CSV file. The function includes three parameters: a data list, a call field list, and an exported file name; inside the export_data function, the file is opened in write mode, and then a writer object is created using csv. The writer object needs to specify a field name, which can be passed to the DictWriter using the export field list as a parameter; the data list is written to the file using the writers method. According to the method, each piece of data is converted into a CSV format according to the appointed field name and written into a file; two lists are created for storing abatement event data and field names to be exported, respectively. These fields can be customized according to the requirements; and calling an export_data function, and exporting the harnessing event data and the harnessing event data to corresponding CSV files according to the designated fields. A separate event. Csv file may be created for each data type.
Specifically, the specific process of carrying out statistical report analysis and comprehensive report display on the treatment event is as follows: the statistical report analysis comprises statistics of the types of the treatment events, statistical analysis of high-incidence problems, statistical analysis of high-incidence areas and trend analysis of high-incidence time periods; event type statistics: the event report number, the managed number and the knot number can be linked with the map; statistical analysis of high-incidence problems: carrying out statistics ranking on various types of problems, and displaying the category of 5 types of problems before high-speed sending; statistical analysis of high-incidence areas: counting the problems of each region, and displaying the first 5 regions with high problems; trend analysis of high-incidence time periods; counting the events of each period, displaying the occurrence quantity of the problems of each period, and displaying the occurrence quantity in a graph; and (3) comprehensive report display: the CSV module of Python is imported, a CSV format data file is processed, mysql.connector functions are imported to connect with a MySQL social management database, a dictionary list is defined, management event data is stored, comprehensive reports are generated by the management event data, each data list is traversed in the functions, corresponding report rows are generated according to fields of each data item, the report rows are added into a report list, finally the generated comprehensive reports are returned, the management event and service application data are supported by an import platform, the comprehensive reports are generated, the results are stored in report variables, and the generated comprehensive reports are output through for cyclic traversal.
In this embodiment, a CSV module and a mysql. Connector module are introduced: the CSV module of Python is firstly imported and used for processing the file in CSV format, and in addition, mysql.connector function is imported to connect with MySQL database resource pool; the CSV module is used for reading and processing the corresponding data files and loading the data into the dictionary list. Each dictionary represents a piece of data, and key values represent field names and corresponding values; connecting to a MySQL database resource pool by using a mysql.connector function to obtain the access right of the related data table; the fields to be displayed can be selected according to requirements, such as a problem source, a reception time, an event type, a problem type, a major class name, a minor class name, a belonging street, a belonging community, a belonging grid, an address description, a problem description, a supervisor unit, a responsibility unit and the like. Adding each report line to a list named report; taking the generated comprehensive report as a return value of the function; and calling an export_report function, inputting treatment event data, generating a comprehensive report and storing the result in a report variable. The report content can be displayed row by row through the comprehensive report generated by for cyclic traversal output.
The following points need to be described:
(1) The drawings of the embodiments of the present invention relate only to the structures related to the embodiments of the present invention, and other structures may refer to the general designs.
(2) In the drawings for describing embodiments of the present invention, the thickness of layers or regions is exaggerated or reduced for clarity, i.e., the drawings are not drawn to actual scale. It will be understood that when an element such as a layer, film, region or substrate is referred to as being "on" or "under" another element, it can be "directly on" or "under" the other element or intervening elements may be present.
(3) The embodiments of the invention and the features of the embodiments can be combined with each other to give new embodiments without conflict.
The present invention is not limited to the above embodiments, but the scope of the invention is defined by the claims.
Claims (5)
1. The integrated social management informatization system with the multi-level integration is characterized by comprising a social management database module, a platform supporting module, a business application module, a multi-level user module, a data security module, a data calling module and a statistical analysis module;
the social management database module is used for converging social management business data, including people, houses, events and organization data;
the platform supporting module is used for integrating all supporting platform functions, business applications, user use and data storage into one layer;
the business application module is used for constructing the commonality application in the provincial range, and evaluating the application quality coincidence coefficient in the provincial range;
the specific process for evaluating the application quality coincidence coefficient in the construction provincial range by using the commonality in the construction provincial range is as follows:
common applications within the construction provincial scale include: the method comprises the steps of self-building provincial level commonality application, accessing provincial level special application and accessing urban area level special application;
the self-built provincial commonality applications include: unit a, unit b, unit c, unit d, and unit e;
the access provincial special application comprises: unit 1, unit 2, unit 3 and unit 4;
accessing urban level feature applications includes: unit one, unit two and unit three;
defining three list variables which are respectively used for storing a self-built provincial commonality application index, an access provincial special application index and an access urban characteristic application index;
the calculation formula for estimating the application quality coincidence coefficient in the construction provincial range is as follows:
；
in the method, in the process of the invention,indicating the quality of application in the construction provincial scale according to the coefficient, < ->Indicating access provincial special application index, +.>Represents a self-established provincial commonality application index, < >>Indicating an access urban level feature application index, +.>Weight factor representing the application quality coincidence coefficient within the range of the access provincial level application index corresponding to the construction provincial level>Weight factor representing the application quality coincidence coefficient within the range of the corresponding construction province of the self-construction province-level commonality application index, +.>Weight factor representing the application quality coincidence coefficient within the range of the corresponding construction province of the application index of the access urban level feature, < ->，/>Representing natural constants;
the multi-level user module is used for collecting and managing the management event data in the jurisdiction, evaluating the quality of the management event data and evaluating the quality coincidence coefficient of the management event data;
the specific process for estimating the quality of the treatment event data according with the coefficient is as follows:
reading a CSV file of the composition_data.csv, storing the data in a data variable, removing repeated items in the data, filling the missing value into 0, creating a new Boolean type column case_match, judging whether the treatment event data is consistent with the standard treatment event data, and accumulating to obtain the correct number of the treatment event data fields by counting the number of the values in the Boolean type column as Ture;
based on the correct number of the treatment event data fields and the total number of the treatment event data fields, evaluating the quality of the treatment event data, and evaluating the quality coincidence coefficient of the treatment event data;
the calculation process of the quality coincidence coefficient of the treatment event data is as follows:
；
in the method, in the process of the invention,representing a quality compliance factor for the abatement event data, +.>Indicating the total field number of the abatement event data, +.>Indicating the correct number of data fields for a abatement event, +.>Permissible value representing the number of errors in the data field of the abatement event,/->Representing natural constants;
the data security module is used for controlling, coordinating and managing the data use security condition of the platform database, evaluating the data security condition of the platform database and evaluating the data security index of the platform database;
the specific process of controlling, coordinating and managing the data use safety condition of the platform database is as follows:
importing a face recognition algorithm, an encryption algorithm and log records, and middleware for preventing libraries of cross-site request attacks and repairing reverse proxy problems;
initializing an application program and repairing a problem in a deployment environment using a reverse proxy by using middleware;
encrypting and desensitizing information to be processed, defining a log_operation function to record a user operation log, and carrying out identity verification on an interface needing face recognition verification;
defining a data access interface, acquiring user id and data, respectively encrypting and desensitizing the data, adding a watermark, recording the data access operation of a user, and acquiring the desensitization degree of information to be processed and the density of the information to be processed;
the formula of the data security index of the estimation platform database is as follows:
；
in the method, in the process of the invention,representing the platform database data security index, +.>Indicating the degree of desensitization of the information to be processed, +.>Representing the density of the information to be processed,/->Weight factor representing the data security index corresponding to the degree of desensitization of the information to be processed, < >>Weight factor representing the encryption degree of the information to be processed corresponding to the data security index, +.>；
The data calling module is used for carrying out custom calling on the treatment event data and controlling calling fields and calling times;
the specific processes of carrying out custom call on the treatment event data and controlling the call field and the call times are as follows:
importing Python's CSV module, defining dictionary list, storing event data, calling the abatement event data to CSV file, using the writers function in CSV module, the writers function including three parameters: a data list, a call field list, and a call file name; opening a file in a writing mode in the writers function, creating a writer object by using csv. DictWriter, designating a field name, writing data into the file by using a writers method, storing the field name required to be called for managing event data, and calling the event data into the event. Csv file according to the designated field;
the statistical analysis module is used for carrying out statistical report analysis and comprehensive report display on the treatment event.
2. The integrated social management information system of claim 1, wherein the aggregate social management business data comprises the following specific processes of people, houses, events and organization data:
event data of public information, medical health, public education, social security, urban management and public security categories reported and handled by the collection of gridmen, citizens and departments at all levels are written by using JavaScript, the script is stored in a database, related data or data service is provided in a form of a library table or an interface, and comparison and analysis are carried out to form a social management database.
3. The integrated social management informatization system of claim 1, wherein the platform support module is configured to aggregate all support platform functions, business applications, user usage, and data storage into one layer as follows:
the platform support module includes: a service application layer and a multi-level user layer;
the business application layer gathers all self-built applications, accessed applications, applications used in the whole province range and applications used in urban area level features into one layer; the multi-level user layer gathers multi-level social management staff using platforms into one layer in provinces, urban areas, streets, villages, communities, villages and grid members.
4. The integrated social management information system of claim 1, wherein the specific process of collecting and managing intra-jurisdictional management event data is as follows:
connecting with MySQL social administration database, creating a cursor object comprising: provincial level users, urban level users, street village level users, communities, villages, level users, and grid member users; creating a harnessing event data field by using the harnessing event data field statement; collecting treatment event data, inserting a treatment event data field into a social treatment database, and inquiring treatment event information in the social treatment database according to conditions.
5. The integrated social management informatization system of claim 1, wherein the specific process of statistical report analysis and comprehensive report presentation of the management event is as follows:
the statistical report analysis comprises event type statistics, high-incidence type problem statistical analysis, high-incidence area statistical analysis and high-incidence period trend analysis;
event type statistics include: counting event report number, subject number and transaction number;
the statistical analysis of the high-incidence problems comprises the following steps: carrying out statistics ranking on various types of problems, and displaying the category of 5 types of problems before high-speed sending;
the high-incidence area statistical analysis comprises the following steps: counting the problems of each region, and displaying the first 5 regions with high problems;
the high-hair period trend analysis includes: counting the events of each period, displaying the occurrence quantity of the problems of each period, and displaying the occurrence quantity in a graph;
the comprehensive report display comprises the following steps: importing a CSV module of Python to process a CSV format data file; importing a mysql.connector function to connect with a MySQL social management database, defining a dictionary list, storing management event data, generating a comprehensive report from the management event data, traversing each data list in the function, generating corresponding report lines according to fields of each data item, and adding the report lines into a report list; and returning the generated comprehensive report, supporting the treatment event and business application data by the input platform, generating the comprehensive report, storing the result in a report variable, and outputting the generated comprehensive report through for cycle traversal.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410031673.7A CN117575172B (en) | 2024-01-09 | 2024-01-09 | Integrated social management informatization system with multi-level integration |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410031673.7A CN117575172B (en) | 2024-01-09 | 2024-01-09 | Integrated social management informatization system with multi-level integration |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN117575172A CN117575172A (en) | 2024-02-20 |
| CN117575172B true CN117575172B (en) | 2024-04-12 |
Family
ID=89884696
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202410031673.7A Active CN117575172B (en) | 2024-01-09 | 2024-01-09 | Integrated social management informatization system with multi-level integration |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117575172B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101526962A (en) * | 2009-04-03 | 2009-09-09 | 成都市华为赛门铁克科技有限公司 | Generation method for security events of database, device and database system |
| CN112614037A (en) * | 2020-12-28 | 2021-04-06 | 博康智能信息技术有限公司 | Command center system for urban social management |
| CN116090856A (en) * | 2022-11-01 | 2023-05-09 | 云赛智联股份有限公司 | Comprehensive treatment information management system |
| CN116932612A (en) * | 2023-07-31 | 2023-10-24 | 杭州元声象素科技有限公司 | Basic society governs intelligent data processing system |
| CN117455379A (en) * | 2023-06-21 | 2024-01-26 | 重庆浪潮政务云管理运营有限公司 | Basic intelligent management system and method |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120066145A1 (en) * | 2010-09-15 | 2012-03-15 | International Business Machines Corporation | Automating A Governance Process Of Reviewing Service Artifacts In A Governed SOA |
-
2024
- 2024-01-09 CN CN202410031673.7A patent/CN117575172B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101526962A (en) * | 2009-04-03 | 2009-09-09 | 成都市华为赛门铁克科技有限公司 | Generation method for security events of database, device and database system |
| CN112614037A (en) * | 2020-12-28 | 2021-04-06 | 博康智能信息技术有限公司 | Command center system for urban social management |
| CN116090856A (en) * | 2022-11-01 | 2023-05-09 | 云赛智联股份有限公司 | Comprehensive treatment information management system |
| CN117455379A (en) * | 2023-06-21 | 2024-01-26 | 重庆浪潮政务云管理运营有限公司 | Basic intelligent management system and method |
| CN116932612A (en) * | 2023-07-31 | 2023-10-24 | 杭州元声象素科技有限公司 | Basic society governs intelligent data processing system |
Non-Patent Citations (1)
| Title |
|---|
| 基于大数据的网格化服务管理信息平台;林欣郁;;中国新通信;20160805(第15期) * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN117575172A (en) | 2024-02-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Templ | Statistical disclosure control for microdata | |
| Mooney et al. | The annotation process in OpenStreetMap | |
| Wand et al. | Anchoring data quality dimensions in ontological foundations | |
| CN110119395B (en) | Method for realizing association processing of data standard and data quality based on metadata in big data management | |
| Schintler et al. | Encyclopedia of big data | |
| CN102067106A (en) | Data quality tracking by determining metric values for child nodes and a parent node | |
| US11989632B2 (en) | Apparatuses, methods, and computer program products for programmatically parsing, classifying, and labeling data objects | |
| CN114428822B (en) | Data processing method and device, electronic equipment and storage medium | |
| Alghushairy et al. | Data storage | |
| Huang | Data processing | |
| Bagga et al. | Big data and its challenges: a review | |
| CN111680083B (en) | Intelligent multi-level government financial data acquisition system and data acquisition method | |
| Halevy et al. | Data Management for Journalism. | |
| Ekaputra et al. | Semantic-enabled architecture for auditable privacy-preserving data analysis | |
| CN117575172B (en) | Integrated social management informatization system with multi-level integration | |
| Musto et al. | Improving data quality, privacy and provenance in citizen science applications | |
| Gonçalves et al. | Revisiting the dataset gap problem–On availability, assessment and perspective of mobile forensic corpora | |
| Hogan | Data center | |
| CN115438024A (en) | Method, device and system for importing data into middle station, electronic equipment and storage medium | |
| M'Baba et al. | Blockchain logging for process mining: a systematic review | |
| Imran et al. | Data Provenance | |
| JP5500859B2 (en) | Environment-related information aggregation and analysis system. | |
| Devátý et al. | An open rainfall-runoff measurement database | |
| CN115423595B (en) | File information processing method and device, computer equipment and storage medium | |
| Musto et al. | Integrating data quality requirements to citizen science application design |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |