A method and system for exporting achievement information
By obtaining user needs and generating a result information export list, and combining data hot and cold analysis to allocate platform resources, the problems of lag and low efficiency during the export of result information are solved, and efficient result information export is achieved.
Patent Information
- Application Number
- CN202411311608.6
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-09-20
- Publication Date
- 2025-03-07
- Estimated Expiration
- 2044-09-20
AI Technical Summary
The excessive storage of result information data in existing databases leads to slow query speed, and when users export large amounts of result information, the system is often stuttered and the export time is too long.
By obtaining user needs, obtaining result information data, and displaying it in the form of a data list; generating a result information export list based on the categories and forms of the result information data selected by the user; when the user determines to export the result information, the export list is called, filtered and integrated according to the preset data association rules, and allocating platform resources based on the data hot and cold analysis results to perform the result information export operation.
It effectively solves the problem of lag when there is a lot of results information, ensures the quality and efficiency of results information export, and meets the user's results information export needs.
Smart Images

Figure CN118861047B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of information export, and in particular to a method and system for exporting achievement information. Background Art
[0002] With the rapid development of my country's science and technology service industry, the number of scientific and technological achievements and non-scientific and technological achievements has increased rapidly. Various types of achievements are usually stored independently in corresponding databases. However, existing databases store too much achievement data, which often leads to slow achievement query speeds. When users export a large amount of achievement information, system freezes and export time is too long. In addition, when users export achievement information, they often need to make personalized choices based on their personal needs.
[0003] Therefore, the present invention provides a method and system for exporting achievement information. Summary of the invention
[0004] The present invention provides an achievement information export method and system, which are used to obtain achievement information data according to user needs, and display it on the front end in the form of a data list; generate an achievement information export list according to the category and form of the achievement information data selected by the user; when the user determines to export the achievement information, the corresponding achievement information data in the export list is called, screened and integrated according to preset data association rules, and platform resources are allocated according to the data hotness and coldness analysis results to execute the achievement information export operation; the achievement information is exported to a specified location, and the exported information of each achievement information is visually displayed; the user's needs for exporting achievement information are met, and the jamming problem when there is a lot of achievement information is effectively solved, thereby ensuring the quality and efficiency of the achievement information export.
[0005] The present invention provides a method for exporting achievement information, comprising:
[0006] Step 1: Obtain user needs, access the achievement database, obtain achievement information data, and display the achievement information data in the form of a data list on the front end;
[0007] Step 2: Generate an export list of achievement information according to the category and form of achievement information data selected by the user;
[0008] Step 3: When the user determines to export the achievement information, the corresponding achievement information data in the export list is called, screened and integrated according to the preset data association rules, and platform resources are allocated according to the data hotness and coldness analysis results to perform the achievement information export operation;
[0009] Step 4: Export the achievement information to the specified location. When the achievement information export operation is detected to be completed, the corresponding achievement information export alarm data is generated, and the export information of each achievement information is visualized.
[0010] Preferably, obtaining user needs, accessing the achievement database for data processing, and obtaining achievement information data include:
[0011] Obtain user needs, analyze and process user needs, and obtain the category and form of the output information that users need to export;
[0012] The user authority is verified. When the category and form of the achievement information that the user needs to export are consistent with the user authority and the user access status is normal, data access processing will be performed on the corresponding achievement database to obtain the achievement information data.
[0013] Preferably, the achievement information data is displayed on the front end in the form of a data list, including:
[0014] When the achievement database is monitored to be accessed for data processing, data quality verification is performed on the achievement data stored in the achievement database, and data quality is updated according to the data quality verification result, wherein the data quality verification includes: data timeliness verification, data integrity verification, data accuracy verification and data security verification;
[0015] When it is determined that the data quality verification and the data update processing are completed, the achievement information data is displayed on the front end in the form of a data list, and at the same time, the data quality verification result and the data update processing result are displayed synchronously.
[0016] Preferably, according to the category and form of the achievement information data selected by the user, an achievement information export list is generated, including:
[0017] When it is detected that the user only chooses to export one achievement information, the achievement information export operation is performed;
[0018] Otherwise, according to the category and form of the achievement information data selected by the user to be exported in the data list, combined with the preset achievement information export list layout and the time data selected by the user to be exported, a corresponding achievement information export list is generated;
[0019] When the user clicks the export button in the achievement information export list, the achievement list selected by the user is exported;
[0020] When the user clicks the Export All button in the achievement information export list, all achievements will be exported.
[0021] Preferably, the export list is called, screened and integrated with corresponding achievement information data, and platform resources are allocated according to the data hotness and coldness analysis results to perform achievement information export operations, including:
[0022] Perform data integrity check and data consistency check on the achievement information data stored in the achievement information export platform. If there is a verification problem, re-execute the corresponding achievement data call operation;
[0023] If there is no verification problem, the export list is screened according to the database data quality verification results, data integrity verification results and data consistency verification results, and unqualified achievement data is eliminated;
[0024] According to the user's secondary screening option operation, the export list is screened for the second time, and the achievement data that does not meet the user's needs are secondary eliminated, wherein the user's secondary screening options include: data timeliness screening, data storage size screening, data category screening, and data form screening;
[0025] The result information data after the secondary screening is completed is recorded as the user-exported result information data;
[0026] Randomly select two data forms from the user-derived achievement information data to perform data integration analysis and processing, and when the data integration analysis and processing results meet the preset data integration rules, perform data integration on the user-derived achievement information data;
[0027] Obtain the historical access count, historical call count, and historical export count of each data after data integration and determine the popularity of each data;
[0028] Allocate platform resources based on the popularity of each data and user permissions, and calculate the export score of the corresponding achievement information;
[0029] ; Wherein, P1 is the derived score of the achievement information; x1 is the number of historical resources with abnormal transmission and abnormal platform detection resources determined from the allocation log of the platform resource allocation results; x2 is the number of historical resources with normal transmission and normal platform detection resources determined from the allocation log of the platform resource allocation results; y1 is the number of historical resources with normal transmission and abnormal platform detection resources determined from the allocation log of the platform resource allocation results; y2 is the number of historical resources with abnormal transmission and normal platform detection resources determined from the allocation log of the platform resource allocation results; zi1 is the data volume of the i1th data transmission channel involved in the allocation log; ti1 is the data transmission time of the i1th data transmission channel involved in the allocation log; a1 is the influence weight of data transmission quality on the derived score; a2 is the influence weight of data transmission efficiency on the derived score; n1 is the total number of data transmission channels involved based on the allocation log; The number of data corresponding to the hotness and coldness; is the hotness or coldness of the j1th data; is the cold and hot threshold; is the variance of the coldness and heatness corresponding to all hot data; n3 is the number of hot data;
[0030] When the export score is lower than the preset score, reallocate platform resources;
[0031] Otherwise, perform the result information export operation.
[0032] Preferably, the achievement information is exported to a designated location, corresponding achievement information export alarm data is generated, and the export information of each achievement information is visually displayed, including:
[0033] Obtaining the export location selected by the user, and when it is determined that the storage space of the export location is not less than the data volume of the exported achievement information, exporting the achievement information to the export location;
[0034] Generate corresponding transmission time alarm data based on the maximum data transmission time involved in the current distributed transmission, and display it in real-time visualization;
[0035] When it is monitored that the achievement information is exported to the export location, corresponding achievement information export alarm data is generated according to the data transmission quality and the data transmission time, and the export information of each achievement information is visually displayed.
[0036] Preferably, it also includes:
[0037] When it is monitored that the achievement information is exported to the export location and corresponding achievement information export alarm data is generated, if there is a data transmission quality problem, the corresponding achievement information is exported and replaced for the second time;
[0038] The relevant data involved in this user export operation is recorded, and the hot database of the achievement information export platform is updated.
[0039] Preferably, a system for exporting achievement information includes:
[0040] Achievement acquisition module, used to obtain user needs, access the achievement database, obtain achievement information data, and display the achievement information data in the form of a data list on the front end;
[0041] The achievement list module is used to generate an achievement information export list according to the category and form of the achievement information data selected by the user;
[0042] Achievement extraction module, used for calling, screening and integrating corresponding achievement information data in the export list according to preset data association rules when the user determines to export achievement information, and allocating platform resources and executing achievement information export operation according to the data hotness and coldness analysis results;
[0043] The achievement export module is used to export the achievement information to the specified location. When the achievement information export operation is detected to be completed, the corresponding achievement information export alarm data is generated, and the export information of each achievement information is visualized.
[0044] Compared with the prior art, the beneficial effects of this application are as follows:
[0045] According to user needs, the achievement information data is obtained and displayed on the front end in the form of a data list; according to the category and form of the achievement information data selected by the user, an achievement information export list is generated; when the user decides to export the achievement information, the corresponding achievement information data in the export list is called, screened and integrated according to the preset data association rules, and according to the data hot and cold analysis results, platform resources are allocated to execute the achievement information export operation; the achievement information is exported to the specified location, and the exported information of each achievement information is visualized; it not only meets the user's needs for exporting achievement information, but also effectively solves the problem of jamming when there is a lot of achievement information, ensuring the quality and efficiency of the achievement information export.
[0046] Other features and advantages of the present invention will be described in the following description, and partly become apparent from the description, or understood by practicing the present invention. The purpose and other advantages of the present invention can be realized and obtained by the structures particularly pointed out in the written description and the accompanying drawings.
[0047] The technical solution of the present invention is further described in detail below through the accompanying drawings and embodiments. BRIEF DESCRIPTION OF THE DRAWINGS
[0048] The accompanying drawings are used to provide a further understanding of the present invention and constitute a part of the specification. Together with the embodiments of the present invention, they are used to explain the present invention and do not constitute a limitation of the present invention. In the accompanying drawings:
[0049] Figure 1 A flowchart of a method for exporting achievement information in an embodiment of the present invention;
[0050] Figure 2 It is a structural diagram of a system for exporting achievement information in an embodiment of the present invention. DETAILED DESCRIPTION
[0051] The preferred embodiments of the present invention are described below in conjunction with the accompanying drawings. It should be understood that the preferred embodiments described herein are only used to illustrate and explain the present invention, and are not used to limit the present invention.
[0052] The embodiment of the present invention provides a method for exporting achievement information. Figure 1 As shown, including:
[0053] Step 1: Obtain user needs, access the achievement database, obtain achievement information data, and display the achievement information data in the form of a data list on the front end;
[0054] Step 2: Generate an export list of achievement information according to the category and form of achievement information data selected by the user;
[0055] Step 3: When the user determines to export the achievement information, the corresponding achievement information data in the export list is called, screened and integrated according to the preset data association rules, and platform resources are allocated according to the data hotness and coldness analysis results to perform the achievement information export operation;
[0056] Step 4: Export the achievement information to the specified location. When the achievement information export operation is detected to be completed, the corresponding achievement information export alarm data is generated, and the export information of each achievement information is visualized.
[0057] In this embodiment, the user demand refers to the user's demand to choose to export single, multiple or all achievement information.
[0058] In this embodiment, the achievement database refers to a database used to store achievement information, such as a scientific and technological database and a non-scientific and technological database, and the achievement information stored in each type of database does not affect each other.
[0059] In this embodiment, the front-end display in the form of a data list refers to the front-end display of the main content of the achievement information, such as the achievement name, achievement introduction, achievement source, achievement unit, achievement personnel, contact information, achievement time, achievement type and achievement status of the achievement information.
[0060] In this embodiment, the category of achievement information data refers to the type or type of achievement information, such as scientific or non-scientific; the form of achievement information data refers to the presentation format of achievement information, such as text, picture, audio and video.
[0061] In this embodiment, the achievement information export list refers to a list generated when a user exports multiple achievement information, and is used for the user to determine the export information.
[0062] In this embodiment, the preset data association rules refer to the rules for data calling, screening, and integration of achievement information, including platform rules and user rules. For example, the user stipulates that the achievement information is scientific and technological and within the time period t1~t2; the platform rules automatically screen out achievement information with data quality problems and integrate similar data.
[0063] In this embodiment, data hotness refers to a parameter determined according to the number of user accesses, calls, and exports to indicate whether the data is frequent. Hot data refers to data that needs to be frequently accessed, and cold data refers to data that is not frequently accessed.
[0064] In this embodiment, the total amount of platform resources is fixed and is dynamically adjusted according to user permissions, the number of user accesses in the same period, and the export data of achievement information.
[0065] In this embodiment, the achievement information exports alarm data, for example, if the achievement information fails to be exported, corresponding achievement information export failure alarm data is generated.
[0066] In this embodiment, the export information of each achievement information is visualized, such as the export location, estimated export time, export format, export progress and export quality.
[0067] The beneficial effects of the above technical solution are: according to user needs, the achievement information data is obtained and displayed on the front end in the form of a data list; according to the category and form of the achievement information data selected by the user, an achievement information export list is generated; when the user determines to export the achievement information, the corresponding achievement information data in the export list is called, screened and integrated according to the preset data association rules, and according to the data hot and cold analysis results, platform resources are allocated to execute the achievement information export operation; the achievement information is exported to a specified location, and the exported information of each achievement information is visually displayed; it not only meets the user's needs for exporting achievement information, but also effectively solves the problem of jamming when there is a lot of achievement information, ensuring the quality and efficiency of the achievement information export.
[0068] The embodiment of the present invention provides a method for exporting achievement information, which obtains user needs, performs data access processing on an achievement database, and obtains achievement information data, including:
[0069] Obtain user needs, analyze and process user needs, and obtain the category and form of the output information that users need to export;
[0070] The user authority is verified. When the category and form of the achievement information that the user needs to export are consistent with the user authority and the user access status is normal, data access processing will be performed on the corresponding achievement database to obtain the achievement information data.
[0071] In this embodiment, user needs are obtained and analyzed. For example, user A1 needs to export part of the achievement information in category a1; user A2 needs to export all the achievement information in category a1; user A3 needs to export one achievement information in category a2.
[0072] In this embodiment, the categories of achievement information include, for example, scientific and technological achievements and non-scientific and technological achievements; the forms of achievement information include, for example, text form, digital form, audio form, picture form and video form.
[0073] In this embodiment, user authority refers to the authority granted by the achievement information export platform to each user to access the database. For example, user A1 with user authority b1 is allowed to access category a1 achievement information and category a2 achievement information.
[0074] In this embodiment, normal user access status means that the connection access relationship between the user and the achievement information export platform is normal and there is no access risk. For example, when the user has multiple login addresses at the same time, there are a large number of access behaviors in a short period of time, and illegally accesses achievement information that does not comply with the corresponding user permissions, the user access status is judged to be abnormal.
[0075] The beneficial effects of the above technical solution are: by obtaining user needs, it is conducive to subsequent database access processing and effectively meets the user's needs for exporting achievement information; verifying user permissions and ensuring that user access status is normal, effectively ensuring the data security of achievement information.
[0076] The embodiment of the present invention provides a method for exporting achievement information, which displays the achievement information data in the form of a data list on the front end, including:
[0077] When the achievement database is monitored to be accessed for data processing, data quality verification is performed on the achievement data stored in the achievement database, and data quality is updated according to the data quality verification result, wherein the data quality verification includes: data timeliness verification, data integrity verification, data accuracy verification and data security verification;
[0078] When it is determined that the data quality verification and the data update processing are completed, the achievement information data is displayed on the front end in the form of a data list, and at the same time, the data quality verification result and the data update processing result are displayed synchronously.
[0079] In this embodiment, data quality verification, for example, data timeliness verification, a1 category achievement information data is valid achievement information in the time period t1~t2; data integrity verification, if no data loss problem occurs during data access processing, the data is judged to be complete; data security verification, if no abnormal intrusion problems such as risky access occur during data access processing, the data is judged to be safe.
[0080] In this embodiment, data quality update refers to eliminating data that fails the data quality verification and supplementing and updating the data that meets the quality verification accordingly. For example, if data loss occurs in the achievement information b1 during data access processing and there is a problem with the data integrity verification, a data quality update is required; if the achievement information b2 data is invalid, if valid updated data of the achievement information b2 is detected in the achievement database, the corresponding data quality update is performed, otherwise, the achievement information b2 is updated with an invalidation mark.
[0081] In this embodiment, the achievement information data is displayed on the front end in the form of a data list, for example, achievement information b1, achievement name, achievement introduction, achievement source, achievement unit, achievement personnel, contact information, achievement time, and achievement type. At the same time, data integrity problems existing in data quality verification and data effective updates are displayed synchronously.
[0082] The beneficial effects of the above technical solution are: by performing data quality verification on the achievement data, the data quality of the achievement information is effectively ensured; the achievement information data is displayed on the front end in the form of a data list, which facilitates users to select achievement information and subsequent export operations, thereby improving the user experience.
[0083] The embodiment of the present invention provides a method for exporting achievement information, which generates an achievement information export list according to the category and form of achievement information data selected by a user, including:
[0084] When it is detected that the user only chooses to export one achievement information, the achievement information export operation is performed;
[0085] Otherwise, according to the category and form of the achievement information data selected by the user to be exported in the data list, combined with the preset achievement information export list layout and the time data selected by the user to be exported, a corresponding achievement information export list is generated;
[0086] When the user clicks the export button in the achievement information export list, the achievement list selected by the user is exported;
[0087] When the user clicks the Export All button in the achievement information export list, all achievements will be exported.
[0088] In this embodiment, the achievement information export list refers to a list generated based on the achievement information data selected for export by the user, and is used to determine the user's exported achievement information. For example, if the user selects to export achievement information a1, a2, b1, b2, and c1, the corresponding achievement information export list A1 is generated.
[0089] In this embodiment, the layout of the achievement information export list is preset, for example, the list is sorted according to achievement information of categories a, b, and c, and achievement information of the same category is sorted according to the time data selected by the user for export.
[0090] In this embodiment, an export button and an export all button are preset, and the export button can execute the export of the result information selected by the user, for example, the user selects to export the result information a1, b1 and c1.
[0091] In this embodiment, the Export All button can export one or more categories of achievement information, for example, export category A achievement information or export all (a, b, c) categories of achievement information.
[0092] The beneficial effects of the above technical solution are: by generating a corresponding achievement information export list, it is helpful for users to determine the achievement information to be exported, which is convenient for subsequent users to modify; deploying export buttons and all export buttons is helpful to meet users' different achievement information export needs.
[0093] The embodiment of the present invention provides a method for exporting achievement information, which calls, screens and integrates the corresponding achievement information data in the export list, allocates platform resources according to the data hotness and coldness analysis results, and executes the achievement information export operation, including:
[0094] Perform data integrity check and data consistency check on the achievement information data stored in the achievement information export platform. If there is a verification problem, re-execute the corresponding achievement data call operation;
[0095] If there is no verification problem, the export list is screened according to the database data quality verification results, data integrity verification results and data consistency verification results, and unqualified achievement data is eliminated;
[0096] According to the user's secondary screening option operation, the export list is screened for the second time, and the achievement data that does not meet the user's needs are secondary eliminated, wherein the user's secondary screening options include: data timeliness screening, data storage size screening, data category screening, and data form screening;
[0097] The result information data after the secondary screening is completed is recorded as the user-exported result information data;
[0098] Randomly select two data forms from the user-derived achievement information data to perform data integration analysis and processing, and when the data integration analysis and processing results meet the preset data integration rules, perform data integration on the user-derived achievement information data;
[0099] Obtain the historical access count, historical call count, and historical export count of each data after data integration and determine the popularity of each data;
[0100] Allocate platform resources based on the popularity of each data and user permissions, and calculate the export score of the corresponding achievement information;
[0101] ; Wherein, P1 is the derived score of the achievement information; x1 is the number of historical resources with abnormal transmission and abnormal platform detection resources determined from the allocation log of the platform resource allocation results; x2 is the number of historical resources with normal transmission and normal platform detection resources determined from the allocation log of the platform resource allocation results; y1 is the number of historical resources with normal transmission and abnormal platform detection resources determined from the allocation log of the platform resource allocation results; y2 is the number of historical resources with abnormal transmission and normal platform detection resources determined from the allocation log of the platform resource allocation results; zi1 is the data volume of the i1th data transmission channel involved in the allocation log; ti1 is the data transmission time of the i1th data transmission channel involved in the allocation log; a1 is the influence weight of data transmission quality on the derived score; a2 is the influence weight of data transmission efficiency on the derived score; n1 is the total number of data transmission channels involved based on the allocation log; The number of data corresponding to the hotness and coldness; is the hotness or coldness of the j1th data; is the cold and hot threshold; is the variance of the coldness and heatness corresponding to all hot data; n3 is the number of hot data;
[0102] When the export score is lower than the preset score, reallocate platform resources;
[0103] Otherwise, perform the result information export operation.
[0104] In this embodiment, the achievement data call operation creates a new user call task in the platform, accesses the corresponding database of the corresponding achievement information data, and when the data access of each database is stable, executes the user call task and temporarily stores the achievement information data in the achievement information export platform.
[0105] In this embodiment, when it is monitored that the user has suspended the export operation of the results information, the corresponding user call task will be suspended, and the data access will be kept stable, and the data of each database will be continuously read. When the data of each database is monitored to have changed, the corresponding changed data will be updated in the export list, and a data update alarm operation will be performed.
[0106] In this embodiment, when the achievement data calling operation is completed, the data access to each database is terminated and the corresponding data calling channel is closed.
[0107] In this embodiment, data integrity verification refers to a verification operation to monitor whether there is data loss and data tampering during the data transmission process and the data storage process.
[0108] In this embodiment, data consistency verification refers to maintaining consistency of the same data stored in the achievement information export platform and each achievement database.
[0109] In this embodiment, the primary screening refers to the automated screening performed by the achievement information export platform according to the database data quality verification results, data integrity verification results and data consistency verification results, and unqualified achievement data is eliminated once.
[0110] In this embodiment, the secondary screening refers to the manual screening of the achievement information export list by the user according to the user's secondary screening option operation.
[0111] In this embodiment, the user exports the result information data, which refers to the result information of the first screening and the second screening, and can perform the export operation.
[0112] In this embodiment, the data form basis, for example, text, picture, audio and video; the user randomly selects two data form bases from the exported achievement information data for data integration analysis and processing. For example, the achievement information data a1 is analyzed. The achievement information data a1 includes a text data form basis, a picture data form basis and a video data form basis. When the text data b1 changes, the picture data c2 changes accordingly. When the text data b2 changes, the video data c1 changes accordingly, and the corresponding data integration is performed.
[0113] In this embodiment, data integration refers to the operation of consistently associating and calling corresponding data with data association changes, for example, integrating the text data b2 and the video data c1 of the achievement information data a1.
[0114] In this embodiment, data integration improves data export efficiency by adjusting data export, effectively avoiding export jams.
[0115] In this embodiment, the heat of each data is determined according to the historical access times, the historical call times and the historical export times. For example, the heat of data with a preset historical access time of 100 times is 100.
[0116] In this embodiment, the historical access times, historical call times, and historical export times are weighted averaged to determine the hotness or coldness of each data.
[0117] In this embodiment, the heat threshold, for example, the preset heat threshold is 60 (0-100), then data with a heat greater than the heat threshold is recorded as hot data, and the remaining data is recorded as cold data.
[0118] In this embodiment, the hot data is packaged and stored in the hot database; the cold data is stored in the original achievement database.
[0119] In this embodiment, when the user performs an operation to export achievement information data, hot data in the hot database is called first, thereby reducing resource usage of the achievement information export platform.
[0120] In this embodiment, the achievement information is exported using distributed data export.
[0121] The beneficial effects of the above technical solution are: by calling, screening and integrating data for the exported results information selected by the user, the quality of the exported results information is effectively ensured; according to the results of data hot and cold analysis, platform resources are allocated, which effectively solves the problem of jamming when a large amount of results information is exported, thereby ensuring the efficiency of the export of results information.
[0122] The embodiment of the present invention provides a method for exporting achievement information, which exports achievement information to a specified location, generates corresponding achievement information export alarm data, and visually displays the exported information of each achievement information, including:
[0123] Obtaining the export location selected by the user, and when it is determined that the storage space of the export location is not less than the data volume of the exported achievement information, exporting the achievement information to the export location;
[0124] Generate corresponding transmission time alarm data based on the maximum data transmission time involved in the current distributed transmission, and display it in real-time visualization;
[0125] When it is monitored that the achievement information is exported to the export location, corresponding achievement information export alarm data is generated according to the data transmission quality and the data transmission time, and the export information of each achievement information is visually displayed.
[0126] In this embodiment, it is determined that the storage space of the export location is not less than the data volume of the exported achievement information. For example, the user selects the storage space of the export location as A1, and the data volume of the exported achievement information is A2. When A1>A2, the achievement information export operation is executed, otherwise, the corresponding transmission space alarm data is generated, such as an alarm for insufficient storage space.
[0127] In this embodiment, when the user adjusts the export of achievement information once, the storage space and transmission time of the export location are correspondingly determined once.
[0128] In this embodiment, distributed transmission is used, that is, data is dispersed in each node of the achievement information export platform, and parallel export operations are performed. Therefore, the maximum data transmission time involved in the current distributed transmission is selected to generate corresponding transmission time alarm data. For example, the user exports achievement information a1, a2, b1, b2, b3 and c1, and the estimated export time of category a achievement information is t1, the estimated export time of category b achievement information is t2, and the estimated export time of category c achievement information is t3, and t2>t3>t1, then the corresponding transmission time alarm data is generated according to t1, and at the same time, the corresponding transmission time alarm data of each type of estimated export time is visualized accordingly.
[0129] In this embodiment, the achievement information derives alarm data, including: data transmission quality alarm data, data transmission time alarm data, data transmission volume alarm data, and transmission progress alarm data.
[0130] The beneficial effects of the above technical solution are: obtaining the user's export location to ensure that the achievement information can be successfully exported; real-time visual display of transmission time alarm data, which is conducive to users to view the export status of various achievement information in real time, thereby improving user experience.
[0131] The embodiment of the present invention provides a method for exporting achievement information, further comprising:
[0132] When it is monitored that the achievement information is exported to the export location and corresponding achievement information export alarm data is generated, if there is a data transmission quality problem, the corresponding achievement information is exported and replaced for the second time;
[0133] The relevant data involved in this user export operation is recorded, and the hot database of the achievement information export platform is updated.
[0134] In this embodiment, secondary export and replacement is performed after the user's achievement information is exported. For example, the user exports achievement information a1, a2, and a3. If it is detected that there is a data transmission quality problem with achievement information a3 during the export process, secondary export and replacement is performed on achievement information a3.
[0135] In this embodiment, the hot database stores achievement information frequently accessed by users. The achievement information stored in the hot database has better access speed and export speed than the achievement information stored in the corresponding achievement database, and occupies less resources of the achievement information export platform.
[0136] In this embodiment, the storage space of the heat database is valid, so when a user completes exporting the achievement information, the heat database is determined and updated in time.
[0137] The beneficial effects of the above technical solution are: by performing a secondary export and replacement of the results information with data transmission quality problems, the quality of the export of the results information is effectively ensured; recording relevant export data and updating the hot database is conducive to the platform to conduct statistical analysis on various results information, ensure data security and optimize subsequent results information export operations.
[0138] The embodiment of the present invention provides a system for exporting achievement information. Figure 2 As shown, including:
[0139] Achievement acquisition module, used to obtain user needs, access the achievement database, obtain achievement information data, and display the achievement information data in the form of a data list on the front end;
[0140] The achievement list module is used to generate an achievement information export list according to the category and form of the achievement information data selected by the user;
[0141] Achievement extraction module, used for calling, screening and integrating corresponding achievement information data in the export list according to preset data association rules when the user determines to export achievement information, and allocating platform resources and executing achievement information export operation according to the data hotness and coldness analysis results;
[0142] The achievement export module is used to export the achievement information to the specified location. When the achievement information export operation is detected to be completed, the corresponding achievement information export alarm data is generated, and the export information of each achievement information is visualized.
[0143] The beneficial effects of the above technical solution are: according to user needs, the achievement information data is obtained and displayed on the front end in the form of a data list; according to the category and form of the achievement information data selected by the user, an achievement information export list is generated; when the user determines to export the achievement information, the corresponding achievement information data in the export list is called, screened and integrated according to the preset data association rules, and according to the data hot and cold analysis results, platform resources are allocated to execute the achievement information export operation; the achievement information is exported to a specified location, and the exported information of each achievement information is visually displayed; it not only meets the user's needs for exporting achievement information, but also effectively solves the problem of jamming when there is a lot of achievement information, ensuring the quality and efficiency of the achievement information export.
[0144] Obviously, those skilled in the art can make various changes and modifications to the present invention without departing from the spirit and scope of the present invention. Thus, if these modifications and variations of the present invention fall within the scope of the claims of the present invention and their equivalents, the present invention is also intended to include these modifications and variations.
Claims
1. A method for exporting achievement information, characterized in that: include: Step 1: Obtain user needs, access the achievement database, obtain achievement information data, and display the achievement information data in the form of a data list on the front end; Step 2: Generate an export list of achievement information according to the category and form of achievement information data selected by the user; Step 3: When the user determines to export the achievement information, the corresponding achievement information data in the export list is called, screened and integrated according to the preset data association rules, and platform resources are allocated according to the data hotness and coldness analysis results to perform the achievement information export operation; Step 4: Export the achievement information to the specified location. When the achievement information export operation is completed, generate the corresponding achievement information export alarm data, and visualize the export information of each achievement information; Wherein, step 3 includes: Perform data integrity check and data consistency check on the achievement information data stored in the achievement information export platform. If there is a verification problem, re-execute the corresponding achievement data call operation; If there is no verification problem, the export list is screened according to the database data quality verification results, data integrity verification results and data consistency verification results, and unqualified achievement data is eliminated; According to the user's secondary screening option operation, the export list is screened for the second time, and the achievement data that does not meet the user's needs are secondary eliminated, wherein the user's secondary screening options include: data timeliness screening, data storage size screening, data category screening, and data form screening; The result information data after the secondary screening is completed is recorded as the user-exported result information data; Randomly select two data forms from the user-derived achievement information data to perform data integration analysis and processing, and when the data integration analysis and processing results meet the preset data integration rules, perform data integration on the user-derived achievement information data; Obtain the historical access count, historical call count, and historical export count of each data after data integration and determine the popularity of each data; Allocate platform resources based on the popularity of each data and user permissions, and calculate the export score of the corresponding achievement information; ; Wherein, P1 is the derived score of the achievement information; x1 is the number of historical resources with abnormal transmission and abnormal platform detection resources determined from the allocation log of the platform resource allocation results; x2 is the number of historical resources with normal transmission and normal platform detection resources determined from the allocation log of the platform resource allocation results; y1 is the number of historical resources with normal transmission and abnormal platform detection resources determined from the allocation log of the platform resource allocation results; y2 is the number of historical resources with abnormal transmission and normal platform detection resources determined from the allocation log of the platform resource allocation results; zi1 is the data volume of the i1th data transmission channel involved in the allocation log; ti1 is the data transmission time of the i1th data transmission channel involved in the allocation log; a1 is the influence weight of data transmission quality on the derived score; a2 is the influence weight of data transmission efficiency on the derived score; n1 is the total number of data transmission channels involved based on the allocation log; The number of data corresponding to the hotness and coldness; is the hotness or coldness of the j1th data; is the cold and hot threshold; is the variance of the coldness and heatness corresponding to all hot data; n3 is the number of hot data; When the export score is lower than the preset score, reallocate platform resources; Otherwise, perform the result information export operation.
2. A method for exporting achievement information according to claim 1, characterized in that: Obtain user needs, access and process the achievement database, and obtain achievement information data, including: Obtain user needs, analyze and process user needs, and obtain the category and form of the output information that users need to export; The user authority is verified. When the category and form of the achievement information that the user needs to export are consistent with the user authority and the user access status is normal, data access processing will be performed on the corresponding achievement database to obtain the achievement information data.
3. A method for exporting achievement information according to claim 1, characterized in that: The achievement information data is displayed on the front end in the form of a data list, including: When the achievement database is monitored to be accessed for data processing, data quality verification is performed on the achievement data stored in the achievement database, and data quality is updated according to the data quality verification result, wherein the data quality verification includes: data timeliness verification, data integrity verification, data accuracy verification and data security verification; When it is determined that the data quality verification and the data update processing are completed, the achievement information data is displayed on the front end in the form of a data list, and at the same time, the data quality verification result and the data update processing result are displayed synchronously.
4. A method for exporting achievement information according to claim 1, characterized in that: Generate an export list of achievement information based on the category and format of achievement information data selected by the user, including: When it is detected that the user only chooses to export one achievement information, the achievement information export operation is performed; Otherwise, according to the category and form of the achievement information data selected by the user to be exported in the data list, combined with the preset achievement information export list layout and the time data selected by the user to be exported, a corresponding achievement information export list is generated; When the user clicks the export button in the achievement information export list, the achievement list selected by the user is exported; When the user clicks the Export All button in the achievement information export list, all achievements will be exported.
5. A method for exporting achievement information according to claim 1, characterized in that: Export the achievement information to the specified location, generate the corresponding achievement information export alarm data, and visualize the export information of each achievement information, including: Obtaining the export location selected by the user, and when it is determined that the storage space of the export location is not less than the data volume of the exported achievement information, exporting the achievement information to the export location; Generate corresponding transmission time alarm data based on the maximum data transmission time involved in the current distributed transmission, and display it in real-time visualization; When it is monitored that the achievement information is exported to the export location, corresponding achievement information export alarm data is generated according to the data transmission quality and the data transmission time, and the export information of each achievement information is visually displayed.
6. A method for exporting achievement information according to claim 5, characterized in that: Also includes: When it is monitored that the achievement information is exported to the export location and corresponding achievement information export alarm data is generated, if there is a data transmission quality problem, the corresponding achievement information is exported and replaced for the second time; The relevant data involved in this user export operation is recorded, and the hot database of the achievement information export platform is updated.
7. A system for exporting achievement information, characterized in that: include: Achievement acquisition module, used to obtain user needs, access the achievement database, obtain achievement information data, and display the achievement information data in the form of a data list on the front end; The achievement list module is used to generate an achievement information export list according to the category and form of the achievement information data selected by the user; Achievement extraction module, used for calling, screening and integrating corresponding achievement information data in the export list according to preset data association rules when the user determines to export achievement information, and allocating platform resources and executing achievement information export operation according to the data hotness and coldness analysis results; The achievement export module is used to export the achievement information to a specified location. When the achievement information export operation is completed, the corresponding achievement information export alarm data is generated, and the export information of each achievement information is visually displayed; Among them, the achievement extraction module is specifically used for: Perform data integrity check and data consistency check on the achievement information data stored in the achievement information export platform. If there is a verification problem, re-execute the corresponding achievement data call operation; If there is no verification problem, the export list is screened according to the database data quality verification results, data integrity verification results and data consistency verification results, and unqualified achievement data is eliminated; According to the user's secondary screening option operation, the export list is screened for the second time, and the achievement data that does not meet the user's needs are secondary eliminated, wherein the user's secondary screening options include: data timeliness screening, data storage size screening, data category screening, and data form screening; The result information data after the secondary screening is completed is recorded as the user-exported result information data; Randomly select two data forms from the user-derived achievement information data to perform data integration analysis and processing, and when the data integration analysis and processing results meet the preset data integration rules, perform data integration on the user-derived achievement information data; Obtain the historical access count, historical call count, and historical export count of each data after data integration and determine the popularity of each data; Allocate platform resources based on the popularity of each data and user permissions, and calculate the export score of the corresponding achievement information; ; Wherein, P1 is the derived score of the achievement information; x1 is the number of historical resources with abnormal transmission and abnormal platform detection resources determined from the allocation log of the platform resource allocation results; x2 is the number of historical resources with normal transmission and normal platform detection resources determined from the allocation log of the platform resource allocation results; y1 is the number of historical resources with normal transmission and abnormal platform detection resources determined from the allocation log of the platform resource allocation results; y2 is the number of historical resources with abnormal transmission and normal platform detection resources determined from the allocation log of the platform resource allocation results; zi1 is the data volume of the i1th data transmission channel involved in the allocation log; ti1 is the data transmission time of the i1th data transmission channel involved in the allocation log; a1 is the influence weight of data transmission quality on the derived score; a2 is the influence weight of data transmission efficiency on the derived score; n1 is the total number of data transmission channels involved based on the allocation log; The number of data corresponding to the hotness and coldness; is the hotness or coldness of the j1th data; is the cold and hot threshold; is the variance of the coldness and heatness corresponding to all hot data; n3 is the number of hot data; When the export score is lower than the preset score, reallocate platform resources; Otherwise, perform the result information export operation.
Citation Information
Patent Citations
Massive search query log calculation and analysis system based on cloud platform
CN111708740A
Business intelligent query method and system based on enterprise database
CN118410151A