Summary of the invention
Purpose of the present invention just provides a kind of tobacco leaf quality management system and method thereof, it is by a database, the information relevant with quality of tobacco is carried out statistical study, thereby understand the every index of tobacco leaf easily, its quality is made correct assessment, alleviated labor capacity, improved efficiency, strengthened and the producing region information interchange, by to leaf tobacco production area ecological environment, the diversified analysis of tobacco leaf product style, improve fragrance matter, perfume quantity and the industrial applicability of tobacco leaf accurately and effectively, for research and development of products provides quality assurance and data support.
For achieving the above object, the present invention has adopted following technical scheme: a kind of tobacco leaf quality management system, and it comprises at least one data acquisition equipment, in order to gather the every information relevant with tobacco leaf; A print out equipment, in order to output form, the graphic operation information relevant with quality of tobacco, it is characterized in that: described data acquisition equipment connects with a quality of tobacco database, and this quality of tobacco database comprises,
A subsystem processor is in order to handle the tobacco leaf relevant information that is comprised in this subsystem;
A data processor, in order to the tobacco leaf information of gathering is compared, excavates, statistics and operational analysis, draw required indication information according to target requirement;
One compound advances the rank query processor, in order to inquiry soil source-information, tobacco sample information, redried leaf tobacco information, meteorological condition information, tobacco leaf safety indexes;
Describedly compoundly advance the rank query processor and connect, in order to data are derived with the data export interface;
Describedly compoundly advance the rank query processor and connect, by sequential operation the quality of tobacco data are formed form, statistical graph, image, result of calculation etc. and send print out equipment output with the data processing processor.
Described data acquisition equipment collection comprises the ecological information of tobacco leaf, tobacco leaf presentation quality, the tobacco leaf contents such as quality, tobacco leaf chemical composition, security of smokeing panel test.
Described data processing processor comprises
A data comparator processor is in order to carry out horizontal and vertical comparison to parallel quality of tobacco index;
Data are excavated processor, and in order to based on raw data, the relevant information data that tobacco leaf ecology information, tobacco leaf presentation quality, tobacco leaf are smoked panel test in quality, tobacco leaf chemical composition, each scope of security is excavated respectively;
A data statistics processor adopts mathematical statistics method, and the original quality data are carried out statistical treatment;
Data computation and analysis processor are in order to calculate and to analyze tobacco leaf chemical composition, the quality of smokeing panel test and safety indexes information.
Described database also connects with a code maintenance processor, in order to increase, modification, the code of deleting the user, title etc., the authority of selected user is set.
A kind of quality of tobacco management method, it sends into database with contents such as the ecological information of the tobacco leaf of tobacco leaf, tobacco leaf presentation quality, tobacco leaf sensory evaluating smoking quality, tobacco leaf chemical composition, securities by input equipment; After database processing, with relevant form, the output of graphic operation information, it is characterized in that: the data of collection are sent into database behind the code maintenance processor by print out equipment;
Data processor in the database, in order to the tobacco leaf information of gathering is compared, excavates, statistics and operational analysis, draw required indication information according to target requirement;
Compoundly advance the rank query processor soil source-information, tobacco sample information, redried leaf tobacco information, meteorological condition information, tobacco leaf safety indexes information inquiry inlet are provided, so that transfer corresponding information;
The data comparator processor carries out horizontal and vertical comparison with the same ATTRIBUTE INDEX data of different objects, draws the comparative analysis result;
The data mining processor, respectively to the ecological information of tobacco leaf, tobacco leaf presentation quality, tobacco leaf smoke panel test that primary data information (pdi) in quality, tobacco leaf chemical composition, each scope of security screens, ordering and data extract, obtaining needs the target information excavated;
The data statistics processor is added up the original quality data, for research and development of products, raw material research, leaf tobacco production etc. provide individuation data information support targetedly;
Data computation and analysis processor carry out correlation analysis to tobacco leaf chemical composition, the quality of smokeing panel test and safety indexes information, draw the comprehensive evaluation result of quality of tobacco;
Compoundly advance information in the query processor of rank and the information of above-mentioned each processor is integrated, transfer required form, figure, send print out equipment output.
The described compound Query Result that advances the rank query processor can be by the output of data export interface.
Quality of tobacco database main task is to provide relevant quality of tobacco proterties database technology for enterprise, realize data collection, manage, finish various statistics, inquiry, provide subdata base for relevant environment, make data management realize machineization, information provides computerized.The foundation of quality of tobacco database among the present invention, strengthened and the producing region information interchange, to big, the diversified advantage of tobacco leaf product style of abundant understanding performance leaf tobacco production area ecological environment difference, active development is fit to the sound tobacco of cigarette demand, thereby improve fragrance matter, perfume quantity and the industrial applicability of tobacco leaf accurately and effectively, for research and development of products provides quality assurance and data support.Can in time understand the quality state of tobacco leaf, be convenient to the planning management of tobacco leaf.Can purpose be arranged, purchase raw tobacco material and use raw tobacco material selectively according to the quality identification of tobacco leaf, reduce human factor and blindness.Can design, reduce the reinforced foundation that science is provided of cigarette objectionable constituent and cigarette flavoring for cigarette composition, significant to improving business economic benefit and core competitiveness.
Embodiment
The invention will be further described below in conjunction with accompanying drawing and embodiment.
Among Fig. 1, tobacco leaf quality management system, it comprises at least one data acquisition equipment 1, and in order to gather the every information relevant with tobacco leaf, this information comprises contents such as the ecological information of tobacco leaf, tobacco leaf presentation quality, tobacco leaf sensory evaluating smoking quality, tobacco leaf chemical composition, security.Particular content comprises:
Quality of tobacco: kind, grade, the position, color, blade construction, identity, oil content, gloss, total reducing sugar (%), reducing sugar (%), nicotine (%), total nitrogen (%), protein (%), potassium (K2O) %, chlorine (%), ether extract acidity (%), ether extract neutrality (%) ether extract alkalescence (%), starch (%), volatile acid (%), volatilization alkali (%), the ph value, cigarette weight (g/ props up), resistance to suction (mmH2O), mouth number (mouthful /), TPM (mg/ props up), smoking nicotine (mg/ props up), flue gas moisture (mg/ props up), carbon monoxide (mg/ props up), tar (mg/ props up), odor type, strength, concentration, the saturating property sent out, fragrance matter (branch), perfume quantity (branch), pleasant impression (branch), assorted gas (branch), pungency (branch), flammability (branch), grey (branch), PTS (branch), total reducing sugar/nicotine, nitrogen/alkali, schmuck value, Ca%, Mg%, P%, Cu mg/Kg, Zn mg/Kg, Mn mg/Kg, Fe mg/Kg, B mg/Kg.
Meteorological: frostless season, number of days, accumulated temperature, all temperature, all when precipitation, illumination, illumination rate, humidity.
The soil longitude and latitude, sea level elevation m, physical features, the soil parent material quality, unit weight g/cm3, the ph value, the content of organic matter (%), total nitrogen (%), full phosphorus (P2O5) %, full potassium (K2O) %, quick-acting nitrogen mg/kg, rapid available phosphorus (P) mg/kg, available potassium (K) mg/kg, soluble chloride mg/kg, effective iron mg/kg, effective manganese mg/kg, effective copper mg/kg, effective zinc mg/kg, effective effective molybdenum mg/kg of boron mg/kg, sulphur mg/kg, exchangeable calcium cmol/kg, indexs such as exchangeability magnesium cmol/kg.
Safety index: benzene hexachloride, D.D.T. (dichloro-diphenyl-trichloroethane), heptachlor, Heptachlor epoxide, 5a,6,9,9a-hexahydro-6,9-methano-2,4, drinox, dieldrite, acephatemet, parathion, Entex, the malathion, parathion-methyl, fenifrothion, Menite, phosphamidon, Azodrin, decis, along fenvalerate, high cypermethrin, lambda-cyhalothrin, carbofuran, carbaryl, Aldicarb, Methomyl, Imidacloprid, metalaxyl, Mancozeb, thiophanate methyl, dimethachlon Evil frost, carbendazim, enide, napropamide, isopropyl methoxalamine, maleic hydrazide, pendimethalin, isopropalin, butralin, flumetralim, the tobacco nitrosamine, benzopyrene, cadmium, chromium, plumbous, arsenic, information such as mercury.
A print out equipment 2 is in order to output form, the graphic operation information relevant with quality of tobacco.
Described data acquisition equipment connects with quality of tobacco database 3, and this quality of tobacco database 3 comprises,
A subsystem processor 4 is in order to handle the quality of tobacco information that is comprised in this subsystem;
A data treatment facility, in order to the tobacco leaf information of gathering is compared, excavates, statistics and operational analysis, draw needed relevant information;
One compound advances rank query processor 5, in order to inquiry soil source-information, tobacco sample information, redried leaf tobacco information, meteorological condition information, tobacco leaf safety indexes; Can filter out the information of system map location when entering this processor.
Other deposits: select the path of depositing of Excel file, Query Result can be saved as the Excel file.
During comprehensive inquiry, select a title (as: sample number into spectrum), select comparison operator (as:=) then, input is value accordingly, clicks execution and promptly according to condition filters out Query Result.Can compound query (as: can look into sample number into spectrum greater than what and less than what etc.).
Compoundly advance rank query processor 5 and connect, in order to data are derived with data export interface 6; Compoundly advance rank query processor 5 and connect, by sequential operation the quality of tobacco data are formed form, statistical graph, image, result of calculation etc. and send print out equipment 2 outputs with data processor 7.
Described data processing treating apparatus comprises,
A data comparator processor 8 is in order to carry out horizontal and vertical comparison to parallel quality of tobacco index;
Data are excavated processor 9, and in order to based on raw data, the relevant information data that tobacco leaf ecology information, tobacco leaf presentation quality, tobacco leaf are smoked panel test in quality, tobacco leaf chemical composition, each scope of security is excavated respectively;
A data statistics processor 10 adopts mathematical statistics method, and the original quality data are carried out statistical treatment;
Data computation and analysis processor 11 are in order to calculate and to analyze tobacco leaf chemical composition, the quality of smokeing panel test and safety indexes information.
Database also connects with a code maintenance processor 12, in order to increase, modification, the code of deleting the user, title etc., the authority of selected user is set.Typing area code: area code differentiated control, two one-levels, 2 of first order province and municipalities directly under the Central Government, 4 of second level districts and cities, 6 of third level county and county-level cities, 8 in fourth stage small towns, 10 in level V village.Can increase, revise, delete codes at different levels, typing quality code: increase, revise, deletion position, color, blade construction, identity, oil content, odor type, strength, concentration, gloss, send out code thoroughly.
A kind of quality of tobacco management method, it sends into database with contents such as the ecological information of the tobacco leaf of tobacco leaf, tobacco leaf presentation quality, tobacco leaf sensory evaluating smoking quality, tobacco leaf chemical composition, securities by input equipment; After database processing, with relevant form, the output of graphic operation information, the data of collection are sent into database behind the code maintenance processor after authenticating by operating right by print out equipment;
Data processor in the database, to the tobacco leaf information of gathering compare, excavate, statistics and operational analysis, draw needed relevant information;
Compoundly advance the rank query processor soil source-information, tobacco sample information, redried leaf tobacco information, meteorological condition information, tobacco leaf safety indexes information inquiry inlet are provided, so that transfer corresponding information;
The data comparator processor carries out horizontal and vertical comparison with the same ATTRIBUTE INDEX data of different objects, draws the comparative analysis result;
The data mining processor, respectively to the ecological information of tobacco leaf, tobacco leaf presentation quality, tobacco leaf smoke panel test that primary data information (pdi) in quality, tobacco leaf chemical composition, each scope of security screens, ordering and data extract, obtaining needs the target information excavated;
The data statistics processor is added up the original quality data, for research and development of products, raw material research, leaf tobacco production etc. provide individuation data information support targetedly;
Data computation and analysis processor carry out correlation analysis to tobacco leaf chemical composition, the quality of smokeing panel test and safety indexes information, draw the comprehensive evaluation result of quality of tobacco;
Compoundly advance information in the query processor of rank and the information of above-mentioned each processor is integrated, transfer required form, figure, send print out equipment output.