3,311 Hits in 2.1 sec

NewSQL: Towards Next-Generation Scalable RDBMS for Online Transaction Processing (OLTP) for Big Data Management [article]

A B M Moniruzzaman
2014 arXiv   pre-print
One of the key advances in resolving the big-data problem has been the emergence of an alternative database technology.  ...  This paper compares SQL based RDBMS, NoSQL and NewSQL databases with set of metrics; as well as, addressed some research issues ofNoSQL and NewSQL.  ...  Comparison of SQL based RDBMS, NoSQL and NewSQL This section compares SQL based RDBMS, NoSQL and NewSQL databases with set of metrics.  ... 
arXiv:1411.7343v1 fatcat:d2k3yangbjae5k5246ah6bwhxq

NewSQL: Towards Next-Generation Scalable RDBMS for Online Transaction Processing (OLTP) for Big Data Management

A. B. M. Moniruzzaman
2014 International Journal of Database Theory and Application  
One of the key advances in resolving the "big-data" problem has been the emergence of an alternative database technology.  ...  This paper compares SQL based RDBMS, NoSQL and NewSQL databases with set of metrics; as well as, addressed some research issues of NoSQL and NewSQL.  ...  One of the key advances in resolving the "big- Figure 1.  ... 
doi:10.14257/ijdta.2014.7.6.11 fatcat:hbyj4wfjbjewvmrufh3n2lmu54

MQL2SQL: A Proposal Data Transformation Algorithm from MongoDB to RDBMS

Jabrane Kachaoui
2020 International Journal of Advanced Trends in Computer Science and Engineering  
This paper proposes an integration algorithm to support hybrid database architecture, including MongoDB and MySQL, by allowing users to query data from NoSQL systems into relational SQL (Structured Query  ...  :"Advanced"} The first model is to embed the Course document in Student document.  ...  Figure 1 : 1 Figure 1:Proposal data model from MongoDB to RDBMS Figure 2 : 2 Figure 2:Comparison between SQL and MQL Figure 3 : 3 Figure 3: One to one RDBMS association MongoDB can model the 1:1 association  ... 
doi:10.30534/ijatcse/2020/234922020 fatcat:h7xlechbhbfxfl5iyuurlg6usa

Comparison between SQL and NoSQL Databases and Their Relationship with Big Data Analytics

Wajid Ali, Muhammad Usman Shafique, Muhammad Arslan Majeed, Ali Raza
2019 Asian Journal of Research in Computer Science  
In this paper we will discuss about SQL and NoSQL databases, comparison of traditional SQL with NoSQL databases for Big Data analytics, NoSQL data models, types of NoSQL data stores, characteristics and  ...  In the world of data storage, NoSQL (usually interpreted as "not only SQL" by developers) database is a growing trend.  ...  In this paper, we mainly focused on SQL, NoSQL databases, NoSQL data models with their types and comparison between these two databases (SQL, NoSQL).  ... 
doi:10.9734/ajrcos/2019/v4i230108 fatcat:oobltju6tfdohlbyyhuh6fkxuy

SQL for SRL: Structure Learning Inside a Database System [article]

Oliver Schulte, Zhensong Qian
2015 arXiv   pre-print
Our implementation shows how our SQL constructs in FACTORBASE facilitate fast, modular, and reliable program development.  ...  Relational algebra is implemented in the Structured Query Language (SQL), which is the basis of relational database management systems.  ...  These systems focus on inference given a statistical-relational model, not on learning the model from the data stored in the RDBMS.  ... 
arXiv:1507.00646v1 fatcat:6z3pnpclavdu3gykpznpijzqja

JSON data management

Zhen Hua Liu, Beda Hammerschmidt, Doug McMahon
2014 Proceedings of the 2014 ACM SIGMOD international conference on Management of data - SIGMOD '14  
Consequently, an RDBMS can unify the management of both relational data and JSON data in one platform and use SQL with an embedded JSON path language as a single declarative language to query both relational  ...  In this paper, we analyze the way in which requirements differ between management of relational data and management of JSON data.  ...  The authors like to express their thanks to following colleagues who have been in the working group to formulate SQL/JSON standard: Krishna Kulkarni, Fatma Ozcan, Jim Melton, Jan-Eike Michels, Hamid Pirahesh  ... 
doi:10.1145/2588555.2595628 dblp:conf/sigmod/LiuHM14 fatcat:rrf7sofrfvcdplcbrapk5rb4ji

Leveraging Data Analytics by Transforming Relational Database Schema in to Big Data

Siddiqui Zeeshan
2016 Trends in Computer Science and Information Technology  
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.  ...  . • Columns as compared to traditional RDBMS model and are very different in HBase.  ... 
doi:10.17352/tcsit.000002 fatcat:mjtpnrl5lbb4pkinqgr5hdksiu

Emerging Technologies For Big Data Processing: NOSQL And NEWSQL Data Stores

