A Comparison of NoSQL Time Series Databases
A Comparison of NoSQL Time Series Databases

Author: Kevin Rudolph

Publisher: GRIN Verlag

Published: 2015-05-21

Total Pages: 50

ISBN-13: 3656965757

DOWNLOAD EBOOK

Research Paper (undergraduate) from the year 2015 in the subject Engineering - Industrial Engineering and Management, grade: 1,0, Technical University of Berlin (Wirtschaftsinformatik - Information Systems Engineering (ISE)), course: Seminar: Hot Topics in Information Systems Engineering, language: English, abstract: During the last years NoSQL databases have been developed to ad-dress the needs of tremendous performance, reliability and horizontal scalability. NoSQL time series databases (TSDBs) have risen to combine valuable NoSQL properties with characteristics of time series data encountering many use-cases. Solutions offer the efficient handling of data volume and frequency related to time series. Developers and decision makers struggle with the choice of a TSDB among a large variety of solutions. Up to now no comparison exists focusing on the specific features and qualities of those heterogeneous applications. This paper aims to deliver two frameworks for the comparison of TSDBs, firstly with a focus on features and secondly on quality. Furthermore, we apply and evaluate the frameworks on up to seven open-source TSDBs such as InfluxDB and OpenTSDB. We come to the result that the investigated TSDBs differ mainly in support- and extension related points. They share performance-enhancing techniques, time-related query capabilities and data schemas optimized for the handling of time-series data.

Time Series Databases
Time Series Databases

Author: Ted Dunning

Publisher: O'Reilly Media

Published: 2014

Total Pages: 0

ISBN-13: 9781491914724

DOWNLOAD EBOOK

Time series data is of growing importance, especially with the rapid expansion of the Internet of Things. This concise guide shows you effective ways to collect, persist, and access large-scale time series data for analysis. You'll explore the theory behind time series databases and learn practical methods for implementing them. Authors Ted Dunning and Ellen Friedman provide a detailed examination of open source tools such as OpenTSDB and new modifications that greatly speed up data ingestion. You'll learn: A variety of time series use cases The advantages of NoSQL databases for large-scale time series data NoSQL table design for high-performance time series databases The benefits and limitations of OpenTSDB How to access data in OpenTSDB using R, Go, and Ruby How time series databases contribute to practical machine learning projects How to handle the added complexity of geo-temporal data For advice on analyzing time series data, check out Practical Machine Learning: A New Look at Anomaly Detection, also from Ted Dunning and Ellen Friedman.

SQL and NoSQL Databases
SQL and NoSQL Databases

Author: Michael Kaufmann

Publisher: Springer Nature

Published: 2023-06-29

Total Pages: 263

ISBN-13: 3031279085

DOWNLOAD EBOOK

This textbook offers a comprehensive introduction to relational (SQL) and non-relational (NoSQL) databases. The authors thoroughly review the current state of database tools and techniques and examine upcoming innovations. In the first five chapters, the authors analyze in detail the management, modeling, languages, security, and architecture of relational databases, graph databases, and document databases. Moreover, an overview of other SQL- and NoSQL-based database approaches is provided. In addition to classic concepts such as the entity and relationship model and its mapping in SQL database schemas, query languages or transaction management, other aspects for NoSQL databases such as non-relational data models, document and graph query languages (MQL, Cypher), the Map/Reduce procedure, distribution options (sharding, replication) or the CAP theorem (Consistency, Availability, Partition Tolerance) are explained. This 2nd English edition offers a new in-depth introduction to document databases with a method for modeling document structures, an overview of the document-oriented MongoDB query language MQL as well as security and architecture aspects. The topic of database security is newly introduced as a separate chapter and analyzed in detail with regard to data protection, integrity, and transactions. Texts on data management, database programming, and data warehousing and data lakes have been updated. In addition, the book now explains the concepts of JSON, JSON schema, BSON, index-free neighborhood, cloud databases, search engines and time series databases. The book includes more than 100 tables, examples and illustrations, and each chapter offers a list of resources for further reading. It conveys an in-depth comparison of relational and non-relational approaches and shows how to undertake development for big data applications. This way, it benefits students and practitioners working across the broad field of data science and applied information technology.

