CN110362551A - Building Method of Data Warehouse, device, equipment and storage medium - Google Patents
Building Method of Data Warehouse, device, equipment and storage medium Download PDFInfo
- Publication number
- CN110362551A CN110362551A CN201810283053.7A CN201810283053A CN110362551A CN 110362551 A CN110362551 A CN 110362551A CN 201810283053 A CN201810283053 A CN 201810283053A CN 110362551 A CN110362551 A CN 110362551A
- Authority
- CN
- China
- Prior art keywords
- dimension
- attribute
- inheritance
- commodity
- data warehouse
- 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
- 238000000034 method Methods 0.000 title claims abstract description 53
- 238000010276 construction Methods 0.000 claims description 18
- 238000004590 computer program Methods 0.000 claims description 5
- 230000008569 process Effects 0.000 description 7
- 238000012545 processing Methods 0.000 description 7
- 238000010586 diagram Methods 0.000 description 5
- 238000012423 maintenance Methods 0.000 description 4
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 238000004458 analytical method Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000006467 substitution reaction Methods 0.000 description 2
- TVZRAEYQIKYCPH-UHFFFAOYSA-N 3-(trimethylsilyl)propane-1-sulfonic acid Chemical compound C[Si](C)(C)CCCS(O)(=O)=O TVZRAEYQIKYCPH-UHFFFAOYSA-N 0.000 description 1
- 230000000712 assembly Effects 0.000 description 1
- 238000000429 assembly Methods 0.000 description 1
- 238000009411 base construction Methods 0.000 description 1
- 230000008901 benefit Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 239000000835 fiber Substances 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 238000012827 research and development Methods 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
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/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
- G06F16/212—Schema design and management with details for data modelling support
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the present application discloses a kind of Building Method of Data Warehouse, device, equipment and storage medium.This method comprises: establishing the inheritance of the first dimension Yu the second dimension predetermined;According to inheritance, the first dimension inherits the defined attribute of the second dimension;Define that the second dimension is undefined, the distinctive attribute of the first dimension;According to the defined attribute of the second dimension and the distinctive attribute of the first dimension, data warehouse is constructed.The Building Method of Data Warehouse, device, equipment and storage medium of the embodiment of the present application, first dimension inherits the defined attribute of the second dimension, the defined attribute of second dimension without being defined again, it only needs to define that the second dimension is undefined, the distinctive attribute of the first dimension, can guarantee the consistency of data and data redundancy can be reduced.
Description
Technical field
This application involves technical field of data administration more particularly to a kind of Building Method of Data Warehouse, device, equipment and deposit
Storage media.
Background technique
Traditional database technology be with single data resource, i.e., centered on database, carry out transaction, batch at
The various data processing works such as reason, Analysis of Policy Making.The daily pursuits that traditional Database Systems are conducive to enterprise handle work, but difficult
In realizing the requirement to Data Analysis Services, the diversified requirement of data processing can no longer meet.
For traditional database application, data warehouse is a subject-oriented, integrated, metastable
The data acquisition system for being used to support managerial decision making of (i.e. nonupdatable), reflecting history variation (changing over time), it
It is the structural data environment of DSS and on-line analysis application data source.
Existing data warehouse generallys use the Star Model Star Schema based on multi-dimensional data modeling and is set
Meter.The Star Schema usually has biggish central table (i.e. true table) and one group with radial, and to be centered around central table all
The lesser table (i.e. dimension table) enclosed.Wherein, the public attribute for there are all subtypes is defined in central table, is determined in each dimension table
Justice has public attribute and respective particular attribute in central table.
But the public attribute in central table can be realized by multiple definition and repeatedly, when the public attribute hair in central table
When changing, the maintenance and management of dimension table is extremely difficult, not can guarantee the data one in the data and central table in dimension table
Cause property;And there are redundancies for data.
Summary of the invention
The embodiment of the present application provides a kind of Building Method of Data Warehouse, device, equipment and storage medium, can guarantee data
Consistency and data redundancy can be reduced.
On the one hand, the embodiment of the present application provides a kind of Building Method of Data Warehouse, and method includes:
Establish the inheritance of the first dimension Yu the second dimension predetermined;
According to inheritance, the first dimension inherits the defined attribute of the second dimension;
Define that the second dimension is undefined, the distinctive attribute of the first dimension;
According to the defined attribute of the second dimension and the distinctive attribute of the first dimension, data warehouse is constructed.
In one embodiment of the application, Building Method of Data Warehouse further include:
According to inheritance, the first dimension and the second dimension, the view based on the first dimension and the second dimension, view are generated
Including the defined attribute of the second dimension and the distinctive attribute of the first dimension.
In one embodiment of the application, the distinctive attribute of the first dimension in view is invisible relative to user.
In one embodiment of the application, the inheritance of the first dimension Yu the second dimension predetermined is established, is wrapped
Include: the father's dimension for defining the first dimension is the second dimension.
In one embodiment of the application, the inheritance for establishing the first dimension and the second dimension predetermined it
Before, Building Method of Data Warehouse further include:
Define the attribute of the second dimension and the second dimension.
In one embodiment of the application, after defining the attribute of the second dimension and the second dimension, data warehouse
Construction method further include:
Establish the attribute of the second dimension and the incidence relation of other dimensions.
On the other hand, the embodiment of the present application provides a kind of data warehouse construction device, and device includes:
Inheritance establishes module, for establishing the inheritance of the first dimension Yu the second dimension predetermined;
Module is inherited, for according to inheritance, the first dimension to inherit the defined attribute of the second dimension;
First definition module, undefined, the distinctive attribute of the first dimension for the second dimension of definition;
Module is constructed, is used for according to the defined attribute of second dimension and the distinctive attribute of the first dimension,
Construct data warehouse.
In one embodiment of the application, data warehouse construction device further include:
Generation module, for generating based on the first dimension and the second dimension according to inheritance, the first dimension and the second dimension
The view of degree, view include the defined attribute of the second dimension and the distinctive attribute of the first dimension.
In one embodiment of the application, the distinctive attribute of the first dimension in view is invisible relative to user.
In one embodiment of the application, inheritance establishes module, is specifically used for:
The father's dimension for defining the first dimension is the second dimension.
In one embodiment of the application, data warehouse construction device further include:
Second definition module, for defining the attribute of the second dimension and the second dimension.
In one embodiment of the application, data warehouse construction device further include:
Incidence relation establishes module, for establishing the attribute of the second dimension and the incidence relation of other dimensions.
In another aspect, the embodiment of the present application provides a kind of data warehouse building equipment, equipment includes: memory and processing
Device;
Memory is for storing executable program code;
Processor is for reading the executable program code stored in memory to execute number provided by the embodiments of the present application
According to warehouse construction method.
In another aspect, the embodiment of the present application provides a kind of computer readable storage medium, on computer readable storage medium
It is stored with computer program instructions;Data bins provided by the embodiments of the present application are realized when computer program instructions are executed by processor
Base construction method.
The Building Method of Data Warehouse, device, equipment and storage medium of the embodiment of the present application, the first dimension inherit the second dimension
Spend defined attribute, the defined attribute of the second dimension without being defined again, it is only necessary to define the second dimension it is undefined, the
The distinctive attribute of dimension can guarantee the consistency of data and can reduce data redundancy.
Detailed description of the invention
Technical solution in ord to more clearly illustrate embodiments of the present application will make below to required in the embodiment of the present application
Attached drawing is briefly described, for those of ordinary skill in the art, without creative efforts, also
Other drawings may be obtained according to these drawings without any creative labor.
Fig. 1 shows the flow diagram of Building Method of Data Warehouse provided by the embodiments of the present application;
Fig. 2 shows the structural schematic diagrams of data warehouse construction device provided by the embodiments of the present application;
Fig. 3, which is shown, can be realized according to the exemplary of the calculating equipment of the Building Method of Data Warehouse of the embodiment of the present application
The structure chart of hardware structure.
Specific embodiment
The feature and exemplary embodiment of the various aspects of the application is described more fully below, in order to make the mesh of the application
, technical solution and advantage be more clearly understood, with reference to the accompanying drawings and embodiments, the application is further retouched in detail
It states.It should be understood that specific embodiment described herein is only configured to explain the application, it is not configured as limiting the application.
To those skilled in the art, the application can be real in the case where not needing some details in these details
It applies.Below the description of embodiment is used for the purpose of better understanding the application to provide by showing the example of the application.
It should be noted that, in this document, relational terms such as first and second and the like are used merely to a reality
Body or operation are distinguished with another entity or operation, are deposited without necessarily requiring or implying between these entities or operation
In any actual relationship or order or sequence.Moreover, the terms "include", "comprise" or its any other variant are intended to
Non-exclusive inclusion, so that the process, method, article or equipment including a series of elements is not only wanted including those
Element, but also including other elements that are not explicitly listed, or further include for this process, method, article or equipment
Intrinsic element.In the absence of more restrictions, the element limited by sentence " including ... ", it is not excluded that including
There is also other identical elements in the process, method, article or equipment of the element.
When due to the creation of existing data warehouse, the attribute of dimension can be defined repeatedly, not can guarantee the consistency of data
And there are redundancies for data.Based on this, the embodiment of the present application provides a kind of Building Method of Data Warehouse, device, equipment and storage and is situated between
The inheritance method of object-oriented is innovatively introduced into the dimensional attribute definition of data warehouse, avoids the weight of attribute by matter
Multiple definition, realizes the unified management and maintenance of attribute, ensure that the consistency of data;And the defined attribute of father's dimension is not necessarily to
It is defined again, it is only necessary to which the particular attribute for defining sub- dimension reduces data redundancy.
Building Method of Data Warehouse provided by the embodiments of the present application is described in detail first below.
Fig. 1 shows the flow diagram of Building Method of Data Warehouse provided by the embodiments of the present application.Data warehouse building
Method may include:
S101: the inheritance of the first dimension Yu the second dimension predetermined is established.
S102: according to inheritance, the first dimension inherits the defined attribute of the second dimension.
S103: define that the second dimension is undefined, the distinctive attribute of the first dimension.
S104: according to the defined attribute of the second dimension and the distinctive attribute of the first dimension, data warehouse is constructed.
It is understood that establishing the inheritance and the first dimension the second dimension of succession of the first dimension and the second dimension
Defined attribute needs in advance to be defined the second dimension, and defines the attribute of the second dimension.
Wherein, the succession in the embodiment of the present application is a concept in Object Oriented technology.Succession can make
Sub- dimension has the attribute of father's dimension.
Illustratively, below with the second dimension for M commodity dimension, the first dimension is respectively N1 commodity dimension, N2 commodity dimension
Degree and N3 commodity dimension, N1 commodity dimension, N2 commodity dimension and N3 commodity dimension inherit the defined attribute of M commodity dimension and are
Example is illustrated.
It is understood that M commodity dimension is N1 commodity dimension, father's dimension of N2 commodity dimension and N3 commodity dimension, N1
Commodity dimension, N2 commodity dimension and N3 commodity dimension are the sub- dimension of M commodity dimension.
The Chinese for defining M commodity dimension is M commodity dimension, English name dim_M_item.
The attribute for defining M commodity dimension is as shown in table 1.
Table 1
In one embodiment of the application, the major key of M commodity dimension can also be defined, for example be by attribute English name
The attribute definition of item_id is the major key of M commodity dimension.Wherein, major key is also known as major key, is one or more words in table
Section, its value are used to uniquely identify a certain item record in table.
When defining the particular attribute of N1 commodity dimension, the Chinese of N1 commodity dimension is defined first as N1 commodity dimension
Degree, English name dim_N1_item.
Then the inheritance of N1 commodity dimension Yu M commodity dimension is established.
In one embodiment of the application, the inheritance of N1 commodity dimension Yu M commodity dimension is established, N1 can be defined
Father's dimension of commodity dimension is M commodity dimension.
According to the inheritance of N1 commodity dimension and M commodity dimension, N1 commodity dimension inherits the defined category of M commodity dimension
Property.At this point, for N1 commodity dimension, N1 commodity dimension has each attribute shown in above-mentioned table 1, shown in table 1
Each attribute without being defined again.
For N1 commodity dimension, it is only necessary to define the particular attribute of N1 commodity dimension.
The particular attribute for defining N1 commodity dimension is as shown in table 2.
Table 2
At this point, N1 commodity dimension has each attribute shown in above-mentioned table 1, and has for N1 commodity dimension
There is each attribute shown in above-mentioned table 2.
When defining the particular attribute of N2 commodity dimension, the Chinese of N2 commodity dimension is defined first as N2 commodity dimension
Degree, English name dim_N2_item.
Then the inheritance of N2 commodity dimension Yu M commodity dimension is established.
In one embodiment of the application, the inheritance of N2 commodity dimension Yu M commodity dimension is established, N2 can be defined
Father's dimension of commodity dimension is M commodity dimension.
According to the inheritance of N2 commodity dimension and M commodity dimension, N2 commodity dimension inherits the defined category of M commodity dimension
Property.At this point, for N2 commodity dimension, N2 commodity dimension has each attribute shown in above-mentioned table 1, shown in table 1
Each attribute without being defined again.
For N2 commodity dimension, it is only necessary to define the particular attribute of N2 commodity dimension.
The particular attribute for defining N2 commodity dimension is as shown in table 3.
Table 3
At this point, N2 commodity dimension has each attribute shown in above-mentioned table 1, and has for N2 commodity dimension
There is each attribute shown in above-mentioned table 3.
When defining the particular attribute of N3 commodity dimension, the Chinese of N3 commodity dimension is defined first as N3 commodity dimension
Degree, English name dim_N3_item.
Then the inheritance of N3 commodity dimension Yu M commodity dimension is established.
In one embodiment of the application, the inheritance of N3 commodity dimension Yu M commodity dimension is established, N3 can be defined
Father's dimension of commodity dimension is M commodity dimension.
According to the inheritance of N3 commodity dimension and M commodity dimension, N3 commodity dimension inherits the defined category of M commodity dimension
Property.At this point, for N3 commodity dimension, N3 commodity dimension has each attribute shown in above-mentioned table 1, shown in table 1
Each attribute without being defined again.
For N3 commodity dimension, it is only necessary to define the particular attribute of N3 commodity dimension.
The particular attribute for defining N3 commodity dimension is as shown in table 4.
Table 4
At this point, N3 commodity dimension has each attribute shown in above-mentioned table 1, and has for N3 commodity dimension
There is each attribute shown in above-mentioned table 4.
Wherein, big int of the table 1 into table 4 indicates that attribute type is long, and string indicates that attribute type is character
Serial type.
Each row data of the table 1 into table 4 under attribute calculating logic are the sentence based on structured query language SQL.
Commodity list in table 1 can be the source table that data warehouse is synchronized to from data source.
Attribute in table 1 it can be seen from above-mentioned table 1 to table 4 is only defined once, N1 commodity dimension, N2 commodity dimension
Degree, N3 commodity dimension are not again defined the attribute in table 1.By way of succession, the attribute in table 1 is inherited.It avoids
Attribute re-defines, and realizes the unified management and maintenance of attribute, ensure that the consistency of data, and it is superfluous to reduce data
It is remaining.
In one embodiment of the application, N1 commodity dimension, N2 commodity dimension, N3 commodity dimension can inherit M commodity
The all properties of dimension, naturally it is also possible to only inherit part attribute.
When M commodity dimension and its attribute, N1 commodity dimension and its attribute definition, N2 commodity dimension and its attribute definition and N3
After the completion of commodity dimension and its attribute definition, according to the defined attribute of M commodity dimension, the defined endemic genus of N1 commodity dimension
Property, the defined particular attribute of N2 commodity dimension and the defined particular attribute of N3 commodity dimension, construct data warehouse.
According to the Building Method of Data Warehouse of the embodiment of the present application, innovatively the inheritance method of object-oriented is introduced into
In the dimensional attribute definition of data warehouse, re-defining for attribute is avoided, the unified management and maintenance of attribute are realized, is guaranteed
The consistency of data;And the defined attribute of father's dimension without being defined again, it is only necessary to define the particular attribute of sub- dimension i.e.
Can, reduce data redundancy.
In one embodiment of the application, Building Method of Data Warehouse can also include: according to inheritance, the first dimension
Degree and the second dimension, generate the view based on the first dimension and the second dimension, view include the defined attribute of the second dimension with
And the first distinctive attribute of dimension.Wherein, view is a Virtual table in data warehouse, includes that a series of bands are denominative
The data of columns and rows.
Also it is illustrated by taking above-mentioned M commodity dimension, N1 commodity dimension, N2 commodity dimension and N3 commodity dimension as an example.
According to the inheritance of aforementioned four dimension, the view of generation is as shown in table 5.
Table 5
In one embodiment of the application, the distinctive attribute of the first dimension in view is invisible relative to user.
For the view shown in the table 5,1 part of table that table 5 includes is for user as it can be seen that and table 5 includes
Table 2 is invisible for user to 4 part of table.That is the attribute of M commodity dimension is for user as it can be seen that and N1 commodity
The attribute of dimension, N2 commodity dimension and N3 commodity dimension is invisible for user.This allows for user and does not need to perceive and find
Newly-increased sub- dimension is easy to be perceived, is re-used, is able to ascend production by View Mechanism across member, cross-team development
Product efficiency of research and development, and can guarantee the consistency of data.And it for a user, need to only see M commodity dimension, be not required to
Each seed dimension is gone for, need to only find commodity, so that it may find all properties corresponding to commodity, be able to ascend data search
Speed.
In one embodiment of the application, attribute is associated with dimension if it exists, then is defining the second dimension and second
After the attribute of dimension, the attribute of the second dimension and the incidence relation of other dimensions can establish.
Such as: the cate_id attribute in M commodity dimension is associated with M classification dimension, the seller_id in M commodity dimension belongs to
Property is associated with M seller's dimension, the xcat1_id attribute in N1 commodity dimension is associated with N1 industry dimension, in N2 commodity dimension
Xcat2_id attribute be associated with N2 industry dimension and N3 commodity dimension in xcat3_id attribute be associated with N3 industry dimension.
Then establish cate_id attribute and M classification dimension, seller_id attribute and M seller's dimension, xcat1_id attribute and
The incidence relation of N1 industry dimension, xcat2_id attribute and N2 industry dimension and xcat3_id attribute and N3 industry dimension.
For establishing cate_id attribute and M classification dimension.
The cate_id attribute of foundation and the incidence relation of M classification dimension are as shown in table 6.
Table 6
Attribute English name | Attribute Association dimension English name | Attribute Association dimension Chinese |
cate_id | dim_M_cate | M classification dimension |
According to the Building Method of Data Warehouse of the embodiment of the present application, with using above-mentioned view per family, across sub- dimension into
When row data query, without carrying out table association manually, by the incidence relation of above-mentioned foundation, system carries out SQL statement automatically
Assembled and execution, improves data query speed.
It should be noted that it is above-mentioned by taking M commodity dimension, N1 commodity dimension, N2 commodity dimension and N3 commodity dimension as an example into
Row explanation, the only specific example of the application, do not constitute the restriction to the application.
Corresponding with above-mentioned embodiment of the method, the embodiment of the present application also provides a kind of data warehouse construction device, such as Fig. 2
It is shown.Fig. 2 shows the structural schematic diagrams of data warehouse construction device provided by the embodiments of the present application.Data warehouse construction device
May include:
Inheritance establishes module 201, for establishing the inheritance of the first dimension Yu the second dimension predetermined;
Module 202 is inherited, for according to inheritance, the first dimension to inherit the defined attribute of the second dimension;
First definition module 203, undefined, the distinctive attribute of the first dimension for the second dimension of definition;
Module 204 is constructed, for according to the defined attribute of second dimension and the distinctive category of the first dimension
Property, construct data warehouse.
In one embodiment of the application, data warehouse construction device can also include: that generation module (does not show in figure
Out), for generating the view based on the first dimension and the second dimension, view according to inheritance, the first dimension and the second dimension
Including the defined attribute of the second dimension and the distinctive attribute of the first dimension.
In one embodiment of the application, the distinctive attribute of the first dimension in view is invisible relative to user.
In one embodiment of the application, inheritance establishes module, specifically can be used for:
The father's dimension for defining the first dimension is the second dimension.
In one embodiment of the application, data warehouse construction device can also include: the second definition module (in figure not
Show), for defining the attribute of the second dimension and the second dimension.
In one embodiment of the application, data warehouse construction device can also include: that incidence relation establishes module (figure
In be not shown), for establishing the attribute of the second dimension and the incidence relation of other dimensions.
The embodiment of the present application of each section details and the figure 1 above description of the data warehouse construction device of the embodiment of the present application
Building Method of Data Warehouse it is similar, details are not described herein for the embodiment of the present application.
Fig. 3 shows the calculating equipment that can be realized the Building Method of Data Warehouse and device according to the embodiment of the present application
The structure chart of exemplary hardware architecture.As shown in figure 3, calculating equipment 300 includes input equipment 301, input interface 302, center
Processor 303, memory 304, output interface 305 and output equipment 306.Wherein, input interface 302, central processing unit
303, memory 304 and output interface 305 are connected with each other by bus 310, and input equipment 301 and output equipment 306 are distinguished
It is connect by input interface 302 and output interface 305 with bus 310, and then is connect with the other assemblies for calculating equipment 300.
Specifically, input equipment 301 is received from external input information, and will input information by input interface 302
It is transmitted to central processing unit 303;Central processing unit 303 is based on the computer executable instructions stored in memory 304 to input
Information is handled to generate output information, and output information is temporarily or permanently stored in memory 304, is then passed through
Output information is transmitted to output equipment 306 by output interface 305;Output information is output to and calculates equipment 300 by output equipment 306
Outside for users to use.
That is, calculating equipment shown in Fig. 3 also may be implemented as data warehouse building equipment, the data warehouse structure
It may include: the memory for being stored with computer executable instructions that construction is standby;And processor, the processor are executing computer
The Building Method of Data Warehouse and device that combine Fig. 1 and Fig. 2 to describe may be implemented when executable instruction.
The embodiment of the present application also provides a kind of computer readable storage medium, is stored on the computer readable storage medium
Computer program instructions;The computer program instructions realize data warehouse structure provided by the embodiments of the present application when being executed by processor
Construction method.
It should be clear that the application is not limited to specific configuration described above and shown in figure and processing.
For brevity, it is omitted here the detailed description to known method.In the above-described embodiments, several tools have been described and illustrated
The step of body, is as example.But the present processes process is not limited to described and illustrated specific steps, this field
Technical staff can be variously modified, modification and addition after understanding spirit herein, or suitable between changing the step
Sequence.
Functional block shown in structures described above block diagram can be implemented as hardware, software, firmware or their group
It closes.When realizing in hardware, it may, for example, be electronic circuit, specific integrated circuit (ASIC), firmware appropriate, insert
Part, function card etc..When being realized with software mode, the element of the application is used to execute program or the generation of required task
Code section.Perhaps code segment can store in machine readable media program or the data-signal by carrying in carrier wave is passing
Defeated medium or communication links are sent." machine readable media " may include any medium for capableing of storage or transmission information.
The example of machine readable media includes electronic circuit, semiconductor memory devices, ROM, flash memory, erasable ROM (EROM), soft
Disk, CD-ROM, CD, hard disk, fiber medium, radio frequency (RF) link, etc..Code segment can be via such as internet, inline
The computer network of net etc. is downloaded.
It should also be noted that, the exemplary embodiment referred in the application, is retouched based on a series of step or device
State certain methods or system.But the application is not limited to the sequence of above-mentioned steps, that is to say, that can be according in embodiment
The sequence referred to executes step, may also be distinct from that the sequence in embodiment or several steps are performed simultaneously.
The above, the only specific embodiment of the application, it is apparent to those skilled in the art that,
For convenience of description and succinctly, the system, module of foregoing description and the specific work process of unit can refer to preceding method
Corresponding process in embodiment, details are not described herein.It should be understood that the protection scope of the application is not limited thereto, it is any to be familiar with
Those skilled in the art within the technical scope of the present application, can readily occur in various equivalent modifications or substitutions,
These modifications or substitutions should all cover within the scope of protection of this application.
Claims (14)
1. a kind of Building Method of Data Warehouse, which is characterized in that the described method includes:
Establish the inheritance of the first dimension Yu the second dimension predetermined;
According to the inheritance, first dimension inherits the defined attribute of the second dimension;
Define that second dimension is undefined, the distinctive attribute of the first dimension;
According to the defined attribute of second dimension and the distinctive attribute of the first dimension, data warehouse is constructed.
2. the method according to claim 1, wherein the method also includes:
According to the inheritance, first dimension and second dimension, generate based on first dimension and described the
The view of two-dimensions, the view include the defined attribute of second dimension and the distinctive attribute of the first dimension.
3. according to the method described in claim 2, it is characterized in that, the distinctive attribute phase of first dimension in the view
It is invisible for user.
4. the method according to claim 1, wherein described establish the first dimension and the second dimension predetermined
Inheritance, comprising:
The father's dimension for defining first dimension is second dimension.
5. the method according to claim 1, wherein establishing the first dimension and the second dimension predetermined described
Before the inheritance of degree, the method also includes:
Define the attribute of second dimension and second dimension.
6. according to the method described in claim 5, it is characterized in that, defining second dimension and second dimension described
After the attribute of degree, the method also includes:
Establish the attribute of second dimension and the incidence relation of other dimensions.
7. a kind of data warehouse construction device, which is characterized in that described device includes:
Inheritance establishes module, for establishing the inheritance of the first dimension Yu the second dimension predetermined;
Module is inherited, for according to the inheritance, first dimension to inherit the defined attribute of the second dimension;
First definition module, for defining, second dimension is undefined, the distinctive attribute of the first dimension;
Module is constructed, for according to the defined attribute of second dimension and the distinctive attribute of the first dimension, building
Data warehouse.
8. device according to claim 7, which is characterized in that described device further include:
Generation module, for generating and being based on described first according to the inheritance, first dimension and second dimension
The view of dimension and second dimension, the view include the defined attribute of second dimension and first dimension
Distinctive attribute.
9. device according to claim 8, which is characterized in that the distinctive attribute phase of first dimension in the view
It is invisible for user.
10. device according to claim 7, which is characterized in that the inheritance establishes module, is specifically used for:
The father's dimension for defining first dimension is second dimension.
11. device according to claim 7, which is characterized in that described device further include:
Second definition module, for defining the attribute of second dimension and second dimension.
12. device according to claim 11, which is characterized in that described device further include:
Incidence relation establishes module, for establishing the attribute of second dimension and the incidence relation of other dimensions.
13. a kind of data warehouse constructs equipment, which is characterized in that the equipment includes: memory and processor;
The memory is for storing executable program code;
The processor is used to read the executable program code stored in the memory and requires 1-6 any one with perform claim
Building Method of Data Warehouse described in.
14. a kind of computer readable storage medium, which is characterized in that be stored with computer on the computer readable storage medium
Program instruction;The computer program instructions realize data as claimed in any one of claims 1 to 6 when being executed by processor
Warehouse construction method.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810283053.7A CN110362551A (en) | 2018-04-02 | 2018-04-02 | Building Method of Data Warehouse, device, equipment and storage medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810283053.7A CN110362551A (en) | 2018-04-02 | 2018-04-02 | Building Method of Data Warehouse, device, equipment and storage medium |
Publications (1)
Publication Number | Publication Date |
---|---|
CN110362551A true CN110362551A (en) | 2019-10-22 |
Family
ID=68213497
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201810283053.7A Pending CN110362551A (en) | 2018-04-02 | 2018-04-02 | Building Method of Data Warehouse, device, equipment and storage medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110362551A (en) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110851543A (en) * | 2019-11-08 | 2020-02-28 | 深圳市彬讯科技有限公司 | Data modeling method, device, equipment and storage medium |
CN112115235A (en) * | 2020-09-28 | 2020-12-22 | 中国建设银行股份有限公司 | Entity attribute data query and configuration method, device and server |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6418427B1 (en) * | 1999-12-30 | 2002-07-09 | Decode Genetics Ehf | Online modifications of dimension structures in multidimensional processing |
CN101089846A (en) * | 2006-06-16 | 2007-12-19 | 国际商业机器公司 | Data analysis method, equipment and data analysis auxiliary method |
US20130036222A1 (en) * | 2010-06-14 | 2013-02-07 | Compuware Corporation | Inheritable dimensions in a service model |
CN105528360A (en) * | 2014-09-30 | 2016-04-27 | 百旭科技有限公司 | Design of walking type instruction recombination of Service Oriented Architecture (SOA) applied to real-time commercial intelligent system |
-
2018
- 2018-04-02 CN CN201810283053.7A patent/CN110362551A/en active Pending
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6418427B1 (en) * | 1999-12-30 | 2002-07-09 | Decode Genetics Ehf | Online modifications of dimension structures in multidimensional processing |
CN101089846A (en) * | 2006-06-16 | 2007-12-19 | 国际商业机器公司 | Data analysis method, equipment and data analysis auxiliary method |
US20130036222A1 (en) * | 2010-06-14 | 2013-02-07 | Compuware Corporation | Inheritable dimensions in a service model |
CN105528360A (en) * | 2014-09-30 | 2016-04-27 | 百旭科技有限公司 | Design of walking type instruction recombination of Service Oriented Architecture (SOA) applied to real-time commercial intelligent system |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110851543A (en) * | 2019-11-08 | 2020-02-28 | 深圳市彬讯科技有限公司 | Data modeling method, device, equipment and storage medium |
CN112115235A (en) * | 2020-09-28 | 2020-12-22 | 中国建设银行股份有限公司 | Entity attribute data query and configuration method, device and server |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
EP3380954B1 (en) | Storing and retrieving data of a data cube | |
CN110019397B (en) | Method and device for data processing | |
US9965641B2 (en) | Policy-based data-centric access control in a sorted, distributed key-value data store | |
TW202029079A (en) | Method and device for identifying irregular group | |
US9201700B2 (en) | Provisioning computer resources on a network | |
JP2010524060A (en) | Data merging in distributed computing | |
Afrati et al. | GYM: A multiround distributed join algorithm | |
US10552129B2 (en) | Agglomerative algorithm for graph clustering | |
US11615076B2 (en) | Monolith database to distributed database transformation | |
EP2965492B1 (en) | Selection of data storage settings for an application | |
EP3470992B1 (en) | Efficient storage and utilization of a hierarchical data set | |
CN110502520A (en) | A kind of method of data loading, system, equipment and computer readable storage medium | |
US20110264703A1 (en) | Importing Tree Structure | |
WO2020003109A1 (en) | Facet-based query refinement based on multiple query interpretations | |
CN105653716A (en) | Database construction method and system based on classification-attribute-value | |
CN112860730A (en) | SQL statement processing method and device, electronic equipment and readable storage medium | |
CN111125064A (en) | Method and device for generating database mode definition statement | |
WO2017107130A1 (en) | Data query method and database system | |
US9792355B2 (en) | Searches for similar documents | |
CN110362551A (en) | Building Method of Data Warehouse, device, equipment and storage medium | |
US6748388B1 (en) | Method and mechanism for storing and managing self-descriptive heterogeneous data | |
CN110109893A (en) | The method and apparatus of data modeling and operation | |
Diao et al. | Efficient exploration of interesting aggregates in RDF graphs | |
US8407255B1 (en) | Method and apparatus for exploiting master-detail data relationships to enhance searching operations | |
Moertini et al. | Enhancing parallel k-means using map reduce for discovering knowledge from big data |
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 | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20191022 |
|
RJ01 | Rejection of invention patent application after publication |