CN103678590B - Report collecting device and report collecting method based on OLAP - Google Patents
Report collecting device and report collecting method based on OLAP Download PDFInfo
- Publication number
- CN103678590B CN103678590B CN201310681731.2A CN201310681731A CN103678590B CN 103678590 B CN103678590 B CN 103678590B CN 201310681731 A CN201310681731 A CN 201310681731A CN 103678590 B CN103678590 B CN 103678590B
- Authority
- CN
- China
- Prior art keywords
- dimension
- mapping
- area
- multidimensional model
- mapping area
- 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
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- 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)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Health & Medical Sciences (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (AREA)
- Data Mining & Analysis (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a report collecting device based on OLAP. The report collecting device based on the OLAP comprises a multi-dimensional model fast establishing module, a multi-dimensional model and report area mapping module and a data extracting module. According to the multi-dimensional model fast establishing module, service operation is selected, and a multi-dimensional model is generated fast according to selected service operation information. According to the multi-dimensional model and report area mapping module, based on the established multi-dimensional model, the mapping between the multi-dimensional model and a report area is set through a dragging mode, and a mapping area is generated according to a mapping relation set through the mapping. According to the data extracting module, based on the generated mapping area, the mapping area is converted into multi-dimensional inquiry statements to carry out multi-dimensional inquiry, and inquiry results are filled in a report. The invention further provides a report collecting method based on the OLAP. By means of the technical scheme, based on the existing report collecting modes, the report collection of multi-object data can be completed by fully utilizing single-object data, and a general and uniform collecting concept is established, wherein multi-object data are involved in the general and uniform collecting concept, and the general and uniform collecting concept is oriented to scattered data report collection and independent data report collection.
Description
Technical field
The present invention relates to field of computer technology, in particular it relates to a kind of form harvester and one kind based on OLAP
Form acquisition method based on OLAP.
Background technology
At present, most medium-and-large-sized enterprises and institutions have been set up the Back ground Informations such as fairly perfect ERP, CRM, OA
Change system, these systems are essentially all typical OLTP systems, are that enterprise have accumulated substantial amounts of data.But these data are
Disperse, be stored separately in database, these data are the books from heaven that cannot be understood for business personnel.How these to be counted
It is analyzed or gathers according to the data integrated and be converted to business meaningFor this point, existing product mostly passes through
Multi-dimensional query is solved, but the subject matter for existing has：
(1) it is excessively complicated that multidimensional model is built：Multidimensional model building process is excessively complicated, the skill that multidimensional model is related to
Art and concept are exposed to user, it is impossible to quickly go out multidimensional model；
(2) multidimensional model can not be applied to gather form：Existing product primarily focuses on analytical statement, without by multidimensional
Inquiring technology is applied in collection form.
How will dispersion, independent data integrated, and by the data rapid extraction after integration to gather formNeed
Propose solution.
Accordingly, it would be desirable to a kind of new form acquisition technique based on OLAP, can be on existing form acquisition mode basis
On, the form for making full use of single pair of image data to complete many object datas is gathered, set up that many object datas participate in towards dispersion, solely
General, the unified collection thinking of vertical data sheet collection.
The content of the invention
The present invention is based on above mentioned problem, it is proposed that a kind of new form acquisition technique based on OLAP, can be existing
On the basis of some form acquisition modes, the form for making full use of single pair of image data to complete many object datas is gathered, and sets up many objects
What data were participated in gathers thinking towards dispersion, the general, unified of independent data form collection.
In view of this, the present invention proposes a kind of form harvester based on OLAP, including：Multidimensional model rapid build
Module, for the business operation for selecting to include service profile, accounting period, measurement, data source, according to the business operation of selection
Information quickly generates multidimensional model；Multidimensional model and form area map module, for based on the multidimensional model rapid build
The multidimensional model of module construction, the mapping settings of multidimensional model and form region is carried out by pulling mode, according to mapping settings
Mapping relations generation mapping area；Data extraction module, for being given birth to based on the multidimensional model and form area map module
Into mapping area, mapping area is converted into multi-dimensional query sentence carries out multi-dimensional query, and query resultses are filled into report
In table.In the technical scheme, the rapid build multidimensional model by way of service-oriented, by multidimensional model and collection form
Area maps mode, by data extract collection form in, can reduce multidimensional model structure complexity.
In the above-mentioned technical solutions, it is preferable that the multidimensional model rapid build module, specifically include：Interface sets mould
Block, for selecting the business operation comprising service profile, accounting period, measurement and data source；Multidimensional model builds module, uses
In the business operation for obtaining the interface setup module selection, multidimensional model is built based on the business operation for obtaining.
In the above-mentioned technical solutions, it is preferable that it is many based on the business operation structure for obtaining that the multidimensional model builds module
The operation of dimension module, specifically includes：Service profile generation dimension in the business operation, and automatically generate the layer of dimension
Secondary and rank；The corresponding data table of the service profile constitutes dimension table, the value on the Major key dimension of service profile, business
Show value on the name-value dimension of archives；Accounting period generation time dimension in the business operation, and it is raw
Into multiple ranks of time dimension；Measurement generation measurement in the business operation；According to the industry in the business operation
Business archives, measurement and data source, the true table of generation；The dimension, time dimension, measurement and true table according to generation, it is raw
Into cube.
In the above-mentioned technical solutions, it is preferable that the multidimensional model and form area map module, specifically include：Mapping
Setup module, multidimensional model and pre-defined collection form for obtaining the multidimensional model rapid build module construction,
The multidimensional model and the mapping relations in form region corresponding with the collection form that obtain are entered by pulling mode
Row is set；Mapping area generation module, for the mapping relations set based on the mapping settings module, generates mapping area.
In the above-mentioned technical solutions, it is preferable that the mapping settings module passes through the multidimensional of the pulling mode to acquisition
The operation that the mapping relations in model and form region corresponding with the collection form are configured, specifically includes：Pull many
The dimension member and measurement of dimension module are fixed mapping area to the left side or top of the memory cell for pre-setting；Pull
To the top of the memory cell for pre-setting, be expanded the dimension member and measurement of multidimensional model mapping area；By the expansion
Exhibition mapping area is mapped with dimension in multidimensional model, and the dimension is to extend the foundation that mapping area is extended；And,
The mapping area generation module is based on the mapping relations that the mapping settings module is set, and generates the operation of mapping area, tool
Body includes：Obtain the set of the mapping relations for setting and all memory cell for pre-setting in the mapping settings module；From
The corresponding memory cell of one index cell of selection, chooses from the mapping relations in the set of all memory cell
The ranks dimension of memory cell mapping, and whether verify the ranks dimension legal：If legal, already present map section is obtained
Domain list, and judge whether for the mapping area list to be added to existing mapping area：If adding, by respective memory unit
Add mapping area and regenerate regional extent；If being added without, new mapping area is generated, add the new mappings region pair
The mapping area list answered；If illegal, judge whether all traversal memory cell；If all traversal, terminates this secondary
Into the operation of mapping area；If not traveling through all, next index unit is chosen from the set of all memory cell
The corresponding memory cell of lattice is processed；And/or, mapping area is converted to multi-dimensional query sentence and entered by the data extraction module
Row multi-dimensional query, and query resultses are filled into the operation in form, specifically include the operation and calculating for calculating FX
The operation of extended area, wherein：The operation for calculating FX, including according to the corresponding row dimension of mapping area or row
The rule of classification whether dimension matches completely, mapping area is grouped, and carries out data extraction by group；In the packet rule
In then, if row dimension is matched completely, row dimension is extended during splicing multi-dimensional query sentence；If complete of row dimension
Match somebody with somebody, be then just extended row dimension when splicing multi-dimensional query sentence；The operation that data extraction is carried out by group, specific bag
Include：Multiple mapping areas merge into a computing unit；Splicing multi-dimensional query sentence：Mapping area is mapped in rows and columns
Dimension as axle dimension, will collection form in itself the dimension such as unit, period as food slicer dimension；Multidimensional model secondary operation,
Reject useless dimensional information；MDX is performed by OLAP engines to inquire about；Query Result is split by mapping area；Perform number
According to filling；The operation for calculating extended area, specifically includes：Obtain the dimension mapped in extended area；Splicing multi-dimensional query
Sentence：Mapping area is mapped in the dimension on row as row dimension, all member's dimensions that will be mapped in extended area as
Row dimension, will collection form in itself the dimension such as unit, period as food slicer dimension；Multidimensional model secondary operation, rejects useless
Dimensional information；MDX is performed by OLAP engines to inquire about；Perform extended area extension；Perform data filling.
According to a further aspect of the invention, it is also proposed that a kind of form acquisition method based on OLAP, including：Step
202：Selection includes service profile, accounting period, measurement, the business operation of data source, according to the business operation information of selection
Quickly generate multidimensional model；Step 204：Based on the multidimensional model that the step 202 builds, multidimensional mould is carried out by pulling mode
The mapping area of the generation in type and form region, mapping area is converted into multi-dimensional query sentence carries out multi-dimensional query, and will look into
Result set is ask to be filled into form.In the technical scheme, the rapid build multidimensional model by way of service-oriented, by many
Dimension module with collection form area maps mode, by data extract collection form in, can reduce multidimensional model structure answer
Miscellaneous degree.Mapping settings, the mapping relations generation mapping area according to mapping settings；Step 206：Based on the step 204
In the above-mentioned technical solutions, it is preferable that the step 202, specifically include：Selection includes service profile, accounting period
Between, measurement and data source business operation；The business operation of above-mentioned selection is obtained, multidimensional is built based on the business operation for obtaining
Model.
In the above-mentioned technical solutions, it is preferable that the operation that multidimensional model is built based on the business operation for obtaining, specifically
Including：Service profile generation dimension in the business operation, and automatically generate the level and rank of dimension；The business
The corresponding data table of archives constitutes dimension table, and the value on the Major key dimension of service profile, the name-value of service profile is constituted
Show value in dimension；Accounting period generation time dimension in the business operation, and generate the multiple of time dimension
Rank；Measurement generation measurement in the business operation；Service profile, measurement and data in the business operation
Source, the true table of generation；The dimension, time dimension, measurement and true table according to generation, generate cube.
In the above-mentioned technical solutions, it is preferable that the step 204, specifically include：Obtain build the multidimensional model and
Pre-defined collection form, by pulling mode to obtain the multidimensional model and with it is described collection form it is corresponding
The mapping relations in form region are configured；Based on the mapping relations for setting, mapping area is generated.
In the above-mentioned technical solutions, it is preferable that it is described by pulling mode to obtain the multidimensional model and with institute
The operation that the mapping relations in the corresponding form region of collection form are configured is stated, is specifically included：Pull the dimension of multidimensional model
Member and measurement are fixed mapping area to the left side or top of the memory cell for pre-setting；Pull the dimension of multidimensional model
, to the top of the memory cell for pre-setting, be expanded mapping area for degree member and measurement；By it is described extension mapping area with
Dimension is mapped in multidimensional model, and the dimension is to extend the foundation that mapping area is extended；And, it is described based on described
The mapping relations that mapping settings module is set, generate the operation of mapping area, specifically include：Obtain the mapping relations that set and pre-
The set of all memory cell for first setting；An index cell is chosen from the set of all memory cell corresponding
Memory cell, chooses the ranks dimension of memory cell mapping from the mapping relations, and verifies whether the ranks dimension closes
Method：If legal, already present mapping area list is obtained, and judge whether for the mapping area list to be added to existing reflecting
Penetrate region：If adding, respective memory unit is added into mapping area and regional extent is regenerated；If being added without, generate
New mapping area, adds the corresponding mapping area list in the new mappings region；If illegal, judge whether that all traversal is deposited
Storage unit；If all traversal, terminates the operation of this generation mapping area；If not traveling through all, from all storages
The corresponding memory cell of next index cell is chosen in the set of unit to be processed；And/or, it is described to turn mapping area
Being changed to multi-dimensional query sentence carries out multi-dimensional query, and query resultses are filled into the operation in form, specifically includes calculating solid
The operation for determining region and the operation for calculating extended area, wherein：The operation for calculating FX, specifically includes：According to reflecting
The rule of classification whether corresponding row dimension in region or row dimension match completely is penetrated, mapping area is grouped, and by group
Carry out data extraction；In the rule of classification, if row dimension is matched completely, by row dimension during splicing multi-dimensional query sentence
It is extended；If row dimension is matched completely, just row dimension is extended during splicing multi-dimensional query sentence；It is described to enter by group
The operation that row data are extracted, specifically includes：Multiple mapping areas merge into a computing unit；Splicing multi-dimensional query sentence：Will
Mapping area is mapped in dimension in rows and columns as axle dimension, will collection form in itself the dimension such as unit, period as section
Device dimension；Multidimensional model secondary operation, rejects useless dimensional information；MDX is performed by OLAP engines to inquire about；Query Result is pressed
Mapping area is split；Perform data filling；The operation for calculating extended area, specifically includes：In acquirement extended area
The dimension of mapping；Splicing multi-dimensional query sentence：Mapping area is mapped in the dimension on row as row dimension, by extended area
All member's dimensions of mapping as row dimension, will collection form in itself the dimension such as unit, period as food slicer dimension；Multidimensional
Model secondary operation, rejects useless dimensional information；MDX is performed by OLAP engines to inquire about；Perform extended area extension；Perform number
According to filling.
By above technical scheme, on the basis of existing form acquisition mode single pair of image data can be made full use of complete
Form into many object datas is gathered, and sets up general, the system that are gathered towards dispersion, independent data form that many object datas are participated in
One collection thinking.
Brief description of the drawings
Fig. 1 shows the block diagram of the form harvester based on OLAP according to an embodiment of the invention；
Fig. 2 shows the flow chart of the form acquisition method based on OLAP according to an embodiment of the invention；
Fig. 3 shows the principle schematic of the form harvester based on OLAP according to an embodiment of the invention；
Fig. 4 shows the principle schematic of Multidimensional Data Model example according to an embodiment of the invention；
Fig. 5 shows that the ranks dimension that memory cell mapping is obtained according to an embodiment of the invention from mapping relations is shown
The principle schematic of example；
Fig. 6 shows the flow chart of mapping area generation module according to an embodiment of the invention；
Fig. 7 shows the flow chart that data are extracted according to an embodiment of the invention；
Fig. 8 shows and passes through multidimensional model rapid build module construction multidimensional model example according to an embodiment of the invention
Figure；
Fig. 9 shows the setting mapping relations exemplary plot according to an embodiment of the invention in mapping settings module；
Figure 10 is shown and shown by multidimensional model rapid build module construction multidimensional model according to an embodiment of the invention
Illustration；
Figure 11 shows and extract data instance figure by data extraction module according to an embodiment of the invention；
Figure 12 shows balance sheet Mapping Examples figure according to an embodiment of the invention；
Figure 13 shows credit and debt detail list Mapping Examples figure internal according to an embodiment of the invention.
Specific embodiment
It is below in conjunction with the accompanying drawings and specific real in order to be more clearly understood that the above objects, features and advantages of the present invention
Mode is applied to be further described in detail the present invention.It should be noted that in the case where not conflicting, the implementation of the application
Feature in example and embodiment can be mutually combined.
Many details are elaborated in the following description in order to fully understand the present invention, but, the present invention may be used also
Implemented with being different from other modes described here using other, therefore, protection scope of the present invention is not by described below
Specific embodiment limitation.
Fig. 1 shows the block diagram of the form harvester based on OLAP according to an embodiment of the invention.
As shown in figure 1, the form harvester 100 of OLAP is based on according to an embodiment of the invention, including：Multidimensional model
Rapid build module 102, for the business operation for selecting to include service profile, accounting period, measurement, data source, according to choosing
The business operation information selected quickly generates multidimensional model；Multidimensional model and form area map module 104, for based on multidimensional mould
The multidimensional model of type rapid build module construction, the mapping settings of multidimensional model and form region, root are carried out by pulling mode
Mapping area is generated according to the mapping relations of mapping settings；Data extraction module 106, for being reflected with form region based on multidimensional model
The mapping area of module generation is penetrated, mapping area is converted into multi-dimensional query sentence carries out multi-dimensional query, and by query resultses
It is filled into form.In the technical scheme, the rapid build multidimensional model by way of service-oriented, by multidimensional model with
Collection form area maps mode, by data extract collection form in, can reduce multidimensional model structure complexity.
In the above-mentioned technical solutions, it is preferable that multidimensional model rapid build module 102, specifically include：Interface sets mould
Block, for selecting the business operation comprising service profile, accounting period, measurement and data source；Multidimensional model builds module, uses
In the business operation for obtaining the selection of interface setup module, multidimensional model is built based on the business operation for obtaining.
In the above-mentioned technical solutions, it is preferable that multidimensional model builds the business operation structure multidimensional mould that module is based on obtaining
The operation of type, specifically includes：Service profile generation dimension in business operation, and automatically generate the level and level of dimension
Not；The corresponding data table of service profile constitutes dimension table, the value on the Major key dimension of service profile, the title of service profile
Show value on value dimension；Accounting period generation time dimension in business operation, and generate many of time dimension
Individual rank；Measurement generation measurement in business operation；Service profile, measurement and data source in business operation,
The true table of generation；Dimension, time dimension, measurement and true table according to generation, generate cube.
In the above-mentioned technical solutions, it is preferable that multidimensional model and form area map module 104, specifically include：Mapping sets
Module is put, multidimensional model and pre-defined collection form for obtaining multidimensional model rapid build module construction, by dragging
Multidimensional model and the mapping relations in collection form corresponding form region of the mode to obtaining is dragged to be configured；Map section
Domain generation module, for the mapping relations set based on mapping settings module, generates mapping area.
In the above-mentioned technical solutions, it is preferable that mapping settings module by pulling mode to obtain multidimensional model and
The operation that the mapping relations in form region corresponding with collection form are configured, specifically includes：Pull the dimension of multidimensional model
Member and measurement are fixed mapping area to the left side or top of the memory cell for pre-setting；Pull the dimension of multidimensional model
, to the top of the memory cell for pre-setting, be expanded mapping area for degree member and measurement；Mapping area and multidimensional will be extended
Dimension is mapped in model, and dimension is to extend the foundation that mapping area is extended；And, mapping area generation module is based on
The mapping relations that mapping settings module is set, generate the operation of mapping area, specifically include：Obtain setting in mapping settings module
Mapping relations and the set of all memory cell that pre-sets；An index list is chosen from the set of all memory cell
The corresponding memory cell of first lattice, chooses the ranks dimension of memory cell mapping from mapping relations, and verifies the ranks dimension
It is whether legal：If legal, already present mapping area list is obtained, and judge whether to be added to the mapping area list
Some mapping areas：If adding, respective memory unit is added into mapping area and regional extent is regenerated；If being added without,
New mapping area is then generated, the corresponding mapping area list in the new mappings region is added；If illegal, judge whether whole
Traversal memory cell；If all traversal, terminates the operation of this generation mapping area；If not traveling through all, deposited from all
The corresponding memory cell of next index cell is chosen in the set of storage unit to be processed；And/or, data extraction module
Mapping area is converted to multi-dimensional query sentence by 106 carries out multi-dimensional query, and query resultses are filled into the operation in form,
The operation for calculating FX and the operation for calculating extended area are specifically included, wherein：Calculate the operation of FX, including root
According to the rule of classification whether corresponding row dimension of mapping area or row dimension match completely, mapping area is grouped, and
Data extraction is carried out by group；In rule of classification, if row dimension is matched completely, by row dimension during splicing multi-dimensional query sentence
It is extended；If row dimension is matched completely, just row dimension is extended during splicing multi-dimensional query sentence；Enter line number by group
According to the operation extracted, specifically include：Multiple mapping areas merge into a computing unit；Splicing multi-dimensional query sentence：Will mapping
Dimension of the area maps in rows and columns used as axle dimension, using collection form, as food slicer tie up in itself by the dimension such as unit, period
Degree；Multidimensional model secondary operation, rejects useless dimensional information；MDX is performed by OLAP engines to inquire about；By Query Result by mapping
Region is split；Perform data filling；The operation of extended area is calculated, is specifically included：Obtain the dimension mapped in extended area
Degree；Splicing multi-dimensional query sentence：Mapping area is mapped in the dimension on arranging as row dimension, the institute that will be mapped in extended area
Have member's dimension as row dimension, will collection form in itself the dimension such as unit, period as food slicer dimension；Multidimensional model is secondary
Processing, rejects useless dimensional information；MDX is performed by OLAP engines to inquire about；Perform extended area extension；Perform data filling.
Fig. 2 shows the flow chart of the form acquisition method based on OLAP according to an embodiment of the invention.
As shown in Fig. 2 the form acquisition method of OLAP is based on according to an embodiment of the invention, including：Step 202：Choosing
Select comprising service profile, accounting period, measurement, data source business operation, according to selection the fast fast-growing of business operation information
Into multidimensional model；Step 204：Based on the multidimensional model that step 202 builds, multidimensional model and report band are carried out by pulling mode
The mapping area of the generation in domain, mapping area is converted into multi-dimensional query sentence carries out multi-dimensional query, and query resultses are filled out
It is charged in form.In the technical scheme, the rapid build multidimensional model by way of service-oriented, by multidimensional model with adopt
Newspaper collecting table section mapping mode, by data extract collection form in, can reduce multidimensional model structure complexity.Mapping sets
Put, the mapping relations generation mapping area according to mapping settings；Step 206：Based on step 204
In the above-mentioned technical solutions, it is preferable that step 202, specifically include：Selection includes service profile, accounting period, degree
The business operation of amount and data source；The business operation of above-mentioned selection is obtained, multidimensional model is built based on the business operation for obtaining.
In the above-mentioned technical solutions, it is preferable that the operation of multidimensional model, specific bag are built based on the business operation for obtaining
Include：Service profile generation dimension in business operation, and automatically generate the level and rank of dimension；The correspondence of service profile
Tables of data constitutes dimension table, and the value on the Major key dimension of service profile is aobvious on the name-value dimension of service profile
Indicating value；Accounting period generation time dimension in business operation, and generate multiple ranks of time dimension；Grasped according to business
Measurement generation measurement in work；Service profile, measurement and data source in business operation, the true table of generation；According to life
Into dimension, time dimension, measurement and true table, generate cube.
In the above-mentioned technical solutions, it is preferable that step 204, specifically include：Obtain the multidimensional model of structure and pre-define
Collection form, closed to the multidimensional model that obtains and with the mapping in the corresponding form region of collection form by pulling mode
System is configured；Based on the mapping relations for setting, mapping area is generated.
In the above-mentioned technical solutions, it is preferable that by pulling mode to obtain multidimensional model and with collection form pair
The operation that the mapping relations in the form region answered are configured, specifically includes：The dimension member and measurement for pulling multidimensional model are arrived
The left side or top of the memory cell for pre-setting, are fixed mapping area；Pull the dimension member and measurement of multidimensional model
To the top of the memory cell for pre-setting, be expanded mapping area；Extension mapping area is entered with dimension in multidimensional model
Row mapping, dimension is to extend the foundation that mapping area is extended；And, based on the mapping relations that mapping settings module is set,
The operation of mapping area is generated, is specifically included：Obtain the set of the mapping relations for setting and all memory cell for pre-setting；
The corresponding memory cell of one index cell of selection, chooses the storage from mapping relations from the set of all memory cell
The ranks dimension of unit mapping, and whether verify the ranks dimension legal：If legal, already present mapping area row are obtained
Table, and judge whether for the mapping area list to be added to existing mapping area：If adding, respective memory unit is added
Mapping area simultaneously regenerates regional extent；If being added without, new mapping area is generated, add the new mappings region corresponding
Mapping area list；If illegal, judge whether all traversal memory cell；If all traversal, terminates this generation and reflects
Penetrate the operation in region；If not traveling through all, next index cell is chosen from the set of all memory cell corresponding
Memory cell is processed；And/or, mapping area is converted into multi-dimensional query sentence carries out multi-dimensional query, and by Query Result
Collection is filled into the operation in form, specifically includes the operation for calculating FX and the operation for calculating extended area, wherein：Calculate
The operation of FX, specifically includes：According to the packet whether corresponding row dimension of mapping area or row dimension match completely
Rule, mapping area is grouped, and carries out data extraction by group；In rule of classification, if row dimension is matched completely,
Row dimension is extended during splicing multi-dimensional query sentence；If row dimension is matched completely, during splicing multi-dimensional query sentence just
Row dimension is extended；The operation of data extraction is carried out by group, is specifically included：Multiple mapping areas merge into one and calculate single
Unit；Splicing multi-dimensional query sentence：Mapping area is mapped in the dimension in rows and columns as axle dimension, collection form is single in itself
The dimensions such as position, period are used as food slicer dimension；Multidimensional model secondary operation, rejects useless dimensional information；Held by OLAP engines
Row MDX is inquired about；Query Result is split by mapping area；Perform data filling；Calculate the operation of extended area, specific bag
Include：Obtain the dimension mapped in extended area；Splicing multi-dimensional query sentence：Mapping area is mapped in the dimension on arranging as row
Dimension, all member's dimensions that will be mapped in extended area used as row dimension, by collection form, make in itself by the dimension such as unit, period
It is food slicer dimension；Multidimensional model secondary operation, rejects useless dimensional information；MDX is performed by OLAP engines to inquire about；Perform expansion
Exhibition section domain extends；Perform data filling.
For example, as shown in figure 3, technical solution of the present invention automatically processes process, main three portions for including being equipped with
Point：Multidimensional model rapid build module, multidimensional model and form area map module, data extraction module.It is described as follows：
(i) multidimensional model rapid build module
Multidimensional model rapid build module completes the rapid build of multidimensional model, and it is divided into again：Interface setup module, multidimensional
Model construction module.The business operations such as selection service profile, accounting period, measurement, data source are carried out in the setup module of interface,
Multidimensional model builds information of the module in the setup module of interface to quickly generate multidimensional model.
The operating process of interface setup module is as follows：(1) service profile is selected；(2) accounting period is selected；(3) selected metric；
(4) data source is selected.
As shown in figure 4, the operating process that multidimensional model builds module is as follows：(1) the business shelves in the setup module of interface are obtained
The information such as case, accounting period, measurement, data source；(2) according to the information architecture multidimensional model for obtaining：1. dimensional information is generated；
Service profile according to selection generates dimension, and automatically generates the level and rank of dimension；Dimension table is the corresponding data of this archives
Table, the value in dimension is the Major key of this archives, and the show value in dimension is the name-value of this archives；2. time dimension is generated；
Time dimension is generated according to accounting period, and generates multiple ranks of time dimension；3. generation is measured；4. true table is generated；Root
According to the service profile of selection, measurement and the true table of data source generation；5. cube is generated.
(ii) multidimensional model and form area map module
Multidimensional model completes the mapping of multidimensional model and form region with form area map module, and it is divided into again：Mapping
Setup module, mapping area generation module.Mapping settings module is a kind of interface module, and multidimensional model rapid build is obtained first
The multidimensional model of module construction, then carries out the mapping settings of multidimensional model and form region by pulling mode；Mapping area
Generation module is a kind of background process device, and mapping area is generated according to the mapping relations set in mapping settings module.
The operating process of mapping settings module is as follows：(1) the multidimensional model of multidimensional model rapid build module construction is obtained；
(2) defined collection form is obtained；(3) the mapping settings of multidimensional model and form region is carried out：
1. FX：The dimension member and measurement for pulling multidimensional model arrive the left side or top of memory cell.2. extend
Region：The dimension member and measurement for pulling multidimensional model arrive the top of memory cell；By dimension in extended area and multidimensional model
Mapping, the foundation that this dimension is extended as expansion area.
As shown in fig. 6, the operating process of mapping area generation module is as follows：
(1) the mapping relations set in mapping settings module are obtained；(2) all memory cell set are obtained；(3) from set
Take a memory cell；(4) as shown in figure 5, obtaining the ranks dimension of memory cell mapping from mapping relations：1. row dimension：From
Row dimension is searched to the left in this memory cell position；2. row dimension：Row dimension is searched upwards from this memory cell position；(5) verification is reflected
Whether the ranks dimension penetrated is legal：1. it is：(6) walked to；2. it is no：(8) walked to；(6) existing mapping area list is obtained；⑺
Whether existing mapping area can be added to：1. it is：This memory cell is added into mapping area and regional extent is regenerated；②
It is no：The new mapping area of generation, adds mapping area list；(8) whether memory cell is all traveled through：1. it is：Generation mapping area
Terminate；2. it is no：To the (3) step take next index cell treatment.
(iii) data extraction module
Data extraction module obtains the mapping area of multidimensional model and generation in form area map module first, will map
Region is converted to multi-dimensional query sentence and carries out multi-dimensional query, and query resultses are filled into form.
The operating process of data extraction module is as follows：
(1) the mapping area of multidimensional model and generation in form area map module is obtained；(2) FX is calculated：
1. mapping area is grouped
a）Rule of classification：The corresponding row dimension of mapping area or row dimension are matched completely；If row dimension is matched completely,
Row dimension can be just extended when then splicing multi-dimensional query sentence；If row dimension is matched completely, splice multi-dimensional query
Row dimension can be just extended during sentence.
2. data extraction is carried out by group, as shown in Figure 7：
a）Multiple mapping areas merge into a computing unit；b）Splicing multi-dimensional query sentence：Mapping area is mapped in
Dimension in rows and columns as axle dimension, will collection form in itself the dimension such as unit, period as food slicer dimension；c）Multidimensional mould
Type secondary operation, rejects useless dimensional information；d）MDX is performed by OLAP engines to inquire about；e）Query Result is pressed into mapping area
Split；f）Perform data filling；
(3) extended area is calculated；
1. the dimension mapped in extended area is obtained；2. multi-dimensional query sentence is spliced：a）Mapping area is mapped on row
Dimension as axle（Row）Dimension；b）The dimension that will be mapped in extended area（All members）As axle（OK）Dimension；c）To adopt
Collection form in itself the dimension such as unit, period as food slicer dimension；3. multidimensional model secondary operation, rejects useless dimensional information；
4. MDX is performed by OLAP engines to inquire about；5. extended area extension is performed；6. data filling is performed.
And for example, the realization of technical solution of the present invention flows into as follows：
(1), by multidimensional model rapid build module construction multidimensional model, example is as shown in Figure 8.
(2) mapped with form area map module by multidimensional model：
1. mapping relations are set in mapping settings module：As shown in figure 9, the cell with words identification represents setting
Dimension member or measurement, with ' 123 ' mark cell represent memory cell.
2. by generating mapping area in mapping area generation module：As shown in Figure 10, memory cell set is obtained：[B4,
C4, D4, E4, B5, C5, D5, E5], according to generation mapping area principle, ultimately generate two mapping areas：B4:C5、E4:E5.
(3) data are extracted by data extraction module：As shown in figure 11, by B4:C5、E4:E5 mapping areas merge, splicing
MDX statement, performs MDX and inquires about by OLAP engines, represents after Query Result is filled.
For another example, the balance sheet Mapping Examples using technical solution of the present invention are as shown in figure 12, and internal credit and debt is bright
Thin table Mapping Examples are as shown in figure 13.
Technical scheme, based on a large amount of dispersions, the independent data that exist by enterprise, rapid build multidimensional mould
Type, and data are extracted into collection form by the way that multidimensional engine is quick.Using technical scheme, on the one hand will be scattered
Data have carried out quick integration and extraction；On the other hand also enhancing collection form carries out the mode of data acquisition.It is of the invention
Technical scheme difference with the prior art part：
(1) existing report data collection technology is, based on formula, storing process, to set formula and foundation was stored mostly
Journey workload is big, difficulty is high, and cannot be integrated for the data of dispersion storage.And technical scheme can be to existing
Scattered data are integrated, and the data after integration are extracted into collection form using multi-dimensional query technology；Furthermore, the present invention
Technical scheme than traditional setting formula, to set up the modes such as storing process easy to use, can largely reduce report data collection
Workload is set；
(2) the existing product based on OLAP technologies primarily focuses on statement analysis, and multidimensional technology and concept are exposed
The complexity of multidimensional model is built increased.And structure multidimensional model to have been done technical scheme the envelope of service-oriented
Dress, multidimensional model is quickly generated based on business operation, and can be applied in form collection by multidimensional model and multidimensional technology
Row data acquisition, reduces the structure complexity of multidimensional model, and enhances the mode of report data collection.
Technical scheme, can be applied in form product, by the method independent data will be disperseed quickly to carry
Get collection form.Technical scheme, having the special feature that is：(1) the rapid build multidimensional mould by way of service-oriented
Type, no longer the technology and concept that multidimensional model is related to is exposed, it is only necessary to completed by carrying out simple business operation
Multidimensional model builds；The complexity of multidimensional model structure can be reduced；(2) by multidimensional model and collection form area maps side
Formula, by data extract collection form in；Can cause that multidimensional model is no longer used only for analysis, and can be used for form and adopt
Collection.
Technical scheme is described in detail above in association with accompanying drawing, it is contemplated that there is no simplicity, system in correlation technique
One solution for the collection of many object data forms.Existing form collection cannot complete dispersion, independent data ginseng
With form gatherer process.Therefore, the present invention proposes a kind of form harvester based on OLAP and a kind of based on OLAP's
Form acquisition method, can make full use of single pair of image data to complete many object datas on the basis of existing form acquisition mode
Form collection, set up that many object datas participate in towards dispersion, general, the unified collection thinking of independent data form collection.
The preferred embodiments of the present invention are the foregoing is only, is not intended to limit the invention, for the skill of this area
For art personnel, the present invention can have various modifications and variations.It is all within the spirit and principles in the present invention, made any repair
Change, equivalent, improvement etc., should be included within the scope of the present invention.
Claims (8)
1. a kind of form harvester based on OLAP, it is characterised in that including：
Multidimensional model rapid build module, specifically includes：Interface setup module and multidimensional model build module, and the interface is set
Module is used to select the business operation comprising service profile, accounting period, measurement and data source, the multidimensional model to build mould
Block, the business operation for obtaining the interface setup module selection, multidimensional model is built based on the business operation for obtaining；
Multidimensional model and form area map module, specifically include：Mapping settings module and mapping area generation module, it is described to reflect
Setup module is penetrated for obtaining the multidimensional model and pre-defined collection form of the multidimensional model rapid build module construction,
The multidimensional model and the mapping relations in form region corresponding with the collection form that obtain are entered by pulling mode
Row is set, the mapping area generation module, for the mapping relations set based on the mapping settings module, generates map section
Domain；
Data extraction module, specifically includes：The operation for calculating FX and the operation for calculating extended area, the calculating are fixed
Whether the operation in region, including the rule of classification matched completely according to the corresponding row dimension of mapping area or row dimension, will reflect
Penetrate region to be grouped, and data extraction is carried out by group, the operation of the calculating extended area is specifically included：Obtain expansion area
The dimension mapped in domain；Splicing multi-dimensional query sentence, multidimensional model secondary operation rejects useless dimensional information；Drawn by OLAP
Hold up execution MDX inquiries；Perform extended area extension；Perform data filling.
2. the form harvester based on OLAP according to claim 1, it is characterised in that the multidimensional model builds
Module is based on the operation of the business operation structure multidimensional model for obtaining, and specifically includes：
Service profile generation dimension in the business operation, and automatically generate the level and rank of dimension；The business
The corresponding data table of archives constitutes dimension table, and the value on the Major key dimension of service profile, the name-value of service profile is constituted
Show value in dimension；
Accounting period generation time dimension in the business operation, and generate multiple ranks of time dimension；
Measurement generation measurement in the business operation；
Service profile, measurement and data source in the business operation, the true table of generation；
The dimension, time dimension, measurement and true table according to generation, generate cube.
3. the form harvester based on OLAP according to claim 1, it is characterised in that the mapping settings module
Specifically include：
The dimension member and measurement of multidimensional model are pulled to the left side of the memory cell for pre-setting, mapping area is fixed；
The dimension member and measurement of multidimensional model are pulled to the top of the memory cell for pre-setting, be expanded mapping area；By institute
State extension mapping area to be mapped with dimension in multidimensional model, the dimension is to extend the foundation that mapping area is extended；
And, the mapping area generation module base is specifically included：
Obtain the set of the mapping relations for setting and all memory cell for pre-setting in the mapping settings module；
The corresponding memory cell of one index cell of selection from the set of all memory cell, from the mapping relations
The middle ranks dimension for choosing memory cell mapping, and whether verify the ranks dimension legal：
If legal, already present mapping area list is obtained, and judge whether to be added to the mapping area list existing
Mapping area：If adding, respective memory unit is added into mapping area and regional extent is regenerated；If being added without, give birth to
The mapping area of Cheng Xin, adds the corresponding mapping area list in the new mappings region；
If illegal, judge whether all traversal memory cell；If all traversal, terminates this behaviour for generating mapping area
Make；If not traveling through all, the corresponding storage of next index cell is chosen from the set of all memory cell single
Unit is processed.
4. the form harvester based on OLAP according to claim 1, it is characterised in that
In the rule of classification, if row dimension is matched completely, row dimension is extended during splicing multi-dimensional query sentence；Such as
Fruit row dimension is matched completely, then be just extended row dimension when splicing multi-dimensional query sentence；
The operation that data extraction is carried out by group, specifically includes：Multiple mapping areas merge into a computing unit；Splicing is more
Dimension query statement：Mapping area is mapped in dimension in rows and columns as axle dimension, will collection form unit and period in itself
Dimension is used as food slicer dimension；Multidimensional model secondary operation, rejects useless dimensional information；MDX is performed by OLAP engines to look into
Ask；Query Result is split by mapping area；Perform data filling；
The splicing multi-dimensional query sentence includes：Mapping area is mapped in the dimension on row as row dimension, by extended area
All member's dimensions of middle mapping as row dimension and will collection form in itself the dimension such as unit, period as food slicer dimension.
5. a kind of form acquisition method based on OLAP, it is characterised in that including：
Step 202：Selection includes service profile, accounting period, measurement, the business operation of data source, obtains above-mentioned selection
Business operation, multidimensional model is built based on the business operation for obtaining；
Step 204：Based on the step 202 build multidimensional model, by pulling mode to obtain the multidimensional model,
And the mapping relations in form region corresponding with the collection form are configured, the mapping area generation module is used for
Based on the mapping relations that the mapping settings module is set, mapping area is generated；
Step 206：Based on the mapping area of the step 204 generation, mapping area is converted into multi-dimensional query sentence is carried out
Multi-dimensional query, and query resultses are filled into form, specifically include the operation and calculating extended area for calculating FX
Operation, the operation of the calculating FX, including whether complete according to the corresponding row dimension of mapping area or row dimension
The rule of classification of matching, mapping area is grouped, and carries out data extraction by group, the operation of the calculating extended area,
Specifically include：Obtain the dimension mapped in extended area；Splicing multi-dimensional query sentence, multidimensional model secondary operation is rejected useless
Dimensional information；MDX is performed by OLAP engines to inquire about；Perform extended area extension；Perform data filling.
6. the form acquisition method based on OLAP according to claim 5, it is characterised in that described based on the industry for obtaining
Business operation builds the operation of multidimensional model, specifically includes：
Service profile generation dimension in the business operation, and automatically generate the level and rank of dimension；The business
The corresponding data table of archives constitutes dimension table, and the value on the Major key dimension of service profile, the name-value of service profile is constituted
Show value in dimension；
Accounting period generation time dimension in the business operation, and generate multiple ranks of time dimension；
Measurement generation measurement in the business operation；
Service profile, measurement and data source in the business operation, the true table of generation；
The dimension, time dimension, measurement and true table according to generation, generate cube.
7. the form acquisition method based on OLAP according to claim 5, it is characterised in that described by pulling mode
The behaviour being configured to the multidimensional model and the mapping relations in form region corresponding with the collection form that obtain
Make, specifically include：
The dimension member and measurement of multidimensional model are pulled to the left side of the memory cell for pre-setting, mapping area is fixed；
The dimension member and measurement of multidimensional model are pulled to the top of the memory cell for pre-setting, be expanded mapping area；By institute
State extension mapping area to be mapped with dimension in multidimensional model, the dimension is to extend the foundation that mapping area is extended；
And,
The mapping relations set based on the mapping settings module, generate the operation of mapping area, specifically include：
Obtain the set of the mapping relations for setting and all memory cell for pre-setting；
The corresponding memory cell of one index cell of selection from the set of all memory cell, from the mapping relations
The middle ranks dimension for choosing memory cell mapping, and whether verify the ranks dimension legal：
If legal, already present mapping area list is obtained, and judge whether to be added to the mapping area list existing
Mapping area：If adding, respective memory unit is added into mapping area and regional extent is regenerated；If being added without, give birth to
The mapping area of Cheng Xin, adds the corresponding mapping area list in the new mappings region；
If illegal, judge whether all traversal memory cell；If all traversal, terminates this behaviour for generating mapping area
Make；If not traveling through all, the corresponding storage of next index cell is chosen from the set of all memory cell single
Unit is processed.
8. the form acquisition method based on OLAP according to claim 5, it is characterised in that
In the rule of classification, if row dimension is matched completely, row dimension is extended during splicing multi-dimensional query sentence；Such as
Fruit row dimension is matched completely, then be just extended row dimension when splicing multi-dimensional query sentence；
The operation that data extraction is carried out by group, specifically includes：Multiple mapping areas merge into a computing unit；Splicing is more
Dimension query statement：Mapping area is mapped in dimension in rows and columns as axle dimension, will collection form unit and period in itself
Dimension is used as food slicer dimension；Multidimensional model secondary operation, rejects useless dimensional information；MDX is performed by OLAP engines to look into
Ask；Query Result is split by mapping area；Perform data filling；
The splicing multi-dimensional query sentence includes：Mapping area is mapped in the dimension on row as row dimension, by extended area
All member's dimensions of middle mapping as row dimension and will collection form in itself the dimension such as unit, period as food slicer dimension.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310681731.2A CN103678590B (en) | 2013-12-12 | 2013-12-12 | Report collecting device and report collecting method based on OLAP |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310681731.2A CN103678590B (en) | 2013-12-12 | 2013-12-12 | Report collecting device and report collecting method based on OLAP |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103678590A CN103678590A (en) | 2014-03-26 |
| CN103678590B true CN103678590B (en) | 2017-05-24 |
Family
ID=50316135
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310681731.2A Active CN103678590B (en) | 2013-12-12 | 2013-12-12 | Report collecting device and report collecting method based on OLAP |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103678590B (en) |
Families Citing this family (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103955502B (en) * | 2014-04-24 | 2017-07-28 | 科技谷（厦门）信息技术有限公司 | A kind of visualization OLAP application realization method and system |
| CN104361137A (en) * | 2014-12-10 | 2015-02-18 | 用友软件股份有限公司 | Device and method for generating data fetching conditions of report form |
| CN104965886B (en) * | 2015-06-16 | 2019-01-29 | 广州市勤思网络科技有限公司 | Data dimension processing method |
| CN105159876A (en) * | 2015-09-24 | 2015-12-16 | 四川长虹电器股份有限公司 | CAS-based method for sorting report elements and determining report modeling structure |
| CN107632971B (en) * | 2016-07-19 | 2020-12-15 | 百度在线网络技术（北京）有限公司 | Method and device for generating multidimensional report |
| CN106372114B (en) * | 2016-08-23 | 2019-09-10 | 电子科技大学 | A kind of on-line analysing processing system and method based on big data |
| CN106682064B (en) * | 2016-11-03 | 2020-02-11 | 用友网络科技股份有限公司 | Data acquisition device and method for enterprise report |
| CN107229730A (en) * | 2017-06-08 | 2017-10-03 | 北京奇虎科技有限公司 | Data query method and device |
| CN107861998B (en) * | 2017-10-19 | 2020-05-15 | 用友网络科技股份有限公司 | Business data importing method and device and computer equipment |
| CN110633267B (en) * | 2019-09-29 | 2023-09-29 | 浪潮通用软件有限公司 | Method and system capable of supporting multi-service report function |
| CN111401014A (en) * | 2020-03-12 | 2020-07-10 | 山东浪潮通软信息科技有限公司 | Multi-index multi-dimensional analysis method, system and construction method based on report |
| CN112286929B (en) * | 2020-06-08 | 2022-04-05 | 上海柯林布瑞信息技术有限公司 | Method and device for generating multi-dimensional data set and computer readable storage medium |
| CN113407587B (en) * | 2021-07-19 | 2023-10-27 | 北京百度网讯科技有限公司 | Data processing method, device and equipment for online analysis processing engine |
| CN113779160A (en) * | 2021-08-24 | 2021-12-10 | 北京元年科技股份有限公司 | Method and device for acquiring data of multidimensional database |
| CN116383262B (en) * | 2023-05-31 | 2023-08-11 | 山东英伟电子技术有限公司 | Power plant SIS system-based energy consumption data management platform |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1482432A2 (en) * | 2003-05-27 | 2004-12-01 | Cognos Incorporated | System and method of modelling of a multi-dimensional data source in an entity-relationship model |
| CN101197876A (en) * | 2006-12-06 | 2008-06-11 | 中兴通讯股份有限公司 | Method and system for multi-dimensional analysis of message service data |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020029207A1 (en) * | 2000-02-28 | 2002-03-07 | Hyperroll, Inc. | Data aggregation server for managing a multi-dimensional database and database management system having data aggregation server integrated therein |
-
2013
- 2013-12-12 CN CN201310681731.2A patent/CN103678590B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1482432A2 (en) * | 2003-05-27 | 2004-12-01 | Cognos Incorporated | System and method of modelling of a multi-dimensional data source in an entity-relationship model |
| CN101197876A (en) * | 2006-12-06 | 2008-06-11 | 中兴通讯股份有限公司 | Method and system for multi-dimensional analysis of message service data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103678590A (en) | 2014-03-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103678590B (en) | Report collecting device and report collecting method based on OLAP | |
| WO2016054908A1 (en) | Internet of things big data platform-based intelligent user profiling method and apparatus | |
| Olczyk | A systematic retrieval of international competitiveness literature: a bibliometric study | |
| CN109582667A (en) | A kind of multiple database mixing storage method and system based on power regulation big data | |
| CN102270232A (en) | Semantic data query system with optimized storage | |
| CN104679827A (en) | Big data-based public information association method and mining engine | |
| CN102073701A (en) | Semantic definition-based multi-data source data querying method | |
| CN105677549B (en) | A kind of software testing management method and system | |
| CN113064866A (en) | Power business data integration system | |
| CN101706926A (en) | Method for investigating and processing cigarette consumption information | |
| CN105260849A (en) | Scientific researcher evaluation method across social networks | |
| CN103605607B (en) | Software complexity analysis system and method | |
| CN109947880A (en) | Three-dimensional spatial information serves urban-rural integration management isomeric data fusion method | |
| CN104050291B (en) | A kind of method for parallel processing and system of account balance data | |
| CN106528756B (en) | A kind of network map data method for organizing based on space-time relationship | |
| CN115062164A (en) | Knowledge graph construction method based on multi-field information of product manufacturing process | |
| CN114064707A (en) | Data query method and device for data virtualization server and storage medium | |
| CN113254517A (en) | Service providing method based on internet big data | |
| CN103064837A (en) | Retrieval of leading figures in academic fields and visualized navigation system | |
| CN103577555A (en) | Big data analysis method based on internet of vehicles | |
| CN111160692A (en) | Multi-source information fusion evaluation and system for electric power scientific and technological achievements | |
| CN106204252A (en) | Internal credit and debt remaining sum identification, the method and system gathering and checking | |
| CN109558522A (en) | Method for building up, device and the computer readable storage medium of enterprise network figure | |
| CN102236721A (en) | Method for extracting complex window space information in space data engine | |
| CN110008239A (en) | Logic based on precomputation optimization executes optimization method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: 100094 Beijing city Haidian District North Road No. 68, UFIDA Software Park Applicant after: Yonyou Network Technology Co., Ltd. Address before: 100094 Beijing city Haidian District North Road No. 68, UFIDA Software Park Applicant before: UFIDA Software Co., Ltd. |
|
| COR | Change of bibliographic data | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |