CN115640369B - Piece information base data storage method applying star-shaped data model - Google Patents
Piece information base data storage method applying star-shaped data model Download PDFInfo
- Publication number
- CN115640369B CN115640369B CN202211416835.6A CN202211416835A CN115640369B CN 115640369 B CN115640369 B CN 115640369B CN 202211416835 A CN202211416835 A CN 202211416835A CN 115640369 B CN115640369 B CN 115640369B
- Authority
- CN
- China
- Prior art keywords
- information
- data
- target
- office
- request
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 111
- 238000013499 data model Methods 0.000 title claims abstract description 36
- 238000013500 data storage Methods 0.000 title claims abstract description 31
- 230000008569 process Effects 0.000 claims abstract description 70
- 238000012795 verification Methods 0.000 claims description 46
- 239000011159 matrix material Substances 0.000 claims description 25
- 230000003213 activating effect Effects 0.000 claims description 12
- 239000013598 vector Substances 0.000 claims description 9
- 230000006870 function Effects 0.000 claims description 7
- 239000003550 marker Substances 0.000 claims description 7
- 238000004364 calculation method Methods 0.000 claims description 6
- 238000013507 mapping Methods 0.000 claims description 6
- 238000013528 artificial neural network Methods 0.000 claims description 5
- 238000007726 management method Methods 0.000 claims description 4
- 230000004913 activation Effects 0.000 claims description 3
- 238000012512 characterization method Methods 0.000 claims description 3
- 230000000694 effects Effects 0.000 abstract description 3
- 239000007787 solid Substances 0.000 abstract description 3
- 230000009286 beneficial effect Effects 0.000 description 12
- 238000005259 measurement Methods 0.000 description 7
- 238000005457 optimization Methods 0.000 description 6
- 238000004458 analytical method Methods 0.000 description 4
- 239000000470 constituent Substances 0.000 description 4
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000010606 normalization Methods 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 1
- 238000009825 accumulation Methods 0.000 description 1
- 230000004075 alteration Effects 0.000 description 1
- 238000012790 confirmation Methods 0.000 description 1
- 238000013075 data extraction Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 238000005065 mining Methods 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 238000003672 processing method Methods 0.000 description 1
- 230000004044 response Effects 0.000 description 1
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Abstract
The invention provides a piece information base data storage method applying a star-shaped data model, which comprises the following steps: acquiring N information types of government affair office information, and creating N information indexes in an office table according to the N information types; the method comprises the steps that information data corresponding to government affair handling information are stored in a handling table firstly based on an information index, and meanwhile N process tables connected with the handling table are created according to the information index; and carrying out information description on the information data in the office table based on the process table, and completing second storage of the government office information according to the information description result. The method has the advantages that the office process data of the government affair service is stored through the star-shaped data model, the data association degree and the analyzability are improved, a solid data base is provided for the comprehensive application of the government affair big data, the storage standardization of different types of data is guaranteed, the storage efficiency of office information is improved, and the data storage effect is standardized.
Description
Technical Field
The invention relates to the technical field of data storage, in particular to a piece information base data storage method applying a star-shaped data model.
Background
At present, in government databases at all levels, conventional databases are generally used for storing office process data, each data table is associated according to office ID (identity) major keys, office information is taken as a major part, various process information is taken as an auxiliary part, and the office process data processing method is only suitable for searching the process data through office and only can analyze office data in a single dimension, and is not beneficial to mining the office process data value.
Therefore, the invention provides a data storage method of a piece information base applying a star data model, which consists of a piece handling Table (face Table) and a group of process tables (Dimension tables), wherein the piece handling Table is taken as a center, and all the process tables are directly connected to the piece handling Table, so that a mode of multidimensional analysis space is realized. The method is beneficial to improving the data query speed, and the data structure has better readability and is easier to understand. The method is more suitable for being used as a data source for multidimensional analysis of government affair big data; the star-shaped data model is used for storing the office process data of the government affair service, so that the data association degree and the analyzability are improved, and a solid data base is provided for the comprehensive application of the government affair big data.
Disclosure of Invention
The invention provides a data storage method of a office information base applying a star data model, which is used for storing office process data of government service through the star data model by determining information types of office information capable of handling government affairs and information descriptions of different government affair office information and storing the government affair office information and the corresponding information descriptions in an office table and a process table respectively, thereby improving data association degree and analyzability, providing a firm data basis for comprehensive application of government affair big data, guaranteeing storage standardization of different types of data, improving storage efficiency of office information and standardizing data storage effect.
The invention provides a piece information base data storage method applying a star-shaped data model, which comprises the following steps:
step 1: acquiring N information types of government affair office information, and creating N information indexes in an office table according to the N information types;
step 2: the method comprises the steps that information data corresponding to government affair handling information are stored in a handling table firstly based on an information index, and meanwhile N process tables connected with the handling table are created according to the information index;
step 3: and carrying out information description on the information data in the office table based on the process table, and completing second storage of the government office information according to the information description result.
Preferably, in step 1, N information types of government office information are obtained, including:
acquiring an expected operation target of the government affair hall, analyzing the expected operation target, and determining a transactable business information set of the government affair hall;
determining data feature vectors of the business information which can be processed in the business information sets, and clustering the business information which can be processed based on the data feature vectors to obtain N sub business information sets which can be processed;
extracting class characteristics of N sub-transactable service information sets respectively, and determining service functions corresponding to different sub-transactable service information sets based on the class characteristics, wherein one sub-transactable service information set corresponds to one class characteristic;
and respectively determining class names of the N sub-transactable service information sets based on the service function, and judging the class names as N information types corresponding to the government affair handling information.
Preferably, in step 1, creating N information indexes in the office table according to N information types, where the method includes:
reading the information type, determining the type characteristic of the information type, and performing text characterization on the type characteristic to obtain a target field corresponding to the information type;
address coding is carried out on the target field corresponding to the information type, and an index link of the target field is obtained;
acquiring the composition keywords of the target field, and creating sub-index identifiers for each composition keyword;
establishing an index creation request based on the index links of the target fields and the sub-index identifiers of each component keyword, and inputting the index creation request to a request verification terminal for verification;
when the request verification terminal passes the verification, an information index corresponding to the information type is created based on the index link of the target field and the sub-index identification of each component key.
Preferably, a method for storing data in a piece information base by applying a star-shaped data model inputs an index creation request to a request verification terminal for verification, including:
acquiring a request input format condition of a request verification terminal, and determining a request content standard of the request verification terminal;
performing first verification on the index creation request according to the request input format condition;
when the request format of the index creation request does not accord with the request input format condition, judging that the index creation request does not pass verification;
otherwise, inputting the index creation request into a request verification terminal to perform second verification based on the request content standard, and judging that the index creation request passes the verification when the request content of the index creation request meets the request standard.
Preferably, in step 2, information data corresponding to government office information is first stored in an office table based on an information index, including:
determining target government affair handling information based on the information index, and simultaneously creating a data storage block corresponding to the information index in a handling table;
reading information characteristics of the target government office information, and constructing a target operator in the data storage block according to the information characteristics;
determining information data of target government office information, loading the information data into a data storage block, and calculating the information data based on a target operator to obtain a data calculation result;
and storing the calculation result and the information data of the target government affair handling information in a storage block for the first time.
Preferably, in step 2, N process tables connected to the office table are created according to the information index, including:
constructing N process tables with the same number as the information indexes, taking the information indexes as header titles of the process tables, and determining first connection identifiers of the process tables according to the header titles;
determining a second connection identity based on the information index;
matching the first connection identifier with the second connection identifier, creating a target connection line when the first connection identifier is consistent with the second connection identifier, and taking the first connection identifier and the second connection identifier as a marker of the target connection line;
and connecting the process table with the office table according to the target connecting line and the marker.
Preferably, in step 3, information description is performed on information data in a handling table based on a process table, and second storage of government office information is completed according to an information description result, including:
acquiring an activating factor of a target process table, activating the target table in the target process table according to the activating factor, and generating a data reading instruction according to the table attribute of the target table after the activation is completed;
and reading the target data in the office form based on the data reading instruction, determining the text meaning corresponding to the target data in the target process form based on the reading result, filling the text meaning of the target data in the target form, and finishing the second storage of the government office information based on the filling result.
Preferably, a method for storing data in a piece information base by applying a star-shaped data model further comprises:
forming a piece handling information base based on the first storage result and the second storage result, and setting a first key layer, a second key layer and a third key layer in the piece handling information base, wherein the first key layer is connected with the second key layer, and the second key layer is connected with the third key layer;
the first key layer is used for collecting the data access requests and determining the working state of the second key layer, and when the second key layer is in an idle state, the data access requests are transmitted to the second key layer;
the second key layer is used for reading the data access request, determining the request authority corresponding to the data access request and transmitting the data request authority to the third key layer;
and the third key layer is used for storing government affair handling information and calling target data based on the data request authority.
Preferably, a method for storing data in a piece information base by applying a star-shaped data model, the second key layer includes:
reading the data access request, and determining login information of a target user in the data access request and a data reading target of the target user;
acquiring a user account of a target user based on login information, performing association mapping on the user account and a user information management library, and registering a file based on information of the target user of an association mapping result;
reading the information registration file, determining registration information of the target user, and determining a readable data range of the target user according to the registration information;
and matching the readable data range with a data reading target, and determining the data request authority based on the matching result.
Preferably, a method for storing data in a piece information base by applying a star-shaped data model further comprises:
constructing a first measurement matrix based on information data corresponding to the information index in the first storage, and constructing a second measurement matrix for information description of the information data corresponding to the information index in the second storage, wherein the first measurement matrix corresponds to the second measurement matrix one by one;
performing iterative learning on the first measurement matrix and the second measurement matrix in the target neural network, and establishing a data identification model for performing data storage in the office information base according to the iterative learning result;
identifying error data in the office information base based on the data identification model, marking the error data in the office information base, and determining the total data amount of the error data;
and determining the storage efficiency of the government affair handling information according to the total data amount of the error data, and storing and optimizing operation when the storage efficiency is smaller than a set threshold value.
Additional features and advantages of the invention will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. The objectives and other advantages of the invention will be realized and attained by the structure particularly pointed out in the written description and claims thereof as well as the appended drawings.
The technical scheme of the invention is further described in detail through the drawings and the embodiments.
Drawings
The accompanying drawings are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate the invention and together with the embodiments of the invention, serve to explain the invention. In the drawings:
FIG. 1 is a flow chart of a method for storing data in a piece information base by applying a star data model according to an embodiment of the present invention;
FIG. 2 is a flowchart of step 1 in a method for storing data in a piece database using a star data model according to an embodiment of the present invention;
FIG. 3 is a diagram of a database of office information in an embodiment of the present invention.
Detailed Description
The preferred embodiments of the present invention will be described below with reference to the accompanying drawings, it being understood that the preferred embodiments described herein are for illustration and explanation of the present invention only, and are not intended to limit the present invention.
Example 1:
the embodiment provides a piece information base data storage method applying a star-shaped data model, as shown in fig. 1, including:
step 1: acquiring N information types of government affair office information, and creating N information indexes in an office table according to the N information types;
step 2: the method comprises the steps that information data corresponding to government affair handling information are stored in a handling table firstly based on an information index, and meanwhile N process tables connected with the handling table are created according to the information index;
step 3: and carrying out information description on the information data in the office table based on the process table, and completing second storage of the government office information according to the information description result.
In this embodiment, the government office information may be a business type to be transacted, specifically may be a real estate class, a social security class, etc., and the information type of the government office information is not unique.
In this embodiment, the information index may be a summary of information categories corresponding to different government office information, where the summary is the information index, and is used to represent a large category of business types that can be handled.
In this embodiment, the office table may be a table for storing the information index and specific data corresponding to the information index, where the specific data may be a data value of government office information.
In this embodiment, the information data may be specific data content corresponding to the government office information.
In this embodiment, the first storage may be to store an information index corresponding to the government office information and corresponding information data in the office table.
In this embodiment, the process table may be a subclass corresponding to an information index for representing different government office information in the office table, which is a further extension or supplementary description of the government office information, and specifically may be that the information index of the government office information is a real estate, and the process table may include: house property registration, house property passing, etc.
In this embodiment, the information description may be a plurality of different service categories obtained by subdividing different government service office information in the office table.
In this embodiment, the second storage may be storing the information description in a created process table.
The beneficial effects of the technical scheme are as follows: the information types of the government affair handling information and the information descriptions of different government affair handling information which can be handled are determined, and the government affair handling information and the corresponding information descriptions are respectively stored in a handling table and a process table, so that the handling process data of the government affair service is stored through a star-shaped data model, the data association degree and the analyzability are improved, a solid data basis is provided for the comprehensive application of the government affair big data, the storage standardization of different types of data is ensured, the storage efficiency of the government affair handling information is improved, and the data storage effect is standardized.
Example 2:
on the basis of embodiment 1, this embodiment provides a method for storing office information base data by applying a star-shaped data model, as shown in fig. 2, in step 1, obtaining N information types of office information includes:
s101: acquiring an expected operation target of the government affair hall, analyzing the expected operation target, and determining a transactable business information set of the government affair hall;
s102: determining data feature vectors of the business information which can be processed in the business information sets, and clustering the business information which can be processed based on the data feature vectors to obtain N sub business information sets which can be processed;
s103: extracting class characteristics of N sub-transactable service information sets respectively, and determining service functions corresponding to different sub-transactable service information sets based on the class characteristics, wherein one sub-transactable service information set corresponds to one class characteristic;
s104: and respectively determining class names of the N sub-transactable service information sets based on the service function, and judging the class names as N information types corresponding to the government affair handling information.
In this embodiment, the intended operational target may be the type of business item that the government lobby is expected to be able to contain at runtime.
In this embodiment, the set of transactable business information may be all business categories that the government lobby is capable of transacting.
In this embodiment, the data feature vector may be a business feature corresponding to a business that can be handled.
In this embodiment, the sub-transactable service information set may be different types of transactable service information obtained by classifying the transactable service information according to the data feature vector of the transactable service information.
In this embodiment, the category features may be data features corresponding to each type of business information, and specifically may be features such as a value range of each type of business information.
In this embodiment, the service functions may be of a type that can be implemented by different sub-transactable service information.
In this embodiment, the class name may be a class name assigned to each sub-transactable service information set, so as to facilitate determining specific class information corresponding to the transactable service information of the class.
The beneficial effects of the technical scheme are as follows: through analyzing the expected operation targets of the government affair hall, the method and the system realize effective confirmation of the transactable business information set of the government affair hall according to analysis results, and extract the data feature vector of the transactable business information to realize classification of the transactable business information set, so that the information type of the government affair office information is effectively locked according to classification results, and convenience and guarantee are provided for realizing first storage of the government affair office information.
Example 3:
on the basis of embodiment 1, the present embodiment provides a method for storing information base data of a office component using a star-shaped data model, in step 1, creating N information indexes in an office component table according to N information types, including:
reading the information type, determining the type characteristic of the information type, and performing text characterization on the type characteristic to obtain a target field corresponding to the information type;
address coding is carried out on the target field corresponding to the information type, and an index link of the target field is obtained;
acquiring the composition keywords of the target field, and creating sub-index identifiers for each composition keyword;
establishing an index creation request based on the index links of the target fields and the sub-index identifiers of each component keyword, and inputting the index creation request to a request verification terminal for verification;
when the request verification terminal passes the verification, an information index corresponding to the information type is created based on the index link of the target field and the sub-index identification of each component key.
In this embodiment, sub-index identifiers are created for each constituent key in order to increase indexing efficiency.
In this embodiment, the type feature may be a data feature of each type of government office information, and specifically may be a value range of each type of business data that can be handled, and the like.
In this embodiment, the text representation may be a presentation of the type feature in text form.
In this embodiment, the target field may be a specific field content corresponding to the type feature of the different information types.
In this embodiment, the index link may be to set a hyperlink to the target field, and each jump to the corresponding process table by the motor.
In this embodiment, the constituent key may be a piece of data in the target field that can characterize the field content.
In this embodiment, the sub-index identification may be to create a corresponding marker symbol for each constituent key for distinguishing the data type contained in the constituent key.
The beneficial effects of the technical scheme are as follows: by determining the information type of the government affair handling information, determining a corresponding target field according to the information type, setting the target field as an index link, and creating an index mark for each component keyword in the target field, thereby creating an information index corresponding to each information type according to the index link and the index mark, storing the handling process data of the government affair service through a star-shaped data model, and improving the data association degree and the analyzability.
Example 4:
on the basis of embodiment 3, the present embodiment provides a method for storing information base data of a piece by applying a star-shaped data model, wherein the method for inputting an index creation request to a request verification terminal for verification includes:
acquiring a request input format condition of a request verification terminal, and determining a request content standard of the request verification terminal;
performing first verification on the index creation request according to the request input format condition;
when the request format of the index creation request does not accord with the request input format condition, judging that the index creation request does not pass verification;
otherwise, inputting the index creation request into a request verification terminal to perform second verification based on the request content standard, and judging that the index creation request passes the verification when the request content of the index creation request meets the request standard.
In this embodiment, the request input format condition may be a condition required by the request verification terminal for the format or the like of the data to be input.
In this embodiment, the requested content criteria may be the content of the data to be received, the requirement of normalization, and the like.
In this embodiment, the first verification may be a verification of the index creation request by requesting the input format condition.
In this embodiment, the second verification may be verification of the index creation request by the request content.
The beneficial effects of the technical scheme are as follows: by analyzing the request verification terminal, the request input format condition and the request content standard of the request verification terminal are effectively acquired, so that the index creation request is accurately and reliably verified, the reliability of the created information index is ensured, and the data association degree and the analyzability are improved conveniently.
Example 5:
on the basis of embodiment 1, the present embodiment provides a method for storing information data of a office information base by applying a star-shaped data model, in step 2, information data corresponding to office information is stored in an office table for the first time based on an information index, including:
determining target government affair handling information based on the information index, and simultaneously creating a data storage block corresponding to the information index in a handling table;
reading information characteristics of the target government office information, and constructing a target operator in the data storage block according to the information characteristics;
determining information data of target government office information, loading the information data into a data storage block, and calculating the information data based on a target operator to obtain a data calculation result;
and storing the calculation result and the information data of the target government affair handling information in a storage block for the first time.
In this embodiment, the target operator may be an accumulation or the like.
In this embodiment, the target office information may be an office information type that needs to be processed or stored with related data.
In this embodiment, the data storage block may be a data storage space provided in the office table for the target government office information.
In this embodiment, the information feature may be an information type of the target government office information, a corresponding specific data content, and the like.
The beneficial effects of the technical scheme are as follows: the data storage block is created for the target government office information to be stored in the office table, meanwhile, the information data corresponding to the target government office information is determined, and the information data is processed through the target operator, so that the government office information is effectively stored in the office table, the data association degree and the analyzability are improved conveniently, and meanwhile, the storage standardization of the data is guaranteed.
Example 6:
on the basis of embodiment 1, the present embodiment provides a method for storing information base data of office work by applying a star-shaped data model, in step 2, N process tables connected with the office work table are created according to information indexes, including:
constructing N process tables with the same number as the information indexes, taking the information indexes as header titles of the process tables, and determining first connection identifiers of the process tables according to the header titles;
determining a second connection identity based on the information index;
matching the first connection identifier with the second connection identifier, creating a target connection line when the first connection identifier is consistent with the second connection identifier, and taking the first connection identifier and the second connection identifier as a marker of the target connection line;
and connecting the process table with the office table according to the target connecting line and the marker.
In this embodiment, the header may be a header of each process table, which is used to characterize the service type to which the process table belongs.
In this embodiment, the first connection identifier may be a connection relationship between the process table and the office table determined according to the header.
In this embodiment, the second connection identifier may be a connection relationship between the process table and the office table determined according to the information index.
In this embodiment, the target connection line may be a line connecting the information types of the government affair handling information in the process table and the handling table.
The beneficial effects of the technical scheme are as follows: by determining the header titles of different process tables according to the information index, and simultaneously determining the first connection identifier and the second connection identifier according to the information index, the corresponding target connecting lines are finally established according to the first connection identifier and the second connection identifier, so that the process tables and the office tables are accurately and reliably connected, the data association degree and the analyzability are improved, and the normative storage of different types of data is facilitated.
Example 7:
on the basis of embodiment 1, the present embodiment provides a method for storing information in a office information base by applying a star-shaped data model, in step 3, information description is performed on information data in the office table based on a process table, and second storage of office information is completed according to an information description result, including:
acquiring an activating factor of a target process table, activating the target table in the target process table according to the activating factor, and generating a data reading instruction according to the table attribute of the target table after the activation is completed;
and reading the target data in the office form based on the data reading instruction, determining the text meaning corresponding to the target data in the target process form based on the reading result, filling the text meaning of the target data in the target form, and finishing the second storage of the government office information based on the filling result.
In this embodiment, the target process table may be a process table that needs to be processed.
In this embodiment, the activating factor may be a tool for changing the working state of the process table, and may specifically be a call instruction for calling the interface, etc.
In this embodiment, the target table may be a presence table in the target process table for storing different information descriptions.
In this embodiment, the table attribute may be a data type that the target table can store, a storage capacity that can store data, and the like.
In this embodiment, the target data may be specific data content corresponding to the government office information having a relationship with the current process table in the office table.
In this embodiment, the text meaning may be descriptive data describing information data of the target data in the office table, specifically, when the office information is the house ownership year 70, the data in the office table are the properties (index information) and 70, and the text meaning of the process table is: house ownership years.
The beneficial effects of the technical scheme are as follows: by activating the process table and corresponding the target table contained in the process table to the corresponding target data in the office table, accurate locking of filling content of the target table in the process table according to text meanings of the target data in the office table is achieved, specific content corresponding to the text meanings is stored in the target table in the process table, data association and analyzability are improved conveniently, and meanwhile storage reliability and storage normalization of different types of data are guaranteed conveniently.
Example 8:
on the basis of embodiment 1, this embodiment provides a method for storing information base data of a piece by applying a star-shaped data model, as shown in fig. 3, further including:
forming a piece handling information base based on the first storage result and the second storage result, and setting a first key layer, a second key layer and a third key layer in the piece handling information base, wherein the first key layer is connected with the second key layer, and the second key layer is connected with the third key layer;
the first key layer is used for collecting the data access requests and determining the working state of the second key layer, and when the second key layer is in an idle state, the data access requests are transmitted to the second key layer;
the second key layer is used for reading the data access request, determining the request authority corresponding to the data access request and transmitting the data request authority to the third key layer;
and the third key layer is used for storing government affair handling information and calling target data based on the data request authority.
In this embodiment, the first key layer may be to firstly implement interception of the data access request, so as to avoid random extraction of data.
In this embodiment, the working state of the second key layer may be: busy state and idle state.
In this embodiment, the second key layer may be used to read the data access request, so as to determine the request authority corresponding to the data access request.
In this embodiment, the third key layer may be used to store data information corresponding to the first storage result and the second storage result, and identify the request authority to determine the target data to be read.
In this embodiment, the target data may be data that the data access request needs to access.
In this embodiment, the request authority may be a data authority for reading in the third critical layer.
The beneficial effects of the technical scheme are as follows: by establishing the first key layer, interception of the data access request can be effectively realized, and when the second key layer is in an idle state, the data access request is transmitted to the second key layer; the accurate analysis of the data access request is realized through the second key, so that the data extraction range (namely the data authority) is locked, the third key layer accurately reads the target data based on the data authority, the accuracy of data reading is improved, and the safety of the rest data in the office information base is also ensured.
Example 9:
on the basis of embodiment 8, this embodiment provides a method for storing information base data of office work by applying star-shaped data model, and the second key layer includes:
reading the data access request, and determining login information of a target user in the data access request and a data reading target of the target user;
acquiring a user account of a target user based on login information, performing association mapping on the user account and a user information management library, and registering a file based on information of the target user of an association mapping result;
reading the information registration file, determining registration information of the target user, and determining a readable data range of the target user according to the registration information;
and matching the readable data range with a data reading target, and determining the data request authority based on the matching result.
In this embodiment, the login information of the target user may be a login account including the target user, a login name, and a permission level of the target user, and the like.
In this embodiment, the data read target of the target user may be target data that the target user wants to extract in the office information base.
In this embodiment, the user information management library may be set in advance, and is used to store user information of the user that reads the office information library, including user accounts of users registered in all levels, and information registration files corresponding to each user account.
In this embodiment, the information registration file may be a readable data range that includes that the user can be in the office information base, for example, if the information registered by the user is medical social security, the readable data range value of the user may be medical data, and the setting may be to realize security and privacy of the data.
In this embodiment, the readable data range may be data content that can be read by a user, wherein the target data belongs to the readable data range.
In this embodiment, the matching result may be that target data extracted within a readable data range based on the data reading target is a matching result.
The beneficial effects of the technical scheme are as follows: by determining the login information of the target user, the readable data range of the target user can be accurately determined, and by determining the data reading target of the target user, the accurate matching of the data reading target and the readable data range is realized, and then the data request authority is determined, so that the accuracy of the target data reading by the user is improved, and the security and privacy of the data in the office information base are guaranteed.
Example 10:
on the basis of embodiment 1, this embodiment provides a method for storing information base data of office piece by applying star-shaped data model, further comprising:
constructing a first matrix based on information data corresponding to the information index in the first storage, and constructing a second matrix for information description of the information data corresponding to the information index in the second storage, wherein the first matrix corresponds to the second matrix one by one;
learning the first matrix and the second matrix in a target neural network, and establishing a data identification model for data storage in a piece information base according to an iterative learning result;
wherein IDE represents a data recognition model; n represents the total number of identification frames of the first matrix; i represents the current identification frame of the first matrix; delta represents an equalization coefficient between an estimation error of information data and an estimation error of abnormal data in the information data, and the value is 0.5; m is M i Representing the pairs of ith identification frames in a first matrixA response information data value;representing a target neural network output value corresponding to an ith identification frame in a first matrix; w represents the total number of identification frames of the second matrix; j represents the current identification frame of the first matrix; s is S j Representing the information data value corresponding to the jth identification frame in the second matrix; />Representing a target neural network output value corresponding to the jth identification frame in the second matrix;
identifying error data in the office information base based on the data identification model, marking the error data in the office information base, and determining the data quantity of the error data;
determining the storage efficiency of storing the government affair handling information according to the data quantity of the error data;
wherein, eta represents the storage efficiency of storing the government affair handling information; ζ represents an error factor, and the value range is (0.03,0.035); k represents the total data volume of the government affair handling information; omega represents the data amount of error data; q represents the correct data volume in the government office information;
comparing the storage efficiency with a set threshold value, and evaluating the storage condition of the government office information;
when the storage efficiency is equal to or greater than a set threshold, the storage condition of storing the government affair handling information is good;
otherwise, the storage condition of storing the government affair handling information is poor;
when the storage condition of storing the government affair handling information is bad, setting an optimization factor for optimizing the storage of the government affair handling information based on the data identification model, and performing storage optimization operation on the handling information base based on the optimization factor.
In this embodiment, the set threshold may be a measurement value set in advance for evaluating a storage condition in which the government office information is stored.
In this embodiment, the optimization factor may be a factor that performs storage optimization on the optimized government office information determined based on model parameters of the data identification model.
In this embodiment, the optimization operation may be to determine conditions of data identification through the data identification model, so as to filter error data storage in the office part information base according to the conditions of data identification, thereby realizing accuracy of data storage.
The beneficial effects of the technical scheme are as follows: the data identification model is determined, so that the error data in the office information base is accurately identified, the error data amount in the office information base is determined, the storage efficiency for storing the government office information can be accurately calculated through the error data amount, the office information is evaluated in a mutual searching storage condition, the storage condition of the office information base is reasonably and objectively determined, and the accurate monitoring of the office information base data storage condition is improved.
It will be apparent to those skilled in the art that various modifications and variations can be made to the present invention without departing from the spirit or scope of the invention. Thus, it is intended that the present invention also include such modifications and alterations insofar as they come within the scope of the appended claims or the equivalents thereof.
Claims (8)
1. A piece information base data storage method applying a star data model is characterized by comprising the following steps:
step 1: acquiring N information types of government affair office information, and creating N information indexes in an office table according to the N information types;
step 2: the method comprises the steps that information data corresponding to government affair handling information are stored in a handling table firstly based on an information index, and meanwhile N process tables connected with the handling table are created according to the information index;
step 3: carrying out information description on the information data in the office table based on the process table, and completing second storage of the government office information according to the information description result;
in step 1, obtaining N information types of government affair handling information includes:
acquiring an expected operation target of the government affair hall, analyzing the expected operation target, and determining a transactable business information set of the government affair hall;
determining data feature vectors of the business information which can be processed in the business information sets, and clustering the business information which can be processed based on the data feature vectors to obtain N sub business information sets which can be processed;
extracting class characteristics of N sub-transactable service information sets respectively, and determining service functions corresponding to different sub-transactable service information sets based on the class characteristics, wherein one sub-transactable service information set corresponds to one class characteristic;
respectively determining class names of N sub-transactable business information sets based on the business functions, and judging the class names as N information types corresponding to the government affair handling information;
in step 1, creating N information indexes in the office table according to N information types, including:
reading the information type, determining the type characteristic of the information type, and performing text characterization on the type characteristic to obtain a target field corresponding to the information type;
address coding is carried out on the target field corresponding to the information type, and an index link of the target field is obtained;
acquiring the composition keywords of the target field, and creating sub-index identifiers for each composition keyword;
establishing an index creation request based on the index links of the target fields and the sub-index identifiers of each component keyword, and inputting the index creation request to a request verification terminal for verification;
when the request verification terminal passes the verification, an information index corresponding to the information type is created based on the index link of the target field and the sub-index identification of each component key.
2. The method for storing information in a database of office parts using a star data model according to claim 1, wherein inputting the index creation request to the request verification terminal for verification comprises:
acquiring a request input format condition of a request verification terminal, and determining a request content standard of the request verification terminal;
performing first verification on the index creation request according to the request input format condition;
when the request format of the index creation request does not accord with the request input format condition, judging that the index creation request does not pass verification;
otherwise, inputting the index creation request into a request verification terminal to perform second verification based on the request content standard, and judging that the index creation request passes the verification when the request content of the index creation request meets the request standard.
3. The method for storing information in a office information base using a star data model according to claim 1, wherein in step 2, the first storing, in the office table, information data corresponding to office information based on an information index includes:
determining target government affair handling information based on the information index, and simultaneously creating a data storage block corresponding to the information index in a handling table;
reading information characteristics of the target government office information, and constructing a target operator in the data storage block according to the information characteristics;
determining information data of target government office information, loading the information data into a data storage block, and calculating the information data based on a target operator to obtain a data calculation result;
and storing the calculation result and the information data of the target government affair handling information in a storage block for the first time.
4. The method for storing information in a database of office parts using a star data model according to claim 1, wherein in step 2, creating N process tables connected to the office part tables according to the information index comprises:
constructing N process tables with the same number as the information indexes, taking the information indexes as header titles of the process tables, and determining first connection identifiers of the process tables according to the header titles;
determining a second connection identity based on the information index;
matching the first connection identifier with the second connection identifier, creating a target connection line when the first connection identifier is consistent with the second connection identifier, and taking the first connection identifier and the second connection identifier as a marker of the target connection line;
and connecting the process table with the office table according to the target connecting line and the marker.
5. The method for storing information in a office information base using a star data model according to claim 1, wherein in step 3, information description is performed on information data in the office table based on a process table, and the second storing of the office information is completed according to the information description result, including:
acquiring an activating factor of a target process table, activating the target table in the target process table according to the activating factor, and generating a data reading instruction according to the table attribute of the target table after the activation is completed; the activating factor is a calling instruction for calling the interface;
and reading the target data in the office form based on the data reading instruction, determining the text meaning corresponding to the target data in the target process form based on the reading result, filling the text meaning of the target data in the target form, and finishing the second storage of the government office information based on the filling result.
6. The method for storing information in a piece database using a star data model according to claim 1, further comprising:
forming a piece handling information base based on the first storage result and the second storage result, and setting a first key layer, a second key layer and a third key layer in the piece handling information base, wherein the first key layer is connected with the second key layer, and the second key layer is connected with the third key layer;
the first key layer is used for collecting the data access requests and determining the working state of the second key layer, and when the second key layer is in an idle state, the data access requests are transmitted to the second key layer;
the second key layer is used for reading the data access request, determining the request authority corresponding to the data access request and transmitting the data request authority to the third key layer;
and the third key layer is used for storing government affair handling information and calling target data based on the data request authority.
7. The method for storing information in a piece database using a star data model of claim 6, wherein the second key layer comprises:
reading the data access request, and determining login information of a target user in the data access request and a data reading target of the target user;
acquiring a user account of a target user based on login information, performing association mapping on the user account and a user information management library, and registering a file based on information of the target user of an association mapping result;
reading the information registration file, determining registration information of the target user, and determining a readable data range of the target user according to the registration information;
and matching the readable data range with a data reading target, and determining the data request authority based on the matching result.
8. The method for storing information in a piece database using a star data model according to claim 1, further comprising:
constructing a first matrix based on information data corresponding to the information index in the first storage, and constructing a second matrix for information description of the information data corresponding to the information index in the second storage, wherein the first matrix corresponds to the second matrix one by one;
performing iterative learning on the first matrix and the second matrix in the target neural network, and establishing a data identification model for performing data storage in the office information base according to the iterative learning result;
identifying error data in the office information base based on the data identification model, marking the error data in the office information base, and determining the total data amount of the error data;
and determining the storage efficiency of the government affair handling information according to the total data amount of the error data, and storing and optimizing operation when the storage efficiency is smaller than a set threshold value.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211416835.6A CN115640369B (en) | 2022-11-14 | 2022-11-14 | Piece information base data storage method applying star-shaped data model |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211416835.6A CN115640369B (en) | 2022-11-14 | 2022-11-14 | Piece information base data storage method applying star-shaped data model |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115640369A CN115640369A (en) | 2023-01-24 |
| CN115640369B true CN115640369B (en) | 2023-12-15 |
Family
ID=84948315
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211416835.6A Active CN115640369B (en) | 2022-11-14 | 2022-11-14 | Piece information base data storage method applying star-shaped data model |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115640369B (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101950295A (en) * | 2010-08-17 | 2011-01-19 | 南京中图数码科技有限公司 | Intelligent starlike structure modeling method applied to traffic signal system management |
| CN102184196A (en) * | 2011-04-21 | 2011-09-14 | 中国电子信息产业集团有限公司第六研究所 | Petition integrated management information system |
| CN112199351A (en) * | 2020-09-30 | 2021-01-08 | 澳优乳业（中国）有限公司 | Mobile sales data storage method and system, electronic equipment and storage medium |
| CN113379243A (en) * | 2021-06-09 | 2021-09-10 | 爱驰汽车有限公司 | Service subsystem evaluation method and device based on central platform and computer equipment |
| CN114428814A (en) * | 2021-12-29 | 2022-05-03 | 上海晶赞融宣科技有限公司 | Self-service analysis modeling method for different-scale aggregation of large data set |
| CN115168506A (en) * | 2022-07-04 | 2022-10-11 | 四川大学 | Multi-platform distributed data integration method, system and storage medium |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030018616A1 (en) * | 2001-06-05 | 2003-01-23 | Wilbanks John Thompson | Systems, methods and computer program products for integrating databases to create an ontology network |
-
2022
- 2022-11-14 CN CN202211416835.6A patent/CN115640369B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101950295A (en) * | 2010-08-17 | 2011-01-19 | 南京中图数码科技有限公司 | Intelligent starlike structure modeling method applied to traffic signal system management |
| CN102184196A (en) * | 2011-04-21 | 2011-09-14 | 中国电子信息产业集团有限公司第六研究所 | Petition integrated management information system |
| CN112199351A (en) * | 2020-09-30 | 2021-01-08 | 澳优乳业（中国）有限公司 | Mobile sales data storage method and system, electronic equipment and storage medium |
| CN113379243A (en) * | 2021-06-09 | 2021-09-10 | 爱驰汽车有限公司 | Service subsystem evaluation method and device based on central platform and computer equipment |
| CN114428814A (en) * | 2021-12-29 | 2022-05-03 | 上海晶赞融宣科技有限公司 | Self-service analysis modeling method for different-scale aggregation of large data set |
| CN115168506A (en) * | 2022-07-04 | 2022-10-11 | 四川大学 | Multi-platform distributed data integration method, system and storage medium |
Non-Patent Citations (4)
| Title |
|---|
| 基于数据仓库技术建立电力营销系统;李雪;苑津莎;张卫华;;江苏电机工程(第01期);全文 * |
| 基于数据仓库的文献资料采办系统设计研究;王睿;曾斌;;图书馆学刊(第09期);全文 * |
| 基于用户需求的多维农业信息分类模型研究――以湖南省油菜网络信息为例;王晓乔;廖桂平;王访;李锦卫;邱春荣;;中国农学通报(第32期);全文 * |
| 社保系统数据模型设计;李俊;徐颖;;牡丹江大学学报(第03期);第124-126页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115640369A (en) | 2023-01-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CA2471940C (en) | Real time data warehousing | |
| US8620937B2 (en) | Real time data warehousing | |
| US11386224B2 (en) | Method and system for managing personal digital identifiers of a user in a plurality of data elements | |
| CN112506925A (en) | Data retrieval system and method based on block chain | |
| CN113688311A (en) | Information recommendation method, device and equipment based on data interaction and storage medium | |
| US20240127143A1 (en) | Method, device and storage medium for information processing based on data interaction | |
| CN112069269B (en) | Big data and multidimensional feature-based data tracing method and big data cloud server | |
| CN115640369B (en) | Piece information base data storage method applying star-shaped data model | |
| CN109087053B (en) | Collaborative office processing method, device, equipment and medium based on association topological graph | |
| US20030120614A1 (en) | Automated e-commerce authentication method and system | |
| CN109636578A (en) | Risk checking method, device, equipment and the readable storage medium storing program for executing of credit information | |
| CN111460268B (en) | Method and device for determining database query request and computer equipment | |
| CN110765232B (en) | Data processing method, data processing device, computer equipment and storage medium | |
| CN114090076A (en) | Method and device for judging compliance of application program | |
| CN113704601A (en) | Information interaction method, device, equipment and storage medium | |
| CN111475657A (en) | Display device, display system and entity alignment method | |
| CN112559823B (en) | Data standardized data acquisition method | |
| CN116521776B (en) | Quick information query system | |
| CN113949529B (en) | Credible hybrid cloud management platform access method and system | |
| CN116303375B (en) | Database maintenance analysis method, server and medium based on big data | |
| CN110377515B (en) | Method for testing data quality of crawler | |
| CN114647615A (en) | Document collection method and device and computer storage medium | |
| CN115017224A (en) | User identity portrait generation method based on computer environment | |
| CN115187339A (en) | Business order information processing method and device based on artificial intelligence | |
| CN111459970A (en) | Method for checking uniqueness of object information |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |