We heard some interesting news regarding SQL and Big Data earlier this month, and now there's more: Oracle Big Data SQL. Even if that incredibly creative name doesn't do it for you, it looks like it should be useful as a way to connect the various Big Data technologies you might be working with.
A common question that comes up when people start tuning queries is “why doesn’t this query use the index I expect?" There are a few myths surrounding when database optimizers will use an index. The basic decision on whether or not to use an index, though, comes down to its cost.
It should come as no surprise that NoSQL has become popular over the past few years. This popularity has been driven in large part by the app revolution. Many new apps are hitting millions of users in less than a week, some in a day. This presents a scaling problem for app developers who seek a large audience.
Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone. This week's best include a look at Realm, a memory-efficient mobile database, a renewed focus on Java and SQL, the similarities between databases and humvees, and more.
This is the fourth post in our MySQL Fabric series. In case you’re joining us now, we started with an introductory post, and then discussed High Availability (HA) using MySQL Fabric. Today we will talk about how MySQL Fabric can help you scale out MySQL databases with sharding.
I was experimenting with the FTS3/FTS4 feature of SQlite in a WinRT app. The default tokenizer ‘simple’ wont tokenize special character like $, @, etc. The solution is to use ‘unicode61’ tokenizer. Unfortunately the SQLite installer for WinRT8.1 comes without unicode61 tokenizer.
Imagine you want to collect detailed usage statistics to tune your Oracle database, e.g. if you want to have A-Rows and A-Time values in your execution plans. It's simple enough, but of course, you hardly ever have the required privileges. So how can we get those advanced statistics? Easy: by using a logon trigger.
If you're a mobile developer looking for a database that won't crush devices more thoroughly than Play Services 5.0, SQLite isn't the only option anymore. Now there's Realm, currently available for iOS (and Android, soon).
Every week here and in our newsletter, we feature a new developer/blogger from the DZone community to catch up and find out what he or she is working on now and what's coming next. This week we're getting a different sort of perspective from DZone's development interns, Jeffery Kim and Trevor Gadaska!
While there’s not much application-side IDENTITY generator optimization (other than configuring database identity preallocation), the sequence identifiers offer much more flexibility in this regard. One of the most common optimization strategy is based on the hi/lo allocation algorithm. This article will investigate various sequence-like generation strategies and all the available optimizations.
Recently, one of my long-term clients was noticing that while their INSERTs were succeeding, a particular column counter was not incrementing. Here's what happened and how to solve it.
This is an introduction to MariaDB Replication and to why we need a binlogs server and what this is. The first part is an introduction to replication basics, and if you know this already, then you want want to skip past the first section or two.
If you're a Ruby developer working with SQL, you might want to check out Jiří Pospíšil's definitive guide to Arel, the SQL manager for Ruby. It's one of those libraries that you use constantly and rely on heavily, even though you might not know much about how it works, or even that it exists.
A demanded feature on our Ideas and Feedback portal is the out-of-the-box ability to generate persistent classes that can be serialized, and here it is in Telerik Data Access Q2 2014.
In the past, we’ve been providing you with a new article every Friday about what’s new in Java 8. It has been a very exciting blog series, but we would like to focus again more on our core content, which is Java and SQL.
If you're wondering about the similarities between your database choices and your militarized suburban vehicle choices, Bruce Momjian and Marc Linster have the presentation for you!
In the previous post of this series we saw how you could use mysqlrpladmin to perform manual failover/switchover when GTID replication is enabled in MySQL 5.6. Now we will review mysqlfailover (version 1.4.3), another tool from the MySQL Utilities that can be used for automatic failover.
For those who are not familiar with GridGain, it is an open source distributed data grid product. With the release of 6.1.9, GridGain significantly simplified its installation and deployment. GridGain now allows for one click installation and one JAR dependency.
Responding to a comment involving infinite loops, the author looks at how to clean them up using check conditions.
I recently had an opportunity to migrate a customer from a physical server into Amazon’s RDS environment. In this particular case the customers’ platform makes extensive use of MySQL triggers and views. I came across two significant issues that prevented me from following Amazon’s documentation.
Earlier this week I shared the news that there is now an "official(ish)" version of SQLite that can be used in what Microsoft calls "Universal Apps". I was asked how this compares with using Akavache, and if I have any recommendations.
In my previous post I talked about different database identifier strategies. This post will compare the most common surrogate primary key strategies: IDENTITY, SEQUENCE, and TABLE (SEQUENCE).
Table-valued functions are an awesome thing. Many databases support them in one way or another and so does PostgreSQL. In PostgreSQL, (almost) everything is a table.
MySQL Utilities are a set of tools provided by Oracle to perform many kinds of administrative tasks. When GTID-replication is enabled, 2 tools can be used for slave promotion: mysqlrpladmin and mysqlfailover. We will review mysqlrpladmin (version 1.4.3) in this post.
If you haven’t tried TokuDB yet, here’s an opportunity to do so. This first post looks into giving a bit of context about how TokuDB fits into MySQL, and the next one, to be published in the following days, will document my experience in installing it with Percona Server.