CN104462254B - Complex region access device and method - Google Patents
Complex region access device and method Download PDFInfo
- Publication number
- CN104462254B CN104462254B CN201410671292.1A CN201410671292A CN104462254B CN 104462254 B CN104462254 B CN 104462254B CN 201410671292 A CN201410671292 A CN 201410671292A CN 104462254 B CN104462254 B CN 104462254B
- Authority
- CN
- China
- Prior art keywords
- column
- dimension
- row
- row column
- access
- 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/24—Querying
- G06F16/248—Presentation of query results
-
- 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 Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- General Health & Medical Sciences (AREA)
- Stored Programmes (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a kind of complex region access devices, including：Show sample table unit, the sample table for showing required column；Data set unit, for creating column dimension according to the definition of row column, which includes row column dimension and row column dimension；The row column and/or row column extended for needs, construction access logic, obtains data set corresponding with required column.The present invention also provides a kind of complex region access methods.Technical solution through the invention can make full use of single object type to complete the region access of more object types on the basis of existing region access mode, establish general, the unified access thinking fetched towards complex region that more object types participate in.
Description
Technical field
The present invention relates to field of computer technology, and in particular, to a kind of complex region access device and a kind of complex area
Domain access method.
Background technology
Chinese style report form is various, is a complex region of complex report forms shaped like following report, referring to Fig. 4.Fig. 4
The characteristics of middle table area is：
1) most of column is fixed formation, can be the relationship for including or including partly between column.Such as have
Two columns：All, rural migrant worker.All this column includes rural migrant worker.For example such column again：Women, rural migrant worker.
The two columns have part intersection.
2) column having is extended with data, for example, worker, engineers and technicians can be one with
The extension column of Data expansion.
Difficult point：Just because of there are These characteristics, the access SQL realizations of above-mentioned data single are become more difficult.This hair
It is bright to propose a kind of access scheme, a SQL statement may be implemented and take out result data.(certainly, also part does not influence performance
Prepare SQL).
Therefore, it is necessary to a kind of new region access technologies, can be made full use of on the basis of existing region access mode
Single object type completes the region access of more object types, and it is logical to establish fetching towards complex region for more object types participations
With, unified access thinking.
Invention content
The present invention is based on the above problem, it is proposed that a kind of new region access technology can take in existing region
On the basis of number mode, makes full use of single object type to complete the region access of more object types, establish what more object types participated in
General, unified access thinking towards complex region access.
In view of this, the present invention proposes a kind of complex region access device, including：Show sample table unit, for showing
The sample table of required column；Data set unit, for creating column dimension according to the definition of row column, which includes row column
Mesh dimension and row column dimension；The row column and/or row column extended for needs, construction access logic, obtains and required column
The corresponding data set of mesh.In the technical scheme, the complex region access that can once read analysis data, can be in complexity
High efficiency data acquisition is realized in report region.
In the above-mentioned technical solutions, it is preferable that the data set unit specifically includes：Column dimension creation module, is used for
Column dimension is created according to the definition of row column；Access logical building block, row column and/or row for being extended for needs
Column, construction access logic, obtains data set corresponding with required column.In the technical scheme, because dimension table data volume is small,
Therefore all inquiries can be put into a dimension table, and this dimension table can use the common table created in advance, reduction to make every time
With the expense for creating interim table.
In the above-mentioned technical solutions, it is preferable that the column dimension that the column dimension creation module creates, including row column
Dimension and row column dimension.
In the above-mentioned technical solutions, it is preferable that the column dimension creation module creates the operation of column dimension, specific to wrap
It includes：According to user demand, row column dimension table and row column dimension table is respectively created.
In the above-mentioned technical solutions, it is preferable that the column for showing sample table unit and showing sample table, including only fixed hurdle
Mesh, without extension column, stationary column and extension column.
According to a further aspect of the invention, it is also proposed that a kind of complex region access method, including：Step 202：Show
The sample table of required column；Step 204：Column dimension is created according to the definition of row column, which includes row column dimension
With row column dimension；The row column and/or row column extended for needs, construction access logic, obtains corresponding with required column
Data set.In the technical scheme, the complex region access that can once read analysis data, can be in complex report forms region
Middle realization high efficiency data acquisition.
In the above-mentioned technical solutions, it is preferable that the step 204 specifically includes：Step 302：According to the definition of row column
Create column dimension；Step 304：For the row column that extends of needs and/or row column, construction access logic, obtain with it is required
The corresponding data set of column.In the technical scheme, because dimension table data volume is small, therefore all inquiries can be put into a dimension
In table, and this dimension table can use the common table created in advance, reduce every time using the expense for creating interim table.
In the above-mentioned technical solutions, it is preferable that the column dimension that the step 302 creates, including row column dimension and row
Column dimension.
In the above-mentioned technical solutions, it is preferable that the step 302 creates the operation of column dimension, specifically includes：According to
Row column dimension table and row column dimension table is respectively created in family demand.
In the above-mentioned technical solutions, it is preferable that the step 102 shows the column of sample table, including only stationary column, without expansion
Open up column, stationary column and extension column.
By above technical scheme, single object type can be made full use of complete on the basis of existing region access mode
It fetches at the region of more object types, establishes general, the unified access think of fetched towards complex region that more object types participate in
Road.
Description of the drawings
Fig. 1 shows the block diagram of complex region access device according to an embodiment of the invention；
Fig. 2 shows the flow charts of complex region access method according to an embodiment of the invention；
Fig. 3 shows the flow chart of data set unit according to an embodiment of the invention；
Fig. 4 shows a complex region figure of complex report forms.
Specific implementation mode
To better understand the objects, features and advantages of the present invention, below in conjunction with the accompanying drawings and specific real
Mode is applied the present invention is further described in detail.It should be noted that in the absence of conflict, the implementation of the application
Feature in example and embodiment can be combined with each other.
Many details are elaborated in the following description to facilitate a thorough understanding of the present invention, still, the present invention may be used also
To be implemented 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 complex region access device according to an embodiment of the invention.
The device 100 as shown in Figure 1, complex region according to an embodiment of the invention is fetched, including：Show sample table unit
102, the sample table for showing required column；Data set unit 104 should for creating column dimension according to the definition of row column
Column dimension includes row column dimension and row column dimension；The row column and/or row column extended for needs, construction access are patrolled
Volume, obtain data set corresponding with required column.In the technical scheme, the complex region that can once read analysis data takes
Number, can realize high efficiency data acquisition in complex report forms region.
In the above-mentioned technical solutions, it is preferable that data set unit 104 specifically includes：Column dimension creation module 1042,
For creating column dimension according to the definition of row column；Access logical building block 1044, the row column for being extended for needs
Mesh and/or row column, construction access logic, obtain data set corresponding with required column.In the technical scheme, because of dimension table
Data volume is small, therefore all inquiries can be put into a dimension table, and this dimension table can use the common table created in advance, subtract
It is few to use the expense for creating interim table every time.
In the above-mentioned technical solutions, it is preferable that the column dimension that column dimension creation module 1042 creates, including row column
Dimension and row column dimension.
In the above-mentioned technical solutions, it is preferable that column dimension creation module 1042 creates the operation of column dimension, specific to wrap
It includes：According to user demand, row column dimension table and row column dimension table is respectively created.
In the above-mentioned technical solutions, it is preferable that show the column that sample table unit 102 shows sample table, including only stationary column,
Without extension column, stationary column and extension column.
Fig. 2 shows the flow charts of complex region access method according to an embodiment of the invention.
As shown in Fig. 2, complex region access method according to an embodiment of the invention, including：Step 202：Needed for showing
The sample table of column；Step 204：Column dimension is created according to the definition of row column, which includes row column dimension and row
Column dimension；The row column and/or row column extended for needs, construction access logic, obtains number corresponding with required column
According to collection.In the technical scheme, the complex region access that can once read analysis data, can be real in complex report forms region
Existing high efficiency data acquisition.
In the above-mentioned technical solutions, it is preferable that as shown in figure 3, step 204, specifically includes：Step 302：According to row column
Definition create column dimension；Step 304：The row column and/or row column extended for needs, construction access logic, obtains
Data set corresponding with required column.In the technical scheme, because dimension table data volume is small, therefore all inquiries can be put into
In one dimension table, and this dimension table can use the common table created in advance, reduce every time using the expense for creating interim table.
In the above-mentioned technical solutions, it is preferable that the column dimension that step 302 creates, including row column dimension and row column
Dimension.
In the above-mentioned technical solutions, it is preferable that step 302 creates the operation of column dimension, specifically includes：According to user's need
It asks, row column dimension table and row column dimension table is respectively created.
In the above-mentioned technical solutions, it is preferable that step 102 shows the column of sample table, including only stationary column, without expandable bar
Mesh, stationary column and extension column.
Technical scheme of the present invention can once read the complex region access of analysis data, can be used for complex report forms area
The high efficiency of numeric field data obtains, and high efficiency data acquisition can be realized in complex report forms region.
Technical scheme of the present invention has the characteristics that：
1, the data of data source do not land and (do not create new table storage data source data)；
2, it does not repeat to read analysis data；
3, it supports to execute distinct operations to analysis data, such as：Count (distinct (personnel id)).
Two examples are given below, gradually illustrate the principle of technical solution of the present invention.
Example 1：Only stationary column, no extension column
Show sample table such as table two：
Table two：Only stationary column shows sample table
| Whole workers | Wherein:Women | Wherein：Rural migrant worker | …… | |
| It is total | ||||
| One, coal productions | ||||
| 1. coal production personnel | ||||
| Wherein:Raw coal direct labor |
Data set：
Table three：The only data set of stationary column
Protocol step：
1, column dimension, including row column dimension and row column dimension are created according to the definition of row column.1) row column is tieed up
Spend table
Four example of table, 1 row column dimension table
2) row column dimension
Five example of table, 1 row column dimension table
2, access logic
Assuming that table (or inquiry) entitled t_fact of data set, row column dimension table name tie up t_rowdim, row column
The entitled t_columndim of dimension table.
Example 2：Stationary column+extension column
On the basis of example 1, addition extension column.
Show sample table such as table four：
Four stationary columns of table+expandable bar purpose shows sample table
| Whole workers | Wherein:Women | Wherein：Rural migrant worker | …… | |
| Management position | ||||
| Engineering management post | ||||
| Technology post | ||||
| It is total | ||||
| One, coal productions | ||||
| 1. coal production personnel | ||||
| Wherein:Raw coal direct labor |
Wherein, one " whole ", " management position ", " engineering management post ", " technology post " term extension newly increased
Column --- " post "
Data set：
Three stationary columns of table+expandable bar purpose data set
Protocol step：
1, column dimension, including row column dimension and row column dimension are created according to the definition of row column.
1) row column dimension table
2) row column dimension
With " five example of table, 1 row column dimension table ".
2, construction access logic
More complicated situation, such as：Row column, which is also required to extension or ranks, has multiple extension columns, processing mode similar.
Correct access can be achieved in technical solution of the present invention.
As can be seen that technical solution of the present invention without building whole dimension table data, and the side of the whole dimension tables of structure in advance
Case compares, and the present invention has the following advantages：
1, dimension table data volume is small, can greatly reduce the time for creating dimension table data.
2, because dimension table data volume is small, therefore all inquiries can be put into a dimension table, and this dimension table can use
The common table created in advance is reduced every time using the expense for creating interim table.
3, because only there are one final access logical statement, thus execute terminate before will not be swapped out by database in
It deposits, optimum efficiency is obtained under concurrent environment.
Technical solution of the present invention verified using the data of UF HR systems, may be implemented to analyze needs
Unique primary reading of data, because access logic can also protect for database when concurrent in a SQL statement
Demonstrate,proving the data handled will not be swapped out, and best performance theoretically may be implemented.
Technical scheme of the present invention is described in detail above in association with attached drawing, it is contemplated that not easy, system in the related technology
One solution for the access of complicated type region.Existing region access can not complete the region of complicated type participation
Access process.Therefore, the present invention proposes a kind of complex region access device and a kind of complex region access method, can be existing
On the basis of some region access modes, make full use of single object type complete more object types region access, establish it is multipair as
General, the unified access thinking towards complex region access that type participates in.
The foregoing is only a preferred embodiment of the present invention, is not intended to restrict the invention, for the skill of this field
For art personnel, the invention may be variously modified and varied.All within the spirits and principles of the present invention, any made by repair
Change, equivalent replacement, improvement etc., should all be included in the protection scope of the present invention.
Claims (4)
- The device 1. a kind of complex region is fetched, which is characterized in that including：Show sample table unit, the sample table for showing required column；The column for showing sample table unit and showing sample table, including only Stationary column, without extension column, stationary column and extension column；Data set unit, for creating column dimension according to the definition of row column, which includes row column dimension and row Column dimension；The row column and/or row column extended for needs, construction access logic, obtains number corresponding with required column According to collection；The data set unit, specifically includes：Column dimension creation module, for creating column dimension according to the definition of row column；Fetch logical building block, for for the row column that extends of needs and/or row column, construction access logic, obtain with The corresponding data set of required column；The column dimension creation module creates the operation of column dimension, specifically includes：According to user demand, row column dimension table and row column dimension table is respectively created；It is put into all inquiring in a dimension table, and this dimension table is reduced and faced every time using establishment using the common table created in advance When table expense；Device makes full use of the region that single object type completes more object types to take on the basis of existing region access mode Number establishes general, the unified access thinking fetched towards complex region that more object types participate in.
- 2. a kind of complex region access method, which is characterized in that including：Step 202：Show the sample table of required column；Step 204：Column dimension is created according to the definition of row column, which includes row column dimension and row column dimension Degree；The row column and/or row column extended for needs, construction access logic, obtains data set corresponding with required column；Institute Step 204 is stated, is specifically included：Step 302：Column dimension is created according to the definition of row column；Step 304：The row column and/or row column extended for needs, construction access logic, obtains corresponding with required column Data set；It is put into all inquiring in a dimension table, and this dimension table is reduced every time using the common table created in advance using establishment The expense of interim table；On the basis of existing region access mode, single object type is made full use of to complete the area of more object types Domain is fetched, and general, the unified access thinking fetched towards complex region that more object types participate in is established.
- 3. complex region access method according to claim 2, which is characterized in that the step 302 creates column dimension Operation, specifically include：According to user demand, row column dimension table and row column dimension table is respectively created.
- 4. complex region access method according to claim 3, which is characterized in that show the column of sample table in step 202, Including only stationary column, without extension column, stationary column and extension column.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410671292.1A CN104462254B (en) | 2014-11-21 | 2014-11-21 | Complex region access device and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410671292.1A CN104462254B (en) | 2014-11-21 | 2014-11-21 | Complex region access device and method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104462254A CN104462254A (en) | 2015-03-25 |
| CN104462254B true CN104462254B (en) | 2018-08-28 |
Family
ID=52908290
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410671292.1A Active CN104462254B (en) | 2014-11-21 | 2014-11-21 | Complex region access device and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104462254B (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102446172A (en) * | 2010-10-08 | 2012-05-09 | 金蝶软件（中国）有限公司 | Data service processing method and device adopting same |
| CN103744831A (en) * | 2013-12-16 | 2014-04-23 | 远光软件股份有限公司 | Compilation method and device for multi-dimensional report |
| CN103745301A (en) * | 2013-12-16 | 2014-04-23 | 远光软件股份有限公司 | Statement figure acquisition setting method and device based on statement dimension |
| CN104063361A (en) * | 2014-07-04 | 2014-09-24 | 用友软件股份有限公司 | Report design method and system |
-
2014
- 2014-11-21 CN CN201410671292.1A patent/CN104462254B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102446172A (en) * | 2010-10-08 | 2012-05-09 | 金蝶软件（中国）有限公司 | Data service processing method and device adopting same |
| CN103744831A (en) * | 2013-12-16 | 2014-04-23 | 远光软件股份有限公司 | Compilation method and device for multi-dimensional report |
| CN103745301A (en) * | 2013-12-16 | 2014-04-23 | 远光软件股份有限公司 | Statement figure acquisition setting method and device based on statement dimension |
| CN104063361A (en) * | 2014-07-04 | 2014-09-24 | 用友软件股份有限公司 | Report design method and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104462254A (en) | 2015-03-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105138661A (en) | Hadoop-based k-means clustering analysis system and method of network security log | |
| MX2015008799A (en) | System and method for distributed database query engines. | |
| US20140207820A1 (en) | Method for parallel mining of temporal relations in large event file | |
| CN108197187B (en) | Query statement optimization method and device, storage medium and computer equipment | |
| CN109885614B (en) | Data synchronization method and device | |
| CN107748745B (en) | Enterprise name keyword extraction method | |
| CN108829884A (en) | data mapping method and device | |
| US20180075101A1 (en) | N-way hash join | |
| CN104462361A (en) | Method and device for matching data in data table | |
| CN105681199B (en) | The processing method and processing device of message data in a kind of vehicle bus | |
| CN104834709A (en) | Parallel cosine mode mining method based on load balancing | |
| CN103036726A (en) | Method and device for network user management | |
| CN103984723A (en) | Method used for updating data mining for frequent item by incremental data | |
| CN104462254B (en) | Complex region access device and method | |
| US20180203896A1 (en) | Method and apparatus for processing query | |
| CN103716234B (en) | A kind of method for positioning message memory leak | |
| CN110019252A (en) | The method, apparatus and electronic equipment of information processing | |
| CN104699747A (en) | AMQ (approximate membership query) method based on high-dimensional data filter | |
| CN102323966B (en) | CAD (Computer-Aided Design) network topological graph analysis method based on rapid group search technology | |
| CN108256003A (en) | A kind of method that union operation efficiencies are improved according to analysis Data duplication rate | |
| US10339107B2 (en) | Multi-level colocation and processing of spatial data on MapReduce | |
| Ke et al. | Analysis on current research of supernetwork through knowledge mapping method | |
| CN104391866A (en) | Approximate membership query method based on high-dimension data filter | |
| Argyriou et al. | Two polynomial time algorithms for the metro-line crossing minimization problem | |
| KR101423560B1 (en) | Method for providing knowledge map based on key word |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| 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 |