A kind of data model automatic creation system and methodTechnical field
The present invention relates to Computer Applied Technology field, particularly relate to a kind of data model automatic creation system and method.
Background technology
There is substantial amounts of business form in industry, needs when informationization models to set up substantial amounts of business datum table, these tablesThere is the information data of specialty, list structure bulky complex, creating when these business datums being carried out after-treatment operation bigThe business logic codes of amount.
In order to simplify the process logic of business, reduce the impact that business form upgrading brings, opportunity database data structureFundamental system model arise at the historic moment, but prior art exist data model and program realize partly overlapping cause with heavy work loadMultiple problem, significantly increases workload, reduces work efficiency.
Summary of the invention
The technical problem existed based on background technology, the present invention proposes a kind of data model automatic creation system and sideMethod.
A kind of data model automatic creation system that the present invention proposes, including external interface, basic data acquisition module, fortuneCalculate module, tree structure display module, base table definition module, data connection definition module, data base, order module and dataModel management module, the input of described external interface and basic data acquisition module connects, and basic data acquisition moduleOutfan is connected with the input of computing module, the outfan of described computing module respectively with the input of tree structure display moduleEnd and data base connect, and the input of tree structure display module and data base connect, described tree structure display moduleInput is connected with base table definition module and data cube computation definition module respectively, and data base and order module connect, describedBasic data acquisition module, computing module, tree structure display module, base table definition module, data connection definition module, numberAll it is connected with data model management module according to storehouse and order module.
Preferably, described computing module includes intersection operation unit, union operation unit, set difference operation unit or non-fortuneCalculate unit, statistical calculation unit, filtration operation unit, operation result preview unit, preserve tactics unit and combinatorial operation unit,And intersection operation unit, union operation unit, set difference operation unit, NOR-operation unit, statistical calculation unit and filtration operationUnit all inputs with combinatorial operation unit are connected, the outfan of described combinatorial operation unit respectively with operation result preview listThe input of unit and preservation tactics unit connects.
Preferably, the outfan of described basic data acquisition module respectively with intersection operation unit, union operation unit, differenceSet operation unit, NOR-operation unit, statistical calculation unit and filtration operation unit connect, and the outfan of combinatorial operation unitBeing connected with the input of tree structure display module, the outfan of described preservation tactics unit is connected with data base.
Preferably, described data model management module be connected to identity information memory module, authentication module andNumbering module, and identity information memory module is connected with the input of authentication module and the outfan of numbering module respectively,The outfan of described numbering module is connected with data base, and the outfan of authentication module connects the input having matching moduleEnd, described matching module is connected with data base.
The invention allows for a kind of method that data model automatically generates, comprise the following steps:
S1: controlling base table definition module by data model management module and data cube computation definition module runs, base table definesThe base table of tree structure display module is defined by module, the data connection definition module company to tree structure display moduleThe relation of connecing is defined；
S2: control basic data acquisition module by data model management module and computing module runs, basic data acquisition moduleBy basic data transmission to computing module after external interface obtains basic data, the operation result transmission of computing module is to tree-likeConfiguration shows module carries out hierarchical tree-structure displaying, and the operation result transmission of computing module simultaneously stores to data base,With data model management module control order module run, order module by the storage data in data base according to create the time andField is ranked up.
Preferably, in described S2, basic data acquisition module obtains after basic data respectively by basis number from external interfaceAccording to transmission to intersection operation unit, union operation unit, set difference operation unit, NOR-operation unit, statistical calculation unit and mistakeFilter arithmetic element, combinatorial operation unit to intersection operation unit, union operation unit, set difference operation unit, NOR-operation unit,Statistical calculation unit and filtration operation unit are combined, thus basic data carries out computing, and then combinatorial operation unit willOperation result transmission carries out hierarchical tree-structure displaying to tree structure display module, and combinatorial operation unit is by operation result simultaneouslyTransmission stores to data base.
In the present invention, described a kind of data model automatic creation system and method can be from by basic data acquisition moduleBasic data is transmitted to computing module after obtaining basic data by external interface, can be carried out basic data by computing moduleComputing, can carry out hierarchical tree-structure displaying to operation result by tree structure display module, and the present invention solves dataThe problem that the workload that causes of realizing model and program partly overlapping repeats, greatly reduces workload, improves work effectRate, method is simple, easy to use, low cost.
Detailed description of the invention
Below in conjunction with specific embodiment, the present invention is explained orally further.
Embodiment
With reference to Fig. 1, the present embodiment proposes a kind of data model automatic creation system, including external interface, basic dataAcquisition module, computing module, tree structure display module, base table definition module, data connection definition module, data base, rowSequence module and data model management module, the input of external interface and basic data acquisition module connects, and basic data obtainsThe outfan of delivery block is connected with the input of computing module, the outfan of computing module respectively with tree structure display moduleInput and data base connect, and the input of tree structure display module and data base connect, tree structure display moduleInput is connected with base table definition module and data cube computation definition module respectively, and data base and order module connect, basisData acquisition module, computing module, tree structure display module, base table definition module, data connection definition module, data baseAll being connected with data model management module with order module, a kind of data model automatic creation system and method pass through basic dataBasic data can be transmitted to computing module after external interface obtains basic data by acquisition module, can by computing moduleBasic data is carried out computing, operation result can be carried out hierarchical tree-structure displaying by tree structure display module, thisInvention solves data model and program and realizes partly overlapping the problem that the workload caused repeats, and greatly reduces workAmount, improves work efficiency, and method is simple, easy to use, low cost.
In the present embodiment, computing module includes intersection operation unit, union operation unit, set difference operation unit or non-fortuneCalculate unit, statistical calculation unit, filtration operation unit, operation result preview unit, preserve tactics unit and combinatorial operation unit,And intersection operation unit, union operation unit, set difference operation unit, NOR-operation unit, statistical calculation unit and filtration operationUnit all inputs with combinatorial operation unit are connected, the outfan of combinatorial operation unit respectively with operation result preview unit andPreserve tactics unit input connect, the outfan of basic data acquisition module respectively with intersection operation unit, union operationUnit, set difference operation unit, NOR-operation unit, statistical calculation unit and filtration operation unit connect, and combinatorial operation unitOutfan be connected with the input of tree structure display module, preserve tactics unit outfan be connected with data base, dataModel management module is connected to identity information memory module, authentication module and numbering module, and identity information storageModule is connected with the input of authentication module and the outfan of numbering module respectively, the outfan of numbering module and data baseConnecting, and the outfan of authentication module connects the input having matching module, matching module is connected with data base, a kind of numberCan be by base after external interface obtains basic data by basic data acquisition module according to auto-building model system and methodPlinth data are transmitted to computing module, basic data can be carried out computing by computing module, by tree structure display moduleOperation result can be carried out hierarchical tree-structure displaying, the present invention solves data model and realizes partly overlapping causing with programThe problem that repeats of workload, greatly reduce workload, improve work efficiency, method is simple, easy to use, costLow.
The present embodiment also proposed a kind of method that data model automatically generates, and comprises the following steps:
S1: controlling base table definition module by data model management module and data cube computation definition module runs, base table definesThe base table of tree structure display module is defined by module, the data connection definition module company to tree structure display moduleThe relation of connecing is defined；
S2: control basic data acquisition module by data model management module and computing module runs, basic data acquisition moduleBy basic data transmission to computing module after external interface obtains basic data, the operation result transmission of computing module is to tree-likeConfiguration shows module carries out hierarchical tree-structure displaying, and the operation result transmission of computing module simultaneously stores to data base,With data model management module control order module run, order module by the storage data in data base according to create the time andField is ranked up.
In the present embodiment, in S2, basic data acquisition module obtains after basic data respectively by basis number from external interfaceAccording to transmission to intersection operation unit, union operation unit, set difference operation unit, NOR-operation unit, statistical calculation unit and mistakeFilter arithmetic element, combinatorial operation unit to intersection operation unit, union operation unit, set difference operation unit, NOR-operation unit,Statistical calculation unit and filtration operation unit are combined, thus basic data carries out computing, and then combinatorial operation unit willOperation result transmission carries out hierarchical tree-structure displaying to tree structure display module, and combinatorial operation unit is by operation result simultaneouslyTransmitting to data base and store, a kind of data model automatic creation system and method can be from by basic data acquisition moduleBasic data is transmitted to computing module after obtaining basic data by external interface, can be carried out basic data by computing moduleComputing, can carry out hierarchical tree-structure displaying to operation result by tree structure display module, and the present invention solves dataThe problem that the workload that causes of realizing model and program partly overlapping repeats, greatly reduces workload, improves work effectRate, method is simple, easy to use, low cost.
The above, the only present invention preferably detailed description of the invention, but protection scope of the present invention is not limited thereto,Any those familiar with the art in the technical scope that the invention discloses, according to technical scheme andInventive concept equivalent or change in addition, all should contain within protection scope of the present invention.