CN103069351A - Data retrieval system - Google Patents

Data retrieval system Download PDF

Info

Publication number
CN103069351A
CN103069351A CN2010800685545A CN201080068554A CN103069351A CN 103069351 A CN103069351 A CN 103069351A CN 2010800685545 A CN2010800685545 A CN 2010800685545A CN 201080068554 A CN201080068554 A CN 201080068554A CN 103069351 A CN103069351 A CN 103069351A
Authority
CN
China
Prior art keywords
data
product
retrieval
transacter
control
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN2010800685545A
Other languages
Chinese (zh)
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.)
Toshiba Mitsubishi Electric Industrial Systems Corp
Original Assignee
Toshiba Mitsubishi Electric Industrial Systems Corp
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 Toshiba Mitsubishi Electric Industrial Systems Corp filed Critical Toshiba Mitsubishi Electric Industrial Systems Corp
Publication of CN103069351A publication Critical patent/CN103069351A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Administration; Management
    • G06Q10/06Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F17/00Digital computing or data processing equipment or methods, specially adapted for specific functions
    • G06F17/40Data acquisition and logging
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Administration; Management
    • G06Q10/08Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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
    • G06Q50/00Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/04Manufacturing
    • BPERFORMING OPERATIONS; TRANSPORTING
    • B21MECHANICAL METAL-WORKING WITHOUT ESSENTIALLY REMOVING MATERIAL; PUNCHING METAL
    • B21BROLLING OF METAL
    • B21B37/00Control devices or methods specially adapted for metal-rolling mills or the work produced thereby

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Theoretical Computer Science (AREA)
  • Economics (AREA)
  • Physics & Mathematics (AREA)
  • Human Resources & Organizations (AREA)
  • General Physics & Mathematics (AREA)
  • Strategic Management (AREA)
  • General Business, Economics & Management (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Marketing (AREA)
  • Tourism & Hospitality (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Development Economics (AREA)
  • General Engineering & Computer Science (AREA)
  • Computer Hardware Design (AREA)
  • Data Mining & Analysis (AREA)
  • Primary Health Care (AREA)
  • Educational Administration (AREA)
  • Game Theory and Decision Science (AREA)
  • Health & Medical Sciences (AREA)
  • Manufacturing & Machinery (AREA)
  • General Health & Medical Sciences (AREA)
  • Databases & Information Systems (AREA)
  • Mathematical Physics (AREA)
  • Software Systems (AREA)
  • Testing And Monitoring For Control Systems (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • General Factory Administration (AREA)

Abstract

Provided is a data retrieval system wherein a user can perform an arbitrary search which meets his/her purpose, using various data collected in an industrial plant, and the retrieval result can be displayed in a desired display format with respect to each product. In the data retrieval system, a data collection device (3) collects product data with respect to each product produced in a rolling line of an industrial plant, and the product data is accumulated in a data accumulation device (4). The data collection device (3) also collects control data continuously generated in the industrial plant, and accumulates the data in the data accumulation device (4). A data retrieval device (6) performs a search using both the product data and the control data accumulated in the data accumulation device (4), on the basis retrieval conditions and an output method designated by the user, with reference to rolling area definition information in a storage device, and outputs the retrieval result for each product.

Description

Data retrieval system
Technical field
The present invention relates to a kind of data retrieval system that in the industrial premises equipment of iron and steel, non-ferrous metal, metal etc., uses.
Background technology
In the industrial premises equipment of iron and steel, non-ferrous metal, metal etc., for such as quality management, the such specific purpose of fault analysis, collect various data.That is, be determined in advance for the project of carrying out quality management, fault analysis, and only in this project, collecting in order to carry out the required data of normal/abnormal judgement.
For example, in following patent documentation 1, in order thickness of slab precision and tabular quality to be managed when cold rolling in that steel plate is carried out, following method has been proposed: regularly (for example, every day, wait weekly) to uneven thickness (Off gauge) incidence, plate shape deviation ratio etc. in time and the variation that occurs is calculated, and give the alarm when unusual detecting.
The prior art document
Patent documentation
Sharp document 1: Japanese Laid-Open Patent Unexamined Patent 11-129030 communique
Summary of the invention
Invent technical matters to be solved
In patent documentation 1 described method, although can suppress do not have versatility in order to collect or store the required resource of data, except predetermined purpose, can not utilize the data of collecting.For example, the supvr of rolling line etc. can not retrieve the data relevant with substandard product and read subsequently, can not utilize for new purpose the data of collecting.
The present invention finishes be used to addressing the above problem, its purpose is, a kind of data retrieval system is provided, this data retrieval system can utilize the various data of collecting in industrial premises equipment to carry out the arbitrarily retrieval that agrees with mutually with user's purpose, and this data retrieval system can also come each product is shown this result for retrieval with desirable display format.
The technical scheme that adopts for dealing with problems
Data retrieval system involved in the present invention comprises: the 1st transacter, the 1st transacter is collected the product data of each product of producing on the rolling line of industrial premises equipment, and it is stored in the data storage device of regulation; The 2nd transacter, the 2nd transacter is collected the control data that produce continuously in industrial premises equipment, and it is stored in the data storage device; Memory storage, this memory storage has rolling zone definitions information, described rolling zone definitions information obtains by the following method: namely, rolling line is divided into a plurality of zones, and necessarily only have the product below on these a plurality of zones, will by collected each of the 2nd transacter control data with divided after the zone in any zone be associated; User terminal, this user terminal is used for the output intent of the input desirable search condition of user and result for retrieval; And data searcher, this data searcher is based on search condition and output intent from the user terminal input, and with reference to the rolling zone definitions information in the memory storage, utilization is stored in product data in the data storage device and control data, and the two is retrieved, and to this result for retrieval of each output of products.
The invention effect
According to data retrieval system involved in the present invention, can utilize the various data of in industrial premises equipment, collecting to carry out the arbitrarily retrieval that agrees with mutually with user's purpose, and, can also come each product is shown this result for retrieval with desirable display format.
Description of drawings
Fig. 1 is the structural drawing of the integral body of the data retrieval system in the expression embodiments of the present invention 1.
Fig. 2 is the structural drawing of the major part of the data retrieval system in the expression embodiments of the present invention 1.
Fig. 3 is the structural drawing of other major part of the data retrieval system in the expression embodiments of the present invention 1.
Fig. 4 is the figure that expression is divided into rolling line the state behind a plurality of zones.
Fig. 5 is the figure of the summary of expression data conversion definition.
Fig. 6 is the figure that describes for to the sorted order that uses the notebook data searching system.
Fig. 7 is the process flow diagram that describes for to the sorted order that uses the notebook data searching system.
Fig. 8 is the figure that describes for the function to data searcher.
Fig. 9 is the figure that describes for the function to data searcher.
Figure 10 is the figure that describes for the function to data searcher.
Figure 11 is the figure that describes for the function to data searcher.
Embodiment
For the present invention will be described in more detail, be described with reference to accompanying drawing.In addition, in each accompanying drawing, for the identical label of identical or suitable part mark, and suitably simplify or omit repeat specification to them.
Embodiment 1
Fig. 1 is the structural drawing of the integral body of the data retrieval system in the expression embodiments of the present invention 1, and Fig. 2 is the structural drawing of its major part of expression, and Fig. 3 is the structural drawing of other major part of expression.
The notebook data searching system is applied in the industrial premises equipment of iron and steel, non-ferrous metal, metal etc., and has such as described in Figure 1 hardware configuration.Data collection server) 3, data storage device (DS:Dat aStorage: data-carrier store) 4, user terminal 5, data searcher (SE:SearchEngine: search engine) 6 particularly, the major part of notebook data searching system comprises: computing machine 1, controller 2, transacter (DCS:DataCollec torServer:.
Controller 2 and transacter 3 are connected with LAN8 with control by interface (I/F) 7 respectively.In addition, include shared storage 9 at each interface 7, the data of each shared storage 9 constituted within the update cycle of control with LAN8 to be upgraded.That is, mutually equate in the update cycle of LAN8 is used in control with the data of the shared storage 9 of controlling all devices that are connected with LAN8.
In addition, computing machine 1, transacter 3, data storage device 4, user terminal 5 and data searcher 6 are connected with LAN10 with system.
Below, with reference to Fig. 2 and Fig. 3, each structure of notebook data searching system is described in detail.
Computing machine 1 has and will be used for outputing in the instruction of industrial premises equipment production product the function of controller 2.Particularly, computing machine 1 will output to controller 2 for producing the required various data of product, and make controller 2 carry out the required control of this production.In addition, computing machine 1 is in order to manage product, in the process of producing product and produce finish after, obtain the real data of the regulation relevant with this product and it carried out record.And if the production run of this product all finishes, then computing machine 1 generates the product data of the regulation relevant with this product based on to the instruction of controller 2 or the real data that gets access to etc., and the product data that generate are outputed to transacter 3.
Following table 1 shows an example of the product data that generate in computing machine 1.
[table 1]
Figure BDA00002830851400041
Product data have been compiled the various data relevant with this product, export this product data when the rolling line of industrial premises equipment generates product at every turn.In these product data, for example comprise: the intrinsic numbering of product is the chemical constitution that comprises in production code member information, the time information as rolling Start Date or rolling Close Date, the product or its ratio, such as the size of product or the quality information the shape, such as the temperature of product in the operation of rolling or shape, rolling information as size.In addition, for example in rolling information, also comprise when rolling line with industrial premises equipment is divided into a plurality of zone, pass through the moment of each zone.(content relevant with this zone specifies the back.) in addition, in the product data except also comprising above-mentioned each information: such as the initial input information the target thickness of slab of product or Target Board are wide, such as the set information to each equipment so rolling load-carrying setting value or the mill speed setting value, actual information etc. as the actual plate thickness of product or actual plate are wide.
Controller 2 has the control function to each equipment of industrial premises equipment.That is, if controller 2 receives instruction for the production of product from computing machine 1, then controller 2 based on this receive data carry out for the production of scheduling, and determine particularly the action of each equipment.In addition, controller 2 outputs to transacter 3 with the required various data (control data) of each equipment of control when producing product.In these control data, such as the set information that comprises the drive unit such as motor or actual information, from the actual information that is arranged at the measuring equipment on the rolling line (measured value) etc.
Transacter 3 has collects product data and control data, and makes it be stored in function in the data storage device 4.The major part of this transacter 3 is utilized data reception portion 11, data conversion treatment section 12, counting appendix 13, appendix 14, data sending part 15 consist of constantly.
Transacter 3 has the function as the 1st transacter, and the product data of each product of producing at rolling line are collected.Particularly, if send product data from computing machine 1, then transacter 3 receives these product data by data reception portion 11.If receive product data, then transacter 3 converts received product data to the data mode that can preserve by data conversion treatment section 12 in data storage device 4.In addition, transacter 3 is controlled with the enumeration data on the LAN8 by 13 pairs of received product data of counting appendix are additional.And, if transacter 3 is implemented above-mentioned each processing, then send product data from data sending part 15, and in data storage device 4 the storage products data.
In addition, transacter 3 has the function as the 2nd transacter, and each control data that produce continuously in industrial premises equipment are collected.Particularly, if controller 2 sends the control data, then transacter 3 receives this control data by data reception portion 11.If transacter 3 receives the control data, the data mode that then by data conversion treatment section 12 received control data-switching is become can store in data storage device 4.In addition, transacter 3 is controlled with the enumeration data on the LAN8 by 13 pairs of received control data of counting appendix are additional, and, by moment appendix 14 additional current times.And, if transacter 3 implement above-mentioned each process, then send the control data from data sending part 15, and in data storage device 4 storage control data.
Following table 2 shows an example of the control data of record in the data storage device 4.
[table 2]
Figure BDA00002830851400061
Because the control data are made of control each equipment employed data etc., therefore, different from the said goods data of intermittently output, the control data the very short cycle (for example, cycle about 2msec or 50msec) generates continuously in, thereby a large amount of control data are input in the transacter 3.Therefore, transacter 3 constitutes one or more according to the scale of the data of collecting.
Data storage device 4 is used for prestoring various data.As described above, immediately record product data or the control data of sending from transacter 3 in the data storage device 4.In addition, data storage device 4 also has the function as memory storage, except the said goods data and control data, also comprises the rolling zone definitions information of regulation.
Below, this rolling zone definitions information is described.
Only exist on the rolling line of industrial premises equipment in the situation of a product, naturally be the data that generate when producing this product from the control data of controller 2 output, can keep intact with itself and product on the rolling line be associated (it is corresponding one by one with product to control data).Yet, on rolling line, usually have many products.Therefore, even from controller 2 output control data, can not will control data with keeping intact and be associated with product on the rolling line.That is, can't when being which product of rolling line production, these control data generate according to itself identifying from the control data of controller 2 output.
Therefore, in the notebook data searching system, as shown in Figure 4, the rolling line of industrial premises equipment is divided into a plurality of zones, and this regional of cutting apart is associated with the control data that monitor this zone in advance and it is defined, wherein, necessarily only has product below one in these a plurality of zones.That is any one in the zone after each control data of, being collected by transacter 3 and above-mentioned cutting apart is associated.And, the regional that obtains thus is pre-stored in data storage device 4 with the corresponding informance of control data, with as rolling zone definitions information.
In addition, to be expression be divided into the figure of the state behind a plurality of zones with rolling line to Fig. 4, and following table 3 shows an example of the rolling zone definitions information of this moment.
[table 3]
As shown in Figure 4, the rolling line of industrial premises equipment is divided into roughing zone, soaking pit zone, regional, the ROT(RunOutTable of finish rolling: transport platform) regional, DC(DownCoiler: downcoiler) these 5 zones, zone, and set result, soaking pit entrance side temperature, the finish rolling of roughing the result, spray the water yield, coiling temperature, with the project as the data of supervision regional.For example, definition has the required various data (control data) of each equipment of controlling the roughing zone in the result of roughing.Other data items is also identical.
In addition, above-mentioned computing machine 1 also comprises as the function by moment recording means.That is, if the regional of product by defining in the rolling zone definitions information, then computing machine 1 will be somebody's turn to do by constantly being recorded in the product data of corresponding product.
For example, comprise that in the result of finish rolling if product introduction finish rolling is regional, then the measured value of type plate thickness tester is increased to setting rapidly from 0 in the situation of the measured value (control data) from type plate thickness tester.In addition, if product is fully regional by finish rolling, the measured value of type plate thickness tester is reduced to 0 rapidly from the afore mentioned rules value.Computing machine 1(is by recording means constantly) such changing rapidly etc. automatically detects the moment of product by regional (enter this zone enter constantly and leave this regional departure time) based on the control data, and carry out record as the part of product data.
User terminal 5 is the terminals that operate for the user who carries out data retrieval for hope.The notebook data searching system constituted to carry out the arbitrarily retrieval that agrees with mutually with user's purpose.That is, the user is from the output intent of the user terminal 5 desirable search conditions of input or result for retrieval.
Data searcher 6 has the function that the various data that are stored in the data storage device 4 are retrieved, and the method for utilization regulation is come the function to each this result for retrieval of output of products.Required processing is retrieved or exported to data searcher 6 based on search condition or output intent from user terminal 5 inputs.In order to realize such function, in data searcher 6, for example comprise: data processing equipment 16, data editor 17 and picture conveyer 18.
Picture conveyer 18 has required information is shown to function on the display of user terminal 5.For example, do not receive in the situation of request from user terminal 5 at data searcher 6, picture conveyer 18 utilizes remote control to read handling part 19 the Web picture (initial picture) of stipulating is shown on the display of user terminal 5.
If user to user terminal 5 operates, and send to be used for the request (beginning request) that begins to retrieve by the Web picture, then the beginning request receiving section 20 by data processing equipment 16 receives this and begins request.If receiving by beginning request receiving section 20, data processing equipment 16 begins request, then generate be used to making the user input the picture (searching picture) of the output intent of search condition or result for retrieval by searching picture generating unit 21, and this image information is sent to picture conveyer 18.If picture conveyer 18 receives above-mentioned image information from searching picture generating unit 21, then read handling part 19 by remote control searching picture is shown on the user terminal 5.
In addition, if user to user terminal 5 operates, and specify the concurrent censorship rope of the output intent request of search condition or result for retrieval by searching picture, then the retrieval request acceptance division 22 by data processing equipment 16 receives this retrieval request.If data processing equipment 16 receives retrieval request by retrieval request acceptance division 22, then read and utilize data retrieval handling part 23 to carry out retrieval to data memory storage 4, and from data storage device 4, extract the data that meet specified search condition.
The result of the retrieval of being undertaken by data retrieval handling part 23 is received by the result for retrieval acceptance division 24 of data editor 17.If data editor 17 utilizes result for retrieval acceptance division 24 to receive result for retrieval, then utilize searching picture based on the user and the content of asking, carry out the editor of result for retrieval by result for retrieval editorial office 25.
For example, in data editor 17 storage as shown in Figure 5 the conversion formula that is registered with in advance data or the data conversion definition of display mode.Definition has in industrial premises equipment the various formula that are used for problem analysis (calculating formula of the tricks of the trade (know how) that the formula of for example, using based on statistical study, the researcher of problem analysis are exclusive etc.) in the data-switching formula.In addition, the related content that definition has the data of utilizing the data changed according to above-mentioned conversion formula or unconverted to carry out what kind of demonstration in display mode.Result for retrieval editorial office 25 does suitable selection based on user's indication to the conversion formula in this data conversion definition or display packing, and carries out required processing.
If with the specified display mode of user (for example generate to be used for, the form of form, the form of curve map) utilize the picture of the edited result that shows that result for retrieval editorial office 25 obtains, then data editor 17 sends to picture conveyer 18 with this image information.If receive above-mentioned image information from result for retrieval editorial office 25, then picture conveyer 18 reads handling part 19 by remote control, result for retrieval is shown on the display of user terminal 5.
In addition, such as mentioned above in the notebook data searching system, in data storage device 4, have in advance rolling zone definitions information, and in the retrieval that data searcher 6 carries out, the two can use control data and product data.Below, with reference to Fig. 6 to Figure 11, the order when the two is retrieved with control data and product data is elaborated.
Fig. 6 is the figure that describes for to the sorted order that uses the notebook data searching system, and Fig. 7 is its process flow diagram, and Fig. 8 to Figure 11 is the figure that describes for the function to data searcher.In addition, in following explanation, it is pre-stored in data storage device 4 to set the rolling zone definitions information shown in Fig. 4 and the above-mentioned table 3.
The user uses the notebook data searching system for for example following purpose: namely, up to the present extract the substandard product product of defective state (perhaps close to) in the product of producing, and in the equipment of regulation, what kind of control these substandard products carried out having confirmed, what kind of that is, to having trend with these device-dependent control data (value of utilizing the control data to obtain) confirm.
As Figure 6 and Figure 7, the user at first utilizes user terminal 5 to set the search condition of product data, and the condition that sets is sent to data searcher 6(S101 in order to extract substandard product).In addition, the condition of herein setting is the condition of following product being retrieved for from the products of having produced: namely, the final size of this product or the measured value in the production run surpass desired value or the specified value of user, perhaps the specified value of fall short value or user on the contrary.For example, the user specifies thickness of slab to surpass the product of 3mm, is set to be the product data as intelligence-collecting object, and makes data searcher 6 carry out retrieval.
In the product data that data searcher 6 is stored, the product that meets the specified condition of user is retrieved (S102) from the DB of data storage device 4.Do not exist in data storage device 4 in the situation of the product data that meet above-mentioned search condition, data searcher 6 is shown to error message on the user terminal 5, and image switching is so that the user can set the search condition (S103) of product data again.
In addition, have in data storage device 4 in the situation of the product data that meet above-mentioned search condition, the catalogue that data searcher 6 will satisfy the product of this condition is shown on the display of user terminal 5 (S104).Fig. 6 shows the situation that exists 4 to meet the product of above-mentioned search condition (thickness of slab surpasses 3mm) in the DB of data storage device 4.
Be shown on the user terminal 5 if will meet the catalogue of the product of the condition of appointment in S101, then user to user terminal 5 operates, and the control data of the product of from this demonstration hope further being retrieved and hope output are selected (S105).Fig. 6 shows following situation: namely, select to have the product of production code member A003 4 products of user on being shown in display, and specify result, the result of finish rolling, the coiling temperature of roughing, with the control data as output.
If in S105 product and control data as searching object are selected, then the user utilizes the method for 5 pairs of statistical study of user terminal or the display packing of result to select (S106) again.For example, user selection plate length is as statistical study, and the curve map of selection take thickness of slab as the longitudinal axis, take plate length as transverse axis is as display mode.And if required input all finishes, then the user sends to data searcher 6 with selected content.
Data searcher 6 is based on received content, each processing (S107 to S110) such as the statistical study of successively implementation data retrieval, result for retrieval, data demonstration.
For example, data searcher 6 is by the product data with reference to user-selected product, determine thus the regional of this product by rolling line during.As mentioned above, be registered with in advance in the rolling zone definitions information and respectively control the information which zone is data monitoring.Therefore, data searcher 6 by with reference to rolling zone definitions information and product data the two, thus to user-selected product, can judge pass through the moment (with reference to Fig. 8) of each zone corresponding with the specified control data of user.Namely, when the user specifies the result of result, the finish rolling of roughing, control data that the coiling temperature is used as exporting, data searcher 6 is with reference to these product data and rolling zone definitions information, determine this product by the roughing zone, finish rolling is regional, DC is regional each constantly.
If the product of searching object is determined passing through constantly of above-mentioned each corresponding region, then data searcher 6 obtains the specified statistical study of user or the required data of display mode from these control data of obtaining by the moment.For example, such as mentioned above, option board length is used as statistical study, the curve map of selection take thickness of slab as the longitudinal axis, take plate length as transverse axis is used as display mode, in this case, data searcher 6 is according to time of passing through in determined above-mentioned each zone, extract the data shown in the following table 4 with time series.
[table 4]
If required control data are extracted, then data searcher 6 is changed data based on the specified conversion formula of user.For example, data searcher 6 utilizes conversion formula shown in Figure 9, and according to mill speed and advanced speed plate progress row is calculated, and convert the time series data of obtaining to take product length as benchmark data, and with its output.In addition, if required data are changed, then data searcher 6 generates image information based on the specified display mode of user.For example, data searcher 6 generates curve map based on as shown in Figure 10 display format.At this moment, when the two shows to the data of using the data that are converted to according to conversion formula and unconverted, by using enumeration data additional when the Data Collection, thus so that when curve shows each data deviation do not occur synchronously.
And data searcher 6 sends to user terminal 5 by the image information that will generate, and thus curve map as shown in figure 11 is shown on the display of user terminal 5.In addition, if result for retrieval (for example, curve map as shown in figure 11) is shown on the display, then user to user terminal 5 operates, and select to wish the data (S111) of output, and with document form it is outputed in the storage medium of regulation (S112).
According to the data retrieval system with said structure, the user uses the various data collect in industrial premises equipment, thereby can carry out the arbitrarily retrieval that agrees with mutually with my purpose.In addition, owing in the notebook data searching system, the product data or the control data that generate in industrial premises equipment are collected, and not fettered by specific purpose, therefore, the user can retrieve arbitrarily according to the phenomenon that occurs.For example, the user can repeat required retrieval in the output intent that changes search method or result for retrieval, perhaps carries out such as from once analyzing the such development formula analysis of twice analysis.
In addition, in the notebook data searching system, by using rolling zone definitions information, generated frequency or the diverse product data of generating period can be associated with the control data thus.Therefore, the user is to for example specific product, the control data in the time of can only collecting by specified devices, and in order to grasp its trend, the two is retrieved with controlling data and product data.
In addition, in the notebook data searching system, by in data conversion definition, appending new conversion formula or display mode, thus can after change the options of the output intent of search method or result for retrieval.
In addition, native system also can constitute following structure: namely, collect the data (for example, the data with alert that generates when unusual) that generate suddenly, and with these market demands in retrieval.Under correlation circumstance, also can constitute following structure: namely, each data that for example obtains for unexpected generation, in advance it is associated with in the zone of cutting apart any and is defined in the rolling zone definitions information, further, when transacter 3 was collected, additional enumeration data and current time were saved in it in data storage device 4.
Industrial practicality
In the data retrieval system that the present invention can be applicable to use in the industrial premises equipment of iron and steel, non-ferrous metal, metal etc.
Label declaration
1 computing machine
2 controllers
3 transacters (DCS)
4 data storage devices (DS)
5 user terminals
6 data searchers (SE)
7 interfaces (I/F)
8 control LAN
9 shared storages
10 LAN of system
11 data reception portion
12 data conversion treatment sections
13 counting appendix
14 moment appendix
15 data sending parts
16 data processing equipments
17 data editors
18 picture conveyers
Handling part is read in 19 remote controls
20 beginning request receiving sections
21 searching picture generating units
22 retrieval request acceptance divisions
23 data retrieval handling parts
24 result for retrieval acceptance divisions
25 result for retrieval editorial offices

Claims (3)

1. a data retrieval system is characterized in that, comprising:
The 1st transacter, the 1st transacter is collected the product data of each product of producing on the rolling line of industrial premises equipment, and it is stored in the data storage device of regulation;
The 2nd transacter, the 2nd transacter is collected the control data that generate continuously in described industrial premises equipment, and it is stored in the described data storage device;
Memory storage, this memory storage has rolling zone definitions information, described rolling zone definitions information obtains by the following method: namely, described rolling line is divided into a plurality of zones, and necessarily only have the product below on these a plurality of zones, will by collected each of described the 2nd transacter control data with divided after described zone in any zone be associated;
User terminal, this user terminal is used for the output intent of the input desirable search condition of user and result for retrieval; And
Data searcher, this data searcher is based on search condition and output intent from described user terminal input, and with reference to the described rolling zone definitions information in the described memory storage, utilization is stored in product data in the described data storage device and control data, and the two is retrieved, and to this result for retrieval of each output of products.
2. data retrieval system as claimed in claim 1 is characterized in that, also comprises:
By moment record cell, should product be recorded in the product data of this product by the moment that is defined in the regional in the described rolling zone definitions information by moment record cell; And
Moment appendix, this moment appendix is arranged in described the 2nd transacter, and current time is appended in the control data that receive.
3. such as claim 1 or data retrieval system claimed in claim 2, it is characterized in that,
Further comprise controller, this controller is controlled each equipment of described industrial premises equipment, and generates the control data,
A plurality of described the 2nd transacters are connected with LAN with the control that is connected with described controller,
Each described the 2nd transacter has the shared storage that upgrades within the update cycle of described control with LAN, and, receiving control from described controller during data, the enumeration data of this shared storage is appended in the control data.
CN2010800685545A 2010-08-09 2010-08-09 Data retrieval system Pending CN103069351A (en)

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
PCT/JP2010/063471 WO2012020468A1 (en) 2010-08-09 2010-08-09 Data retrieval system

Publications (1)

Publication Number Publication Date
CN103069351A true CN103069351A (en) 2013-04-24

Family

ID=45567449

Family Applications (1)

Application Number Title Priority Date Filing Date
CN2010800685545A Pending CN103069351A (en) 2010-08-09 2010-08-09 Data retrieval system

Country Status (5)

Country Link
JP (1) JPWO2012020468A1 (en)
KR (1) KR101409545B1 (en)
CN (1) CN103069351A (en)
TW (1) TWI437396B (en)
WO (1) WO2012020468A1 (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104239362A (en) * 2013-06-24 2014-12-24 上海梅山钢铁股份有限公司 High frequency data retrieval and storage method for use in cold rolling process
CN110262439A (en) * 2019-07-22 2019-09-20 中冶赛迪工程技术股份有限公司 A kind of steelmaking process method of quality control and system
US12025644B2 (en) 2017-05-29 2024-07-02 Mitsubishi Electric Corporation Wireless power transmission device and power transmission system to aerial moving body

Families Citing this family (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP6229282B2 (en) * 2013-03-25 2017-11-15 大日本印刷株式会社 Machining system, machining log storage program, machining device
JP6101568B2 (en) * 2013-05-30 2017-03-22 株式会社日立製作所 Data conversion system, data conversion apparatus, and data conversion method
JP6916584B2 (en) * 2017-12-07 2021-08-11 東芝三菱電機産業システム株式会社 Plant information management device
JP2020027542A (en) * 2018-08-16 2020-02-20 東芝三菱電機産業システム株式会社 Controller and motor driving device for motor acceleration and deceleration

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPS626550A (en) * 1985-07-03 1987-01-13 Fuji Electric Co Ltd Hierarchy decentralized control system
CN101266494A (en) * 2007-03-14 2008-09-17 欧姆龙株式会社 Quality improvement system
WO2009044864A1 (en) * 2007-10-05 2009-04-09 Nippon Steel Corporation Plant control system and method
JP2010102679A (en) * 2008-09-29 2010-05-06 Semiconductor Technology Academic Research Center Information processing apparatus, information processing method, and program for achieving the same

Family Cites Families (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2002251213A (en) 2001-02-21 2002-09-06 Toshiba Corp Plant information processing system
JP2002373017A (en) 2001-06-18 2002-12-26 Mitsubishi Electric Corp Process data managing device
JP4180960B2 (en) 2003-04-11 2008-11-12 キヤノンItソリューションズ株式会社 Data analysis apparatus, control method therefor, computer program, and computer-readable storage medium
JP5353182B2 (en) * 2008-10-27 2013-11-27 新日鐵住金株式会社 Data analysis support device, data analysis support method, computer program, and recording medium

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPS626550A (en) * 1985-07-03 1987-01-13 Fuji Electric Co Ltd Hierarchy decentralized control system
CN101266494A (en) * 2007-03-14 2008-09-17 欧姆龙株式会社 Quality improvement system
WO2009044864A1 (en) * 2007-10-05 2009-04-09 Nippon Steel Corporation Plant control system and method
JP2010102679A (en) * 2008-09-29 2010-05-06 Semiconductor Technology Academic Research Center Information processing apparatus, information processing method, and program for achieving the same

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
SHIGEMASA NAKAGAWA: "Networked process control systems of iron and steel plants", 《JOURNAL OF THE SOCIETY OF INSTRUMENT AND CONTROL ENGINEERS》 *

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104239362A (en) * 2013-06-24 2014-12-24 上海梅山钢铁股份有限公司 High frequency data retrieval and storage method for use in cold rolling process
US12025644B2 (en) 2017-05-29 2024-07-02 Mitsubishi Electric Corporation Wireless power transmission device and power transmission system to aerial moving body
CN110262439A (en) * 2019-07-22 2019-09-20 中冶赛迪工程技术股份有限公司 A kind of steelmaking process method of quality control and system
CN110262439B (en) * 2019-07-22 2021-11-19 中冶赛迪工程技术股份有限公司 Steelmaking process quality control method and system

Also Published As

Publication number Publication date
TWI437396B (en) 2014-05-11
KR20130060258A (en) 2013-06-07
WO2012020468A1 (en) 2012-02-16
TW201207584A (en) 2012-02-16
JPWO2012020468A1 (en) 2013-10-28
KR101409545B1 (en) 2014-06-19

Similar Documents

Publication Publication Date Title
CN103069351A (en) Data retrieval system
AU622215B2 (en) Utility metering
KR100934866B1 (en) Surveillance data collection and operation system of power system and method
CN104707868A (en) Data analysis device
CN107909126A (en) A kind of MES system for motor automated production
CN101833307B (en) System and method for automatically integrating technological operation and management of plastic and rubber products
TW201837830A (en) Production management method and system of utilizing power consumption feature
CN104020744A (en) Fresh food sensor based on Internet of things and cold insulation supply chain monitoring method
US9460133B2 (en) Data management apparatus, data management method and data management program
CN117872898B (en) Cold chain intelligent control system based on remote communication
CN116300720A (en) Intelligent flexible scheduling advanced planning and scheduling system for production line
US20110197135A1 (en) Manipulation-monitoring device
CN107250935A (en) Steel complete set of equipments alert management apparatus
US20140297685A1 (en) Data management apparatus, data management method and data management program
CN103853691A (en) Operating efficiency estimating device and method
CN113656244A (en) MES manufacturing production process parameter monitoring system
CN112504331A (en) Performance data acquisition and analysis device for plastic forming machine tool
CN111176174A (en) Multifunctional supervision system for stamping workshop
JP2014203360A (en) Plant operation reproduction device
CN109847667B (en) Chemical reaction control system
CN116774665B (en) Intelligent control method and system for roll-to-roll laminating production line
CN213210787U (en) Performance data acquisition and analysis device for plastic forming machine tool
CN117486285B (en) Control method and system of water purifying equipment, water purifying equipment and storage medium
CN113704581B (en) Operation effect, data display method, device, equipment and storage medium
JP6916584B2 (en) Plant information management device

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C05 Deemed withdrawal (patent law before 1993)
WD01 Invention patent application deemed withdrawn after publication

Application publication date: 20130424