CN105335401B - Data warehouse INDEX MANAGEMENT method and apparatus and system - Google Patents
Data warehouse INDEX MANAGEMENT method and apparatus and system Download PDFInfo
- Publication number
- CN105335401B CN105335401B CN201410351744.8A CN201410351744A CN105335401B CN 105335401 B CN105335401 B CN 105335401B CN 201410351744 A CN201410351744 A CN 201410351744A CN 105335401 B CN105335401 B CN 105335401B
- Authority
- CN
- China
- Prior art keywords
- index
- pond
- interface
- operation system
- middle layer
- 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
Abstract
The application proposes a kind of data warehouse INDEX MANAGEMENT method and apparatus and system, the data warehouse INDEX MANAGEMENT method includes the index for receiving Data Mart and being exported by first interface, the first interface is the unified interface between Data Mart and middle layer, and the middle layer is the preset interface layer between Data Mart and operation system；The index is stored in corresponding index pond；The index is exported to corresponding operation system by second interface, the second interface is the unified interface between the middle layer and the operation system.This method is able to solve traditional approach and is managed the problem of causing with table level, thus avoid bore inconsistent, overlapping development and unmanageable problem.
Description
Technical field
This application involves technical field of data processing more particularly to a kind of data warehouse INDEX MANAGEMENT method and apparatus and it is
System.
Background technique
Data warehouse (Data Warehouse, DW) is that a subject-oriented, integrated, metastable, reflection are gone through
The data acquisition system of history variation, for supporting administrative decision.Table is the important component of data warehouse, and a table record is by key
Word (key), measurement and attribute data composition.
Generally from multiple Data Mart outputs, each Data Mart adds data warehouse output-index according to respective business side's demand
Work index.Such as loan balance, risk fairground and operation fairground all develop the index and are output to business intelligence (Business
Intelligence, BI) report is shown and checks for business side.
Traditional data warehouse is all using table as granularity development index, and INDEX MANAGEMENT is also managed with table level.But by
Be dispersed in the different tables in different data fairground in index, between different data fairground index of the same name there are bore inconsistence problems,
Even if the index of the same name between the same Data Mart difference table is also likely to be present bore inconsistence problems；Different data is deposited between fairground
In overlapping development, waste of resource problem；Index is difficult to the problems such as managing.
Summary of the invention
The application is intended to solve at least some of the technical problems in related technologies.
For this purpose, the purpose of the application is to propose that a kind of data warehouse INDEX MANAGEMENT method, this method can solve
Traditional approach is managed the problem of causing with table level, to avoid bore inconsistent, overlapping development and unmanageable asks
Topic.
Further object is to propose a kind of data warehouse INDEX MANAGEMENT device.
Further object is to propose a kind of data warehouse.
In order to achieve the above objectives, the data warehouse INDEX MANAGEMENT method that the application first aspect embodiment proposes, comprising: connect
The index that Data Mart is exported by first interface is received, the first interface is uniformly connecing between Data Mart and middle layer
Mouthful, the middle layer is the preset interface layer between Data Mart and operation system；The index is stored in correspondence
Index pond in；The index is exported to corresponding operation system by second interface, the second interface is the centre
Unified interface between layer and the operation system.
The data warehouse INDEX MANAGEMENT method that the application first aspect embodiment proposes, by the way that middle layer, middle layer is arranged
There are unified interface, middle layer and operation system, there is also the indexs that unified interface, Data Mart generate with Data Mart
It is stored in the index pond of middle layer, the unified management to index may be implemented, due to middle layer and each Data Mart and each industry
Business system is there are unified interface, problem that can be inconsistent to avoid bore, also, since unified management can be to avoid repeating open
Problem of management is sent out and is difficult to, to solve the problems, such as that carrying out INDEX MANAGEMENT with table level exists.
In order to achieve the above objectives, the data warehouse INDEX MANAGEMENT device that the application second aspect embodiment proposes, comprising: connect
Module is received, the index that fairground is exported by first interface for receiving data, the first interface is Data Mart and middle layer
Between unified interface, the middle layer is the preset interface layer between Data Mart and operation system；Preserving module,
For the index to be stored in corresponding index pond；Sending module, for by second interface by the index export to
Corresponding operation system, the second interface are the unified interfaces between the middle layer and the operation system.
The data warehouse INDEX MANAGEMENT device that the application second aspect embodiment proposes, by the way that middle layer, middle layer is arranged
There are unified interface, middle layer and operation system, there is also the indexs that unified interface, Data Mart generate with Data Mart
It is stored in the index pond of middle layer, the unified management to index may be implemented, due to middle layer and each Data Mart and each industry
Business system is there are unified interface, problem that can be inconsistent to avoid bore, also, since unified management can be to avoid repeating open
Problem of management is sent out and is difficult to, to solve the problems, such as that carrying out INDEX MANAGEMENT with table level exists.
In order to achieve the above objectives, the data warehouse that the application third aspect embodiment proposes, comprising: second aspect institute
The device stated, and, Data Mart and operation system；Described device between the Data Mart and the operation system,
For being managed collectively to index.
The data warehouse that the application third aspect embodiment proposes, by the way that middle layer, middle layer and data set is arranged
There are unified interface, middle layer and operation systems in city there is also unified interface, during the index that Data Mart generates is stored in
In the index pond of interbed, the unified management to index may be implemented, since middle layer and each Data Mart and each operation system are deposited
In unified interface, problem that can be inconsistent to avoid bore, also, since unified management can be to avoid overlapping development and difficulty
With problem of management, to solve the problems, such as that carrying out INDEX MANAGEMENT with table level exists.
The additional aspect of the application and advantage will be set forth in part in the description, and will partially become from the following description
It obtains obviously, or recognized by the practice of the application.
Detailed description of the invention
The application is above-mentioned and/or additional aspect and advantage will become from the following description of the accompanying drawings of embodiments
Obviously and it is readily appreciated that, in which:
Fig. 1 is the flow diagram for the data warehouse INDEX MANAGEMENT method that one embodiment of the application proposes；
Fig. 2 is the flow diagram for the data warehouse INDEX MANAGEMENT method that another embodiment of the application proposes；
Fig. 3 is the corresponding system structure diagram of Fig. 2；
Fig. 4 is the structural schematic diagram for the data warehouse INDEX MANAGEMENT device that another embodiment of the application proposes；
Fig. 5 is the structural schematic diagram for the data warehouse INDEX MANAGEMENT device that another embodiment of the application proposes；
Fig. 6 is the structural schematic diagram for the data warehouse that another embodiment of the application proposes.
Specific embodiment
Embodiments herein is described below in detail, examples of the embodiments are shown in the accompanying drawings, wherein from beginning to end
Same or similar label indicates same or similar element or element with the same or similar functions.Below with reference to attached
The embodiment of figure description is exemplary, and is only used for explaining the application, and should not be understood as the limitation to the application.On the contrary, this
The embodiment of application includes all changes fallen within the scope of the spiritual and intension of attached claims, modification and is equal
Object.
Fig. 1 is the flow diagram for the data warehouse INDEX MANAGEMENT method that one embodiment of the application proposes, this method comprises:
S11: the index that Data Mart is exported by first interface is received, the first interface is Data Mart and middle layer
Between unified interface, the middle layer is the preset interface layer between Data Mart and operation system.
Wherein, the present embodiment can create a middle layer between existing Data Mart and operation system, among this
Layer be managed collectively to the index that each Data Mart externally exports or be safeguarded to be unified.
Interface between middle layer and Data Mart is properly termed as first interface, and the index of different Data Mart output is all
It is exported by the unified first interface to middle layer.
S12: the index is stored in corresponding index pond.
Wherein, index pond can be set in middle layer, index pond includes public index pond and operational indicator pond, public index
Pond (publice) is one, and the number of type of service for including in the number and operation system in operational indicator pond is identical, and mutually
It is corresponding, for example, including reporting system and risk system in operation system, then the operational indicator pond being arranged in the intermediate layer includes
Report form index pond and risk indicator pond.
The middle layer includes index pond, and the index pond includes public index pond and operational indicator pond, the public finger
Marking pond is one, and the number in the operational indicator pond is identical as the number for the class of service that the operation system includes.
Index of the same name is not present in the same operational indicator pond, includes in different business index pond or does not include finger of the same name
Index of the same name is not present in mark, public index pond and each operational indicator pond.
Index needed for corresponding service can be generated in different data fairground, for example, reporting system can be generated in report fairground
Required index, index needed for risk system can be generated in risk fairground.
After Data Mart generates index, index can be saved in the index pond of corresponding business, for example, report fairground
The index of generation is stored in report form index pond, and the index that risk fairground generates is stored in risk indicator pond.
S13: the index is exported to corresponding operation system by second interface, the second interface is the centre
Unified interface between layer and the operation system.
Wherein, the index in different index ponds can be exported by unified second interface to corresponding operation system, example
Such as, reporting system can obtain index by second interface from report form index pond, risk system can by second interface from
Risk indicator obtains index in pond.
In addition, different business systems can also obtain index from public index pond, for example, reporting system can be from public
Index is obtained in index pond, risk system can also obtain index from public index pond.
The present embodiment is by setting middle layer, and there are unified interface, middle layer and business systems for middle layer and Data Mart
There is also unified interface, the index that Data Mart generates is stored in the index pond of middle layer, may be implemented to index system
Unified management can be inconsistent to avoid bore since there are unified interfaces for middle layer and each Data Mart and each operation system
The problem of, also, since unified management to avoid overlapping development and can be difficult to problem of management, to solve to be referred to table level
Mark management there are the problem of.
Fig. 2 is the flow diagram for the data warehouse INDEX MANAGEMENT method that another embodiment of the application proposes, Fig. 3 is Fig. 2
Corresponding system structure diagram.
Referring to Fig. 3, the system of the present embodiment includes Data Mart 31, middle layer 32 and operation system 33.Data Mart 31
It may include risk fairground, credit fairground, operation fairground etc..Middle layer 32 is properly termed as DW index interface layer, and middle layer 32 is wrapped
Public index pond, report form index pond, risk indicator pond etc. are included, further includes converter, derivatization device, screening washer and tracker.Business
System 33 includes reporting system and risk system etc..
Referring to fig. 2, this method comprises:
S21: Data Mart handles data source, obtains corresponding index.
For example, risk fairground handles data source, this index of loan balance is obtained.
S22: Data Mart is exported index to middle layer by first interface.
Wherein, first interface can be realized using java or .net.
Different data fairground can export respective index by unified first interface to middle layer.
S23: the converter in middle layer is reconstructed received index according to the preset format in the index pond, will
Index after reconstruct is stored in corresponding index pond.
Wherein, Data Mart can be exported in output-index using table mode, for example, risk fairground generates one
Table includes multiple indexs in the table, and later, risk fairground can export the table to middle layer.
Referring to Fig. 3, middle layer is provided that index pond, each index pond include following index: index encodes (code), pond
It encodes (code), index English name, index Chinese name, dimension, computation rule, data warehouse source table, status attribute, founder,
Modify people.
Since the format in the index pond of middle layer setting is different from the tableau format that Data Mart exports, conversion
Device can be reconstructed received table, to be suitble to the format in index pond.
After converter converts received index, index can be stored in corresponding index pond, for example, will
The index of risk fairground output is stored in risk indicator pond.
In order to guarantee that bore is unified and avoids overlapping development, each index pond be can satisfy: in the same operational indicator pond not
Comprising index of the same name, different business index pond may include index of the same name, in any operational indicator pond index not with public index
Index is of the same name in pond.
Index pond is a kind of structure design, can use oracle, the traditional databases such as mysql or distributed data base
It realizes.
S24: the derivatization device in middle layer derives new index according to existing index in the index pond.
For example, existing index includes day loan balance in index pond, then derivatization device can spread out according to day loan balance
Bear a moon loan balance.
In addition, the index derived can be stored in index pond belonging to the index of source, for example, day loan balance is located at fortune
Seek in index pond, then according to day loan balance it is derivative obtain the moon loan balance there may also be in operation indicator pond.
S25: after the screening washer in middle layer is recombinated the index in index pond according to the format of operation system demand,
It exports to corresponding operation system.
For example, risk system needs loan balance index and overdue index, then screening washer can take from risk indicator pond
Loan balance index and overdue index out, and export after being recombinated according to the format that risk system needs to risk system.
Wherein, the index in public index pond and corresponding operational indicator pond can be used in operation system, for example, report system
The index in public index pond and report form index pond can be used in system, and public index pond and risk indicator can be used in risk system
Index in pond.
S26: tracker in middle layer to generation, use and the alteration of the index in the index pond carry out with
Track.
For example, middle layer is after receiving a new index and being saved in index pond in Data Mart, tracker can be remembered
The new index is recorded, alternatively, after derivatization device derives new index according to existing index, it is new that tracker also can recorde this
Index.Alternatively,
After operation system uses an index, tracker also can recorde the index used.Alternatively,
When the index in operational indicator pond is placed into public index Chi Zhonghou, tracker also can recorde the change, for example,
When risk personnel have found that some index has existed inside operation indicator pond, and the one of demand bore and operation indicator pond
It causes, then can apply the index in operation indicator pond moving to public index pond.
In addition, tracker can also carry out, the online monitoring of index, life cycle management, index deactivate lower wire management control on line
System etc., specifically, temperature can be used according to the frequency monitoring index that index metadata is used；It can be supervised by index view
Achievement data is controlled to occupy memory space, calculate the realization health degree monitoring of the data such as space；It can be controlled by index metadata interface
The online access of index processed and offline deactivated control.
The present embodiment substitutes traditional table level INDEX MANAGEMENT by setting middle layer and index pond, the management of service index pond,
It, can be to avoid between each Data Mart or in same Data Mart between different tables due to there are unified INDEX MANAGEMENT platform
Bore disunity problem realizes that the interface bore of index transmission is consistent；It, can be to avoid since index is uniformly stored in index pond
Overlapping development caused by each Data Mart is developed respectively and problem of resource waste；By the way that the centre being managed collectively to index is arranged
Layer, can be managed collectively and be tracked to index life cycle, business side's visual system is allowed to check indication information.
Fig. 4 is the structural schematic diagram for the data warehouse INDEX MANAGEMENT device that another embodiment of the application proposes, the device 40
Including receiving module 41, preserving module 42 and sending module 43.
The index that fairground is exported by first interface for receiving data of receiving module 41, the first interface are data sets
Unified interface between city and middle layer, the middle layer are the preset interfaces between Data Mart and operation system
Layer；
Wherein, the present embodiment can create a middle layer between existing Data Mart and operation system, among this
Layer be managed collectively to the index that each Data Mart externally exports or be safeguarded to be unified.
Interface between middle layer and Data Mart is properly termed as first interface, and the index of different Data Mart output is all
It is exported by the unified first interface to middle layer.
Preserving module 42 is for the index to be stored in corresponding index pond；
Wherein, index pond can be set in middle layer, index pond includes public index pond and operational indicator pond, public index
Pond (publice) is one, and the number of type of service for including in the number and operation system in operational indicator pond is identical, and mutually
It is corresponding, for example, including reporting system and risk system in operation system, then the operational indicator pond being arranged in the intermediate layer includes
Report form index pond and risk indicator pond.
The middle layer includes index pond, and the index pond includes public index pond and operational indicator pond, the public finger
Marking pond is one, and the number in the operational indicator pond is identical as the number for the class of service that the operation system includes.
Index of the same name is not present in the same operational indicator pond, includes in different business index pond or does not include finger of the same name
Index of the same name is not present in mark, public index pond and each operational indicator pond.
Index needed for corresponding service can be generated in different data fairground, for example, reporting system can be generated in report fairground
Required index, index needed for risk system can be generated in risk fairground.
After Data Mart generates index, index can be saved in the index pond of corresponding business, for example, report fairground
The index of generation is stored in report form index pond, and the index that risk fairground generates is stored in risk indicator pond.
Sending module 43 is for being exported the index to corresponding operation system, the second interface by second interface
It is the unified interface between the middle layer and the operation system.
Wherein, the index in different index ponds can be exported by unified second interface to corresponding operation system, example
Such as, reporting system can obtain index by second interface from report form index pond, risk system can by second interface from
Risk indicator obtains index in pond.
In addition, different business systems can also obtain index from public index pond, for example, reporting system can be from public
Index is obtained in index pond, risk system can also obtain index from public index pond.
In one embodiment, the middle layer includes index pond, and the index pond includes public index pond and operational indicator
Pond, the public index pond are one, for the class of service that the number and the operation system in the operational indicator pond include
Number is identical.
In one embodiment, index of the same name is not present in the same operational indicator pond, include in different business index pond or
Person does not include index of the same name, and index of the same name is not present in public index pond and each operational indicator pond.
In one embodiment, the index pond includes following index:
Index coding, pond coding, index English name, index Chinese name, dimension, computation rule, data warehouse source table, state
Attribute, founder modify people.
The preserving module can specifically correspond to the index pond of above method embodiment.
Referring to Fig. 5, the device 40 further include: converter 44, for the preset format according to the index pond, to the finger
Mark is reconstructed, so that the index after reconstruct to be stored in corresponding index pond.
Wherein, Data Mart can be exported in output-index using table mode, for example, risk fairground generates one
Table includes multiple indexs in the table, and later, risk fairground can export the table to middle layer.
Referring to Fig. 3, middle layer is provided that index pond, each index pond include following index: index encodes (code), pond
It encodes (code), index English name, index Chinese name, dimension, computation rule, data warehouse source table, status attribute, founder,
Modify people.
Since the format in the index pond of middle layer setting is different from the tableau format that Data Mart exports, conversion
Device can be reconstructed received table, to be suitble to the format in index pond.
After converter converts received index, index can be stored in corresponding index pond, for example, will
The index of risk fairground output is stored in risk indicator pond.
In order to guarantee that bore is unified and avoids overlapping development, each index pond be can satisfy: in the same operational indicator pond not
Comprising index of the same name, different business index pond may include index of the same name, in any operational indicator pond index not with public index
Index is of the same name in pond.
Index pond is a kind of structure design, can use oracle, the traditional databases such as mysql or distributed data base
It realizes.
Referring to Fig. 5, the device 40 further include: screening washer 45, for by the index according to the operation system demand
After format is recombinated, export to corresponding operation system.
For example, risk system needs loan balance index and overdue index, then screening washer can take from risk indicator pond
Loan balance index and overdue index out, and export after being recombinated according to the format that risk system needs to risk system.
Wherein, the index in public index pond and corresponding operational indicator pond can be used in operation system, for example, report system
The index in public index pond and report form index pond can be used in system, and public index pond and risk indicator can be used in risk system
Index in pond.
Referring to Fig. 5, the device 40 further include: derivatization device 46, for being derived according to existing index in the index pond
New index.
For example, existing index includes day loan balance in index pond, then derivatization device can spread out according to day loan balance
Bear a moon loan balance.
In addition, the index derived can be stored in index pond belonging to the index of source, for example, day loan balance is located at fortune
Seek in index pond, then according to day loan balance it is derivative obtain the moon loan balance there may also be in operation indicator pond.
Referring to Fig. 5, the device 40 further include: tracker 47, for the index in the index pond generation, using and
Alteration is tracked.
For example, middle layer is after receiving a new index and being saved in index pond in Data Mart, tracker can be remembered
The new index is recorded, alternatively, after derivatization device derives new index according to existing index, it is new that tracker also can recorde this
Index.Alternatively,
After operation system uses an index, tracker also can recorde the index used.Alternatively,
When the index in operational indicator pond is placed into public index Chi Zhonghou, tracker also can recorde the change, for example,
When risk personnel have found that some index has existed inside operation indicator pond, and the one of demand bore and operation indicator pond
It causes, then can apply the index in operation indicator pond moving to public index pond.
In addition, tracker can also carry out, the online monitoring of index, life cycle management, index deactivate lower wire management control on line
System etc., specifically, temperature can be used according to the frequency monitoring index that index metadata is used；It can be supervised by index view
Achievement data is controlled to occupy memory space, calculate the realization health degree monitoring of the data such as space；It can be controlled by index metadata interface
The online access of index processed and offline deactivated control.
The present embodiment substitutes traditional table level INDEX MANAGEMENT by setting middle layer and index pond, the management of service index pond,
It, can be to avoid between each Data Mart or in same Data Mart between different tables due to there are unified INDEX MANAGEMENT platform
Bore disunity problem realizes that the interface bore of index transmission is consistent；It, can be to avoid since index is uniformly stored in index pond
Overlapping development caused by each Data Mart is developed respectively and problem of resource waste；By the way that the centre being managed collectively to index is arranged
Layer, can be managed collectively and be tracked to index life cycle, business side's visual system is allowed to check indication information.
Fig. 6 is the structural schematic diagram for the data warehouse that another embodiment of the application proposes, which includes data
Fairground 61, middle layer 62 and operation system 63, middle layer 62 is between Data Mart 61 and operation system 63, for index
It is managed collectively.The concrete composition of middle layer 62 may refer to Fig. 4 or embodiment illustrated in fig. 5.
The present embodiment is by setting middle layer, and there are unified interface, middle layer and business systems for middle layer and Data Mart
There is also unified interface, the index that Data Mart generates is stored in the index pond of middle layer, may be implemented to index system
Unified management can be inconsistent to avoid bore since there are unified interfaces for middle layer and each Data Mart and each operation system
The problem of, also, since unified management to avoid overlapping development and can be difficult to problem of management, to solve to be referred to table level
Mark management there are the problem of.
It should be noted that term " first ", " second " etc. are used for description purposes only in the description of the present application, without
It can be interpreted as indication or suggestion relative importance.In addition, in the description of the present application, unless otherwise indicated, the meaning of " multiple "
It is two or more.
Any process described otherwise above or method description are construed as in flow chart or herein, and expression includes
It is one or more for realizing specific logical function or process the step of executable instruction code module, segment or portion
Point, and the range of the preferred embodiment of the application includes other realization, wherein can not press shown or discussed suitable
Sequence, including according to related function by it is basic simultaneously in the way of or in the opposite order, Lai Zhihang function, this should be by the application
Embodiment person of ordinary skill in the field understood.
It should be appreciated that each section of the application can be realized with hardware, software, firmware or their combination.Above-mentioned
In embodiment, software that multiple steps or method can be executed in memory and by suitable instruction execution system with storage
Or firmware is realized.It, and in another embodiment, can be under well known in the art for example, if realized with hardware
Any one of column technology or their combination are realized: having a logic gates for realizing logic function to data-signal
Discrete logic, with suitable combinational logic gate circuit specific integrated circuit, programmable gate array (PGA), scene
Programmable gate array (FPGA) etc..
Those skilled in the art are understood that realize all or part of step that above-described embodiment method carries
It suddenly is that relevant hardware can be instructed to complete by program, the program can store in a kind of computer-readable storage medium
In matter, which when being executed, includes the steps that one or a combination set of embodiment of the method.
It, can also be in addition, can integrate in a processing module in each functional unit in each embodiment of the application
It is that each unit physically exists alone, can also be integrated in two or more units in a module.Above-mentioned integrated mould
Block both can take the form of hardware realization, can also be realized in the form of software function module.The integrated module is such as
Fruit is realized and when sold or used as an independent product in the form of software function module, also can store in a computer
In read/write memory medium.
Storage medium mentioned above can be read-only memory, disk or CD etc..
In the description of this specification, reference term " one embodiment ", " some embodiments ", " example ", " specifically show
The description of example " or " some examples " etc. means specific features, structure, material or spy described in conjunction with this embodiment or example
Point is contained at least one embodiment or example of the application.In the present specification, schematic expression of the above terms are not
Centainly refer to identical embodiment or example.Moreover, particular features, structures, materials, or characteristics described can be any
One or more embodiment or examples in can be combined in any suitable manner.
Although embodiments herein has been shown and described above, it is to be understood that above-described embodiment is example
Property, it should not be understood as the limitation to the application, those skilled in the art within the scope of application can be to above-mentioned
Embodiment is changed, modifies, replacement and variant.
Claims (13)
1. a kind of data warehouse INDEX MANAGEMENT method characterized by comprising
The index that Data Mart is exported by first interface is received, the first interface is the system between Data Mart and middle layer
One interface, the middle layer are the preset interface layers between Data Mart and operation system；
The index is stored in corresponding index pond；
The index is exported to corresponding operation system by second interface, the second interface be the middle layer with it is described
Unified interface between operation system；
Wherein, the middle layer includes index pond, and the index pond includes public index pond and operational indicator pond, the public finger
Marking pond is one, and the number in the operational indicator pond is identical as the number for the class of service that the operation system includes；
Wherein, index of the same name is not present in the same operational indicator pond, includes in different business index pond or does not include of the same name
Index of the same name is not present in index, public index pond and each operational indicator pond.
2. the method according to claim 1, wherein the index pond includes following index:
Index coding, pond coding, index English name, index Chinese name, dimension, computation rule, data warehouse source table, state category
Property, founder modifies people.
3. the method according to claim 1, wherein described be stored in the index in corresponding index pond,
Include:
According to the preset format in the index pond, the index is reconstructed, the index after reconstruct is stored in corresponding finger
It marks in pond.
4. method according to any one of claims 1 to 3, which is characterized in that described to export the index to corresponding
Operation system, comprising:
After the index is recombinated according to the format of the operation system demand, export to corresponding operation system.
5. method according to any one of claims 1 to 3, which is characterized in that further include:
New index is derived according to existing index in the index pond.
6. method according to any one of claims 1 to 3, which is characterized in that further include:
Generation, use and the alteration of index in the index pond are tracked.
7. a kind of data warehouse INDEX MANAGEMENT device characterized by comprising
Receiving module, the index that fairground is exported by first interface for receiving data, the first interface be Data Mart with
Unified interface between middle layer, the middle layer are the preset interface layers between Data Mart and operation system；
Preserving module, for the index to be stored in corresponding index pond；
Sending module, for being exported the index to corresponding operation system by second interface, the second interface is institute
State the unified interface between middle layer and the operation system；
Wherein, the middle layer includes index pond, and the index pond includes public index pond and operational indicator pond, the public finger
Marking pond is one, and the number in the operational indicator pond is identical as the number for the class of service that the operation system includes；
Wherein, index of the same name is not present in the same operational indicator pond, includes in different business index pond or does not include of the same name
Index of the same name is not present in index, public index pond and each operational indicator pond.
8. device according to claim 7, which is characterized in that the index pond includes following index:
Index coding, pond coding, index English name, index Chinese name, dimension, computation rule, data warehouse source table, state category
Property, founder modifies people.
9. device according to claim 7, which is characterized in that further include:
Converter is reconstructed the index for the preset format according to the index pond, so as to the index after reconstructing
It is stored in corresponding index pond.
10. according to the described in any item devices of claim 7 to 8, which is characterized in that further include:
Screening washer exports after being recombinated the index according to the format of the operation system demand to corresponding industry
Business system.
11. according to the described in any item devices of claim 7 to 8, which is characterized in that further include:
Derivatization device, for deriving new index according to existing index in the index pond.
12. according to the described in any item devices of claim 7 to 8, which is characterized in that further include:
Tracker is tracked for generation, use and the alteration to the index in the index pond.
13. a kind of data warehouse characterized by comprising
Such as the described in any item devices of claim 7 to 12, and, Data Mart and operation system；
Described device is between the Data Mart and the operation system, for being managed collectively to index.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410351744.8A CN105335401B (en) | 2014-07-22 | 2014-07-22 | Data warehouse INDEX MANAGEMENT method and apparatus and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410351744.8A CN105335401B (en) | 2014-07-22 | 2014-07-22 | Data warehouse INDEX MANAGEMENT method and apparatus and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105335401A CN105335401A (en) | 2016-02-17 |
| CN105335401B true CN105335401B (en) | 2019-02-26 |
Family
ID=55285938
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410351744.8A Active CN105335401B (en) | 2014-07-22 | 2014-07-22 | Data warehouse INDEX MANAGEMENT method and apparatus and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105335401B (en) |
Families Citing this family (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105809358A (en) * | 2016-03-16 | 2016-07-27 | 浪潮通信信息系统有限公司 | Network management performance statement report requirement support modeling method based on data driving |
| CN107346321A (en) * | 2016-05-06 | 2017-11-14 | 阿里巴巴集团控股有限公司 | Data warehouse management method and device |
| CN107679096B (en) * | 2017-09-08 | 2020-06-05 | 北京京东尚科信息技术有限公司 | Method and device for sharing indexes among data marts |
| CN110941601B (en) * | 2019-11-12 | 2023-05-30 | 北京三快在线科技有限公司 | Method and device for determining standard caliber of index, electronic equipment and storage medium |
| CN111400356B (en) * | 2020-06-04 | 2020-11-10 | 浙江口碑网络技术有限公司 | Data query method, device and equipment |
| CN112465364B (en) * | 2020-12-03 | 2024-03-19 | 合肥天源迪科信息技术有限公司 | Management system for index library |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102497435A (en) * | 2011-12-16 | 2012-06-13 | 海南杰福瑞网络科技有限公司 | Data distributing method and device of data service |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101908163A (en) * | 2009-06-05 | 2010-12-08 | 深圳市脑库计算机系统有限公司 | Expert-supported application system platform used for government affair and business affair decision and establishment method thereof |
| CN101706911A (en) * | 2009-11-23 | 2010-05-12 | 浪潮集团山东通用软件有限公司 | Method for implementing service-oriented index model in business intelligence system |
| CN101986333A (en) * | 2010-12-01 | 2011-03-16 | 福州维胜信息技术有限公司 | Auxiliary decision supporting system of hospital |
-
2014
- 2014-07-22 CN CN201410351744.8A patent/CN105335401B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102497435A (en) * | 2011-12-16 | 2012-06-13 | 海南杰福瑞网络科技有限公司 | Data distributing method and device of data service |
Non-Patent Citations (3)
| Title |
|---|
| "基于数据仓库实现对外部监管的支撑探析";初莹莹;《中国金融电脑》;20121130(第11期);第32-36页 |
| "基于数据仓库的银行个人信贷系统的分析与设计";宋培钟等;《金融理论与实践》;20110131(第1期);第71-74页 |
| "江苏电信数据仓库软件的设计与实现";冯吉;《中国优秀硕士学位论文全文数据库 信息科技辑》;20130615(第6期);第13页 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105335401A (en) | 2016-02-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105335401B (en) | Data warehouse INDEX MANAGEMENT method and apparatus and system | |
| JP7129465B2 (en) | Optimizing User Satisfaction When Training a Cognitive Hierarchical Storage Management System | |
| JP6388655B2 (en) | Generation of multi-column index of relational database by data bit interleaving for selectivity | |
| CN104281533B (en) | A kind of method and device of data storage | |
| Moh'd Ali et al. | Transforming business decision making with internet of things (IoT) and machine learning (ML) | |
| Bates et al. | Systematic maps to support the evidence base in social care | |
| CN107122377A (en) | Automatic Adaptation Data collection and storage assembly | |
| Reis et al. | Fundamentals of Data Engineering | |
| CN109460439A (en) | A kind of data processing method, device, medium and electronic equipment | |
| US20160026708A1 (en) | Selection of data storage settings for an application | |
| CN106557399A (en) | Method and apparatus for the state of storage cluster is presented | |
| CN103257987A (en) | Rule-based distributed log service implementation method | |
| CN109558299A (en) | Business monitoring and the method, apparatus of early warning, equipment and storage medium | |
| US20200265025A1 (en) | Methods and systems for mapping flattened structure to relationship preserving hierarchical structure | |
| CN107341164A (en) | Multi-hard-disk file management system and method thereof | |
| Hamed et al. | T-Recs: Time-aware twitter-based drug recommender system | |
| Lathia | Using idle moments to record your health via mobile applications | |
| Cruz-Martínez et al. | Frameworks, models, and theories used in electronic health research and development to support self-management of cardiovascular diseases through remote monitoring technologies: Protocol for a metaethnography review | |
| Saifee et al. | Do Online Reviews of Physicians Reflect Healthcare Outcomes? | |
| US11094405B2 (en) | Cognitive care plan recommendation system | |
| De Lusignan et al. | The Hayes principles: learning from the national pilot of information technology and core generalisable theory in informatics | |
| CN107301187A (en) | Individualized learning method and apparatus based on the network terminal | |
| CN106407354B (en) | Content-data statistical method, device, electronic equipment, server and system | |
| US20180350254A1 (en) | Multi table of contents and courseware generation | |
| TWI815605B (en) | Automated generation of dialogue flow from documents |
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 | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20201009 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Patentee after: Innovative advanced technology Co.,Ltd. Address before: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Patentee before: Advanced innovation technology Co.,Ltd. Effective date of registration: 20201009 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Patentee after: Advanced innovation technology Co.,Ltd. Address before: A four-storey 847 mailbox in Grand Cayman Capital Building, British Cayman Islands Patentee before: Alibaba Group Holding Ltd. |