Embodiment
Be described below in detail the embodiment of the application, the example of described embodiment is shown in the drawings, and wherein same or similar label represents same or similar element or has element that is identical or similar functions from start to finish.Being exemplary below by the embodiment be described with reference to the drawings, only for explaining the application, and the restriction to the application can not being interpreted as.On the contrary, the embodiment of the application comprise fall into attached claims spirit and intension within the scope of all changes, amendment and equivalent.
Fig. 1 is the schematic flow sheet of the data warehouse INDEX MANAGEMENT method that the application one embodiment proposes, and the method comprises:
S11: receive the index that Data Mart is exported by first interface, described first interface is the unified interface between Data Mart and middle layer, and described middle layer is the default interface layer between Data Mart and operation system.
Wherein, the present embodiment can create a middle layer between existing Data Mart and operation system, and this middle layer is carried out unified management to the index that each Data Mart externally exports or is called unified maintenance.
Interface between middle layer and Data Mart can be called first interface, and the index that different Data Marts exports all exports to middle layer by this unified first interface.
S12: described index is kept in corresponding index pond.
Wherein, can setting target pond in middle layer, index pond comprises public index pond and operational indicator pond, public index pond (publice) is one, the number of the type of service that number and the operation system in operational indicator pond comprise is identical, and mutually corresponding, such as, comprise reporting system and risk system in operation system, then the operational indicator pond arranged in the intermediate layer comprises report form index pond and risk indicator pond.
Described middle layer comprises index pond, and described index pond comprises public index pond and operational indicator pond, and described public index pond is one, and the number in described operational indicator pond is identical with the number of the class of service that described operation system comprises.
There is not index of the same name in same operational indicator pond, comprise or do not comprise index of the same name in different business index pond, there is not index of the same name in public index pond and each operational indicator pond.
Different pieces of information fairground can generate the index needed for corresponding service, and such as, form fairground can index needed for generating report forms system, and risk fairground can generate the index needed for risk system.
After Data Mart generates index, index can be saved in the index pond of corresponding business, such as, the index that form fairground generates is kept in report form index pond, and the index that risk fairground generates is kept in risk indicator pond.
S13: by the second interface, described index is exported to corresponding operation system, described second interface is the unified interface between described middle layer and described operation system.
Wherein, index in different index pond can export to corresponding operation system by the second unified interface, such as, reporting system can obtain index by the second interface from report form index pond, and risk system can obtain index by the second interface from risk indicator pond.
In addition, different business systems can also obtain index from public index pond, and such as, reporting system can obtain index from public index pond, and risk system also can obtain index from public index pond.
The present embodiment is by arranging middle layer, there is unified interface in middle layer and Data Mart, also there is unified interface in middle layer and operation system, the index that Data Mart generates is kept in the index pond in middle layer, the unified management to index can be realized, because middle layer and each Data Mart and each operation system exist unified interface, the problem that bore is inconsistent can be avoided, and, overlapping development can be avoided due to unified management and be difficult to problem of management, thus solving to show grading row index management Problems existing.
Fig. 2 is the schematic flow sheet of the data warehouse INDEX MANAGEMENT method that another embodiment of the application proposes, and Fig. 3 is the system architecture schematic diagram that Fig. 2 is corresponding.
See Fig. 3, the system of the present embodiment comprises Data Mart 31, middle layer 32 and operation system 33.Data Mart 31 can comprise risk fairground, credit fairground, operation fairground etc.Middle layer 32 can be called DW index interface layer, and middle layer 32 comprises public index pond, report form index pond, risk indicator pond etc., also comprises converter, derivatization device, screening washer and tracker.Operation system 33 comprises reporting system and risk system etc.
See Fig. 2, the method comprises:
S21: Data Mart processes data source, obtains corresponding index.
Such as, risk fairground processes data source, obtains this index of loan balance.
S22: index is exported to middle layer by first interface by Data Mart.
Wherein, first interface can adopt java or .net to realize.
Respective index all can be exported to middle layer by unified first interface by different pieces of information fairground.
S23: the converter in middle layer, according to the preset format in described index pond, is reconstructed the index received, and the index after reconstruct is kept in corresponding index pond.
Wherein, Data Mart can adopt table mode to export when output-index, and such as, risk fairground generates a table, and this table comprises multiple index, and afterwards, this table can be exported to middle layer by risk fairground.
See Fig. 3, what middle layer was arranged is index pond, and each index pond comprises following index: index coding (code), pond coding (code), index English name, index Chinese name, dimension, computation rule, data warehouse source is shown, status attribute, founder, amendment people.
Because the form in the index pond that middle layer is arranged is different from the tableau format that Data Mart exports, therefore, converter can be reconstructed the table received, with the form in applicable index pond.
After converter is changed the index received, index can be kept in corresponding index pond, such as, the index that risk fairground exports be kept in risk indicator pond.
In order to ensure that bore is unified and avoid overlapping development, each index pond can meet: do not comprise index of the same name in same operational indicator pond, and different business index pond can comprise index of the same name, and in any operational indicator pond, index is not of the same name with index in public index pond.
Index pond is a kind of structural design, can adopt oracle, and the traditional databases such as mysql or distributed data base realize.
S24: the derivatization device in middle layer derives according to existing index in described index pond the index made new advances.
Such as, in index pond, existing index comprises a day loan balance, and so derivatization device can derive a moon loan balance according to day loan balance.
In addition, the index derived can be kept in the index pond belonging to the index of source, such as, day loan balance be arranged in operation indicator pond, so derive according to day loan balance the moon loan balance obtained and also can exist in operation indicator pond.
S25: after the index in index pond is recombinated according to the form of operation system demand by the screening washer in middle layer, exports to corresponding operation system.
Such as, risk system needs loan balance index and index of exceeding the time limit, then screening washer can take out loan balance index and index of exceeding the time limit from risk indicator pond, and exports to risk system after recombinating according to the form that risk system needs.
Wherein, operation system can use the index in public index pond and corresponding operational indicator pond, and such as, reporting system can use the index in public index pond and report form index pond, and risk system can use the index in public index pond and risk indicator pond.
S26: the tracker in middle layer is followed the tracks of the generation of the index in described index pond, use and alteration.
Such as, middle layer from Data Mart, receive a new index and after being saved in index pond, tracker can record this new index, or derivatization device derives the index made new advances according to existing index after, tracker also can record this new index.Or,
After operation system uses an index, tracker also can record the index of this use.Or,
When the index in operational indicator pond is placed into after in public index pond, tracker also can record this change, such as, when risk personnel find that certain index exists inside operation indicator pond, and demand bore is consistent with operation indicator pond, this index in operation indicator pond so can be applied for move to public index pond.
In addition, tracker can also carry out reach the standard grade life cycle management on monitoring, line, index of index and to stop using lower wire management control etc., concrete, can be used temperature according to index metadata by the frequency monitoring index used; The data such as storage space, computer memory can be taken by index view monitor control index data and realize health degree monitoring; Can by reach the standard grade access and the control of stopping using of rolling off the production line of index metadata interface control index.
The present embodiment is by arranging middle layer and index pond, the management of service index pond substitutes traditional table level INDEX MANAGEMENT, owing to there is unified INDEX MANAGEMENT platform, can avoid between each Data Mart or bore disunity problem in same Data Mart between different table, the interface bore realizing index transmission is consistent; Be kept in index pond because index is unified, the overlapping development and problem of resource waste that each Data Mart can be avoided to develop respectively cause; By arranging the middle layer to index unified management, unified management and tracking can be carried out to index life cycle, making business side can check indication information by visual system.
Fig. 4 is the structural representation of the data warehouse INDEX MANAGEMENT device that another embodiment of the application proposes, and this device 40 comprises receiver module 41, preserves module 42 and sending module 43.
The index that receiver module 41 is exported by first interface for receiving Data Mart, described first interface is the unified interface between Data Mart and middle layer, and described middle layer is the default interface layer between Data Mart and operation system;
Wherein, the present embodiment can create a middle layer between existing Data Mart and operation system, and this middle layer is carried out unified management to the index that each Data Mart externally exports or is called unified maintenance.
Interface between middle layer and Data Mart can be called first interface, and the index that different Data Marts exports all exports to middle layer by this unified first interface.
Preserve module 42 for described index being kept in corresponding index pond;
Wherein, can setting target pond in middle layer, index pond comprises public index pond and operational indicator pond, public index pond (publice) is one, the number of the type of service that number and the operation system in operational indicator pond comprise is identical, and mutually corresponding, such as, comprise reporting system and risk system in operation system, then the operational indicator pond arranged in the intermediate layer comprises report form index pond and risk indicator pond.
Described middle layer comprises index pond, and described index pond comprises public index pond and operational indicator pond, and described public index pond is one, and the number in described operational indicator pond is identical with the number of the class of service that described operation system comprises.
There is not index of the same name in same operational indicator pond, comprise or do not comprise index of the same name in different business index pond, there is not index of the same name in public index pond and each operational indicator pond.
Different pieces of information fairground can generate the index needed for corresponding service, and such as, form fairground can index needed for generating report forms system, and risk fairground can generate the index needed for risk system.
After Data Mart generates index, index can be saved in the index pond of corresponding business, such as, the index that form fairground generates is kept in report form index pond, and the index that risk fairground generates is kept in risk indicator pond.
Sending module 43 is for exporting to corresponding operation system by the second interface by described index, and described second interface is the unified interface between described middle layer and described operation system.
Wherein, index in different index pond can export to corresponding operation system by the second unified interface, such as, reporting system can obtain index by the second interface from report form index pond, and risk system can obtain index by the second interface from risk indicator pond.
In addition, different business systems can also obtain index from public index pond, and such as, reporting system can obtain index from public index pond, and risk system also can obtain index from public index pond.
In an embodiment, described middle layer comprises index pond, and described index pond comprises public index pond and operational indicator pond, and described public index pond is one, and the number in described operational indicator pond is identical with the number of the class of service that described operation system comprises.
In an embodiment, there is not index of the same name in same operational indicator pond, comprise or do not comprise index of the same name in different business index pond, there is not index of the same name in public index pond and each operational indicator pond.
In an embodiment, described index pond comprises following index:
Index is encoded, and encode in pond, index English name, index Chinese name, dimension, computation rule, and data warehouse source is shown, status attribute, founder, amendment people.
This preservation module can the index pond of concrete corresponding said method embodiment.
See Fig. 5, this device 40 also comprises: converter 44, for the preset format according to described index pond, is reconstructed described index, the index after reconstruct to be kept in corresponding index pond.
Wherein, Data Mart can adopt table mode to export when output-index, and such as, risk fairground generates a table, and this table comprises multiple index, and afterwards, this table can be exported to middle layer by risk fairground.
See Fig. 3, what middle layer was arranged is index pond, and each index pond comprises following index: index coding (code), pond coding (code), index English name, index Chinese name, dimension, computation rule, data warehouse source is shown, status attribute, founder, amendment people.
Because the form in the index pond that middle layer is arranged is different from the tableau format that Data Mart exports, therefore, converter can be reconstructed the table received, with the form in applicable index pond.
After converter is changed the index received, index can be kept in corresponding index pond, such as, the index that risk fairground exports be kept in risk indicator pond.
In order to ensure that bore is unified and avoid overlapping development, each index pond can meet: do not comprise index of the same name in same operational indicator pond, and different business index pond can comprise index of the same name, and in any operational indicator pond, index is not of the same name with index in public index pond.
Index pond is a kind of structural design, can adopt oracle, and the traditional databases such as mysql or distributed data base realize.
See Fig. 5, this device 40 also comprises: screening washer 45, after described index being recombinated according to the form of described operation system demand, exports to corresponding operation system.
Such as, risk system needs loan balance index and index of exceeding the time limit, then screening washer can take out loan balance index and index of exceeding the time limit from risk indicator pond, and exports to risk system after recombinating according to the form that risk system needs.
Wherein, operation system can use the index in public index pond and corresponding operational indicator pond, and such as, reporting system can use the index in public index pond and report form index pond, and risk system can use the index in public index pond and risk indicator pond.
See Fig. 5, this device 40 also comprises: derivatization device 46, for deriving according to existing index in described index pond the index made new advances.
Such as, in index pond, existing index comprises a day loan balance, and so derivatization device can derive a moon loan balance according to day loan balance.
In addition, the index derived can be kept in the index pond belonging to the index of source, such as, day loan balance be arranged in operation indicator pond, so derive according to day loan balance the moon loan balance obtained and also can exist in operation indicator pond.
See Fig. 5, this device 40 also comprises: tracker 47, follows the tracks of for the generation to the index in described index pond, use and alteration.
Such as, middle layer from Data Mart, receive a new index and after being saved in index pond, tracker can record this new index, or derivatization device derives the index made new advances according to existing index after, tracker also can record this new index.Or,
After operation system uses an index, tracker also can record the index of this use.Or,
When the index in operational indicator pond is placed into after in public index pond, tracker also can record this change, such as, when risk personnel find that certain index exists inside operation indicator pond, and demand bore is consistent with operation indicator pond, this index in operation indicator pond so can be applied for move to public index pond.
In addition, tracker can also carry out reach the standard grade life cycle management on monitoring, line, index of index and to stop using lower wire management control etc., concrete, can be used temperature according to index metadata by the frequency monitoring index used; The data such as storage space, computer memory can be taken by index view monitor control index data and realize health degree monitoring; Can by reach the standard grade access and the control of stopping using of rolling off the production line of index metadata interface control index.
The present embodiment is by arranging middle layer and index pond, the management of service index pond substitutes traditional table level INDEX MANAGEMENT, owing to there is unified INDEX MANAGEMENT platform, can avoid between each Data Mart or bore disunity problem in same Data Mart between different table, the interface bore realizing index transmission is consistent; Be kept in index pond because index is unified, the overlapping development and problem of resource waste that each Data Mart can be avoided to develop respectively cause; By arranging the middle layer to index unified management, unified management and tracking can be carried out to index life cycle, making business side can check indication information by visual system.
Fig. 6 is the structural representation of the data warehouse that another embodiment of the application proposes, this system 60 comprises Data Mart 61, middle layer 62 and operation system 63, middle layer 62 between Data Mart 61 and operation system 63, for carrying out unified management to index.The concrete composition in middle layer 62 can see Fig. 4 or embodiment illustrated in fig. 5.
The present embodiment is by arranging middle layer, there is unified interface in middle layer and Data Mart, also there is unified interface in middle layer and operation system, the index that Data Mart generates is kept in the index pond in middle layer, the unified management to index can be realized, because middle layer and each Data Mart and each operation system exist unified interface, the problem that bore is inconsistent can be avoided, and, overlapping development can be avoided due to unified management and be difficult to problem of management, thus solving to show grading row index management Problems existing.
It should be noted that, in the description of the application, term " first ", " second " etc. only for describing object, and can not be interpreted as instruction or hint relative importance.In addition, in the description of the application, except as otherwise noted, the implication of " multiple " is two or more.
Describe and can be understood in process flow diagram or in this any process otherwise described or method, represent and comprise one or more for realizing the module of the code of the executable instruction of the step of specific logical function or process, fragment or part, and the scope of the preferred implementation of the application comprises other realization, wherein can not according to order that is shown or that discuss, comprise according to involved function by the mode while of basic or by contrary order, carry out n-back test, this should understand by the embodiment person of ordinary skill in the field of the application.
Should be appreciated that each several part of the application can realize with hardware, software, firmware or their combination.In the above-described embodiment, multiple step or method can with to store in memory and the software performed by suitable instruction execution system or firmware realize.Such as, if realized with hardware, the same in another embodiment, can realize by any one in following technology well known in the art or their combination: the discrete logic with the logic gates for realizing logic function to data-signal, there is the special IC of suitable combinational logic gate circuit, programmable gate array (PGA), field programmable gate array (FPGA) etc.
Those skilled in the art are appreciated that realizing all or part of step that above-described embodiment method carries is that the hardware that can carry out instruction relevant by program completes, described program can be stored in a kind of computer-readable recording medium, this program perform time, step comprising embodiment of the method one or a combination set of.
In addition, each functional unit in each embodiment of the application can be integrated in a processing module, also can be that the independent physics of unit exists, also can be integrated in a module by two or more unit.Above-mentioned integrated module both can adopt the form of hardware to realize, and the form of software function module also can be adopted to realize.If described integrated module using the form of software function module realize and as independently production marketing or use time, also can be stored in a computer read/write memory medium.
The above-mentioned storage medium mentioned can be ROM (read-only memory), disk or CD etc.
In the description of this instructions, at least one embodiment that specific features, structure, material or feature that the description of reference term " embodiment ", " some embodiments ", " example ", " concrete example " or " some examples " etc. means to describe in conjunction with this embodiment or example are contained in the application or example.In this manual, identical embodiment or example are not necessarily referred to the schematic representation of above-mentioned term.And the specific features of description, structure, material or feature can combine in an appropriate manner in any one or more embodiment or example.
Although illustrate and described the embodiment of the application above, be understandable that, above-described embodiment is exemplary, can not be interpreted as the restriction to the application, and those of ordinary skill in the art can change above-described embodiment, revises, replace and modification in the scope of the application.