CN107679245A - A kind of organizational structure method of adjustment and device - Google Patents
A kind of organizational structure method of adjustment and device Download PDFInfo
- Publication number
- CN107679245A CN107679245A CN201711042890.2A CN201711042890A CN107679245A CN 107679245 A CN107679245 A CN 107679245A CN 201711042890 A CN201711042890 A CN 201711042890A CN 107679245 A CN107679245 A CN 107679245A
- Authority
- CN
- China
- Prior art keywords
- data
- row
- basic stitch
- new tissue
- framework
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 33
- 230000008520 organization Effects 0.000 claims abstract description 81
- 238000013507 mapping Methods 0.000 claims abstract description 76
- 238000007726 management method Methods 0.000 description 13
- 241001269238 Data Species 0.000 description 6
- 238000004458 analytical method Methods 0.000 description 5
- 230000008569 process Effects 0.000 description 5
- 230000008859 change Effects 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 3
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 3
- 230000008901 benefit Effects 0.000 description 2
- 238000007405 data analysis Methods 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 238000013468 resource allocation Methods 0.000 description 2
- 238000007619 statistical method Methods 0.000 description 2
- 239000013256 coordination polymer Substances 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000005194 fractionation Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 238000013439 planning Methods 0.000 description 1
- 230000000717 retained effect Effects 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
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/23—Updating
- G06F16/2358—Change logging, detection, and notification
-
- 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/23—Updating
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a kind of organizational structure method of adjustment and device, this method can include：Determine the pending basic stitch framework row in pending business object table；Statistical organization row are created in the business object table；The corresponding at least one Adjusted Option of the default basic stitch framework row is obtained, wherein, each described Adjusted Option includes adjusting the mapping relations of type and new tissue data and the basic stitch data in basic stitch framework row；For Adjusted Option each described, the adjustment type and the mapping relations in current Adjusted Option, the corresponding new tissue data are write in the corresponding data items in the statistical organization row.This programme can retain the organizational structure of history.
Description
Technical field
The present invention relates to field of computer technology, more particularly to a kind of organizational structure method of adjustment and device.
Background technology
Nowadays, ERP (Enterprise Resource Planning, Enterprise Resources Plan) system etc. has been widely used
In enterprise, moreover, enterprise can adjust the organizational structure of system at any time, the development of enterprise supported with this according to development need.
At present, in the organizational structure of the system of adjustment, basic stitch framework is mainly directly changed to required new tissue
Framework, so, the new organizational structure adjusted out will be then only existed after the adjustment, and the basic stitch framework before adjustment no longer be present,
Just the data under basic stitch framework and new organizational structure can not be analyzed simultaneously so as to after.It can be seen that how to retain history
Organizational structure turn into current urgent problem to be solved.
The content of the invention
The embodiments of the invention provide a kind of organizational structure method of adjustment and device, the organizational structure of history can be retained.
In a first aspect, the embodiments of the invention provide a kind of organizational structure method of adjustment, including：
Determine the pending basic stitch framework row in pending business object table；
Statistical organization row are created in the business object table；
The corresponding at least one Adjusted Option of the default basic stitch framework row is obtained, wherein, each described tune
Perfect square case includes the mapping relations for adjusting type and new tissue data and the basic stitch data in basic stitch framework row；
For Adjusted Option each described, the adjustment type and the mapping in current Adjusted Option are closed
System, the corresponding new tissue data are write in the corresponding data items in the statistical organization row.
Preferably,
When the adjustment type in the current Adjusted Option is simply adjusts, the mapping relations are one first
The mapping relations of new tissue data and a first basic stitch data in basic stitch framework row；
The adjustment type and the mapping relations in the current Adjusted Option of basis, will the corresponding new tissue
Data are write in the corresponding data items in the statistical organization row, including：
Described first new tissue data are write at least one first data item in the statistical organization row, wherein,
Described in one write during the in each described first data item described first new tissue data arrange with the basic stitch framework
First basic stitch data are located at same row.
Preferably,
When the adjustment type in the current Adjusted Option merges for organizational structure, the mapping relations are one
The mapping relations of at least two the second different basic stitch data in second new tissue data and basic stitch framework row；
The adjustment type and the mapping relations in the current Adjusted Option of basis, will the corresponding new tissue
Data are write in the corresponding data items in the statistical organization row, including：
Described second new tissue data are write at least two second data item in the statistical organization row, wherein,
Described in one write during the in each described second data item described second new tissue data arrange with the basic stitch framework
Second basic stitch data are located at same row.
Preferably,
When the adjustment type in the current Adjusted Option splits for organizational structure, the mapping relations are at least
The mapping relations of two the different the 3rd new tissue data and a three foundation weave data in basic stitch framework row；
The adjustment type and the mapping relations in the current Adjusted Option of basis, will the corresponding new tissue
Data are write in the corresponding data items in the statistical organization row, including：
Obtain management resource distribution table corresponding to the default three foundation weave data；In the management resource distribution table
Including at least one key column, wherein, each described key column includes at least one critical data；
According to the critical data at least one key column and each described key column, by different institutes
The 3rd new tissue data are stated to be respectively written at least one 3rd data item in the statistical organization row, wherein, write-in is each
The described 3rd new tissue data in individual 3rd data item and one described 3rd former group in basic stitch framework row
Organization data is in same a line.
Preferably,
The key column, including：Area row, product row and client row in any one.
Second aspect, the embodiments of the invention provide a kind of organizational structure adjusting apparatus, including：
Determining unit, for determining the pending basic stitch framework row in pending business object table；
Creating unit, for creating statistical organization row in the business object table；
Acquiring unit, at least one Adjusted Option corresponding for obtaining the default basic stitch framework row, wherein,
Each described Adjusted Option includes adjusting the basic stitch number in type and new tissue data and basic stitch framework row
According to mapping relations；
Adjustment unit, for for Adjusted Option each described, the adjustment type in current Adjusted Option
With the mapping relations, the corresponding new tissue data are write in the corresponding data items in the statistical organization row.
Preferably,
When the adjustment type in the current Adjusted Option is simply adjusts, the mapping relations are one first
The mapping relations of new tissue data and a first basic stitch data in basic stitch framework row；
The adjustment unit, for the described first new tissue data are write in the statistical organization row at least one the
In one data item, wherein, the described first new tissue data write in each described first data item and the basic stitch frame
The first basic stitch data in structure row are located at same row.
Preferably,
When the adjustment type in the current Adjusted Option merges for organizational structure, the mapping relations are one
The mapping relations of at least two the second different basic stitch data in second new tissue data and basic stitch framework row；
The adjustment unit, for the described second new tissue data are write in the statistical organization row at least two the
In two data item, wherein, the described second new tissue data write in each described second data item and the basic stitch frame
The second basic stitch data in structure row are located at same row.
Preferably,
When the adjustment type in the current Adjusted Option splits for organizational structure, the mapping relations are at least
The mapping relations of two the different the 3rd new tissue data and a three foundation weave data in basic stitch framework row；
The adjustment unit, for obtaining management resource distribution table corresponding to the default three foundation weave data；Institute
Stating management resource distribution table includes at least one key column, wherein, each described key column includes at least one key
Data；According to the critical data at least one key column and each described key column, described in different
3rd new tissue data are respectively written at least one 3rd data item in the statistical organization row, wherein, write each
The described 3rd new tissue data in 3rd data item and a three foundation weave in basic stitch framework row
Data are in same a line.
Preferably,
The key column, including：Area row, product row and client row in any one.
It is first when carrying out organizational structure adjustment the embodiments of the invention provide a kind of organizational structure method of adjustment and device
The pending basic stitch framework row being first to determine in pending business object table, are then adjusted to the business object table
It is whole, namely in the business object table create one statistics organizational structure row, mainly by arranged in the statistical organization newly created into
The corresponding new tissue data of row are filled in adjust out new organizational structure, and avoid directly being adjusted basic stitch framework row,
Specifically, the corresponding at least one Adjusted Option of default basic stitch framework row is got, wherein, each Adjusted Option
Include adjusting type and the mapping relations of new tissue data and the basic stitch data in basic stitch framework row, so, so that it may
For each adjustment type, and corresponding mapping relations, to be filled in the corresponding data items of statistical organization row corresponding
New tissue data, and be no longer that corresponding basic stitch data change newly organizes data during directly basic stitch framework is arranged, so as to
While new organizational structure is adjusted out, the organizational structure of history is remained.
Brief description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
There is the required accompanying drawing used in technology description to be briefly described, it should be apparent that, drawings in the following description are the present invention
Some embodiments, for those of ordinary skill in the art, on the premise of not paying creative work, can also basis
These accompanying drawings obtain other accompanying drawings.
Fig. 1 is a kind of flow chart for organizational structure method of adjustment that one embodiment of the invention provides；
Fig. 2 is a kind of flow chart for organizational structure method of adjustment that another embodiment of the present invention provides；
Fig. 3 is a kind of structural representation for organizational structure adjusting apparatus that one embodiment of the invention provides.
Embodiment
To make the purpose, technical scheme and advantage of the embodiment of the present invention clearer, below in conjunction with the embodiment of the present invention
In accompanying drawing, the technical scheme in the embodiment of the present invention is clearly and completely described, it is clear that described embodiment is
Part of the embodiment of the present invention, rather than whole embodiments, based on the embodiment in the present invention, those of ordinary skill in the art
The every other embodiment obtained on the premise of creative work is not made, belongs to the scope of protection of the invention.
As shown in figure 1, the embodiments of the invention provide a kind of organizational structure method of adjustment, this method can include following step
Suddenly：
Step 101：Determine the pending basic stitch framework row in pending business object table.
Step 102：Statistical organization row are created in the business object table.
Step 103：The corresponding at least one Adjusted Option of the default basic stitch framework row is obtained, wherein, it is each
The individual Adjusted Option includes adjusting type and new tissue data and the basic stitch data in basic stitch framework row
Mapping relations.
Step 104：For Adjusted Option each described, the adjustment type in current Adjusted Option and described
Mapping relations, the corresponding new tissue data are write in the corresponding data items in the statistical organization row.
The embodiments of the invention provide a kind of organizational structure method of adjustment, is true first when carrying out organizational structure adjustment
Pending basic stitch framework row in fixed pending business object table, are then adjusted to the business object table, namely
A statistics organizational structure row are created in the business object table, it is mainly corresponding by being carried out in the statistical organization row newly created
New tissue data are filled in adjust out new organizational structure, and avoid directly being adjusted basic stitch framework row, specifically, obtaining
The corresponding at least one Adjusted Option of default basic stitch framework row is got, wherein, each Adjusted Option includes adjusting
Whole type and the mapping relations of new tissue data and the basic stitch data in basic stitch framework row, in this manner it is possible to for every
One adjustment type, and corresponding mapping relations, corresponding new tissue is filled in the corresponding data items of statistical organization row
Data, and be no longer that corresponding basic stitch data change newly organizes data during directly basic stitch framework is arranged, so as to adjust out
While new organizational structure, the organizational structure of history is remained.
In an embodiment of the invention, when the adjustment type in the current Adjusted Option is simply adjusts,
The mapping relations are reflected for a first basic stitch data in one first new tissue data and basic stitch framework row
Penetrate relation；The embodiment of the step 104, it may include：Described first new tissue data are write into the statistical organization
In at least one first data item in row, wherein, the described first new tissue number write in each described first data item
It is located at same row according to the first basic stitch data in being arranged with the basic stitch framework.
For example, mapping relations are the first new tissue data " Zhang San three " and the mapping relations of basic stitch data " Zhang San ", vacation
If currently pending business object table is as shown in table 1 below；
Table 1
| Basic stitch | The business date | Area | Client | Product |
| Zhang San | 2017.01 | Shandong | A | a |
| Zhang San | 2017.02 | Shandong | B | b |
| Zhang San | 2017.02 | Shandong | C | c |
| … | … | … | … | … |
In inventive embodiments, basic stitch framework row are the first row basic stitch in above-mentioned table 1, and Zhang San is in the row
A kind of basic stitch data, then in order to retain the organizational structure of history, then when carrying out organizational structure adjustment, then first in table 1
It is middle to create statistical organization row, then according to mapping relations, by be in basic stitch Zhang San corresponding statistical organization row in
Each data item fill in Zhang San three, specifically, complete organizational structure adjustment after business object table can be as shown in table 2 below.
Table 2
| Basic stitch | The business date | Area | Client | Product | Statistical organization |
| Zhang San | 2017.01 | Shandong | A | a | Zhang San three |
| Zhang San | 2017.02 | Shandong | B | b | Zhang San three |
| Zhang San | 2017.03 | Shandong | C | c | Zhang San three |
| … | … | … | … | … | … |
As shown in Table 2, the statistical organization row that last row as newly creates from left to right, it can be seen that basic stitch framework
All basic stitch data Zhang San and the new tissue data Zhang San in statistical organization row in row (being first row from left to right)
Three correspondences, so, if carrying out history and the analysis of current organizational structure afterwards, Zhang San is searched for, can be searched out accordingly extremely
Few three datas record, if search Zhang San three, it can equally search out corresponding at least three datas record.
In addition, user can also be adjusted according to the demand of reality, for example, also including industry in current Adjusted Option
It is engaged in Start Date, such as 2017.02, then when carrying out organizational structure adjustment, then the first row of statistical organization row will be filled in no longer
Zhang San three, and would is that sky data.
In an embodiment of the invention, when the adjustment type in the current Adjusted Option merges for organizational structure
When, the mapping relations are at least two different second former group in one second new tissue data and basic stitch framework row
The mapping relations of organization data；The embodiment of the step 104, it may include：By the described second new tissue data write-in institute
State at least two second data item in statistical organization row, wherein, described the write in each described second data item
Two new tissue data are located at same row with the second basic stitch data in basic stitch framework row.
For example, mapping relations be the first new tissue data " king five " respectively with basic stitch data " Zhang San " and basic stitch data
The mapping relations of " Li Si ", it is assumed that currently pending business object table is as shown in table 3 below；
Table 3
In inventive embodiments, the first row basic stitch from left to right in basic stitch framework row as above-mentioned table 3, Zhang San
It is two class basic stitch data in basic stitch framework row with Li Si, then in order to retain the organizational structure of history, then carrying out
When organizational structure adjusts, then a statistical organization row are created first in table 3, then according to mapping relations, will be in basic stitch
Each data item in the corresponding statistical organization row of Zhang San and Li Si fills in Chengwang five, is adjusted specifically, completing organizational structure
Business object table after whole can be as shown in table 4 below.
Table 4
| Basic stitch | The business date | Area | Client | Product | Statistical organization |
| Zhang San | 2017.02 | Shandong | D | d | King five |
| Li Si | 2017.03 | Beijing | E | s | King five |
| Li Si | 2017.04 | Beijing | S | s | King five |
| … | … | … | … | … | … |
As shown in Table 4, the statistical organization row that last row as newly creates from left to right, it can be seen that basic stitch framework
All basic stitch data Zhang San and basic stitch data Li Si arrange with statistical organization in row (being first row from left to right)
In the new correspondence of tissue data king five, so, if afterwards carry out history and current organizational structure analysis, search for Zhang San, energy
Corresponding at least one data record (data record for including the 1st row) is enough searched out, if search Li Si, can be searched out corresponding
At least two datas record (including data record of the 2nd row and the 3rd row), then search king five, then can search out at least
Three datas record (data record for including the 1st row, the 2nd row and the 3rd row).
In an embodiment of the invention, when the adjustment type in the current Adjusted Option splits for organizational structure
When, the mapping relations are one the 3rd at least two the different the 3rd new tissue data and basic stitch framework row former
Organize the mapping relations of data；The embodiment of the step 104, it may include：Obtain the default three foundation weave
Management resource distribution table corresponding to data；The management resource distribution table includes at least one key column, wherein, each institute
Stating key column includes at least one critical data；According at least one key column and each described key column
The critical data, at least one 3rd the different the described 3rd new tissue data are respectively written into the statistical organization row
In data item, wherein, the described 3rd new tissue data write in each described 3rd data item and the basic stitch framework
The three foundation weave data in row are in same a line.
For example, mapping relations be the first new tissue data " Zhang San " and first newly organize data " king five " respectively with basic stitch
The mapping relations of data " Li Si ", it is assumed that currently pending business object table is as shown in table 5 below；
Table 5
| Basic stitch | The business date | Area | Client | Product | … |
| Li Si | 2017.01 | Shandong | A | d | … |
| Li Si | 2017.02 | Shandong | A | d | |
| Li Si | 2017.02 | Beijing | P | w | |
| Li Si | 2017.02 | Beijing | P | w | … |
| Li Si | 2017.03 | Shandong | C | g | … |
In inventive embodiments, the first row basic stitch from left to right in basic stitch framework row as above-mentioned table 5, Li Si
For the basic stitch framework arrange in a kind of basic stitch data, from above-mentioned table 5 as can be seen that a data record will be corresponding with it is more
Row, i.e., in addition to the above-mentioned business days column listed, area row, client's row and product arrange, in addition to other multiple rows.So
, then can be according to being pre-configured with specifically by those resource allocations to corresponding new tissue data when carrying out organizational structure adjustment
Resource distribution table is managed, can be as shown in table 6 below；
Table 6
Area row, client's row and product row are three selected in the embodiment of the present invention it can be seen from above-mentioned table 6
Key column, as long as namely to include each data record that basic stitch is Li Si, area is Shandong, client A, product are d equal
New tissue data Zhang San is distributed to, and each data that basic stitch is Li Si, area is Beijing, client P, product are w are remembered
New tissue data Zhang San is also distributed in record, and basic stitch is, area is Shandong, client C, product are each data notes of g
New tissue data king five is distributed in record, so, according to mapping relations and the management resource distribution table, can be arranged in statistical organization
Corresponding data items in fill in Zhang San or king five, specifically, complete organizational structure adjustment after business object table can be such as table 7 below
It is shown；
Table 7
| Basic stitch | The business date | Area | Client | Product | … | Statistical organization |
| Li Si | 2017.01 | Shandong | A | d | … | Zhang San |
| Li Si | 2017.02 | Shandong | A | d | Zhang San | |
| Li Si | 2017.02 | Beijing | P | w | Zhang San | |
| Li Si | 2017.02 | Beijing | P | w | … | Zhang San |
| Li Si | 2017.03 | Shandong | C | g | … | King five |
As shown in Table 7, the statistical organization row that last row as newly creates from left to right, it can be seen that basic stitch framework
New tissue data during all basic stitch data Li Sis arrange with statistical organization in row (being first row from left to right)
Three and the correspondence of king five, so, if carrying out history and the analysis of current organizational structure afterwards, Zhang San is searched for, phase can be searched out
The four datas record (data record for including the 1st row to the 4th row) answered, if search king five, a data note can be searched out
Record (data record for including the 5th row), if the data Li Si in search basic stitch framework row, because history organizational structure retains,
5 datas record (including the 1st row to the data record on the 5th) can also then be searched out.
In an embodiment of the invention, the key column, including：It is any one in area row, product row and client's row
It is individual.
A kind of organizational structure method of adjustment provided in an embodiment of the present invention is described more detail below, as shown in Fig. 2 this method
It may comprise steps of：
Step 201：Determine the pending basic stitch framework row in pending business object table.
Step 202：Statistical organization row are created in the business object table.
In embodiments of the present invention, arranged in the case of adjusting a basic stitch framework, then when there are two in business object table
When basic stitch framework row need to be adjusted, then two statistical organization row are created that in the business object table, then for every
One basic stitch framework row, is adjusted correspondingly according to the steps.
In embodiments of the present invention, pending business object table should be defined in advance, specifically, may include as follows
Content in table 8：
Table 8
| Field | Explanation |
| YXYWDX_LSBH | Flowing water |
| YXYWDX_GSID | Accounting unit |
| YXYWDX_BM | Business object table name |
| YXYWDX_ZZZD | Basic stitch framework field |
| YXYWDX_TJZZ | Statistical organization field |
| YXYWDX_RQZD | Business date field |
| YXYWDX_DQZD | Region field |
| YXYWDX_KHZD | Custom fields |
| YXYWDX_CPZD | Product field |
| YXYWDX_SYBZ | Using mark 1, use；0, without using |
| YXYWDX_BZ | Remarks |
Wherein, when YXYWDX_SYBZ is mark 1, then current basic stitch framework field (namely is carried in above-described embodiment
To basic stitch framework row) be adjusted correspondingly, when for mark 0 when, then current basic stitch framework field is not adjusted.
Step 203：The corresponding at least one Adjusted Option of default basic stitch framework row is obtained, wherein, each tune
Perfect square case includes adjusting type and the mapping relations of new tissue data and the basic stitch data in basic stitch framework row, works as tune
When whole type is simply adjusts, step 204 is performed；When it is that organizational structure merges to adjust type, step 205 is performed；Work as adjustment
When type is that organizational structure is split, step 206 is performed.
In embodiments of the present invention, equally organizational structure Adjusted Option should be defined in advance, specifically, may include as
Content in table 9 below：
Table 9
| Field | Explanation |
| YXZZFA_LSBH | Flowing water |
| YXZZFA_GSID | Accounting unit |
| YXZZFA_YZZ | Basic stitch data |
| YXZZFA_XZZ | New tissue data |
| YXZZFA_YWRQ | Business Start Date |
| YXZZFA_TZLX | Adjust type |
| YXZZFA_SYBZ | Using mark 1, use；0, without using |
| YXZZFA_BZ | Remarks |
Likewise, when the YXZZFA_SYBZ in table 9 is mark 1, then this current one kind in not arranging the original architecture
Basic stitch data are adjusted, and YXZZFA_YWRQ can be set according to the actual requirements, i.e. selection adjustment original when
Organize data.
It may need to carry out different adjustment simultaneously in arranging due to a basic stitch framework, for example, some basic stitch data
Need simply to be adjusted, some basic stitch data need to carry out organizational structure merging adjustment, and some basic stitch data may
Need to carry out fractionation adjustment, therefore, a basic stitch framework row may correspond to multiple Adjusted Options simultaneously, then specifically may be used
It is adjusted correspondingly according to default Adjusted Option.
Step 204：The mapping relations are one first former group in one first new tissue data and basic stitch framework row
The mapping relations of organization data, the first new tissue data are write at least one first data item in statistical organization row, wherein,
Write the in each first data item first new tissue data and a first basic stitch data bit in basic stitch framework row
In same a line, and terminate current process.
Step 205：The mapping relations are different in one second new tissue data and basic stitch framework row at least two
The mapping relations of second basic stitch data, by least two second data in the second new tissue data write-in statistical organization row
Xiang Zhong, wherein, write the in each second data item second new tissue data and one second in basic stitch framework row is former
Tissue data are located at same row, and terminate current process.
In embodiments of the present invention, when carrying out simple adjustment either organizational structure merging adjustment, specifically, with former group
Stretching frame structure is classified as where conditions, updates the data in business object table in statistical organization framework row by update.
Step 206：The mapping relations are one at least two the different the 3rd new tissue data and basic stitch framework row
The mapping relations of individual three foundation weave data, obtain management resource distribution table corresponding to default three foundation weave data；The pipe
Reason resource distribution table includes at least one key column, wherein, each key column includes at least one critical data.
In embodiments of the present invention, equally management resource distribution table should be defined in advance, specifically, may include as follows
Content in table 10：
Table 10
| Field | Explanation |
| YXZZZY_LSBH | Flowing water |
| YXZZZY_GSID | Accounting unit |
| YXZZZY_YZZ | Basic stitch data |
| YXZZZY_XZZ | New tissue data |
| YXZZZY_DQ | Region field |
| YXZZZY_KH | Custom fields |
| YXZZZY_CP | Product field |
| YXZZZY_SYBZ | Using mark 1, use；0, without using |
| YXZZZY_BZ | Remarks |
Likewise, when the YXZZFA_SYBZ in table 10 is mark 1, then in not arranging the original architecture it is current this
Class basic stitch data are adjusted, and area, client and product are the key column selected in the embodiment of the present invention.
Step 207：It is according to the critical data at least one key column and each key column, different the 3rd is new
Tissue data are respectively written at least one 3rd data item in statistical organization row, wherein, write each the 3rd data item
In the 3rd new tissue data be in same a line with a three foundation weave data in basic stitch framework row.
In embodiments of the present invention, using basic stitch framework and new organizational structure as where conditions, match management resource distribution
Resource allocation relationship in table, while the statistical organization field defined in join business object tables, by statistical organization field with
Field in management resource distribution table is matched, and is realized the locking of business datum in business object table, is realized statistical organization frame
The update renewal operations of structure.
In embodiments of the present invention, when being adjusted to basic stitch data, key code can be as follows：
After statistical organization data processing is realized, statistical organization and original structure can be based in data query, BI analyses
The statistical analysis under framework respectively is carried out, solves the history framework data analysis problem that enterprise organization structure adjustment is brought.
As shown in figure 3, the embodiments of the invention provide a kind of organizational structure adjusting apparatus, including：
Determining unit 301, for determining the pending basic stitch framework row in pending business object table；
Creating unit 302, for creating statistical organization row in the business object table；
Acquiring unit 303, at least one Adjusted Option corresponding for obtaining the default basic stitch framework row, its
In, each described Adjusted Option includes adjusting the basic stitch in type and new tissue data and basic stitch framework row
The mapping relations of data；
Adjustment unit 304, for for Adjusted Option each described, the adjustment class in current Adjusted Option
Type and the mapping relations, the corresponding new tissue data are write in the corresponding data items in the statistical organization row.
In an embodiment of the invention, when the adjustment type in the current Adjusted Option is simply adjusts,
The mapping relations are reflected for a first basic stitch data in one first new tissue data and basic stitch framework row
Penetrate relation；
The adjustment unit, for the described first new tissue data are write in the statistical organization row at least one the
In one data item, wherein, the described first new tissue data write in each described first data item and the basic stitch frame
The first basic stitch data in structure row are located at same row.
In an embodiment of the invention, when the adjustment type in the current Adjusted Option merges for organizational structure
When, the mapping relations are at least two different second former group in one second new tissue data and basic stitch framework row
The mapping relations of organization data；
The adjustment unit, for the described second new tissue data are write in the statistical organization row at least two the
In two data item, wherein, the described second new tissue data write in each described second data item and the basic stitch frame
The second basic stitch data in structure row are located at same row.
In an embodiment of the invention, when the adjustment type in the current Adjusted Option splits for organizational structure
When, the mapping relations are one the 3rd at least two the different the 3rd new tissue data and basic stitch framework row former
Organize the mapping relations of data；
The adjustment unit, for obtaining management resource distribution table corresponding to the default three foundation weave data；Institute
Stating management resource distribution table includes at least one key column, wherein, each described key column includes at least one key
Data；According to the critical data at least one key column and each described key column, described in different
3rd new tissue data are respectively written at least one 3rd data item in the statistical organization row, wherein, write each
The described 3rd new tissue data in 3rd data item and a three foundation weave in basic stitch framework row
Data are in same a line.
In an embodiment of the invention, the key column, including：It is any one in area row, product row and client's row
It is individual.
The contents such as the information exchange between each unit, implementation procedure in said apparatus, due to implementing with the inventive method
Example is based on same design, and particular content can be found in the narration in the inventive method embodiment, and here is omitted.
To sum up, each embodiment of the present invention at least has the advantages that：
1st, in embodiments of the present invention, when carrying out organizational structure adjustment, pending business object table is to determine first
In pending basic stitch framework row, then the business object table is adjusted, namely is created in the business object table
One statistics organizational structure row, mainly filled in by carrying out corresponding new tissue data in the statistical organization row newly created to adjust
Go out new organizational structure, and avoid directly being adjusted basic stitch framework row, specifically, getting the default basic stitch frame
The corresponding at least one Adjusted Option of structure row, wherein, each Adjusted Option includes adjusting type and newly organizes data
The mapping relations of basic stitch data in being arranged with basic stitch framework, in this manner it is possible to for each adjustment type, and accordingly
Mapping relations, corresponding new tissue data are filled in the corresponding data items of statistical organization row, and be no longer directly by original
Corresponding basic stitch data change newly organizes data in organizational structure row, so as to while new organizational structure is adjusted out, protect
The organizational structure of history is stayed.
2nd, in embodiments of the present invention, resource distribution table is managed by setting, easily can be carried out to new tissue data
Resource divides, can be by the data in several key columns, really moreover, by managing the key column set in resource distribution table
The data record that a plurality of needs plan is divided into new tissue data is made, avoids being selected one by one, improves tissue frame
The efficiency of structure adjustment.
3rd, in embodiments of the present invention, after statistical organization data processing is realized, can be based in data query, BI analyses
Statistical organization and original structure carry out the statistical analysis under framework respectively, solve the history framework that enterprise organization structure adjustment is brought
Data analysis problem.
It should be noted that herein, such as first and second etc relational terms are used merely to an entity
Or operation makes a distinction with another entity or operation, and not necessarily require or imply and exist between these entities or operation
Any this actual relation or order.Moreover, term " comprising ", "comprising" or its any other variant be intended to it is non-
It is exclusive to include, so that process, method, article or equipment including a series of elements not only include those key elements,
But also the other element including being not expressly set out, or also include solid by this process, method, article or equipment
Some key elements.In the absence of more restrictions, by sentence " including the key element that a 〃 〃 " is limited, it is not excluded that
Other identical factor in the process including the key element, method, article or equipment also be present.
One of ordinary skill in the art will appreciate that：Realizing all or part of step of above method embodiment can pass through
Programmed instruction related hardware is completed, and foregoing program can be stored in computer-readable storage medium, the program
Upon execution, the step of execution includes above method embodiment；And foregoing storage medium includes：ROM, RAM, magnetic disc or light
Disk etc. is various can be with the medium of store program codes.
It is last it should be noted that：Presently preferred embodiments of the present invention is the foregoing is only, is merely to illustrate the skill of the present invention
Art scheme, is not intended to limit the scope of the present invention.Any modification for being made within the spirit and principles of the invention,
Equivalent substitution, improvement etc., are all contained in protection scope of the present invention.
Claims (10)
- A kind of 1. organizational structure method of adjustment, it is characterised in that including：Determine the pending basic stitch framework row in pending business object table；Statistical organization row are created in the business object table；The corresponding at least one Adjusted Option of the default basic stitch framework row is obtained, wherein, each described adjustment side Case includes the mapping relations for adjusting type and new tissue data and the basic stitch data in basic stitch framework row；For Adjusted Option each described, the adjustment type and the mapping relations in current Adjusted Option will The corresponding new tissue data are write in the corresponding data items in the statistical organization row.
- 2. according to the method for claim 1, it is characterised in thatWhen the adjustment type in the current Adjusted Option is simply adjusts, the mapping relations are one first new group The mapping relations of organization data and a first basic stitch data in basic stitch framework row；The adjustment type and the mapping relations in the current Adjusted Option of basis, will the corresponding new tissue data Write in the corresponding data items in the statistical organization row, including：Described first new tissue data are write at least one first data item in the statistical organization row, wherein, write-in The described first new tissue data in each described first data item and one described first in basic stitch framework row Basic stitch data are located at same row.
- 3. according to the method for claim 1, it is characterised in thatWhen the adjustment type in the current Adjusted Option merges for organizational structure, the mapping relations are one second The mapping relations of at least two the second different basic stitch data in new tissue data and basic stitch framework row；The adjustment type and the mapping relations in the current Adjusted Option of basis, will the corresponding new tissue data Write in the corresponding data items in the statistical organization row, including：Described second new tissue data are write at least two second data item in the statistical organization row, wherein, write-in The described second new tissue data in each described second data item and one described second in basic stitch framework row Basic stitch data are located at same row.
- 4. according to the method for claim 1, it is characterised in thatWhen the adjustment type in the current Adjusted Option splits for organizational structure, the mapping relations are at least two The mapping relations of the new tissue data of different the 3rd and a three foundation weave data in basic stitch framework row；The adjustment type and the mapping relations in the current Adjusted Option of basis, will the corresponding new tissue data Write in the corresponding data items in the statistical organization row, including：Obtain management resource distribution table corresponding to the default three foundation weave data；The management resource distribution table includes At least one key column, wherein, each described key column includes at least one critical data；According to the critical data at least one key column and each described key column, by different described Three new tissue data are respectively written at least one 3rd data item in the statistical organization row, wherein, write each institute State the described 3rd new tissue data in the 3rd data item and a three foundation weave number in basic stitch framework row According in same a line.
- 5. according to the method for claim 4, it is characterised in thatThe key column, including：Area row, product row and client row in any one.
- A kind of 6. organizational structure adjusting apparatus, it is characterised in that including：Determining unit, for determining the pending basic stitch framework row in pending business object table；Creating unit, for creating statistical organization row in the business object table；Acquiring unit, at least one Adjusted Option corresponding for obtaining the default basic stitch framework row, wherein, it is each The individual Adjusted Option includes adjusting type and new tissue data and the basic stitch data in basic stitch framework row Mapping relations；Adjustment unit, for for Adjusted Option each described, the adjustment type and institute in current Adjusted Option Mapping relations are stated, the corresponding new tissue data are write in the corresponding data items in the statistical organization row.
- 7. device according to claim 6, it is characterised in thatWhen the adjustment type in the current Adjusted Option is simply adjusts, the mapping relations are one first new group The mapping relations of organization data and a first basic stitch data in basic stitch framework row；The adjustment unit, at least one first number for writing the described first new tissue data in the statistical organization row According in item, wherein, the described first new tissue data write in each described first data item arrange with the basic stitch framework In the first basic stitch data be located at same row.
- 8. device according to claim 6, it is characterised in thatWhen the adjustment type in the current Adjusted Option merges for organizational structure, the mapping relations are one second The mapping relations of at least two the second different basic stitch data in new tissue data and basic stitch framework row；The adjustment unit, at least two second numbers for writing the described second new tissue data in the statistical organization row According in item, wherein, the described second new tissue data write in each described second data item arrange with the basic stitch framework In the second basic stitch data be located at same row.
- 9. device according to claim 6, it is characterised in thatWhen the adjustment type in the current Adjusted Option splits for organizational structure, the mapping relations are at least two The mapping relations of the new tissue data of different the 3rd and a three foundation weave data in basic stitch framework row；The adjustment unit, for obtaining management resource distribution table corresponding to the default three foundation weave data；The pipe Reason resource distribution table includes at least one key column, wherein, each described key column includes at least one critical data； It is according to the critical data at least one key column and each described key column, different the described 3rd is new Tissue data are respectively written at least one 3rd data item in statistical organization row, wherein, write each described the At the three foundation weave data in the described 3rd new tissue data and basic stitch framework row in three data item In same a line.
- 10. device according to claim 9, it is characterised in thatThe key column, including：Area row, product row and client row in any one.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711042890.2A CN107679245A (en) | 2017-10-30 | 2017-10-30 | A kind of organizational structure method of adjustment and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711042890.2A CN107679245A (en) | 2017-10-30 | 2017-10-30 | A kind of organizational structure method of adjustment and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107679245A true CN107679245A (en) | 2018-02-09 |
Family
ID=61143067
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711042890.2A Pending CN107679245A (en) | 2017-10-30 | 2017-10-30 | A kind of organizational structure method of adjustment and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107679245A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109918053A (en) * | 2019-01-17 | 2019-06-21 | 平安城市建设科技(深圳)有限公司 | Organizational structure method of adjustment, device, equipment and readable storage medium storing program for executing |
| CN110134663A (en) * | 2019-04-02 | 2019-08-16 | 北京三快在线科技有限公司 | Texture data processing method, device, electronic equipment |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102065413A (en) * | 2010-11-17 | 2011-05-18 | 北京北方烽火科技有限公司 | Database updating method and system, and base station self-starting method and system |
| CN102332026A (en) * | 2011-10-10 | 2012-01-25 | 深圳中兴网信科技有限公司 | Inquiring statistical method for service database |
| CN102855305A (en) * | 2012-08-20 | 2013-01-02 | 大唐移动通信设备有限公司 | Data upgrading method and device |
| US20170060908A1 (en) * | 2015-08-26 | 2017-03-02 | International Business Machines Corporation | Method for storing data elements in a database |
| CN108073709A (en) * | 2017-12-20 | 2018-05-25 | 上海达梦数据库有限公司 | A kind of operating method of data record, device, equipment and storage medium |
-
2017
- 2017-10-30 CN CN201711042890.2A patent/CN107679245A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102065413A (en) * | 2010-11-17 | 2011-05-18 | 北京北方烽火科技有限公司 | Database updating method and system, and base station self-starting method and system |
| CN102332026A (en) * | 2011-10-10 | 2012-01-25 | 深圳中兴网信科技有限公司 | Inquiring statistical method for service database |
| CN102855305A (en) * | 2012-08-20 | 2013-01-02 | 大唐移动通信设备有限公司 | Data upgrading method and device |
| US20170060908A1 (en) * | 2015-08-26 | 2017-03-02 | International Business Machines Corporation | Method for storing data elements in a database |
| CN108073709A (en) * | 2017-12-20 | 2018-05-25 | 上海达梦数据库有限公司 | A kind of operating method of data record, device, equipment and storage medium |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109918053A (en) * | 2019-01-17 | 2019-06-21 | 平安城市建设科技(深圳)有限公司 | Organizational structure method of adjustment, device, equipment and readable storage medium storing program for executing |
| CN110134663A (en) * | 2019-04-02 | 2019-08-16 | 北京三快在线科技有限公司 | Texture data processing method, device, electronic equipment |
| CN110134663B (en) * | 2019-04-02 | 2020-04-28 | 北京三快在线科技有限公司 | Organization structure data processing method and device and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105373599B (en) | Data mover system based on various data storing platforms | |
| US7093207B1 (en) | Data analysis flow engine | |
| CN100375971C (en) | System and method for hierarchical layout specialization | |
| US20200356688A1 (en) | Data access authority management method, apparatus, terminal device and storage medium | |
| US8151181B2 (en) | Method and apparatus for form automatic layout | |
| US7617443B2 (en) | Flexible multiple spreadsheet data consolidation system | |
| CN101661580B (en) | Method and system for testing software | |
| CN103488475B (en) | Multidimensional data analysis system and multidimensional data analysis method | |
| US8151056B2 (en) | Updating data within a business planning tool | |
| CN101539855A (en) | Service basic software platform | |
| US20080086478A1 (en) | Semantical partitioning of data | |
| CN104573022A (en) | Data query method and device for HBase | |
| CN107748752A (en) | A kind of data processing method and device | |
| CN107103035A (en) | This earth's surface data-updating method and device | |
| CN115840567A (en) | Application editing method and related equipment | |
| CN107679245A (en) | A kind of organizational structure method of adjustment and device | |
| CN115730900A (en) | Project data processing method and device, computer equipment and storage medium | |
| US7805462B2 (en) | Portfolio management methods, systems, and computer programs | |
| CN106250110A (en) | Set up the method and device of model | |
| CN106599291B (en) | Data grouping method and device | |
| US20070050420A1 (en) | Method and apparatus for transferring data between databases | |
| CN107590259A (en) | The dissemination method and device of a kind of data, services | |
| Murtaza | A framework for developing enterprise data warehouses | |
| CN101814064B (en) | Establishment method of report template, report generation method and report system | |
| CN110019299A (en) | A kind of method and apparatus for creating or refreshing the off-line data set of analytic type data warehouse |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180209 |
|
| RJ01 | Rejection of invention patent application after publication |