CN115510074B

CN115510074B - Distributed data management and application system based on table

Info

Publication number: CN115510074B
Application number: CN202211397077.8A
Authority: CN
Inventors: 陈飞; 刘育川
Original assignee: Chengdu Liaoliao Technology Co ltd
Current assignee: Chengdu Liaoliao Technology Co ltd
Priority date: 2022-11-09
Filing date: 2022-11-09
Publication date: 2023-03-03
Anticipated expiration: 2042-11-09
Also published as: CN115510074A

Abstract

The invention discloses a distributed data management and application system based on a table, which is used for acquiring data of a plurality of ports for sorting and storing and comprises the following steps: the connection module is used for connecting the data ports of a plurality of platforms to perform data access: the storage module is used for locally storing the data transmitted by the connection module; the interaction module generates a fixed interaction interface and provides an online port for the terminal equipment to acquire and display the interaction interface; and the form generation module is used for generating the identity label and the identity index word according to the data submitted by the interactive interface, acquiring the identity index data with the identity index word in the plurality of platforms through the connection module, storing the identity index data in the storage module, analyzing and classifying the data, generating a corresponding information form by using the stored form template, and sending the corresponding information form to the interactive module for display.

Description

Distributed data management and application system based on table

Technical Field

The invention belongs to the technical field of big data, and particularly relates to a distributed data management and application system based on a table.

Background

At present, the community informatization service construction of China is entering a more deep and more solid new stage. Social informatization service demands are strong. The intelligent community service system development strategy explores new development ways of social management, community service and people-friendly industry by integrating key information of street management and service operation, and creates a new modern street work operation mode with accurate management, cultural service, socialized operation, informatization means, standardized work and modernized technology.

The intelligent community integrates various existing service resources of the community by utilizing various intelligent technologies and modes, and provides multiple convenient services such as government affairs, commerce, entertainment, education, medical care, life mutual assistance and the like for the community. From the application direction, the intelligent community can improve the transaction efficiency by intelligent government affairs, improve the life of people by intelligent people, build intelligent life by intelligent families, and improve the community quality by intelligent communities. The intelligent community is a new idea of community management and is a new mode of social management innovation in new situations. The intelligent community fully utilizes the integrated application of new-generation information technologies such as Internet of things, cloud computing and mobile internet, and provides a safe, comfortable and convenient modern and intelligent living environment for community residents, so that a community with a new management form based on informatization and intelligent social management and service is formed. The construction of the intelligent community can effectively promote economic transformation and promote the development of the modern service industry.

In current community service, there are many affairs works, and statistics and collection of community resident information are needed to develop corresponding services. For example, care services for low-security families in the community, care services for disabled persons in the community, employment rewards for college students in the community, subsidies for community unemployed persons, and epidemic prevention works. In these affairs, the conventional process is to fill and provide corresponding certificate documents when residents go to the community office, then the community staff establishes corresponding files, and then the next process is performed according to the file information. Or aiming at residents who have inconvenient actions, community staff can fill information and obtain certification documents at home, so that the efficiency of developing various services under the existing community management system is low. And because the service items of the community are not fixed and can be adjusted according to the change of policies, new service items exist every year, the targeted group also changes, and the information collected every time cannot be used as the next item. By applying the solution of the intelligent community, an informationized management system is established in the community, the service efficiency can be improved, and for the unfixed project, the corresponding function can be realized by adopting the technology of lightweight editing at any time for expanding and adjusting the plate block, namely a low-code platform.

However, when the existing smart community is built, in order to meet the requirement of data storage, a great number of servers are built or leased to build a hardware framework of the cloud platform. The cost is high, and the number of residents in each community is large, as described in the above, the service items of the community change with the change of policy, and each year, there are many new items to be developed, and meanwhile, the emergent events like the epidemic situation can give more functional requirements to the community. In the past, data cannot be deleted generally, the system building requirements of all communities (particularly a two-wire large city) are met, data redundancy is too much due to the fact that the number of servers is increased, building and maintaining costs are too high, and the existing requirements cannot be met.