Deepika Aggarwal, Roopam Sonika
2016 International Journal Of Engineering And Computer Science  
In this incessant science and technological era, where advances in web technology and the production of mobile devices and sensors connected to the Internet are resulting to voluminous amount of structured  ...  This paper discusses the prominent features of NoSQL and NewSQL data stores in the context of cloud computing.  ...  Characteristics of NoSQL  NoSQL does not use the relational data model thus does not use SQL language.  NoSQL stores large volume of data.  In distributed environment (spread data to different machines  ... 
doi:10.18535/ijecs/v5i1.24 fatcat:jdtuhhti6faadm4l4fireck3hm

Identifying New Directions in Database Performance Tuning

Derek Colley, Clare Stanier
2017 Procedia Computer Science  
However, this has resulted in generally poor query performance for SQL developed by object applications and an irregular fit with cost-based optimisation algorithms, and leads to questions about the need  ...  optimiser model.  ...  Based on the seminal work of Codd [14] , RDBMS have been in use for almost half a century and RDBMS performance tuning is a well-understood field.  ... 
doi:10.1016/j.procs.2017.11.036 fatcat:4l7ko5x2bzc6vfqpjflemlohmu

A Decade of XML Data Management: An Industrial Experience Report from Oracle

Zhen Hua Liu, Ravi Murthy
2009 Proceedings / International Conference on Data Engineering  
There has been considerable amount of effort both from research and industry focusing on XML, XQuery/XPath, XSLT and SQL/XML processing in the database.  ...  XML and its related technologies have now been in use for almost a decade.  ...  XML as an abstract type ANSI SQL/XML defines XMLType as a built-in datatype in the RDBMS [16] .  ... 
doi:10.1109/icde.2009.18 dblp:conf/icde/LiuM09 fatcat:oecsthn7q5g5bp2y3x7vbnoq5i

Activity recognition in wide aerial video surveillance using entity relationship models

Jongmoo Choi, Yann Dumortier, Jan Prokaj, Gérard Medioni
2012 Proceedings of the 20th International Conference on Advances in Geographic Information Systems - SIGSPATIAL '12  
In this approach, finding an activity is equivalent to sending a query to a Relational DataBase Management System (RDBMS).  ...  We present the design and implementation of an activity recognition system in wide area aerial video surveillance using Entity Relationship Models (ERM).  ...  Acknowledgment This work was supported in part by grant DE-FG52-08NA28775 from the U.S. Department of Energy.  ... 
doi:10.1145/2424321.2424391 dblp:conf/gis/ChoiDPM12 fatcat:yrfzavlfxvadjl6vk4tmq54np4

Towards Business Intelligence over Unified Structured and Unstructured Data Using XML [chapter]

Zhen Hua, Vishu Krishnamurthy
2012 Business Intelligence - Solution for Business Development  
SQL/XML in RDBMS for XML based DWH SQL/XML is an ISO SQL standard that defines XML as a datatype conforming to the XQuery data model with three new built-in operators: XMLQuery(), XMLExists(), and XMLCast  ...  Data warehouse in SQL/RDBMS -its success and limitations Based on a strong foundation in relational model and algebra (Codd, 1970) , relational database management system (RDBMS) is a great success.  ... 
doi:10.5772/36863 fatcat:oqyadnvxljbmznwwbjz2m6clx4

Integrating MapReduce and RDBMSs

Natalie Gruska, Patrick Martin
2010 Proceedings of the 2010 Conference of the Center for Advanced Studies on Collaborative Research - CASCON '10  
Several database vendors and researchers have already turned to MapReduce to aid in processing relational data, thus requiring integration of MapReduce and RDBMS technologies.  ...  In this paper, we provide a taxonomy to characterize several existing integration methods.  ...  He is also a Faculty Fellow with the IBM Centre for Advanced Studies in Toronto, ON. His research interests include database system performance, Web services and autonomic computing systems.  ... 
doi:10.1145/1923947.1923970 dblp:conf/cascon/GruskaM10 fatcat:rm5qni6ebbhrfblaffoqlpqrtm

SQL vs. NoSQL vs. NewSQL- A Comparative Study

Sneha Binani, Ajinkya Gutti, Shivam Upadhyay
2016 Communications on Applied Electronics  
It is also horizontally Scalable as opposed to vertical scaling in RDBMS.  ...  SQL Databases also known as RDBMS (Relational Database Management Systems) is the most common and traditional approach to database solutions.  ...  SQL 3.1 Definition SQL is a computer language used in databases for managing data in Relational Database Managing System (RDBMS). [2] SQL was originally developed in 1970 in the IBM laboratories.  ... 
doi:10.5120/cae2016652418 fatcat:vo4kfgl6tjd5vixtwpzniwycnm


Joseph Vinish D'silva, Florestan De Moor, Bettina Kemme
2018 Proceedings of the VLDB Endowment  
In this paper, we propose AIDA -an abstraction for advanced in-database analytics.  ...  With the tremendous growth in data science and machine learning, it has become increasingly clear that traditional relational database management systems (RDBMS) are lacking appropriate support for the  ...  In the first case, the data is in RDBMS tables and AIDA, therefore, executes a SQL internally in the RDBMS to produce the result.  ... 
doi:10.14778/3236187.3236194 fatcat:mhj6tp2q7nhjra3eoo2lqicnyi
« Previous Showing results 1 — 15 out of 3,311 results