Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

The Best of the Week (Oct. 31): SQL Zone

DZone's Guide to

The Best of the Week (Oct. 31): SQL Zone

· Database Zone
Free Resource

Check out the IT Market Clock report for recommendations on how to consolidate and replace legacy databases. Brought to you in partnership with MariaDB.

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

1. Hibernate Collections Optimistic Locking

  • Hibernate provides an optimistic locking mechanism to prevent lost updates even for long-conversations.

2. MySQL 5.6 Full Text Search Throwdown: Webinar Q&A

  • Yesterday (Oct. 22) I gave a presentation titled “MySQL 5.6 Full Text Search Throwdown.” If you missed it, you can still register to view the recording and my slides. Thanks to everyone who attended, and especially to folks who asked the great questions. I answered as many as we had time for during the session, but here are all the questions with my complete answers

3. Facebook MySQL database engineers ready for Percona Live London 2014

  • I spoke with Facebook database engineers Yoshinori “Yoshi” Matsunobu and Shlomo Priymak about their upcoming sessions along with what’s new at Facebook since our last conversation back in April.

4. Understanding the Execution Plan [When Table JOIN occurs Part-I]

  • In my previous article we are just using a single table as per our example is concern, Now in this article we are going to see the different table join each other’s and make a single data set by using JOIN.

5. Back to Learning Grammar with ANTLR

  • This post is going to be about language processing. Language processing could be anything like an arithmetic expression evaluator, a SQL parser or even a compiler or interpreter. Many times when we build user facing products, we give users a new language to interact with the product.

 

Interested in reducing database costs by moving from Oracle Enterprise to open source subscription?  Read the total cost of ownership (TCO) analysis. Brought to you in partnership with MariaDB.

Topics:

Opinions expressed by DZone contributors are their own.

The best of DZone straight to your inbox.

SEE AN EXAMPLE
Please provide a valid email address.

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.
Subscribe

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

{{ parent.tldr }}

{{ parent.urlSource.name }}