CN109271389A - A kind of Internet of Things storage model based on modified NoSQL technology - Google Patents
A kind of Internet of Things storage model based on modified NoSQL technology Download PDFInfo
- Publication number
- CN109271389A CN109271389A CN201811152338.3A CN201811152338A CN109271389A CN 109271389 A CN109271389 A CN 109271389A CN 201811152338 A CN201811152338 A CN 201811152338A CN 109271389 A CN109271389 A CN 109271389A
- Authority
- CN
- China
- Prior art keywords
- record
- unit
- data
- storage
- internet
- 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
Abstract
The present invention provides a kind of Internet of Things storage models based on modified NoSQL technology, comprising: several basis storage unit Record, each basis storage unit Record are used to one record of storage；Each basis storage unit Record includes: tag unit rID, static cell sID, conceptual model unit ClassID, dynamic cell InstID, physical location unit Location and time quantum Recordtime；Tag unit rID is used to store the mark of mark current record；Static cell sID is for storing data constant in current record；Conceptual model unit ClassID is used to store the conceptual model of this record；Dynamic cell InstID is for storing the data changed in current record；The physical location of equipment when physical location unit Location is used to store this current record acquisition.Internet of Things storage model based on modified NoSQL technology solve the problems, such as in the prior art not by NoSQL technology and ontology in conjunction with mode and lead to not the isomerism for meeting internet of things data storage.
Description
Technical field
The present invention relates to field of data storage, and in particular to a kind of Internet of Things storage mould based on modified NoSQL technology
Type.
Background technique
Internet of Things industry has extraordinary appreciation prospect, and not only own has obtained development energetically, automatic technology,
Other also achieve rapid progress in relation to field for sensor control, video monitoring, mass data storage etc., produce preceding institute not
Some clusters develop phenomenon.With the further development of technology of Internet of things, ever-increasing data, traditional storage rack are faced
Structure is since scalability is poor, and if things go on like this, storage environment will become increasingly complicated, and cause excessively high energy consumption.
The purpose of ontology be so that the information and application of different developing instrument and application platform can communicate, share and
It reuses, overcomes knowledge system new in the past that cannot effectively utilize the defect of existing knowledge system, it is not necessary to start to redesign, from
And save a large amount of human and material resources and financial resource.NoSQL technology and ontology have certain similitude, can manage two kinds
Thought combines, and meets the data storage requirement of Internet of Things.
Constantly expand to solve data scale under big data era, data type is more and more abundant, data management demand
Higher and higher, the concept of NoSQL was suggested in 2009, and was rapidly developed.NoSQL is non-relational number
According to the generalized definition of storage, NoSQL database is different from traditional relevant database, both none unified framework,
There is no specific range and definition, does not need predefined data mode or table structure as traditional Relational DataBase.
NoSQL gets rid of the stringent ACID theory constraint of relevant database.Most of NoSQL database is the ring of cluster
Border design, has good resilient expansion mechanism, has higher efficiency when in face of high concurrent request, thus is gradually used
In many web Internet applications.
NoSQL technology and ontology are not combined in the prior art, while not being able to satisfy internet of things data storage
Isomerism.
Summary of the invention
The present invention will provide a kind of Internet of Things storage model based on modified NoSQL technology, and solution does not have in the prior art
Have by NoSQL technology and ontology in conjunction with mode and lead to not the problem of meeting the isomerism of internet of things data storage.
To achieve the above object, present invention employs the following technical solutions:
A kind of Internet of Things storage model based on modified NoSQL technology, comprising: several basis storage unit Record, it is each
Basic storage unit Record is used to one entity record of storage；
Each basis storage unit Record include: tag unit rID, static cell sID, conceptual model unit ClassID,
Dynamic cell InstID, physical location unit Location and time quantum Recordtime；Tag unit rID is for storing
Identify the mark of current record；Static cell sID is for storing data constant in current record；Conceptual model unit
ClassID is used to store the Ontological concept model of this record；Dynamic cell InstID is used to store to change in current record
Data；The physical location of equipment when physical location unit Location is used to store this current record acquisition；Time quantum
Recordtime is used to store time when this current record occurs.
Compared with the prior art, the invention has the following beneficial effects:
By the way that Ontological concept model unit ClassID is arranged, the storage to the ontology of record is realized, which is stored with to reach
Correlation between theme (namely having which equipment), theme and theme has which data fundamental type, each theme
With which attribute, the attribute having be static attribute or dynamic attribute and the attribute having is with the basic class of what data
Type expression, to facilitate subsequent these data of lookup, meet the isomerism of internet of things data storage, reaches internet of things data storage
Purpose, while also facilitating subsequent lookup data.
Further advantage, target and feature of the invention will be partially reflected by the following instructions, and part will also be by this
The research and practice of invention and be understood by the person skilled in the art.
Detailed description of the invention
Fig. 1 is the calculator room equipment data storage mould formed using the Internet of Things storage model based on modified NoSQL technology
Type；
Fig. 2 is to be changed in traditional oracle database lookup time and the present invention to be based on modified NoSQL skill according to quantity item number
The Internet of Things storage model of art searches the experimental result picture of time.
Specific embodiment
In order to make the present invention realize technological means, creation characteristic, reach purpose and effect more clearly and be apparent to,
The present invention is further elaborated with reference to the accompanying drawings and detailed description:
The invention proposes a kind of Internet of Things storage models based on modified NoSQL technology, comprising: several basis storage units
Record, each basis storage unit Record are used to one entity record of storage；
Each basis storage unit Record include: tag unit rID, static cell sID, conceptual model unit ClassID,
Dynamic cell InstID, physical location unit Location and time quantum Recordtime；Tag unit rID is for storing
Identify the mark of current record；Static cell sID is for storing data constant in current record；Conceptual model unit
ClassID is used to store the Ontological concept model of this record；Dynamic cell InstID is used to store to change in current record
Data；The physical location of equipment when physical location unit Location is used to store this current record acquisition；Time quantum
Recordtime is used to store time when this current record occurs.
Preferably, conceptual model unit ClassID includes:
Class unit, for storing the mark of theme and the title of theme；
Associative cell, for storing the relationship between theme and theme；
Scope template(-let), for storing data title of the mark of fundamental type and data fundamental type；
Domain generic attribute unit is that static attribute or dynamic belong to for storing each theme with which attribute, the attribute having
Property and the attribute that has expressed with what data fundamental type.
Preferably, it is SampleElement key assignments that all basis storage unit Record, which are all made of data store organisation,
To structure.
It is illustrated below with the Internet of Things storage model of monitoring system, the monitored object of monitoring system is mainly that computer room is dynamic
The equipment such as power and environmental unit, such as controller switching equipment, air-conditioning equipment, temperature and humidity detection equipment, smog alarm detection device etc., respectively
The relevant information of a equipment is as follows:
1. the attribute of controller switching equipment has: equipment state, equipment basic designation, device type, voltage class, device subclass, it is active,
The parameters such as idle, frequency, power factor and the state of panel switches etc..
2. the attribute of air-conditioning equipment has: equipment state, affiliated producer, device type, device subclass, voltage class, equipment
Title etc..
3. the attribute of temperature and humidity detection equipment has: device name, factory businessman, device type, device subclass, voltage etc.
Grade etc..
The attribute of smog alarm detection device has: device name, factory businessman, device type, smokescope, alarm,
Switch state, device subclass, voltage class etc..
Such as configuration information, name information, organizational information etc., are all artificial for management calculator room equipment in device attribute
Setting information, and data that device attribute is just no variation in, therefore device attribute should store static cell sID
In.
Meanwhile above equipment is there is also a large amount of real-time dynamic informations, for reflecting the variation of environment, for example equipment is active
Power, reactive power, become the real-time voltage of electric switch, the smokescope etc. of monitoring device measurement, these information are all dynamics
Information, therefore multidate information should store in dynamic cell InstID.
The first, the foundation of conceptual model unit ClassID is as follows:
S11, class unit: as shown in table 1 below, in table: ID column indicate that the mark of theme, Name indicate the title of concept theme, table 1
Mean that the data of class unit storage:
Table 1
S12, associative cell: the relationship of current record and class table is stored, in associative cell to indicate in current record with organic
The mutual relationships such as room, controller switching equipment, air-conditioning equipment, temperature and humidity detection equipment, smog alarm detection device, as shown in table 2, table
In in first record computer room concept include controller switching equipment concept, cID1 and cID2 are one in cID column in table 1；
Table 2
S13, scope template(-let): it is floating that integer (Int), single precision floating datum (Float), double precision are described in scope attribute list
Points (Double), character string (String) etc. data fundamental type, as shown in table 3.
Table 3
S14, domain generic attribute unit: it is static attribute with which attribute, the attribute having or moves for storing each theme
State attribute and the attribute having are expressed with what data fundamental type, as shown in table 4, first record in table 4 (2,
4, ' equipment state ', ' quiet ' ...) be associated with controller switching equipment concept with scope attribute String, and name attribute-name equipment shape
State, " quiet " indicating that this attribute is static attribute, value is stored in the static part of instance data, other and so on；
Table 4
After conceptual model unit ClassID is expressed clearly in Internet of Things storage model based on modified NoSQL technology, computer room is set
Standby Data Storage Models are as shown in Fig. 1 in Figure of description:
As shown in Figure 1, system has included a plurality of Record record, for first, the ID of first Record is that 1, sID refers to
To the static part of instance data, SID 1, the static data that the ID being directed toward in instance data is 1, it is general that ClassID is directed toward ontology
The ID of device concept in model is read, ClassID is that the equipment of this record known to 2 is that controller switching equipment (can also be searched by 2
Arrive, controller switching equipment belongs to computer room, controller switching equipment tool there are four attribute " equipment state ", " voltage class ", " active power " and
" reactive power ", " equipment state " and " voltage class " belong to static attribute and indicate " have with string data fundamental type
Function power " and " reactive power " belong to dynamic attribute and are indicated with float data fundamental type), InstID is directed toward instance number
According to dynamic part, InstID 1 is directed toward the dynamic data that ID is 1 in instance data, and Location 7 shows that equipment is in
The position that number is 7 in computer room, RecordTime is the 12:20 ' of ' 2018/9/10, shows the data generation time.Instance data
It is 1 that (static part) first record data length, which is 10, tID type, thereafter equipment state: ' enable ' with
The storage of SampleElement structure, shows that equipment is in initiate mode.Similarly, instance data (dynamic part) first note
Data length 20 is recorded, active power: 100, reactive power: 20, active power is also recorded with SampleElement structure
And reactive power, value are respectively 100,20.Other records and so on.
The second, the database storage model of the application storage model and the prior art is compared
Firstly, prior art database storage model establishment step is as follows:
In the prior art according to the characteristics of relational database and model needs, for equipment active power, the relationship of reactive power
Database purchase mode is as shown in table 5 below:
Table 5
Wherein Ouur_time show record time, Cur_01, Cur_02 ..., Cur_99, Cur_100 record active power
And reactive power, physical record be which equipment active power and reactive power；
Then, the active power and reactive power which equipment table expression is are established, as shown in table 6 below:
Table 6
In upper figure, Cur_01 Cur_02 express the active power and reactive power of equipment 1 respectively, Cur_03 Cur_04 distinguish table
Up to the active power and reactive power of equipment 2, and so on.
Finally, comparative analysis obtains following result:
1) according to the above design, storage dynamic real time data table at most can recorde 50 equipment active power and idle function
Rate, when equipment is less than 50 equipment, it may appear that the waste of memory space；When equipment is greater than 50 equipment, need to build again
Table, and the relationship between Maintenance Table, increase management and complexity, meanwhile, also increase computation burden；
2) storage model proposed by the present invention is used, problem above can be improved, so that storage model is more preferably suitable
Answer the data characteristics of Internet of Things and the needs of Internet of Things application.Main reason is that relational database design itself is for real
The data processing of business type, in relational model, once database model building is completed, and after generating database instance, data pair
As the relationship between, data object (database table) is also just fixed, during database instance operation, table record quantity is only existed
Variation, relationship quantity is determined between object variation, table unit content " value " variation, and the type structure of data, type pass
The characteristics of system is fixed, and Internet of Things mass data type isomery multiplicity, dynamic change are unable to satisfy.NoSQL is non-relational data
The generalized definition of storage, NoSQL database are different from traditional relevant database, and both none unified framework, did not had yet
There are specific range and definition, does not need predefined data mode or table structure as traditional Relational DataBase.NoSQL
Get rid of the stringent ACID theory constraint of relevant database.Most of NoSQL database is the Environment Design of cluster,
It with good resilient expansion mechanism, is had higher efficiency when in face of high concurrent request, thus is gradually applied to many
In web Internet application.
Third compares the effect of the storage effect of oracle database and the application database
Identical data conventionally are stored with storage model proposed by the present invention using oracle database respectively, into
Row comparative analysis.Compare the time of the average lookup of single record data in the case where different scales data.Experimental result is such as
Shown in Fig. 2, Oracle indicates that oracle database, tDB indicate that the application is deposited based on the Internet of Things of modified NoSQL technology in figure
Model is stored up, following result be can analyze out by Fig. 2:
Horizontal coordinate is the data volume size of experiment, and vertical direction represents multiple single record queries average time, blue lines
It is the experimental result of Oracle, red lines are the experimental results of this model.With the increase of data volume, required for two inquiries
Average time gradually increases, while slope is gradually increased, and illustrates that the time consumed by system increased.From the comparison of two lines
From the point of view of, when data scale is smaller, the time of oracle database is better than this model data, but with the increase of data volume, originally
The advantage of model gradually embodies, and illustrates the storage model database based on NoSQL technology and ontology in reply Internet of Things
The changeable data storage aspect of net magnanimity isomery is advantageous.
Finally, it is stated that the above examples are only used to illustrate the technical scheme of the present invention and are not limiting, although referring to compared with
Good embodiment describes the invention in detail, those skilled in the art should understand that, it can be to skill of the invention
Art scheme is modified or replaced equivalently, and without departing from the objective and range of technical solution of the present invention, should all be covered at this
In the scope of the claims of invention.
Claims (3)
1. a kind of Internet of Things storage model based on modified NoSQL technology characterized by comprising several basis storages are single
First Record, each basis storage unit Record are used to one entity record of storage；
Each basis storage unit Record include: tag unit rID, static cell sID, conceptual model unit ClassID,
Dynamic cell InstID, physical location unit Location and time quantum Recordtime；Tag unit rID is for storing
Identify the mark of current record；Static cell sID is for storing data constant in current record；Conceptual model unit
ClassID is used to store the Ontological concept model of this record；Dynamic cell InstID is used to store to change in current record
Data；The physical location of equipment when physical location unit Location is used to store this current record acquisition；Time quantum
Recordtime is used to store time when this current record occurs.
2. a kind of Internet of Things storage model based on modified NoSQL technology according to claim 1, which is characterized in that
Ontological concept model unit ClassID includes:
Class unit, for storing the mark of theme and the title of theme；
Associative cell, for storing the relationship between theme and theme；
Scope template(-let), for storing data title of the mark of fundamental type and data fundamental type；
Domain generic attribute unit is that static attribute or dynamic belong to for storing each theme with which attribute, the attribute having
Property and the attribute that has expressed with what data fundamental type.
3. a kind of Internet of Things storage model based on modified NoSQL technology according to claim 1, which is characterized in that
It is SampleElement key-value pair structure that all basis storage unit Record, which are all made of data store organisation,.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811152338.3A CN109271389A (en) | 2018-09-29 | 2018-09-29 | A kind of Internet of Things storage model based on modified NoSQL technology |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811152338.3A CN109271389A (en) | 2018-09-29 | 2018-09-29 | A kind of Internet of Things storage model based on modified NoSQL technology |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109271389A true CN109271389A (en) | 2019-01-25 |
Family
ID=65196097
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811152338.3A Pending CN109271389A (en) | 2018-09-29 | 2018-09-29 | A kind of Internet of Things storage model based on modified NoSQL technology |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109271389A (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103023970A (en) * | 2012-11-15 | 2013-04-03 | 中国科学院计算机网络信息中心 | Method and system for storing mass data of Internet of Things (IoT) |
| CN107016056A (en) * | 2017-03-07 | 2017-08-04 | 西安电子科技大学 | The distributed memory system and method for magnanimity heterogeneous sensor data in a kind of Internet of Things |
| CN108510118A (en) * | 2018-04-02 | 2018-09-07 | 张龙 | A kind of building heating energy forecast analysis terminal based on Internet of Things |
-
2018
- 2018-09-29 CN CN201811152338.3A patent/CN109271389A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103023970A (en) * | 2012-11-15 | 2013-04-03 | 中国科学院计算机网络信息中心 | Method and system for storing mass data of Internet of Things (IoT) |
| CN107016056A (en) * | 2017-03-07 | 2017-08-04 | 西安电子科技大学 | The distributed memory system and method for magnanimity heterogeneous sensor data in a kind of Internet of Things |
| CN108510118A (en) * | 2018-04-02 | 2018-09-07 | 张龙 | A kind of building heating energy forecast analysis terminal based on Internet of Things |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Wang et al. | Tracking the evolution processes of smart cities in China by assessing performance and efficiency | |
| Yang et al. | Tag tagging: Towards more descriptive keywords of image content | |
| CN108595664A (en) | A kind of agricultural data monitoring method under hadoop environment | |
| Yang et al. | MapReduce based method for big data semantic clustering | |
| CN111130842A (en) | Dynamic network map database construction method reflecting network multidimensional resources | |
| CN109271389A (en) | A kind of Internet of Things storage model based on modified NoSQL technology | |
| Zhao et al. | Toward efficient and flexible metadata indexing of big data systems | |
| Suri et al. | A comparative study between the performance of relational & object oriented database in Data Warehousing | |
| CN111414355A (en) | Offshore wind farm data monitoring and storing system, method and device | |
| CN109815303A (en) | A kind of location-based mobile data storage system | |
| CN110309354A (en) | A kind of instructional video segment transaction system of knowledge based point | |
| Gao et al. | Construction and Optimization of Co-occurrence-attribute-interaction Model for Column Semantic Recognition | |
| Liang et al. | Research on distributed storage of big data based on hbase remote sensing image | |
| Zhou et al. | Spatial Data Dynamic Balancing Distribution Method Based on the Minimum Spatial Proximity for Parallel Spatial Database. | |
| Atwa et al. | Clustering evolving data stream with affinity propagation algorithm | |
| CN102968666A (en) | Storage definition method for electric power system data holographic complete time domain management | |
| Li et al. | Real-Time Controllable Optimization Algorithm for Correlated Big Data in Cloud Computing Environment | |
| Zou | Construction of Intelligent Sign Language Corpus of Tourist Attractions under the Background of Big Data Information Retrieval | |
| Guo | Analysis and Research on Big Data Query Technology Based on NOSQL Database | |
| CN106327405A (en) | Intelligent city management system based on cloud platform | |
| Zhou et al. | Real-Time Electricity Pricing Trend Forecasting Based on Multi-density Clustering and Sequence Pattern Mining | |
| Gao et al. | Memory augmented variational auto-encoder for anomaly detection | |
| CN118051798A (en) | Data center management method, device, equipment and storage medium | |
| Wang | Network analytics er model–towards a conceptual view of network analytics | |
| Yin et al. | Integration of BIM and Data Optimization Technology Into the Online Guiding of Engineering Management in Colleges |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190125 |