Solving Business Problems with Informix TimeSeries
Solving Business Problems with Informix TimeSeries

Author: Vaibhav S Dantale

Publisher: IBM Redbooks

Published: 2012-09-21

Total Pages: 148

ISBN-13: 0738437239

DOWNLOAD EBOOK

The world is becoming more and more instrumented, interconnected, and intelligent in what IBM® terms a smarter planet, with more and more data being collected for analysis. In trade magazines, this trend is called big data. As part of this trend, the following types of time-based information are collected: Large data centers support a corporation or provide cloud services. These data centers need to collect temperature, humidity, and other types of information over time to optimize energy usage. Utility meters (referred to as smart meters) allow utility companies to collect information over a wireless network and to collect more data than ever before. IBM Informix® TimeSeries is optimized for the processing of time-based data and can provide the following benefits: Storage savings: Storage can be optimized when you know the characteristics of your time-based data. Informix TimeSeries often uses one third of the storage space that is required by a standard relational database. Query performance: Informix TimeSeries takes into consideration the type of data to optimize its organization on disk and eliminates the need for some large indexes and additional sorting. For these reasons and more, some queries can easily have an order of magnitude performance improvement compared to standard relational. Simpler queries: Informix TimeSeries includes a large set of specialized functions that allow you to better express the processing that you want to execute. It even provides a toolkit so that you can add proprietary algoritms to the library. This IBM Redbooks® publication is for people who want to implement a solution that revolves around time-based data. It gives you the information that you need to get started and be productive with Informix TimeSeries.

Seven Databases in Seven Weeks
Seven Databases in Seven Weeks

Author: Luc Perkins

Publisher: Pragmatic Bookshelf

Published: 2018-04-05

Total Pages: 430

ISBN-13: 1680505971

DOWNLOAD EBOOK

Data is getting bigger and more complex by the day, and so are your choices in handling it. Explore some of the most cutting-edge databases available - from a traditional relational database to newer NoSQL approaches - and make informed decisions about challenging data storage problems. This is the only comprehensive guide to the world of NoSQL databases, with in-depth practical and conceptual introductions to seven different technologies: Redis, Neo4J, CouchDB, MongoDB, HBase, Postgres, and DynamoDB. This second edition includes a new chapter on DynamoDB and updated content for each chapter. While relational databases such as MySQL remain as relevant as ever, the alternative, NoSQL paradigm has opened up new horizons in performance and scalability and changed the way we approach data-centric problems. This book presents the essential concepts behind each database alongside hands-on examples that make each technology come alive. With each database, tackle a real-world problem that highlights the concepts and features that make it shine. Along the way, explore five database models - relational, key/value, columnar, document, and graph - from the perspective of challenges faced by real applications. Learn how MongoDB and CouchDB are strikingly different, make your applications faster with Redis and more connected with Neo4J, build a cluster of HBase servers using cloud services such as Amazon's Elastic MapReduce, and more. This new edition brings a brand new chapter on DynamoDB, updated code samples and exercises, and a more up-to-date account of each database's feature set. Whether you're a programmer building the next big thing, a data scientist seeking solutions to thorny problems, or a technology enthusiast venturing into new territory, you will find something to inspire you in this book. What You Need: You'll need a *nix shell (Mac OS or Linux preferred, Windows users will need Cygwin), Java 6 (or greater), and Ruby 1.8.7 (or greater). Each chapter will list the downloads required for that database.

Time and Relational Theory
Time and Relational Theory

Author: C.J. Date

Publisher: Morgan Kaufmann

Published: 2014-08-13

Total Pages: 579

ISBN-13: 0128006757

DOWNLOAD EBOOK

