Leveraging Data Analytics by Transforming Relational Database Schema in to Big Data
Journal Title: Trends in Computer Science and Information Technology - Year 2016, Vol 1, Issue 1
Abstract
The growth of data and its efficient handling is becoming more popular trend in recent years bringing new challenges to explore new avenues. Data analytics can be done more efficiently with the availability of distributed architecture of “Not Only SQL” NoSQL databases. Technological advancements around us are changing very rapidly and major shift is being carried out, a shift from relational to non-relational world. More precisely we are talking about the shift from traditional relational database models to non-relational database models. When moving from relational to non-relational models, database administrators face common issues due to the fact that NoSQL is a No-Schema database. Logical mapping of the schema from relational to non-relational models is complex and it is not a standard process. The purpose of conducting this research is to propose a mechanism by which the schema of a relational database management system and its data can be transformed into big data by following a set of standardize rules. This model can be very useful for relational database administrators by enabling them to focus on logical modeling instead of procedural writing for every SQL to NoSQL transition. In this paper, we studied both models and focus our research to present a set of rules and framework that can be used to apply transformation operation in a seamlessly manageable way.
Authors and Affiliations
Ahmad Mukhtar, Siddiqui Zeeshan
Keywords
Related Articles
- EP ID EP543529
- DOI 10.17352/tcsit.000002
- Views 90
- Downloads 0
Classification by Artificial Neural Network according to the values affecting Electricity Generation
Predicting the amount of electricity produced in a power plant is very important for today’s economy. Oven Power (MW), Boiler Input Gas Temperature, Superheated Steam Amount, ID-Fan Speed, Feeding Water Tank data affect...
Leveraging Data Analytics by Transforming Relational Database Schema in to Big Data
The growth of data and its efficient handling is becoming more popular trend in recent years bringing new challenges to explore new avenues. Data analytics can be done more efficiently with the availability of distribute...
Video-based assessment of practical operative skills for Undergraduate dental students
Introduction: The aim of this study is to evaluate, within the scope of an experimental design, to what extent the assessment of two different settings of prepared cavities, based on video sequences, containing digital a...
Shrinkage Parameters for Each Explanatory Variable Found Via Particle Swarm Optimization in Ridge Regression
Ridge regression method is an improved method when the assumptions of independence of the explanatory variables cannot be achieved, which is also called multicollinearity problem, in regression analysis. One of the way t...
Squaring the Circle Using Modified Tartaglia Method
The paper presents a modified Tartaglia method. Tartaglia proposed a simple approach to perform an approximate quadrature of the circle. His construction results with the number pi=3.125. Using a similar construction as...