CN104391938B - A kind of picture batch in physical assets management imports the method and system of database - Google Patents
A kind of picture batch in physical assets management imports the method and system of database Download PDFInfo
- Publication number
- CN104391938B CN104391938B CN201410682477.2A CN201410682477A CN104391938B CN 104391938 B CN104391938 B CN 104391938B CN 201410682477 A CN201410682477 A CN 201410682477A CN 104391938 B CN104391938 B CN 104391938B
- Authority
- CN
- China
- Prior art keywords
- picture
- numbering
- pending object
- pending
- bar code
- 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
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
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Processing Or Creating Images (AREA)
Abstract
The present invention relates to the method and system that the picture batch in a kind of management of physical assets imports database.Methods described includes:The picture of some groups of pending objects is obtained, the picture of every group of pending object includes the first picture and second picture respectively;Bar code information is extracted from the first picture of some groups of pending objects, each bar code information is parsed into the numbering of pending object by bar code analytic technique, then respectively by the numbering of the pending object of second picture filename RNTO of each pending object;All data-base recordings are traveled through according to the numbering of the pending object of second picture filename, when the numbering of the pending object of second picture filename is identical with the numbering of the pending object of picture fields in data-base recording, the second picture of pending object is imported into data-base recording.The present invention improves batch picture and imports the speed of database and the accuracy rate of importing by above method.
Description
Technical field
The present invention relates to the method and system that the picture batch in a kind of management of physical assets imports database.
Background technology
The management of database often involves the management in the management of people or thing, such as Students'Management System to student, Gu
Determine the management to fixed assets in physical assets management system.
In the prior art, it is typically that different people or thing are numbered, the numbering of everyone or thing is unique, data
Storehouse is with field come each attribute (including described numbering) of recorder or thing, and a people or thing are exactly a note in database
Record.
In Students'Management System or fixed physical assets management system, the figure of student or fixed assets can be often used
Piece, picture is typically obtained with various digital equipment shootings, and picture is stored in file after taking, then by eye recognition,
All pictures are imported into corresponding data-base recording one by one.This traditional picture introduction method has following disadvantage
End:
1st, picture can only be imported manually one by one, and efficiency is very low.
2nd, the article outward appearance of many same size models is about the same, and by eye recognition, error rate is very high.
The content of the invention
The technical problem to be solved in the present invention is to provide one kind database is manually imported for batch picture in the prior art
Efficiency is low and picture batch the problem of high error rate imports the method and system of database.
In order to solve the above technical problems, the picture batch in a kind of physical assets management of the present invention imports the side of database
The technical scheme of method and system is as follows:
The method that the picture batch of the present invention imports database, comprises the following steps:
Step 1:The picture of some groups of pending objects is obtained, the picture of every group of pending object includes the first picture respectively
And second picture, first picture is the photo of the bar code information containing object to be handled, and the second picture is to meet
The standard of the pending object of system administration request is shone;
Step 2:Bar code information is extracted from the first picture of some groups of pending objects, will each bar code letter
Breath is parsed into the numbering of pending object, then waits to locate by the second picture filename RNTO of each pending object respectively
Manage the numbering of object;
Step 3:All data-base recordings, every are traveled through according to the numbering of the pending object of the second picture filename
Data-base recording includes picture fields, and the picture fields include the numbering of pending object, when the second picture filename
Pending object numbering and the numbering of pending object of picture fields in data-base recording when differing, perform step
Rapid 4;When identical, step 5 is performed;
Step 4:Continue to travel through next data storehouse record, until in the data-base recording picture fields it is pending right
The numbering of elephant is identical with the numbering of the pending object of second picture filename, performs step 5;
Step 5:The second picture of pending object is imported into data-base recording;
Step 6:Judge whether the second picture of the pending object is all imported in data-base recording, if it is not,
Perform step 3;Otherwise, processing terminates.
The beneficial effects of the invention are as follows:The present invention is by above-mentioned technical proposal, the irregular picture that digital equipment is shot
And picture file name, by bar code analytic technique, by the numbering and second of the pending object of picture fields in data-base recording
The numbering of the pending object of picture file name is corresponded, so as to realize high-volume picture automated import of data storehouse.
Further, also include in the step 1, by the picture of object to be handled be saved in local or external storage
In equipment.
Using the beneficial effect of above-mentioned further scheme:By object to be handled picture carry out concentration preservation after, can
To improve the speed that picture imports database.
Further, when being parsed in the step 2 to the bar code, by bar code analytic technique by the bar shaped
Code information is parsed into the numbering of pending object.
Using the beneficial effect of above-mentioned further scheme:Can be by picture word in data-base recording by bar code analytic technique
The numbering of the pending object of section and the numbering of the pending object of second picture filename realize Auto-matching.
The system that a kind of picture batch imports database, including picture acquiring device, picture resolver, picture processing dress
Put, picture travels through device, picture gatherer and picture judgment means;
The picture acquiring device, the picture for obtaining some groups of pending objects, the picture of every group of pending object
Include the first picture and second picture respectively, first picture is the photo of the bar code information containing object to be handled, institute
The standard that second picture is the pending object for meeting system administration request is stated to shine;
The picture resolver, will for extracting bar code information from the first picture of some groups of pending objects
Each bar code information is parsed into the numbering of pending object, then respectively by the second picture text of each pending object
The numbering of the part name pending object of RNTO;
The picture processing device, the numbering traversal for the pending object according to the second picture filename is all
Data-base recording, per data storehouse, record includes picture fields, and the picture fields include the numbering of pending object, when described
The numbering and the numbering of the pending object of picture fields in the data-base recording of the pending object of second picture filename
When differing, picture traversal device is returned to;When identical, picture gatherer is returned to;
The picture travels through device, for continuing to travel through next data storehouse record, until scheming in the data-base recording
The numbering of the pending object of piece field is identical with the numbering of the pending object of second picture filename, returns to picture and imports dress
Put;
The picture gatherer, for the second picture of pending object to be imported into data-base recording;
The picture judgment means, for judging whether the second picture of the pending object all imports database note
In record, if it is not, returning to picture processing device.
The beneficial effects of the invention are as follows:The present invention passes through bar code by shooting the picture containing bar code to people or article
The bar code is parsed into the numbering of pending object by analytic technique, then respectively by the second picture of each pending object
The numbering of the pending object of filename RNTO, realizes the numbering and database of the pending object of second picture filename
The numbering of the pending object of picture fields is corresponded in record, it is achieved thereby that high-volume picture imports database.
Further, the system also includes picture save set, for the picture of institute's object to be handled to be saved in
In ground or External memory equipment.
Using the beneficial effect of above-mentioned further scheme:By object to be handled picture carry out concentration preservation after, can
To improve the speed that picture imports database.
Further, bar code information is parsed into pending object by the picture resolver by bar code analytic technique
Numbering.
Using the beneficial effect of above-mentioned further scheme:Can be by picture word in data-base recording by bar code analytic technique
The numbering of the pending object of section and the numbering of the pending object of the second filename are realized and corresponded.
Brief description of the drawings
Fig. 1 is the flow chart of the inventive method;
Fig. 2 is present system block diagram;
In accompanying drawing, the list of parts representated by each label is as follows:
1st, picture acquiring device, 2, picture resolver, 3, picture processing device, 4, picture traversal device, 5, picture leads
Enter device, 6, picture judgment means, 7, picture save set.
Embodiment
The principle and feature of the present invention are described below in conjunction with accompanying drawing, the given examples are served only to explain the present invention, and
It is non-to be used to limit the scope of the present invention.
Technical scheme can be applied in Students'Management System, the picture of batch student is imported into student's pipe
In the database of reason system, manage and safeguard accordingly.Can also be applied in fixed physical assets management system to criticize
Measure fixed assets picture and import database, corresponding fixed assets are managed.
It is introduced below so that batch fixed assets picture imports database as an example.Pending object in present embodiment
For fixed assets.
Fig. 1 shows flow chart of the method for the present invention.
First, being set respectively in each fixed assets on a label, label has one-dimensional (or two dimension) bar code
And fixed assets title, specifications and models, using contents such as departments, fixed assets numbering is contained in bar code.
Step 1:Obtain the picture of some groups of fixed assets, fixed assets one group of fixed assets picture of correspondence.Every group
The picture of fixed assets includes the first picture and second picture, and first picture is the bar code information containing fixed assets
Photo (the bar shaped digital content is numbered for fixed assets), the second picture is the fixed assets for meeting system administration request
Standard is shone.The picture of all fixed assets of shooting is put into local or External memory equipment and preserved, facilitates user's batch
Fixed assets picture is imported in database.
Step 2:Bar code information is extracted from the first picture of some groups of fixed assets, will each bar code information
The numbering of pending object is parsed into, then respectively the second picture filename RNTO of each pending fixed assets is treated
The numbering of process object.
Wherein, in order to improve the discrimination of bar code, the bar code containing fixed assets information can individually be clapped
Take the photograph.By bar code analytic technique by the fixed assets of picture fields in the numbering and database of the fixed assets of second picture filename
The numbering of production is corresponded, the problem of fixed assets picture for solving phase specifications and models leans on human eye None- identified, while also carrying
High picture imports database speed and accuracy rate.
Step 3:Traveled through and stored in all data-base recordings, database according to the numbering of the second picture filename
The data-base recording of fixed assets to be handled, per data storehouse, record includes picture fields, and the picture fields include waiting to locate
The numbering of object is managed, when the numbering and picture fields in the data-base recording of the pending object of the second picture filename
Pending object number when differing, perform step 4;When identical, step 5 is performed.
Step 4:Continue to travel through next data storehouse record, until the middle picture fields of the data-base recording is pending
The numbering of object is identical with the numbering of the pending object of second picture filename, performs step 5.
Step 5:The second picture of fixed assets is imported into database.
The bar code is conventional bar code, for example, one-dimensional bar code or two-dimensional bar etc..
The present invention to picture by carrying out after above-mentioned processing, it is possible to achieve batch picture automated import of data storehouse, without people
Work is intervened, when especially carrying out a large amount of pictures importing databases, by technical scheme, can be fast and accurately real
The now importing of batch photo.
Fig. 2 shows the system block diagram of the present invention, and the system includes picture acquiring device 1, picture resolver 2, figure
Piece treating apparatus 3, picture traversal device 4, picture gatherer 5 and picture judgment means 6;
The picture acquiring device 1, the picture for obtaining some groups of fixed assets, every group of fixed assets picture is wrapped respectively
The first picture and second picture are included, first picture is the photo of the bar code information containing fixed assets, second figure
Piece is that the standard for the fixed assets for meeting system administration request is shone.
The picture resolver 2, for extracting bar code information from the first picture of some groups of fixed assets, passes through
Each bar code information is parsed into the numbering of pending object by bar code analytic technique, then respectively will be each pending right
The numbering of the pending object of second picture filename RNTO of elephant.
The filename for the irregular picture for being shot digital equipment by picture resolver 2 is changed to represent its uniqueness
Numbering, realize the numbering of the fixed assets of the fixed assets of picture fields and second picture filename in database one by one
Correspondence, the problem of fixed assets picture for solving same size model leans on human eye None- identified, leads while also improving picture
Enter database speed and accuracy rate.
The picture processing device 3, the numbering for the pending object according to the second picture filename travels through institute
Have be stored with data-base recording, database fixed assets to be handled data-base recording, per data storehouse record include
Picture fields, the picture fields include the numbering of pending object, when the pending object of the second picture filename
When numbering and the numbering of the pending object of picture fields in the data-base recording are differed, picture traversal device 4 is returned to.Phase
Meanwhile, return to picture gatherer 5.
The picture travels through device 4, in continuing to travel through next data storehouse record, until picture in the data-base recording
The numbering of the pending object of field is identical with the numbering of the pending object of second picture filename, returns to picture gatherer
5。
The picture gatherer 5, for the second picture of pending object to be imported into data-base recording.
The picture judgment means 6, for judging whether the second picture of the pending object all imports database
In record, if it is not, returning to picture processing device 3.
The system also include picture save set 7, for by institute object to be handled picture be saved in locally or
In External memory equipment.
The bar code is conventional bar code, for example, one-dimensional bar code or two-dimensional bar etc..
Wherein,, can be right in order to improve the discrimination of bar code when pending fixed assets can not carry out overall shoot
Bar code containing fixed assets information is individually shot.
The foregoing is only presently preferred embodiments of the present invention, be not intended to limit the invention, it is all the present invention spirit and
Within principle, any modification, equivalent substitution and improvements made etc. should be included in the scope of the protection.
Claims (8)
1. the method that the picture batch in a kind of physical assets management imports database, comprises the following steps:
Step 1:Obtain the picture of some groups of pending objects, the picture of every group of pending object includes the first picture and the respectively
Two pictures, first picture is the photo of the bar code information containing object to be handled, and the second picture is to meet management
The standard of the pending object of system requirements is shone;
Step 2:Bar code information is extracted from the first picture of some groups of pending objects, passes through independently developed high-precision bar
Each bar code information is parsed into the numbering of pending object by code analytic technique, then respectively will each pending object
The pending object of second picture filename RNTO numbering;
Step 3:All data-base recordings are traveled through according to the numbering of the pending object of the second picture filename, per data
Storehouse record includes picture fields, and the picture fields include the numbering of pending object, when treating for the second picture filename
When the numbering and the numbering of the pending object of picture fields in the data-base recording of process object are differed, step 4 is performed;
When identical, step 5 is performed;
Step 4:Continue to travel through next data storehouse record, until the pending object of picture fields in the data-base recording
Numbering is identical with the numbering of the pending object of second picture filename, performs step 5;
Step 5:The second picture of pending object is imported into data-base recording;
Step 6:Judge whether the second picture of the pending object is all imported in data-base recording, if it is not, performing
Step 3;Otherwise, processing terminates.
2. the method that the picture batch in physical assets management according to claim 1 imports database, it is characterised in that
The picture of one pending object correspondence, one group of pending object;Be stored with database object to be handled database note
Record.
3. the method that the picture batch in physical assets management according to claim 1 imports database, it is characterised in that
The step 1 also includes, by the picture of object to be handled be saved in local or External memory equipment.
4. the method that the picture batch in physical assets management according to claim 1 imports database, it is characterised in that
The bar code is one-dimensional bar code or two-dimensional bar.
5. the system that the picture batch in a kind of physical assets management imports database, it is characterised in that the system includes figure
Piece acquisition device (1), picture resolver (2), picture processing device (3), picture traversal device (4), picture gatherer (5)
With picture judgment means (6);
The picture acquiring device (1), the picture for obtaining some groups of pending objects, the picture point of every group of pending object
Not Bao Kuo the first picture and second picture, first picture be containing object to be handled bar code information photo, it is described
Second picture is that the standard for the pending object for meeting system administration request is shone;
The picture resolver (2), for extracting bar code information from the first picture of some groups of pending objects, passes through
Each bar code information is parsed into the numbering of pending object by bar code analytic technique, then respectively will be each pending right
The numbering of the pending object of second picture filename RNTO of elephant;
The picture processing device (3), the numbering traversal for the pending object according to the second picture filename is all
Data-base recording, per data storehouse, record includes picture fields, and the picture fields include the numbering of pending object, when described
The numbering and the numbering of the pending object of picture fields in the data-base recording of the pending object of second picture filename
When differing, picture traversal device (4) is returned to;When identical, picture gatherer (5) is returned to;
The picture traversal device (4), for continuing to travel through next data storehouse record, until picture in the data-base recording
The numbering of the pending object of field is identical with the numbering of the pending object of second picture filename, returns to picture gatherer
(5);
The picture gatherer (5), for the second picture of pending object to be imported into data-base recording;
The picture judgment means (6), for judging whether the second picture of the pending object all imports database note
In record, if it is not, returning to picture processing device (3).
6. the system that the picture batch in physical assets management according to claim 5 imports database, it is characterised in that
The picture of one pending object correspondence, one group of pending object;Be stored with database object to be handled database note
Record.
7. the system that the picture batch in physical assets management according to claim 5 imports database, it is characterised in that
The system also includes picture save set (7), for by the picture of object to be handled be saved in local or outside deposit
Store up in equipment.
8. the system that the picture batch in physical assets management according to claim 5 imports database, it is characterised in that
The bar code is one-dimensional bar code or two-dimensional bar.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410682477.2A CN104391938B (en) | 2014-11-24 | 2014-11-24 | A kind of picture batch in physical assets management imports the method and system of database |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410682477.2A CN104391938B (en) | 2014-11-24 | 2014-11-24 | A kind of picture batch in physical assets management imports the method and system of database |
Publications (2)
Publication Number | Publication Date |
---|---|
CN104391938A CN104391938A (en) | 2015-03-04 |
CN104391938B true CN104391938B (en) | 2017-10-10 |
Family
ID=52609842
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201410682477.2A Active CN104391938B (en) | 2014-11-24 | 2014-11-24 | A kind of picture batch in physical assets management imports the method and system of database |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN104391938B (en) |
Families Citing this family (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104657495B (en) * | 2015-03-09 | 2018-11-27 | 广东欧珀移动通信有限公司 | A kind of picture renaming method and picture rename device |
CN106302581A (en) * | 2015-05-21 | 2017-01-04 | 阿里巴巴集团控股有限公司 | The introduction method of batch data and system |
CN106599084A (en) * | 2016-11-21 | 2017-04-26 | 上海斐讯数据通信技术有限公司 | Database data synchronous input device and method |
CN106599212A (en) * | 2016-12-16 | 2017-04-26 | 济南浪潮高新科技投资发展有限公司 | Method for importing data in batches through business interface |
CN115866348A (en) * | 2021-09-24 | 2023-03-28 | 上海幻电信息科技有限公司 | Data processing method, device and system based on two-dimensional code |
CN113947389B (en) * | 2021-12-20 | 2022-04-22 | 佛山众陶联供应链服务有限公司 | Digitization method and digitization system for balance sheet of ceramic supply chain system |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101873467A (en) * | 2009-04-24 | 2010-10-27 | 联芯科技有限公司 | Multimedia terminal and method for processing information of mobile television by using same |
CN102625937A (en) * | 2009-08-07 | 2012-08-01 | 谷歌公司 | Architecture for responding to a visual query |
CN103080897A (en) * | 2010-08-05 | 2013-05-01 | 波音公司 | Methods and systems for optical asset recognition and location tracking |
CN103150392A (en) * | 2013-03-25 | 2013-06-12 | 江苏乐买到网络科技有限公司 | Method for comparing prices of similar commodities |
-
2014
- 2014-11-24 CN CN201410682477.2A patent/CN104391938B/en active Active
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101873467A (en) * | 2009-04-24 | 2010-10-27 | 联芯科技有限公司 | Multimedia terminal and method for processing information of mobile television by using same |
CN102625937A (en) * | 2009-08-07 | 2012-08-01 | 谷歌公司 | Architecture for responding to a visual query |
CN103080897A (en) * | 2010-08-05 | 2013-05-01 | 波音公司 | Methods and systems for optical asset recognition and location tracking |
JP2013539102A (en) * | 2010-08-05 | 2013-10-17 | ザ・ボーイング・カンパニー | Optical asset identification and location tracking |
CN103150392A (en) * | 2013-03-25 | 2013-06-12 | 江苏乐买到网络科技有限公司 | Method for comparing prices of similar commodities |
Also Published As
Publication number | Publication date |
---|---|
CN104391938A (en) | 2015-03-04 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN104391938B (en) | A kind of picture batch in physical assets management imports the method and system of database | |
CN106033435B (en) | Item identification method and device, indoor map generation method and device | |
CN103810224B (en) | information persistence and query method and device | |
CN103186541B (en) | A kind of mapping relations generate method and device | |
CN103902701B (en) | A kind of data-storage system and storage method | |
CN108108426A (en) | Understanding method, device and the electronic equipment that natural language is putd question to | |
CN107229757A (en) | The video retrieval method encoded based on deep learning and Hash | |
JP2007172384A5 (en) | ||
CN105589938A (en) | Image retrieval system and retrieval method based on FPGA | |
CN104572965A (en) | Search-by-image system based on convolutional neural network | |
WO2003069554A3 (en) | Method and system for interactive ground-truthing of document images | |
CN104462873A (en) | Picture processing method and picture processing device | |
TW201241773A (en) | Method and apparatus of determining product category information | |
CN104618361B (en) | A kind of network flow data method for reordering | |
US20140074993A1 (en) | Method enabling the presentation of two or more contents interposed on the same digital stream | |
CN104951562B (en) | A kind of image search method based on VLAD dual adaptions | |
CN105183857A (en) | Automatic picture training sample extracting method and system | |
CN106980620A (en) | A kind of method and device matched to Chinese character string | |
CN106649360A (en) | Data repeatability check method and apparatus | |
CN107330009A (en) | Descriptor disaggregated model creation method, creating device and storage medium | |
CN104346616B (en) | Character recognition device and character identifying method | |
CN106997350A (en) | A kind of method and device of data processing | |
Truong et al. | Video search based on semantic extraction and locally regional object proposal | |
CN107247730A (en) | Image searching method and device | |
CN102004795B (en) | Hand language searching method |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
TA01 | Transfer of patent application right | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20170914 Address after: 430070, Hubei City, Wuhan province East Lake New Technology Development Zone, Gezhouba Dam Sun City 1, 1, room 2 Applicant after: Wuhan Haichuan Yungu Software Technology Co. Ltd. Address before: 430070, room 1, 40 Gezhouba Dam Sun Industrial Park, four hi tech Road, East Lake Development Zone, Wuhan, Hubei,, China Applicant before: Huang Jinri |