Time and Relational Theory provides an in-depth description of temporal database systems, which provide special facilities for storing, querying, and updating historical and future data. Traditionally, database management systems provide little or no special support for temporal data at all. This situation is changing because: - Cheap storage enables retention of large volumes of historical data in data warehouses - Users are now faced with temporal data problems, and need solutions - Temporal features have recently been incorporated into the SQL standard, and vendors have begun to add temporal support to their DBMS products Based on the groundbreaking text Temporal Data & the Relational Model (Morgan Kaufmann, 2002) and new research led by the authors, Time and Relational Theory is the only book to offer a complete overview of the functionality of a temporal DBMS. Expert authors Nikos Lorentzos, Hugh Darwen, and Chris Date describe an approach to temporal database management that is firmly rooted in classical relational theory and will stand the test of time. This book covers the SQL:2011 temporal extensions in depth and identifies and discusses the temporal functionality still missing from SQL. - Understand how the relational model provides an ideal basis for taming the complexities of temporal databases - Learn how to analyze and evaluate commercial temporal products with this timely and important information - Be able to use sound principles in designing and using temporal databases - Understand the temporal support recently added to SQL with coverage of the new SQL features in this unique, accurate, and authoritative reference - Appreciate the benefits of a truly relational approach to the problem with this clear, user friendly presentation

A Study and Comparison of NoSQL Databases
A Study and Comparison of NoSQL Databases

Author: Christopher Jay Choi

Publisher:

Published: 2014

Total Pages: 63

ISBN-13:

DOWNLOAD EBOOK

The advent of big data and the need for large scale data analysis has led to a rapid increase in the number of systems designed to serve data on the cloud. These systems address the need for OLTP, often adhering to BASE principles in order to maintain a high degree of availability and scalability. The wide range of systems, now available, make it difficult to determine which system will best meet a user's needs without testing each system individually. In 2010, Yahoo! filled the need for an apples-to-apples performance comparison by open sourcing their Yahoo! Cloud Serving Benchmark (YCSB) framework. The framework was designed with the goal of facilitating performance comparisons of the new generation of cloud data serving systems. YCSB provides a set of core workloads that reflect common real world use cases. This thesis discusses the architectures of several widely used NoSQL database systems as well as the results of applying YCSB workloads to the most readily available versions of those systems.

NoSQL Distilled
NoSQL Distilled

Author: Pramod J. Sadalage

Publisher: Pearson Education

Published: 2013

Total Pages: 188

ISBN-13: 0321826620

DOWNLOAD EBOOK

'NoSQL Distilled' is designed to provide you with enough background on how NoSQL databases work, so that you can choose the right data store without having to trawl the whole web to do it. It won't answer your questions definitively, but it should narrow down the range of options you have to consider.

Recent Innovations in Computing
Recent Innovations in Computing

Author: Pradeep Kumar Singh

Publisher: Springer Nature

Published: 2021-01-12

Total Pages: 846

ISBN-13: 9811582971

DOWNLOAD EBOOK

This book features selected papers presented at the 3rd International Conference on Recent Innovations in Computing (ICRIC 2020), held on 20–21 March 2020 at the Central University of Jammu, India, and organized by the university’s Department of Computer Science & Information Technology. It includes the latest research in the areas of software engineering, cloud computing, computer networks and Internet technologies, artificial intelligence, information security, database and distributed computing, and digital India.

Comparative Analysis of MySQL (Relational) with MongoDB (NoSQL) Databases
Comparative Analysis of MySQL (Relational) with MongoDB (NoSQL) Databases

Author: Independently Published

Publisher:

Published: 2017-09-15

Total Pages: 45

ISBN-13: 9781726755337

DOWNLOAD EBOOK

As huge amount of data is increasing day by day and it cannot be managed easily by relational databases because of low scalability provided by the relational databases. The storage technology is still not capable enough for the performance and scalability that is needed to store data but after 2005 NoSQL databases have come in existence and start solving the problems that relational databases were facing before. NoSQL is a type of such databases that come under non-relational databases. There are four types of NoSQL databases and these types are { Key Value Store}, {Column Store} ,{ Document databases},{ Graph databases}, each one of these databases has different features. Now , the question arise is whether non-relational databases are the right choice to continue or to stay with the old relational databases for applications and web development and from where NoSQL came from, how they are represented and what are the types of relational and non-relational databases, these all questions are going to be explained in this thesis. The objectives of this thesis are to show that the why need of NoSQL databases became necessary with the time, second objective is to show the types and representation of various types of relational and non-relational databases, third objective is to focus about MongoDB which is a type of Document Databases under the category of NoSQL database that is a non-relational database and comparison of MySQL that is a relational database with MongoDB by how to represent these two databases and how to write answers for same query in MySQL and MongoDB, then a comparison analysis by calculating the time of selection, updating and deleting between MongoDB and MySQL .