Disclosure of Invention

In order to solve the problems in the prior art, the invention provides a distributed data management and application system based on one table, and the effect of low data storage capacity can be realized by utilizing the characteristics of community services through optimization and improvement of a system layer, so that the construction and maintenance cost of hardware is reduced, and more information acquisition requirements in the community services can be met.

The technical scheme adopted by the invention is as follows:

in a first aspect, the present invention provides a distributed data management and application system based on one table, which establishes a cloud platform, obtains data of a plurality of external platform ports for sorting and storing, and displays the sorted data in an information table form for a user of the cloud platform, including:

the connection module is used for connecting data ports of a plurality of external platforms to perform data access:

the storage module is used for storing the data transmitted by the connection module in the local server;

the interaction module generates a fixed interaction interface and provides an on-line port for the terminal equipment to acquire and display the interaction interface;

the processing module is used for analyzing and processing the data acquired from other platforms; and

the form generation module generates identity labels and identity index words according to data submitted by the interactive interface, obtains identity index data with the identity index words in a plurality of platforms through the connection module and stores the identity index data in the storage module, and then fills the classified data in a stored form template after analyzing, screening and classifying the data by using the processing module, so that a corresponding information form is generated and sent to the interactive module for display.

The external platform is an external system platform that is linked after the owner of the platform acquires the authority in addition to the external platform, and corresponding data can be acquired through a data port at the back end. Meanwhile, when the link is established, the converter is established according to the language of the corresponding platform, so that the data transmitted by the converter can be translated.

With reference to the first aspect, the present invention provides a first implementation manner of the first aspect, in a single information table generating process, identity index data entered from a connection module is stored in a storage module, and is analyzed and processed by a processing module to cover the data;

the data of the information form generated by the form generation module can be temporarily stored in the storage module, and after the interaction module determines that the data of the information form is sent to a storage address provided by a user after display, the data is deleted after the data is reserved for more than set time.

The data overlay is that after the identity index data of the corresponding user is called by the processing module, the called data is marked to be erased, and other data is written. The processing module writes the sorted and processed data into the storage module, but the stored address is randomly distributed to the erased address, so that the effect of cleaning the data is achieved.

With reference to the first implementation manner of the first aspect, the present invention provides a second implementation manner of the first aspect, where a cache unit is disposed in the storage module, and the cache unit is configured to store compressed information with an identity tag;

the compressed information is source link information of the identity index data in the storage module.

Before a single table is made, the processing module retains and compresses the source connection information into the cache unit when the data is analyzed. And after the form is completed and sent, the cached source connection information is stored in other addresses of the storage module.

With reference to the first implementation manner of the first aspect, the present invention provides a third implementation manner of the first aspect, where a cache unit is disposed in the storage module, and the cache unit is configured to store compressed information with an identity tag;

after the table generating module generates the information table, the processing module erases data which are not utilized by the information table, compresses the data utilized by the information table to form compressed information, and calls the compressed information when the compressed information is viewed for the second time.

With reference to the first implementation manner of the first aspect, the present invention provides a fourth implementation manner of the first aspect, where a cache unit is disposed in the storage module, and the cache unit is configured to store all data for caching when a single table is made;

a semantic analysis model is arranged in the processing module, and after the table generating module generates the information table, the semantic analysis model is used for carrying out semantic analysis on data which are not utilized to obtain the labels of the data of the same information source;

and then respectively reserving the source link information of the utilized and unused identity index data with corresponding labels, compressing the source link information into corresponding compressed information and storing the compressed information in a storage module.

With reference to the first, second, third, or fourth implementation manners of the first aspect, the present invention provides a fifth implementation manner of the first aspect, where the cache unit includes a local cache and an external cache, and the external cache is a storage space separately partitioned in storage media of each platform connected to the connection module;

