CN109146397A - A kind of processing method, server and the storage medium of index application - Google Patents
A kind of processing method, server and the storage medium of index application Download PDFInfo
- Publication number
- CN109146397A CN109146397A CN201810713087.5A CN201810713087A CN109146397A CN 109146397 A CN109146397 A CN 109146397A CN 201810713087 A CN201810713087 A CN 201810713087A CN 109146397 A CN109146397 A CN 109146397A
- Authority
- CN
- China
- Prior art keywords
- index
- people
- copending
- application
- permission
- 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.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Engineering & Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Operations Research (AREA)
- Economics (AREA)
- Marketing (AREA)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses processing method, server and the storage mediums of a kind of index application, which comprises copending people sends application record table to data center, and the application record table includes information: application index；Copending people's index relation table is obtained, permission judgement is carried out according to copending people's index relation table and the application record table；Judge that copending people without temporary, terminates requisition procedure；Judge that copending people has temporary, forms user and apply for index table；Apply for index table according to the user, extracts index dimensional relationships table.The present invention is conducive to index applications management, improves the achievement data efficiency of management by the way that different index application permissions is arranged for different copending people.
Description
Technical field
The present invention relates to data processing fields more particularly to a kind of processing method of index application, server and storage to be situated between
Matter.
Background technique
With the development of mobile network, traditional performance statistics object, is no longer satisfied enterprise customer and refines
The requirement of operation, the user behavior analysis to come into being become the concern target of enterprise customer and improve the basis of profitability.
User behavior analysis can be counted by event log to user and media message content, these event logs and media
The content that message is included is united on the basis of event log and media message considerably beyond traditional performance statistics object
Meter and analysis can carry out depth analysis to a series of indexs such as system performance, user behavior, obtain more valuable information.
Information in enterprise for statistics, can have some confidential data information, these usual confidential data information can lead to
Permission is crossed to be managed.
Shen is carried out to index from database often by the people having permission to the processing of index application in the prior art
Please, it is defined in the definition of permission using up rightness, i.e. permission vertical distribution, such distribution is excessively stiff, can not be flexible
Index application is handled, leads to index application processing not in time.
Summary of the invention
The purpose of the present invention is in view of the above-mentioned drawbacks of the prior art, provide a kind of processing method of index application,
Server and storage medium.
The technical solution adopted by the present invention is that providing a kind of processing method of index application first, which comprises
Copending people sends application record table to data center, and the application record table includes information: application index；
Copending people's index relation table is obtained, is carried out according to copending people's index relation table and the application record table
Permission judgement；
Judge that copending people without temporary, terminates requisition procedure；
Judge that copending people has temporary, forms user and apply for index table；
Apply for index table according to the user, extracts index dimensional relationships table.
Preferably, the application record table further comprises spare permission people solicited message, by verifying the spare power
People's solicited message is limited, obtains the authority information of spare permission people, and then corresponded to according to the spare permission human rights limit information
Authorization.
Preferably, it defines person specially designated for a post and possesses spare permission.To have the function that understand management level.
Preferably, before the copending people's index relation table of acquisition, the method also includes:
According to the classification setting index classification code of index, index classification code table is formed；
Copending people's information is obtained, copending people's information table is formed；
By the index classification code table partial association to copending people's information table, copending people's index is formed
Relation table.Copending people's index relation table is preset, the application permission for judging the copending people can be accelerated.
Preferably, described by the index classification code table partial association to copending people's information table, described in formation
Copending people's index relation table includes:
The extent of competence of the copending people is defined by higher level permission person；
According to the extent of competence, the permission index classification that the copending people can apply is determined, form permission index
Classification code；
According to the permission index classification code, corresponding classification code is extracted from the index classification code table and is formed
Permission index classification code sublist；
The permission index classification code sublist is associated with copending people's information table, forms the institute that configuration has permission
State copending people's index relation table.Copending people's index relation table is preset, the permission for conveniently treating approver authenticates, clearly
Authorize boundary.
Preferably, described that permission judgement packet is carried out according to copending people's index relation table and the application record table
It includes:
Extract the permission indication range information in copending people's index relation table；
Extract the target indicator information applied in the application record table；
It is described to judge whether the application index falls into for the target indicator for comparing the permission indication range and the application
Permission indication range.By the intersection situation of the permission indication range and the application index, judge whether copending people has
Power.
Preferably, described to judge copending people without temporary, terminating requisition procedure includes:
When comparing the permission indication range and the application index, the non-permission index of the application index is obtained
Index as a result, determining that the copending people haves no right in range.
Preferably, judge that copending people has temporary, form user and apply for that index table includes:
When comparing the permission indication range and the application index, obtaining the application index is the permission index
Index as a result, determining that the copending people has the right in range；
The application record table is added to user and applies for index table, the user applies for that index table includes dimension index letter
Breath.
Preferably, described to apply for index table according to the user, extracting index dimensional relationships table includes:
Permission index identical with the application index in the permission indication range is extracted, and the permission index is returned
The permission index classification code sublist progress permission guideline code is returned to claim；
According to the permission guideline code matching dimensionality code, index dimensional relationships code is formed；
Index dimensional relationships are claimed according to the index dimensional relationships code, form index by the index dimensional relationships
Dimensional relationships table.
Preferably, the method also includes:
By the index dimensional relationships table, to data warehouse application index dimension result table.
Secondly, providing a kind of server, which is characterized in that including processor and memory, be stored in the memory
At least one instruction, at least one section of program, code set or instruction set, at least one instruction, at least one section of program, institute
Code set or described instruction collection is stated to be loaded by the processor and executed to realize such as aforementioned described in any item index applications
Processing method.
Finally, also providing a kind of computer readable storage medium, which is characterized in that be stored at least in the storage medium
One instruction, at least one section of program, code set or instruction set, at least one instruction, at least one section of program, the generation
Code collection or described instruction collection are loaded by the processor and are executed to realize the processing such as aforementioned described in any item index applications
Method.
Compared with prior art, the present invention at least has the advantages that the present invention by for different copending people
Different index application permissions is set, index applications management is conducive to, improves the achievement data efficiency of management.
Detailed description of the invention
Fig. 1 is the implementation environment schematic diagram of the embodiment of the present invention；
Fig. 2 is the method flow diagram of the embodiment of the present invention；
Fig. 3 is a kind of embodiment flow chart of the invention；
Fig. 4 is another embodiment flow chart of the invention；
Fig. 5 is that the part of the embodiment of the present invention has authority processing method flow chart；
Fig. 6 is the pre-set level relation table flow chart of the embodiment of the present invention；
Fig. 7 is the copending people's index relation table flow chart of formation of the embodiment of the present invention；
Fig. 8 is the permission decision flow chart of the embodiment of the present invention；
Fig. 9 is that the formation user of the embodiment of the present invention applies for index table flow chart；
Figure 10 is the extraction index dimensional relationships table flow chart of the embodiment of the present invention.
Specific embodiment
The present invention will be further described with reference to the accompanying drawings and examples.
As shown in Figure 1, present invention firstly provides a kind of index dimensional relationships to define method, it is of the invention to better illustrate
Invention is intended to, and designs a kind of implementation environment that method is defined suitable for the index dimensional relationships, the implementation environment includes: end
End, the terminal can be the smart machines such as smart phone, intelligent robot, plate and computer, but it should be recognized that described
Terminal be not restricted to more than the smart machines such as smart phone, intelligent robot, plate and computer.It is described other than terminal
Implementation environment further includes providing the data warehouse 1b of data basis, the data set that the data in warehouse 1b are formed based on the data
City 2b, for request data and calculate data application layer 3b and for the presentation layer 4b of display data.
Further to illustrate the invention of the embodiment of the present invention to be intended to, the implementation environment can be specially enterprise report exhibition
Show, it, can be by being shown on the terminal (such as mobile phone) when the upward level display report of departmental staff.The terminal can be with
Related data is extracted by the data warehouse 1b that enterprise is arranged, constructs table according to the data of dimension and index, and at the terminal
The table is shown.
As a kind of environment of possible implementation, the terminal can also extract related data as number by cloud database 5b
According to source, Data Warehouse for Enterprises 1b is constructed according to the data source of extraction, constructs data further according to the data in the data warehouse 1b
Fairground 2b.
As shown in Fig. 2, the processing method of the index application comprising steps of
S11, copending people send application record table to data center, and the application record table includes information: application index.
Further, the application record table includes information: target indicator information, application time, state and the original of application
Because etc..It should be noted that wherein, the target indicator information of the application is the pointer type and dimension that copending people wants application
Spend attribute；The application time can be used for recording copending people in the application when initiated, and the application status is for remembering
Record whether copending people applies for success, the reason for the request is used to record the application motivation of copending people, the application record table
User action log can be added as event in interior information.
As a kind of possible embodiment, for make copending people know perfectly well have no right in the case where, moreover it is possible to continuation application, it is described
Application record table can further include spare permission people solicited message, by verifying the spare permission people solicited message,
The authority information of spare permission people is obtained, and then corresponding authorization is carried out according to the spare permission human rights limit information.Specifically, to
Approver provides the spare permission people solicited message in application record table, is determining copending people to the index of the application
Information extracts the spare power without temporary, obtaining the spare permission people solicited message from the application record table
The authority information having described in limit people, and go out authorization requests to the spare permission human hair, when the spare permission people responds institute
After stating authorization requests, according to response as a result, if the spare permission people agrees to authorization, the application to the copending people
Record sheet is authorized, if the spare permission people disagrees authorization, terminates requisition procedure.
As another possible embodiment, comprising applying for multiple target indicator information in the application record table, need
Applied using multiple permissions, and when the insufficient permission of the copending people, it can also be more into one in the application record table
Step includes multiple spare permission people solicited messages, by verifying the multiple spare permission people solicited message, is obtained the multiple
The authority information of spare permission people, and then corresponding authorization is carried out to complete to described according to the authority information of the spare permission people
The application for the multiple target indicator information for including in application record table.Specifically, copending people is in the application record table
Multiple target indicators are applied in middle requirement, are determining that the copending people haves no right or when insufficient permission, extract the multiple target
Indication information forms a target indicator application list；Multiple spare permission people described in the application record table are extracted to ask
Information is sought, the authority information of the multiple spare permission people is obtained, analyzes the authority information of the multiple spare permission people, is extracted
The multiple delegatable index grant item of spare permission people, forms an index grant column list；According to the target indicator Shen
Please list be allocated with the index grant column list, by the Distribution Indexes in the target indicator application list to the index
Corresponding index grant item in grant column list returns to the multiple spare permission people by index grant item, to the multiple
Spare permission human hair goes out authorization requests, after the spare permission people responds the authorization requests, according to response as a result, to authorization
Index be marked, formation can use application record table, described with comprising authorization target indicator information, using in application record table
Apply for authorization target indicator in application.
In addition, as alternatively possible embodiment, comprising applying for multiple target indicator information in the application record table,
It needs to be applied using multiple permissions, and when the insufficient permission of the copending people, possess the multiple standby of the permission from trend
Go out solicited message with permission human hair, and application record table information is dealt into the multiple spare permission people simultaneously and is confirmed, makes
The multiple spare permission people clearly knows that who will apply, what is applied for.By verifying the multiple spare permission people request
Information, obtains the authority information of the multiple spare permission people, and then is carried out pair according to the authority information of the spare permission people
It should authorize to complete the application to the multiple target indicator information for including in the application record table.Specifically, copending
People requires the multiple target indicators of application in the application record table, is determining that the copending people haves no right or when insufficient permission,
The multiple target indicator information is extracted, a target indicator application list is formed；Extract institute in the application record table
Multiple spare permission people solicited messages are stated, the authority information of the multiple spare permission people is obtained, analyze the multiple spare power
The authority information of people is limited, the multiple spare delegatable index grant item of permission people is extracted, forms an index grant column list；
It is allocated according to the target indicator application list and the index grant column list, it will be in the target indicator application list
Distribution Indexes corresponding index grant item into the index grant column list is returned to the multiple spare by index grant item
Permission people goes out authorization requests to the multiple spare permission human hair, after the spare permission people responds the authorization requests, root
According to responding as a result, the index to authorization is marked, formation can use application record table, it is described can in application record table comprising awarding
Target indicator information is weighed, for applying for application authorization target indicator.
S12, copending people's index relation table is obtained, according to copending people's index relation table and the application record table
Carry out permission judgement；It should be noted that copending people's index relation table limits the index of copending people as authority list
Application range, records the copending people and its index relationship that can apply in copending people's index relation table, it is described to
Approver's index relation table is preset.
Further, in approver's index relation table include all indexs that the copending people can apply,
To be more clear the permission boundary in copending people's index relation table, copending people's index relation table and it is described to
Approver corresponds, that is to say, that a copending people presets copending people's index relation table.Carrying out purview certification
When, the target indicator in the application record table is extracted, is closed according to the target indicator in copending people's index
It is to be searched in table, so as to judging to whether there is in copending people's index relation table on the target indicator, if depositing
Then the copending people has the right, and if it does not exist, then the copending people haves no right.
Certainly, in order to reduce the pressure of storage, copending people's index relation table is also possible to polymerize described pending
The copending people's index relationship summary table for criticizing people's index relationship, authorizes the index in copending people's index relationship summary table
Signature, i.e., sign to multiple copending people in an index；It, will be in the application record table when carrying out purview certification
Target indicator extract, pass through the target indicator obtain in copending people's index relationship summary table corresponding finger
Mark detects the signature that whether there is the copending people in the index, and if it exists, and then the copending people has the right, if it does not exist,
Then the copending people haves no right.
As a kind of possible embodiment, when there is spare permission people solicited message in the application record table, to mention
Height application efficiency can obtain described spare while obtaining copending people's index relation table from the application record table
Permission people's solicited message obtains corresponding spare permission people index relation table according to the spare rights request message, and then extracts
The authority information having described in the spare permission people out, and go out authorization requests to the spare permission human hair.
In the embodiment that a copending people presets copending people's index relation table, the spare permission people index
Relation table also corresponds to a spare permission people and presets；For all copending people, copending people's index relationship summary table is being set
In embodiment, the spare permission people index relationship is also disposed in copending people's index relationship summary table, and is signed
Certification.Above two embodiment is referred to for the specific purview certification of spare permission people, this will not be repeated here.
S13, judge that copending people without temporary, terminates requisition procedure；It should be noted that judging the copending people
Have no right, refer to that the copending people haves no right completely, is the mesh applied in the application record table that the copending people proposes
Index is marked, completely not in the extent of competence of the copending people.
Further, to keep application process more humane, before the end requisition procedure, relief journey can also be set
Sequence, the Relief Procedures comprising steps of
S131a, determine that the copending people haves no right completely；
S132a, transmission reaffirm to ask, and acquisition reaffirms to ask record sheet；The copending people becomes the target indicator of application
More, step S11 is executed；
S133a, the copending people abandon reaffirming to ask, and terminate requisition procedure.
As a kind of possible embodiment, the Relief Procedures be also possible that comprising steps of
S131b, spare permission people solicited message is preset in the application record table；
S132b, determine that the copending people haves no right completely；
S133b, spare permission people solicited message is extracted, send authorization requests to spare permission human hair；
S134b, spare permission people agree to authorization, carry out step S14；
S135b, spare permission people disagree authorization, terminate requisition procedure.
Spare permission people solicited message is specifically preset to the purview certification of spare permission people with reference to aforementioned related real
Example is applied, is not repeated separately herein.
S14, judge that copending people has temporary, form user and apply for index table；It should be noted that it is described judge to
Approver has the right, and can refer to that copending people part has the right or all has the right, that is to say, that remember in the application of the copending people
It records in table, it is possible to there are multiple target indicators, and in this multiple target indicator, the target indicator for application of having the right may not be
All, this is that part is had the right, and the target indicator for application of having the right is all, then to have the right to be whole.The user apply index table by
The target indicator information and dimensional information applied in copending people's application record table are formed.
Further, in order to improve the efficiency of application, the case where for partially having the right, processing method may include step:
S141, the target indicator information for determining copending people's application record table right of possession, the target having the right refer to
Mark information includes: the target indicator information that copending people applies for that extent of competence is interior and is present in the application record table, and
Spare permission people agrees to the target indicator information in application record table described in the presence of authorization.
S142, the target indicator information and dimensional information for obtaining copending people's application record table right of possession are formed and are used
Apply for index table in family.
S15, index table is applied for according to the user, extracts index dimensional relationships table.It should be noted that the index dimension
Spending relation table is the tables of data about index dimensional relationships being preset in the data warehouse, and the index dimension table is index
A part of dimension summary table, the index dimension summary table include: that index factual data and dimension illustrate data.
The index dimension is mapped in by the target indicator information and dimensional information applied for the user in index table
In relationship summary table, to extract index dimensional relationships table corresponding with user application index table.
In embodiments of the present invention, before the copending people's index relation table of acquisition, the method also includes steps:
S21, the classification setting index classification code according to index form index classification code table；Further, the finger
It is to be classified in the data warehouse by achievement data type that mark, which is sorted in, and the index classification code is in data warehouse layer
Face is binary code, convenient for the storage and reading of the index classification code data, it should be noted that wrap in the index
Metric is included, the metric can be divided into absolute measure and opposite measurement, and the metric can be divided into absolutely several times
Amount and relative number measurement, absolute number measurement reflection is scale index, such as population, GDP, income, number of users,
And relative number measurement is mainly used to reflect the index of quality, such as profit margin, retention ratio, coverage rate.It may also be said that index
It is divided into absolute number index and relative number index, the absolute number index is aggregated data, such as population, GDP, income, user
Number the time, place, range aggregated data, the relative number index be on the basis of the aggregated data of absolute number index again
Processing polymerization obtains, such as profit margin, retention ratio, coverage rate etc., in a profit margin formula: profit margin=profit ÷ cost ×
In 100%, profit is an absolute number index, and cost is also an absolute number index, rate of return data be profit data at
The polymerization of notebook data.
In some possible embodiments, the index classification code can be decimal code in displaying level, greatly
The personnel that majority does enterprise report are not programming personnel, and decimal code meets user for the habit of code compilation, makes institute
The definition for stating index classification code is more intuitive.
Further, the index classification code is written into index fact table in the data warehouse, the finger
It marks in true table and is stored with the data of the fact that index.
In some possible embodiments, in order to read the index classification table index speed faster, the index
Classification code can be separately provided as index classification code table, and be mapped by a mapping relations and the index fact table, from
And the data that illustrate in the index fact table are encoded, make the true data in the index fact table also have code into
The external difference of row.
S22, copending people's information is obtained, forms copending people's information table；It should be noted that copending people's information
It is characterized information, can be used as purview certification information, is stored in copending people's information table.Copending people's information
It may is that the identifiable characteristic informations such as the vocal print, fingerprint, face of copending people, it can also be with characteristic informations such as passwords.It is described to
In approver's information table include multiple copending people's information, by copending people's information table can index specifically to
Information.
S23, by the index classification code table partial association to copending people's information table, form the copending people
Index relation table.Copending people's index relation table is preset, the application permission for judging the copending people can be accelerated.
As a possible embodiment, copending people's information table is preset in the Data Mart, by will be described
Index classification code table is associated with copending people's information table, is made in copending people's information table about the permission
Target indicator information be indicated with code, reduce the storage pressure of the Data Mart.
In embodiments of the present invention, described by the index classification code table partial association to copending people's information
Table, form copending people's index relation table comprising steps of
S31, the extent of competence that the copending people is defined by higher level permission person；
In some possible embodiments, such as in the related embodiment that spare permission people is arranged, for clear management
Level can also be defined the spare permission of spare permission people, for example, defining person specially designated for a post possesses spare permission, i.e.,
It is the people that these possess spare permission, just can be used as spare permission people, can be just written in application record table by copending people.
About the definition of spare permission, can be defined by higher level permission person.
S32, according to the extent of competence, determine the permission index classification that the copending people can apply, form permission
Index classification code；It should be noted that the extent of competence is to assign the copending people, the power by higher level permission person
The target indicator that limit range includes is configured by the higher level permission person, and the permission index classification code is according to permission model
Enclose interior target indicator corresponding index classification code in the index classification code.
S33, according to the permission index classification code, extract corresponding classification code from the index classification code table
Form permission index classification code sublist；The permission index classification code sublist is for copending people's extent of competence shape
At, it can be and be arranged in a one-to-one correspondence, the extent of competence of the corresponding copending people of an index classification code sublist.
As a kind of possible embodiment, pressure is stored to reduce, it can be in the index classification code with the shape of signature
Formula is authorized, and specific step has been described in above-mentioned signature authorization, is not just described separately herein.
S34, the permission index classification code sublist is associated with to copending people's information table, forms configuration and has permission
Copending people's index relation table.Copending people's index relation table is preset, the permission for conveniently treating approver authenticates,
Clear authorization boundary.
In embodiments of the present invention, described to be weighed according to copending people's index relation table and the application record table
Limit judgement comprising steps of
Permission indication range information in S41, extraction copending people's index relation table；
S42, the target indicator information for extracting application in the application record table；
The target indicator of S43, comparison the permission indication range and the application, judge whether the application index falls into
The permission indication range.By the intersection situation of the permission indication range and the application index, judge that copending people is
It is no to have the right.
Invention for clearer description the present embodiment is intended to, and by taking set as an example, the permission index is set as set A, institute
It states application index and is set as set B, if set B is the subset of set A, the target indicator of copending people's application is all falling into
It states in permission indication range, if set B is not the subset of set A, and there are intersection C with set A, then copending people is in intersection C
In the target indicator of application entirely fall in the permission indication range, remaining in set B and not Shen in intersection C
Target indicator please is set as D set, then the target indicator of the application in the D set is fallen into outside the permission indication range.
In the embodiment that spare permission people is set, the target indicator of the application in D set is sent to spare permission human hair
This part after authorized, be set as E set by the target indicator that spare permission people authorizes, E is gathered and handed over by authorization requests
Collection C does a union processing, obtains F set, then the target indicator of the application in the F set falls into the permission indication range
It is interior.
In embodiments of the present invention, described to judge copending people without temporary, terminating requisition procedure includes:
When comparing the permission indication range and the application index, the non-permission index of the application index is obtained
Index as a result, determining that the copending people haves no right in range.
In embodiments of the present invention, judge copending people have temporary, formed user apply index table comprising steps of
S51, when comparing the permission indication range and the apply index, obtain the application index as the permission
Index as a result, determining that the copending people has the right in indication range；Specifically, determining that the copending people has the right to be divided into
Part has the right and all has the right, and partially has the right to refer in the target indicator applied in application record table, only partial target index is
Application is had permission, all has the right to refer in the target applied in application record table, target complete index is all to have permission application
's.
S52, the application record table is added to user's application index table, the user applies for that index table includes that dimension refers to
Mark information.
It further,, can Shen in the application record table for the efficiency for improving application in the embodiment partially having the right
Target indicator please extracts, and the target indicator for extracting application of having the right forms a live application record sheet, has described
Effect application record table is added to user and applies for index table.In this way, even if can also apply when the permission of copending people has deficiency
To partial target index.
In embodiments of the present invention, described to apply for index table according to the user, extracting index dimensional relationships table includes step
It is rapid:
S61, permission index identical with the application index in the permission indication range is extracted, and the permission is referred to
Mark returns to the permission index classification code sublist progress permission guideline code and claims；
S62, according to the permission guideline code matching dimensionality code, form index dimensional relationships code；
S63, index dimensional relationships are claimed according to the index dimensional relationships code, is formed by the index dimensional relationships
Index dimensional relationships table.
In embodiments of the present invention, the method also includes:
By the index dimensional relationships table, to data warehouse application index dimension result table.
As a kind of possible embodiment, the index dimension result table be can be set in the Data Mart, be improved
The extraction rate of index dimension result table.
Secondly, also providing a kind of server, the server includes processor and memory, is stored in the memory
At least one instruction, at least one section of program, code set or instruction set, at least one instruction, at least one section of program, institute
It states code set or described instruction collection is loaded by the processor and executed to realize such as any one of aforementioned finger as described in the examples
Mark the processing method of application.
Processor in the server can be computing chip, to the dimension data in calculation processing database and refer to
The polymerization of data is marked, the memory may is that USB flash disk, read-only memory (ROM), random access memory (RAM), movement are hard
The various storage devices that can store program code such as disk, magnetic or disk.
A kind of computer readable storage medium is finally also provided, at least one instruction, extremely is stored in the storage medium
Few one section of program, code set or instruction set, at least one instruction, at least one section of program, the code set or described
Instruction set is loaded by the processor and is executed to realize the processing side such as any one of aforementioned index application as described in the examples
Method.
The computer readable storage medium includes: USB flash disk, read-only memory (ROM), random access memory (RAM), moves
The various media that can store program code such as dynamic hard disk, magnetic or disk.
Above-described embodiment is merely to illustrate a specific embodiment of the invention.It should be pointed out that for the general of this field
For logical technical staff, without departing from the inventive concept of the premise, several deformations and variation can also be made, these deformations and
Variation all should belong to protection scope of the present invention.
Claims (10)
1. a kind of processing method of index application, which is characterized in that the described method includes:
Copending people sends application record table to data center, and the application record table includes information: application index；
Copending people's index relation table is obtained, permission is carried out according to copending people's index relation table and the application record table
Judgement；
Judge that copending people without temporary, terminates requisition procedure；
Judge that copending people has temporary, forms user and apply for index table；
Apply for index table according to the user, extracts index dimensional relationships table.
2. the processing method of index application as described in claim 1, which is characterized in that described to obtain copending people's index pass
Before being table, the method also includes:
According to the classification setting index classification code of index, index classification code table is formed；
Copending people's information is obtained, copending people's information table is formed；
By the index classification code table partial association to copending people's information table, copending people's index relationship is formed
Table.
3. the processing method of index application as described in claim 2, which is characterized in that described by the index classification code
Exterior portion point is associated with copending people's information table, forms copending people's index relation table and includes:
The extent of competence of the copending people is defined by higher level permission person；
According to the extent of competence, index classification in permission that the copending people can apply is determined, form index in permission
Classification code；
According to the permission index classification code, corresponding classification code is extracted from the index classification code table and forms permission
Index classification code sublist；
The permission index classification code sublist is associated with copending people's information table, form that configuration has permission it is described to
Approver's index relation table.
4. the processing method of index application as described in claim 3, which is characterized in that described to be referred to according to the copending people
Mark relation table and the application record table carry out permission judgement
Extract the permission indication range information in copending people's index relation table；
Extract the target indicator information applied in the application record table；
The target indicator for comparing the permission indication range and the application, judges whether the application index falls into the permission
Indication range.
5. the processing method of the index application as described in any in claim 1-4, which is characterized in that it is described judge it is pending
Crowd people includes: without temporary, terminating requisition procedure
When comparing the permission indication range and the application index, the non-permission indication range of the application index is obtained
Interior index as a result, determining that the copending people haves no right.
6. the processing method of the index application as described in any in claim 1-4, which is characterized in that judge copending people
Have temporary, forms user and apply for that index table includes:
When comparing the permission indication range and the application index, obtaining the application index is the permission indication range
Interior index as a result, determining that the copending people has the right；
The application record table is added to user and applies for index table, the user applies for that index table includes dimension indication information.
7. the processing method of index application as described in claim 6, which is characterized in that described to be referred to according to user application
Table is marked, extracting index dimensional relationships table includes:
Permission index identical with the application index in the permission indication range is extracted, and the permission index is returned into institute
Permission index classification code sublist progress permission guideline code is stated to claim；
According to the permission guideline code matching dimensionality code, index dimensional relationships code is formed；
Index dimensional relationships are claimed according to the index dimensional relationships code, form index dimension by the index dimensional relationships
Relation table.
8. the processing method of index application as described in claim 7, which is characterized in that the method also includes:
By the index dimensional relationships table, to data warehouse application index dimension result table.
9. a kind of server, which is characterized in that including processor and memory, at least one finger is stored in the memory
Enable, at least one section of program, code set or instruction set, at least one instruction, at least one section of program, the code set or
Described instruction collection is loaded by the processor and is executed to realize such as index application described in any item of the claim 1 to 8
Processing method.
10. a kind of computer readable storage medium, which is characterized in that be stored at least one instruction, extremely in the storage medium
Few one section of program, code set or instruction set, at least one instruction, at least one section of program, the code set or described
Instruction set is loaded by the processor and is executed to realize the processing such as index application described in any item of the claim 1 to 8
Method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810713087.5A CN109146397A (en) | 2018-06-29 | 2018-06-29 | A kind of processing method, server and the storage medium of index application |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810713087.5A CN109146397A (en) | 2018-06-29 | 2018-06-29 | A kind of processing method, server and the storage medium of index application |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109146397A true CN109146397A (en) | 2019-01-04 |
Family
ID=64799691
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810713087.5A Pending CN109146397A (en) | 2018-06-29 | 2018-06-29 | A kind of processing method, server and the storage medium of index application |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109146397A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1652509A (en) * | 2004-02-07 | 2005-08-10 | 华为技术有限公司 | Method for implementing intelligent network flexible authority management |
| CN102769602A (en) * | 2011-05-03 | 2012-11-07 | 中国移动通信集团山东有限公司 | Method, system and device for temporary permission control |
| CN103761323A (en) * | 2014-01-28 | 2014-04-30 | 北京国双科技有限公司 | Database permission control method and device |
| CN107315782A (en) * | 2017-06-08 | 2017-11-03 | 北京奇艺世纪科技有限公司 | A kind of data query method and device |
| CN107679749A (en) * | 2017-09-30 | 2018-02-09 | 新奥（中国）燃气投资有限公司 | The measures and procedures for the examination and approval and Current Authorization Management Platform of a kind of authority application |
-
2018
- 2018-06-29 CN CN201810713087.5A patent/CN109146397A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1652509A (en) * | 2004-02-07 | 2005-08-10 | 华为技术有限公司 | Method for implementing intelligent network flexible authority management |
| CN102769602A (en) * | 2011-05-03 | 2012-11-07 | 中国移动通信集团山东有限公司 | Method, system and device for temporary permission control |
| CN103761323A (en) * | 2014-01-28 | 2014-04-30 | 北京国双科技有限公司 | Database permission control method and device |
| CN107315782A (en) * | 2017-06-08 | 2017-11-03 | 北京奇艺世纪科技有限公司 | A kind of data query method and device |
| CN107679749A (en) * | 2017-09-30 | 2018-02-09 | 新奥（中国）燃气投资有限公司 | The measures and procedures for the examination and approval and Current Authorization Management Platform of a kind of authority application |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11818136B2 (en) | System and method for intelligent agents for decision support in network identity graph based identity management artificial intelligence systems | |
| Templ et al. | Statistical disclosure control for micro-data using the R package sdcMicro | |
| US10860742B2 (en) | Privacy risk information display | |
| Zhao | R and data mining: Examples and case studies | |
| CN109376549A (en) | A kind of electricity transaction big data dissemination method based on difference secret protection | |
| US11424013B2 (en) | Systems and methods for sorting findings to medical coders | |
| US20120240194A1 (en) | Systems and Methods for Controlling Access to Electronic Data | |
| CN109361654B (en) | Method and system for managing business secret based on block chain negotiation encryption | |
| CN110427254A (en) | Task processing method, device, equipment and computer readable storage medium | |
| CN109325648A (en) | Multi-dimensional data stream statistics method, server and storage medium based on index | |
| US7706574B1 (en) | Identifying and protecting composed and transmitted messages utilizing keystroke dynamics | |
| Crotty et al. | Cyber threat: its origins and consequence and the use of qualitative and quantitative methods in cyber risk assessment | |
| US10242169B2 (en) | Method for identification of user's interaction signature | |
| CN101295388A (en) | Credit estimation method and system | |
| CN109146397A (en) | A kind of processing method, server and the storage medium of index application | |
| Myers | Data management and statistical analysis techniques | |
| KR102659788B1 (en) | System for recommending document using dynamic change of time-series pattern information | |
| Smith | Event detection in educational records: an application of big data approaches | |
| US10783257B1 (en) | Use of word embeddings to locate sensitive text in computer programming scripts | |
| CN114417099A (en) | Archive management system based on RFID (radio frequency identification) label | |
| Yosef et al. | New concepts for cluster construction and similarity measurement | |
| CN112346938B (en) | Operation auditing method and device, server and computer readable storage medium | |
| Mir et al. | A measure of supervisory power: Scale development and validation | |
| CN109325725A (en) | A kind of information layered acquisition management system of corporate client | |
| Beaver et al. | An approach to the automated determination of host information value |
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 | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20190104 |