CN105760424A - Database establishment method for storing key data of enterprise products - Google Patents
Database establishment method for storing key data of enterprise products Download PDFInfo
- Publication number
- CN105760424A CN105760424A CN201610045566.5A CN201610045566A CN105760424A CN 105760424 A CN105760424 A CN 105760424A CN 201610045566 A CN201610045566 A CN 201610045566A CN 105760424 A CN105760424 A CN 105760424A
- Authority
- CN
- China
- Prior art keywords
- product
- critical data
- data
- gray
- key data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F30/00—Computer-aided design [CAD]
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06T—IMAGE DATA PROCESSING OR GENERATION, IN GENERAL
- G06T7/00—Image analysis
- G06T7/0002—Inspection of images, e.g. flaw detection
- G06T7/0004—Industrial image inspection
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06T—IMAGE DATA PROCESSING OR GENERATION, IN GENERAL
- G06T7/00—Image analysis
- G06T7/60—Analysis of geometric attributes
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06T—IMAGE DATA PROCESSING OR GENERATION, IN GENERAL
- G06T2207/00—Indexing scheme for image analysis or image enhancement
- G06T2207/10—Image acquisition modality
- G06T2207/10024—Color image
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06T—IMAGE DATA PROCESSING OR GENERATION, IN GENERAL
- G06T2207/00—Indexing scheme for image analysis or image enhancement
- G06T2207/30—Subject of image; Context of image processing
- G06T2207/30108—Industrial image inspection
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Geometry (AREA)
- Computer Vision & Pattern Recognition (AREA)
- Computer Hardware Design (AREA)
- Evolutionary Computation (AREA)
- Quality & Reliability (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a database establishment method for storing key data of enterprise products.The database establishment method comprises the steps that a plurality of high-definition vidicons are configured, are arranged on a product production line at intervals and shoot the appearances of produced products or the appearances of parts forming the products; the high-definition vidicons transmit acquired image information to a threshold value algorithm based product appearance data extractor through a local area network, the key data of the product appearances are extracted and transmitted to a product appearance key data comparison module; a database of the key data of the products is created; a product key data storage structure is generated according to defined EXCEL reports; functional keys for query, deletion, modification and edition of product information are created, and the information is transmitted to the product appearance key data comparison module; the product appearance key data comparison module compares the key data with the report structure.The database establishment method can effectively improve product management, document strengthening and efficient utilization of drawings and data and makes the work process standardized.
Description
Technical field
The present invention relates to a kind of database building method, especially with regard to a kind of database building method for storing enterprise product critical data.
Background technology
At present, the product data management system great majority that Chinese Enterprises uses can only store the data such as some critical datas and the product drawing related in some product life cycles, the document of some enterprise products, and these systems are all pure software systems.And product data management information system quick development platform be one for developing PDM (product data management) information system fast Development instrument.Current a lot of enterprises all suffer from a problem, and to be how quickly to set up a product data management platform all with product related information (including parts information, configuration, document, cad file, structure, authority information etc.) and all with product correlated process (include process definition and manage) for managing, but due to enterprise in order to the feature meeting market demand enterprise product tends to vary with turn of the market, just the PDM system of exploitation will not from newly developed with some months.
Summary of the invention
For solving above-mentioned technical problem, the present invention provides a kind of database building method for storing enterprise product critical data, and the method can be effectively improved product quality, strengthens, for document, drawing, the efficient utilization of data, making workflow standardize.
For achieving the above object, the present invention takes techniques below scheme: a kind of database building method for storing enterprise product critical data, it is characterized in that comprising the following steps: 1) several high-definition cameras are set, and these some high-definition cameras are disposed in product line, shot by the parts outward appearance of some high-definition cameras product appearance to producing or composition product；2) some high-definition cameras by the image information that collects through local network transport to based in thresholding algorithm product design data extractor, extracted the critical data being clapped product or product component outward appearance by this extractor, and the transmission of this critical data is contrasted in module to product design critical data；3) data base of storage product critical data is created；4) in EXCEL electrical form, product or product component design information, the storage position of cad file and product structure information the EXCEL report generation product critical data storage organization that will define are defined according to product feature；5) directly create the list structure in data base according to the product data structure of EXCEL definition, and on corresponding list structure, build the function button of information query, deletion, amendment；6) by step 5) in list structure definition information query editting function, by build need inquiry product query argument, select query argument exhibition method build the complex query needed for enterprise customer；7) will be provided with editor, inquiry, delete, the transmission of the list structure of amendment function is to product design critical data contrast module；8) it is preset with error threshold in product design critical data contrast module, product design critical data contrast module is by step 2) obtain product appearance critical data and step 7) list structure that obtains contrasts, if product appearance critical data with in list structure storage differ error by the appearance design data clapping product or product component less than or equal to error threshold set in advance, then qualified by bat product on production line；Otherwise, reject this and clapped product.
Based on above-described embodiment, described step 1) in, the shooting background in product line need to have aberration with by bat product or product component.
Based on above-described embodiment, described step 2) in, described as follows based on the thresholding algorithm in thresholding algorithm product design data extractor: the image information received is carried out gray proces by (1), all converts all color image informations to gray level image information；(2) image information after gray proces is smoothed；(3) gray difference according to the shooting background clapped on product or product component and production line arranges Gray-scale value；(4) compare with the gray value of each pixel in image after smoothing processing and the Gray-scale value of setting, if the gray value of pixel is less than in the gray threshold set, then retain the gray value of this pixel, otherwise, delete the gray value of this pixel；(5) all pixel gray values under reserved obtain the critical data of product or the product component outward appearance being taken.
The invention have the advantages that: 1, the present invention is by creating the data base of storage product critical data, and some high-definition cameras are set on a production line, to compare with the storage data in the data base of storage product critical data after product Image Information Processing on production line, confirm product quality, so can be effectively improved production efficiency, be conducive to the Life cycle of product is managed, strengthen for document, drawing, the efficient utilization of data, make workflow standardize.2, the present invention can respond the change of product feature dynamically and create the data base of storage product critical data as required, it is possible to greatly reduce a large amount of repetitive operation of system development, shortens the PDM construction cycle, reduces artificial, improves efficiency.3, the present invention is integrated with the hardware devices such as video camera, LAN and product appearance data extractor, the outward appearance that can utilize video camera shooting product or product component extracts the critical data of product or parts outward appearance by data extraction module, and the appearance data of design in Product Process drawing corresponding with the storage in the data base of storage product critical data for this critical data and document is compared, it is effectively increased product quality.4, the critical data that the present invention stores the product needed of enterprise defines in EXCEL electrical form, creates the list structure of this product critical data according to definition, and creates the amendment of product critical data, increase, deletion and query function according to list structure.Whole process, without the secondary development of system and programming, reduces artificial, improves efficiency, make workflow standardize.
Other features and advantages of the present invention will be set forth in the following description, and, becoming apparent from description of part, or understand by implementing the present invention.The purpose of the present invention and other advantages can be realized by structure specifically noted in the description write, claims and accompanying drawing and be obtained.
Accompanying drawing explanation
Accompanying drawing is only for illustrating the purpose of specific embodiment, and is not considered as limitation of the present invention, and in whole accompanying drawing, identical reference marks represents identical parts.
Fig. 1 is the overall flow schematic diagram of the present invention.
Detailed description of the invention
Below in conjunction with drawings and Examples, the present invention being described in detail, wherein, accompanying drawing constitutes the application part, and is used for together with embodiments of the present invention explaining the present invention.But those skilled in the art will appreciate that following example are not unique restriction that technical solution of the present invention is made, every any equivalents done under technical solution of the present invention spirit or change, be regarded as belonging to protection scope of the present invention.
As it is shown in figure 1, the present invention provides a kind of database building method for storing enterprise product critical data, it comprises the following steps:
1) several high-definition cameras are set, and these some high-definition cameras are disposed in product line, shot by the parts outward appearance of some high-definition cameras product appearance to producing or composition product；
Wherein, the shooting background in product line need to have aberration with by bat product or product component.
2) some high-definition cameras by the image information that collects through local network transport to based in thresholding algorithm product design data extractor, the critical data being clapped product or product component outward appearance is extracted by this extractor, for instance: the data such as length and radius and component part numbers or production code member；And the transmission of this critical data is contrasted in module to product design critical data；
Wherein, as follows based on the thresholding algorithm in thresholding algorithm product design data extractor:
(1) image information received is carried out gray proces, all convert all color image informations to gray level image information；
(2) image information after gray proces is smoothed, removes noise；
(3) gray difference according to the shooting background clapped on product (or product component) and production line arranges Gray-scale value；Choosing of Gray-scale value depends on concrete product design feature.
(4) compare with the gray value of each pixel in image after smoothing processing and the Gray-scale value of setting, if the gray value of pixel is less than in the gray threshold set, then retain the gray value of this pixel, otherwise, delete the gray value of this pixel；
(5) all pixel gray values under reserved obtain the critical data of product or the product component outward appearance being taken.
3) creating the data base of storage product critical data, this data base, without defining in database Management Information System, can directly be defined by development platform, and support SQL-SERVER, the database Management Information System that ORACEL, MySQL etc. are different, can be selected according to demand by enterprise customer and choose.
4) in EXCEL electrical form, product or product component design information, the storage position of cad file and product structure information the EXCEL report generation product critical data storage organization that will define are defined according to product feature.
5) directly create the list structure in data base according to the product data structure of EXCEL definition, and be built with, on corresponding list structure, the function button possessing the basic functions such as certain information query, deletion, amendment, it is not necessary to writing of any program code.
6) by step 5) in list structure definition information query editting function, by building the product query argument needing inquiry, select the exhibition method of query argument (as query argument can with calendar, text box, the different exhibition method such as drop-down list box) build the complex query needed for enterprise customer.
7) will be provided with the transmission of the list structure of the functions such as editor, inquiry, deletion, amendment to contrast in module to product design critical data；
8) it is preset with error threshold in product design critical data contrast module, product design critical data contrast module is by step 2) obtain product appearance critical data and step 7) list structure that obtains contrasts, if product appearance critical data with in list structure storage differ error by the appearance design data clapping product or product component less than or equal to error threshold set in advance, then qualified by bat product on production line；Otherwise, reject this and clapped product.
The above; being only the present invention preferably detailed description of the invention, but protection scope of the present invention is not limited thereto, any those familiar with the art is in the technical scope that the invention discloses; the change that can readily occur in or replacement, all should be encompassed within protection scope of the present invention.
Claims (3)
1. the database building method being used for storing enterprise product critical data, it is characterised in that comprise the following steps:
1) several high-definition cameras are set, and these some high-definition cameras are disposed in product line, shot by the parts outward appearance of some high-definition cameras product appearance to producing or composition product；
2) some high-definition cameras by the image information that collects through local network transport to based in thresholding algorithm product design data extractor, extracted the critical data being clapped product or product component outward appearance by this extractor, and the transmission of this critical data is contrasted in module to product design critical data；
3) data base of storage product critical data is created；
4) in EXCEL electrical form, product or product component design information, the storage position of cad file and product structure information the EXCEL report generation product critical data storage organization that will define are defined according to product feature；
5) directly create the list structure in data base according to the product data structure of EXCEL definition, and on corresponding list structure, build the function button of information query, deletion, amendment；
6) by step 5) in list structure definition information query editting function, by build need inquiry product query argument, select query argument exhibition method build the complex query needed for enterprise customer；
7) will be provided with editor, inquiry, delete, the transmission of the list structure of amendment function is to product design critical data contrast module；
8) it is preset with error threshold in product design critical data contrast module, product design critical data contrast module is by step 2) obtain product appearance critical data and step 7) list structure that obtains contrasts, if product appearance critical data with in list structure storage differ error by the appearance design data clapping product or product component less than or equal to error threshold set in advance, then qualified by bat product on production line；Otherwise, reject this and clapped product.
2. the database building method for storing enterprise product critical data as claimed in claim 1, it is characterised in that: described step 1) in, the shooting background in product line need to have aberration with by bat product or product component.
3. the database building method for storing enterprise product critical data as claimed in claim 1 or 2, it is characterised in that: described step 2) in, described as follows based on the thresholding algorithm in thresholding algorithm product design data extractor:
(1) image information received is carried out gray proces, all convert all color image informations to gray level image information；
(2) image information after gray proces is smoothed；
(3) gray difference according to the shooting background clapped on product or product component and production line arranges Gray-scale value；
(4) compare with the gray value of each pixel in image after smoothing processing and the Gray-scale value of setting, if the gray value of pixel is less than in the gray threshold set, then retain the gray value of this pixel, otherwise, delete the gray value of this pixel；
(5) all pixel gray values under reserved obtain the critical data of product or the product component outward appearance being taken.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610045566.5A CN105760424A (en) | 2016-01-16 | 2016-01-16 | Database establishment method for storing key data of enterprise products |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610045566.5A CN105760424A (en) | 2016-01-16 | 2016-01-16 | Database establishment method for storing key data of enterprise products |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105760424A true CN105760424A (en) | 2016-07-13 |
Family
ID=56342539
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610045566.5A Pending CN105760424A (en) | 2016-01-16 | 2016-01-16 | Database establishment method for storing key data of enterprise products |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105760424A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109377281A (en) * | 2018-10-29 | 2019-02-22 | 扬州笛莎服装科技有限公司 | The monitoring device of product introduction Internet-based and customer experience system |
| CN111590746A (en) * | 2019-02-20 | 2020-08-28 | 中铁建设集团建筑发展有限公司 | Detection method and system in production process of concrete prefabricated part |
| CN112182259A (en) * | 2020-10-10 | 2021-01-05 | 珠海格力电器股份有限公司 | Drawing parameter processing method and device |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1263270A (en) * | 2000-03-14 | 2000-08-16 | 武原庆 | Method for testing abnormality of electronic element and device on printed circuit board and its testing instrument |
| US6525333B1 (en) * | 2000-07-18 | 2003-02-25 | Intelligent Machine Concepts, L.L.C. | System and method for inspecting containers with openings with pipeline image processing |
| CN201116868Y (en) * | 2007-06-15 | 2008-09-17 | 山东省药用玻璃股份有限公司 | Tubular bottle on-line detecting system |
| CN201819889U (en) * | 2010-05-21 | 2011-05-04 | 符强 | Full-automatic intelligent lamp detection system |
| CN102788801A (en) * | 2012-08-14 | 2012-11-21 | 深圳先进技术研究院 | Online detection system and detection method thereof |
| CN103234981A (en) * | 2013-05-14 | 2013-08-07 | 天津名唐环保科技有限公司 | Detection method and detection system for inner wall of dual-visual metal can |
| CN204346935U (en) * | 2015-01-16 | 2015-05-20 | 郑州轻工业学院 | The location of food multi-packaging thing nondestructive detection system and dust guard |
-
2016
- 2016-01-16 CN CN201610045566.5A patent/CN105760424A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1263270A (en) * | 2000-03-14 | 2000-08-16 | 武原庆 | Method for testing abnormality of electronic element and device on printed circuit board and its testing instrument |
| US6525333B1 (en) * | 2000-07-18 | 2003-02-25 | Intelligent Machine Concepts, L.L.C. | System and method for inspecting containers with openings with pipeline image processing |
| CN201116868Y (en) * | 2007-06-15 | 2008-09-17 | 山东省药用玻璃股份有限公司 | Tubular bottle on-line detecting system |
| CN201819889U (en) * | 2010-05-21 | 2011-05-04 | 符强 | Full-automatic intelligent lamp detection system |
| CN102788801A (en) * | 2012-08-14 | 2012-11-21 | 深圳先进技术研究院 | Online detection system and detection method thereof |
| CN103234981A (en) * | 2013-05-14 | 2013-08-07 | 天津名唐环保科技有限公司 | Detection method and detection system for inner wall of dual-visual metal can |
| CN204346935U (en) * | 2015-01-16 | 2015-05-20 | 郑州轻工业学院 | The location of food multi-packaging thing nondestructive detection system and dust guard |
Non-Patent Citations (2)
| Title |
|---|
| 陈慧岩 等: "《无人驾驶汽车概论》", 31 July 2014 * |
| 陈艳平: "《SQL Server 数据库技术及应用》", 31 August 2014 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109377281A (en) * | 2018-10-29 | 2019-02-22 | 扬州笛莎服装科技有限公司 | The monitoring device of product introduction Internet-based and customer experience system |
| CN111590746A (en) * | 2019-02-20 | 2020-08-28 | 中铁建设集团建筑发展有限公司 | Detection method and system in production process of concrete prefabricated part |
| CN112182259A (en) * | 2020-10-10 | 2021-01-05 | 珠海格力电器股份有限公司 | Drawing parameter processing method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111324577B (en) | Yml file reading and writing method and device | |
| US20070299835A1 (en) | Search engine for software components and a search program for software components | |
| CN101313294A (en) | Smart copy/paste of graphical nodes | |
| US20210049711A1 (en) | Method of automatically transmitting data information and device of automatically transmitting data information | |
| CN102103497A (en) | Finite state machine actuating device and method, and method for establishing and using finite state machine | |
| US20200250897A1 (en) | Intelligent prognostics and health management system and method | |
| CN103177329A (en) | Rule-based determination and validation in business object processing | |
| US11003635B2 (en) | Database scheme for storing generic data | |
| CN110991279B (en) | Document Image Analysis and Recognition Method and System | |
| CN105760424A (en) | Database establishment method for storing key data of enterprise products | |
| CN116523479A (en) | Collaborative creation method for digital works, task release method and device | |
| CN101887541A (en) | The system that is used for the electronically scheduling vehicle order | |
| CN110705891A (en) | Data processing method based on high-allocable changeability | |
| Abdoli et al. | Designing warehouse logical architecture by applying object oriented model based system engineering | |
| CN110362854B (en) | Automatic processing method and device for fault tree graphical modeling node layout | |
| CN115329504A (en) | BOM construction method based on complex product structure | |
| CN109324856A (en) | Menu treating method, device, computer equipment and storage medium | |
| Eiden et al. | Supporting semantic PLM by using a lightweight engineering metadata mapping engine | |
| CN114816170A (en) | Rule scheme generation method, device, medium and electronic equipment | |
| CN106802812A (en) | A kind of method of load document, device and electronic equipment | |
| CN105893445A (en) | Data processing method, server and terminal device | |
| CN115630151A (en) | Infrastructure engineering knowledge management method, system and storage medium | |
| CN108108472B (en) | Data processing method and server | |
| CN114548709A (en) | Intelligent decision-making method and system based on Bayesian network data enabling enterprise | |
| Rudzajs et al. | Variability handling in multi-mode service composition |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160713 |