when the table generating module generates an information table, the table generating module can temporarily store the data with the identity index words transmitted from the plurality of platforms in a local cache and an external cache at the same time, and generate the label information of the transmitted data in the storage space of the corresponding platform; when the information table has no secondary request within the set time, the local cache deletes the stored data with the identity index word;

when the interaction module sends a secondary request to the same identity tag beyond a set time, the table generation module directly calls tag information stored in the storage space of the platforms by the identity tag to quickly acquire a corresponding data generation information table.

With reference to the fifth implementation manner of the first aspect, the present invention provides a sixth implementation manner of the first aspect, where the tag information includes corresponding data node information and a utilized partial feature value of the data, and the table generation module invokes the tag information and analyzes the feature value, and then directly extracts the corresponding data and displays the corresponding data on a corresponding portion of the information table.

With reference to the first aspect, the present invention provides a seventh implementation manner of the first aspect, further including a verification module, where the interaction module sends a repeated form request submitted for a same identity tag, the form generation module invokes index information stored in the storage module under a corresponding identity tag, extracts corresponding data in a corresponding platform according to the index information, compares the extracted corresponding data with data of an information form generated last time, and retains and fills updated data in the corresponding information form for display.

With reference to the first aspect, the present invention provides an eighth implementation manner of the first aspect, further including a user management module, where the user management module performs user registration and identity tag identification.

With reference to the first aspect, the present invention provides a ninth implementation manner of the first aspect, and the platform is applied to information management for community residents in a community service.

The invention has the beneficial effects that:

the platform provided by the invention can link the databases of the service type system platforms existing in the corresponding community or other administrative ranges, and the automatic filling of the form is realized by calling the corresponding data in all the databases, so that the user using the platform can automatically determine the key index information by the platform after directly verifying the corresponding identity information, search the related data in the largest range according to the index information, and automatically generate the information form by using the related data for presentation, thereby providing the most intuitive information query function for the user in the community or the administrative range;

meanwhile, the data after the form is made each time is processed, the made form data is displayed on an interactive page, the complete data of the form is sent to the terminal equipment of a user or a designated storage address, the data is erased, only source link information is reserved as the guiding information of the next form making, and therefore the data quantity index is reduced compared with the difference that other system platforms completely reserve the data, the complete form data can be provided, and the equipment establishing and maintaining cost is reduced;

meanwhile, the system divides the processed identity index data into a currently utilized identity index data and a currently unutilized identity index data, and respectively determines the labels of each group of data, and then reserves the source connection information of a single identity index data or all the identity index data for compression, so that after a single form is made, effective information is reserved according to the requirement, the data processing amount of re-making the form can be reduced, and the processing efficiency is improved;

the invention also can realize data reading and table generation in the whole area only by setting a smaller server by utilizing the database of the prior platform for data caching, thereby having lower construction and maintenance cost.

Drawings

Fig. 1 is an overall system architecture diagram of the present invention.

Detailed Description

The invention is further explained by the following embodiments in combination with the drawings.

In order to make the objects, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are some embodiments of the present application, but not all embodiments. The components of the embodiments of the present application, generally described and illustrated in the figures herein, can be arranged and designed in a wide variety of different configurations.

Thus, the following detailed description of the embodiments of the present application, presented in the accompanying drawings, is not intended to limit the scope of the claimed application, but is merely representative of selected embodiments of the application. All other embodiments obtained by a person of ordinary skill in the art based on the embodiments in the present application without making any creative effort belong to the protection scope of the present application.

It should be noted that: like reference numbers and letters refer to like items in the following figures, and thus, once an item is defined in one figure, it need not be further defined and explained in subsequent figures.

In the description of the present application, it should be noted that if the terms "center", "upper", "lower", "left", "right", "vertical", "horizontal", "inner", "outer", etc. are used for indicating the orientation or positional relationship based on the orientation or positional relationship shown in the drawings or the orientation or positional relationship which is usually placed when the product of the application is used, the description is only for convenience and simplicity, and the indication or suggestion that the referred device or element must have a specific orientation, be constructed in a specific orientation and be operated, and thus, should not be construed as limiting the present application. Furthermore, the appearances of the terms "first," "second," and the like in the description herein are only used for distinguishing between similar elements and are not intended to be construed as indicating or implying relative importance.

