CN102033939B - High-speed bar code recognition database management method based on SOA framework and system - Google Patents
High-speed bar code recognition database management method based on SOA framework and system Download PDFInfo
- Publication number
- CN102033939B CN102033939B CN201010597209.2A CN201010597209A CN102033939B CN 102033939 B CN102033939 B CN 102033939B CN 201010597209 A CN201010597209 A CN 201010597209A CN 102033939 B CN102033939 B CN 102033939B
- Authority
- CN
- China
- Prior art keywords
- server
- data
- bar code
- database server
- database
- 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.)
- Expired - Fee Related
Links
- 238000007726 management method Methods 0.000 title claims abstract description 44
- 238000000034 method Methods 0.000 claims abstract description 22
- 238000003860 storage Methods 0.000 claims abstract description 20
- 239000003205 fragrance Substances 0.000 claims description 20
- 230000005540 biological transmission Effects 0.000 claims description 8
- 238000004891 communication Methods 0.000 claims description 7
- 230000002452 interceptive effect Effects 0.000 claims description 6
- 238000013507 mapping Methods 0.000 claims description 6
- 239000000203 mixture Substances 0.000 claims description 5
- 230000008859 change Effects 0.000 claims description 3
- 238000013523 data management Methods 0.000 claims description 3
- 230000007246 mechanism Effects 0.000 claims description 3
- YNPNZTXNASCQKK-UHFFFAOYSA-N phenanthrene Chemical compound C1=CC=C2C3=CC=CC=C3C=CC2=C1 YNPNZTXNASCQKK-UHFFFAOYSA-N 0.000 description 16
- 238000007639 printing Methods 0.000 description 13
- 238000004519 manufacturing process Methods 0.000 description 11
- 238000005520 cutting process Methods 0.000 description 6
- 238000005516 engineering process Methods 0.000 description 5
- 230000004044 response Effects 0.000 description 4
- 241000237858 Gastropoda Species 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 230000000717 retained effect Effects 0.000 description 3
- 238000011161 development Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- OKTJSMMVPCPJKN-UHFFFAOYSA-N Carbon Chemical compound [C] OKTJSMMVPCPJKN-UHFFFAOYSA-N 0.000 description 1
- PEDCQBHIVMGVHV-UHFFFAOYSA-N Glycerine Chemical compound OCC(O)CO PEDCQBHIVMGVHV-UHFFFAOYSA-N 0.000 description 1
- 230000008901 benefit Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 229910052799 carbon Inorganic materials 0.000 description 1
- 238000004140 cleaning Methods 0.000 description 1
- 239000002131 composite material Substances 0.000 description 1
- 230000008878 coupling Effects 0.000 description 1
- 238000010168 coupling process Methods 0.000 description 1
- 238000005859 coupling reaction Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000009434 installation Methods 0.000 description 1
- 230000035800 maturation Effects 0.000 description 1
- 238000004064 recycling Methods 0.000 description 1
- 238000005096 rolling process Methods 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 239000004753 textile Substances 0.000 description 1
- 238000012549 training Methods 0.000 description 1
Abstract
The invention discloses high-speed bar code recognition database management method based on SOA framework, it is characterised in that its method comprises the following steps: (1) builds a SOA framework system；(2) an application system server is set in application layer, multiple stage database server is set at data Layer；(3) each database server in described data server array is carried out sequential coding；(4) in each database server, data directory list that is of the same name with application server and include same field is created；(5) application system server is according to the request of associated data, creates corresponding bar code value record and sets up data association；(6) bar code value and associated data are paid the storage of correspondence database server；(8) application system server inquires about according to barcode device request, read and write or updates the data record being associated with bar code value.Present invention also offers the data base management system realizing the method.
Description
Technical field
The present invention relates to computer technology and network communication technology field, particularly relate to a kind of high speed bar code
Identification database management method, further relates to a kind of Database Systems realizing the method.
Background technology
In prior art, the production numeration of the various manufacturing enterprises such as garment enterprise, substantially adopt
With printing luxuriant and rich with fragrance young (i.e. two-dimensional bar code) paper slip, this method then tied up in cut-parts is carried out.
The luxuriant and rich with fragrance son that garment enterprise cutting prints has two kinds, and a kind of with bar code, one is without bar code
's.Most garment enterprise, including have employed the garment enterprise that large-scale hangar system carries out producing, be
The luxuriant and rich with fragrance son with bar code need to be printed and carry out producing the scanning recognition numeration of each link, and use RFID technique
, then use printing being pasted onto on rfid card without bar code phenanthrene son and carry out identification numeration of swiping the card.
RFID swipe the card numeration compare paper phenanthrene bar code scan numeration for, one of its advantage is that rfid card can
To reuse, but promote the software system of this technology at present, all need nonetheless remain for printing paster, and
Needing multiple card to support the use, in addition, the turnaround time that rfid card repeats recycling is long, therefore, and enterprise
Need the substantial amounts of rfid card of disposable input to lay in, considerably increase the cost of enterprise.
Rfid card, in circular flow, is also faced with taking care of, stores, the managerial problem such as cleaning,
Therefore, use rfid card, can not save and print luxuriant and rich with fragrance young cost, the input of enterprise can be increased the weight of on the contrary
With management cost.RFID numeration of swiping the card is its fast response time than the bar code paper phenanthrene real strong point of numeration,
Therefore, how to solve or improve the key that paper phenanthrene bar code scan numeration response speed is problem.Cause paper
The slow reason of luxuriant and rich with fragrance bar code scan response speed has multiple, such as: the quality of printing device, printing carbon ribbon
Quality, the quality etc. of printing paper, but these easily solve, and are not key factor.Key again than
More scabrous factor is: how to control in a shorter scope by the character length generating bar code,
To improve recognition speed and the accuracy of barcode scanner, data server is enable quickly to carry out data manipulation.
The luxuriant and rich with fragrance width of the width that in prior art, printer prints, i.e. paper is fixing, and bar code be need by
The ratio of certain height and the width, particularly to have enough width, print, just can be just
Really identify.Such as: now with the width that a paper is luxuriant and rich with fragrance, just can only correctly identify 1 figure place
Bar code, changes to 7 figure places by the figure place of bar code, and the black and white space of this bar code will become the closeest
Real, even bond together, be difficult to maybe cannot be identified.Therefore, it is restricted at paper phenanthrene width
In the case of, how to use technological means, reduce the information digit described in bar code, just become problem
One of crucial.
In manufacturing industry production management system, in the software management system of garment enterprise, produce bar code
The method of character, generally has two kinds, and one is coded system, and one is to utilize SQL2000 data base
The identification field of middle list automatically generates natural number sequentially.The first coded system, character length,
Complexity is difficult to again avoid repeating, and (programming) of software system realizes finally also needing client to participate in,
Thus, this mode is worthless, does not uses；The second natural number automatic increase mode,
Simple and practical, bar code generates number and never repeats, and clothing software system is typically all adopted in this way.
But it is the natural number constantly added up, for the garment production enterprise of monthly output ten thousand ready-made clothes products of 10-20
Industry, within its month, generation bar yardage can reach about 1,000,000, and it is exactly up to ten million within 1 year, adding up to get off.The most just
It is to say, the figure place of bar code, 7 figure places can be rapidly risen to from 1 figure place in one month, will after 1 year
Being maintained at more than 8 figure places, its quantity of information recorded is the hugest, and the width of common bar code paper is just
Demand can not be met, here it is bar code is more and more closeer, read or write speed is increasingly slower, and garment enterprise
The selected paper being used for printing the paper phenanthrene of bar code only requires that low price, toughness are strong, width is the widest
Main cause, and only this item, annual the most just to the integrated cost of tens thousand of to the hundreds thousand of units of increase of enterprise.
It addition, in existing garment enterprise production management system, be applied to clothing and beat the information that luxuriant and rich with fragrance meter is luxuriant and rich with fragrance
Management system does not also provide the form of cutting list lattice, it is impossible to the typing cutting list of quicklook, no
Conveniently browse statistics；Because Bar Code does not reaches the level that efficiently and accurately is errorless, it is not easy to produce
The inquiry of progress.The hardware configuration of the properly functioning requirement of system is the highest, needs extra increase hardware supporting
Spending, adds use cost, and it is slow and easy that every document that form single centre controls generates process
Make mistakes, simultaneously factor data frequent operation and huge, often result in system crash, it has not been convenient to management same
Time easily cause loss of data, it is impossible to process flow is monitored in real time and the accurate palm of production status
Hold.
In recent years, Service-Oriented Architecture Based (SOA) the software system architecture technology of fast development, for solving
The problems referred to above provide feasibility, and SOA undoubtedly has become as a new generation of enterprise first-selection, first
That enter, maturation, the application architecture of standard, but, with regard to current enterprise information management Software Industry
For, there is no the concrete report seen about using it for high speed bar code identification database management system aspects
Road and practice.
Summary of the invention
An object of the present invention, is the above-mentioned deficiency for prior art, it is provided that a kind of based on SOA
The high-speed bar code recognition database management method of framework, the method generates the position of the natural increase number of bar code
Number, in the range of remaining at default value data (within 7 figure places), described in bar code
Information controls in default numerical range, so that the black and white vertical line of bar code is at fixing width range
The most all the time can keep preferable density, on the one hand bar code is easily scanned rifle and accurately identifies out, separately
On the one hand the speed of system read-write data form is accelerated again.Meanwhile, also luxuriant and rich with fragrance for reducing printing paper width
Degree, or within the relative unit interval, many type slugs number of codes, it is provided that condition.
A further object of the present invention is to provide a kind of Database Systems realizing the method, passes through data
The form composition data warehouse of storehouse server array, by setting each server access data record
The method of big bar number, carries out accessing operation to database server one by one, thus substantially increases data
The corresponding speed of library access operation.
For effectively solving above-mentioned technical problem, the technical scheme that the present invention takes is as follows:
High-speed bar code recognition database management method based on SOA framework, it is characterised in that its method
Comprise the following steps:
(1) building a SOA framework system, it includes the most interconnective expression layer, application
Layer, operation layer, service layer, data Layer；
(2) an application system server is set in application layer, multiple stage data base clothes are set at data Layer
Business device composition data server array, carries out accessing data manipulation for described application system server；
(3) each database server in described data server array is carried out sequential coding, generate
With each database server uniqueness sequence code value one to one；According to sequence code value described
In application system server, the list of the establishment three fields including this sequence code value, one
Field is the initial value of representation database server series code, and another field is representation database clothes
The maximum of business device sequence code, the 3rd field is storable maximum in each database server
The bar number of data record；Application system server sets its bar code value create-rule as: stem
Previous position or two are each server series code, follow-up for setting the natural order coding in figure place,
This sequential encoding is the serial number adding the most successively and obtaining；
(4) in each database server, it is respectively created and application service according to respective sequence code value
Device is of the same name and includes the data directory list of same field, and according to the instruction of application system server,
Preserve bar code record and the associated data being not more than this setting bar number respectively, enter for application system server
Row read-write operation；
(5) application system server is according to the request of associated data, and creates according to bar code value create-rule
Corresponding bar code value record also sets up data association, and the bar code value generated writes the number of self simultaneously
According in list: according to the request of associated data, application system server automatically generates the previous position of stem
Or front two is database server serial number code, follow-up for set natural order coding in figure place,
The serial number starting to add one successively from a upper record numerical value and obtain is as bar code value, and sets up it and be
The incidence relation of corresponding data in system；Its automatically from the initial value of database server serial number code,
Natural order is encoded to number at the beginning, adds one successively, until this database server serial number code
Database server for initial value reaches the bar number of its maximum storage data record set, and automatically turns
It is that stem, natural order are encoded to number at the beginning and depend on from next database server serial number code
Secondary add one, until this database server reaches the bar number of the maximum storage data record set, then from
Dynamic turning from next database server serial number code is that stem, natural order are encoded to number at the beginning
And add one successively, so move in circles, create corresponding bar code value record for all database servers
And set up data association；
(6) bar code value and associated data are paid the storage of correspondence database server: application system server
The correspondence generation paid is judged automatically according to server series code in the bar code value that self list stores
The database server of code, and this bar code value and associated data are paid it store, until it reaches
The bar number of the maximum data record that this database server sets；Next number of application system server calls
Deposit according to the bar code value of storehouse server and in transferring to the database server of next code serial number
Storage, so moves in circles, and makes all of database server all store the maximum data note set
The data of record bar number；
(7) the maximum data record strip number of setting is entirely reached when database server all of in array
During data, application system server calls the most automatically from the beginning of initial code, sequential encoding is opened from one
The bar code value record begun, re-establishes data association and pays the storage of initial code database server,
Cover identical bar code value and the associated data record thereof of original storage, until it reaches the maximum data of setting
The bar number of record；Application system server calls the bar code of next code serial number data storehouse server automatically
Value also stores in transferring to the database server of next code serial number, until all of data
Storehouse server entirely reaches the bar number of the maximum data record of setting, and so moves in circles；
(8) application system server is inquired about, reads and writes or is updated according to barcode device request and bar code value phase
During the data record of association, first according to the code value of bar code value stem in the data form of self really
The database server at this data record place fixed, then connects and accesses this database server,
Further according to the serial number that bar code value is follow-up, it is quickly found out this bar code value, and then to associated by this bar code value
Data carry out inquiring about, reading and writing or update operation.
Described step (2) is further comprising the steps of: transmitted by data by described application system server
The server array that bus becomes with multiple stage database servers group is connected with each other.
The sequential coding of database server in described step (3), for alphabet code, Arab
Digital coding, or English alphabet and Arabic numerals hybrid coding are that generate with each data base according to it
Server uniqueness sequence code value one to one, is that the sequence according to described sequential coding is the most secondary
Sequence, and the mapping code value that can determine whether before and after's logical relation determined, it can be sequential coding basis
Body, it is also possible to be the mapping code worked out separately.
Described bar code value, first of its stem or front two are the sequence code of database server；
Its subsequent bit is the natural order coding in 1～7 figure places set, and this sequential encoding is for depend on from the beginning
The secondary serial number adding one and obtain；When natural order coding arrives the maximum setting figure place, automatically
The sequence code of the database server transferring next next-door neighbour continues coding as stem, all the time by bar code
Value controls within 2～10, so that the black and white vertical line of bar code all the time can in fixing width range
Keep preferable density, it is possible to identified quickly and accurately.
The associated data of described bar code value, is to be set according to application program by application system server
Character, numerical value, date, time, the constant of the type such as logic or variable data.
A kind of high speed bar code identification database based on SOA framework management system realizing preceding method,
It is characterized in that,
Described SOA framework system, it include the most interconnective expression layer, application layer,
Operation layer, service layer, data Layer；An application system service it is provided with in wherein said application layer
Device, arranges multiple stage database server, is provided with based on WEB in described expression layer in described data Layer
Integrated door, for the most several client terminals access.
Described database server and application system server constitute remote server, and described application takes
Business device includes that application subsystem, function control subsystem, beat luxuriant and rich with fragrance management subsystem, data management subsystem
System and form menu manager subsystem；Described database server includes that data transmission module, data store
Module and data call module；Described application system server passes through one or more levels data transmission bus
It is connected with each other and interactive communication with described database server.
Described Database Systems also include that the most several graded access end, described graded access end include passing through
The local work station access end that LAN is directly connected with described application server, and pass through
The remote work station access end that INTERNET connects；Described server end and described access end are by handing over
Change planes build LAN or INTERNET be connected with each other and realize interactive communication.
Described server end is provided with the multiple service of daily server, standby server and immediate care device
Device duty selects pattern, it is provided that calamitous server handover mechanism, and described function controls subsystem
Also include authority management module, and use single entrance many rights managements pattern to carry out user's management.
The present invention uses SOA framework flexible, quick, distributed, uses high speed bar code identification data
Library management method, makes the figure place of the bar code value of generated natural increase control all the time in the figure place set
In the range of, as controlled in the range of 2～9, if the restricted width of printing paper phenanthrene can also be further
Control within 2～7 figure places, so that the black and white vertical line of bar code all the time can in fixing width range
Keeping preferable density, on the one hand bar code is easily scanned rifle and identifies, and on the other hand accelerates again
System to addressing data, read and write, update time response and processing speed；It is also possible to realize
Reduce the width that printing paper is luxuriant and rich with fragrance, save paper using and cut operating costs, or within the relative unit interval,
Many type slugs number of codes, accelerates operating rate, improves work efficiency.
The present invention provides data base management system based on SOA framework, by data Layer classification bus,
Data are managed concentratedly by data server array, and by SOA framework loose coupling, expansible, easy
The superior functions such as deployment, use Distributed Calculation and data storage；Application system server passes through front end
The production status that each system of computer tracking is single, controls all process steps flow process, understands in real time and scheduling is raw
Produce；System uses Fast Report form single system, meets the multiple report Worksheet self-defining of different client
Demand for services, supports different format printer；Data form is set up and with ERP system with tree
Framework builds, and can infinitely extend customization function；Multilamellar application embodiment work efficiency: simple to operate,
Convenient, fast；WEB integrated operation simple interface, understand, user through less training or is not trained
Instruction just can operate native system；Native system is convenient for installation and maintenance, all completes in remote server, user
Without carrying out mounting box maintenance in this locality, end after server update version, is used to automatically update version；This
Different work position and concrete operations etc. are all being carried out strict rights management system by system；For
Sensitive operation has log recording function.
The composite can be widely applied to clothing, textile industry, and other need to use bar code to give birth to
Produce in the various enterprise informationization management systems of management, and readily satisfy collectivization enterprise, industry-specific
Or cross-cutting industrial chain is integrated, the demand of management, has wide development and application prospect.
The present invention is described in detail below in conjunction with the accompanying drawings.
Accompanying drawing explanation
Fig. 1 is to inquire about and preserve flow chart of data processing schematic diagram after bar code value of the present invention generates；
Fig. 2 is bar code identification of the present invention, inquiry, reading data flow journey schematic diagram；
Fig. 3 is database management system server end system structural representation of the present invention；
Fig. 4 is that data base management system of the present invention forms structural representation.
Detailed description of the invention
Embodiment 1:
See Fig. 1 and Fig. 2,
High-speed bar code recognition database management method based on SOA framework, it is characterised in that its method
Comprise the following steps:
(1) building a SOA framework system, it includes the most interconnective expression layer, application
Layer, operation layer, service layer, data Layer；
(2) an application system server is set in application layer, multiple stage data base clothes are set at data Layer
Business device composition data server array, carries out accessing data manipulation for described application system server；
Described application system server is become with multiple stage database servers group by data transmission bus
Server array is connected with each other；This data transmission bus is one-level centralized deployment, or multilevel distributed
Dispose；
(3) each database server in described data server array is carried out sequential coding, such as
1-9 or A-Z, generates and each database server uniqueness sequence code value one to one, such as 1,
A1, BC etc.；According to sequence code value in described application system server, create and include this sequence generation
Code value is at the list of three interior fields, and a field is at the beginning of representation database server series code
Initial value such as 1, another field is the maximum such as 9 of representation database server series code, the 3rd
Field is the bar number of storable maximum data record in each database server, such as 99999；Answering
It is each service with system server setting its bar code value create-rule as: the previous position of stem or two
Device sequence code, such as A1, BC etc., follow-up for setting the natural order coding in figure place, this is sequentially
The serial number being encoded to add one the most successively and obtain, for example, 1～99999；
The wherein sequential coding of database server, compiles for alphabet code A-Z, Arabic numerals
Code 0-9, or English alphabet and Arabic numerals hybrid coding, or other codings, according to its generate with
Each database server uniqueness sequence code value one to one, is the sequence according to described sequential coding
Row precedence, and the mapping code value that can determine whether before and after's logical relation determined, it can be sequence
Row coding itself, it is also possible to be the mapping code worked out separately, specifically can work out as required.
(4) in each database server, it is respectively created and application service according to respective sequence code value
Device is of the same name and includes the data directory list of same field, and according to the instruction of application system server,
Preserve bar code record and the associated data being not more than this setting bar number respectively, enter for application system server
Row read-write operation；Can be 99999 as set bar number.
The associated data of described bar code value, is to be set according to application program by application system server
Character, numerical value, date, time, the constant of the type such as logic or variable data.
(5) application system server is according to the request of associated data, and creates according to bar code value create-rule
Corresponding bar code value record also sets up data association, and the bar code value generated writes the number of self simultaneously
According in list: according to the request of associated data, application system server automatically generates the previous position of stem
Or front two is database server serial number code, follow-up for set natural order coding in figure place,
The serial number starting to add one successively from a upper record numerical value and obtain is as bar code value, and sets up it and be
The incidence relation of corresponding data in system；Its automatically from the initial value of database server serial number code,
Natural order is encoded to number at the beginning, adds one successively, until this database server serial number code
Database server for initial value reaches the bar number of its maximum storage data record set, and automatically turns
It is that stem, natural order are encoded to number at the beginning and depend on from next database server serial number code
Secondary add one, until this database server reaches the bar number of the maximum storage data record set, then from
Dynamic turning from next database server serial number code is that stem, natural order are encoded to number at the beginning
And add one successively, so move in circles, create corresponding bar code value record for all database servers
And set up data association；
(6) bar code value and associated data are paid the storage of correspondence database server: application system server
The correspondence generation paid is judged automatically according to server series code in the bar code value that self list stores
The database server of code, and this bar code value and associated data are paid it store, until it reaches
The bar number of the maximum data record that this database server sets；Next number of application system server calls
Deposit according to the bar code value of storehouse server and in transferring to the database server of next code serial number
Storage, so moves in circles, and makes all of database server all store the maximum data note set
The data of record bar number；
(7) the maximum data record strip number of setting is entirely reached when database server all of in array
During data, application system server calls the most automatically from the beginning of initial code, sequential encoding is opened from one
The bar code value record begun, re-establishes data association and pays the storage of initial code database server,
Cover identical bar code value and the associated data record thereof of original storage, until it reaches the maximum data of setting
The bar number of record；Application system server calls the bar code of next code serial number data storehouse server automatically
Value also stores in transferring to the database server of next code serial number, until all of data
Storehouse server entirely reaches the bar number of the maximum data record of setting, and so moves in circles；
(8) application system server is inquired about, reads and writes or is updated according to barcode device request and bar code value phase
During the data record of association, first according to the code value of bar code value stem in the data form of self really
The database server at this data record place fixed, then connects and accesses this database server,
Further according to the serial number that bar code value is follow-up, it is quickly found out this bar code value, and then to associated by this bar code value
Data carry out inquiring about, reading and writing or update operation.
Described bar code value, first of its stem or front two are the sequence code of database server；
Its subsequent bit is the natural order coding in 1～7 figure places set, and this sequential encoding is for depend on from the beginning
The secondary serial number adding one and obtain；When natural order coding arrives the maximum setting figure place, automatically
The sequence code of the database server transferring next next-door neighbour continues coding as stem, all the time by bar code
Value controls within 2～10, so that the black and white vertical line of bar code all the time can in fixing width range
Keep preferable density, it is possible to identified quickly and accurately；Also it is effectively shortened server to seek simultaneously
The time of location, improve data access and operating efficiency.
See Fig. 3, Fig. 4, the high speed based on SOA framework realizing preceding method that the present invention provides
Bar code identification database management system, the SOA framework system that it is used, including the most mutual
The expression layer of connection, application layer, operation layer, service layer, data Layer；In wherein said application layer
It is provided with an application system server, multiple stage database server is set in described data Layer,
It is provided with integrated door based on WEB in described expression layer, accesses for the most several client terminals.
Described database server and application system server constitute remote server, and described application takes
Business device includes that application subsystem, function control subsystem, beat luxuriant and rich with fragrance management subsystem, data management subsystem
System and form menu manager subsystem；Described database server includes that data transmission module, data store
Module and data call module；Described application system server passes through one or more levels data transmission bus
It is connected with each other and interactive communication with described database server.
Described Database Systems also include that the most several graded access end, described graded access end include passing through
The local work station access end that LAN is directly connected with described application server, and pass through
The remote work station access end that INTERNET connects；Described server end and described access end are by handing over
Change planes build LAN or INTERNET be connected with each other and realize interactive communication.
Described server end is provided with the multiple service of daily server, standby server and immediate care device
Device duty selects pattern, it is provided that calamitous server handover mechanism, and described function controls subsystem
Also include authority management module, and use single entrance many rights managements pattern to carry out user's management.
Embodiment 2:
In the present embodiment, generate as a example by the production management of enterprise by a ready-made clothes, illustrate the present invention
Concrete application.
The clothing that the present invention is applied to beats the workflow of the luxuriant and rich with fragrance information management system of luxuriant and rich with fragrance meter: fill in cutting
System is single, then forms data input system processed, it is carried out a point rolling tube and manages and check cutting number, connects
Printing device prints luxuriant and rich with fragrance ticket and is issued workshop, workman complete to prick goods one procedure, cut phase
The luxuriant and rich with fragrance ticket answered, submits luxuriant and rich with fragrance ticket after completing work, phenanthrene ticket is read in system with bar code device by statistician so that it is
The direct labor often pricking goods can be inquired about, automatically generate piece-rate wage list and production report list, and at any time
Manufacturing schedule list can be inquired about.
Seeing Fig. 1 and Fig. 2, it is about 1,000,000 that certain ready-made clothes garment enterprise moon generates barcode data amount,
Barcode data is minimum need to be retained three months in systems, be i.e. retained in the barcode data of system be
About 3000000 data.So, this 3,000,000 data is distributed in 31 data bases by our design
On server, the title of 31 servers be respectively tmServer01, tmServer02,
TmServer03......tmServer29, tmServer30, tmServer31, its；Application system server
Upper generation with each database server uniqueness sequence code value one to one, be 1～31；?
In described application system server, the list of the establishment three fields including this sequence code value
" tm ", one of them field is the initial value such as 1 of representation database server series code, another
Field is the maximum such as 31 of representation database server series code, and the 3rd field is each data
The bar number of storable maximum data record in the server of storehouse, such as 99999.
Then all create in every database server one of the same name and include same field content
The SQL2000 data directory list of " tm ", then be less than 100,000 according to the data that this list stores
Bar, when the natural number of the automatic increase i.e. generating bar code reaches 99999, just automatically switches to next number
According on the server of storehouse, start counting up from 1 again.The default value having a field in list is data base
The sequence code of server, is such as tmServer01 list, and its value is the most just 01；In this way
TmServer25 list, its value is the most just 25.
Application system server is set in application layer, and establishment has above three word on that server
The list of section, it includes database server sequence code such as: tmS, and its field initialization values is 01, should
By system when saving data, first read and write the value of this field, arrive the tmServer comprising this value the most again
Whether tm list in the server of series data storehouse looks into the bar yardage of natural increase more than 99999, it is possible to
It is 90000, (for guaranteeing can reserve some spaces less than 99999, it is possible to this value is met at client
Arrange voluntarily), if it is not greater, just the associated data of this bar code value is saved in this database server
In corresponding list, if it is greater, then find database server sequence code field initialization values to add 1
Next database server, then, associated data is saved in tmServer series data storehouse clothes
In the server data list of next order of business device, when in tmS list, field value is 31, and
When the data volume of storage is more than 99999 in tmServer31 server tm data form, all numbers are described
The bar code value associated data retained according to storehouse list current system has surpassed 3,000,000, then application system server
Bar code value in new associated data, with First database server is associated, will
Data in tmServer01 server tm list update, and by the count value used by bar code field identification
Reset to the seed of these row, the most again from the beginning of 1.
When printing bar code, bar code value is then added server series code (sequence by original single natural number
Number) composition, it is such as the Article 1 data in tmServer01 list, its bar code value is: 1-01,
2nd data, its bar code value is: 2-01, the 3rd data, and its bar code value is: 3-01, with this type of
Push away；Article 1 data in tm25 list in this way, its bar code value is: 1-25, the 2nd data, its
Bar code value is: 2-25, the 3rd data, and its bar code value is: 3-25...... is by that analogy；(above
Natural number is plus the building form of database server sequence number, it is possible to server sequence number, front, represents single
The natural increase number of bar code rear, such as (tm01 list): 01-1,01-2 etc.).
When carrying out inquiring about according to bar code and obtain data, as long as first identifying the sequence of database server
Row code, goes to search follow-up natural numerical value in the data directory list comprising this sequence code of then arriving
Just can quickly find corresponding data record.
So, the figure place of the natural increase number generating bar code is controlled in the figure place scope being set all the time
In, such as 7 (i.e. data record strip number be less than 100,000), so that the black and white vertical line of bar code is solid
All the time can keep in fixed width range preferably combing density；On the one hand bar code is easily scanned rifle identification
Out, on the other hand System Addresses, read-write or the speed of more new data are accelerated again.Meanwhile, also it is
Reduce the width that printing paper is luxuriant and rich with fragrance, or within the relative unit interval, many type slugs number of codes, it is provided that
Condition.
The present invention is not limited to above-mentioned embodiment, and all employings come real with similarity method of the present invention and system
All embodiments of existing the object of the invention are all within protection scope of the present invention.
Claims (10)
1. high-speed bar code recognition database management method based on SOA framework, it is characterised in that its
Method comprises the following steps:
(1) building a SOA framework system, it includes the most interconnective expression layer, application
Layer, operation layer, service layer, data Layer；
(2) an application system server is set in application layer, multiple stage data base clothes are set at data Layer
Business device composition data server array, carries out accessing data manipulation for described application system server；
(3) each database server in described data server array is carried out sequential coding, generate
With each database server uniqueness sequence code value one to one；According to sequence code value described
In application system server, the list of the establishment three fields including this sequence code value, one
Field is the initial value of representation database server series code, and another field is representation database clothes
The maximum of business device sequence code, the 3rd field is storable maximum in each database server
The bar number of data record；Application system server sets its bar code value create-rule as: stem
Previous position or two are each server series code, follow-up for setting the natural order coding in figure place,
This sequential encoding is the serial number adding the most successively and obtaining；
(4) in each database server, it is respectively created and application service according to respective sequence code value
Device is of the same name and includes the data directory list of same field, and according to the instruction of application system server,
Preserve bar code record and the associated data being not more than this setting bar number respectively, enter for application system server
Row read-write operation；
(5) application system server is according to the request of associated data, and creates according to bar code value create-rule
Corresponding bar code value record also sets up data association, and the bar code value generated writes the number of self simultaneously
According in list: according to the request of associated data, application system server automatically generates the previous position of stem
Or front two is database server serial number code, follow-up for set natural order coding in figure place,
The serial number starting to add one successively from a upper record numerical value and obtain is as bar code value, and sets up it and be
The incidence relation of corresponding data in system；Its automatically from the initial value of database server serial number code,
Natural order is encoded to number at the beginning, adds one successively, until this database server serial number code
Database server for initial value reaches the bar number of its maximum storage data record set, and automatically turns
It is that stem, natural order are encoded to number at the beginning and depend on from next database server serial number code
Secondary add one, until this database server reaches the bar number of the maximum storage data record set, then from
Dynamic turning from next database server serial number code is that stem, natural order are encoded to number at the beginning
And add one successively, so move in circles, create corresponding bar code value record for all database servers
And set up data association；
(6) bar code value and associated data are paid the storage of correspondence database server: application system server
The correspondence generation paid is judged automatically according to server series code in the bar code value that self list stores
The database server of code, and this bar code value and associated data are paid it store, until it reaches
The bar number of the maximum data record that this database server sets；Next number of application system server calls
Deposit according to the bar code value of storehouse server and in transferring to the database server of next code serial number
Storage, so moves in circles, and makes all of database server all store the maximum data note set
The data of record bar number；
(8) application system server is inquired about, reads and writes or is updated according to barcode device request and bar code value phase
During the data record of association, first according to the code value of bar code value stem in the data form of self really
The database server at this data record place fixed, then connects and accesses this database server,
Further according to the serial number that bar code value is follow-up, it is quickly found out this bar code value, and then to associated by this bar code value
Data carry out inquiring about, reading and writing or update operation.
High speed bar code identification database based on SOA framework the most according to claim 1 manages
Method, it is characterised in that it also comprises the steps:
(7) the maximum data record strip number of setting is entirely reached when database server all of in array
During data, application system server calls the most automatically from the beginning of initial code, sequential encoding is opened from one
The bar code value record begun, re-establishes data association and pays the storage of initial code database server,
Cover identical bar code value and the associated data record thereof of original storage, until it reaches the maximum data of setting
The bar number of record；Application system server calls the bar code of next code serial number data storehouse server automatically
Value also stores in transferring to the database server of next code serial number, until all of data
Storehouse server entirely reaches the bar number of the maximum data record of setting, and so moves in circles.
High speed bar code identification database based on SOA framework the most according to claim 1 and 2
Management method, it is characterised in that
Described step (2) is further comprising the steps of: transmitted by data by described application system server
The server array that bus becomes with multiple stage database servers group is connected with each other.
High speed bar code identification database based on SOA framework the most according to claim 1 and 2
Management method, it is characterised in that
The sequential coding of database server in described step (3), for alphabet code, Arab
Digital coding, or English alphabet and Arabic numerals hybrid coding are that generate with each data base according to it
Server uniqueness sequence code value one to one, is that the sequence according to described sequential coding is the most secondary
Sequence, and the mapping code value that can determine whether before and after's logical relation determined, it is sequential coding itself,
Or the mapping code worked out separately.
High speed bar code identification database based on SOA framework the most according to claim 1 and 2
Management method, it is characterised in that
Described bar code value, first of its stem or front two are the sequence code of database server；
Its subsequent bit is the natural order coding in 1～7 figure places set, and this sequential encoding is for depend on from the beginning
The secondary serial number adding one and obtain；When natural order coding arrives the maximum setting figure place, automatically
The sequence code of the database server transferring next next-door neighbour continues coding as stem, all the time by bar code
Value controls within 2～10, so that the black and white vertical line of bar code all the time can in fixing width range
Keep preferable density, it is possible to identified quickly and accurately.
High speed bar code identification database based on SOA framework the most according to claim 1 and 2
Management method, it is characterised in that
The associated data of described bar code value, is to be set according to application program by application system server
Character, numerical value, date, time, the constant of logical type or variable data.
7. the high speed bar code based on SOA framework realizing one of claim 1～6 described method
Identification database management system, it is characterised in that
It is provided with integrated door based on WEB in described expression layer, accesses for the most several client terminals.
High speed bar code identification database based on SOA framework the most according to claim 7 manages
System, it is characterised in that
Described database server and application system server constitute remote server, and described application takes
Business device includes that application subsystem, function control subsystem, beat luxuriant and rich with fragrance management subsystem, data management subsystem
System and form menu manager subsystem；Described database server includes that data transmission module, data store
Module and data call module；Described application system server passes through one or more levels data transmission bus
It is connected with each other and interactive communication with described database server.
High speed bar code identification database based on SOA framework the most according to claim 7 manages
System, it is characterised in that
Described Database Systems also include that the most several graded access end, described graded access end include passing through
The local work station access end that LAN is directly connected with described application server, and pass through
The remote work station access end that INTERNET connects；Described server end and described access end are by handing over
Change planes build LAN or INTERNET be connected with each other and realize interactive communication.
High speed bar code identification database based on SOA framework the most according to claim 8 manages
System, it is characterised in that
Described server end is provided with the multiple service of daily server, standby server and immediate care device
Device duty selects pattern, it is provided that calamitous server handover mechanism, and described function controls subsystem
Also include authority management module, and use single entrance many rights managements pattern to carry out user's management.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201010597209.2A CN102033939B (en) | 2010-12-21 | 2010-12-21 | High-speed bar code recognition database management method based on SOA framework and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201010597209.2A CN102033939B (en) | 2010-12-21 | 2010-12-21 | High-speed bar code recognition database management method based on SOA framework and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102033939A CN102033939A (en) | 2011-04-27 |
| CN102033939B true CN102033939B (en) | 2016-11-23 |
Family
ID=43886832
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201010597209.2A Expired - Fee Related CN102033939B (en) | 2010-12-21 | 2010-12-21 | High-speed bar code recognition database management method based on SOA framework and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102033939B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103078775B (en) * | 2012-12-31 | 2018-05-04 | 新奥特（北京）视频技术有限公司 | A kind of method and system based on the interaction of multistage ESB messages between buses |
| CN104899178A (en) * | 2014-04-03 | 2015-09-09 | 腾讯科技（深圳）有限公司 | Service processing method and device |
| CN103927173A (en) * | 2014-04-16 | 2014-07-16 | 深圳市腾邦国际商业服务股份有限公司 | Data processing method and system based on integrated sales operation |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7258266B1 (en) * | 2003-12-23 | 2007-08-21 | Siebel Systems, Inc. | Defining, administering, and managing automatic identification information, such as bar codes |
| CN201229591Y (en) * | 2008-07-14 | 2009-04-29 | 东莞市盈达科技开发有限公司 | Clothing ERP management system based on SOA architecture |
| CN101546325A (en) * | 2008-12-23 | 2009-09-30 | 重庆邮电大学 | Grid heterogeneous data integrating method based on SOA |
| CN101765224A (en) * | 2010-01-18 | 2010-06-30 | 彭保 | Mutually unique mark implementation method for terminal of Internet of Things |
-
2010
- 2010-12-21 CN CN201010597209.2A patent/CN102033939B/en not_active Expired - Fee Related
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7258266B1 (en) * | 2003-12-23 | 2007-08-21 | Siebel Systems, Inc. | Defining, administering, and managing automatic identification information, such as bar codes |
| CN201229591Y (en) * | 2008-07-14 | 2009-04-29 | 东莞市盈达科技开发有限公司 | Clothing ERP management system based on SOA architecture |
| CN101546325A (en) * | 2008-12-23 | 2009-09-30 | 重庆邮电大学 | Grid heterogeneous data integrating method based on SOA |
| CN101765224A (en) * | 2010-01-18 | 2010-06-30 | 彭保 | Mutually unique mark implementation method for terminal of Internet of Things |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102033939A (en) | 2011-04-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103238150B (en) | By multiple users real-time synchronization documents editing to blog | |
| CN100440141C (en) | Customizable information processing apparatus | |
| CN101552842B (en) | Call center application data and interoperation architecture for a telecommunication service center | |
| CN106708480A (en) | Management platform realization method and apparatus | |
| US7143111B2 (en) | Magazine automatic editing system | |
| CN103020027A (en) | Method, device and system for generating dynamic report | |
| JPH0698062A (en) | Method for application of form for requesting of automatic form generation | |
| CN106293554A (en) | A kind of cloud print system and cloud printer | |
| CN101799808A (en) | Data processing method and system thereof | |
| CN101027637A (en) | Engineering data interface and electrical specification tracking and ordering system | |
| Shao et al. | Evaluation of postponement strategies in mass customization with service guarantees | |
| CN101446971A (en) | Method for building content management system and device thereof | |
| CN106126587A (en) | Multinode data based on flow process display recording mechanism | |
| CN109685475A (en) | Intelligent warehouse management system based on SOA and genetic algorithm | |
| CN111694547A (en) | Automatic coding data processing application design tool based on data state change | |
| CN109299180A (en) | A kind of data warehouse ETL operating system | |
| CN102033939B (en) | High-speed bar code recognition database management method based on SOA framework and system | |
| CN109034622A (en) | A kind of data processing method and system | |
| CN113805853A (en) | Software product development system based on industrial internet | |
| US7512546B2 (en) | Store system | |
| CN103870252A (en) | Resource managing method and device | |
| CN110389817A (en) | Dispatching method, device and the computer program product of cloudy system | |
| Bernstein | A fifteen-year forecast of information processing technology | |
| CN101635711B (en) | Programmable character communication method | |
| CN107678856B (en) | Method and device for processing incremental information in business entity |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C41 | Transfer of patent application or patent right or utility model | ||
| CB03 | Change of inventor or designer information |
Inventor after: Sun Mingke Inventor after: Cai Yongsheng Inventor after: Zhao Jianlei Inventor after: Cao Haining Inventor before: Sun Mingke |
|
| COR | Change of bibliographic data | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20160901 Address after: 523000 Guangdong province Dongguan Nancheng District week Xilong Xi Road No. 5 Goldman tech park two of Goldman's 15 storey commercial building room 08 Applicant after: DONGGUAN GAOMING ENTERPRISE SERVICE CO.,LTD. Address before: 523000 Guangdong Province, Dongguan Nancheng District Yuan Mei Dong Lu first international Bai'an center block A room 507 Applicant before: GONGGUAN GOSCIEN ELECTRICAL AND MECHANICAL TECHNOLOGY SERVICES Co.,Ltd. |
|
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20170511 Address after: 511400, Guangdong, Guangzhou hi tech Industrial Development Zone, one of the 2817 Avenue, building 3 Co-patentee after: DONGGUAN GAOMING ENTERPRISE SERVICE CO.,LTD. Patentee after: Guangzhou channel development Mdt InfoTech Ltd. Address before: 523000 Guangdong province Dongguan Nancheng District week Xilong Xi Road No. 5 Goldman tech park two of Goldman's 15 storey commercial building room 08 Patentee before: DONGGUAN GAOMING ENTERPRISE SERVICE CO.,LTD. |
|
| TR01 | Transfer of patent right | ||
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20161123 Termination date: 20211221 |