CN105678523A - TPM information management system proposal method - Google Patents
TPM information management system proposal method Download PDFInfo
- Publication number
- CN105678523A CN105678523A CN201610088593.0A CN201610088593A CN105678523A CN 105678523 A CN105678523 A CN 105678523A CN 201610088593 A CN201610088593 A CN 201610088593A CN 105678523 A CN105678523 A CN 105678523A
- Authority
- CN
- China
- Prior art keywords
- data
- motion
- proposal message
- inventory
- proposal
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Engineering & Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Operations Research (AREA)
- Economics (AREA)
- Marketing (AREA)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a TPM information management system proposal method, and the method comprises the steps: uploading proposal information in a system; generating a proposal list through proposal information data extraction, proposal information data integration, proposal information data conversion, proposal information data cleaning, and proposal information data loading; further generating a chief inspector evaluation list and a final improvement proposal list, thereby automatically completing the submitting and evaluation of an improved proposal, greatly improving the work efficiency, and motivating the personnel for participating the improvement.
Description
Technical field
The present invention relates to TPM information management system technical field, particularly relate to a kind of TPM information management system motion method.
Background technology
TPM information management system starts to encourage employee's total involvement improvement activity from most basic 6S, is mainly used in employee and improves the submission of motion, evaluation, displaying and data statistics etc., brings huge economic benefit for enterprise. But existing TPM information management system adopt motion method be: employee first by improve motion make PPT be committed to TPM carry out do, by carry out do assistant director carry out arrangement hand over to the collective or the state department judging panel be evaluated, data statistics is carried out afterwards to evaluation result is manual, so that whole, to improve the submission of motion, appraisal very loaded down with trivial details, greatly reduce work efficiency, run in the opposite direction with the original intention setting up TPM information management system.
Summary of the invention
For above-mentioned technical problem, it is an object of the invention to provide a kind of TPM information management system motion method, upload proposal message in systems, automatically generate motion inventory, generate chief inspector further evaluate inventory and finally improve motion inventory, improving the submission of motion, appraisal thus being automatically performed, substantially increasing work efficiency, excite the passion that employee's total involvement improves.
For reaching this purpose, the present invention by the following technical solutions:
A kind of TPM information management system motion method, it is characterised in that comprise the steps:
A, unlatching motion;
B, upload proposal message to background server, according to proposal message coupling system internal preset template, generate motion inventory;
C, according to motion inventory coupling system internal preset template, generate chief inspector and evaluate inventory;
D, evaluate inventory coupling system internal preset template according to chief inspector, generate and improve motion inventory;
E, closedown motion.
Especially, described step B uploads proposal message to specifically include to background server:
The data producing motion inventory needs are extracted by B1, proposal message data pick-up according to certain form from proposal message data source;
B2, proposal message data integration, need to carry out integrating to the mapping of the source field of proposal message to the aiming field of motion inventory;
B3, proposal message data are changed, and by the source data of the extraction needs according to data warehouse model in proposal message data source, carry out data conversion, make the data after conversion meet background server requirement;
B4, proposal message data cleansing, detect and delete mistake and the contradiction of translated data, it is ensured that the quality of data;
B5, proposal message data load, and the data after cleaning are loaded into background server.
Especially, in described step B1, proposal message data pick-up adopts increment extraction, is only drawn from the incremental data produced since data pick-up last time every time.
Especially, in described step B1, for the data that proposal message data volume is less, adopt and directly extract; For the data that proposal message data volume is bigger, first convert data to text, then extract from text.
Especially, in described step B4, proposal message data cleansing specifically includes and the proposal message data after conversion is carried out the actual content of storage format, field or field groups and the inspection of implicit content, checks whether the exceptional value in field or field groups and whole piece record repeat.
Especially, according to proposal message coupling system internal preset template in described step B, generate motion inventory to specifically include: background server presets correlate template, deposit in the table of background server in a binary format, after opening motion, directly correlation table is copied to the data base at proposal message place, generates correspondingly motion inventory; In like manner, correlation table is copied to by described step C the data base at motion inventory place, generate correspondingly chief inspector and evaluate inventory; Correlation table is copied to chief inspector by described step D and evaluates the data base at inventory place, generate and correspondingly improve motion inventory.
A kind of TPM information management system motion method that the present invention proposes, upload proposal message in systems, load generate motion inventory by proposal message data pick-up, proposal message data integration, the conversion of proposal message data, proposal message data cleansing and proposal message data, generate chief inspector further evaluate inventory and finally improve motion inventory, the submission of motion, appraisal is improved thus being automatically performed, substantially increase work efficiency, excite the passion that employee's total involvement improves.
Accompanying drawing explanation
Fig. 1 is the TPM information management system motion method flow diagram that the embodiment of the present invention provides.
Detailed description of the invention
Below in conjunction with drawings and Examples, the invention will be further described. It is understood that specific embodiment described herein is used only for explaining the present invention, but not limitation of the invention. It also should be noted that, for the ease of describing, illustrate only part related to the present invention in accompanying drawing but not full content, unless otherwise defined, all of technology used herein is identical with the implication that the those skilled in the art belonging to the present invention are generally understood that with scientific terminology. The term used in the description of the invention herein is intended merely to the purpose describing specific embodiment, it is not intended that in the restriction present invention. Term as used herein " and/or " include the arbitrary and all of combination of one or more relevant Listed Items.
Embodiment one
Refer to shown in Fig. 1, the TPM information management system motion method flow diagram that Fig. 1 provides for the embodiment of the present invention.
In the present embodiment, TPM information management system motion method specifically includes:
S101, unlatching motion.
Described TPM information management system can set the unlatching motion cycle as required, and in the present embodiment, the default motion cycle is one month, and each motion cycle and every month are automatically controlled the of that month motion of unlatching by manager's Non-follow control or system.
S102, upload proposal message.
Employee or line manager upload and improve motion detailed content, have preserved and have submitted to, the motion detailed content uploaded can be checked, revise and delete work simultaneously.
S103, proposal message data pick-up.
From proposal message data source, the data producing motion inventory needs being extracted according to certain form, described proposal message data include business datum and coding data, for the data that data volume is bigger, cocoa first converts data to text, then extracts from text; For the data that data volume is less, it is possible to directly extract. Described extraction adopts increment extraction, is only drawn from the incremental data produced since data pick-up last time every time, thus ensureing that the data volume of data pick-up is little, and then the data volume of data conversion and loading is also little.
S104, proposal message data integration.
In order to proposal message being converted into motion inventory, have 10%-20% need to carry out integrating from the source field of proposal message to the mapping of the aiming field of motion inventory, being specifically divided into two benches, the first stage is isolation stage, and the source field for different proposal messages assigns a unique identifier; Second stage is reconciliation phase, confirms that the source field of which proposal message is identical, is then combined by these each occurrences of identical source field.
S105, proposal message data are changed.
By the source data of the extraction needs according to data warehouse model in proposal message data source, carry out data conversion, make the data after conversion meet background server requirement. The conversion of these data includes in the way of file, data being processed, and considers harmony and the programming of substantial amounts of non-statement of whole handling process simultaneously, therefore intermediate disk should have corresponding amount of storage, loading performance and mass data processing ability.
S106, proposal message data cleansing.
Proposal message data after conversion are checked, is not only the inspection of storage format, also include the actual content to field or field groups and the inspection of implicit content, check whether the exceptional value in data field and whole piece record repeat. By checking, detect and delete mistake and the contradiction of translated data further, it is ensured that the quality of data, it is ensured that the concordance of data, it is ensured that the referential integrity of data and the accuracy of data.
S107, proposal message data load.
After motion unlatching, proposal message are filled in, substantial amounts of data can be produced, select the loading tool with efficient loading performance that the proposal message data after cleaning are loaded, the data after cleaning are loaded into background server. Concrete loading strategy includes loading cycle and data supplementing strategy. Loading cycle refers to that proposal message extracts to the interval loading a secondary data. Data supplementing strategy is how proposal message data add every time.
S108, background server generate motion inventory.
Background server presets correlate template, deposits in the table of background server in a binary format, after opening motion, proposal message is loaded into background server, directly correlation table is copied to the data base at proposal message place, generates correspondingly motion inventory, and show in systems.
S109, background server generate chief inspector and evaluate inventory.
Motion inventory is evaluated by chief inspector, and determine motion grade, background server presets correlate template, deposit in the table of background server in a binary format, after opening motion, generate motion inventory, directly correlation table is copied to the data base at motion inventory place, generate correspondingly chief inspector and evaluate inventory, and show in systems.
S110, background server generate and finally improve motion inventory.
Motion inventory is evaluated by judging panel, and determine motion grade, background server presets correlate template, deposit in the table of background server in a binary format, after opening motion, generate chief inspector and evaluate inventory, directly correlation table is copied to chief inspector and evaluates the data base at inventory place, generate and finally improve motion inventory, and show in systems.
S111, manager close motion.
Manager or system are automatically switched off motion, preset template generation Various types of data statistics according to internal system, and described data statistics includes but not limited to individual's motion statistics, department of team motion statistics, TPM group motion statistics.
Technical scheme is applied to TPM information management system, upload proposal message in systems, load generate motion inventory by proposal message data pick-up, proposal message data integration, the conversion of proposal message data, proposal message data cleansing and proposal message data, generate chief inspector further evaluate inventory and finally improve motion inventory, the submission of motion, appraisal is improved thus being automatically performed, substantially increase work efficiency, excite the passion that employee's total involvement improves.
Note, above are only presently preferred embodiments of the present invention and institute's application technology principle. It will be appreciated by those skilled in the art that and the invention is not restricted to specific embodiment described here, various obvious change can be carried out for a person skilled in the art, readjust and substitute without departing from protection scope of the present invention. Therefore, although the present invention being described in further detail by above example, but the present invention is not limited only to above example, when without departing from present inventive concept, other Equivalent embodiments more can also be included, and the scope of the present invention is determined by appended right.
Claims (6)
1. a TPM information management system motion method, it is characterised in that comprise the steps:
A, unlatching motion;
B, upload proposal message to background server, according to proposal message coupling system internal preset template, generate motion inventory;
C, according to motion inventory coupling system internal preset template, generate chief inspector and evaluate inventory;
D, evaluate inventory coupling system internal preset template according to chief inspector, generate and improve motion inventory;
E, closedown motion.
2. TPM information management system motion method according to claim 1, it is characterised in that upload proposal message in described step B and specifically include to background server:
The data producing motion inventory needs are extracted by B1, proposal message data pick-up according to certain form from proposal message data source;
B2, proposal message data integration, need to carry out integrating to the mapping of the source field of proposal message to the aiming field of motion inventory;
B3, proposal message data are changed, and by the source data of the extraction needs according to data warehouse model in proposal message data source, carry out data conversion, make the data after conversion meet background server requirement;
B4, proposal message data cleansing, detect and delete mistake and the contradiction of translated data, it is ensured that the quality of data;
B5, proposal message data load, and the data after cleaning are loaded into background server.
3. TPM information management system motion method according to claim 2, it is characterised in that in described step B1, proposal message data pick-up adopts increment extraction, is only drawn from the incremental data produced since data pick-up last time every time.
4. TPM information management system motion method according to claim 2, it is characterised in that in described step B1, for the data that proposal message data volume is less, adopts and directly extracts; For the data that proposal message data volume is bigger, first convert data to text, then extract from text.
5. TPM information management system motion method according to claim 2, it is characterized in that, in described step B4, proposal message data cleansing specifically includes and the proposal message data after conversion is carried out the actual content of storage format, field or field groups and the inspection of implicit content, checks whether the exceptional value in field or field groups and whole piece record repeat.
6. TPM information management system motion method according to claim 1, it is characterized in that, according to proposal message coupling system internal preset template in described step B, generate motion inventory to specifically include: background server presets correlate template, deposit in the table of background server in a binary format, after opening motion, directly correlation table is copied to the data base at proposal message place, generates correspondingly motion inventory; In like manner, correlation table is replicated by described step C the data base at motion inventory place, generate correspondingly chief inspector and evaluate inventory; Correlation table is copied to chief inspector by described step D and evaluates the data base at inventory place, generate and correspondingly improve motion inventory.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610088593.0A CN105678523A (en) | 2016-02-17 | 2016-02-17 | TPM information management system proposal method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610088593.0A CN105678523A (en) | 2016-02-17 | 2016-02-17 | TPM information management system proposal method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105678523A true CN105678523A (en) | 2016-06-15 |
Family
ID=56304615
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610088593.0A Pending CN105678523A (en) | 2016-02-17 | 2016-02-17 | TPM information management system proposal method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105678523A (en) |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1464443A (en) * | 2002-06-21 | 2003-12-31 | 英业达股份有限公司 | Overture re-examining system and method thereof based on web pages |
| CN1499400A (en) * | 2002-11-11 | 2004-05-26 | 英业达股份有限公司 | Improved proposal management systema and method |
| CN101447038A (en) * | 2007-11-26 | 2009-06-03 | 鸿富锦精密工业（深圳）有限公司 | System and method for auditing proposal improvement |
| CN101593295A (en) * | 2008-05-26 | 2009-12-02 | 北京六所和瑞科技发展有限公司 | A kind of questionnaire type computer-aided proposal estimating and examining system and evaluation method |
| CN102325170A (en) * | 2011-08-24 | 2012-01-18 | 无锡中科方德软件有限公司 | Data extraction and integration method and system thereof |
| CN103606045A (en) * | 2013-11-20 | 2014-02-26 | 国家电网公司 | Report form generation method and report form system |
| CN104050275A (en) * | 2014-06-25 | 2014-09-17 | 国家电网公司 | Method and system for reviewing project |
| CN104239580A (en) * | 2014-10-13 | 2014-12-24 | 武汉大学 | General single-field split data extraction method and device based on value-column mapping |
-
2016
- 2016-02-17 CN CN201610088593.0A patent/CN105678523A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1464443A (en) * | 2002-06-21 | 2003-12-31 | 英业达股份有限公司 | Overture re-examining system and method thereof based on web pages |
| CN1499400A (en) * | 2002-11-11 | 2004-05-26 | 英业达股份有限公司 | Improved proposal management systema and method |
| CN101447038A (en) * | 2007-11-26 | 2009-06-03 | 鸿富锦精密工业（深圳）有限公司 | System and method for auditing proposal improvement |
| CN101593295A (en) * | 2008-05-26 | 2009-12-02 | 北京六所和瑞科技发展有限公司 | A kind of questionnaire type computer-aided proposal estimating and examining system and evaluation method |
| CN102325170A (en) * | 2011-08-24 | 2012-01-18 | 无锡中科方德软件有限公司 | Data extraction and integration method and system thereof |
| CN103606045A (en) * | 2013-11-20 | 2014-02-26 | 国家电网公司 | Report form generation method and report form system |
| CN104050275A (en) * | 2014-06-25 | 2014-09-17 | 国家电网公司 | Method and system for reviewing project |
| CN104239580A (en) * | 2014-10-13 | 2014-12-24 | 武汉大学 | General single-field split data extraction method and device based on value-column mapping |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109669934B (en) | Data warehouse system suitable for electric power customer service and construction method thereof | |
| US20110004622A1 (en) | Method and apparatus for gathering and organizing information pertaining to an entity | |
| CN105589968A (en) | Data summarization system and method | |
| AU2010213346A1 (en) | Creation of a data store | |
| US8224791B2 (en) | Information lifecycle cross-system reconciliation | |
| CN103460208A (en) | Methods and systems for loading data into a temporal data warehouse | |
| CN101937463A (en) | Method for automatically generating form for workflow model | |
| CN111079025A (en) | Government affair recommendation method based on big data analysis and system comprising method | |
| CN101169804A (en) | Electronic drawing data recording method and system | |
| JP2013517585A (en) | Method for accessing a large collection object table in a database | |
| CN108509198B (en) | Neutral BOM-based product electronic album construction method | |
| CN110032154B (en) | Production control method and system for small-batch products | |
| Muthalagu | Data Modeling for Engineering Change Management Processes in Engineering Industries | |
| CN114386920A (en) | Information operation system and method based on data sharing | |
| Berkani et al. | Value-driven Approach for Designing Extended Data Warehouses. | |
| TW200419388A (en) | System and method for automatically comparing and recoding difference between bills of material (BOM) | |
| CN105678523A (en) | TPM information management system proposal method | |
| CN109919496B (en) | Method and system for managing design rule knowledge of aircraft assembly process | |
| CN102779092A (en) | Citing checking system and citing checking method | |
| Woodall et al. | Data quality in analytics: key problems arising from the repurposing of manufacturing data | |
| CN111861401A (en) | Technical scheme of industry qualification management and online approval system | |
| Lu et al. | Intrafirm technology and knowledge transfer: a best practice perspective | |
| Piprani | Using orm-based models as a foundation for a data quality firewall in an advanced generation data warehouse | |
| CN112381228B (en) | Knowledge system construction and application method based on business | |
| TW201327432A (en) | Scalable order data validation method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160615 |
|
| RJ01 | Rejection of invention patent application after publication |