Furthermore, the terms "horizontal", "vertical" and the like when used in the description of the present application do not require that the components be absolutely horizontal or overhanging, but may be slightly inclined. For example, "horizontal" merely means that the direction is more horizontal than "vertical" and does not mean that the structure must be perfectly horizontal, but may be slightly inclined.

In the description of the present application, it should also be noted that, unless otherwise explicitly stated or limited, the terms "disposed," "mounted," "connected," and "connected" should be interpreted broadly, e.g., as being fixedly connected, detachably connected, or integrally connected; can be mechanically or electrically connected; they may be connected directly or indirectly through intervening media, or they may be interconnected between two elements. The specific meaning of the above terms in this application will be understood to be a specific case for those of ordinary skill in the art.

Example 1:

the invention provides a distributed data management and application system based on a table, and aims to provide more visual information table display for regional users covered by a platform.

Specifically, the system of the platform is divided into a plurality of modules by functions, and the modules comprise:

the interaction module generates a fixed interaction interface and provides an online port for the terminal equipment to acquire and display the interaction interface;

the processing module is used for analyzing and processing data acquired from other platforms; and

the form generation module is used for generating identity labels and identity index words according to data submitted by the interactive interface, acquiring identity index data with the identity index words in the platforms through the connection module and storing the identity index data in the storage module, and then filling the classified data in a stored form template after analyzing, screening and classifying the data by using the processing module, so that a corresponding information form is generated and sent to the interactive module for display.

In the single information table generating process, the identity index data entering from the connecting module is stored in the storage module, and is analyzed and processed by the processing module to cover the data;

the data of the information form generated by the form generation module are temporarily stored in the storage module, and after the interaction module determines that the data of the information form are sent to a storage address provided by a user after display, the data are deleted after the data are reserved for more than set time.

The platform has two types of user accounts, namely a common user and a management user, wherein the common user can obtain a user interaction interface after login is verified through the interaction interface, and partial permission, namely three functions of form application, form viewing and information, is obtained through the user interaction interface. The management user cannot directly view the report of the common user, but only can export the total data through the table generating module of the system and then view the corresponding data. Meanwhile, the management user can adjust the plates of the whole system, corresponding modules can be added according to the requirements through the application of the low-code platform, and a new primary menu is formed on the interactive interface of a common user.

The form application is to form a form making application to a back-end server through an interaction module, a label of the form application is arranged on a user interaction interface, and a secondary menu of the form application is entered after the label is triggered. The second-level menu is provided with a plurality of labels, each label can enter a corresponding popup process, and the processing is guided step by step through interface information. For example, a new form application, after a series of information submission and verification, the form generation process is performed by the form generation module, and the progress is displayed on the user interaction interface.

In the new form application, various form templates stored in the system can be selected according to requirements, different options can be selected in each form template, and a user can only select a standard template or select additional added items according to the requirements. The system can determine the label of each blank to be filled according to the selected form template to screen and process the identity index data, namely, the identity index data is processed by a processing module and a semantic analysis model arranged in the identity index data is utilized.

Meanwhile, the user who has obtained the form can select the label of the updated form from the secondary menu of the form application and enter the corresponding pop-up window process. If the user who has acquired the form wants to reestablish the form, a new form can be established by updating the form.

The information function is to record the whole operation flow data of the user, the data does not include table data or other related data of each operation, is only used for recording the flow information and time information of each operation, and simultaneously comprises system notification information and the like.

It should be noted that the above modules are all sub-modules of a software system built in the same server, and data thereof are all stored in the same address, and the effect to be achieved is to provide independent data information summary for a plurality of objects in a lightweight data storage manner and to present the summary in the form of a table.

The interactive module is used for displaying the same or similar information and arranged graphical interfaces to different front ends, the different front ends comprise a mobile end, a webpage end, an independent APP, small program forms in each large application program and the like, and the platform can be accessed to carry out data calling after the information is confirmed by logging in through the front end interfaces in various forms.

In one application mode, a cache unit is arranged in a storage module and used for storing compressed information with an identity tag; the compressed information is source link information of the identity index data in the storage module. Before a single table is made, the processing module retains and compresses the source connection information into the cache unit when the data is analyzed. And after the form is completed and sent, the cached source connection information is stored in other addresses of the storage module. (all links to source information are preserved)

The storage module is a data storage area separately defined in the server, and is a place for storing data except for the system, and the capacity of the storage module is the largest. The total amount of data such as the data of the server and generated logs is controllable, the data can be cleaned and updated regularly, and the storage capacity of the server is small.

In this embodiment, the cache unit itself is not an independent hardware structure, does not have different hardware parameters from other storage media, and is only a reference to a dedicated storage area, and the location of the cache unit is not fixed, and data can be erased and written in different areas, but the cache unit has a fixed encoding format.

After the table generating module generates the information table, the data which is not utilized by the information table is deleted through the storage module, and the source link information of the data utilized by the information table is compressed to form compressed information, so that the compressed information is convenient to call when the information table is checked for the second time.

The compressed information is stored in the cache unit in the table generating process, when the table is generated and is checked by a user without errors, the part of the compressed information stored in the cache unit is directly stored in the storage module for fixed storage, and because only the link information is used and pictures or other larger data size is not reserved, the data of a single compressed table is only counted by byte number, and even if the number of users in the community is large, a small number of servers can meet the requirements.

Or, the cache unit is used for storing the compressed information with the identity tag; after the table generating module generates the information table, the data which is not utilized by the information table is erased through the processing module, the data utilized by the information table is compressed to form compressed information, and the compressed information is called when the information table is checked for the second time. (information used is stored only)

Or, the cache unit is used for caching all data when making a single table;

and then respectively reserving the source link information of the identity index data which is utilized and not utilized with corresponding labels, compressing into corresponding compressed information and storing in a storage module.

The method is to keep original information of all data, but perform tagging processing on each data, wherein tags of the utilized data are utilized, and the data which are not utilized are core keywords of the information judged through a semantic analysis model, the keywords are used as index tags to be stored together with data source link information of the data, whether the new table needs to be adopted is judged again according to the stored core keywords after the new table is updated when the table is made next time, then indexing is performed according to the data indexed last time, the data is acquired by combining the new keywords and then returned for processing, so that the data volume of the re-made table is reduced, and the information accuracy is improved.

It should be noted that when the processing module determines the correlation according to the algorithm, part of the data cannot be used because the data is the sum of the data searched from each large platform by the identity index, but the data including the identity tag is not related to the corresponding item in the table. For example, shopping information on a certain online shopping platform requires a user to count online shopping data of each large platform, and each platform cannot directly utilize interactive data, such as purchase heart, evaluation and chat data shared by the user on the platform, in addition to the online shopping data. However, when the next table is made, the user may adjust part of the items or sub-items, if there is a difference between the data to be acquired in the newly added column in the table and the data acquired last time, the tags of the data which is not utilized in the last retrieval are retained for fast screening, and the relevance of the information can be determined first, so that the data can be directly acquired from the corresponding platform through the source link information in a targeted manner.

Furthermore, the cache unit comprises a local cache and an external cache, wherein the external cache is a storage space which is separately partitioned from storage media of each platform connected with the connection module; when the table generation module generates an information table, data with identity index words transmitted from a plurality of platforms are temporarily stored in a local cache and an external cache at the same time, and tag information of the transmitted data is generated in a storage space of a corresponding platform; when the information table has no secondary request within the set time, the local cache deletes the stored data with the identity index word;

