REQUIREMENTS OF DATABASES IN DIFFERENT IoT APPLICATIONS
Shona M
Assistant professor,Department of CSE,SVCE,Bangalore,India ,sonasuresh04@gmail.com
Abstract-In the recent years, the Internet of Things (IoT) is considered as a part of the Internet of future and makes it possible for connecting various smart objects together through the Internet.The use of IoT technology in applications has spurred the increase of real-time data, which makes the information storage and accessing more difficult and challenging.Different applcations of IoT requires different types of databases.This paper discusses the different databases used for different IoT applications.
Keywords-NoSQL, Hadoop, Time Series Daemon, (TSD), MemSQL
…show more content…
There are pros and cons to each.
Relational Database
The relational model organizes data into multiple tables and assigns a value to attributes in each row and column, with a unique key for each row. Other tables can use these keys to access the data without reorganizing the table.
• The pros: Relational databases are simple, structured and ¬flexible. They’re often used when processing speed is not a factor. They use Structured Query Language (SQL), a commonly understood process for manipulating data. Relational databases are often used in industries such as banking and financial services; because the data is not divisible, data integrity is preserved.
• The cons: Relational databases can be slow. If there are many tables utilizing relationships, the responsiveness of data queries can be delayed. In addition, relational databases scale up well, but do not scale out well, making storage expensive.
Non-Relational Database (
…show more content…
Unlike relational databases, NoSQL databases are not set up to have tables with linked relationships. There are several types of NoSQL databases, each with slightly different attributes defining how the information is stored and displayed to the user.
The pros: NoSQL databases are generally more scalable than relational ones and performance is generally not an issue. They are designed to expand transparently and horizontally using low-cost hardware.
The cons: NoSQL databases generally cannot handle the analytic processing of the data or joins, which are common requirements for IoT applications. They employ low-level query languages, and do not accommodate transactions where data integrity needs to be preserved (such as in the banking example above).
The reality is, the IoT requires characteristics of both relational [6] and NoSQL databases; the flexibility of NoSQL, which allows different types of data to be stored, and the agility to adapt the underlying data models to specific business requirements and applications, and the data integrity aspects of the relational
It is a database which shows the links and relationships between two sets of data/stored information in a document or mainly entities. This means e.g. if a computer system has to store a lot of data/information about people instead of repeating the same row of information which may include personal or unnecessary things, you will then be able to click on the main primary key data which then leads to the actual personal things. This is the relationship between the primary key and foreign key. Ians & Co will benefit with a relational database as it has many links to primary and secondary data. Ians & Co being a large company will have a lot of data which means it will be harder to maintain with a simple and old database.
A relational database is a database that consists of a collection of tables with columns showing entities, and rows showing data. This type of database uses a primary key and foreign key. The foreign key in another table will point to the primary key of a table, and this is how tables can relate to each other. This permits for one-to-one, one-to-many, and many-to-many relationship between the data. An advantage of relational databases includes the ease of adding or modifying new tables and entities without needing to change the structure of the database already in place. Relational database have many features, including indexing, setting data type, and setting validation tests, all these help to ensure data integrity.
Database model defines the logical structure of the database by determining manner in which the data will be stored. Relational model is one of the most popular database models, which defines tables and relationships between the tables.
General a database has a lot of tables and some tables are related to each other so relationship is use to make the connection between two or more tables. It is a method to avoid excessive data and to ensure the data integrity. There have three types of relationships:
The tables in relational databases organize data in rows and columns, simplifying data access and manipulation. It is easier for manager to understand the relational model than put all data in one table. Besides, a relational database allows tables to be linked. And the linkage reduces data redundancy and allows data to be organized more logically. In a word, relational database is easier to control, more flexible, and more intuitive than approaches.
I am utilizing the Relational Database in my proposal. According to Murthy, data in a relational database, is mainly represented in tables and is considered to be an assortment of relations. A relational database is similar to a spreadsheet, in that a relational database organizes data in tables. The table is then made up of rows and columns. A row is also known as a record or tuple, and a column is also known as called a field or attribute. Using a relational database allows me to efficiently store huge amount of data, and effectively retrieve selected data. Tables in the relational database are distinguished by a primary key, which confirms that “no
A relational database is designed to comply with a term called normalization. Normalization is a process of organizing tables to minimize the redundancy in the database. The design of a relational database decreases the amount of space the database uses in a system. The relational database uses fields to help reduce redundancy in the tables. Relational designed database use the relational value in fields, an example would be a field for Book_ISBN and a field with Title_ISBN, could be limited to just one field naming the ISBN (Safari).
The main feature of a relation database would be the primary key. It is a unique identifier set to each and every record which moves across different tables in relationships. A good example of a primary key is a Social Security number. The primary keys job is to make each record unique and lets data to be kept in more than one table. Each table within a relational database will have to have a field for the primary key.
Firstly a relational database contains a set of tables which basically are linked collectively by the relationships between the tables. Also it is also known as reason such as a database is called relational database.
The relational database provides a number of advantages over previous models, such as the following.
Other than the factors mentioned so far, below listed are a few more advantages of SQL for a business:
NoSQL was created to remedy the architecture of relational databases, to make the schema more dynamic and ever expanding. With the emergence of cloud computing, unstructured data such as social media posts in need of storage, and Agile development practice, The Document
Many of the IoT applications will include monitoring devices reporting on different aspects of the system being monitored. For instance, many buildings and offices include occupancy, and temperature sensors. Vehicles could be equipped with monitoring devices reporting on locations, fuel consumption, etc. However, current IoT applications are domain specific, with no wider vision for reusing the data generated by devices in other applications or sharing them with other users in other domains. The Internet of Things is lacking a well-defined architecture that could help create a competitive marketplace of applications and solutions without locking any users into using a monolithic stack from a single solution provider.
The modern RDBMS advancements are not capable of supporting unstructured information with ideal space necessity. The plan winds up plainly mind-boggling and is henceforth troublesome for designers. The requirement for unstructured information administration is so annoying with conventional RDBMS arrangements (Big data in financial services industry: Market trends, challenges, and prospects 2013 - 2018). Moreover, RDBMS turns out to be an exorbitant answer for creating light-footed web applications with direct information investigation necessities. NoSQL is developing as a proficient possibility in this situation, which connects the issues related with RDBMS innovation. The market development can credit to creative dispatches of NoSQL arrangements, and collective endeavors by NoSQL sellers and clients. The endeavors of organizations, to enhance their market offerings, are creating the request of NoSQL, as a back-end bolster (Big data in financial services industry: Market trends, challenges, and prospects 2013 - 2018). The emergence of agile software development is creating the demand for NoSQL (Big data in financial services industry: Market trends, challenges, and prospects 2013 - 2018). They offer users much more avenues to accept data in many different forms. NoSQL is adaptable as SQL but offers many more uses that can apply to many organizations.