Comparison of JSON and XML Data Formats in Document Stored NoSql Database Replication Processes

With every passing day, data generation is increasing exponentially, its volume, variety, velocity are making it quite challenging to analyze, interpret, visualize for gaining the greater insights from the available data. Billions of networked sensors are being embedded in devices such as smart phones, automobiles, social media sites, laptop, PC's and industrial machines etc. that operates, generate and communicate data. Thus, the data obtained from various resources exists in structured, semi-structured and unstructured form. The traditional database system is not suitable to handle these data formats. Therefore, new tools and techniques are developed to work with these data. NoSQL is one of them. Currently, many NoSQL database are available in the market, each one of them specially designed to solve specific type of data handling problems, most of the NoSQL databases are developed with special attention to problem of business organizations and enterprises. The chapter focuses various aspects of NoSQL as tool for handling the big data.

Download Full-text

Database Replication of NoSQL Database-as-a-Service

Cloud Data Management ◽

10.1007/978-3-319-04765-2_5 ◽

2014 ◽

pp. 67-80

Author(s):

Liang Zhao ◽

Sherif Sakr ◽

Anna Liu ◽

Athman Bouguettaya

Keyword(s):

Database Replication ◽

Nosql Database ◽

Database As A Service

Download Full-text

CLASSIFICATION COMPLEX QUERY SQL FOR DATA LAKE MANAGEMENT USING MACHINE LEARNING

Journal of Information System and Technology Management ◽

10.35631//jistm.622002 ◽

2021 ◽

Vol 6 (22) ◽

pp. 15-24

Author(s):

Nurhadi Nurhadi ◽

Rabiah Abdul Kadir ◽

Ely Salwana Mat Surin

Keyword(s):

Lake Management ◽

Support Vector ◽

Bayes Classifier ◽

Text Data ◽

Complex Queries ◽

Data Formats ◽

Database Table ◽

Nosql Database ◽

Analytical Processing ◽

Clause Complex

A query is a request for data or information from a database table or a combination of tables. It allows for a more accurate database search. SQL queries are divided into two types, namely, simple queries and complex queries. Complex SQL is the use of SQL queries that go beyond standard SQL by using the SELECT and WHERE commands. Complex SQL queries often involve the use of complex joins and subqueries, where the queries are nested in a WHERE clause. Complex SQL queries can be grouped into two types of queries, namely, Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) queries. In the implementation of complex SQL queries in the NoSQL database, a classification process is needed due to the varying data formats, namely, structured, semi-structured, and unstructured data. The classification process aims to make it easier for the query data to be organized by type of query. The classification method used in this research is the Naive Bayes Classifier (NBC) which is generally often used in text data, and the Support Vector Machine (SVM), which is known to work very well on data with large dimensions. The two methods will be compared to determine the best classification result. The results showed that SVM was 84.61% accurate in terms of classification, and comparatively, NBC was at 76.92%.

Download Full-text

Cloud-based Middleware for Syntactical Interoperability in Internet of Things

Journal of Information Technology and Computer Science ◽

10.25126/jitecs.202051148 ◽

2020 ◽

Vol 5 (1) ◽

pp. 32

Author(s):

Eko Sakti Pramukantoro ◽

Fariz Andri Bakhtiar

Keyword(s):

Internet Of Things ◽

Data Storage ◽

Sensor Nodes ◽

Unstructured Data ◽

Communication Interface ◽

Data Formats ◽

Nosql Database ◽

Interoperability Testing ◽

To Receive ◽

The Internet Of Things

Heterogeneity of protocol communications, data formats, data structure, and hardware specifications on the Internet of things can lead to an Interoperability problem. The solution provides middleware that capable to work in heterogeneity communications, data formats, etc. This paper proposed. A cloud-based middleware that provides a communication interface to receive data from sensor nodes based on Restful and CoAP. Received data then stored in heterogenous IoT data storage based on the NoSQL database. From experiment and testing, interoperability testing methodology was used. The result shows proposed middleware can receive data from both protocols. The received data could store based on structure data or unstructured data on IoT data storage.

Download Full-text