CN111782665A - Method and system for monitoring life cycle management of product and commodity - Google Patents
Method and system for monitoring life cycle management of product and commodity Download PDFInfo
- Publication number
- CN111782665A CN111782665A CN202010567248.1A CN202010567248A CN111782665A CN 111782665 A CN111782665 A CN 111782665A CN 202010567248 A CN202010567248 A CN 202010567248A CN 111782665 A CN111782665 A CN 111782665A
- Authority
- CN
- China
- Prior art keywords
- data
- modification
- life cycle
- information
- product
- 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
Images
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
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 discloses a method and a system for monitoring life cycle management of a product, and belongs to the technical field of data processing. The method comprises the following steps: acquiring life cycle data of a product, and establishing a database of the life cycle data of the product; generating a data modification table by a preset template aiming at a database; after the expenses of the produced commodities are on line, calling a database and modifying life cycle data of the produced commodities, recording modification information of the life cycle data of the produced commodities after modification, generating modification data for the modification information by using a preset template, and storing the modification data into a data modification table of the database; and calling a data modification table, taking the life cycle data of the product as a node each time, adding modified data to each node, generating a linear graph, and monitoring the life cycle of the product according to the linear graph. The invention solves the problem that when the data of the commodity is abnormal, the relevant operation records, time and operators can be found out most quickly, and the problem solving efficiency is improved.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a method and a system for monitoring life cycle management of a product.
Background
When the related online business processing of the operator is carried out, when the product information is found to be modified, the content and the reason of modifying the product cannot be known, and a modifier cannot be known. There is no detailed information, which affects other businesses when modifying a product.
In the process of business processing, when a problem occurs, a data modifier cannot be positioned.
Disclosure of Invention
In view of the above problems, the present invention provides a method for monitoring product lifecycle management, the method comprising:
acquiring life cycle data of a product, and establishing a database of the life cycle data of the product;
generating a data modification table by a preset template aiming at a database;
after the expenses of the produced commodities are on line, calling a database and modifying life cycle data of the produced commodities, recording modification information of the life cycle data of the produced commodities after modification, generating modification data for the modification information by using a preset template, and storing the modification data into a data modification table of the database;
and calling a data modification table, taking the life cycle data of the product as a node each time, adding modified data to each node, generating a linear graph, and monitoring the life cycle of the product according to the linear graph.
Optionally, modifying the information includes: and newly adding or modifying the generated change information, modifier information and modification time information of the price of the produced commodity.
Optionally, the preset template includes a plurality of modification elements, and the form field is larger than the largest modification element in all templates.
Optionally, each modification includes modifying the life cycle data of any one of the products or modifying the life cycle data of a plurality of the products in a batch.
Optionally, the method further comprises:
when the life cycle data of the produced commodity is modified and the modification information cannot be recorded, calling the life cycle data of the produced commodity before and after modification for comparison after modification to obtain difference data;
modifier information for the difference data is obtained.
The invention also provides a system for monitoring the life cycle management of the produced goods, which comprises the following steps:
the data processing module is used for acquiring the life cycle data of the produced goods and establishing a database of the life cycle data of the produced goods;
the preprocessing module is used for generating a data modification table by a preset template aiming at the database;
the recording module calls the database and modifies the life cycle data of the produced commodity after the expense of the produced commodity is on line, records modification information of the life cycle data of the produced commodity after modification, generates modification data for the modification information by a preset template, and stores the modification data into a data modification table of the database;
and the monitoring module calls the data modification table to take the life cycle data of the product as a node each time the life cycle data of the product is modified, adds modified data to each node to generate a linear graph, and monitors the life cycle of the product according to the linear graph.
Optionally, modifying the information includes: and newly adding or modifying the generated change information, modifier information and modification time information of the price of the produced commodity.
Optionally, the preset template includes a plurality of modification elements, and the form field is larger than the largest modification element in all templates.
Optionally, each modification includes modifying the life cycle data of any one of the products or modifying the life cycle data of a plurality of the products in a batch.
Optionally, the recording module is further configured to:
when the life cycle data of the produced commodity is modified and the modification information cannot be recorded, calling the life cycle data of the produced commodity before and after modification for comparison after modification to obtain difference data;
modifier information for the difference data is obtained.
Compared with the prior art, the invention has the beneficial effects that:
all modification records of the product are recorded, so that data information can be well supervised, each piece of modification information can be ensured to be supervised by a client, the data can not be maliciously modified, and the data security is greatly enhanced;
when the data of the commodity is abnormal, the relevant operation records, time and operators can be found out most quickly, and the problem solving efficiency is improved.
Drawings
FIG. 1 is a flow chart of a method for monitoring product lifecycle management according to the present invention;
FIG. 2 is a block diagram of a system for monitoring product lifecycle management according to the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments, which can be obtained by a person skilled in the art without any inventive step based on the embodiments of the present invention, are within the scope of the present invention.
The invention provides a method for monitoring the life cycle management of a product, as shown in figure 1, comprising:
acquiring life cycle data of a product, and establishing a database of the life cycle data of the product;
generating a data modification table by a preset template aiming at a database;
after the expenses of the produced commodities are on line, calling a database and modifying life cycle data of the produced commodities, recording modification information of the life cycle data of the produced commodities after modification, generating modification data for the modification information by using a preset template, and storing the modification data into a data modification table of the database;
when the life cycle data of the produced commodity is modified and the modification information cannot be recorded, calling the life cycle data of the produced commodity before and after modification for comparison after modification to obtain difference data;
acquiring modifier information of the difference data;
and calling a data modification table, taking the life cycle data of the product as a node each time, adding modified data to each node, generating a linear graph, and monitoring the life cycle of the product according to the linear graph.
Wherein, modifying the information comprises: and newly adding or modifying the generated change information, modifier information and modification time information of the price of the produced commodity.
The preset template comprises a plurality of modification elements, and the form field is larger than the maximum modification element in all templates.
Wherein, each modification comprises the modification of the life cycle data of any one product in the products or the batch modification of the life cycle data of a plurality of products in the products.
The invention is described in further detail below with reference to the attached drawing figures:
(1) modifying, by the system, the production trajectory of the commodity;
when the data in the database changes, adding information in the life cycle of the commodity;
when the charge is on line, adding a new piece of data to the database for information changed by adding or modifying the charge, a modifier, modification time and the like, and then displaying the new piece of data on the page through page query;
the elements required to be added in each newly added sentence are different, and the number of the elements required to be modified in the modification template is different, so that the table fields for storing the tracks are temporarily set to be 100, and the configured templates can be completely added into the database;
and the track display adopts a linear graph display, a node is added in each modification from the newly added point according to the time display, and if the node is modified in batch, only one node is displayed until the commodity is offline or the system time is reached.
(2) Generating a track by directly modifying database data;
when the database is directly operated and the database data is modified, because the database data does not pass through a commodity production system, a piece of modification data cannot be added in the track when the commodity production data is modified;
firstly, using a quartz timing task, storing all tables related to the strain system of the manufacturer in the timing task every day to obtain data of two days before and after the data of the day;
storing the data into a temporary table, comparing the data of two days, finding out the difference data through data comparison, comparing the difference data with the corresponding table in the product library, finding out the rest difference data, storing the difference data into a difference table, displaying the difference data on a page, notifying every day, filling the reasons and the modifiers for modification on the page, and storing the modification information into a track table.
When comparing with the product library, special fields such as serial numbers, up-down time and the like are required to be considered to be inconsistent in the two libraries, and the special fields are required to be removed when comparing.
The present invention also provides a system 200 for monitoring product lifecycle management, as shown in fig. 2, comprising:
the data processing module 201 is used for acquiring life cycle data of the product and establishing a database of the life cycle data of the product;
the preprocessing module 202 generates a data modification table by using a preset template aiming at the database;
the recording module 203 calls the database and modifies the life cycle data of the produced commodity after the expense of the produced commodity is on line, records modification information of the life cycle data of the produced commodity after modification, generates modification data for the modification information by using a preset template, and stores the modification data into a data modification table of the database;
when the life cycle data of the produced commodity is modified and the modification information cannot be recorded, calling the life cycle data of the produced commodity before and after modification for comparison after modification to obtain difference data;
acquiring modifier information of the difference data;
the monitoring module 204 calls the data modification table to modify the life cycle data of the product as a node each time, adds the modified data to each node to generate a linear graph, and monitors the life cycle of the product according to the linear graph.
Wherein, modifying the information comprises: and newly adding or modifying the generated change information, modifier information and modification time information of the price of the produced commodity.
The preset template comprises a plurality of modification elements, and the form field is larger than the maximum modification element in all templates.
Wherein, each modification comprises the modification of the life cycle data of any one product in the products or the batch modification of the life cycle data of a plurality of products in the products.
All modification records of the product are recorded, so that data information can be well supervised, each piece of modification information can be ensured to be supervised by a client, the data can not be maliciously modified, and the data security is greatly enhanced;
when the data is abnormal, the relevant operation records, time and operators can be found out most quickly, and the problem solving efficiency is improved.
The above is only a preferred embodiment of the present invention, and is not intended to limit the present invention, and various modifications and changes will occur to those skilled in the art. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (10)
1. A method for monitoring product lifecycle management, the method comprising:
acquiring life cycle data of a product, and establishing a database of the life cycle data of the product;
generating a data modification table by a preset template aiming at a database;
after the expenses of the produced commodities are on line, calling a database and modifying life cycle data of the produced commodities, recording modification information of the life cycle data of the produced commodities after modification, generating modification data for the modification information by using a preset template, and storing the modification data into a data modification table of the database;
and calling a data modification table, taking the life cycle data of the product as a node each time, adding modified data to each node, generating a linear graph, and monitoring the life cycle of the product according to the linear graph.
2. The method of claim 1, the modifying information, comprising: and newly adding or modifying the generated change information, modifier information and modification time information of the price of the produced commodity.
3. The method of claim 1, the preset template comprising a plurality of modification elements and a form field greater than a largest modification element of all templates.
4. The method of claim 1, wherein each modification comprises a lifecycle data modification of any one of the products or a batch modification of lifecycle data of a plurality of the products.
5. The method of claim 1, further comprising:
when the life cycle data of the produced commodity is modified and the modification information cannot be recorded, calling the life cycle data of the produced commodity before and after modification for comparison after modification to obtain difference data;
modifier information for the difference data is obtained.
6. A system for monitoring product lifecycle management, the system comprising:
the data processing module is used for acquiring the life cycle data of the produced goods and establishing a database of the life cycle data of the produced goods;
the preprocessing module is used for generating a data modification table by a preset template aiming at the database;
the recording module calls the database and modifies the life cycle data of the produced commodity after the expense of the produced commodity is on line, records modification information of the life cycle data of the produced commodity after modification, generates modification data for the modification information by a preset template, and stores the modification data into a data modification table of the database;
and the monitoring module calls the data modification table to take the life cycle data of the product as a node each time the life cycle data of the product is modified, adds modified data to each node to generate a linear graph, and monitors the life cycle of the product according to the linear graph.
7. The system of claim 6, the modification information, comprising: and newly adding or modifying the generated change information, modifier information and modification time information of the price of the produced commodity.
8. The system of claim 6, the preset template comprising a plurality of modification elements and a form field greater than a largest modification element of all templates.
9. The system of claim 6, wherein each modification comprises a modification of lifecycle data for any one of the products or a batch modification of lifecycle data for a plurality of the products.
10. The system of claim 6, the recording module further to:
when the life cycle data of the produced commodity is modified and the modification information cannot be recorded, calling the life cycle data of the produced commodity before and after modification for comparison after modification to obtain difference data;
modifier information for the difference data is obtained.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010567248.1A CN111782665A (en) | 2020-06-19 | 2020-06-19 | Method and system for monitoring life cycle management of product and commodity |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010567248.1A CN111782665A (en) | 2020-06-19 | 2020-06-19 | Method and system for monitoring life cycle management of product and commodity |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111782665A true CN111782665A (en) | 2020-10-16 |
Family
ID=72757155
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010567248.1A Pending CN111782665A (en) | 2020-06-19 | 2020-06-19 | Method and system for monitoring life cycle management of product and commodity |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111782665A (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103700010A (en) * | 2013-12-30 | 2014-04-02 | 世纪禾光科技发展（北京）有限责任公司 | Commodity trajectory system and correlation method |
| CN106203828A (en) * | 2016-07-11 | 2016-12-07 | 浪潮软件集团有限公司 | Data management platform based on data full life cycle management |
| CN106980638A (en) * | 2016-09-29 | 2017-07-25 | 阿里巴巴集团控股有限公司 | Operation note system, method and operation object modification information querying method |
| CN110347686A (en) * | 2019-07-02 | 2019-10-18 | 上海外高桥造船有限公司 | Record the method and system of engineering drawing modification information |
-
2020
- 2020-06-19 CN CN202010567248.1A patent/CN111782665A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103700010A (en) * | 2013-12-30 | 2014-04-02 | 世纪禾光科技发展（北京）有限责任公司 | Commodity trajectory system and correlation method |
| CN106203828A (en) * | 2016-07-11 | 2016-12-07 | 浪潮软件集团有限公司 | Data management platform based on data full life cycle management |
| CN106980638A (en) * | 2016-09-29 | 2017-07-25 | 阿里巴巴集团控股有限公司 | Operation note system, method and operation object modification information querying method |
| CN110347686A (en) * | 2019-07-02 | 2019-10-18 | 上海外高桥造船有限公司 | Record the method and system of engineering drawing modification information |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109255622B (en) | Traceable anti-fake data storage system | |
| CA3155689A1 (en) | Early-warning method for commodity inventory risk based on a statistical interquartile range, and system and computer-readable storage medium thereof | |
| US10956911B2 (en) | System and method of managing data injection into an executing data processing system | |
| US20090164305A1 (en) | System and method for managing product quality | |
| JP5600185B2 (en) | Method for accessing a large collection object table in a database | |
| CN108460598A (en) | A kind of real-time automation supervision reporting system based on double-strand framework block chain | |
| US11182364B2 (en) | Data analysis support apparatus and data analysis support method | |
| Nagabhushana | Data warehousing OLAP and data mining | |
| CN110942314A (en) | Abnormal account supervision method and device | |
| CN111782665A (en) | Method and system for monitoring life cycle management of product and commodity | |
| CN111626682A (en) | Cost accounting method and device, computer equipment and storage medium | |
| CN107480186B (en) | Business model data processing method and computer equipment | |
| US10885054B2 (en) | Tracking metadata changes in multiple data stores and generating alerts for detected data impacts | |
| JP6397099B1 (en) | Management device and management program for applicant information collection system | |
| WO2007089378A2 (en) | Apparatus and method for forecasting control chart data | |
| CN115082087A (en) | Food safety traceability system based on block chain and big data | |
| CN109388647B (en) | WEB-based data filling method and system | |
| CN110580145A (en) | Method for realizing batch price adjustment of medicines and having available document to be checked by B/S architecture-based pharmacy system | |
| CN104360997B (en) | A kind of big data bleach-out process based on structured database | |
| CN113934712B (en) | Method, device and equipment for processing field model of industrial quality inspection data | |
| CN106980921B (en) | User-defined risk analysis method | |
| CN109582710A (en) | A kind of method and system for realizing fixed point lookup to server by station number | |
| CN115292141B (en) | Scheduling abnormity early warning method based on sliding time window and monitoring server | |
| CN114298619A (en) | Electronic product ex-warehouse method, system, equipment and medium | |
| US11256708B2 (en) | Method of creating process protocols |
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 |