CN113254546A - Supply chain management and control system and method and electronic equipment - Google Patents
Supply chain management and control system and method and electronic equipment Download PDFInfo
- Publication number
- CN113254546A CN113254546A CN202110566084.5A CN202110566084A CN113254546A CN 113254546 A CN113254546 A CN 113254546A CN 202110566084 A CN202110566084 A CN 202110566084A CN 113254546 A CN113254546 A CN 113254546A
- Authority
- CN
- China
- Prior art keywords
- data
- supply chain
- amount
- chain management
- warehouse
- 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
- 238000013068 supply chain management Methods 0.000 title claims abstract description 48
- 238000000034 method Methods 0.000 title claims abstract description 40
- 238000005516 engineering process Methods 0.000 claims abstract description 57
- 238000000605 extraction Methods 0.000 claims abstract description 6
- 238000013079 data visualisation Methods 0.000 claims description 25
- 238000012800 visualization Methods 0.000 claims description 20
- 230000007306 turnover Effects 0.000 claims description 12
- 239000000463 material Substances 0.000 description 18
- 238000007726 management method Methods 0.000 description 15
- 238000004458 analytical method Methods 0.000 description 11
- 238000012545 processing Methods 0.000 description 10
- 230000008859 change Effects 0.000 description 8
- 230000008569 process Effects 0.000 description 8
- 238000012544 monitoring process Methods 0.000 description 7
- 230000009286 beneficial effect Effects 0.000 description 6
- 238000005553 drilling Methods 0.000 description 5
- 238000005215 recombination Methods 0.000 description 5
- 230000006798 recombination Effects 0.000 description 5
- 239000000284 extract Substances 0.000 description 4
- 230000006870 function Effects 0.000 description 4
- 238000007405 data analysis Methods 0.000 description 3
- 230000003203 everyday effect Effects 0.000 description 3
- 238000007619 statistical method Methods 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 2
- 238000004140 cleaning Methods 0.000 description 2
- 238000004590 computer program Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 238000011156 evaluation Methods 0.000 description 2
- 238000005065 mining Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 239000002994 raw material Substances 0.000 description 2
- 238000012384 transportation and delivery Methods 0.000 description 2
- 230000004075 alteration Effects 0.000 description 1
- 230000002354 daily effect Effects 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000003111 delayed effect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 230000008447 perception Effects 0.000 description 1
- 238000004886 process control Methods 0.000 description 1
- 230000008521 reorganization Effects 0.000 description 1
- 238000012954 risk control Methods 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000001131 transforming effect Effects 0.000 description 1
- 230000032258 transport Effects 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- 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/26—Visual data mining; Browsing structured data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/285—Clustering or classification
-
- 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/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06393—Score-carding, benchmarking or key performance indicator [KPI] analysis
-
- 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
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
- G06Q30/0282—Rating or review of business operators or products
-
- 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
- G06Q30/00—Commerce
- G06Q30/06—Buying, selling or leasing transactions
- G06Q30/0601—Electronic shopping [e-shopping]
- G06Q30/0605—Supply or demand aggregation
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Human Resources & Organizations (AREA)
- Development Economics (AREA)
- Strategic Management (AREA)
- Economics (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Entrepreneurship & Innovation (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Game Theory and Decision Science (AREA)
- Educational Administration (AREA)
- Operations Research (AREA)
- Tourism & Hospitality (AREA)
- Quality & Reliability (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a supply chain management and control system, a supply chain management and control method and electronic equipment, which comprise an extraction and storage module, an acquisition module and a selection and provision module, wherein on one hand, data are extracted from a database of each preset informatization system by using a data warehouse technology and are stored in a data warehouse in a classified manner, and the data can be extracted from different databases, so that 'information isolated island' is avoided.
Description
Technical Field
The invention relates to the technical field of supply chain management, in particular to a supply chain management and control system, a supply chain management and control method and electronic equipment.
Background
The supply chain is the process by which an enterprise purchases, transports, manufactures, distributes, and ultimately delivers raw materials and parts to customers. Supply chain management is the knowledge that the entire supply chain system is planned, coordinated, operated, controlled, and optimized. With the rapid development of the economy of China, the competition among enterprises gradually evolves into the competition among supply chains. Therefore, it is very important to adopt effective means to manage and control each link of the supply chain in enterprises.
In the daily management work of an enterprise, data of each link of a supply chain often needs to be analyzed and counted to form quantitative index items, and the index items are monitored, wherein key indexes related in the supply chain process comprise: order amount, warehouse entry amount, contract amount, payment amount, inventory amount, contract signing rate, payment rate, purchase price condition, supplier efficiency, order issuing rate, inventory turnover rate, quality problem condition and the like. The data for calculating the indexes are stored in a plurality of databases of different systems, and relate to a plurality of departments of an enterprise, and in addition, the indexes need to be manually exported from the different systems and then manually calculated and reported, so that the reporting work is very complicated, a large amount of manpower and material resources are needed, and the risk of data errors or data tampering exists in manual calculation. The existing system can not provide intuitive and effective data analysis and management decision support capability, and can not realize effective supply chain management and control, so that the reason for causing the problem lies in that:
1) information isolated island: the supply chain management is a matter throughout the whole enterprise work flow, and various informationized systems such as ERP, SAP, MES, cooperative office system and the like which are relatively independent in business work are used in the process. Various service data exist independently, the data lack reusability, the data cannot be analyzed and managed intuitively and effectively, and decision support capability cannot be provided for enterprise managers;
2) data difference, each system uses different databases including SqlSever, MySQL, Oracle, Dameng and the like, different databases are difficult to be directly interconnected, and related data in business cannot be directly integrated;
3) the method is lack of analysis, processing, monitoring and evaluation capabilities, the procurement delay is known to the future, the monitoring is lack of difficulty in finding and processing rapidly, and the suppliers cannot be evaluated according to data in multiple dimensions.
These problems lead us to weak process control of the supply chain, and the control precision is not enough. Therefore, the supply chain needs to be assisted by an informatization means to be finely controlled, manpower is liberated, and decision support is provided for a management layer in time.
Disclosure of Invention
The invention provides a supply chain management and control system, a supply chain management and control method and electronic equipment, aiming at the defects of the prior art.
The technical scheme of the supply chain management and control system is as follows:
comprises an extraction and storage module, an acquisition module and a selection and provision module;
the extraction and storage module is used for: extracting data from a database of each preset informatization system by using a data warehouse technology, and storing the data to a data warehouse in a classified manner;
the acquisition module is configured to: obtaining data corresponding to each preset index item according to the data stored in the data warehouse in a classified manner;
the selection providing module is used for: and selecting data corresponding to the target index item according to the user requirements, and providing the data for the user.
The beneficial effects of the supply chain management and control system are as follows:
on one hand, data are extracted from the database of each preset information system by using a data warehouse technology and are stored in the data warehouse in a classified mode, data can be extracted from different databases, information isolated islands are avoided, on the other hand, data corresponding to each preset index item are obtained according to the data stored in the data warehouse in a classified mode, so that a user can inquire the data corresponding to different target index items in time, a supplier can be evaluated in a multi-dimensional mode, fine control and management of a supply chain are achieved, manpower is liberated, and decision support can be provided for a management layer in time.
On the basis of the above scheme, the supply chain management and control system of the present invention may be further improved as follows.
Further, the selection providing module is further configured to: and visualizing the data corresponding to the target index item by using a data visualization technology, and providing a visualization result for a user.
The beneficial effect of adopting the further scheme is that: the data corresponding to the target index item can be conveniently and visually checked by the user, the efficiency is improved, and the user experience is improved.
Further, the selection providing module is further configured to visualize and display data corresponding to at least one preset index item by using a data visualization technology.
The beneficial effect of adopting the further scheme is that: and displaying data corresponding to at least one preset index item by default, so that the user can check the data conveniently, and the user experience is further improved.
Further, the plurality of preset index items include an inventory amount, an inventory turnover rate, an order amount, a warehousing amount, a contract amount, a payment amount, a warehousing non-signed contract amount, and a warehousing non-payment amount.
Further, still include the early warning module, the early warning module is used for: and respectively setting threshold values for the preset index items according to business needs, carrying out early warning pushing when the threshold values are exceeded, and reminding each responsible person to pay attention to processing in time by adopting a mode of sending a mail to a mailbox of the enterprise of the responsible person.
The technical scheme of the supply chain management and control method is as follows:
extracting data from a database of each preset informatization system by using a data warehouse technology, and storing the data to a data warehouse in a classified manner;
obtaining data corresponding to each preset index item according to the data stored in the data warehouse in a classified manner;
and selecting data corresponding to the target index item according to the user requirements, and providing the data for the user.
The beneficial effects of the supply chain management and control method provided by the invention are as follows:
on one hand, data are extracted from the database of each preset information system by using a data warehouse technology and are stored in the data warehouse in a classified mode, data can be extracted from different databases, information isolated islands are avoided, on the other hand, data corresponding to each preset index item are obtained according to the data stored in the data warehouse in a classified mode, so that a user can inquire the data corresponding to different target index items in time, a supplier can be evaluated in a multi-dimensional mode, fine control and management of a supply chain are achieved, manpower is liberated, and decision support can be provided for a management layer in time.
On the basis of the above scheme, the supply chain management and control method of the present invention may be further improved as follows.
Further, still include:
and visualizing the data corresponding to the target index item by using a data visualization technology, and providing a visualization result for a user.
The beneficial effect of adopting the further scheme is that: the data corresponding to the target index item can be conveniently and visually checked by the user, the efficiency is improved, and the user experience is improved.
Further, still include: and visualizing and displaying data corresponding to at least one preset index item by using a data visualization technology.
The beneficial effect of adopting the further scheme is that: and displaying data corresponding to at least one preset index item by default, so that the user can check the data conveniently, and the user experience is further improved.
Further, the plurality of preset index items include an inventory amount, an inventory turnover rate, an order amount, a warehousing amount, a contract amount, a payment amount, a warehousing non-signed contract amount, and a warehousing non-payment amount.
Furthermore, threshold values can be set for the preset index items respectively according to business needs, when the threshold values are exceeded, early warning pushing is carried out, and a mode of sending mails to mailboxes of enterprises of responsible persons is adopted to remind each responsible person to pay attention to processing in time.
The technical scheme of the electronic equipment is as follows:
comprising a memory, a processor and a program stored on the memory and running on the processor, the processor implementing the steps of a supply chain management method as claimed in any one of the above when executing the program.
Drawings
Fig. 1 is a schematic structural diagram of a supply chain management and control system according to an embodiment of the present invention;
fig. 2 is a second schematic structural diagram of a supply chain management and control system according to a second embodiment of the present invention;
fig. 3 is a schematic flowchart of a supply chain management and control method according to an embodiment of the present invention;
Detailed Description
As shown in fig. 1, a supply chain management and control system 200 according to an embodiment of the present invention includes an extracting and storing module 210, an obtaining module 220, and a selecting and providing module 230;
the extraction and storage module 210 is configured to: extracting data from a database of each preset informatization system by using a data warehouse technology, and storing the data to a data warehouse in a classified manner;
the obtaining module 220 is configured to: obtaining data corresponding to each preset index item according to the data stored in the data warehouse in a classified manner;
the selection providing module 230 is configured to: and selecting data corresponding to the target index item according to the user requirements, and providing the data for the user.
The enterprise determines the number of the preset information systems and the used database of each preset information system, for example, the preset information systems can be used for counting the data of raw material and part purchase, or counting the data of inventory detail list, warehouse entry and exit detail list, contract and the like, and the data warehouse technology is utilized to extract the data from the database of each preset information system and store the data into the data warehouse in a classified manner;
where classification is understood to be: data on inventory is classified into one category, data on contracts is classified into one category, and so on. The data extracted from the database of each preset informatization system can be classified according to each preset index item.
The preset index items comprise inventory amount, inventory turnover rate, order amount, warehousing amount, contract amount, payment amount, warehousing untagged contract amount and warehousing unpaid amount, and further comprise ex-warehouse amount and ex-warehouse quantity, material historical price and price change rate, supplier arrival rate and overdue condition, supplier million product fault rate, buyer order issuance overdue rate, buyer submission contract approval overdue rate, on-time buyer arrival rate, buyer warehouse entry overdue rate and the like. Specifically, the method comprises the following steps:
1) inventory amount: the data is classified and stored in a data warehouse by using a data warehouse technology, so that data corresponding to 'inventory amount', such as time, library age, project and complete set conditions and the like, are obtained from the data warehouse, and are subjected to data reorganization according to multiple dimensions of time, library age, project and complete set conditions and provided for a user in a form of a table;
2) the ex-warehouse amount and the ex-warehouse quantity are derived from a database of each preset information system, and are taken from an 'ex-warehouse entry detail list' of an SAP system database and an 'ex-warehouse entry detail list' of an ERP system, and because the data are classified and stored in a data warehouse by using a data warehouse technology, specific values of the ex-warehouse amount and specific values of the ex-warehouse quantity are obtained from the data warehouse, and then data of the 'ex-warehouse amount and the ex-warehouse quantity' are obtained and provided for a user;
3) stock turnover rate: the inventory turnover rate is 2 × the ex-warehouse amount/(the initial inventory amount + the end inventory amount), where the ex-warehouse amount is the above-mentioned ex-warehouse amount, the initial inventory amount is the above-mentioned inventory amount, that is, the early or late month inventory amount, and the end and late month inventory amounts are taken as the end inventory amounts, and since the data warehouse technology is used to store the data into the data warehouse in a classified manner, the data is stored according to the data warehouse in a classified manner: calculating the specific value of the ex-warehouse money, the initial inventory money and the final inventory money to obtain the specific value of the inventory turnover rate, namely the data of the inventory turnover rate, and providing the data to a user;
4) amount of the order: the data is classified and stored in a data warehouse by using a data warehouse technology, so that data corresponding to the order amount, such as time, items, wages, material categories, purchasers and the like, are obtained from the data warehouse, are subjected to data recombination according to multiple dimensions of the time, the items, the wages, the material categories, the purchasers and the like, and are provided for users in a table form;
5) warehousing amount: the data warehouse technology is utilized to store the data in a classified manner to the data warehouse, so that data corresponding to the warehousing amount, such as time, items, wages, material categories, purchasers and the like, are obtained from the data warehouse, and are subjected to data recombination according to multiple dimensions of the time, the items, the wages, the material categories, the purchasers and the like, and are provided for users in a table form;
6) contract amount: the data is classified and stored in a data warehouse by using a data warehouse technology, so that data corresponding to contract money, such as money, time, contract examination and approval states and the like on a contract, are obtained from the data warehouse, are subjected to data recombination according to dimensions such as time, contract examination and approval states and the like, and are provided for a user in a table form;
7) amount of outstanding contract in warehouse entry: the data warehouse entry and exit detail list and the contract header list and the contract body list are stored in a data warehouse in a classified manner by using a data warehouse technology, so that the entry and exit detail and contract conditions are jointly checked from the data warehouse according to the order, the specific value of the amount of the order which is warehoused but does not generate the contract is obtained, and the data of the amount of the order which is warehoused but not signed for the contract is obtained and provided for a user;
8) and (4) warehousing unpaid amount: the database from each preset information system is specifically a 'purchase order detail list' table, an in-out database detail list 'table, an ERP system database contract header' table, a 'contract table' table, a 'payment table header' table and a 'payment table body' table from an SAP system database.
9) Historical price and rate of change of price of material: the historical material price and the price change rate (highest price-lowest price)/average price are specifically taken from a purchase order detail list of an SAP system database, a contract table head list and a contract table body list in an ERP system database, and as the data are classified and stored to a data warehouse by using a data warehouse technology, the data are classified and stored according to the data in the data warehouse: and obtaining specific values of historical prices and price change rates of the materials by the highest price, the lowest price and the average price, recombining according to time, material codes, suppliers and purchase quantity dimensions, and providing the recombined materials to users in a table form.
10) Supplier arrival rate and overdue conditions: the supply arrival rate is the arrival order item/order item, the arrival completion rate is the arrival order item/order item, the number of items above X months is the ratio of the number of items above X months, the number of items above X months is the total number of items above X months, and the arrival timeliness rate is the arrival order item/total order item within the purchase period. The data are classified and stored in the data warehouse by using a data warehouse technology, so that a specific value of a supply and delivery rate, a specific value of the ratio of the number of items over X months of overdue and a specific value of the arrival and delivery timeliness rate are obtained by calculating according to the data in the data warehouse, and data recombination is carried out according to multiple dimensions such as overdue time, suppliers, material types, preferred grades and the like, and the data are provided for users in a table form.
11) Failure rate of million products of supplier: the failure rate of the million products of the supplier is the quality problem product quantity/1000000, and is specifically taken from a quality problem report table of an MES system database, a quality problem rapid processing table and a unqualified product auditing table of a cooperative office system database.
12) The buyer orders an overdue rate: the method specifically includes that a purchase order issue overdue rate of a buyer is obtained according to classified data stored in a data warehouse by using a data warehouse technology, the purchase order issue overdue rate of the buyer is obtained by calculation according to the classified data stored in the data warehouse, data recombination is carried out according to multiple dimensions of the buyer, time and the like, and the data are provided for users in a table form.
13) And (3) the buyer submits contract approval overrun rate: the method comprises the steps that a buyer submits contract approval overdue rate, namely an overdue uncommitted contract approval order item/a purchase order item, which is specifically taken from an examination and approval process table of a cooperative office system database, a purchase application detail table and a purchase order detail table in an SAP system, and a contract header table and a contract body table of an ERP system database.
14) The on-time arrival rate of the buyer: the system comprises a data warehouse technology, a buyer, a data warehouse and a user, wherein the on-time arrival rate of the buyer is the item of the on-time arrival order of the corresponding goods/the item of the on-time arrival order, and the data warehouse technology is used for storing the data into the data warehouse in a classified manner, calculating specific values of the on-time arrival rate of the buyer according to the classified and stored data in the data warehouse, recombining the data according to multiple dimensions of the buyer, time and the like, and providing the data to the user in a form of a table.
15) And (3) warehousing overdue rate of buyers: the data warehouse technology is used for storing the data into the data warehouse in a classified manner, the specific value of the warehouse entry overdue rate of the buyer is obtained by calculating the classified and stored data in the data warehouse, and the data is recombined according to multiple dimensions of the buyer, time and the like and is provided for the user in a table form.
It can be understood that the preset index item selected by the user is the target index item, for example, if the user needs to check the "stock amount", the "stock amount" is the target index item.
On one hand, data are extracted from the database of each preset information system by using a data warehouse technology and are stored in the data warehouse in a classified mode, data can be extracted from different databases, information isolated islands are avoided, on the other hand, data corresponding to each preset index item are obtained according to the data stored in the data warehouse in a classified mode, so that a user can inquire the data corresponding to different target index items in time, a supplier can be evaluated in a multi-dimensional mode, fine control and management of a supply chain are achieved, manpower is liberated, and decision support can be provided for a management layer in time.
Preferably, in the above technical solution, the selection providing module 230 is further configured to: and visualizing the data corresponding to the target index item by using a data visualization technology, and providing a visualization result for a user. The data corresponding to the target index item can be conveniently and visually checked by the user, the efficiency is improved, and the user experience is improved. Specifically, the method comprises the following steps:
1) the data corresponding to the inventory amount is visualized according to three dimensions of a project, a complete set of conditions and the inventory age by using a data visualization technology, a visualization result is visually displayed to a user, and the data can be specifically visualized by using existing mature software based on the data visualization technology, such as Yixin Huachen ABI software.
2) Visualizing data corresponding to the amount of the order by using a data visualization technology according to multiple dimensions such as time, items, wages, material categories, purchasers and the like, and visually displaying a visualization result to a user;
3) visualizing the data corresponding to the warehousing money amount by using a data visualization technology according to multiple dimensions such as time, items, job numbers, material categories, purchasers and the like, and visually displaying a visualization result to a user;
4) visualizing data corresponding to the historical price and the price change rate of the material by using a data visualization technology according to suppliers, material categories and the price change rate, and visually displaying a visualization result to a user;
5) visualizing data corresponding to the failure rate of million products of a supplier according to three dimensions of suppliers, material categories and preference levels by using a data visualization technology, and visually displaying a visualization result to a user;
6) data corresponding to the overdue rate issued by the order of the buyer is visualized according to various dimensions such as the buyer, time and the like by using a data visualization technology, and a visualization result is visually displayed to the user;
7) and visualizing the data corresponding to the contract approval overdue rate submitted by the buyer according to multiple dimensions such as the buyer, time and the like by using a data visualization technology, and visually displaying the visualization result to the user.
8) Visualizing data corresponding to the on-time arrival rate of the buyer according to multiple dimensions such as the buyer and time by using a data visualization technology, and visually displaying a visualization result to a user;
9) visualizing data corresponding to the warehousing overdue rate of the buyer according to multiple dimensions such as the buyer, time and the like by using a data visualization technology, and visually displaying a visualization result to a user;
wherein the visualization result is embodied in an image form, an animation form and/or an image form so as to be convenient for the user to view.
Preferably, in the above technical solution, the selection providing module 230 is further configured to visualize and display data corresponding to at least one preset index item by using a data visualization technology. The specific visualization technology refers to the above content, and is not repeated herein, and data corresponding to at least one preset index item is displayed by default, so that the user can check the data conveniently, and the user experience is further improved.
As shown in fig. 2, a platform constructed based on a supply chain management and control system 200 of the present application specifically includes 5 layers, which are a business data source 300, a data warehouse, a theme market 310, an application support and a business service 330, specifically:
1) the service data source 300 comprises databases of each preset information system, specifically an ERP system database, a PDM system database, an SAP system database, and some filled data not put in the databases;
2) a data warehouse: the extracting and storing module 210 extracts data from the business data source 300 by using a data warehouse technology, and stores the data to a data warehouse in a classified manner, wherein the topic market 310 includes different topics, specifically including buyers, suppliers, orders, contracts, and the like, that is, the data extracted from the business data source 300 is classified according to the buyers, suppliers, orders, contracts, and is stored separately.
3) In the application support 320, the data corresponding to each preset index item is obtained according to the data stored in the data warehouse in a classified manner, various analysis tools such as EXCEL software and SPSS software can be specifically inserted, the functions of statistical analysis, table generation and the like are realized by inserting plug-ins and the like, and in addition, the selection providing module 230 is further configured to: visualizing the data corresponding to the target index item by using a data visualization technology, and providing a visualization result for a user, namely displaying the visualization result on a platform;
4) business services 330, based on the data provided in application support 320, perform procurement process monitoring, supplier efficiency analysis, and supplier evaluation.
To address the need for cross-system, complex data monitoring, the supply chain management and control system of the present application can be considered as a Business Intelligence (BI) analysis system. Business intelligence is a set of theories, methods, procedures, and techniques for collecting, organizing, analyzing raw data, transforming it into meaningful information, and providing decision support. The method comprises the steps of extracting data of each service system, namely each preset information system, by using an Extract-Transform-Load (ETL) tool, namely a data warehouse technology, integrating, serially connecting, cleaning and converting the data to be acquired of various service data according to service relations, loading and storing the data into a data warehouse (DataWarehouse) according to a predefined data warehouse model, analyzing and mining the data in the data warehouse on the basis, and providing various visual pages, so that decision support is provided for a management layer, and a complete enterprise-level business intelligent analysis system is formed.
The data warehouse is different from the common database in that the common database stores original service data generated in each information system, and the data warehouse stores data which is cleaned and integrated according to analysis requirements. The ETL tool is an important ring in a BI analysis system, and is used for extracting required data from a plurality of different data warehouses, cleaning and converting the data and then storing the data into the data warehouses. Data analysis mining enables data analysts to quickly, consistently, and interactively view information from various dimensions, and mine deep information hidden beneath business information surfaces through statistical analysis processing, retrieval, and the like. For the analyzed data, the information such as data indexes and the like still needs to be converted into recognizable patterns, images, animations and the like, namely visualization results, and the user is allowed to interact with the data.
The supply chain management and control system 200 integrates mass data of heterogeneous systems in enterprise operation, and the heterogeneous systems are embodied in different databases of different preset informatization systems, so that more accurate and clear data guarantee is provided for decision support of enterprise managers. The problem that clinics in hospitals, factories and the like cannot effectively and immediately monitor key indexes is solved. The problem that enterprises cannot effectively and immediately monitor key indexes is effectively solved.
The supply chain management and control system 200 of the present application aims to provide a supply chain management and control system developed based on a business intelligence system, which takes the working requirements of business departments as starting points and monitors and analyzes each link and supplier of a purchasing process; the key managed and controlled index items, namely the preset index items, comprise: inventory amount, inventory turnover rate, ex-warehouse amount and ex-warehouse quantity, order amount, warehousing amount, contract amount, payment amount, warehousing untagged contract amount, warehousing unpaid amount, historical material price and price change rate, supplier arrival rate and overdue condition, supplier million product fault rate, buyer order issuance overdue rate, buyer submission contract approval overdue rate, buyer arrival rate on time and buyer entering warehouse overdue rate. The management layer of the system can be used for monitoring the existing risk items in real time and evaluating suppliers and buyers.
The supply chain management and control system 200 is a supply chain management and control system developed based on a commercial intelligent system, and the system integrates data of all business systems in an enterprise by adopting a commercial intelligent system, extracts the data of all business systems through an ETL tool, integrates and connects all business data in series according to business relations, constructs a unified and complete enterprise-level data warehouse, analyzes and mines the data in the data warehouse according to indexes concerned by business departments, provides all data analysis services, forms index items, integrates the index items into structured data according to displayed logics, processes the structured data into drillable and analyzable graphs for information display by using a Yixinhuachen ABI tool, and realizes information classified display through a platform.
Preferably, the statistical indicator with the highest user utilization rate is integrated into the top page of the information display platform, that is, the selection providing module 230 visualizes and displays the data corresponding to at least one preset indicator item by using a data visualization technology.
Preferably, the supply chain management and control system 200 of the present application is further provided with a layer-by-layer drilling function module, the drilling is to change the layers of the dimension, the granularity of the analysis is changed, the user can define the summary row data of the analysis factors in a guiding manner, and the drilling of multiple layers can view the lower layer data of finer granularity layer by layer. Drilling is a hierarchy of changing dimensions; when a certain data point is clicked by a mouse during checking, the lower-layer data can be captured; through the drilling function, the user can more deeply understand the data, can more easily find problems and make correct decisions.
The application relates to a chain management and control system, which specifically comprises the following components:
1) the ETL technology, namely a data warehouse system, is utilized to extract and store the data in each independent service system, namely each preset information system, which operates on line into the data warehouse in a classified manner, and particularly, the data can be extracted in a time period when each independent service system, namely each preset information system, is not busy every day in a self-defined manner, so that unnecessary pressure on the operating service system, namely each preset information system, is avoided, and normal operation is prevented from being influenced. The ETL technology can extract required data from different databases, solves the problem that various service data of different databases are independent, updates data every day to ensure that the data are all up-to-date every day, improves the analysis timeliness, reduces the manual processing link, reduces the workload, and improves the accuracy and the authenticity;
2) by utilizing the data warehouse technology, data in different formats in each preset information system are integrated and connected in series and stored in a unified data warehouse, so that the problems that the systems use different databases, the data formats are different, and related data in service cannot be directly integrated are solved. The data stored in the data warehouse can be directly analyzed and processed according to the analysis requirements;
3) by utilizing a data visualization technology, the deep information hidden under the surface of the business information is mined by using Yixin Huachen ABI software through statistical analysis processing, retrieval and other modes. The analyzed data still needs to convert information such as data indexes into recognizable forms such as graphs, images and animations, and allows users to interact with the data, so that data analysts can observe the information from all dimensions quickly, consistently and interactively. The method improves the capability of analyzing, processing, monitoring and evaluating the supply chain of the enterprise, and solves the problems that the perception after the purchase is delayed and the monitoring is lacked, so that the rapid discovery and processing are difficult.
The invention provides a supply chain management and control system developed based on a commercial intelligent system, which integrates all business information systems in an enterprise by utilizing the conventional commercial intelligent system, extracts key information of supply chain management and control from data in a business system which operates on line to a data warehouse by utilizing a data warehouse technology through an ETL tool level in the commercial intelligent system, analyzes and excavates the data in the data warehouse to define index items, and integrates the index items into data to be displayed; finally, data to be displayed are made into various charts by utilizing Yixin Huachen ABI, and the charts are visually displayed through an information display platform, and the detailed information is drilled and checked layer by layer;
according to experimental data, the supply chain management and control system 200 improves the supply chain risk control capability and can accurately position the delay link and the problem main body. The information is transparent, the control is carried out by data speaking, and the reflecting result is objective and accurate. A plurality of hidden problems on the service are exposed, the service management is promoted, and a new mode and means are provided for service management and control. The labor productivity is improved, the original supply chain information acquisition is time-consuming and labor-consuming, manual statistics and layer-by-layer reporting are needed, and the information can be acquired from the system at any time. And decision support basis is provided for enterprise managers.
As shown in fig. 3, a supply chain management and control method according to an embodiment of the present invention includes the following steps,
s1, extracting data from the database of each preset information system by using a data warehouse technology, and storing the data to a data warehouse in a classified manner;
s2, obtaining data corresponding to each preset index item according to the data stored in the data warehouse in a classified manner;
and S3, selecting data corresponding to the target index item according to the user requirement, and providing the data to the user.
On one hand, data are extracted from the database of each preset information system by using a data warehouse technology and are stored in the data warehouse in a classified mode, data can be extracted from different databases, information isolated islands are avoided, on the other hand, data corresponding to each preset index item are obtained according to the data stored in the data warehouse in a classified mode, so that a user can inquire the data corresponding to different target index items in time, a supplier can be evaluated in a multi-dimensional mode, fine control and management of a supply chain are achieved, manpower is liberated, and decision support can be provided for a management layer in time.
Preferably, in the above technical solution, the method further comprises:
and S4, visualizing the data corresponding to the target index item by using a data visualization technology, and providing a visualization result for a user. The data corresponding to the target index item can be conveniently and visually checked by the user, the efficiency is improved, and the user experience is improved.
Preferably, in the above technical solution, the method further comprises:
and S5, visualizing and displaying the data corresponding to the at least one preset index item by using a data visualization technology. And displaying data corresponding to at least one preset index item by default, so that the user can check the data conveniently, and the user experience is further improved.
Preferably, in the above technical solution, the plurality of preset index items include an inventory amount, an inventory turnover rate, an order amount, a warehousing amount, a contract amount, a payment amount, a warehousing non-signed contract amount, and a warehousing non-payment amount.
For the above parameters and steps in the supply chain management and control method of the present invention, reference may be made to the above process for implementing the corresponding function by each unit module in the embodiment of the supply chain management and control system 200, which is not described herein again.
In the foregoing embodiments, although the steps are numbered as S1, S2, etc., but only the specific embodiments are given in this application, and those skilled in the art may adjust the execution sequence of S1, S2, etc. according to the actual situation, which is also within the protection scope of the present invention, and it is understood that some embodiments may include some or all of the above embodiments.
An electronic device according to an embodiment of the present invention includes a memory, a processor, and a program stored in the memory and running on the processor, where the processor implements any of the above-described steps of the supply chain management method when executing the program.
In the above description, for each parameter and step in the electronic device of the present invention, reference may be made to each parameter and step in the above embodiment of a supply chain management and control method, which is not described herein again.
As will be appreciated by one skilled in the art, the present invention may be embodied as a system, method or computer program product.
Accordingly, the present disclosure may be embodied in the form of: may be embodied entirely in hardware, entirely in software (including firmware, resident software, micro-code, etc.) or in a combination of hardware and software, and may be referred to herein generally as a "circuit," module "or" system. Furthermore, in some embodiments, the invention may also be embodied in the form of a computer program product in one or more computer-readable media having computer-readable program code embodied in the medium.
Any combination of one or more computer-readable media may be employed. The computer readable medium may be a computer readable signal medium or a computer readable storage medium. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the computer-readable storage medium include an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
Although embodiments of the present invention have been shown and described above, it is understood that the above embodiments are exemplary and should not be construed as limiting the present invention, and that variations, modifications, substitutions and alterations can be made to the above embodiments by those of ordinary skill in the art within the scope of the present invention.
Claims (9)
1. A supply chain management and control system is characterized by comprising an extraction and storage module, an acquisition module and a selection and provision module;
the extraction and storage module is used for: extracting data from a database of each preset informatization system by using a data warehouse technology, and storing the data to a data warehouse in a classified manner;
the acquisition module is configured to: obtaining data corresponding to each preset index item according to the data stored in the data warehouse in a classified manner;
the selection providing module is used for: and selecting data corresponding to the target index item according to the user requirements, and providing the data for the user.
2. The supply chain management and control system according to claim 1, wherein the selection providing module is further configured to: and visualizing the data corresponding to the target index item by using a data visualization technology, and providing a visualization result for a user.
3. The supply chain management and control system according to claim 2, wherein the selection providing module is further configured to visualize and display data corresponding to at least one preset index item by using a data visualization technology.
4. The supply chain management and control system according to any one of claims 1 to 3, wherein the plurality of preset index items include an inventory amount, an inventory turnover rate, an order amount, a warehousing amount, a contract amount, a payment amount, a warehousing non-signed contract amount, and a warehousing non-payment amount.
5. A supply chain management and control method is characterized by comprising the following steps:
extracting data from a database of each preset informatization system by using a data warehouse technology, and storing the data to a data warehouse in a classified manner;
obtaining data corresponding to each preset index item according to the data stored in the data warehouse in a classified manner;
and selecting data corresponding to the target index item according to the user requirements, and providing the data for the user.
6. The supply chain management and control method according to claim 5, further comprising:
and visualizing the data corresponding to the target index item by using a data visualization technology, and providing a visualization result for a user.
7. The supply chain management and control method according to claim 6, further comprising: and visualizing and displaying data corresponding to at least one preset index item by using a data visualization technology.
8. The supply chain management and control method according to any one of claims 5 to 7, wherein the preset index items comprise an inventory amount, an inventory turnover rate, an order amount, a warehousing amount, a contract amount, a payment amount, a warehousing non-signed contract amount and a warehousing non-payment amount.
9. An electronic device comprising a memory, a processor and a program stored on the memory and running on the processor, wherein the processor when executing the program implements the steps of a supply chain management method according to any one of claims 5 to 8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110566084.5A CN113254546A (en) | 2021-05-24 | 2021-05-24 | Supply chain management and control system and method and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110566084.5A CN113254546A (en) | 2021-05-24 | 2021-05-24 | Supply chain management and control system and method and electronic equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113254546A true CN113254546A (en) | 2021-08-13 |
Family
ID=77184117
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110566084.5A Pending CN113254546A (en) | 2021-05-24 | 2021-05-24 | Supply chain management and control system and method and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113254546A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106991183A (en) * | 2017-03-27 | 2017-07-28 | 福建数林信息科技有限公司 | A kind of business intelligence ETL method for packing and system |
| CN110135811A (en) * | 2019-05-16 | 2019-08-16 | 武汉神算云信息科技有限责任公司 | For the supply-chain management system and equipment at project scene |
| CN112100264A (en) * | 2020-09-16 | 2020-12-18 | 国网辽宁省电力有限公司电力科学研究院 | Power project contract monitoring system and method |
| CN112488612A (en) * | 2020-11-26 | 2021-03-12 | 国网河北省电力有限公司物资分公司 | Visualization-based full inventory resource monitoring and displaying method |
| CN112732823A (en) * | 2020-12-30 | 2021-04-30 | 福建正孚软件有限公司 | Method for realizing enterprise material supply whole process monitoring system |
-
2021
- 2021-05-24 CN CN202110566084.5A patent/CN113254546A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106991183A (en) * | 2017-03-27 | 2017-07-28 | 福建数林信息科技有限公司 | A kind of business intelligence ETL method for packing and system |
| CN110135811A (en) * | 2019-05-16 | 2019-08-16 | 武汉神算云信息科技有限责任公司 | For the supply-chain management system and equipment at project scene |
| CN112100264A (en) * | 2020-09-16 | 2020-12-18 | 国网辽宁省电力有限公司电力科学研究院 | Power project contract monitoring system and method |
| CN112488612A (en) * | 2020-11-26 | 2021-03-12 | 国网河北省电力有限公司物资分公司 | Visualization-based full inventory resource monitoring and displaying method |
| CN112732823A (en) * | 2020-12-30 | 2021-04-30 | 福建正孚软件有限公司 | Method for realizing enterprise material supply whole process monitoring system |
Non-Patent Citations (4)
| Title |
|---|
| MICHAEL J.COREY 等: "《Oracle 8数据仓库分析、构建实用指南》", vol. 1, 31 January 2000, 机械工业出版社, pages: 271 - 273 * |
| 孙澄生 等: "《财会·税务·审计实用技术》", vol. 1, 31 December 1996, 东北大学出版社, pages: 312 * |
| 梁勇 等: "《数字农业框架体系与田块建模研究》", vol. 1, 31 January 2015, 中国农业大学出版社, pages: 19 - 20 * |
| 盛骏飞: "《企业集团全面管理提升指引》", vol. 1, 31 January 2013, 中国市场出版社, pages: 350 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11055731B2 (en) | Parallel processing historical data | |
| US8620716B2 (en) | Computer system and method for detecting and processing changes in data | |
| US20100287146A1 (en) | System and method for change analytics based forecast and query optimization and impact identification in a variance-based forecasting system with visualization | |
| US20090319931A1 (en) | Visual Intelligence Systems | |
| US20020116213A1 (en) | System and method for viewing supply chain network metrics | |
| Schiefer et al. | Process information factory: a data management approach for enhancing business process intelligence | |
| CN108846691A (en) | Regional grain and oil market price monitoring analysing and predicting system and monitoring method | |
| WO2004102323A2 (en) | System or method for analyzing information organized in a configurable manner | |
| Kueng et al. | A holistic process performance analysis through a performance data warehouse | |
| CN114118883B (en) | Financial cost mining and analyzing system and method based on big data | |
| US20130311242A1 (en) | Business Process Analytics | |
| Dolk | Integrated model management in the data warehouse era | |
| JP2004021364A (en) | Management intention decision support system | |
| CN108846645A (en) | A kind of enterprise's flattened management method and system | |
| CN117252632A (en) | Commodity price analysis system and method based on computer | |
| CN114124743B (en) | Method and system for executing full-link inspection rule of data application | |
| US7912809B2 (en) | Data management system for manufacturing enterprise and related methods | |
| JP2008117127A (en) | Method, device and program for extracting candidates of business efficiency degradation cause in business process | |
| CN116957475B (en) | Cloud computing-based oral cavity clinic warehouse management method, system and device | |
| CN113592378A (en) | BOM construction method and management system of large complex equipment | |
| CN115759832A (en) | Product quality tracing early warning method and system, storage medium and electronic equipment | |
| CN117216150A (en) | Data mining system based on data warehouse | |
| CN113254546A (en) | Supply chain management and control system and method and electronic equipment | |
| Stefanovic et al. | Application of data mining for supply chain inventory forecasting | |
| Kleijnen | Quantifying the benefits of information systems |
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 |