CN104504157B - A kind of collecting method - Google Patents
A kind of collecting method Download PDFInfo
- Publication number
- CN104504157B CN104504157B CN201510025361.6A CN201510025361A CN104504157B CN 104504157 B CN104504157 B CN 104504157B CN 201510025361 A CN201510025361 A CN 201510025361A CN 104504157 B CN104504157 B CN 104504157B
- Authority
- CN
- China
- Prior art keywords
- data
- channel
- tables
- acquisition
- address
- 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/21—Design, administration or maintenance of databases
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)
Abstract
The invention discloses a kind of collecting method, wherein, data collecting system is connected with multiple data acquisition units, and each in the multiple data acquisition unit includes multiple passages, the multiple passage corresponds to multiple amounts to be collected of equipment to be collected respectively, comprises the following steps：1) collector table is established in lane database；2) channel table is generated for each collector；3) a total acquisition tables are initialized；4) XML format variable files are generated according to channel table, and is issued to corresponding data acquisition unit；5) each data acquisition unit gathers the data of equipment to be collected by respective channel, and generation respectively divides acquisition tables；6) all points of acquisition tables are uniformly dealt into data collecting system, collection value is inserted into total acquisition tables；7) timing scan passage obtains collection value, and renewal each divides acquisition tables, then updates total acquisition tables.The present invention will make automatic management, addition into by manual edit variable name originally, reduce the cost that system is established and safeguarded.
Description
Technical field
The present invention relates to data collecting field, and in particular to a kind of collecting method.
Background technology
File with CVT forms is the gathered data between terminal and Labview work stations such as NI CRIO terminals or PXI
A kind of mode, this mode efficiency high, speed are fast, and suitable for Large Volume Data communication and large data acquisition system, NI carries
Scheme based on the storage of file supplied, i.e. manual edit meet the file of CVT forms, and distributed terminal and Labview are whole
End is loaded into identical file simultaneously, and terminal scans respective IO by fixed rate, and updates the CVT tables of oneself, then unifies hair
To Labview work stations, Labview workstation maintenances one open big CVT tables, preserve the CVT values collected from each work station.NI
CDL components are additionally provided, for CVT values to be saved in into local data file.
As can be seen that NI this mode needs to establish CVT argument tables by hand, to large scale system, work from foregoing description
Measure and maintenance is all very big；CDL components can be saved in NI oneself file system, be not suitable for using language inquiries such as SQL,
Also inconvenient and other information system queries.
The content of the invention
It is an object of the invention to solve at least the above and/or defect, and provide at least will be described later it is excellent
Point.
In order to realize according to object of the present invention and further advantage, there is provided a kind of collecting method, wherein, number
Multiple data acquisition units are connected with according to acquisition system, and each in the multiple data acquisition unit includes multiple passages, described
Multiple passages correspond to multiple amounts to be collected of equipment to be collected respectively,
Comprise the following steps：
1) collector table is established in the lane database of data collecting system according to the address of each data acquisition unit, it is described to adopt
Storage table includes the address information of all collectors；
2) according to collector table, scan data collector obtains the channel address and channel number of each passage, according to obtaining
Channel address and channel number, respectively each collector generation channel table, the channel table include corresponding data collector
On passage channel address and channel number information；
3) a total acquisition tables are initialized according to all channel tables, in data collecting system, total acquisition tables are to treat
Collection capacity is variable, and each amount to be collected is corresponding with the channel address and channel number of respective channel；
4) XML format variable files are generated according to channel table, and each XML format variable files is issued to corresponding number
According to collector, XML format variable files corresponding to each data acquisition unit loading, the XML format variable files include passage
Channel address and channel number information；
5) information of each data acquisition unit XML format variable files corresponding to, is gathered by respective channel and waits to adopt
Collect the data of equipment, data acquisition unit generates a point acquisition tables, each collection value divided in acquisition tables according to collection value respectively
It is corresponding with the channel address and channel number of respective channel；
6) all points of acquisition tables are uniformly dealt into data collecting system, according to the channel address and channel number of each passage,
Collection value is inserted into total acquisition tables；
7) timing scan passage obtains collection value, and renewal each divides acquisition tables, is then uniformly dealt into data collecting system, more
New total acquisition tables.
Preferably, described collecting method, the data collecting system are NI data collecting systems.
Preferably, described collecting method, the data acquisition unit are PXI or CRIO.
Preferably, described collecting method, it is described to divide acquisition tables and total collection tableau format to be CVT forms.
Preferably, described collecting method, the data collecting system, which is provided with, resides permanently process, according to setting time
Total acquisition tables are read, and are stored to corresponding SQL SERVER value tables.
The present invention comprises at least following beneficial effect：(1) present invention will have been made into automatically by manual edit variable name originally
Management, addition, reduce the cost that system is established and safeguarded.
(2) system closed originally has been made into the suitable framework that can be accessed with any instrument and language, suitable for structure
Build large-scale data collecting system, or and integration of information system.
(3) data acquisition modes of the invention are in the when ratio shared variable mode of variable more than 1000, collecting efficiency meeting
It is high more than 20 times.
Further advantage, target and the feature of the present invention embodies part by following explanation, and part will also be by this
The research and practice of invention and be understood by the person skilled in the art.
Brief description of the drawings
Fig. 1 is the schematic flow sheet for being acquired data preparation of the present invention；
Fig. 2 is the schematic flow sheet for being acquired data of the present invention；
Embodiment
With reference to example, the present invention is described in further detail, to make those skilled in the art with reference to specification text
Word can be implemented according to this.
Example 1
A kind of collecting method, wherein, data collecting system is connected with multiple data acquisition units, and the multiple data are adopted
Each including multiple passages in storage, the multiple passage corresponds to multiple amounts to be collected of equipment to be collected respectively,
As depicted in figs. 1 and 2, comprise the following steps：
1) collector table is established in the lane database of data collecting system according to the address of each data acquisition unit, it is described to adopt
Storage table includes the IP address information of all collectors, is made a distinction each collector by IP address；
2) according to collector table, scan data collector obtains the channel address and channel number of each passage, according to obtaining
Channel address and channel number, respectively each collector generation channel table, the channel table include corresponding data collector
On passage channel address and channel number information；Passage corresponding with each amount to be collected can be thus distinguished；
3) a total acquisition tables are initialized according to all channel tables, in data collecting system, total acquisition tables are to treat
Collection capacity is variable, and each amount to be collected is corresponding with the channel address and channel number of respective channel；
4) XML format variable files are generated according to channel table, and each XML format variable files is issued to corresponding number
According to collector, XML format variable files corresponding to each data acquisition unit loading, the XML format variable files include passage
Channel address and channel number information；XML format variable files be used to telling data acquisition unit need the data that gather and with number
According to the channel address and channel number of corresponding passage；
5) information of each data acquisition unit XML format variable files corresponding to, is gathered by respective channel and waits to adopt
Collect the data of equipment, data acquisition unit generates a point acquisition tables, each collection value divided in acquisition tables according to collection value respectively
It is corresponding with the channel address and channel number of respective channel；
6) all points of acquisition tables are uniformly dealt into data collecting system, according to the channel address and channel number of each passage,
Collection value is inserted into total acquisition tables；
7) timing scan passage obtains collection value, and renewal each divides acquisition tables, is then uniformly dealt into data collecting system, more
New total acquisition tables.
Described collecting method, the data collecting system are NI data collecting systems.
Described collecting method, the data acquisition unit are PXI or CRIO.
Described collecting method, it is described to divide acquisition tables and total collection tableau format to be CVT forms.
Described collecting method, the data collecting system, which is provided with, resides permanently process, is read according to setting time and always adopted
Collect table, and be stored to corresponding SQL SERVER value tables.Thus facilitate and accessed with other instruments and language.
Example 2
1) the collecting device table of distributed parallel computing environment is established；
2) acquisition channel is enumerated into the tables of data of setting form by NI instruments or other method, and closed with corresponding device
Connection；
3) the XML format file of the CVT tables of each collecting device is generated respectively according to CVT data formats；
4) tables of data is inquired about when LABVIEW systems are loaded into and generates total CVT tables；
5) established and communicated by CCC components with each equipment, update total CVT tables；
6) establish and reside permanently process, total CVT tables are read according to setting time, and be stored to corresponding last look according to clause name
In tables of data；
7) program is presented in other data or relevant information integrated system reads tables of data corresponding data and realizes inquiry system
Meter and information integration.
Example 3
Distributed system is CRIO9074, totally 8, each has eight slots, respectively 4 32 tunnel temperature, 4 16 tunnels simulations
Amount, each 192 passages of module, totally 1536 passages, need to define equipment list, be distinguished with IP address, then pass through passage function
Fall to arrange the channel table generation equipment I O tables of each equipment, become according to the XML that equipment I O tables and equipment list generation are named with implementor name
Amount file is issued to each CRIO, and each CRIO is loaded into variable files on startup, and LABVIEW programs are initial from I O table on startup
Change total CVT variables, the channel value of subset is read by CCC timings, and corresponding SQL SERVER are stored to by setting time
It is worth table, query statistic program and other information system program, which access SQL SERVER values tables, can access the collection of current and history
Value.
Although embodiment of the present invention is disclosed as above, it is not restricted in specification and embodiment listed
With.It can be applied to various suitable the field of the invention completely., can be easily for those skilled in the art
Realize other modification.Therefore it is of the invention and unlimited under the universal limited without departing substantially from claim and equivalency range
In specific details and shown here as the example with description.
Claims (4)
1. a kind of collecting method, wherein, data collecting system is connected with multiple data acquisition units, the multiple data acquisition
Each including multiple passages in device, the multiple passage corresponds to multiple amounts to be collected of equipment to be collected respectively,
It is characterised in that it includes following steps：
1) collector table, the collector are established in the lane database of data collecting system according to the address of each data acquisition unit
Table includes the address information of all collectors；
2) channel address and channel number of each passage are obtained according to collector table, scan data collector, it is logical according to what is obtained
Track address and channel number, respectively each collector generation channel table, the channel table is comprising on corresponding data collector
The channel address and channel number information of passage；
3) according to all channel tables, a total acquisition tables are initialized in data collecting system, total acquisition tables are with to be collected
Measure as variable, and each amount to be collected is corresponding with the channel address and channel number of respective channel；
4) XML format variable files are generated according to channel table, and each XML format variable files is issued to corresponding data and adopted
Storage, XML format variable files corresponding to each data acquisition unit loading, the XML format variable files include the logical of passage
Track address and channel number information；
5) information of each data acquisition unit XML format variable files corresponding to, to be collected set is gathered by respective channel
Standby data, data acquisition unit generate a point acquisition tables according to collection value respectively, each collection value divided in acquisition tables with
The channel address and channel number of respective channel are corresponding；
6) all points of acquisition tables are uniformly dealt into data collecting system, according to the channel address and channel number of each passage, will adopted
Set value inserts total acquisition tables；
7) timing scan passage obtains collection value, and renewal each divides acquisition tables, is then uniformly dealt into data collecting system, and renewal is total
Acquisition tables；
The data collecting system, which is provided with, resides permanently process, reads total acquisition tables according to setting time, and be stored to corresponding SQL
SERVER value tables.
2. collecting method as claimed in claim 1, it is characterised in that the data collecting system is NI data acquisitions system
System.
3. collecting method as claimed in claim 1, it is characterised in that the data acquisition unit is PXI or CRIO.
4. collecting method as claimed in claim 1, it is characterised in that described point of acquisition tables and total collection tableau format are
CVT forms.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510025361.6A CN104504157B (en) | 2015-01-19 | 2015-01-19 | A kind of collecting method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510025361.6A CN104504157B (en) | 2015-01-19 | 2015-01-19 | A kind of collecting method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104504157A CN104504157A (en) | 2015-04-08 |
| CN104504157B true CN104504157B (en) | 2018-01-09 |
Family
ID=52945554
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510025361.6A Active CN104504157B (en) | 2015-01-19 | 2015-01-19 | A kind of collecting method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104504157B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107688918A (en) * | 2017-09-07 | 2018-02-13 | 太仓埃特奥数据科技有限公司 | A kind of logistics information big data acquisition method |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2003018575A (en) * | 2001-07-03 | 2003-01-17 | Matsushita Electric Ind Co Ltd | Television receiver, information acquisition system and method for acquiring information |
| CN101217438A (en) * | 2008-01-02 | 2008-07-09 | 江苏省电力公司 | An electric energy collection hybrid networking communication techniques |
| CN101852659A (en) * | 2010-05-25 | 2010-10-06 | 上海应用技术学院 | Oil derrick stress data acquisition system based on fiber Bragg grating sensor network |
| CN104243209A (en) * | 2014-09-10 | 2014-12-24 | 赛尔网络有限公司 | IP address content provider label coverage statistics method |
-
2015
- 2015-01-19 CN CN201510025361.6A patent/CN104504157B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2003018575A (en) * | 2001-07-03 | 2003-01-17 | Matsushita Electric Ind Co Ltd | Television receiver, information acquisition system and method for acquiring information |
| CN101217438A (en) * | 2008-01-02 | 2008-07-09 | 江苏省电力公司 | An electric energy collection hybrid networking communication techniques |
| CN101852659A (en) * | 2010-05-25 | 2010-10-06 | 上海应用技术学院 | Oil derrick stress data acquisition system based on fiber Bragg grating sensor network |
| CN104243209A (en) * | 2014-09-10 | 2014-12-24 | 赛尔网络有限公司 | IP address content provider label coverage statistics method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104504157A (en) | 2015-04-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111382226B (en) | Database query and retrieval method and device and electronic equipment | |
| CN109582667A (en) | A kind of multiple database mixing storage method and system based on power regulation big data | |
| CN104408159B (en) | A kind of data correlation, loading, querying method and device | |
| CN106709024A (en) | Data table source-tracing method and device based on consanguinity analysis | |
| CN104111996A (en) | Health insurance outpatient clinic big data extraction system and method based on hadoop platform | |
| CN104750825B (en) | A kind of intelligent substation SCD file fast resolving method | |
| CN104123227A (en) | Method for automatically generating testing cases | |
| CN112507499B (en) | GIS-based power distribution network line loss data acquisition method and related device | |
| CN106126528B (en) | A kind of moonlet test basic information generation method based on platform model | |
| CN103177094B (en) | Cleaning method of data of internet of things | |
| CN104599032A (en) | Distributed memory power grid construction method and system for resource management | |
| CN105956410B (en) | A kind of Universal-purpose quick detection method of IEC61850 full models | |
| CN104866580A (en) | Method for quickly detecting impact caused by database modification to current service | |
| CN111159180A (en) | Data processing method and system based on data resource directory construction | |
| CN108833523A (en) | A kind of heat supply wisdom operating system based on Internet of Things | |
| CN106682036A (en) | Data exchange system and exchange method thereof | |
| CN105912601A (en) | Partition storage method for distributed real-time memory database of energy management system | |
| CN105071994B (en) | A kind of mass data monitoring system | |
| CN107798062A (en) | A kind of transformer station's historical data unifies storage method and system | |
| CN100382075C (en) | Hardware-level based test script automatic generating system and method | |
| CN108920607A (en) | Field finds method, apparatus and electronic equipment | |
| CN108921307A (en) | Electric power plant station equipment automatically generates the method and system of visit program target | |
| CN101645073A (en) | Method for guiding prior database file into embedded type database | |
| CN104504157B (en) | A kind of collecting method | |
| CN105335482A (en) | Batch insert method facing mass distributed database |
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 |