and when the interaction module makes a secondary request for the same identity tag beyond the set time, the table generation module directly calls tag information stored in the storage spaces of the platforms by the identity tag to quickly acquire corresponding data generation information tables.

Furthermore, the tag information comprises corresponding data node information and a part of characteristic values of the data, and the table generation module calls the tag information, analyzes the characteristic values, directly extracts the corresponding data and displays the corresponding data on a corresponding part of the information table.

The interactive module sends a repeated form request submitted by aiming at the same identity tag, the form generation module calls the index information stored under the corresponding identity tag in the storage module, corresponding data in the corresponding platform is quickly extracted according to the index information and is compared with the data of the information form generated last time, and the updated data is reserved and filled in the corresponding information form for display.

Further, user registration and identification tag identification are performed through the user management module.

The embodiment also discloses a method for processing data by using the platform, firstly, based on the identity information submitted by the object in the online system, the system analyzes and determines the identity label and the identity index word of the object;

searching and acquiring related source data containing the identity index words on a plurality of platforms by the system according to the identity index words, and summarizing the source data into the system;

performing semantic analysis on the source data through the system, and printing corresponding keywords on the analyzed data;

and respectively determining corresponding keywords according to the items of the stored form template in the system, and linking the data with the same keywords with the corresponding items in the form template to generate and display an information form of the object.

As described in the above embodiments, storage units are provided in the storage media of the connected platforms, and a cache unit is provided in the system; when data retrieval is carried out according to the identity index words of the objects, the retrieved data in the corresponding platform are stored in the storage unit of the platform and the cache unit of the system at the same time, and after the system confirms that the data indexed by the platform is recorded into the information table, the identity tag of the object is transmitted to the corresponding platform by the system, and the corresponding source data with the identity tag is stored in the storage unit of the platform.

Or, storage units are arranged in the storage media of the connected platforms, and a cache unit is arranged in the system; when data retrieval is carried out according to the identity index words of the objects, the retrieved data in the corresponding platform are simultaneously stored in the storage unit of the platform and the cache unit of the system, and after the system confirms that the data indexed by the platform is input into the information table, the identity label of the object is transmitted to the corresponding platform by the system; and the corresponding platform reserves the node information of the source data indexed this time and stores the node information in the storage unit in a matching manner with the identity tag.

Example 2:

in this embodiment, the system platform and the processing method in embodiment 1 are adopted, and then the method is applied to statistical display of data collected from a plurality of public platform systems of residents in a community range, a cloud server provides data interaction services for a plurality of terminal devices, and meanwhile, optimization and limitation are performed on the steps of generating and processing identity tags, wherein:

the interaction module carries out data interaction through an interaction interface displayed on the terminal equipment and acquires resident verification data through the interaction interface;

the interaction module is connected with the identity information base for verification through the connection module after acquiring the uploaded resident verification data, requests to acquire complete personal information of the resident in the identity information base after the identity is confirmed, and splits the personal information into a plurality of keywords;

the data collection module is used for collecting personal related data containing the resident keywords on a plurality of public platforms and transmitting the personal related data to the cache module, the processing module is used for screening the related data according to the user portrait information determined by the personal information, and the personal related data with the correlation coefficient lower than the set threshold value are removed and then displayed on the interactive interface.

The resident authentication data includes biometric information and personal identification information, wherein: the biological identification information at least comprises one of fingerprint, iris and human face characteristics which are detected and uploaded in real time; the personal identification information includes a name and an identification number.

The interaction module keeps complete information of the personal identification information, encrypts the biological identification information and transmits the encrypted biological identification information to the identity information base together with the personal identification information, the personal identification information is used for calling corresponding information in the identity information base, the biological identification information is locally decrypted and compared, and then a comparison result is sent to the interaction module.

And when the comparison result is correct, the next operation is carried out through the processing module, and if the comparison result is inconsistent, the corresponding residents are prompted to upload the resident verification data again through the interaction module.

