NoSE: Schema design for NoSQL applications

Mior, Michael J.; Salem, Kenneth; Aboulnaga, Ashraf; Liu, Rui

doi:10.1109/icde.2016.7498239

Cited by 36 publications

(48 citation statements)

References 21 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…This cloud structure maximizes performance, reliability, and data protection. 42 In addition, when information technology is applied in public administration (e.g. federal, state, or municipal spheres), it is called e-Gov.…”

Section: Cloud Platform Componentmentioning

confidence: 99%

Integrated system architecture for decision-making and urban planning in smart cities

Pires

Mendes

Quiñonez

2019

International Journal of Distributed Sensor Networks

View full text Add to dashboard Cite

Research and development of applications for smart cities are extremely relevant considering the various problems that population growth will bring to large urban centers in the next few years. Although research on cyber-physical systems, cloud computing, embedded devices, sensor and actuator networks, and participatory sensing, among other paradigms, is driving the growth of solutions, there are a lot of challenges that need to be addressed. Based on these observations, in this work, we present an integrated system architecture for decision-making support and urban planning by introducing its building blocks (termed components): sensing/actuation, local processing, communication, cloud platform, and application components. In the sensing/actuation component, we present the major relevant resources for data collection, identification devices, and actuators that can be used in smart city solutions. Sensing/actuation component is followed by the local processing component, which is responsible for processing, decision-making support, and control in local scale. The communication component, as the connection element among all these components, is presented with an emphasis on the open-access metropolitan area network and cellular networks. The cloud platform is the essential component for urban planning and integration with electronic governance legacy systems, and finally, the application component, in which the government administrator and users have access to public management tools, citizen services, and other urban planning resources.

show abstract

Section: Cloud Platform Componentmentioning

confidence: 99%

Integrated system architecture for decision-making and urban planning in smart cities

Pires

Mendes

Quiñonez

2019

International Journal of Distributed Sensor Networks

View full text Add to dashboard Cite

show abstract

“…In [1], a cost-based approach for schema recommendation is proposed with the aim of replacing the rules of thumb currently followed by less competent NoSQL database designers. In this approach, the expected performance of the target application is estimated, upon which a candidate schema is recommended.…”

Section: Related Workmentioning

confidence: 99%

“…, developer autonomy [1], [12] and inadequate modeling guidelines [13], have posed numerous challenges in NoSQL schema best-practice implementation. This has increasingly led to erroneous database modeling and designs [1], [14], [15], [16], [17], which defeats the notion of robustness in NoSQL databases and results in the production of low-performance, non-secure and less-durable systems.…”

mentioning

confidence: 99%

Data Modeling Guidelines for NoSQL Document-Store Databases

Imam¹,

Basri²,

Ahmad³

et al. 2018

ijacsa

View full text Add to dashboard Cite

Good database design is key to high data availability and consistency in traditional databases, and numerous techniques exist to abet designers in modeling schemas appropriately. These schemas are strictly enforced by traditional database engines. However, with the emergence of schema-free databases (NoSQL) coupled with voluminous and highly diversified datasets (big data), such aid becomes even more important as schemas in NoSQL are enforced by application developers, which requires a high level of competence. Precisely, existing modeling techniques and guides used in traditional databases are insufficient for bigdata storage settings. As a synthesis, new modeling guidelines for NoSQL document-store databases are posed. These guidelines cut across both logical and physical stages of database designs. Each is developed based on solid empirical insights, yet they are prepared to be intuitive to developers and practitioners. To realize this goal, we employ an exploratory approach to the investigation of techniques, empirical methods and expert consultations. We analyze how industry experts prioritize requirements and analyze the relationships between datasets on the one hand and error prospects and awareness on the other hand. Few proprietary guidelines were extracted from a heuristic evaluation of 5 NoSQL databases. In this regard, the proposed guidelines have great potential to function as an imperative instrument of knowledge transfer from academia to NoSQL database modeling practices.

show abstract

“…Also, it focuses on column databases only. While in [10], an improved cost-based approach for modeling schema is proposed. The approach first estimate target application performance and recommends a candidate schema.…”

Section: Literature Reviewmentioning

confidence: 99%

“…For these reasons, both industry and academia focused on finding practical solutions to assist NoSQL novice data modelers. Nevertheless, some of the available solutions concentrate on dissimilar NoSQL databases rather than document-model databases [10] despite the wide use of the documentmodel databases (please see "Overview of the NoSQL Databases" section), while others are considered to be vendor specific as reported in [6].…”

Section: Introductionmentioning

confidence: 99%

Automatic schema suggestion model for NoSQL document-stores databases

et al. 2018

View full text Add to dashboard Cite

New generation databases also called NoSQL (Not only SQL) databases are highly scalable, flexible, and low-latent. These types of databases emerge as a result of the rigidity shown by traditional databases to handle today's data which is voluminous, highly diversified and generated at a very high rate. With NoSQL, problems such as database expansion difficulties, low query performance and low storage capacity are addressed. However, the inherent complexity of contemporary datasets coupled with programmers' low NoSQL modeling competence are increasingly making database modeling and design vastly challenging, especially when parameters like consistency, availability and scalability are to be balanced in accordance with system requirements. As such, a schema suggestion model for NoSQL databases is posed to address this balancing issue. The proposed model aims to abstractly suggest schemas at the initial stage of system development based on user defined system requirements and CRUD (Create, Read, Update and Delete) operations among others. This is achieved through the adaptation of exploratory and experimental approaches of research. Also, few mathematical formulas are introduced to calculate clusters availability during entity mappings. A comparison was conducted between the schema produced using the proposed model and the one without. Results obtained shows substantial improvement in the areas of security and read-write query performance.

show abstract

NoSE: Schema design for NoSQL applications

Cited by 36 publications

References 21 publications

Integrated system architecture for decision-making and urban planning in smart cities

Integrated system architecture for decision-making and urban planning in smart cities

Data Modeling Guidelines for NoSQL Document-Store Databases

Automatic schema suggestion model for NoSQL document-stores databases

Contact Info

Product

Resources

About