m
Our Mission Statement
This is Photoshop's version of Loremer Ipsn gravida nibh vel velit auctoregorie sam alquet.Aenean sollicitudin, lorem quis bibendum auci elit consequat ipsutis sem nibh id elit.
Follow Us
Top
SQL Archives - VoltDB
53
archive,category,category-sql,category-53,cookies-not-set,mkd-core-1.0,highrise-ver-1.0,,mkd-smooth-page-transitions,mkd-ajax,mkd-grid-1300,mkd-blog-installed,mkd-header-standard,mkd-sticky-header-on-scroll-up,mkd-default-mobile-header,mkd-sticky-up-mobile-header,mkd-dropdown-slide-from-bottom,mkd-dark-header,mkd-header-style-on-scroll,mkd-full-width-wide-menu,mkd-header-standard-in-grid-shadow-disable,mkd-search-dropdown,mkd-side-menu-slide-from-right,wpb-js-composer js-comp-ver-5.4.7,vc_responsive

SQL

VoltDB / SQL

SQL

SQL stands for Structured Query Language. It is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. It is the standard interactive and programming language for getting information from and updating a database. Donald Chamberlin and Raymond Boyce created the language in the mid-1970s. It was the first commercially successful language for relational databases.

SQL is used both as the name of a language and a type of database. The structured query language - is designed for managing data in relational database management systems (RDBMS). Relational database management systems are often called SQL databases since they use the SQL language. Since the mid-1980s, the language has been a standard for querying and managing RDBMS data sets.

Relational databases continue to provide the foundation for the world's transactions. Think about all the credit card transactions being handled by the mainframes and large UNIX servers in the data centers of financial services companies. Web-scale proved to be a great challenge to those traditional RDBMSs -- you couldn't build a single shared resource machine big enough to handle the demands.

Editor’s note: This post is re-posted here by permission from the author. The original post was on LinkedIn on January 10, 2018. The world has changed massively in the past 20 years. Back in the year 2000, a few million users connected to the web using a...

Previously in part one of this blog series, I explained the problems with two methods of database interactions. Traditional JDBC-style interactions mean that locking and latching take up ~30% of compute time. This overhead skyrockets when you try to use a distributed system. A NoSQL key-value...

First off: I’m not here to bash NoSQL. NoSQL came into existence for a good reason — your generic legacy SQL RDBMS is often slow and expensive when compared to NoSQL alternatives. But much of the discussion I’ve seen about NoSQL, NewSQL, Legacy RDBMS and...

For decades, relational databases was the de-facto choice for financial service companies, until the 2000s where systems started to face challenges with scalability and availability as the amount of data being processed and consumed shaped how companies conducted their business. NoSQL databases emerged as a reaction...

My name is Dinesh Majeti and I am a Ph.D. student from the University of Houston in the field of Computer Science. It is an exciting moment when you start to work in the industry for the first time, especially as a graduate student who...

We added support for scalar user-defined functions in our recent release, VoltDB V7.6. With this feature, users can write their own SQL functions in Java and load them into VoltDB. Those functions, once loaded, can be used in all kinds of SQL queries just like...

Several days ago, I saw a tweet fly by in my stream. The creator of Node.js, Ryan Dahl, was recommending Golang for any new server-side projects. While Node.js is still very popular, the growth in microservices has been driving a more wide-spread adoption of Golang...

Last Monday on August 28th, a number of the VoltDB staff attended the Kafka Summit in San Francisco. This one-day event brought in over 700 attendees from the developer audience to attend 30+ valuable technical talks and breakout sessions, and meet directly with exhibiting sponsors...