Over a million developers have joined DZone.

The Best of the Week (Apr 03): SQL Zone

DZone's Guide to

The Best of the Week (Apr 03): SQL Zone

Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone (April 03 - April 10), with appearances by Java 8 and MySQL.

· Database Zone ·
Free Resource

Built by the engineers behind Netezza and the technology behind Amazon Redshift, AnzoGraph is a native, Massively Parallel Processing (MPP) distributed Graph OLAP (GOLAP) database that executes queries more than 100x faster than other vendors.  

Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone (April 03 - April 10). Here they are, in order of popularity:

1. How to Avoid the Dreaded Dead Lock When Pessimistic Locking - And Some Awesome Java 8 Usage!

  • Sometimes you simply cannot avoid it: Pessimistic locking via SQL. In fact, it’s an awesome tool when you want to synchronise several applications on a shared, global lock. Some may think this is abusing the database. We think use the tools you have if they can solve the problem you have.

2. Modifying Your MySQL Structure w/o Downtime

  • Did you try to add a new index to your MySQL huge table and suffered from a downtime?

3. The Cost of Not Properly Managing Your Databases

  • Every day hundreds of millions of dollars are wasted by allowing improperly tuned or misconfigured systems, misunderstood infrastructure, and inefficient IT operations to live and thrive in data centers around the globe. There are both direct and indirect costs associated with allowing these unhealthy systems to continue to exist.

4. Using MobileFirst SQL Adapters with an Ionic Application

  • MobileFirst Adapters are server-side components that connect your hybrid mobile application to other things. Those “things” being generally broken down into a few categories, and a few specific adapter types. The SQL adapter is, as you can guess, a connection to a database.

5. Q&A: Multi-threaded Replication in MySQL 5.6 and MySQL 5.7

  • My webinar “Multi-threaded Replication in MySQL 5.6 and 5.7″ on February 25 generated several excellent questions following the presentation. I didn’t have time to answer many of the questions during the session and so in this post I answer all of them.


Download AnzoGraph now and find out for yourself why it is acknowledged as the most complete all-in-one data warehouse for BI style and graph analytics.  

sql ,best of the week ,database

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}