CN115587689B - Data management system and method based on big data technology - Google Patents

Data management system and method based on big data technology Download PDF

Info

Publication number
CN115587689B
CN115587689B CN202211097136.XA CN202211097136A CN115587689B CN 115587689 B CN115587689 B CN 115587689B CN 202211097136 A CN202211097136 A CN 202211097136A CN 115587689 B CN115587689 B CN 115587689B
Authority
CN
China
Prior art keywords
module
accessories
budget
data
information
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN202211097136.XA
Other languages
Chinese (zh)
Other versions
CN115587689A (en
Inventor
燕建强
赵福亭
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shandong Xinminghui Safety Technology Co ltd
Shandong Yi'anjie Technology Co ltd
Xinminghui Supply Chain Co ltd
Original Assignee
Shandong Xinminghui Safety Technology Co ltd
Shandong Yi'anjie Technology Co ltd
Xinminghui Supply Chain Co ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Shandong Xinminghui Safety Technology Co ltd, Shandong Yi'anjie Technology Co ltd, Xinminghui Supply Chain Co ltd filed Critical Shandong Xinminghui Safety Technology Co ltd
Priority to CN202211097136.XA priority Critical patent/CN115587689B/en
Publication of CN115587689A publication Critical patent/CN115587689A/en
Application granted granted Critical
Publication of CN115587689B publication Critical patent/CN115587689B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

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/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
    • G06Q10/063—Operations research, analysis or management
    • G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
    • G06Q10/06315—Needs-based resource requirements planning or analysis
    • 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/22—Indexing; Data structures therefor; Storage structures
    • G06F16/2282—Tablespace storage structures; Management thereof
    • 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/2379—Updates performed during online database operations; commit processing
    • 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/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
    • G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
    • 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/0283—Price estimation or determination
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/30—Computing systems specially adapted for manufacturing

Abstract

The invention discloses a data management system and a method based on big data technology, and relates to the technical field of data management, wherein the data management system comprises an input and output module and a processing unit, the input and output module and the processing unit are mutually used for transmitting data, a designer fills all selected accessories into a production form, the input and output module is used for transmitting the production form into a preprocessing module for data preprocessing, a budget module is used for retrieving inventory data in a storage module according to the types and the quantity of the accessories required in the production form, after calculation and obtaining a result, the budget module selectively informs a purchasing module to purchase or informs the designer of order confirmation or informs the designer of replacement confirmation according to the calculation result, the data in the production form is processed through the data management system, thereby being beneficial to rationalized replacement use of the accessories in stock, effectively combining the production plan and the purchasing plan, and realizing effective control of production cost.

Description

Data management system and method based on big data technology
The invention relates to the technical field of data management, in particular to a data management system and method based on big data technology.
Background
Along with the improvement of industrial automation and intelligent level, a data management system based on big data technology is also widely applied in the field of industrial automation, and the data management system is applied to a cost accounting link of a machine production link.
Because the machine-made products are very customized, they are assembled, designed, manufactured and produced according to the customer's needs and the orders; this results in a large number of specifications of the product, complicated purchase, and easy increase in cost for controlling the quality of the product. In terms of production operation and production field, the production concept is relatively lagged, and the production operation is difficult to adapt to the competitive demands of the market, and is mainly embodied in: a machine-made enterprise planning approach without a data management system; production plans and procurement plans cannot be effectively combined; lack of standardized, normalized, institutional, programmatic management.
Disclosure of Invention
The present invention is directed to a data management system and method based on big data technology, so as to solve the problems set forth in the background art.
In order to solve the technical problems, the invention provides the following technical scheme:
the data management system based on the big data technology comprises an input and output module and a processing unit, wherein the input and output module and the processing unit mutually transmit data, the input and output module transmits an order contract and a production form to the processing unit, the processing unit processes the data in the production form, and the processing unit transmits a processing result to the input and output module;
The processing unit comprises a preprocessing module, a budget module and a warehousing module, wherein data are mutually transmitted between the preprocessing module and the budget module, and data are mutually transmitted between the budget module and the warehousing module. After the customer places a bill, a designer selects proper accessories according to the requirements of the customer and the types of mechanical accessories in the order, and fills all the selected accessories into a production form, an input-output module transmits the production form into a preprocessing module for data preprocessing, a budget module invokes inventory data in a storage module according to the types and the numbers of the accessories required in the production form and calculates, after the result is obtained, the budget module selectively informs a purchasing module to purchase or informs the designer, namely a user to confirm the order or inform the designer to confirm a replacement according to the calculation result, and a data management system processes the data in the production form, so that the reasonable replacement of the accessories in the inventory is facilitated, the plan and the targeted purchase are facilitated, the production plan and the purchase plan are effectively combined, and the effective control of the production cost is realized.
The input/output module marks the production form as a j Wherein j is more than or equal to 1 and is a positive integer, and on a single production form, j is only represented as the serial number of the production form, and the input/output module fills in the completed production form a j Transmitting to a preprocessing module; production form a j For the designer to produce form a based on the overall form of the selected parts of the machine parts in the order at the time of customer ordering j The content in the product form a comprises the name, model number and quantity of accessories j Each column of the order contract is a fitting, the order contract comprises the transaction amount of the mechanical fitting, and the order contract is matched with the production form.
The pretreatment module is used for producing the form a j Splitting a plurality of production forms a j Single row data expressed as the number of accessories in the same column number i are combined to form a number of accessories columnWherein i is equal to or greater than 1 and i is an ordered set of positive integers, i being represented as production form a j The number of columns in (1) in the number of fittings column->Wherein j is the number of items in the number of parts array, and the production form a j Serial number of (2) and number of parts are in series->Corresponding to the number of items, form a is produced 1 Production form a 2 Production form a 3 …, production form a 6 Number of parts formed by data in column 1 Column->Number of parts column->The second item of (2) is->Number of parts formed by data in column 2 column +.>Number of parts column->The third item in (2) is->The preprocessing module sorts the names of the accessories, and the number of the accessories is listed in the order of the names of the accessories>Sorting, wherein the pretreatment module sorts the number of the plurality of accessories after sorting into a number sequence +.>And the accessory name ordering is sent to the budget module.
The budget module receives the accessory name ordering and accessory number array transmitted by the preprocessing moduleThe budget module sends an instruction for calling the inventory quantity of the accessories to the storage module according to the received accessory name ordering;
the storage module is used for ordering and calling the inventory quantity of corresponding accessories according to the accessory names, and exporting the inventory quantity of the accessories into an inventory sequence K according to the accessory names n Wherein n is greater than or equal to 1 and is an ordered positive integer set, n is the number of inventory array items, elements in the set n are mapped with elements in the set i one by one, and the inventory array K is stored by the warehouse module n To the budget module.
The budget module receives the inventory number series K sent by the warehouse module n And for each number of parts, a plurality of parts are arrangedSumming, and storing the number K in the budget module n The number of parts per item minus the number of parts per item is in the column +. >Sum to obtain the stock allowance number series Z of all accessories n 。
The total number of the accessories is calculated by summing up the total number of the accessories to obtain the stock allowance, thereby calculating the consumption total amount of the accessories, and when the consumption total amount exceeds the limit amount (the limit amount is formulated by enterprises and is used for controlling the use amount of the accessories), the use amount of two or three accessories is the number of the accessoriesWhen the sum of (2) exceeds the limit number, the budget module is added to the number of accessories according to the number size>The number of parts is ordered by size, and after ordering, the number of parts is ordered by number column +.>The number of the primary items of each item is kept unchanged, the first two items and the second two items are selected from the sorting, and the budget module inquires the production form a where the accessory is located according to the number of the primary items of the first two items and the second two items j And for each production form a j The total cost involved is calculated while the budget module queries the production form a j By calculating the total cost and the amount of the deal, dividing the amount of the deal by the total cost multiplied by 100%, and if the calculated cost profit margin (the acquisition percentage is made by the enterprise) is lower than the cost profit margin made by the enterprise, making the production form a j Production form a for positioning fitting data to be adjusted j Screening out the data of the fittings needing to be adjustedForm a of (2) j After that, the budget module sends replacement information to the storage module, the replacement information comprises the names of the accessories, the types of the accessories and the quantity of the accessories to be replaced, the storage module receives the replacement information, queries the accessories of different types which can be used for reducing the production cost or the accessories of different types of stock backlog according to the replacement information, feeds back the replaceable information to the budget module, the replaceable information comprises the names of the accessories, the types of the accessories, the quantity of the accessories and the sales amount of the accessories which are used for replacement, the budget module replaces the replaced accessories according to the replaceable information, and the budget module replaces the types and the quantity of the accessories to realize effective control of the production cost.
The processing unit also comprises a purchasing module, wherein the warehousing module and the purchasing module mutually transmit data;
the budget module transmits data to the purchasing module in one way, and the purchasing module transmits data to the preprocessing module in one way;
the budget module sets the stock allowance number series Z of all accessories n The data in (a) is transmitted to the purchasing module or the input-output module.
A method of a data management system based on big data technology, the method comprising the steps of:
s1, inputting production data;
s2, processing production data;
s3, calculating production data and feeding back order information;
and S4, confirming feedback information, and updating data of the data management system.
The step S1 comprises the following specific steps:
s101, the input/output module marks the production form as a j Wherein j is greater than or equal to 1 and is a positive integer, and on a single production form, j is only represented as the serial number of the production form, and the completed production form a is filled in j Input into an input-output module; when a production form is input, the input is recorded as a production form a 1 When two production forms are input, the two production forms are recorded as a production form a 2 When the upper limit m production forms are input, the upper limit m production forms are recorded as a production form a m At least one production form is input into the input/output module, and the upper limit is m production forms.
Step S102, the input/output module receives the production form a j Transmitting to a preprocessing module, and carrying out the next step S2;
the step S2 comprises the following specific steps:
step S201, a preprocessing module processes the production form a j Splitting a plurality of production forms a j Single row data expressed as the number of accessories in the same column number i are combined to form a number of accessories columnWherein i is equal to or greater than 1 and i is an ordered set of positive integers, i being represented as production form a j Column number in (a) production form a j The number of fittings in the first column is +.>Production form a j The number of fittings in the second column is +.>Production form a j The number of fittings in the nth column is +.>The preprocessing module sorts the names of the accessories, and the number of the accessories is listed in the order of the names of the accessories>Sorting, wherein the pretreatment module sorts the number of the plurality of accessories after sorting into a number sequence +.>And the accessory name ordering is sent to the budget module, and the next step S3 is carried out.
The step S3 comprises the following specific steps:
step S301, the budget module receives the accessory name ordering transmitted by the preprocessing module in step S202Number of parts is in a seriesThe budget module sends an instruction for calling the inventory quantity of the accessories to the storage module according to the received accessory name ordering;
step S302, the budget module is used for counting and arranging the number of each accessoryCarrying out summation treatment, wherein the summation formula is +.>Wherein j is greater than or equal to 1 and is a positive integer, j is represented as a sequence number of the production form, i is greater than or equal to 1 and i is an ordered positive integer set, and i is represented as a production form a j Column number of (a);
step S303, the warehouse module retrieves the inventory quantity of the corresponding accessories according to the accessory name ordering, and derives the accessory inventory quantity to an inventory number sequence K according to the accessory name ordering n Wherein n is more than or equal to 1 and n is an ordered positive integer set, n is the number of inventory array items, elements in the set n are mapped with elements in the set i one by one, the value of each item is the inventory number of a fitting, and the inventory module stores the inventory array K n Transmitting to a budget module;
step S304, the budget module receives the inventory number sequence K sent by the warehouse module n Inventory number sequence K for budget module n Number of parts per item minus number of parts per itemSum to obtain the stock allowance number series Z of all accessories n The calculation formula is as follows: />
Step S305, budget module counts Z of inventory margins i Screening each item of stock allowance data, and comparing the screened data with the stock allowance value larger than zero with the minimum quantity of accessories formulated by enterprises when the accessories need to be purchased;
step S306, in step S305, when the screened data is lower than the minimum number of accessories formulated by enterprises and needed to be purchased, the budget module sends purchasing information to the purchasing module, and then step S308 is performed;
Step S307, in step S305, when the screened data is higher than the lowest number of accessories formulated by enterprises and needed to be purchased, the budget module does not send purchasing information to the purchasing module, and then step S308 is performed;
step S308, the budget module sends order information to the preprocessing module, the order information comprises names of final order placing accessories, the number of final order placing accessories and the order placing date, the preprocessing module sends the order information to the input and output module, the input and output module displays the order information, and the step S4 is entered, and the user is waited for confirmation.
The step S3 further comprises the following specific steps:
step S309, in step S305, the budget module sends replacement information to the warehouse module according to the names of the accessories with the inventory balance value smaller than zero, wherein the replacement information comprises the names of the accessories with the inventory balance value smaller than zero and the required quantity, the warehouse module inquires the accessories available for replacement according to the replacement information and sends replacement feedback information to the budget module, and the replacement feedback information comprises the names of the accessories used for replacement, the model numbers of the accessories, the quantity of the accessories and the sales amount of the accessories;
in step S3010, in step S309, the budget module receives the replacement feedback information sent by the warehouse module, and sends the replacement feedback information to the preprocessing module, and the preprocessing module sends the replacement feedback information to the input/output module, where the input/output module outputs and displays the replacement feedback information, and proceeds to step S4, and waits for confirmation of the user.
The step S3 further comprises the following specific steps:
step S3011, in step S304, the number of parts is set in a plurality of rowsWhen the sum of the numbers exceeds the limit number, the budget module counts the number of accessories according to the numerical valueQuantity sequence->The number of parts is ordered by size, and after ordering, the number of parts is ordered by number column +.>The number of the primary items of each item is kept unchanged, the first two items and the second two items are selected from the sorting, and the budget module inquires the production form a where the accessory is located according to the number of the primary items of the first two items and the second two items j And for each production form a j The total cost involved is calculated while the budget module queries the production form a j By calculating the total cost and the amount of the deal, dividing the amount of the deal by the total cost multiplied by 100%, and if the calculated cost profit margin (the acquisition percentage is made by the enterprise) is lower than the cost profit margin made by the enterprise, making the production form a j Production form a for positioning fitting data to be adjusted j Screening out a production form a needing to adjust accessory data j After that, the budget module sends replacement information to the warehouse module, wherein the replacement information comprises accessory names, accessory models and accessory numbers which need to be replaced;
Step S3012, according to the content of step S3011, the warehouse module receives replacement information, queries accessories of different types or accessories of different types of stock backlog, which can be used for reducing production cost, according to the replacement information, and feeds back the replacement information to the budget module, wherein the replacement information comprises accessory names, accessory types, accessory number and accessory sales amount used for replacement, the budget module replaces the replaced accessories according to the replacement information and generates a production form copy, the budget module sends the production form copy to the preprocessing module, the preprocessing module sends the production form copy to the input/output module, and the input/output module outputs and displays the production form copy, and enters step S4 to wait for confirmation of a user.
The step S4 comprises the following specific steps:
step S401, in step S308, the user signals the orderAfter verification and determination of information, the input/output module sends determination information to the preprocessing module, the preprocessing module sends the determination information to the budget module, the budget module sends inventory data update information to the warehousing module according to the determination information, the data update information comprises accessory names, accessory models and the number of the left accessories to be updated, the warehousing module updates the warehousing information according to the data update information sent by the budget module and feeds back data update success information to the budget module, the operation of the data management system is stopped after the budget module receives the update success information until a new production form a sent by the input/output module is received next time j ；
Step S402, in step S309, after the user checks and determines the replacement feedback information, the input/output module sends the determination information to the preprocessing module, the preprocessing module sends the determination information to the budget module, and the budget module generates the form a according to the determination information j Is replaced, and returns to step S308.
Step S403, in step S3012, after the user checks and determines the copy of the production form, the input/output module sends determination information to the preprocessing module, the preprocessing module sends the determination information to the budget module, and the budget module checks and determines the production form a according to the determination information j Is replaced, and returns to step S308.
Compared with the prior art, the invention has the following beneficial effects:
1. the input and output module transmits the production form to the preprocessing module for data preprocessing, the budget module invokes inventory data in the storage module according to the types and the quantity of accessories required in the production form and calculates, after the result is obtained, the budget module selectively informs the purchasing module to purchase or informs a designer, namely a user to confirm an order or inform the designer to confirm a replacement according to the calculation result, and the data in the production form is processed through the data management system, so that the reasonable replacement of the accessories in inventory is facilitated, the plan and the pertinence purchasing are facilitated, the production plan and the purchasing plan are effectively combined, and the effective control of the production cost is realized.
2. Number of parts is in a seriesWhen the sum of the number of the accessories exceeds the limit number, the budget module counts the number of the accessories according to the value sizeThe size sorting is carried out on a plurality of items in the model, the first two items and the second two items are selected from the sorting, and the budget module inquires the production form a where the accessories are positioned according to the original numbers of the first two items and the second two items j And for each production form a j The total cost involved is calculated while the budget module queries the production form a j By calculating the total cost and the amount of the deal, and screening out the production form a needing to adjust the fitting data by the cost profit margin j And then, the budget module sends replacement information to the storage module, the storage module receives the replacement information, queries accessories of different types which can be used for reducing production cost or accessories of different types of stock backlog according to the replacement information, feeds back the replacement information to the budget module, replaces the replaced accessories according to the replacement information, and replaces the types and the number of the accessories by the budget module, so that effective control of the production cost is realized.
Drawings
The accompanying drawings are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate the invention and together with the embodiments of the invention, serve to explain the invention. In the drawings:
FIG. 1 is a block diagram of a data management system of the present invention;
FIG. 2 is a flow chart of a data management method of the present invention;
FIG. 3 is a schematic representation of a production form of the present invention.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
Referring to fig. 1, the present invention provides the following technical solutions:
the data management system based on the big data technology comprises an input and output module and a processing unit, wherein the input and output module and the processing unit mutually transmit data, the input and output module transmits an order contract and a production form to the processing unit, the processing unit processes the data in the production form, and the processing unit transmits a processing result to the input and output module;
the processing unit comprises a preprocessing module, a budget module and a warehousing module, wherein data are mutually transmitted between the preprocessing module and the budget module, and data are mutually transmitted between the budget module and the warehousing module. After the customer places a bill, a designer selects proper accessories according to the requirements of the customer and the types of mechanical accessories in the order, and fills all the selected accessories into a production form, an input-output module transmits the production form into a preprocessing module for data preprocessing, a budget module invokes inventory data in a storage module according to the types and the numbers of the accessories required in the production form and calculates, after the result is obtained, the budget module selectively informs a purchasing module to purchase or informs the designer, namely a user to confirm the order or inform the designer to confirm a replacement according to the calculation result, and a data management system processes the data in the production form, so that the reasonable replacement of the accessories in the inventory is facilitated, the plan and the targeted purchase are facilitated, the production plan and the purchase plan are effectively combined, and the effective control of the production cost is realized.
The input/output module marks the production form as a j Wherein j is more than or equal to 1 and is a positive integer, and on a single production form, j is only represented as the serial number of the production form, and the input/output module fills out the completed productionYield form a j Transmitting to a preprocessing module; production form a j For the designer to select the total form of the accessories according to the mechanical accessories in the order when the customer places the order, the list of the same column number in a plurality of production forms is expressed as the same type of the same accessory, and the production form a j The content of the order contract comprises the name, model number and quantity of the accessories, the order contract comprises the transaction amount of the mechanical accessories, and the order contract is matched with the production form.
The pretreatment module is used for producing the form a j Splitting a plurality of production forms a j Single row data expressed as the number of accessories in the same column number i are combined to form a number of accessories columnWherein i is equal to or greater than 1 and i is an ordered set of positive integers, i being represented as production form a j The number of columns in (1) in the number of fittings column->Wherein j is the number of items in the number of parts array, and the production form a j Serial number of (2) and number of parts are in series->Corresponding to the number of items, form a is produced 1 Production form a 2 Production form a 3 …, production form a 6 Number of parts formed by data in column 1 of the series +. >Number of parts column->The second item of (2) is->Number of parts formed by data in column 2 column +.>Number of parts column->The third item in (2) is->The preprocessing module sorts the names of the accessories, and the number of the accessories is listed in the order of the names of the accessories>Sorting, wherein the pretreatment module sorts the number of the plurality of accessories after sorting into a number sequence +.>And the accessory name ordering is sent to the budget module.
The budget module receives the accessory name ordering and accessory number array transmitted by the preprocessing moduleThe budget module sends an instruction for calling the inventory quantity of the accessories to the storage module according to the received accessory name ordering;
the storage module is used for ordering and calling the inventory quantity of corresponding accessories according to the accessory names, and exporting the inventory quantity of the accessories into an inventory sequence K according to the accessory names n Wherein n is greater than or equal to 1 and is an ordered positive integer set, n is the number of inventory array items, elements in the set n are mapped with elements in the set i one by one, and the inventory array K is stored by the warehouse module n To the budget module.
The budget module receives the inventory number series K sent by the warehouse module n And for each number of parts, a plurality of parts are arrangedSumming, and storing the number K in the budget module n The number of parts per item minus the number of parts per item is in the column +. >Sum to obtain the stock allowance number series Z of all accessories n 。
Summing the total number of each fitting to obtain the stock allowance, thereby calculatingTotal consumption of the parts, when two or three parts are used, i.e. the number of parts is in the order of the number of parts, for parts whose total consumption exceeds the limit number (the limit number is set by the enterprise for controlling the amount of use of the parts)When the sum of (2) exceeds the limit number, the budget module is added to the number of accessories according to the number size>The number of parts is ordered by size, and after ordering, the number of parts is ordered by number column +.>The number of the primary items of each item is kept unchanged, the first two items and the second two items are selected from the sorting, and the budget module inquires the production form a where the accessory is located according to the number of the primary items of the first two items and the second two items j And for each production form a j The total cost involved is calculated while the budget module queries the production form a j By calculating the total cost and the amount of the deal, dividing the amount of the deal by the total cost multiplied by 100%, and if the calculated cost profit margin (the acquisition percentage is made by the enterprise) is lower than the cost profit margin made by the enterprise, making the production form a j Production form a for positioning fitting data to be adjusted j Screening out a production form a needing to adjust accessory data j After that, the budget module sends replacement information to the storage module, the replacement information comprises the names of the accessories, the types of the accessories and the quantity of the accessories to be replaced, the storage module receives the replacement information, queries the accessories of different types which can be used for reducing the production cost or the accessories of different types of stock backlog according to the replacement information, feeds back the replaceable information to the budget module, the replaceable information comprises the names of the accessories, the types of the accessories, the quantity of the accessories and the sales amount of the accessories which are used for replacement, the budget module replaces the replaced accessories according to the replaceable information, and the budget module replaces the types and the quantity of the accessories to realize effective control of the production cost.
The processing unit also comprises a purchasing module, wherein the warehousing module and the purchasing module mutually transmit data;
the budget module transmits data to the purchasing module in one way, and the purchasing module transmits data to the preprocessing module in one way;
the budget module sets the stock allowance number series Z of all accessories n The data in (a) is transmitted to the purchasing module or the input-output module.
Referring to fig. 2-3, the present invention provides the following technical solutions:
a method of a data management system based on big data technology, the method comprising the steps of:
s1, inputting production data;
s2, processing production data;
s3, calculating production data and feeding back order information;
and S4, confirming feedback information, and updating data of the data management system.
The step S1 comprises the following specific steps:
s101, the input/output module marks the production form as a j Wherein j is greater than or equal to 1 and is a positive integer, and on a single production form, j is only represented as the serial number of the production form, and the completed production form a is filled in j Input into an input-output module; when a production form is input, the input is recorded as a production form a 1 When two production forms are input, the two production forms are recorded as a production form a 2 When the upper limit m production forms are input, the upper limit m production forms are recorded as a production form a m At least one production form is input into the input/output module, and the upper limit is m production forms.
Step S102, the input/output module receives the production form a j Transmitting to a preprocessing module, and carrying out the next step S2;
the step S2 comprises the following specific steps:
step S201, a preprocessing module processes the production form a j Splitting a plurality of production forms a j In the same column number iCombining single line data of the number of accessories to form a number of accessory columnsWherein i is equal to or greater than 1 and i is an ordered set of positive integers, i being represented as production form a j Column number in (a) production form a j The number of fittings in the first column is +.>Production form a j The number of fittings in the second column is +.>Production form a j The number of fittings in the nth column is +.>The preprocessing module sorts the names of the accessories, and the number of the accessories is listed in the order of the names of the accessories>Sorting, wherein the pretreatment module sorts the number of the plurality of accessories after sorting into a number sequence +.>And the accessory name ordering is sent to the budget module, and the next step S3 is carried out.
The step S3 comprises the following specific steps:
step S301, the budget module receives the accessory name ordering and accessory number array transmitted by the preprocessing module in step S202The budget module sends an instruction for calling the inventory quantity of the accessories to the storage module according to the received accessory name ordering;
step S302, the budget module is used for counting and arranging the number of each accessoryCarrying out summation treatment, wherein the summation formula is +.>Wherein j is greater than or equal to 1 and is a positive integer, j is represented as a sequence number of the production form, i is greater than or equal to 1 and i is an ordered positive integer set, and i is represented as a production form a j Column number of (a);
step S303, the warehouse module retrieves the inventory quantity of the corresponding accessories according to the accessory name ordering, and derives the accessory inventory quantity to an inventory number sequence K according to the accessory name ordering n Wherein n is more than or equal to 1 and n is an ordered positive integer set, n is the number of inventory array items, elements in the set n are mapped with elements in the set i one by one, the value of each item is the inventory number of a fitting, and the inventory module stores the inventory array K n Transmitting to a budget module;
step S304, the budget module receives the inventory number sequence K sent by the warehouse module n Inventory number sequence K for budget module n Number of parts per item minus number of parts per itemSum to obtain the stock allowance number series Z of all accessories n The calculation formula is as follows: />
Step S305, budget module counts Z of inventory margins i Screening each item of stock allowance data, and comparing the screened data with the stock allowance value larger than zero with the minimum quantity of accessories formulated by enterprises when the accessories need to be purchased;
step S306, in step S305, when the screened data is lower than the minimum number of accessories formulated by enterprises and needed to be purchased, the budget module sends purchasing information to the purchasing module, and then step S308 is performed;
Step S307, in step S305, when the screened data is higher than the lowest number of accessories formulated by enterprises and needed to be purchased, the budget module does not send purchasing information to the purchasing module, and then step S308 is performed;
step S308, the budget module sends order information to the preprocessing module, the order information comprises names of final order placing accessories, the number of final order placing accessories and the order placing date, the preprocessing module sends the order information to the input and output module, the input and output module displays the order information, and the step S4 is entered, and the user is waited for confirmation.
The step S3 further comprises the following specific steps:
step S309, in step S305, the budget module sends replacement information to the warehouse module according to the names of the accessories with the inventory balance value smaller than zero, wherein the replacement information comprises the names of the accessories with the inventory balance value smaller than zero and the required quantity, the warehouse module inquires the accessories available for replacement according to the replacement information and sends replacement feedback information to the budget module, and the replacement feedback information comprises the names of the accessories used for replacement, the model numbers of the accessories, the quantity of the accessories and the sales amount of the accessories;
in step S3010, in step S309, the budget module receives the replacement feedback information sent by the warehouse module, and sends the replacement feedback information to the preprocessing module, and the preprocessing module sends the replacement feedback information to the input/output module, where the input/output module outputs and displays the replacement feedback information, and proceeds to step S4, and waits for confirmation of the user.
The step S3 further comprises the following specific steps:
step S3011, in step S304, the number of parts is set in a plurality of rowsWhen the sum of (2) exceeds the limit number, the budget module is added to the number of accessories according to the number size>The number of parts is ordered by size, and after ordering, the number of parts is ordered by number column +.>The number of the primary items of each item is kept unchanged, the first two items and the second two items are selected from the sorting, and the budget module inquires the production form a where the accessory is located according to the number of the primary items of the first two items and the second two items j And for each production form a j Related toThe total cost is calculated and the budget module inquires the production form a j By calculating the total cost and the amount of the deal, dividing the amount of the deal by the total cost multiplied by 100%, and if the calculated cost profit margin (the acquisition percentage is made by the enterprise) is lower than the cost profit margin made by the enterprise, making the production form a j Production form a for positioning fitting data to be adjusted j Screening out a production form a needing to adjust accessory data j After that, the budget module sends replacement information to the warehouse module, wherein the replacement information comprises accessory names, accessory models and accessory numbers which need to be replaced;
Step S3012, according to the content of step S3011, the warehouse module receives replacement information, queries accessories of different types or accessories of different types of stock backlog, which can be used for reducing production cost, according to the replacement information, and feeds back the replacement information to the budget module, wherein the replacement information comprises accessory names, accessory types, accessory number and accessory sales amount used for replacement, the budget module replaces the replaced accessories according to the replacement information and generates a production form copy, the budget module sends the production form copy to the preprocessing module, the preprocessing module sends the production form copy to the input/output module, and the input/output module outputs and displays the production form copy, and enters step S4 to wait for confirmation of a user.
The step S4 comprises the following specific steps:
step S401, in step S308, after checking and determining the order information, the user sends determining information to the preprocessing module by the input/output module, the preprocessing module sends determining information to the budget module, the budget module sends inventory data updating information to the warehousing module according to the determining information, the data updating information comprises accessory names, accessory models and the number of the left inventory of accessories to be updated, the warehousing module updates the warehousing information according to the data updating information sent by the budget module, and feeds back data updating success information to the budget module, and the budget module stops the operation of the data management system after receiving the updating success information until the next time of receiving the input/output module New production form a is fed j ；
Step S402, in step S309, after the user checks and determines the replacement feedback information, the input/output module sends the determination information to the preprocessing module, the preprocessing module sends the determination information to the budget module, and the budget module generates the form a according to the determination information j Is replaced, and returns to step S308.
Step S403, in step S3012, after checking and determining the copy of the production form by the user, i.e. the designer, the input/output module sends determination information to the preprocessing module, the preprocessing module sends the determination information to the budget module, and the budget module checks the production form a according to the determination information j Is replaced, and returns to step S308.
In the case of example 1,
in this embodiment, six production forms are taken as an example, and the six production forms are respectively the production form a 1 Production form a 2 Production form a 3 Production form a 4 Production form a 5 Production form a 6 Each production form a j Only 3 columns are filled in;
the minimum number of accessories formulated by enterprises is 50 when the accessories need to be purchased, the limit number is 70, and the cost profit margin is 30%.
After placing an order with a customer, the designer places six production forms a j Wherein 6 is more than or equal to j is more than or equal to 1 and is a positive integer, and the corresponding order contract is input into an input-output module, and the input-output module receives the production form a j To the preprocessing module.
The pretreatment module is used for producing the form a j Splitting, and producing form a in three parts j The single column data in the same column number i are combined to form a number of fittings arrayIn each production form a j Comprises three columns as an example, 3 is more than or equal to i is more than or equal to 1, i is an ordered positive integer set, and i is expressed as a production form a j Column number in (a) production form a j The first row ofThe number of pieces is in the number series Production form a j The number of accessories in the second row is as follows Production form a j The number of the accessories in the 3 rd column is as followsThe preprocessing module sorts the names of the accessories, and the number of the accessories is listed in the order of the names of the accessories>Sequencing, wherein the pretreatment module sequences the number of the three sequenced accessories>And the accessory name ordering is sent to the budget module.
The budget module receives the accessory name ordering and accessory number array transmitted by the preprocessing moduleThe budget module sends an instruction for calling the inventory quantity of the accessories to the storage module according to the received accessory name ordering;
the budget module counts the number of each accessoryCarrying out summation treatment, wherein the summation formula is +. >
The storage module retrieves the inventory quantity of the corresponding accessories according to the accessory name sequencing, and derives the accessory inventory quantity to be an inventory number sequence K according to the accessory name sequencing n Wherein 3 is more than or equal ton is greater than or equal to 1 and is an ordered positive integer set, n is expressed as the number of inventory array items, elements in set n are mapped with elements in set i one by one, and inventory array K n The numerical value of each item is the stock quantity of a fitting, and the stock quantity K is listed by the stock module n Transmitting to a budget module;
the budget module receives the inventory number series K sent by the warehouse module n Inventory number sequence K for budget module n Number of parts per item minus number of parts per itemSum to obtain the stock allowance number series Z of all accessories n The calculation formula is as follows: wherein (1)>
Budget Module for inventory margin array Z i ＝{Z 1 ，Z 2 ，Z 3 Screening each item of stock allowance data, and comparing the screened data with the stock allowance value larger than zero with the minimum quantity 50 of accessories formulated by enterprises when the accessories need to be purchased;
if Z is screened out 1 Or Z is 2 Or Z is 3 Or Z is 1 、Z 2 、Z 3 When the numerical value of the accessory is lower than the minimum number 50 when the accessory set by the enterprise needs to be purchased, the budget module sends purchasing information to the purchasing module, and then the budget module sends order information to the preprocessing module, wherein the order information comprises the name of the accessory to be finally placed, the number of the accessory to be finally placed and the date of placing the order;
If Z is screened out 1 Or Z is 2 Or Z is 3 Or Z is 1 、Z 2 、Z 3 When the value of the number is higher than the minimum number of accessories formulated by enterprises and needing to be purchased, the budget module does not send purchasing information to the purchasing module, and thenThe budget module sends order information to the preprocessing module, wherein the order information comprises names of final ordering accessories, the number of final ordering accessories and ordering dates;
the preprocessing module sends the order information to the input and output module, and the input and output module displays the order information and waits for confirmation of a user.
When the stock allowance value is smaller than zero, the number of the warehouses in the stock cannot meet the production use, the budget module sends replacement information to the warehouse module according to the names of the accessories with the stock allowance value smaller than zero, the replacement information comprises the accessory names and the required number with the stock allowance value smaller than zero, the warehouse module inquires the accessories available for replacement according to the replacement information and sends replacement feedback information to the budget module, and the replacement feedback information comprises the accessory names, the accessory types, the accessory number and the accessory sales amount for replacement;
the budget module receives the replacement feedback information sent by the storage module, sends the replacement feedback information to the preprocessing module, and then sends the replacement feedback information to the input and output module which outputs and displays the replacement feedback information to wait for confirmation of a user;
After the user checks and determines the replacement feedback information, the input/output module sends the determination information to the preprocessing module, the preprocessing module sends the determination information to the budget module, and the budget module produces the form a according to the determination information j The data in the order form is replaced, and then the budget module sends order information to the preprocessing module again, wherein the order information comprises names of final order placing accessories, the number of final order placing accessories and order placing dates;
the preprocessing module sends the order information to the input and output module again, and the input and output module displays the order information again and waits for confirmation of a user.
After checking and determining order information by a user, the input/output module sends determination information to the preprocessing module, the preprocessing module sends the determination information to the budget module, and the budget module sends inventory data updating information to the warehousing module according to the determination informationThe data updating information comprises the accessory name, the accessory model number and the remaining inventory number of accessories to be updated, the warehousing module updates the warehousing information according to the data updating information sent by the budget module, feeds back the data updating success information to the budget module, and stops the operation of the data management system after the budget module receives the updating success information until a new production form a sent by the input/output module is received next time j 。
With two or three parts in number seriesWhen the sum of (2) exceeds the limit number 70, the budget module counts the number of the parts according to the number value>The number of the accessories is ordered according to the size of a plurality of items in the table, and the number of the accessories is ordered according to the number of the accessories Ordering (S)/(S)>After sorting, the number of accessories column +.>The number of entries of each item is kept unchanged and the first two items are selected from the ranking>And the second twoThe budget module inquires a production form a where the accessory is located according to the primary numbers of the first two items and the second two items 1 、a 3 、a 4 、a 6 And for each production form a j The total cost involved is calculated while the budget module queries the production form a j By sum of the total cost and the amount of the deal in the order contractThe sum is calculated, the sum of the transaction is subtracted by the total cost and divided by the total cost multiplied by 100 percent, and if the calculated cost profit margin is 30 percent lower than the cost profit margin established by enterprises, the production form a is produced j Production form a for positioning fitting data to be adjusted j Screening out a production form a needing to adjust accessory data j After that, the budget module sends replacement information to the warehouse module, wherein the replacement information comprises accessory names, accessory models and accessory numbers which need to be replaced;
the storage module receives replacement information, inquires accessories of different types which can be used for reducing production cost or accessories of different types of stock backlog according to the replacement information, and feeds back the replaceable information to the budget module, wherein the replaceable information comprises accessory names, accessory types, accessory quantity and accessory sales amount for replacement, the budget module replaces the replaced accessories according to the replaceable information and generates a production form copy, the production form copy is sent to the preprocessing module, the preprocessing module sends the production form copy to the input/output module, and the input/output module outputs and displays the production form copy to wait for confirmation of a user;
After checking and determining the copies of the production forms by a user, checking and determining the copies of the production forms by a designer, transmitting determination information to a preprocessing module by an input/output module, transmitting the determination information to a budget module by the preprocessing module, replacing data in the production forms aj by the budget module according to the determination information, transmitting order information to the preprocessing module by the budget module, wherein the order information comprises names of final order placing accessories, the number of final order placing accessories and the order placing date, transmitting the order information to the input/output module by the preprocessing module, displaying the order information by the input/output module, and waiting for confirmation of a user;
after checking and determining order information by a user, the input/output module sends determination information to the preprocessing module, the preprocessing module sends the determination information to the budget module, the budget module sends inventory data updating information to the warehousing module according to the determination information, the data updating information comprises accessory names, accessory models and the number of the left accessories to be updated, and the warehousing module is used for acquiring the information according to the budget moduleThe transmitted data updating information carries out storage information updating, and feeds back data updating success information to the budget module, and the budget module stops the operation of the data management system after receiving the updating success information until receiving a new production form a transmitted by the input/output module next time j 。
It is noted that relational terms such as first and second, and the like are used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Moreover, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus.
Finally, it should be noted that: the foregoing description is only a preferred embodiment of the present invention, and the present invention is not limited thereto, but it is to be understood that modifications and equivalents of some of the technical features described in the foregoing embodiments may be made by those skilled in the art, although the present invention has been described in detail with reference to the foregoing embodiments. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims (7)

1. A data management system based on big data technology, characterized in that: the data management system comprises an input/output module and a processing unit, wherein the input/output module and the processing unit mutually transmit data, the input/output module transmits an order contract and a production form to the processing unit, the processing unit processes the data in the production form, and the processing unit transmits a processing result to the input/output module;
the processing unit comprises a preprocessing module, a budget module and a warehousing module, wherein the preprocessing module and the budget module mutually transmit data, and the budget module and the warehousing module mutually transmit data;
the input/output module marks the production form as a j Wherein j is more than or equal to 1 and is a positive integer, and on a single production form, j is only represented as the serial number of the production form, and the input/output module fills in the completed production form a j Transmitting to a preprocessing module;
the pretreatment module is used for producing the form a j Splitting a plurality of production forms a j Single row data expressed as the number of accessories in the same column number i are combined to form a number of accessories columnWherein i is equal to or greater than 1 and i is an ordered set of positive integers, i being represented as production form a j The number of columns in (1) in the number of fittings column->Wherein j is expressed as the number of items in the number of parts array, the pre-processing module sorts the names of the parts, and the number of parts array is +.>Sorting, wherein the pretreatment module sorts the number of the plurality of accessories after sorting into a number sequence +.>The accessory name ordering is sent to the budget module;
the budget module receives the accessory name ordering and accessory number array transmitted by the preprocessing moduleThe budget module sends an instruction for calling the inventory quantity of the accessories to the storage module according to the received accessory name ordering;
the storage module is used for sequencing and calling the inventory quantity of corresponding accessories according to the names of the accessories and calling the inventory quantity of the corresponding accessories according to the accessoriesName ordering derives the number of parts inventory to inventory number K n Wherein n is greater than or equal to 1 and is an ordered positive integer set, n is the number of inventory array items, elements in the set n are mapped with elements in the set i one by one, and the inventory array K is stored by the warehouse module n Transmitting to a budget module;
the budget module receives the inventory number series K sent by the warehouse module n And for each number of parts, a plurality of parts are arrangedSumming, and storing the number K in the budget module n The number of parts per item minus the number of parts per item is in the column +.>Sum to obtain the stock allowance number series Z of all accessories n ；
The budget module sends replacement information to the storage module according to the names of accessories with the inventory remaining values smaller than zero, wherein the replacement information comprises the names of the accessories with the inventory remaining values smaller than zero and the required number, the storage module inquires the accessories available for replacement according to the replacement information and sends replacement feedback information to the budget module, and the replacement feedback information comprises the names of the accessories used for replacement, the model numbers of the accessories, the number of the accessories and the sales amount of the accessories;
the budget module receives the replacement feedback information sent by the storage module, sends the replacement feedback information to the preprocessing module, and then sends the replacement feedback information to the input and output module, wherein the input and output module outputs and displays the replacement feedback information to wait for confirmation of a user.
2. A data management system based on big data technology as claimed in claim 1, wherein: the processing unit also comprises a purchasing module, wherein the warehousing module and the purchasing module mutually transmit data;
the budget module transmits data to the purchasing module in one way, and the purchasing module transmits data to the preprocessing module in one way;
the budget module sets the stock allowance number series Z of all accessories n The data in (a) is transmitted to the purchasing module or the input-output module.
3. A method for a big data technology based data management system according to claim 1, characterized by: the method comprises the following steps:
s1, inputting production data;
s2, processing production data;
s3, calculating production data and feeding back order information;
and S4, confirming feedback information, and updating data of the data management system.
4. A method according to claim 3, characterized in that:
the step S1 comprises the following specific steps:
step S101, filling in completed order contract and production form a j Input into an input-output module;
step S102, the input/output module receives the order contract and the production form a j Transmitting to a preprocessing module, and carrying out the next step S2;
the step S2 comprises the following specific steps:
step S201, a preprocessing module processes the production form a j Splitting a plurality of production forms a j Single row data expressed as the number of accessories in the same column number i are combined to form a number of accessories columnWherein i is equal to or greater than 1 and i is an ordered set of positive integers, i being represented as production form a j The number of columns in (1) is that the preprocessing module sorts the names of the accessories, and the number of the accessories is in (18) according to the sorting of the names of the accessories>Sorting, wherein the pretreatment module sorts the number of the plurality of accessories after sorting into a number sequence +.>And the accessory name ordering is sent to the budget module, and the next step S3 is carried out.
5. The method according to claim 4, wherein:
the step S3 comprises the following specific steps:
step S301, the budget module receives the accessory name ordering and accessory number array transmitted by the preprocessing module in step S202The budget module sends an instruction for calling the inventory quantity of the accessories to the storage module according to the received accessory name ordering;
step S302, the budget module is used for counting and arranging the number of each accessoryCarrying out summation treatment, wherein the summation formula is +.>Wherein j is greater than or equal to 1 and is a positive integer, j is represented as a sequence number of the production form, i is greater than or equal to 1 and i is an ordered positive integer set, and i is represented as a production form a j Column number of (a);
step S303, the warehouse module retrieves the inventory quantity of the corresponding accessories according to the accessory name ordering, and derives the accessory inventory quantity to an inventory number sequence K according to the accessory name ordering n Wherein n is greater than or equal to 1 and is an ordered positive integer set, n is the number of inventory array items, elements in the set n are mapped with elements in the set i one by one, and the inventory array K is stored by the warehouse module n Transmitting to a budget module;
step S304, the budget module receives the inventory number sequence K sent by the warehouse module n Inventory number sequence K for budget module n Number of parts per item minus number of parts per itemSum to obtain the stock allowance number series Z of all accessories n The calculation formula is as follows:
step S305, budget module counts Z of inventory margins i Screening each item of stock allowance data, and comparing the screened data with the stock allowance value larger than zero with the minimum quantity of accessories formulated by enterprises when the accessories need to be purchased;
step S306, in step S305, when the screened data is lower than the minimum number of accessories formulated by enterprises and needed to be purchased, the budget module sends purchasing information to the purchasing module, and then step S308 is performed;
step S307, in step S305, when the screened data is higher than the lowest number of accessories formulated by enterprises and needed to be purchased, the budget module does not send purchasing information to the purchasing module, and then step S308 is performed;
step S308, the budget module sends order information to the preprocessing module, the order information comprises names of final order placing accessories, the number of final order placing accessories and the order placing date, the preprocessing module sends the order information to the input and output module, the input and output module displays the order information, and the step S4 is entered, and the user is waited for confirmation.
6. The method according to claim 5, wherein:
the step S3 further comprises the following specific steps:
step S309, in step S305, the budget module sends replacement information to the warehouse module according to the names of the accessories with the inventory balance value smaller than zero, wherein the replacement information comprises the names of the accessories with the inventory balance value smaller than zero and the required quantity, the warehouse module inquires the accessories available for replacement according to the replacement information and sends replacement feedback information to the budget module, and the replacement feedback information comprises the names of the accessories used for replacement, the model numbers of the accessories, the quantity of the accessories and the sales amount of the accessories;
in step S3010, in step S309, the budget module receives the replacement feedback information sent by the warehouse module, and sends the replacement feedback information to the preprocessing module, and the preprocessing module sends the replacement feedback information to the input/output module, where the input/output module outputs and displays the replacement feedback information, and proceeds to step S4, and waits for confirmation of the user.
7. The method according to claim 6, wherein:
the step S4 comprises the following specific steps:
step S401, in step S308, after checking and determining the order information, the user sends determining information to the preprocessing module by the input/output module, the preprocessing module sends determining information to the budget module, the budget module sends inventory data updating information to the warehousing module according to the determining information, the data updating information comprises accessory names, accessory models and the number of the left inventory of accessories to be updated, the warehousing module updates the warehousing information according to the data updating information sent by the budget module, and feeds back data updating success information to the budget module, and the budget module stops the operation of the data management system after receiving the updating success information until receiving a new production form a sent by the input/output module next time j ；
Step S402, in step S309, after the user checks and determines the replacement feedback information, the input/output module sends the determination information to the preprocessing module, the preprocessing module sends the determination information to the budget module, and the budget module generates the form a according to the determination information j Is replaced, and returns to step S308.
CN202211097136.XA 2022-09-08 2022-09-08 Data management system and method based on big data technology Active CN115587689B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202211097136.XA CN115587689B (en) 2022-09-08 2022-09-08 Data management system and method based on big data technology

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202211097136.XA CN115587689B (en) 2022-09-08 2022-09-08 Data management system and method based on big data technology

Publications (2)

Publication Number Publication Date
CN115587689A CN115587689A (en) 2023-01-10
CN115587689B true CN115587689B (en) 2024-03-08

Family

ID=84771783

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202211097136.XA Active CN115587689B (en) 2022-09-08 2022-09-08 Data management system and method based on big data technology

Country Status (1)

Country Link
CN (1) CN115587689B (en)

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR20010084924A (en) * 2001-04-24 2001-09-07 김영삼 An inventory management system and the inventory managing method on the distribution rate
CN101329747A (en) * 2008-06-25 2008-12-24 北汽福田汽车股份有限公司潍坊模具厂 Die enterprise informatization management system
CN106875119A (en) * 2017-02-14 2017-06-20 河南理工大学 One kind production and commodity distribution control method and system
CN109523108A (en) * 2018-09-13 2019-03-26 赛摩电气股份有限公司 A kind of enterprise's manufacturing management and buying unified platform
CN113627745A (en) * 2021-07-21 2021-11-09 苏州慧工云信息科技有限公司 Material demand planning method and system
CN113674102A (en) * 2021-07-21 2021-11-19 湖南益善科技有限公司 Cloud service support system for production and manufacturing in log whole wood industry

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR20010084924A (en) * 2001-04-24 2001-09-07 김영삼 An inventory management system and the inventory managing method on the distribution rate
CN101329747A (en) * 2008-06-25 2008-12-24 北汽福田汽车股份有限公司潍坊模具厂 Die enterprise informatization management system
CN106875119A (en) * 2017-02-14 2017-06-20 河南理工大学 One kind production and commodity distribution control method and system
CN109523108A (en) * 2018-09-13 2019-03-26 赛摩电气股份有限公司 A kind of enterprise's manufacturing management and buying unified platform
CN113627745A (en) * 2021-07-21 2021-11-09 苏州慧工云信息科技有限公司 Material demand planning method and system
CN113674102A (en) * 2021-07-21 2021-11-19 湖南益善科技有限公司 Cloud service support system for production and manufacturing in log whole wood industry

Also Published As

Publication number Publication date
CN115587689A (en) 2023-01-10

Similar Documents

Publication Publication Date Title
US5101352A (en) Material requirements planning system
EP0721625B1 (en) System and method for integrating a business environment with a process control environment
US6345259B1 (en) System and method for integrating business and manufacturing environments
US7937294B1 (en) System, and associated method, for configuring a buying club and a coop order
CN101127104A (en) Ship engineering material integrated handling computer management system
US20090132570A1 (en) Cost Element Managing System
TWI311289B (en)
CN111626672A (en) Emergency material order processing method and device and inventory control method
CN114596020A (en) Project MRP design method and system for large-scale customized production
CN111461590A (en) Method for calculating complete set of materials according to sales, inventory and purchase information
Dale The management of engineering change procedure
US7398130B2 (en) Ordering/order receiving system
WO2004088442A1 (en) Process delay monitor system
KR102192429B1 (en) Goods Receipt and Issue Management System using binary management user interface
CN115587689B (en) Data management system and method based on big data technology
US20040049415A1 (en) System and method for rescheduling procurement according to altered demand
JP5776797B2 (en) Program, evaluation information generation method, and evaluation information generation system
JP2004292101A (en) System and method for supporting order processing
US20050261921A1 (en) System and method for lot priority adjustment
CN101882267A (en) Method and system for realizing material selection
CN110443492A (en) A kind of sale leading type plant information management system
JP4617926B2 (en) Sales production integrated plan data processing device, sales production integrated plan data processing method, and sales production integrated plan data processing program
JP2005215817A (en) System for estimating computer system construction
CN1714323A (en) Part ordering system and part ordering method
JP2847276B2 (en) Delivery management system for coiled products

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
TA01 Transfer of patent application right

Effective date of registration: 20240205

Address after: 276000 New Minghui Warehouse and Logistics Park, Linxi 12th Road, Yitang Town, Lanshan District, Linyi City, Shandong Province

Applicant after: Xinminghui supply chain Co.,Ltd.

Country or region after: China

Applicant after: Shandong Xinminghui Safety Technology Co.,Ltd.

Applicant after: SHANDONG YI'ANJIE TECHNOLOGY CO.,LTD.

Address before: 010,030 Floor 5, Menglida Apartment, No. 1 Shuiqu Lane, Zhongshan West Road, Huimin District, Hohhot, Inner Mongolia Autonomous Region

Applicant before: Hohhot Subo Electronic Technology Co.,Ltd.

Country or region before: China

TA01 Transfer of patent application right
GR01 Patent grant
GR01 Patent grant