CN107944054A - Intelligent meter sorts small assistant - Google Patents
Intelligent meter sorts small assistant Download PDFInfo
- Publication number
- CN107944054A CN107944054A CN201711401300.0A CN201711401300A CN107944054A CN 107944054 A CN107944054 A CN 107944054A CN 201711401300 A CN201711401300 A CN 201711401300A CN 107944054 A CN107944054 A CN 107944054A
- Authority
- CN
- China
- Prior art keywords
- sorting
- com
- bar code
- database
- systems
- 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
- 241001269238 Data Species 0.000 claims description 6
- 238000012795 verification Methods 0.000 abstract description 6
- 230000006870 function Effects 0.000 description 11
- 238000007726 management method Methods 0.000 description 8
- 238000011161 development Methods 0.000 description 5
- 230000018109 developmental process Effects 0.000 description 5
- 230000007246 mechanism Effects 0.000 description 3
- 238000007689 inspection Methods 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 2
- 230000006399 behavior Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 229910002056 binary alloy Inorganic materials 0.000 description 1
- 230000015572 biosynthetic process Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 239000012141 concentrate Substances 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000013499 data model Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- PWPJGUXAGUPAHP-UHFFFAOYSA-N lufenuron Chemical compound C1=C(Cl)C(OC(F)(F)C(C(F)(F)F)F)=CC(Cl)=C1NC(=O)NC(=O)C1=C(F)C=CC=C1F PWPJGUXAGUPAHP-UHFFFAOYSA-N 0.000 description 1
- 239000000463 material Substances 0.000 description 1
- 238000000034 method Methods 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 230000001737 promoting effect Effects 0.000 description 1
- 230000031877 prophase Effects 0.000 description 1
- 210000000697 sensory organ Anatomy 0.000 description 1
- 238000003786 synthesis reaction Methods 0.000 description 1
- 230000033772 system development Effects 0.000 description 1
- 238000010977 unit operation Methods 0.000 description 1
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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06K—GRAPHICAL DATA READING; PRESENTATION OF DATA; RECORD CARRIERS; HANDLING RECORD CARRIERS
- G06K17/00—Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations
- G06K17/0022—Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations arrangements or provisions for transferring data to distant stations, e.g. from a sensing device
- G06K17/0025—Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations arrangements or provisions for transferring data to distant stations, e.g. from a sensing device the arrangement consisting of a wireless interrogation device in combination with a device for optically marking the record carrier
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Computer Networks & Wireless Communication (AREA)
- Data Mining & Analysis (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of intelligent meter to sort small assistant, including Database Systems, multimedia system, bar code scanning system and Com+ systems.Start the system on notebook, plug bar code scanner scanning, system shows meter state and provides sorting opinion automatically.Exemplified by sorting 2000 pieces of single-phase meters, originally without the people 1 of needs 4 computer barcode scanning verification when applying this instrument, could it sort within 3 days, after, only need 1 ~ 2 people, 1 computer, 0.5 day can sorting it is complete, by original lifting in 166.67/ day per capita, to 2000, work efficiency improves 12 times to work efficiency.
Description
System regions
The present invention relates to a kind of intelligent meter to sort small assistant.
Background system
In goods and materials standardized administration is measured, the sorting for tearing back meter open is an essential job, in order to ensure meter information
Accuracy, need to scan the bar code of meter one by one in checklist timing and 186 systems checked.
In this work of daily development, limited by storehouse place and the reasons such as prophase management is extensive are influenced, cause meter
To accomplish between man of subsidiary factory, isloation state, timesharing, subregion storage it is highly difficult, then result in needs to collect when returning to provincial company
In again concentrate sorting verification.
When concentrating scanning verification, every piece of table is moved to by computer, verification is scanned in SG186 systems, plus SG186 systems
Speed is very slow when actual, directly affects work efficiency, time-consuming and laborious.
The content of the invention
The object of the present invention is to provide one kind can intelligent meter sort small assistant, 186 system of data source, can be placed on pen
Remember unit operation on this, and carry sound prompt function, improve work efficiency and sort accuracy.
To achieve these goals, the system schema that the present invention takes is as follows：
Intelligent meter sorts small assistant, it includes Database Systems, multimedia system, bar code scanning system and Com+ systems.
Intelligent meter sorts small assistant, comprises the following steps：
The first step, Excel document is exported from SG186 query-relevant datas；
Second step, the system is imported by Excel；
3rd step, the system is copied and is compared on notebook；
4th step, on notebook start the system, plug bar code scanner scanning, system show automatically meter state and to
Go out sorting opinion.
Compared with existing system, having the beneficial effect that acquired by the present invention：
The system is developed by Delphi language designs, and background data base Excel document is directly as database application, mainly
The system being related to includes：Database Systems, multimedia system, bar code scanning system and Com+ systems.The system mainly uses
Step is as follows：1st, Excel document is exported from SG186 query-relevant datas；2nd, Excel is imported into the system；3rd, the system is copied
To comparing on notebook；4th, start the system on notebook, plug bar code scanner scanning, system shows meter state automatically
And provide sorting opinion.Exemplified by sorting 2000 pieces of single-phase meters, originally no apply needs 4 people, 1 computer to sweep during this instrument
Code verification, could sort, after for 3 days, it is only necessary to 1 ~ 2 people 1 computer, 0.5 day can sorting it is complete, work efficiency by
To 2000, work efficiency improves 12 times for lifting in 166.67/ day per capita originally.
Brief description of the drawings
Attached drawing 1 is fundamental diagram of the invention.
Embodiment
Further details of narration is carried out to the present invention below in conjunction with attached drawing.
As shown in Figure 1, a kind of intelligent meter sorts small assistant, it includes Database Systems, multimedia system, bar code and sweeps
Retouch system and Com+ systems.Database Systems are a core systems of information system.It is a kind of computer-aided management data
Method, it study how to organize and store data, how efficiently to obtain and handle data.Database is stored in computer
It is organized in additional storage, sharable related data set.Database has the property that：(1) database is tool
There is the data acquisition system of logical relation and definite meaning.(2) database is designed for clear and definite application target, is established and is loaded
's.Each database has one group of user, and is the application demand service of these users.(3) a database reflects objective
Things in some terms, and need it is always consistent with the state of objective things.Data base management system is to database
The system software being managed, its function are effectively to organize and store data, obtain and manage data, receive and complete to use
The various data access requests that family proposes.It can support the data base management system of relational data model, be known as relationship type number
According to base management system（RDBMS）.The basic function of RDBMS includes following 4 aspects：(1) data definition facility：RDBMS is provided
Data Definition Language, easily can be defined the related content in database using DDL.For example, to database, table,
Field and index are defined, and are created and are changed.(2) data manipulation function：RDBMS provides data manipulation language, utilizes DML
It nowadays can be inserted into fact in database, change and delete the basic operations such as data.(3) data query function：RDBMS provides number
According to query language, the data query operation to database can be realized using DQL.(4) data control function：RDBMS provides number
According to control language, database operation control function, including con current control can be completed using DCL（Handle multiple users at the same time
Using during some data there may be the problem of）, security inspection, the inspection and execution of integrity constraint, database
Internal maintenance（Such as the automatic maintenance of index）Deng.Above-mentioned many functions of RDBMS can by structured query language come
Realize, SQL is a kind of standard language in relational database, and in different RDBMS products, the basic syntax in SQL is
Identical.In addition, DDL, DML, DQL and DCL also belong to SQL.Database application system and referred to as Database Systems, refer to
Possess the computer system of Database Systems support, it can be realized in an organized way, dynamically store a large amount of related datas, there is provided
Data processing and the function of information resources share service.All kinds of personnel are primarily involved in the demand analysis of database application system, if
Meter, develop, use, management and safeguard, they database application system exploitation, operation and safeguard etc. the stage play difference
Role, and play a different role.Using RDBMS data query function to the data in database be associated combination or
Macro or mass analysis step by step, and be shown analysis result with form, figure or report form, so as to solve the synthesis of business datum
Utilizing question.Multimedia system refers to believe the medias such as word, data, figure, image, animation, sound by computer
Breath carries out integrated treatment and management, the system for alloing user to carry out real-time information interaction by a variety of sense organs and computer.This
Multimedia system in invention is to use sound and image model.So-called COM is that one kind illustrates how that foundation can dynamic change group
The specification of part, this specification are provided to guarantee to interoperate, some binary systems and network standard that client and component should follow.
By this standard by can communicate between any two component and without consider its residing for operating environment whether phase
Whether development language that is same, using is consistent and whether runs on same computer.COM+ not only inherits all excellent of COM
Point, and some services are also add, such as queue service, load balance, memory database, Event Service etc..Queue service
Very significant for Distributed Application, particularly in the case where present network speed is very slow, this mechanism can ensure should
Can reliably it be run with system.Application system include great deal of nodes but server it is again busy in the case of, Client application journey
Sequence can be put into their request in queue, these requests are reprocessed when server load is lighter；And for example COM+
Load balancing services are provided, it can realize balancing dynamic load, and the load balance characteristic of COM+ application programs is not
Need to write code to support, CLIENT PROGRAM and component programs can be realized by common mode.Obtain load balance characteristic
It is not to be realized with the mode of programming, but the load balance of distributed application program is realized by configuring, as above
The queue service said, also reflects a kind of load balance in fact.(1) real asynchronous communication.COM+ bottoms provide queue
Component service, this makes client and component be possible to cooperate on different time points, and COM+ applications need not increase code just
Such characteristic can be obtained.(2) Event Service.New case mechanism makes event source and event recipient realize Event Function
More flexibly, event model is simplified using system service, avoids the little detail of COM connectionobject mechanisms.(3) may be used
Retractility.The scalability of COM+ derives from many aspects, the system such as balancing dynamic load and memory database, object pool clothes
Business all provides technical foundation for the scalability of COM+, the telescopic nature in the scalability principle of COM+ with sandwich construction
Unanimously.(4) can manage and configurability.Management and configuration are the behaviors after the completion of application system development, in software maintenance cost
Ever-increasing today, COM+ applications will be helpful to software vendor and user reduces the input of this respect.(5) it is easy to develop.
The complexity and complexity of COM+ application and developments will determine the success or not of COM+, although COM+ development models are than pervious
Com component exploitation is more simplified, but really improves development efficiency and still need by means of some outstanding developing instruments.
Intelligent meter sorts small assistant, comprises the following steps：The first step, from SG186 query-relevant datas export Excel texts
Shelves；Second step, the system is imported by Excel；3rd step, the system is copied and is compared on notebook；4th step, on notebook
Start the system, plug bar code scanner scanning, system shows meter state and provides sorting opinion automatically.
The present invention is highly suitable for promoting and applying in meter sorting work.The system is developed by Delphi language designs,
Directly as database application, the system related generally to includes background data base Excel document：Database Systems, multimedia
System, bar code scanning system and Com+ systems.The system is mainly as follows using step：1st, led from SG186 query-relevant datas
Go out Excel document；2nd, Excel is imported into the system；3rd, the system is copied and compared on notebook；4th, this is started on notebook
System, plug bar code scanner scanning, and system shows meter state and provides sorting opinion automatically.It is single-phase with 2000 pieces of sorting
Exemplified by table, originally needing 4 people, 1 computer barcode scanning verification when apply this instrument, it could sort within 3 days, after,
Need 1 ~ 2 people, 1 computer, 0.5 day can sorting it is complete, work efficiency by original lifting in 166.67/ day per capita to 2000,
Work efficiency improves 12 times.
Embodiment described above is merely a preferred embodiment of the present invention, and the simultaneously exhaustion of the feasible implementation of non-invention.It is right
For the General System personnel of this area, on the premise of without departing substantially from the principle of the invention and spirit to any aobvious made by it and
The change being clear to, should all be contemplated as falling with the claims of the present invention.
Claims (2)
1. intelligent meter sorts small assistant, it is characterised in that：It includes Database Systems, multimedia system, bar code scanning system
With Com+ systems.
2. intelligent meter according to claim 1 sorts small assistant, it is characterised in that：Comprise the following steps：
The first step, Excel document is exported from SG186 query-relevant datas；
Second step, the system is imported by Excel；
3rd step, the system is copied and is compared on notebook；
4th step, starts the system on notebook, plugs bar code scanner scanning, system shows meter state and provides automatically
Sorting opinion.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711401300.0A CN107944054A (en) | 2017-12-22 | 2017-12-22 | Intelligent meter sorts small assistant |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711401300.0A CN107944054A (en) | 2017-12-22 | 2017-12-22 | Intelligent meter sorts small assistant |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107944054A true CN107944054A (en) | 2018-04-20 |
Family
ID=61942666
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711401300.0A Pending CN107944054A (en) | 2017-12-22 | 2017-12-22 | Intelligent meter sorts small assistant |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107944054A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2012061416A1 (en) * | 2010-11-01 | 2012-05-10 | Qualcomm Incorporated | Methods and apparatus for a read, merge, and write register file |
| CN203842831U (en) * | 2014-04-30 | 2014-09-24 | 国家电网公司 | Electric energy meter sorting device based on bar code |
| CN105234093A (en) * | 2015-10-30 | 2016-01-13 | 国家电网公司 | Automatic cleaning information recognizing and sorting system for dismounted intelligent meters |
| CN205229231U (en) * | 2015-12-08 | 2016-05-11 | 王琛 | Novel multifunctional energy meter |
| CN106076865A (en) * | 2016-05-27 | 2016-11-09 | 国网天津市电力公司 | One tears back old electric energy meter automatic sorting processing system open |
-
2017
- 2017-12-22 CN CN201711401300.0A patent/CN107944054A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2012061416A1 (en) * | 2010-11-01 | 2012-05-10 | Qualcomm Incorporated | Methods and apparatus for a read, merge, and write register file |
| CN203842831U (en) * | 2014-04-30 | 2014-09-24 | 国家电网公司 | Electric energy meter sorting device based on bar code |
| CN105234093A (en) * | 2015-10-30 | 2016-01-13 | 国家电网公司 | Automatic cleaning information recognizing and sorting system for dismounted intelligent meters |
| CN205229231U (en) * | 2015-12-08 | 2016-05-11 | 王琛 | Novel multifunctional energy meter |
| CN106076865A (en) * | 2016-05-27 | 2016-11-09 | 国网天津市电力公司 | One tears back old electric energy meter automatic sorting processing system open |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107506462B (en) | Data processing method and system for enterprise-level data, electronic equipment and storage medium | |
| US6611838B1 (en) | Metadata exchange | |
| US8340995B2 (en) | Method and system of using artifacts to identify elements of a component business model | |
| CN110119395B (en) | Method for realizing association processing of data standard and data quality based on metadata in big data management | |
| CN100594497C (en) | System for implementing network search caching and search method | |
| CN102918494A (en) | Data storage and/or retrieval based on a database model-agnostic, schema-agnostic and workload-agnostic data strorage and access models | |
| CN107291471B (en) | Meta-model framework system supporting customizable data acquisition | |
| WO2023241519A1 (en) | Bim component creation method and apparatus, and digital design resource library application method and apparatus | |
| CN110490761A (en) | A kind of power grid distribution net equipment account data model modelling approach | |
| Björk et al. | Integrated construction project document management (ICPDM) | |
| Glava et al. | Information Systems Reengineering Approach Based on the Model of Information Systems Domains | |
| CN110134511A (en) | A kind of shared storage optimization method of OpenTSDB | |
| CN109947797A (en) | A kind of data detecting device and method | |
| CN107944054A (en) | Intelligent meter sorts small assistant | |
| Tari et al. | Designing the reengineering service for the DOK federated database system | |
| CN107301239A (en) | A kind of database converter and conversion method | |
| Jou | Deep web query interface integration based on incremental schema matching and merging | |
| CN108304219A (en) | Secondary developing platform and method | |
| Eze et al. | Database system concepts, implementations and organizations-a detailed survey | |
| Froeschl et al. | The role of metadata in using administrative sources | |
| Dryden | Respect for authority: authority control, context control, and archival description | |
| Wu et al. | Based on Web university library management system's modeling research | |
| Ascione | IACP Archives of Social Housing: An Experimental Web Application for Development, Access and Sharing of Crucial Information for Requalification | |
| GATIMU | Enhancing data staging as a mechanism for fast data access | |
| Bruneau et al. | Towards new processes to reverse engineering digital mock-ups from a set of heterogeneous data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180420 |
|
| RJ01 | Rejection of invention patent application after publication |