Search results
1 – 10 of 125Cláudio Lima and Ronaldo Santos Mello
NoSQL databases do not require a default schema associated with the data. Even that, they are categorized by data models. A model associated with the data can promote better…
Abstract
Purpose
NoSQL databases do not require a default schema associated with the data. Even that, they are categorized by data models. A model associated with the data can promote better strategies for persistence and manipulation of data in the target database. Based on this motivation, the purpose of this paper is to present an approach for logical design of NoSQL document databases that consists a process that converts a conceptual modeling into efficient logical representations for a NoSQL document database. The authors also evaluate their approach and demonstrate that the generated NoSQL logical structures reduce the amount of data items accessed by queries.
Design/methodology/approach
This paper presents an approach for logical design of NoSQL document database schemas based on a conceptual schema. The authors generate compact and redundancy-free schemas and define appropriate representations in a NoSQL document logical model. The estimated volume of data and workload information can be considered to generate optimized NoSQL document structures.
Findings
This approach was evaluated through a case study with an experimental evaluation in the e-commerce application domain. The results demonstrate that the authors’ workload-based conversion process improves query performance on NoSQL documents by reducing the number of database accesses.
Originality/value
Unlike related work, the reported approach covers all typical conceptual constructs, details a conversion process between conceptual schemas and logical representations for NoSQL document database category and, additionally, considers the estimated database workload to perform optimizations in the logical structure. An experimental evaluation shows that the proposed approach is promising.
Details
Keywords
The paper aims to focus on so‐called NoSQL databases in the context of cloud computing.
Abstract
Purpose
The paper aims to focus on so‐called NoSQL databases in the context of cloud computing.
Design/methodology/approach
Architectures and basic features of these databases are studied, particularly their horizontal scalability and concurrency model, that is mostly weaker than ACID transactions in relational SQL‐like database systems.
Findings
Some characteristics like a data model and querying capabilities of NoSQL databases are discussed in more detail.
Originality/value
The paper shows vary different data models and query possibilities in a common terminology enabling comparison and categorization of NoSQL databases.
Details
Keywords
Sandeep Kumar Singh and Mamata Jenamani
The purpose of this paper is to design a supply chain database schema for Cassandra to store real-time data generated by Radio Frequency IDentification technology in a…
Abstract
Purpose
The purpose of this paper is to design a supply chain database schema for Cassandra to store real-time data generated by Radio Frequency IDentification technology in a traceability system.
Design/methodology/approach
The real-time data generated in such traceability systems are of high frequency and volume, making it difficult to handle by traditional relational database technologies. To overcome this difficulty, a NoSQL database repository based on Casandra is proposed. The efficacy of the proposed schema is compared with two such databases, document-based MongoDB and column family-based Cassandra, which are suitable for storing traceability data.
Findings
The proposed Cassandra-based data repository outperforms the traditional Structured Query Language-based and MongoDB system from the literature in terms of concurrent reading, and works at par with respect to writing and updating of tracing queries.
Originality/value
The proposed schema is able to store the real-time data generated in a supply chain with low latency. To test the performance of the Cassandra-based data repository, a test-bed is designed in the lab and supply chain operations of Indian Public Distribution System are simulated to generate data.
Details
Keywords
Evagelos Varthis, Marios Poulos, Ilias Giarenis and Sozon Papavlasopoulos
This study aims to provide a system capable of static searching on a large number of unstructured texts directly on the Web domain while keeping costs to a minimum. The proposed…
Abstract
Purpose
This study aims to provide a system capable of static searching on a large number of unstructured texts directly on the Web domain while keeping costs to a minimum. The proposed framework is applied to the unstructured texts of Migne’s Patrologia Graeca (PG) collection, setting PG as an implementation example of the method.
Design/methodology/approach
The unstructured texts of PG have automatically transformed to a read-only not only Structured Query Language (NoSQL) database with a structure identical to that of a representational state transfer access point interface. The transformation makes it possible to execute queries and retrieve ranked results based on a specialized application of the extended Boolean model.
Findings
Using a specifically built Web-browser-based search tool, the user can quickly locate ranked relevant fragments of texts with the ability to navigate back and forth. The user can search using the initial part of words and by ignoring the diacritics of the Greek language. The performance of the search system is comparatively examined when different versions of hypertext transfer protocol (Http) are used for various network latencies and different modes of network connections. Queries using Http-2 have by far the best performance, compared to any of Http-1.1 modes.
Originality/value
The system is not limited to the case study of PG and has a generic application in the field of humanities. The expandability of the system in terms of semantic enrichment is feasible by taking into account synonyms and topics if they are available. The system’s main advantage is that it is totally static which implies important features such as simplicity, efficiency, fast response, portability, security and scalability.
Details
Keywords
Ganjar Alfian, Muhammad Fazal Ijaz, Muhammad Syafrudin, M. Alex Syaekhoni, Norma Latif Fitriyani and Jongtae Rhee
The purpose of this paper is to propose customer behavior analysis based on real-time data processing and association rule for digital signage-based online store (DSOS). The…
Abstract
Purpose
The purpose of this paper is to propose customer behavior analysis based on real-time data processing and association rule for digital signage-based online store (DSOS). The real-time data processing based on big data technology (such as NoSQL MongoDB and Apache Kafka) is utilized to handle the vast amount of customer behavior data.
Design/methodology/approach
In order to extract customer behavior patterns, customers’ browsing history and transactional data from digital signage (DS) could be used as the input for decision making. First, the authors developed a DSOS and installed it in different locations, so that customers could have the experience of browsing and buying a product. Second, the real-time data processing system gathered customers’ browsing history and transaction data as it occurred. In addition, the authors utilized the association rule to extract useful information from customer behavior, so it may be used by the managers to efficiently enhance the service quality.
Findings
First, as the number of customers and DS increases, the proposed system was capable of processing a gigantic amount of input data conveniently. Second, the data set showed that as the number of visit and shopping duration increases, the chance of products being purchased also increased. Third, by combining purchasing and browsing data from customers, the association rules from the frequent transaction pattern were achieved. Thus, the products will have a high possibility to be purchased if they are used as recommendations.
Research limitations/implications
This research empirically supports the theory of association rule that frequent patterns, correlations or causal relationship found in various kinds of databases. The scope of the present study is limited to DSOS, although the findings can be interpreted and generalized in a global business scenario.
Practical implications
The proposed system is expected to help management in taking decisions such as improving the layout of the DS and providing better product suggestions to the customer.
Social implications
The proposed system may be utilized to promote green products to the customer, having a positive impact on sustainability.
Originality/value
The key novelty of the present study lies in system development based on big data technology to handle the enormous amounts of data as well as analyzing the customer behavior in real time in the DSOS. The real-time data processing based on big data technology (such as NoSQL MongoDB and Apache Kafka) is used to handle the vast amount of customer behavior data. In addition, the present study proposed association rule to extract useful information from customer behavior. These results can be used for promotion as well as relevant product recommendations to DSOS customers. Besides in today’s changing retail environment, analyzing the customer behavior in real time in DSOS helps to attract and retain customers more efficiently and effectively, and retailers can get a competitive advantage over their competitors.
Details
Keywords
Nathalia Rose Silva da Purificação, Vinícius Barbosa Henrique, Amilton Amorim, Andrea Carneiro and Guilherme Henrique Barros de Souza
The purpose of the study is to compare methodologies for mapping a historic building, with image capture by smartphones and drones, using photogrammetric techniques for…
Abstract
Purpose
The purpose of the study is to compare methodologies for mapping a historic building, with image capture by smartphones and drones, using photogrammetric techniques for three-dimensional (3D) modeling of the structure. Processes and products are also analyzed, as well as possibilities for storing and visualizing data for structuring a cadastre of historical and artistic heritage are studied.
Design/methodology/approach
For mapping with smartphones, the overlapping of photographs was guaranteed, with data acquisition using three different cameras, on the same date as the aerial survey. The models were made from different combinations of camera use. For storage, a conceptual model based on ISO 19.152:2012 is proposed, which was implemented in the MongoDB, resulting in a database for storage. The visualization was carried out on the Cesium ion platform.
Findings
The results indicate that the terrestrial 3D reconstruction using smartphones is an efficient alternative to the historical and artistic cadastre, presenting texture quality superior to the aerial survey in a shorter production time. When dealing with the conceptual model, the LADM (Land Administration Domain Model) standardization guarantees interoperability and facilitates data exchange. In addition, it proved to be flexible for the creation of thematic profiles, supporting their effective storage. The insertion of data in the visualization platform was simple and effective, and it even generated sharing links for visualization of the models.
Originality/value
The study analyses a low-cost method with the use of easily accessible devices, with a combination of methodologies and applied techniques. The data storage and visualization method is also simple and flexible, suitable for application in the cadastre of historical heritage.
Details
Keywords
Sonya Rapinta Manalu, Jurike Moniaga, Dionisius Andrian Hadipurnawan and Firda Sahidi
Low-cost microcomputers such as the Raspberry Pi are common in library makerspaces. This paper aims to create an OBD-II technology to diagnose a vehicle’s condition.
Abstract
Purpose
Low-cost microcomputers such as the Raspberry Pi are common in library makerspaces. This paper aims to create an OBD-II technology to diagnose a vehicle’s condition.
Design/methodology/approach
An OBD-II scanner plugged into the OBD-II port or usually called the data link connector (DLC), sends diagnostics to the Raspberry Pi.
Findings
Compared with other microcontrollers such as Arduino, the Raspberry Pi was chosen because it sustains the application to receive real-time diagnostics, process the diagnostics and send commands to automobiles at the same time, rather than Arduino that must wait for another process finished to run another process.
Originality/value
This paper also represents the history of mobile technology and OBD-II technology, comparison between Arduino and Raspberry Pi and Node.
Details
Keywords
Aya Khaled Youssef Sayed Mohamed, Dagmar Auer, Daniel Hofer and Josef Küng
Data protection requirements heavily increased due to the rising awareness of data security, legal requirements and technological developments. Today, NoSQL databases are…
Abstract
Purpose
Data protection requirements heavily increased due to the rising awareness of data security, legal requirements and technological developments. Today, NoSQL databases are increasingly used in security-critical domains. Current survey works on databases and data security only consider authorization and access control in a very general way and do not regard most of today’s sophisticated requirements. Accordingly, the purpose of this paper is to discuss authorization and access control for relational and NoSQL database models in detail with respect to requirements and current state of the art.
Design/methodology/approach
This paper follows a systematic literature review approach to study authorization and access control for different database models. Starting with a research on survey works on authorization and access control in databases, the study continues with the identification and definition of advanced authorization and access control requirements, which are generally applicable to any database model. This paper then discusses and compares current database models based on these requirements.
Findings
As no survey works consider requirements for authorization and access control in different database models so far, the authors define their requirements. Furthermore, the authors discuss the current state of the art for the relational, key-value, column-oriented, document-based and graph database models in comparison to the defined requirements.
Originality/value
This paper focuses on authorization and access control for various database models, not concrete products. This paper identifies today’s sophisticated – yet general – requirements from the literature and compares them with research results and access control features of current products for the relational and NoSQL database models.
Details
Keywords
Anastasija Nikiforova, Artjoms Daskevics and Otmane Azeroual
Nowadays, there are billions interconnected devices forming Cyber-Physical Systems (CPS), Internet of Things (IoT) and Industrial Internet of Things (IIoT) ecosystems. With an…
Abstract
Nowadays, there are billions interconnected devices forming Cyber-Physical Systems (CPS), Internet of Things (IoT) and Industrial Internet of Things (IIoT) ecosystems. With an increasing number of devices and systems in use, amount and the value of data, the risks of security breaches increase. One of these risks is posed by open data sources, which are databases that are not properly protected. These poorly protected databases are accessible to external actors, which poses a serious risk to the data holder and the results of data-related activities such as analysis, forecasting, monitoring, decision-making, policy development, and the whole contemporary society. This chapter aims at examining the state of the security of open data databases representing both relational databases and NoSQL, with a particular focus on a later category.
Details
Keywords
Milorad Pantelija Stevic, Branko Milosavljevic and Branko Rade Perisic
Current e-learning platforms are based on relational database management systems (RDBMS) and are well suited for handling structured data. However, it is expected from e-learning…
Abstract
Purpose
Current e-learning platforms are based on relational database management systems (RDBMS) and are well suited for handling structured data. However, it is expected from e-learning solutions to efficiently handle unstructured data as well. The purpose of this paper is to show an alternative to current solutions for unstructured data management.
Design/methodology/approach
Current repository-based solution for file management was compared to MongoDB architecture according to their functionalities and characteristics. This included several categories: data integrity, hardware acquisition, processing files, availability, handling concurrent users, partition tolerance, disaster recovery, backup policies and scalability.
Findings
This paper shows that it is possible to improve e-learning platform capabilities by implementing a hybrid database architecture that incorporates RDBMS for handling structured data and MongoDB database system for handling unstructured data.
Research limitations/implications
The study shows an acceptable adoption of MongoDB inside a service-oriented architecture (SOA) for enhancing e-learning solutions.
Practical implications
This research enables an efficient file handling not only for e-learning systems, but also for any system where file handling is needed.
Originality/value
It is expected that future single/joint e-learning initiatives will need to manage huge amount of files and they will require effective file handling solution. The new architecture solution for file handling is offered in this paper: it is different from current solutions because it is less expensive, more efficient, more flexible and requires less administrative and development effort for building and maintaining.
Details