CN104252452B - The method and device of data management - Google Patents
The method and device of data management Download PDFInfo
- Publication number
- CN104252452B CN104252452B CN201310256161.2A CN201310256161A CN104252452B CN 104252452 B CN104252452 B CN 104252452B CN 201310256161 A CN201310256161 A CN 201310256161A CN 104252452 B CN104252452 B CN 104252452B
- Authority
- CN
- China
- Prior art keywords
- dimension table
- field
- information
- updated
- maintenance
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
- G06F16/2264—Multidimensional index structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F16/275—Synchronous replication
Abstract
The embodiment of the invention discloses a kind of method and devices of data management, are related to field of computer technology, solve and currently carry out safeguarding that the process of update is slow to dimension table, and the problem that safety is lower.Method includes: to receive maintenance more new command；Subscriber identity information is obtained according to maintenance more new command and needs to safeguard the dimension table information of the dimension table updated；According to the pre-set dimension table configuration information of dimension table acquisition of information；Synchronous purpose database and dimension table operation permission information are needed with source database, the dimension table where dimension table in dimension table configuration information；According to subscriber identity information and dimension table operation permission information, judge whether subscriber identity information meets dimension table operation permission information；If subscriber identity information meets dimension table operation permission information, need to safeguard that the dimension table updated is updated operation to described, and the dimension table being updated after operating is synchronized to purpose database.The present invention is suitable for the data management of dimension table.
Description
Technical field
The present invention relates to field of computer technology more particularly to a kind of method and devices of data management.
Background technique
With the development of computer technology, current many fields require to collect by computer, store and process number
According to.Therefore particularly important to the effectively management of data.Such as the sale number of extensive stock in computer management supermarket can be passed through
According in another example data the case where can be applied by a certain website of computer management or computer software.In compliant tube
In the data of reason, there are many numerical data, these numerical datas can be summarized, and be answered in order to further analyze
With.Such as the moon sales volume of the payment product of a certain website release is exactly a kind of numerical data.For the ease of the numerical data
Numerical data, is currently generally recorded in fact table by record and displaying, and in the database by fact table storage.
Such as a certain networking products, the attribute information of the networking products and numerical data can be stored in fact table, the category
Property information can be with having time, area code etc., and numerical data can be a moon sales volume, moon sales growth rate etc..
Currently, generally requiring an extremely multiple dimension tables for the ease of analyzing the data in fact table and coming
Record the attribute information of fact table, wherein some attribute informations provide descriptive information, such as describe above-mentioned regional generation
Area name corresponding to code, some attribute informations are for specifying how to summarize fact table data, such as how to moon pin
The amount of selling and moon sales growth rate summarize etc..Therefore, the data in dimension table are carried out safeguarding that update is more important.It is current right
It is directly to carry out respectively in each dimension table of disparate databases that dimension table, which is managed, even if the same dimension table is more
A database purchase will also carry out respectively maintenance update on multiple databases, safeguard that the process of update is more slow, tie up simultaneously
Data in degree table can safeguard update, but any data updated in dimension table as desired, it is possible to cause dimension table
In corrupted data lose, the safety of current dimension table is lower.
Summary of the invention
The embodiment of the present invention provides a kind of method and device of data management, is able to solve in the prior art due to current
The process for carrying out maintenance update to dimension table is slow, and the problem that safety is lower.
In order to achieve the above objectives, the present invention adopts the following technical scheme:
A kind of method of data management, comprising:
Receive maintenance more new command；
Subscriber identity information is obtained according to the maintenance more new command and needs to safeguard the dimension table of the dimension table updated
Information；
According to the pre-set dimension table configuration information of the dimension table acquisition of information；Wherein, the dimension table matches confidence
With the purpose database that source database, the dimension table needs where the dimension table that needs to safeguard and update are synchronous in breath
And dimension table operation permission information；
According to the subscriber identity information and the dimension table operation permission information, judge that the subscriber identity information is
It is no to meet the dimension table operation permission information；
If the subscriber identity information meets the dimension table operation permission information, need to safeguard the dimension updated to described
Table is updated operation；
The dimension table being updated after operating is synchronized to the purpose database.
A kind of device of data management, comprising:
Receiving unit, for receiving maintenance more new command；
Acquiring unit, for obtaining subscriber identity information and need according to the received maintenance more new command of the receiving unit
Safeguard the dimension table information of the dimension table of update；
The acquiring unit is also used to according to the pre-set dimension table configuration information of the dimension table acquisition of information；Its
In, with source database, the dimension table where the dimension table that needs to safeguard and update in the dimension table configuration information
Need synchronous purpose database and dimension table operation permission information；
Judging unit, the subscriber identity information and the dimension table handling for being obtained according to the acquiring unit
Authority information, judges whether the subscriber identity information meets the dimension table operation permission information；
Operating unit is updated, if determining the subscriber identity information for the judging unit meets the dimension table behaviour
Make authority information, needs to safeguard that the dimension table updated is updated operation to described；
Synchronization unit, the dimension table for the update operating unit to be updated after operation are synchronized to the purpose number
According to library.
The method and device of data management provided in an embodiment of the present invention has received maintenance more new command, and according to described
Maintenance more new command obtains subscriber identity information and needs to safeguard the dimension table information of the dimension table updated；According to the dimension
Spend the pre-set dimension table configuration information of table acquisition of information；Wherein, it needs to tie up with described in the dimension table configuration information
Source database, the dimension table where the dimension table that shield updates need synchronous purpose database and dimension table operating right
Information；According to the subscriber identity information and the dimension table operation permission information, whether the subscriber identity information is judged
Meet the dimension table operation permission information；If the subscriber identity information meets the dimension table operation permission information, to institute
It states and needs to safeguard that the dimension table updated is updated operation；And the dimension table being updated after operating is synchronized to the purpose number
According to library.In the prior art, to dimension table carry out maintenance update be directly in each dimension table of disparate databases respectively into
Capable, even if the same dimension table in multiple database purchases, will also carry out respectively maintenance update, simultaneously on multiple databases
Current any data updated in dimension table, it is possible to the corrupted data in dimension table be caused to lose.Therefore, data of the invention
The mode of management determines its operating right whether there is or not dimension table by confirmation subscriber identity information, can be improved the peace of dimension table
Quan Xing, while the dimension table being updated after operating can be synchronized in purpose database, and avoid in each database
In carry out maintenance update one by one, can be improved maintenance update speed.
Detailed description of the invention
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below
There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
Some embodiments of invention for those of ordinary skill in the art without creative efforts, can be with
It obtains other drawings based on these drawings.
Fig. 1 is the flow chart of the method for data management provided in an embodiment of the present invention；
Fig. 2 is the flow chart of the method for the data management that further embodiment of this invention provides；
Fig. 3 is the structural schematic diagram one of the device of data management provided in an embodiment of the present invention；
Fig. 4 is the structural schematic diagram two of the device of data management provided in an embodiment of the present invention.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.It is based on
Embodiment in the present invention, it is obtained by those of ordinary skill in the art without making creative efforts every other
Embodiment shall fall within the protection scope of the present invention.
The advantages of to make technical solution of the present invention, is clearer, makees specifically to the present invention with reference to the accompanying drawings and examples
It is bright.
As shown in Figure 1, the method for data management provided in an embodiment of the present invention, comprising:
101, maintenance more new command is received.
The maintenance updates the dimension table information for the dimension table that instruction tape maintenance in need updates, and the dimension table information can
To include dimension table name, dimension table identity etc..The maintenance more new command, which can be, increases content instruction, change content
Content instruction is deleted in instruction.
102, subscriber identity information is obtained according to the maintenance more new command and needs to safeguard the dimension of the dimension table updated
Spend table information.
It is worth noting that the executing subject of the method for data management provided in an embodiment of the present invention can be a kind of data
The device of management can register with account under the device of the data management.Above-mentioned subscriber identity information can be data
The account registered under the device of management, but it is not only limited to this.
103, according to the pre-set dimension table configuration information of the dimension table acquisition of information.
Specifically, can be has the dimension table name or dimension in the pre-set dimension table configuration information
Table identity.Therefore according to the dimension table information, i.e. dimension table name or dimension table identity can correspond to acquisition
To dimension table configuration information.
Wherein, in the dimension table configuration information with it is described need safeguard update dimension table where source database,
The dimension table needs synchronous purpose database and dimension table operation permission information.It can be in the form of dimension table allocation list
To record dimension table configuration information.
104, according to the subscriber identity information and the dimension table operation permission information, judge the user identity letter
Whether breath meets the dimension table operation permission information.
Record has the User Identity with dimension table operating right in the dimension table operation permission information, and described
Subscriber identity information is also possible to a kind of identity, and the account registered under the device of data management as escribed above then needs
Judge the account whether in the User Identity.
If 105, the subscriber identity information meets the dimension table operation permission information, maintenance is needed to update to described
Dimension table is updated operation.
It specifically can be in the field according to increase content instruction into dimension table and increase field contents, or according to change
Content instruction changes the field contents in dimension table, or according to the field contents deleted in content instruction deletion dimension table.
106, the dimension table being updated after operating is synchronized to the purpose database.
Dimension table, which is updated, to be carried out on source database, in order to update the identical dimension on other databases
The dimension table updated after operating can be synchronized in the purpose database by table.
The method of data management provided in an embodiment of the present invention has received maintenance more new command, and more according to the maintenance
New command obtains subscriber identity information and needs to safeguard the dimension table information of the dimension table updated；Believed according to the dimension table
Breath obtains pre-set dimension table configuration information；Wherein, it is updated in the dimension table configuration information with needs maintenance
Dimension table where source database, the dimension table need synchronous purpose database and dimension table operation permission information；
According to the subscriber identity information and the dimension table operation permission information, judge whether the subscriber identity information meets institute
State dimension table operation permission information；If the subscriber identity information meets the dimension table operation permission information, to the needs
The dimension table that maintenance updates is updated operation；And the dimension table being updated after operating is synchronized to the purpose database.
In the prior art, carrying out maintenance update to dimension table is directly to carry out respectively in each dimension table of disparate databases,
Even if the same dimension table in multiple database purchases, will also carry out respectively maintenance update on multiple databases, while current
Any data updated in dimension table, it is possible to the corrupted data in dimension table be caused to lose.Therefore, data management of the invention
Mode its operating right whether there is or not dimension table is determined by confirmation subscriber identity information, can be improved the safety of dimension table
Property, while the dimension table being updated after operating can be synchronized in purpose database, and avoid in each database
Maintenance update is carried out one by one, can be improved the speed that maintenance updates.
Further on the basis of Fig. 1, as shown in Fig. 2, the method for the data management that further embodiment of this invention provides,
Include:
201, maintenance more new command is received.
Wherein, dimension table information is carried in the maintenance more new command, the dimension table information may include dimension table
Title, dimension table identity etc..The maintenance more new command is to increase content instruction, change content instruction or delete content to refer to
It enables.
It is worth noting that the executing subject of the method for data management provided in an embodiment of the present invention can be a kind of data
The device of management, the device of the data management can show the opening identification of each dimension table, if the opening identification is activated,
It is then equivalent to and has received maintenance more new command, but be not only limited to this.
202, the user identity letter for needing to carry out the user that dimension table maintenance updates is obtained according to the maintenance more new command
Breath.
Account can be registered under the device of the data management.Above-mentioned subscriber identity information can be a kind of user
Identity, such as the account registered under the device of data management, but it is not only limited to this.Specifically, different user identity
The corresponding user identity of mark may correspond to different dimension table operating rights, such as there are User Identity 1, deposit simultaneously
In dimension table 1, dimension table 2, dimension table 3, the corresponding user identity of User Identity 1 may only have dimension table 1 and dimension
The dimension table operating right of table 2, but it is not only limited to this.
203, according to the pre-set dimension table configuration information of the dimension table acquisition of information.
Specifically, can be has the dimension table name or dimension in the pre-set dimension table configuration information
Table identity.Therefore it according to the dimension table information, i.e., can be corresponded to according to dimension table name or dimension table identity
Get dimension table configuration information.
Wherein, in the dimension table configuration information with it is described need safeguard update dimension table where source database,
The dimension table needs synchronous purpose database and dimension table operation permission information.The dimension table operation permission information packet
It includes: the User Identity with dimension table operating right.Specifically dimension table can be recorded in the form of dimension table allocation list
Configuration information.Such as shown in the following table 1:
Table 1, dimension table allocation list:
Above-mentioned table 1 indicates a kind of dimension table allocation list, which is only the dimension table allocation list in the embodiment of the present invention
One specific example, not unique dimension table allocation list.Those skilled in the art is in the premise not made the creative labor
Under the obtained table of different expression form, belong to the scope of protection of the invention.
In the dimension table allocation list that table 1 indicates, the information having is as shown in table 1, comprising: dimension table allocation list identity mark
Know (Identity, abbreviation ID), relevant dimension table id, dimension table name, dimension table description, responsible person, source database, purpose number
According to library, User Identity can be operated.Wherein, the relevant dimension table is dimension associated with needing to safeguard the dimension table of update
Spend table.
204, judge the subscriber identity information whether in the User Identity with dimension table operating right.
If the subscriber identity information not in the User Identity, executes step 205；If the subscriber identity information is described
In User Identity, step 206 is executed.
The subscriber identity information can be a kind of identity, the account registered under the device of data management as escribed above
Number, but it is not only limited to this.
Such as shown in upper table 1, the user identity mark that User Identity is dimension table operating right herein can be operated
Know.Such as the User Identity that operates of dimension table 1 is abcdef and zxcvbn two, such as above-mentioned account is qwerty,
It then determines the account not operate in User Identity described, does not then have the permission operated to dimension table 1.Again
Such as above-mentioned account is abcdef, then determines the account and operate in User Identity described, then has to dimension table 1
The permission operated.
205, operation is not updated to the dimension table.
In order to guarantee the safety of each dimension table, if user identity corresponding to subscriber identity information is grasped without dimension table
Make permission, then cannot be updated operation to the dimension table.
206, it according to the maintenance more new command, determines and needs to safeguard the field updated, and get and described need to safeguard
The field identification of the field of update.
The field identification or field name for the field that can be updated with maintenance in need in the maintenance more new command.One
As need to update is data line in dimension table, and the data line in dimension table may include one or more fields,
Therefore the maintenance more new command can be with the field identification or field name of all fields of the data line.
207, pre-set field configuration is got according to the field identification and the dimension table configuration information to believe
Breath.
Wherein, the field configuration information includes the field contents ordering rule of the field, field ordering information, field
Restrictive condition.The field configuration information can be indicated in the form of field configuration table.Such as shown in the following table 2:
Table 2, field configuration table:
Above-mentioned table 2 indicates a kind of field configuration table, which is only one of the field configuration table in the embodiment of the present invention
Specific example, not unique field configuration table.Those skilled in the art obtains without creative efforts
Different expression form table, belong to the scope of protection of the invention.
In the field configuration table that table 2 indicates, the information having is as shown in table 2, comprising: Field ID, field name, field
Description, dimension table allocation list ID, field contents ordering rule, field order, field could be sky, Auto-writing default value, word
Whether section is major key, field input mode.It, can due to having Field ID and dimension table allocation list ID in field configuration table
To get pre-set word according to the Field ID and the dimension table configuration information, such as dimension table allocation list ID
Section configuration information, i.e., field configuration table herein.
Field in the field configuration table could be it is empty, whether field is that major key is included in the field restrictive condition
In, specific field could be whether empty, field is that the concrete application of major key describes in the next steps, and details are not described herein again.
The field contents ordering rule, field order, Auto-writing default value concrete application also describe in the next steps.
The field input mode defines that the field will input in what manner, such as can have combobox selection,
Such as when filling in city, in order to avoid filling in mistake, combobox is directly provided, the title in each city is externally provided.The word
Section input mode can also have input frame grid type, i.e., directly input in input frame；Additionally there can be the date to fill in format etc.,
But it is not only limited to this.
208, increase field contents, change field contents or deletion in one or more fields in the dimension table
Field contents.
The field contents may belong to the data line in dimension table, and the data line includes one or more words
Section.
Specifically, it is corresponding to obtain the increase content instruction if the maintenance more new command is to increase content instruction
Batch data content.And then according to the batch data content, increase word in one or more fields in the dimension table
Section content.At this point it is possible to which the field contents are ranked up according to the field contents ordering rule；According to the field
Each field in dimension table is ranked up by order information.The batch data content can be set in advance in data management
Device it is local.When needing to increase field contents, batch data content can be imported, without to each field contents one
One is inputted, and can be improved the speed updated to dimension table maintenance.
In addition, the field contents ordering rule is the sequence in order to limit the field contents, such as the field is
Such as the city in table 2, the field contents ordering rule is to arrange according to pinyin order, then there are " Beijing, day in for example described city
Saliva, Shanghai and Nanjing " is then arranged according to the first letter of pinyin of the first word of city name from a-z, then the sequence of the field contents
For " Beijing, Nanjing, Shanghai, Tianjin ", certain field contents ordering rule can also there are many, no longer go to live in the household of one's in-laws on getting married one by one herein
It states.The field order can be come each field according to a graded due to showing perhaps multiple fields in dimension table
It arranges, such as the field order that the Field ID in table 2 is 4567 is 01, the field order that Field ID is 4568 is 02, then can incite somebody to action
The field that Field ID is 4567 is arranged in front of the field that Field ID is 4568.
Specifically, it is corresponding to obtain the change content instruction if the maintenance more new command is change content instruction
Batch data content.And then according to the batch data content, more alter in one or more fields in the dimension table
Section content.Field contents original in dimension table are replaced with new field contents by the change field contents.In addition, if institute
Maintenance more new command is stated to delete content instruction, deletes field contents in one or more fields in the dimension table.
209, whether each field after judging the increase field contents, changing field contents or deletion field contents
Meet the field restrictive condition.If each field meets the field restrictive condition, step 211 is executed；Otherwise, if having field not
Meet the field restrictive condition, executes step 210.
There are many field restrictive conditions, and the field enumerated in table 2 herein could be whether empty and field is major key.Its
In, field can indicate that the field can not have content to be empty, and field can not indicate that the field has to fill substance to be empty,
And if non-fill substance, data administrator can increase to Auto-writing default value in the field contents.Such as in table 2
City code cannot can be packed into for sky, the then city code that do not fill in the default value sequence one of field it is silent
Recognize value.Whether the field is that show whether the field has the city code in uniqueness, such as table 2 be major key to major-key table,
Then there can be no identical city codes in city code field.Therefore, if being safeguarded in dimension table with data line
It updates, it is possible to not be able to satisfy above-mentioned field restrictive condition.Further, it is also possible to limit the combination of multiple fields, example
If the combination in city and city code in table 2 cannot repeat, i.e., the city for example in dimension table and city code if there is
Following field " Beijing 010 ", Beijing are city fields, and 010 is city code field, then cannot occur again in dimension table
" Beijing 010 ".
210, prompt information is generated.
The prompt information is used to prompt to be unsatisfactory for the Field Count of the field restrictive condition, and prompts to be unsatisfactory for the word
The field relevant information of section restrictive condition.
The field relevant information includes the field identification or field name of the field.
211, the dimension table being updated after operating is synchronized to the purpose database.
Dimension table, which is updated, to be carried out on source database, in order to update the identical dimension on other databases
The dimension table updated after operating can be synchronized in the purpose database by table.
The method for the data management that further embodiment of this invention provides receives maintenance more new command, and according to the maintenance
More new command obtains subscriber identity information and needs to safeguard the dimension table information of the dimension table updated；According to the dimension table
The pre-set dimension table configuration information of acquisition of information；Wherein, it is safeguarded more in the dimension table configuration information with the needs
Source database, the dimension table where new dimension table need synchronous purpose database and dimension table operating right letter
Breath；According to the subscriber identity information and the dimension table operation permission information, judge whether the subscriber identity information is full
The foot dimension table operation permission information；If the subscriber identity information meets the dimension table operation permission information, to described
Need to safeguard that the dimension table of update is updated operation；And the dimension table being updated after operating is synchronized to the purpose data
Library.In the prior art, dimension table is carried out maintenance to update being directly to carry out respectively in each dimension table of disparate databases
, even if the same dimension table in multiple database purchase, maintenance update will be also carried out respectively on multiple databases, is worked as simultaneously
Preceding any data updated in dimension table, it is possible to the corrupted data in dimension table be caused to lose.Therefore, data pipe of the invention
The mode of reason determines its operating right whether there is or not dimension table by confirmation subscriber identity information, can be improved the safety of dimension table
Property, while the dimension table being updated after operating can be synchronized in purpose database, and avoid in each database
Maintenance update is carried out one by one, can be improved the speed that maintenance updates.
Corresponding to the method for above-mentioned Fig. 1 and data management shown in Fig. 2, as shown in figure 3, provided in an embodiment of the present invention
The device of data management, comprising:
Acquiring unit 31, for obtaining subscriber identity information and needing to safeguard the dimension table information of the dimension table updated.
The acquiring unit 31 is also used to according to the pre-set dimension table configuration information of the dimension table acquisition of information；
Wherein, with the source database where the dimension table that needs to safeguard and update, the dimension in the dimension table configuration information
Table needs synchronous purpose database and dimension table operation permission information.
Judging unit 32, the subscriber identity information and the dimension table for being obtained according to the acquiring unit 31
Operation permission information, judges whether the subscriber identity information meets the dimension table operation permission information.
Operating unit 33 is updated, if determining the subscriber identity information for the judging unit 32 meets the dimension
Table handling authority information receives maintenance more new command, needs to safeguard that the dimension table updated is updated operation to described.The dimension
Protecting more new command is to increase content instruction, change content instruction or deletion content instruction.
Synchronization unit 34, the dimension table for the update operating unit 33 to be updated after operation are synchronized to the mesh
Database.
Specifically, the dimension table operation permission information includes: the User Identity with dimension table operating right.
Specifically, as shown in figure 4, the judging unit 32, is used for:
Judge whether the subscriber identity information that the acquiring unit 31 obtains described has dimension table operating right
User Identity in.
Further, as shown in figure 4, the acquiring unit 31, is also used to:
According to the received maintenance more new command of the update operating unit 33, determines and needs to safeguard the field updated,
And get the field identification for needing to safeguard the field updated.
Pre-set field configuration information is got according to the field identification and the dimension table configuration information；Its
In, the field configuration information includes the field contents ordering rule, field ordering information, field restrictive condition of the field.
Specifically, as shown in figure 4, the acquiring unit 31 is used if the maintenance more new command is to increase content instruction
In:
Obtain the corresponding batch data content of the increase content instruction.
The update operating unit 33, the batch data content for being obtained according to the acquiring unit 31, in institute
It states in one or more fields in dimension table and increases field contents.
The update operating unit 33, the field contents sequence rule for being also used to be obtained according to the acquiring unit 31
Then, the field contents are ranked up.
The update operating unit 33 is also used to the field ordering information obtained according to the acquiring unit 31, will
Each field in dimension table is ranked up.
Specifically, as shown in figure 4, the acquiring unit 31 is used if the maintenance more new command is change content instruction
In:
Obtain the corresponding batch data content of the change content instruction.
The update operating unit 33, the batch data content for being obtained according to the acquiring unit 31, in institute
It states in one or more fields in dimension table and changes field contents.
Specifically, as shown in figure 4, if the maintenance more new command be delete content instruction, the update operating unit 33,
For:
Field contents are deleted in one or more fields in the dimension table.
As shown in figure 4, the device of the data management, further includes generation unit 35.
The judging unit 32 is also used to judge that the update operating unit 33 increases field contents, change field contents
Or whether each field after deletion field contents meets the field restrictive condition.
The generation unit 35, if having determined field for the judging unit 32 is unsatisfactory for the field limitation item
Part generates prompt information；The prompt information is used to prompt to be unsatisfactory for the Field Count of the field restrictive condition, and prompts discontented
The field relevant information of the foot field restrictive condition；The field relevant information include the field the field identification or
Person's field name.
It is worth noting that the specific implementation of the device of data management provided in an embodiment of the present invention may refer to figure
1 and data management shown in Fig. 2 method specific embodiment, details are not described herein again.
The device of data management provided in an embodiment of the present invention has received maintenance more new command, and more according to the maintenance
New command obtains subscriber identity information and needs to safeguard the dimension table information of the dimension table updated；Believed according to the dimension table
Breath obtains pre-set dimension table configuration information；Wherein, it is updated in the dimension table configuration information with needs maintenance
Dimension table where source database, the dimension table need synchronous purpose database and dimension table operation permission information；
According to the subscriber identity information and the dimension table operation permission information, judge whether the subscriber identity information meets institute
State dimension table operation permission information；If the subscriber identity information meets the dimension table operation permission information, to the needs
The dimension table that maintenance updates is updated operation；And the dimension table being updated after operating is synchronized to the purpose database.
In the prior art, carrying out maintenance update to dimension table is directly to carry out respectively in each dimension table of disparate databases,
Even if the same dimension table in multiple database purchases, will also carry out respectively maintenance update on multiple databases, while current
Any data updated in dimension table, it is possible to the corrupted data in dimension table be caused to lose.Therefore, data management of the invention
Mode its operating right whether there is or not dimension table is determined by confirmation subscriber identity information, can be improved the safety of dimension table
Property, while the dimension table being updated after operating can be synchronized in purpose database, and avoid in each database
Maintenance update is carried out one by one, can be improved the speed that maintenance updates.
Through the above description of the embodiments, it is apparent to those skilled in the art that the present invention can borrow
Help software that the mode of required common hardware is added to realize, naturally it is also possible to which the former is more preferably by hardware, but in many cases
Embodiment.Based on this understanding, the portion that technical solution of the present invention substantially in other words contributes to the prior art
Dividing can be embodied in the form of software products, which stores in a readable storage medium, such as count
The floppy disk of calculation machine, hard disk or CD etc., including some instructions are used so that computer equipment (it can be personal computer,
Server or the network equipment etc.) execute method described in each embodiment of the present invention.
The above description is merely a specific embodiment, but scope of protection of the present invention is not limited thereto, any
Those familiar with the art in the technical scope disclosed by the present invention, can easily think of the change or the replacement, and should all contain
Lid is within protection scope of the present invention.Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.
Claims (14)
1. a kind of method of data management characterized by comprising
Maintenance more new command is received, the maintenance more new command is to increase content instruction, change content instruction or delete content to refer to
It enables；
Subscriber identity information is obtained according to the maintenance more new command and needs to safeguard the dimension table information of the dimension table updated；
According to the pre-set dimension table configuration information of the dimension table acquisition of information；Wherein, in the dimension table configuration information
With the source database needed to safeguard where the dimension table updated, the dimension table need synchronous purpose database and
Dimension table operation permission information, wherein described to need to safeguard that the dimension table updated is stored in the source database and the purpose
Database；
According to the subscriber identity information and the dimension table operation permission information, judge whether the subscriber identity information is full
The foot dimension table operation permission information；
If the subscriber identity information meets the dimension table operation permission information, according to the maintenance more new command, determining is needed
It safeguards the field of update, and gets the field identification for needing to safeguard the field updated；
Pre-set field configuration information is got according to the field identification and the dimension table configuration information；Wherein,
The field configuration information includes the field contents ordering rule, field ordering information, field restrictive condition of the field；
The dimension table for safeguarding update is needed to be updated operation to described, it is described to update operation to need maintenance to update described
Increase field contents, change field contents in one or more fields in dimension table or deletes field contents；
The dimension table being updated after operating is synchronized to the purpose database.
2. the method for data management according to claim 1, which is characterized in that the dimension table operation permission information packet
It includes: the User Identity with dimension table operating right.
3. the method for data management according to claim 2, which is characterized in that described to judge that the subscriber identity information is
It is no to meet the dimension table operation permission information, comprising:
Judge the subscriber identity information whether in the User Identity with dimension table operating right.
4. the method for data management according to claim 1, which is characterized in that if the maintenance more new command is in increasing
Hold instruction, it is described to need to safeguard that the dimension table updated is updated operation to described, comprising:
Obtain the corresponding batch data content of the increase content instruction；
According to the batch data content, increase field contents in one or more fields in the dimension table；
According to the field contents ordering rule, the field contents are ranked up；
According to the field ordering information, each field in dimension table is ranked up.
5. the method for data management according to claim 1, which is characterized in that if the maintenance more new command is in change
Hold instruction, it is described to need to safeguard that the dimension table updated is updated operation to described, comprising:
Obtain the corresponding batch data content of the change content instruction；
According to the batch data content, field contents are changed in one or more fields in the dimension table.
6. the method for data management according to claim 1, which is characterized in that if the maintenance more new command is in deleting
Hold instruction, it is described to need to safeguard that the dimension table updated is updated operation to described, comprising:
Field contents are deleted in one or more fields in the dimension table.
7. according to the method for the described in any item data managements of claim 4-6, which is characterized in that further include:
It is described whether each field after judging the increase field contents, changing field contents or deletion field contents meets
Field restrictive condition；
If there is field to be unsatisfactory for the field restrictive condition, prompt information is generated；The prompt information is unsatisfactory for institute for prompting
The Field Count of field restrictive condition is stated, and prompts the field relevant information for being unsatisfactory for the field restrictive condition；The field phase
Close the field identification or field name that information includes the field.
8. a kind of device of data management characterized by comprising
Receiving unit, for receiving maintenance more new command, the maintenance more new command is to increase content instruction, change content instruction
Or delete content instruction；
Acquiring unit, for obtaining subscriber identity information according to the received maintenance more new command of the receiving unit and needing to tie up
Protect the dimension table information of the dimension table updated；
The acquiring unit is also used to according to the pre-set dimension table configuration information of the dimension table acquisition of information；Wherein, institute
It states same with source database, the dimension table needs where the dimension table that needs to safeguard and update in dimension table configuration information
The purpose database and dimension table operation permission information of step, wherein the dimension table for needing maintenance to update is stored in described
Source database and the purpose database；
Judging unit, the subscriber identity information and the dimension table operating right for being obtained according to the acquiring unit
Information, judges whether the subscriber identity information meets the dimension table operation permission information；
Operating unit is updated, if determining the subscriber identity information for the judging unit meets the dimension table operating rights
Limit information safeguards that the dimension table updated is updated operation to the needs, and the update operation is to safeguard more in the needs
Increase field contents, change field contents in one or more fields in new dimension table or deletes field contents；
Synchronization unit, the dimension table for the update operating unit to be updated after operation are synchronized to the purpose data
Library；
Wherein, the acquiring unit is also used to according to the received maintenance more new command of the update operating unit, and determining needs
It safeguards the field of update, and gets the field identification for needing to safeguard the field updated；According to the field identification with
And the dimension table configuration information gets pre-set field configuration information；Wherein, the field configuration information includes institute
State the field contents ordering rule, field ordering information, field restrictive condition of field.
9. the device of data management according to claim 8, which is characterized in that the dimension table operation permission information packet
It includes: the User Identity with dimension table operating right.
10. the device of data management according to claim 9, which is characterized in that the judging unit is used for:
Judge the subscriber identity information of the acquiring unit acquisition whether in the user with dimension table operating right
In identity.
11. the device of data management according to claim 8, which is characterized in that if the maintenance more new command is to increase
Content instruction, the acquiring unit, is used for:
Obtain the corresponding batch data content of the increase content instruction；
The update operating unit, the batch data content for being obtained according to the acquiring unit, in the dimension table
In one or more fields in increase field contents；
The update operating unit is also used to the field contents ordering rule obtained according to the acquiring unit, will be described
Field contents are ranked up；
The update operating unit is also used to the field ordering information obtained according to the acquiring unit, will be in dimension table
Each field be ranked up.
12. the device of data management according to claim 8, which is characterized in that if the maintenance more new command is change
Content instruction, the acquiring unit, is used for:
Obtain the corresponding batch data content of the change content instruction；
The update operating unit, the batch data content for being obtained according to the acquiring unit, in the dimension table
In one or more fields in change field contents.
13. the device of data management according to claim 8, which is characterized in that if the maintenance more new command is to delete
Content instruction, the update operating unit, is used for:
Field contents are deleted in one or more fields in the dimension table.
14. the device of the described in any item data managements of 1-13 according to claim 1, which is characterized in that further include generating list
Member；
The judging unit is also used to judge that the update operating unit increases field contents, change field contents or deletion
Whether each field after field contents meets the field restrictive condition；
The generation unit, if having determined field for the judging unit is unsatisfactory for the field restrictive condition, generation is mentioned
Show information；The prompt information is used to prompt to be unsatisfactory for the Field Count of the field restrictive condition, and prompts to be unsatisfactory for the word
The field relevant information of section restrictive condition；The field relevant information includes the field identification or field name of the field
Claim.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310256161.2A CN104252452B (en) | 2013-06-25 | 2013-06-25 | The method and device of data management |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310256161.2A CN104252452B (en) | 2013-06-25 | 2013-06-25 | The method and device of data management |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104252452A CN104252452A (en) | 2014-12-31 |
| CN104252452B true CN104252452B (en) | 2019-03-15 |
Family
ID=52187360
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310256161.2A Active CN104252452B (en) | 2013-06-25 | 2013-06-25 | The method and device of data management |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104252452B (en) |
Families Citing this family (27)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106345351A (en) * | 2016-08-29 | 2017-01-25 | 巴中市方圆环保科技发展有限责任公司 | Intelligent production system of high-molecular environmental protection material |
| CN106682161A (en) * | 2016-12-26 | 2017-05-17 | 北华大学 | System for Japanese pronunciation correction |
| CN107066855A (en) * | 2016-12-30 | 2017-08-18 | 北华大学 | A kind of fail-safe computer user data Protection control system based on cloud computing |
| CN106730226A (en) * | 2017-01-11 | 2017-05-31 | 韩秀霞 | A kind of emergency care inhalation device |
| CN106908628A (en) * | 2017-03-01 | 2017-06-30 | 杨慧桐 | A kind of highly sensitive universal meter with insulation slipmat |
| CN107064428A (en) * | 2017-04-06 | 2017-08-18 | 鲁馨茗 | A kind of room air monitor and alarm system |
| CN107232738A (en) * | 2017-06-06 | 2017-10-10 | 任婉宁 | A kind of Portable learning articles for use storage device |
| CN107239682A (en) * | 2017-06-15 | 2017-10-10 | 武汉万千无限科技有限公司 | A kind of computer internet information safety control system based on cloud computing |
| CN107292104A (en) * | 2017-06-20 | 2017-10-24 | 武汉微护信息技术有限公司 | A kind of micro- shield doctor's case management system |
| CN107728556A (en) * | 2017-10-13 | 2018-02-23 | 江苏科沃纺织有限公司 | A kind of intelligent management system of solar energy rainer |
| CN107894252A (en) * | 2017-11-14 | 2018-04-10 | 江苏科沃纺织有限公司 | It is a kind of to monitor the buried telescopic monitoring system for being sprayed filling device running status in real time |
| CN107799162A (en) * | 2017-11-20 | 2018-03-13 | 张新红 | A kind of hospital emergency department patient Electronic Registration statistical system |
| CN108009298B (en) * | 2017-12-27 | 2021-08-31 | 海口经济学院 | Internet character search information integration analysis control method |
| CN108768689A (en) * | 2018-04-13 | 2018-11-06 | 重庆三峡学院 | A kind of public administration system based on remote control |
| CN108969821A (en) * | 2018-05-16 | 2018-12-11 | 聊城市光明医院 | A kind of bladder irrigator control system of anti-resorption |
| CN108766059B (en) * | 2018-05-21 | 2020-09-01 | 重庆交通大学 | Cloud service English teaching equipment and teaching method |
| CN108877878A (en) * | 2018-06-25 | 2018-11-23 | 荆门市第二人民医院 | A kind of information acquisition management system in oncology chemotherapy |
| CN109299613B (en) * | 2018-09-03 | 2023-07-21 | 中国平安人寿保险股份有限公司 | Database partition authority setting method and terminal equipment |
| CN109213821B (en) * | 2018-09-25 | 2022-03-15 | 中国银行股份有限公司 | Data processing method and system |
| CN109183776A (en) * | 2018-10-24 | 2019-01-11 | 中国水利水电第四工程局有限公司 | A kind of novel humidification adds SDDC methods |
| CN109814895A (en) * | 2018-11-29 | 2019-05-28 | 广州因特信息科技有限公司 | A kind of database update method and system of automation |
| CN109956772A (en) * | 2018-12-13 | 2019-07-02 | 吉林省禾谷新农现代农业科技发展有限公司 | A kind of stalk and coco bran cultivate fruits and vegetables fertilizer and preparation method thereof |
| CN109949432A (en) * | 2019-03-01 | 2019-06-28 | 北华大学 | A kind of student's special electronic attendance system and method based on radio-frequency technique |
| CN110427434B (en) * | 2019-06-28 | 2022-06-07 | 苏宁云计算有限公司 | Multidimensional data query method and device |
| CN110458743B (en) * | 2019-08-12 | 2022-04-29 | 软通智慧信息技术有限公司 | Community management method, device, equipment and storage medium based on big data analysis |
| CN110716989A (en) * | 2019-08-27 | 2020-01-21 | 苏宁云计算有限公司 | Dimension data processing method and device, computer equipment and storage medium |
| CN116126976B (en) * | 2023-04-06 | 2023-07-04 | 之江实验室 | Data synchronization method and device, storage medium and electronic equipment |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101166118A (en) * | 2007-09-30 | 2008-04-23 | 华为技术有限公司 | A method for processing user configuration information and service report system |
| CN102053982A (en) * | 2009-11-02 | 2011-05-11 | 阿里巴巴集团控股有限公司 | Method and equipment for managing database information |
| CN102075553A (en) * | 2009-11-23 | 2011-05-25 | 华为终端有限公司 | Synchronization markup language (SyncML)-based data synchronization method and equipment |
| CN102724295A (en) * | 2012-05-24 | 2012-10-10 | 中国电子科技集团公司第十五研究所 | Data synchronization method and system |
| CN102843366A (en) * | 2012-08-13 | 2012-12-26 | 北京百度网讯科技有限公司 | Network resource access permission control method and device |
Family Cites Families (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| AU2005231230B2 (en) * | 2004-02-21 | 2010-05-27 | Microsoft Technology Licensing, Llc | Ultra-shared-nothing parallel database |
| US20070022120A1 (en) * | 2005-07-25 | 2007-01-25 | Microsoft Corporation | Caching and modifying portions of a multi-dimensional database on a user device |
| US7792856B2 (en) * | 2007-06-29 | 2010-09-07 | International Business Machines Corporation | Entity-based business intelligence |
| US8150808B2 (en) * | 2009-10-21 | 2012-04-03 | Delphix Corp. | Virtual database system |
| CN102710356B (en) * | 2012-05-25 | 2016-04-13 | 周明 | A kind of real time redundancy master station data synchronization method |
| CN102982141B (en) * | 2012-11-20 | 2016-01-20 | 北京搜狐新媒体信息技术有限公司 | A kind of method and device realizing distributed data base agency |
| CN103023656B (en) * | 2012-12-17 | 2018-06-01 | 北京普泽创智数据技术有限公司 | A kind of distribution sequence list authority control method and its system |
-
2013
- 2013-06-25 CN CN201310256161.2A patent/CN104252452B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101166118A (en) * | 2007-09-30 | 2008-04-23 | 华为技术有限公司 | A method for processing user configuration information and service report system |
| CN102053982A (en) * | 2009-11-02 | 2011-05-11 | 阿里巴巴集团控股有限公司 | Method and equipment for managing database information |
| CN102075553A (en) * | 2009-11-23 | 2011-05-25 | 华为终端有限公司 | Synchronization markup language (SyncML)-based data synchronization method and equipment |
| CN102724295A (en) * | 2012-05-24 | 2012-10-10 | 中国电子科技集团公司第十五研究所 | Data synchronization method and system |
| CN102843366A (en) * | 2012-08-13 | 2012-12-26 | 北京百度网讯科技有限公司 | Network resource access permission control method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104252452A (en) | 2014-12-31 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104252452B (en) | The method and device of data management | |
| CA2667142C (en) | Method and apparatus for creating a configurable browser-based forms application | |
| TWI356315B (en) | Method and system for constructing data tag based | |
| CN103678494B (en) | Client synchronization services the method and device of end data | |
| US9471575B2 (en) | Managing changes to one or more files via linked mapping records | |
| US10168870B2 (en) | System for retrieving, visualizing and editing semantic annotations | |
| US8046382B2 (en) | Method and system for software object profile management | |
| CN103150624A (en) | Equipment management and monitoring system based on process flow diagram | |
| US20080066079A1 (en) | Context-Exchange Mechanism For Accumulating And Propagating Contextual Information Between Applications | |
| US20130204875A1 (en) | Automatic Configuration Of A Product Data Management System | |
| US9740693B2 (en) | Techniques for managing persistent document collections | |
| EP2506162A1 (en) | Finding a data item of a plurality of data items stored in a digital data storage | |
| JP5979895B2 (en) | Document management system, computer program, and document management method | |
| CN103984554B (en) | The generation method and device of Software for Design document | |
| CN110531964A (en) | The intelligent developed method of software personalisation | |
| JP2011513842A5 (en) | ||
| CN106503216A (en) | Support the metadata synchronization method and metadata synchronization device of layering | |
| US9529900B2 (en) | Visual interface browser | |
| CN106201515A (en) | Code programming Governance framework and method in modified model computer software | |
| CN113868253A (en) | Data relationship capturing and big data relationship tree construction method | |
| JP6695847B2 (en) | Software parts management system, computer | |
| JP2010061200A (en) | Document management system and operation history display method | |
| CN108733736A (en) | Asset creation methods, devices and systems | |
| JP5783368B2 (en) | Information processing apparatus, information processing method, and information processing program | |
| CN106201516A (en) | Code programming Governance framework and method in computer software |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20190801 Address after: Shenzhen Futian District City, Guangdong province 518000 Zhenxing Road, SEG Science Park 2 East Room 403 Co-patentee after: Tencent cloud computing (Beijing) limited liability company Patentee after: Tencent Technology (Shenzhen) Co., Ltd. Address before: Shenzhen Futian District City, Guangdong province 518000 Zhenxing Road, SEG Science Park 2 East Room 403 Patentee before: Tencent Technology (Shenzhen) Co., Ltd. |
|
| TR01 | Transfer of patent right |