The personal information requested after the interactive module confirms the identity of the resident comprises the name, the identity card number, the political identity, the registered residential address, the number of the resident, the working address, the direct family information, the contact way, the academic history, the learning experience and the hospitalization and diagnosis information of the user; after the keywords are formed, the connection module is linked with a plurality of public platforms to collect data, and during collection, the keywords at least containing identity card numbers are combined and searched to obtain personal related data.

The cloud server is provided with a resident account and a manager account, wherein after the resident account acquires the personal related data, the resident account is not logged in for operation within a set time, and source link information of all identity index data of the personal related data is matched with the tags for storage. The source link information comprises the public platform name and address of the personal related data source and the address information of the information source in the public platform server.

After the resident account verifies the login again and requests the relevant information, the interaction module can quickly link the corresponding public platform according to the stored source link information, acquire personal relevant data and gather the personal relevant data into the interaction module for displaying.

Example 3:

in the present embodiment, a system in which community residents and managers are actually arranged will be described based on the contents in embodiment 1 and embodiment 2.

The architecture of the whole system is shown in fig. 1, and it can be seen that the whole system has several front-end modes, including independent APPs on each mobile system platform, and various applets. The platform can be linked through the front ends, an interactive interface corresponding to the layout mode is obtained, and corresponding operation is carried out by using the interactive interface. The bottom layer is a database and a data port, and data access is carried out through a connecting module.

The users in the community comprise resident users and management users, wherein the management users cannot directly check the data of the resident users, only can count partial data recorded when all community resident users generate the tables on the system through the table generating module, and only display the partial data in a digital sum mode, but cannot know the self condition of each resident user.

Each resident user fills corresponding identity information in the system, the identity label is determined after the system verifies the identity information, and the identity index word is determined according to the form type required to be made by the resident user.

For example, the resident of the community needs to know that there is a recorded medical record form from the birth date to the current time node, and can select a form application column through the system, select a new form application after clicking to enter, and select a form template of medical information. A plurality of items exist on the form template of the hospitalizing information, each item is provided with a label, each item can be expanded to form a plurality of sub-items and is provided with sub-labels, and a user can add new items or sub-items according to needs. For example, the information bar has personal information items including name, age, sex, and the like, and has photo items, there are photos obtained from other platforms in the generated form, or the user uploads the photos as identity information, the processing module also has an image processing model, and can obtain corresponding feature values according to the photos, obtain related identity index data by using the feature values of the photos and other identity index words as search conditions, and then the processing module determines the relevance according to an algorithm to fill in the data.

After the resident user determines the form template, the system gives an estimated report making time according to the average making time of the form type, and the resident user can quit the platform and can determine whether the report is made through the interactive interface when logging in later.

And after confirming the process, the cloud platform sorts the process according to the time sequence and automatically sets the processing time according to the set processing performance of the server. When the form making requirements submitted by the user are processed, the form generating module can utilize the connecting module to connect the back-end data of each large hospital platform system according to the identity index words. (the system in this embodiment has a right to link multiple data platforms, and this embodiment is only used to illustrate technical feasibility of the system, and is not preset for other artificial limiting conditions, such as the cache unit set in the other platforms in the above content, and also setting that permission of the corresponding platform has been obtained at the beginning of establishment of the platform, which does not affect theoretical implementation of the technology) information having the identity index word on each platform is introduced into the system through the connection module, and is stored in the storage module.

In the above embodiment, if a large amount of data content cannot be processed, the found identity index data may be stored in the cache unit established in the corresponding platform, and then the identity index data transmitted by each platform is processed in sequence, and then the source link information of the utilized, unused or all information is stored in the storage module. And the form generating module generates a form by processing and filling in the form template according to the data to be utilized, and informs the resident user to view the form through the system after the form is completed.

When a resident user starts to apply for a new form, a mail address or other cloud storage addresses are filled in, if the resident user does not check and handle the made form within a set time, the system automatically converts the made form data into a conventional format (PDF or JPG picture and the like) and sends the conventional format to the filled storage addresses, and deletes the data after the occurrence, and only source link information during single form making is reserved.

