CN108255479B - Creation method, device, storage medium and the terminal of cube file - Google Patents
Creation method, device, storage medium and the terminal of cube file Download PDFInfo
- Publication number
- CN108255479B CN108255479B CN201711291900.6A CN201711291900A CN108255479B CN 108255479 B CN108255479 B CN 108255479B CN 201711291900 A CN201711291900 A CN 201711291900A CN 108255479 B CN108255479 B CN 108255479B
- Authority
- CN
- China
- Prior art keywords
- file
- cube
- key message
- target xml
- created
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/33—Intelligent editors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0481—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Health & Medical Sciences (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (AREA)
- Human Computer Interaction (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention is suitable for field of communication technology, provide creation method, device, storage medium and the terminal of a kind of cube file, the described method includes: when obtaining creation instruction, the file index that cube file to be created is obtained according to the creation instruction, according to the typing window of key message formula bar of the file index output comprising the cube file；The corresponding field value of the key message of founder's input is obtained by the typing window；Preservation instruction based on key message is associated with and stores the key message and its corresponding field value；The key message and its corresponding field value are loaded into target XML file, cube file is generated；The present invention realizes the automation creation of cube file, simplifies the operation of founder, solves the problems, such as that the prior art expends time, low efficiency when creating cube file.
Description
Technical field
The invention belongs to field of communication technology more particularly to a kind of creation method of cube file, device, storage medium and
Terminal.
Background technique
Pentaho is current most popular open source business intelligence software, is using workflow as core, emphasizes towards solution party
Case rather than the BI external member of tool assembly, have gathered a large amount of machine learning algorithms that can undertake data mining task, including to data
It pre-processed, classified, being returned, being clustered, Association Rule Analysis, and the visualized data on interactive interface.It is therein
Cube file, i.e. data cube, cube file are a kind of multi-dimensional matrixes, can will be more from database or file
Dimension metadata is encapsulated, and is facilitated user and is explored and analyze data set from multiple angles.When creating cube file, existing skill
Art is developed using the schema-workbench component in Pentaho component, needs first to connect database, creation
Then Schema file creates cube file, comprising:
1, new cube file, name are added；
2, true table, name are added；
3, a dimension is added, dimension addition dimension table data is unfolded, modifies title, the setting dimension of dimension hierarchy attribute
The major key of degree table is used to connect with true watch chain, the title that user is shown using the hierarchy attributes when cube file is arranged；
4, the correlation attribute information of dimension is set, including the title seen to user, the title seen to programmer, with true table
The field of link；
5, level is added, the correlation attribute information of level is set, such as the title seen to user, the name seen to programmer
Claim, selection needs the dimensional attribute showed in dimension table；
6, addition measurement, is arranged the correlation attribute information of measurement, for example, check to user title, check to programmer
Title, measurement polymerization methods etc..
So far, cube document creation finishes, and save control is selected to save the cube file, and each step is all linked with one another,
Operating process is cumbersome, expends the time, and low efficiency, the business personnel for being unfamiliar with schema-workbench component cannot be independently completed
The creation of cube file.
Summary of the invention
The embodiment of the invention provides creation method, device, storage medium and the terminals of a kind of cube file, existing to solve
There is the problem of technology expends time, low efficiency when creating cube file.
The embodiment of the invention provides a kind of creation methods of cube file, which comprises
When obtaining creation instruction, the file index of cube file to be created is obtained according to the creation instruction, according to institute
State the typing window of key message formula bar of the file index output comprising the cube file；
The corresponding field value of the key message of founder's input is obtained by the typing window；
Preservation instruction based on key message is associated with and stores the key message and its corresponding field value；
The key message and its corresponding field value are loaded into target XML file, cube file is generated.
Further, when obtaining creation instruction, the file of cube file to be created is obtained according to the creation instruction
Before index, the creation method further include:
The cube file that parsing Schema-workbenth tool has created, obtains text formatting and key message；
Target XML file is generated according to the text formatting, and recording the key message is compiling on typing window
Collect item.
Further, described that the key message and its corresponding field value are loaded into target XML file, generate cube
File includes:
The fact that obtain where the corresponding field value of key message table, according to the name acquiring of true table for verifying
Database；
Library generates checking command based on the data；
The table information recorded in content and the database in the target XML file is verified according to the checking command
It is whether consistent；
If when consistent, generating cube file based on the target XML file.
Further, the creation method further include:
If the table information recorded in the content and database in the target XML file is inconsistent, prompt information is exported.
It further, include Excel file in the typing window；
In the Excel file, each key message is an editable item, including at least one formula bar.
The embodiment of the invention also provides a kind of creating device of cube file, described device includes:
When for obtaining creation instruction, the text of cube file to be created is obtained according to the creation instruction for editor module
Part index, according to the typing window of key message formula bar of the file index output comprising the cube file；
Module is obtained, for obtaining the corresponding field of the key message of founder's input by the typing window
Value；
Memory module is associated with for the preservation instruction based on key message and stores the key message and its corresponding word
Segment value；
Generation module generates cube for the key message and its corresponding field value to be loaded into target XML file
File.
Further, the creating device further include:
Parsing module, the cube file created for parsing Schema-workbenth tool, obtain text formatting and
Key message；
Generation module is indexed, for generating target XML file according to the text formatting, and the key message is recorded and is
Editable item on typing window.
Further, the generation module further include:
Database acquiring unit, the table of the fact that for obtaining where the corresponding field value of the key message, according to the fact
Database of the name acquiring of table for verification；
Verification unit, generates checking command for library based on the data, verifies the target according to the checking command
Whether the table information recorded in the content and the database in XML file is consistent；
Generation unit, if in the target XML file content and the database in the table information that records it is consistent
When, cube file is generated based on the target XML file；
Prompt unit, if in the target XML file content and database in the table information that records it is inconsistent when,
Export prompt information.
The embodiment of the invention also provides a kind of computer readable storage mediums, are stored thereon with computer program, the journey
Step described in the creation method of cube file as described above is realized when sequence is executed as processor.
The embodiment of the invention also provides a kind of terminal, the terminal includes memory, processor and is stored in memory
Computer program that is upper and can running on a processor, the processor are realized as described above when executing the computer program
The step of creation method of cube file.
Compared with prior art, the embodiment of the present invention includes wait create in the typing window by constructing typing window
Formula bar of the key message in cube file built as editable item is interacted by the typing window with user；When connecing
When receiving the creation instruction of cube file, the typing window is exported；The institute of founder's input is obtained by the typing window
State the corresponding field value of key message；When receiving the preservation instruction to key message, then it is associated with and stores the crucial letter
Breath and its corresponding field value；The key message and its corresponding field value are loaded into target XML file, cube text is generated
Part；So that founder can add the key message in cube file in batches, without adding according to original each step execution
Add operation simplifies the operation of founder, realizes the automation creation of cube file, solves the prior art in creation cube
The problem of time, low efficiency are expended when file.
Detailed description of the invention
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below
There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
Some embodiments of invention for those of ordinary skill in the art without creative efforts, can be with
Other accompanying drawings can also be obtained according to these attached drawings.
Fig. 1 is the first implementation flow chart of the creation method of cube file provided in an embodiment of the present invention；
Fig. 2 is the second implementation flow chart of the creation method of cube file provided in an embodiment of the present invention；
Fig. 3 is the third implementation flow chart of the creation method of cube file provided in an embodiment of the present invention；
Fig. 4 is the composite structural diagram of the creating device of cube file provided in an embodiment of the present invention；
Fig. 5 is the schematic diagram of terminal provided in an embodiment of the present invention.
Specific embodiment
In order to make the objectives, technical solutions, and advantages of the present invention clearer, with reference to the accompanying drawings and embodiments, right
The present invention is further elaborated.It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, and
It is not used in the restriction present invention.
Embodiment 1
Fig. 1 shows the first implementation flow of the creation method of cube file provided in an embodiment of the present invention.
In embodiments of the present invention, the creation method of the cube file be applied to terminal, including but not limited to computer,
Server etc..
Refering to fig. 1, the creation method of the cube file includes:
In step s101, when obtaining creation instruction, the text of cube file to be created is obtained according to the creation instruction
Part index, according to the typing window of key message formula bar of the file index output comprising the cube file.
The embodiment of the present invention is by an edit tool of self-service exploitation, to replace original schema-workbenth group
Part.The working principle of the edit tool is to skip operating procedure of the founder on schema-workbenth component, directly
The key message obtained in cube file to be created automatically generates cube file.Wherein, the key message passes through preset
Typing window obtains.It optionally, include Excel file in the typing window；In the Excel file, each is crucial
Information is an editable item, including at least one formula bar, the formula bar be used to indicate founder input it is to be created
The key message of cube file.Unlike the prior art, when instructing the creation for getting cube file, the embodiment of the present invention
It is instructed first according to the creation and obtains file index.The file index is the index information of cube file to be created, packet
Title, key message, the target XML file etc. for including but being not limited to cube file to be created.Then according to the key message
Typing window is exported, to prompt founder to edit by the formula bar on filling window to the cube file.
In step s 102, the corresponding field of the key message of founder's input is obtained by the typing window
Value.
Herein, table, dimension table, aggregation table etc. are stored in database profession the fact that multidimensional data, belong to physical model, and are counted
According to cube, dimension, measures these concepts and belong to logical model.Multidimensional analysis engine, and can it must be understood that logical model
It is mapped on physical model.The mode of multidimensional data, i.e. cube file are exactly used to describe this logical model and arrive physics
The mapping of model.In embodiments of the present invention, the key message is description information of the cube file to logical model, including but
It is not limited to Dimension dimensional information, Hierarchy hierarchical information, Level level information, the Measure measurement of physical model
Information.On the typing window, each key message corresponds at least one formula bar, and founder is on demand in the formula bar
The information such as upper input cube file corresponding Dimension, Level, Measure to be created.Wherein, the dimensional information is
The table name of database is the set of a level Hierarchy.The dimension of one aspect generally corresponds to a few dimension table
(Dimension Table) stores the table of dimension data.Illustratively, common dimension includes but is not limited to time, area
Domain, product etc..By taking time dimension as an example, the content of dimension table include but is not limited to date_tk, year, quarter, month,
The fields such as week, day_of_month, day_of_year, and these fields are exactly the level below dimension.Region dimension table
Content includes but is not limited to the fields such as region_tk, country, province, city, district.
In step s 103, the preservation instruction based on key message is associated with and stores the key message and its corresponding word
Segment value.
In embodiments of the present invention, preservation Function Identification is provided on the typing window.If founder is in the typing
After completing on window to the editor of key message, the preservation Function Identification can be triggered by specified gesture operation and be protected with inputting
Deposit instruction.
When getting preservation instruction, current word in the key message and its corresponding formula bar on the typing window
Segment value will be associated, and then be stored into specified storage medium, to save the edit operation of founder.
In step S104, the key message and its corresponding field value are loaded into target XML file, generate cube
File.
Herein, the target XML file is the template file of the cube file to be created, key message therein
Content be in open position, it is to be filled.When detecting that founder compiles some key message on the typing window
After volume, the field value that the embodiment of the present invention is then inputted the founder, Auto-writing is corresponded into the target XML file
Vacant locations on.Key message and its corresponding field value all on typing window are traversed, and executes guarantor after having filled in
Operation is deposited, cube file is generated.
Illustratively, it is assumed that detect user in typing window into the corresponding formula bar of key message Dimension
Field value StandardDimension is had input, has input field value into the corresponding formula bar of key message Hierarchy
DIM_RPT_HCPMS_PERIOD has input field value YEAR_ID, QUTER_ into the corresponding formula bar of key message Level
ID, MONTH_ID, then for Auto-writing into target XML file, example is as follows, and wherein italicized item is the field value of filling；Most
It executes afterwards and saves operation generation cube file.
< Dimension type=" StandardDimension " visible=" true " highCardinality="
False " name=" DIM_RPT_HCPMS_PERIOD " >
< Hierarchyname=" DIM_RPT_HCPMS_PERIOD " visible=" true " hasAll=" true "
PrimaryKey=" PERIOD_ID " caption=" 日；期；维；">
<Table name=" RPT_HCPMS_PERIOD_V_D ">
</Table>
< Levelname=" YEAR_ID " visible=" true " column=" YEAR_ID " nameColumn="
YEAR_NAME " type=" String " uniqueMembers=" false " levelType=" R egular "
HideMemberIf=" Never " caption=" 年；">
</Level>
< Levelname=" QUTER_ID " visible=" true " column=" QUTER_ID " nameColumn="
QUTER_NAME " type=" String " uniqueMembers=" false " levelType=" Regular "
HideMemberIf=" Never " caption=" 季；度；">
</Level>
< Levelname=" MONTH_ID " visible=" true " column=" MONTH_ID " nameColumn="
MONTH_NAME " type=" String " uniqueMembers=" false " levelType=" Regular "
HideMemberIf=" Never " caption=" 月；份；">
</Level>
</Hierarchy>
</Dimension>
In conclusion the embodiment of the present invention passes through the key message of typing window editor cube file, batch may be implemented
Production, improves the efficiency of cube document creation, it is only necessary to which founder fills in formula bar according to given format, does not need to do other
Operation；Terminal executes padding automatically according to the key message of input and generates cube file, to realize automation creation
Cube file；And it does not need to load data, the contents saved in typing window such as such as true table, dimension table from database and is
Can, without additional caching mechanism.
Further, on the basis of the first implementation flow of the creation method based on Fig. 1 cube file provided, this is proposed
Second implementation process of the creation method for the cube file that inventive embodiments provide.
As shown in Fig. 2, being the second implementation flow chart of the creation method of cube file provided in an embodiment of the present invention, obtaining
When creation being taken to instruct, before the file index that cube file to be created is obtained according to the creation instruction, the creation method
Further include:
In step s 201, the cube file that has created of parsing Schema-workbenth tool, obtain text formatting and
Key message.
Herein, the cube file created is that the prior art is gone through using what Schema-workbenth tool created
History cube file.Since cube file follows the format of XML file, in parsing without compiling, it is only necessary to analyze cube file
Code regulation obtain text formatting and key message.It is alternatively possible to be carried out at analysis using OCR technique to XML file
Reason.Wherein, the text formatting is the syntax rule of code in cube file, and the key message is cube file to logic mould
The description information of type, including but not limited to the Dimension dimensional information, Hierarchy hierarchical information, Level of physical model
Level information, Measure metric.
In step S202, target XML file is generated according to the text formatting, and recording the key message is typing
Editable item on window.
In embodiments of the present invention, the target XML file and editable item together constitute the file of the cube file
Index.Wherein, the key message in target XML file generated is open position, to be filled, to obtain cube file
Template file, so that when creating cube file without generating cube according to the foundation step of Schema-workbenth tool
File, to realize the batch creation of cube file.Then record the key message as edit the cube file when can
Edit item, these editable items are defined should be including the volume of which key message in the typing window according to creation instruction output
Column is collected, allows founder intuitively to edit key message, to realize the batch editor of cube file.
Step S203 to step S206, wherein step S203 to step S206 and Fig. 1 step S101 as described in the examples
It is identical to step S104, the narration of above-described embodiment is specifically referred to, details are not described herein again.
Herein, the embodiment of the present invention is by parsing existing cube file, and generates target XML file and editable
, the editable item is used to define the formula bar on typing window, completes to believe key on typing window to realize
The edit operation of breath, compared with the prior art according to the behaviour of the visioning procedure creation cube file of Schema-workbenth tool
Make, it is more intuitive and convenient, improve the experience sense of founder.
Further, on the basis of the first implementation flow of the creation method based on Fig. 1 cube file provided, this is proposed
The third implementation process of the creation method for the cube file that inventive embodiments provide.
As shown in figure 3, be the third implementation flow chart of the creation method of cube file provided in an embodiment of the present invention, it is described
The key message and its corresponding field value are loaded into target XML file by step S104, are generated cube file and are included:
In step S1041, the fact that obtain where the corresponding field value of the key message table, according to the name of true table
Claim to obtain the database for verification.
Herein, will field value be loaded into target XML file after, execute save operation can be obtained can allow report identify
Cube file.The embodiment of the present invention can also obtain the fact that store these field values table, and be traced according to the title of true table
Its store path obtains the database for saving the true table, determines the range of verification.Wherein, the true table (Fact
Table), i.e. tables of data refers to the table of data of the storage from business.
In step S1042, library generates checking command based on the data.
Herein, the checking command is SQL statement, for the accurate of verification object XML file in the database
Property.The embodiment of the present invention is after getting database, and library generates SQL statement based on the data, to execute to the target
The verification operation of XML file.
In step S1043, content and the database in the target XML file are verified according to the checking command
Whether the table information of middle record is consistent.
When executing the checking command, the key message being loaded into target XML file is traversed, is believed for each key
Breath, be compared with the table information recorded in the database, judge the key message field value and table information whether one
It causes, to verify the accuracy of the target XML file.
In step S1044, if when consistent, generating cube file based on the target XML file.
If the table information recorded in the key message and the database in the target XML file is consistent, show
Key message in the target XML file is correctly, then to execute preservation operation, generate cube file.
Optionally, the creation method further include:
In step S1045, if the table information recorded in content and database in the target XML file is inconsistent
When, export prompt information.
Exist in the result of comparison, in the target XML file and to be recorded in one or more key messages and database
When table information is inconsistent, the fact that show that the corresponding field value of the key message is incorrect, can not map table, then export prompt
Information.Herein, the prompt information includes but is not limited to pop up warning window, shows all verifications by the warning window
The key message of failure, and suspend current cube document creation process.
The embodiment of the present invention verifies the field value of key message by increasing, and ensure that through the typing window
The accuracy of the key message of acquisition ensure that the validity of cube file generated, be conducive to prevent due in the record
Enter invalid cube file caused by the erroneous input on window.
It should be understood that in the above-described embodiments, the size of the serial number of each step is not meant that the order of the execution order, it is each to walk
Rapid execution sequence should be determined by its function and internal logic, and the implementation process without coping with the embodiment of the present invention constitutes any limit
It is fixed.
Embodiment 2
Fig. 4 shows the composite structural diagram of the creating device of cube file provided in an embodiment of the present invention, for the ease of saying
Bright, only parts related to embodiments of the present invention are shown.
In embodiments of the present invention, the creating device of the cube file is for realizing above-mentioned Fig. 1, Fig. 2, Fig. 3 embodiment
Described in cube file creation method, can be the software unit for being built in terminal, hardware cell, software and hardware combining list
Member, the terminal include but is not limited to computer, server etc..
Refering to Fig. 4, the creating device of the cube file includes:
Editor module 41 when for obtaining creation instruction, obtains cube file to be created according to the creation instruction
File index, according to the typing window of key message formula bar of the file index output comprising the cube file；
Module 42 is obtained, for obtaining the corresponding field of the key message of founder's input by the typing window
Value；
Memory module 43 is associated with and stores the key message and its corresponding for the preservation instruction based on key message
Field value；
Generation module 44 is generated for the key message and its corresponding field value to be loaded into target XML file
Cube file.
It wherein, include Excel file in the typing window；
In the Excel file, each key message is an editable item, including at least one formula bar.
Optionally, the creating device further include:
Parsing module 45, the cube file created for parsing Schema-workbenth tool, obtains text formatting
And key message；
Generation module 46 is indexed, for generating target XML file according to the text formatting, and records the key message
For the editable item on typing window.
Optionally, the generation module 44 further include:
Database acquiring unit 441, the table of the fact that for obtaining where the corresponding field value of the key message, according to thing
Database of the name acquiring of real table for verification；
Verification unit 442, generates checking command for library based on the data, verifies the mesh according to the checking command
Whether the table information recorded in the content and the database in mark XML file is consistent；
Generation unit 443, if in the target XML file content and the database in the table information one that records
When cause, cube file is generated based on the target XML file；
Prompt unit 444, if in the target XML file content and database in the table information that records it is inconsistent
When, export prompt information.
It should be noted that each module/unit in the embodiment of the present invention can be used to implement in above method embodiment
Whole technical solutions, specific work process can refer to corresponding processes in the foregoing method embodiment, no longer superfluous herein
It states.
In the above-described embodiments, it all emphasizes particularly on different fields to the description of each embodiment, is not described in detail or remembers in some embodiment
The part of load may refer to the associated description of other embodiments.
Embodiment 3
The present embodiment provides a computer readable storage medium, computer journey is stored on the computer readable storage medium
Sequence realizes the creation method of cube file in embodiment 1, to avoid repeating, here when the computer program is executed by processor
It repeats no more.Alternatively, when the computer program is executed by processor realize embodiment 2 in cube file creating device in each mould
Block/unit function, to avoid repeating, which is not described herein again.
Embodiment 4
Fig. 5 is a kind of schematic diagram of terminal provided in an embodiment of the present invention, and the terminal includes but is not limited to server, moves
Dynamic terminal.As shown in figure 5, the terminal 5 of the embodiment includes: processor 50, memory 51 and is stored in the memory 51
In and the computer program 52 that can be run on the processor 50.The processor 50 executes real when the computer program 52
Step in the creation method embodiment of existing above-mentioned cube file, such as step S101 shown in FIG. 1 is to S104, Fig. 2 embodiment
Described in step S201 to S206, Fig. 3 step S1041 to S1045 as described in the examples；Alternatively, the processor 50 is held
The function of each module/unit in the creating device embodiment of above-mentioned cube file is realized when the row computer program 52, such as
The function of module 41 to 46 shown in Fig. 4.
Illustratively, the computer program 52 can be divided into one or more module/units, it is one or
Multiple module/units are stored in the memory 51, and are executed by the processor 50, to complete the present invention.Described one
A or multiple module/units can be the series of computation machine program instruction section that can complete specific function, which is used for
Implementation procedure of the computer program 52 in the terminal 5 is described.For example, the computer program 52 can be divided into
Editor module obtains module, memory module, generation module, and each module concrete function is as follows:
When for obtaining creation instruction, the text of cube file to be created is obtained according to the creation instruction for editor module
Part index, according to the typing window of key message formula bar of the file index output comprising the cube file；
Module is obtained, for obtaining the corresponding field of the key message of founder's input by the typing window
Value；
Memory module is associated with for the preservation instruction based on key message and stores the key message and its corresponding word
Segment value；
Generation module generates cube for the key message and its corresponding field value to be loaded into target XML file
File.
Optionally, the computer program 52 further include:
Parsing module, the cube file created for parsing Schema-workbenth tool, obtain text formatting and
Key message；
Generation module is indexed, for generating target XML file according to the text formatting, and the key message is recorded and is
Editable item on typing window.
Optionally, the computer program 52 further include:
Database acquiring unit, the table of the fact that for obtaining where the corresponding field value of the key message, according to the fact
Database of the name acquiring of table for verification；
Verification unit, generates checking command for library based on the data, verifies the target according to the checking command
Whether the table information recorded in the content and the database in XML file is consistent；
Creating unit, if in the target XML file content and the database in the table information that records it is consistent
When, cube file is generated based on the target XML file；
Generation unit, if in the target XML file content and database in the table information that records it is inconsistent when,
Export prompt information.
The terminal 5 can be desktop PC, notebook, palm PC and cloud server etc. and calculate equipment.Institute
Stating terminal may include, but be not limited only to, processor 50, memory 51.It will be understood by those skilled in the art that Fig. 5 is only eventually
The example at end 5, the not restriction of structure paired terminal 5 may include than illustrating more or fewer components, or the certain portions of combination
Part or different components, such as the terminal can also include input-output equipment, network access equipment, bus etc..
Alleged processor 50 can be central processing unit (Central Processing Unit, CPU), can also be
Other general processors, digital signal processor (Digital Signal Processor, DSP), specific integrated circuit
(Application Specific Integrated Circuit, ASIC), field programmable gate array (Field-
Programmable Gate Array, FPGA) either other programmable logic device, discrete gate or transistor logic,
Discrete hardware components etc..General processor can be microprocessor or the processor is also possible to any conventional processor
Deng the processor is the control centre of the terminal, utilizes the various pieces of various interfaces and the entire terminal of connection.
The memory 51 can be used for storing the computer program and/or module, and the processor is by operation or holds
Row stores computer program and/or module in the memory, and calls the data being stored in memory, realizes institute
State the various functions of terminal.The memory can mainly include storing program area and storage data area, wherein storing program area can
Application program needed for storage program area, at least one function (such as sound-playing function, image player function etc.) etc.；It deposits
Storage data field, which can be stored, uses created data etc. according to terminal.In addition, memory may include that high random access is deposited
Reservoir can also include nonvolatile memory, such as hard disk, memory, plug-in type hard disk, intelligent memory card (Smart Media
Card, SMC), safe digital card (Secure Digital, SD), flash card (Flash Card), at least one magnetic disk storage
Part, flush memory device or other volatile solid-state parts.
It, can also be in addition, the functional units in various embodiments of the present invention may be integrated into one processing unit
It is that each unit physically exists alone, can also be integrated in one unit with two or more units.Above-mentioned integrated list
Member both can take the form of hardware realization, can also realize in the form of software functional units.
If the integrated module/unit be realized in the form of SFU software functional unit and as independent product sale or
In use, can store in a computer readable storage medium.Based on this understanding, the present invention realizes above-described embodiment
All or part of the process in method can also instruct relevant hardware to complete, the calculating by computer program
Machine program can be stored in a computer readable storage medium, and the computer program is when being executed by processor, it can be achieved that above-mentioned
The step of each embodiment of the method.Wherein, the computer program includes computer program code, the computer program code
It can be source code form, object identification code form, executable file or certain intermediate forms etc..The computer-readable storage medium
Matter may include: can carry the computer program code any entity or device, recording medium, USB flash disk, mobile hard disk,
Magnetic disk, CD, computer storage, read-only memory (ROM, Read-Only Memory), random access memory (RAM,
Random Access Memory), electric carrier signal, telecommunication signal and software distribution medium etc..It should be noted that described
It is appropriate that the content that computer readable storage medium includes can be carried out according to the requirement made laws in jurisdiction with patent practice
Increase and decrease, such as in certain jurisdictions, according to legislation and patent practice, computer readable storage medium do not include be electric load
Wave signal and telecommunication signal.
Embodiment described above is merely illustrative of the technical solution of the present invention, rather than its limitations；Although referring to aforementioned reality
Applying example, invention is explained in detail, those skilled in the art should understand that: it still can be to aforementioned each
Technical solution documented by embodiment is modified or equivalent replacement of some of the technical features；And these are modified
Or replacement, the spirit and scope for technical solution of various embodiments of the present invention that it does not separate the essence of the corresponding technical solution should all
It is included within protection scope of the present invention.
Claims (10)
1. a kind of creation method of cube file, which is characterized in that the creation method includes:
When obtaining creation instruction, the file index of cube file to be created is obtained according to the creation instruction, according to the text
The typing window of key message formula bar of the part index output comprising the cube file, the file index is to be created
The index information of cube file, title, key message, target XML file including cube file to be created；
The corresponding field value of the key message of founder's input is obtained by the typing window；
Preservation instruction based on key message is associated with and stores the key message and its corresponding field value；
The key message and its corresponding field value are loaded into target XML file, cube file is generated；
The target XML file is the template file of the cube file to be created, and the content of key message therein is in
Open position.
2. the creation method of cube file as described in claim 1, which is characterized in that when obtaining creation instruction, according to institute
Before stating the file index that creation instruction obtains cube file to be created, the creation method further include:
The cube file that parsing Schema-workbenth tool has created, obtains text formatting and key message；
Target XML file is generated according to the text formatting, and recording the key message is the editable item on typing window.
3. the creation method of cube file as described in claim 1, which is characterized in that described by the key message and its right
The field value answered is loaded into target XML file, is generated cube file and is included:
The fact that obtain where the corresponding field value of key message table, the number according to the name acquiring of true table for verification
According to library；
Library generates checking command based on the data；
The table information that records in content in the target XML file and the database is verified according to the checking command whether
Unanimously；
If when consistent, generating cube file based on the target XML file.
4. the creation method of cube file as claimed in claim 3, which is characterized in that the creation method further include:
If the table information recorded in the content and database in the target XML file is inconsistent, prompt information is exported.
5. such as the creation method of the described in any item cube files of Claims 1-4, which is characterized in that in the typing window
Including Excel file；
In the Excel file, each key message is an editable item, including at least one formula bar.
6. a kind of creating device of cube file, which is characterized in that described device includes:
When for obtaining creation instruction, the file rope of cube file to be created is obtained according to the creation instruction for editor module
Draw, according to the typing window of key message formula bar of the file index output comprising the cube file, the file rope
It is cited as the index information of cube file to be created, title, key message, target XML text including cube file to be created
Part；
Module is obtained, for obtaining the corresponding field value of the key message of founder's input by the typing window；
Memory module is associated with for the preservation instruction based on key message and stores the key message and its corresponding field
Value；
Generation module generates cube text for the key message and its corresponding field value to be loaded into target XML file
Part；
The target XML file is the template file of the cube file to be created, and the content of key message therein is in
Open position.
7. the creating device of cube file as claimed in claim 6, which is characterized in that the creating device further include:
Parsing module, the cube file created for parsing Schema-workbenth tool, obtains text formatting and key
Information；
Generation module is indexed, for generating target XML file according to the text formatting, and recording the key message is typing
Editable item on window.
8. the creating device of cube file as claimed in claim 6, which is characterized in that the generation module further include:
Database acquiring unit, the table of the fact that for obtaining where the corresponding field value of the key message, according to true table
Database of the name acquiring for verification；
Verification unit generates checking command for library based on the data, verifies the target XML text according to the checking command
Whether the table information recorded in the content and the database in part is consistent；
Generation unit, if in the target XML file content and the database in the table information that records it is consistent when, base
Cube file is generated in the target XML file；
Prompt unit, if in the target XML file content and database in the table information that records it is inconsistent when, output
Prompt information.
9. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the program is held by processor
Step described in the creation method of cube file described in any one of claim 1 to 5 is realized when row.
10. a kind of terminal, the terminal includes memory, processor and storage on a memory and can run on a processor
Computer program, which is characterized in that the processor realizes such as the claims 1 to 5 when executing the computer program
Step described in the creation method of cube file described in one.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711291900.6A CN108255479B (en) | 2017-12-08 | 2017-12-08 | Creation method, device, storage medium and the terminal of cube file |
| PCT/CN2018/081041 WO2019109556A1 (en) | 2017-12-08 | 2018-03-29 | Cube file creation method, device, storage medium and terminal |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711291900.6A CN108255479B (en) | 2017-12-08 | 2017-12-08 | Creation method, device, storage medium and the terminal of cube file |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108255479A CN108255479A (en) | 2018-07-06 |
| CN108255479B true CN108255479B (en) | 2019-10-08 |
Family
ID=62722380
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711291900.6A Active CN108255479B (en) | 2017-12-08 | 2017-12-08 | Creation method, device, storage medium and the terminal of cube file |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN108255479B (en) |
| WO (1) | WO2019109556A1 (en) |
Families Citing this family (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109739940A (en) * | 2018-12-29 | 2019-05-10 | 东软集团股份有限公司 | On-line analytical processing method, apparatus, storage medium and electronic equipment |
| CN111143328A (en) * | 2019-12-26 | 2020-05-12 | 山东翰林科技有限公司 | Agile business intelligent data construction method, system, equipment and storage medium |
| CN113312133B (en) * | 2021-06-17 | 2022-06-24 | 浙江齐安信息科技有限公司 | Operation method, system and storage medium |
| CN113656851B (en) * | 2021-10-20 | 2022-03-15 | 广州中望龙腾软件股份有限公司 | Method for generating gradient functional material based on Wang cubes method, terminal and storage medium |
| CN114546971B (en) * | 2022-01-26 | 2022-11-08 | 北京元年科技股份有限公司 | Data file format conversion method, device, equipment and readable storage medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1564160A (en) * | 2004-04-22 | 2005-01-12 | 重庆市弘越科技有限公司 | Method of seting up and inquirying multiple-demensional data cube |
| CN102508913A (en) * | 2011-11-17 | 2012-06-20 | 张真 | Cloud computing system with data cube storage index structure |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10740309B2 (en) * | 2015-12-18 | 2020-08-11 | Cisco Technology, Inc. | Fast circular database |
| CN107357923A (en) * | 2017-07-21 | 2017-11-17 | 山东浪潮商用系统有限公司 | The cubical method of the tax is generated based on FreeMarker |
-
2017
- 2017-12-08 CN CN201711291900.6A patent/CN108255479B/en active Active
-
2018
- 2018-03-29 WO PCT/CN2018/081041 patent/WO2019109556A1/en active Application Filing
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1564160A (en) * | 2004-04-22 | 2005-01-12 | 重庆市弘越科技有限公司 | Method of seting up and inquirying multiple-demensional data cube |
| CN102508913A (en) * | 2011-11-17 | 2012-06-20 | 张真 | Cloud computing system with data cube storage index structure |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2019109556A1 (en) | 2019-06-13 |
| CN108255479A (en) | 2018-07-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108255479B (en) | Creation method, device, storage medium and the terminal of cube file | |
| Szárnyas et al. | The Train Benchmark: cross-technology performance evaluation of continuous model queries | |
| CN104866426B (en) | Software test integrated control method and system | |
| Ikeda et al. | Panda: A System for Provenance and Data. | |
| US8984485B2 (en) | Analysis of source code changes | |
| US10324929B2 (en) | Provision of position data for query runtime errors | |
| CN106951231B (en) | Computer software development method and device | |
| Chillón et al. | A model-driven approach to generate schemas for object-document mappers | |
| CN109359283A (en) | Method of summary, terminal device and the medium of list data | |
| CN112199086A (en) | Automatic programming control system, method, device, electronic device and storage medium | |
| CN108460068A (en) | Method, apparatus, storage medium and the terminal that report imports and exports | |
| CN109753490A (en) | Database optimizing method, system, equipment and medium based on loophole reparation | |
| Ekanayake et al. | Consistency checking of UML class and sequence diagrams | |
| Thao | A configuration management system for software product lines | |
| US10360186B2 (en) | Managing computations for hierarchical entities | |
| CN108804401B (en) | Report template merging method and device | |
| Rasool | Customizable feature based design pattern recognition integrating multiple techniques | |
| CN111638926A (en) | Method for realizing artificial intelligence in Django framework | |
| CN116166904A (en) | Web page report generation method, device, equipment and medium | |
| Gómez et al. | Ontology metrics and evolution in the GF framework for ontology-based data access | |
| Zhang et al. | A database for developing machine learning based disruption predictors | |
| Kritikos et al. | Towards semantic KPI measurement | |
| CN109597845B (en) | Report configuration method, report configuration device, computer equipment and storage medium | |
| US20200372038A1 (en) | Facilitating construction of a user interface | |
| De Carlos et al. | Model query translator: A model-level query approach for large-scale models |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |