Sign up | Login with →

SQL

From Operations to Insights: Business Analytics Meets NoSQL

November 3, 2016 by Eran Levy

Many people love NoSQL databases because they can throw their data into them without a care (almost) and let the NoSQL database sort out the storage. Writes and reads of “lumps” of data can be blazingly fast, making them favorite tools for many developers seeking performance for their applications. But analytics? If you’ve thrown in your...[read more]

Database Corner: Beginner’s Guide to MySQL Storage Engines

September 10, 2016 by Eran Levy

When a database is created, one often overlooked but critical factor in performance is the storage engine (particularly as the database grows). In many instances, the temptation is to just accept the default and continue on developing your project. This can lead to unexpected negative impacts on performance, backups, and data integrity...[read more]

8 Ways to Fine-tune your SQL Queries (for production databases)

September 7, 2016 by Eran Levy

In organizations that operate without a data warehouse or separate analytical database for reporting, the only source of the latest and up-to-date data may be in the live production database. When querying a production database, optimization is key. An inefficient query may pose a burden on the production database’s resources, and cause...[read more]

Pros and Cons of Using MySQL for Analytical Reporting

July 6, 2016 by Eran Levy

Is MySQL a good solution for reporting and data analytics? The internet is bombarded with 1000’s of guides or courses to installing, configuring, and optimizing MySQL for running analytics. However, none of these write-ups stop to even ask the question: “Is MySQL the right solution for business intelligence?”With the obvious caveat that...[read more]

exclusive

8 File Types, Databases and Platforms You May Not Know Can Be Rescued

May 11, 2016 by Rehan Sheikh

Compromised files and data is something we don’t tend to worry about much these days. Backup to the cloud and other forms of remote digital information storage have us accustomed to the data always being there, somewhere.Sometimes, however, this isn’t the case. Plenty of critical, crucial data for individuals and businesses wind up...[read more]

Apache Drill vs. Apache Spark: What’s The Right Tool for the Job?

March 1, 2016 by Jim Scott

If you’re looking to implement a big data project, you’re probably deciding whether to go with Apache Spark SQL or Apache Drill. This article can help you decide which query tool you should use for the kinds of projects you’re working on.[read more]

exclusive

A Look at SparkSQL

November 18, 2015 by Jim Scott

If you’ve been reading about Apache Spark, you might be worried about whether you have to relearn all of your skills for using it to interact with databases. With Apache Spark, whether you’re a DBA or a developer, you’ll be able to interact with Apache Spark in the way you’re used to—while solving real problems.[read more]

exclusive

Redefining Loyalty Programs with Big Data and Hadoop

June 11, 2015 by Dave Mendle

A loyalty program should not be about points, rewards, or status. While these perks may attract consumers, they don’t foster loyalty. The focus of these programs should be to collect useful data that can be used to build relationships that benefit both the consumer and the brand.[read more]

Not All Hadoop Users Drop ACID

April 8, 2015 by Paige Roberts

ACID.

Hadoop users have all had to give up ACID and settle for the new standard, BASE, as a general rule, but like so many things in the data wrangling industry, that’s changing fast. This may come as a shock to a lot of current Hadoop users and database users considering making the switch to Hadoop, but using Hadoop doesn’t mean you have to give up your ACID habit.[read more]

exclusive

Data Lakes and Network Optimization: What’s Next for Telecommunications and Big Data

March 31, 2015 by Sameer Nori

Telecommunication. 

Relational data warehouses served communications service providers well in the past, but it’s time to start thinking beyond columns and rows. Unstructured data will be the fuel that powers risk management and decision-making in the near future. And to use all sorts of data to its fullest potential, we need new ways of storing, accessing and analyzing that data.[read more]

Aligning Big Data

January 18, 2015 by Martyn Jones

Aligning big data.

This is an overview of the realignment and placement of Big Data into a more generalized architectural framework, an architecture that integrates data warehousing (DW 2.0), business intelligence and statistical analysis.[read more]

exclusive

5 Ways Hadoop Can Help Healthcare Organizations and You

November 23, 2014 by Sameer Nori

Hadoop and healthcare

There are many different use cases for Hadoop in healthcare. Some of them include helping doctors, patients, and healthcare organizations include personalized treatment planning, assisted diagnosis, fraud detection, and monitoring patient vital signs. Learn how Hadoop is being implemented in each of these use cases.[read more]

exclusive

5 Common Use Cases for Hadoop in Retail

November 20, 2014 by Sameer Nori

Hadoop in retail

Retailers can focus on the shopper as an individual, rather than aiming at the masses and hoping to snag a few. Where there once were customer panels, in-store surveys, focus groups, and guesswork, there is now social media, online search behavior, and easy-access customer input.[read more]

Spotlight on SiSense: BI Without the Bandwidth

October 9, 2014 by Shawn Gordon

Spotlight on SiSense.

I was at DataWeek/API World in mid-September 2014 (last week at the time of this writing) and saw some interesting things, almost entirely around Big Data. The two items that stood out for me, were the Graph DataBase system Neo4j (which I wish I had time and a reason to dig into more), and SiSense, who absolutely blew my mind.[read more]

exclusive

Fine-Tuning Manufacturing Operations with Big Data and Hadoop

October 6, 2014 by Sameer Nori

Manufacturing pperations and Hadoop.

Your organization is a lean, mean Six Sigma machine. The corporate culture is centered on continuous improvement, with everyone well versed in Kaizen. Your supply chain is well oiled, which should provide assurance about product quality. And yet you wonder: is it possible to improve operations even further?[read more]