The resident user can see how the state of an illness is, and has detailed time data by acquiring the table, and the resident user can check more detailed data on a platform of a corresponding medical institution according to the data, so that the forgotten diagnosis condition can be confirmed in the form of the table.

Meanwhile, the system can count the total data according to the form data, particularly the disease types marked by the managed users and needing to be counted, and then the permission of the resident users is acquired on the system in advance. For example, the community can confirm the cardiovascular disease condition of residents in the district through the system, if the residents who see a doctor for the cardiovascular disease are counted by the system, the community correspondingly carries out the timing inspection and the related knowledge guidance of the cardiovascular disease in the corresponding district or resident gathering point according to the number and address distribution, and gives the residents some treatment preferential services.

It should be noted that, when performing statistics, the management user also applies for a new form on the interactive interface to perform data acquisition. When the system receives data statistics of all residential users in the district performed by the management user, the form templates corresponding to the management user are different, the system utilizes the source link information stored by each residential user to index on the corresponding platform again, and meanwhile, the same data processing mode is adopted to collect data to generate a form. Because the data is encrypted data, the management user cannot directly see the related information of each resident user, and only one total data statistic can be obtained, so that the system can meet the requirements of two users, reduce the data processing amount and can utilize the low-dosage period at night to obtain uninterrupted data.

It should be noted that the above description is made only with the form made of medical information, but also includes information statistics of other resident life aspects, such as academic information, employment information, online shopping information, and the like, and the data generation form can be acquired by linking corresponding platforms, such as a learning network, a job-seeking website, a talent market, and each online shopping platform. And community management personnel can also carry out targeted service development according to comprehensive statistical data in the district.

The present invention is not limited to the above-described alternative embodiments, and various other forms of products can be obtained by anyone in light of the present invention. The above detailed description should not be taken as limiting the scope of the invention, which is defined in the claims, and which the description is intended to be interpreted accordingly.

Claims

1. The distributed data management and application system based on one table is used for establishing a cloud platform, acquiring data of a plurality of external platform ports for sorting and storing, and displaying the sorted data in an information table form for a user of the cloud platform, and is characterized in that: the method comprises the following steps:

the form generation module is used for generating identity labels and identity index words according to data submitted by the interactive interface, obtaining identity index data with the identity index words in a plurality of platforms through the connection module and storing the identity index data in the storage module, and filling the classified data in a stored form template after analyzing, screening and classifying the data by using the processing module so as to generate a corresponding information form and send the corresponding information form to the interactive module for display;

the data of the information form generated by the form generation module can be temporarily stored in the storage module, and after the data of the information form is determined to be sent to a storage address provided by a user by the interaction module after being displayed, the data is deleted after being reserved for more than set time;

the storage module is provided with a cache unit which is used for caching all data when a single table is made;

2. A table-based distributed data management and application system according to claim 1, wherein: the cache unit comprises a local cache and an external cache, wherein the external cache is a storage space which is divided and marked out independently in storage media of each platform connected with the connection module;

3. The distributed table-based data management and application system of claim 2, wherein: the label information comprises corresponding data node information and a part of characteristic values of the data, and the table generation module calls the label information, analyzes the characteristic values, directly extracts the corresponding data and displays the corresponding data on the corresponding part of the information table.

4. A table-based distributed data management and application system according to claim 1, wherein: the system also comprises a verification module, wherein a repeated form request submitted by aiming at the same identity tag is sent out by the interaction module, the index information stored under the corresponding identity tag in the storage module is called by the form generation module, the corresponding data in the corresponding platform is quickly extracted according to the index information and is compared with the data of the information form generated last time, and the updated data is reserved and filled in the corresponding information form for display.

5. The distributed table-based data management and application system of claim 1, wherein: the system also comprises a user management module, and user registration and identity tag identification are carried out through the user management module.

6. The distributed table-based data management and application system of claim 1, wherein: the system is applied to information management of community residents in community service.