Over a million developers have joined DZone.

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

· Java Zone

Check out this 8-step guide to see how you can increase your productivity by skipping slow application redeploys and by implementing application profiling, as you code! Brought to you in partnership with ZeroTurnaround.

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

1. MySQL Compression: Compressed and Uncompressed Data Size

  • MySQL has information_schema.tables that contain information such as “data_length” or “avg_row_length.” Documentation on this table however is quite poor, making an assumption that those fields are self explanatory – they are not when it comes to tables that employ compression.

2. Sqoop Oracle Example : Getting Started with Oracle -> HDFS Import/Extract

  • In this post, we'll get Sqoop (1.99.3) connected to an Oracle database, extracting records to HDFS.

3. Stop Claiming That You’re Using a Schemaless Database

  • One of MongoDB’s arguments when evangelising MongoDB is the fact that MongoDB is a “schemaless” database... But it doesn’t mean that there is no schema.

4. How to Avoid Hash Collisions When Using MySQL’s CRC32 Function

  • Percona Toolkit’s pt-table-checksum performs an online replication consistency check by executing checksum queries on the master, which produces different results on replicas that are inconsistent with the master – and the tool pt-table-sync synchronizes data efficiently between MySQL tables.

5. Understanding of Execution Plan - III - A [ The OPERATORS ]

  • In this article we are mostly focusing on the Logical and Physical Operators and trying to understand each as it is very important to understand them before understanding the Execution Plan.


The Java Zone is brought to you in partnership with ZeroTurnaround. Check out this 8-step guide to see how you can increase your productivity by skipping slow application redeploys and by implementing application profiling, as you code!

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 }}