Business Intelligence: The Big Picture

Shree Dandekar, Director of Business Intelligence and Data Warehousing Strategy, Dell | 1/26/2012 | 7 comments

Shree Dandekar
There is a lot of buzz about Hadoop, NoSQL, NewSQL, and columnar MPP databases. But where is the actual value for businesses? Businesses need to have actionable information derived from their data that they collect on a regular basis. We know how to collect data and store it in databases of various kinds. We have seen the evolutions of SQL databases over the last five decades, and databases have gotten sophisticated in terms of processing structured data.

With the recent explosion of social media, and with it the proliferation of unstructured data, new technologies have emerged, such as MapReduce. So now we have the data -- but the real question is where does the business value actually get delivered? The answer is simple.

Read the full post here, at Direct2Dell.
View Comments: Newest First | Oldest First | Threaded View
Shree Dandekar   Business Intelligence: The Big Picture   1/31/2012 12:51:58 PM
Re: Perrmance....
great question: 

Unfortunately there is no industry standard that exists today in terms of benchmarking that can help qualify the performance gains (query response times) claimed by some of these vendors.

Dell actively participates in the TPC-H and TPC-C benchmarking efforts:

TPC-C: http://www.tpc.org/tpcc/results/tpcc_price_perf_results.asp

TPC-H: http://www.tpc.org/tpch/results/tpch_results.asp?orderby=hardware

But both these standards do not help in benchmarking some of these disruptive DBMS players.

Apart from TPC there are other vertical specific standards that exists. One that comes to mind is STAC-M3, commonly used for the financial and securities industry. http://www.stacresearch.com/node/10219

I will be interested to find out if there are other evolving DBMS standards that provide benchmarks on some of these NoSQL technologies.

Hope that answers the question.
User Ranking: Blogger
tekedge   Business Intelligence: The Big Picture   1/31/2012 11:23:49 AM
Perrmance....
How does these new lean and mean dbms's perform?
By this I mean the actual query response times in comparison to the traditional dbms's.
Shree Dandekar   Business Intelligence: The Big Picture   1/31/2012 11:13:31 AM
Re: NewSql databases?
you are absolutely right, BI layer is not an integral part of the NoSQL DBMS layer. And that is actually the point I have tried to make through my blog. While NoSQL and NewSQL DBMS's address a problem they do not help customers with the actual insights. Customers still need to implement a BI layer on top of this "plumbing" layer to be able to extract menaingful insights!
User Ranking: Blogger
Taimoor Zubair   Business Intelligence: The Big Picture   1/29/2012 4:56:29 PM
Re: NewSql databases?
@Shree: Does your BI component lie within NewSQL, or is it built upon NewSQL as a separate layer like it had traditionally been with other RDBMS?

 
aries   Business Intelligence: The Big Picture   1/29/2012 12:44:54 PM
Re: NewSql databases?
NewSQL is databases that have been designed from the outset to have a SQL interface (rather than being added on later) but which do not necessarily have a relational storage engine underneath.

NewSQL is a new database access language. It is easier to learn than SQL, elegant, consistent, and well defined. It is not a extension or subset of SQL, and not a Object database language.

Example NewSQL databases :

- VoltDB, This is essentially a standard relational database with all the unnecessary gubbins that has accumulated over 40 years of relational development thrown out so that this is a much leaner and meaner machine than its traditional counterparts. As a result it performs better and has a much smaller footprint than the merchant databases.

- Xeround. This is a cloud-based offering with elastic scaling and NoSQL roots. Like all the other NewSQL databases it is focused on transaction processing. Apart from its inherent capabilities, the other major differentiator for Xeround is that it looks like MySQL, which makes it easy for existing MySQL users to port into the cloud.


- NuoDB uses a distributed object architecture in a peer-to-peer environment that the company likens to BitTorrent. When you update a record you append the changes to the existing data rather than replacing it so you always have a historic data view of your database.

- JustOneDB is fully ACID compliant and is designed to support SQL. In its case, the environment looks just like PostgreSQL and it runs in the cloud on Heroku. However, it uses a completely different storage architecture that the company refers to as tunnel storage.

Another example newsql database :

- Hosted: Amazon RDS, SQL Azure, Database.com, Xeround, FathomDB,etc.

- Stand-alone: HadlerSocket, Akiban, Clustrix, Drizzle, GenieDB, ScalArc, CodeFutures, etc.
Shree Dandekar   Business Intelligence: The Big Picture   1/27/2012 11:36:49 AM
Re: NewSql databases?
NewSQL is a set of DBMS players promising to deliver the scalability and flexibility promised by NoSQL while retaining the support for SQL queries and/or ACID (atomicity, consistency, isolation and durability) transactions.

Although fundamentally both NoSQL and NewSQL are trying to solve the same use cases of providing scalability and performance on top of traditional DBMS's like MySQL.

Some examples of NewSQL: VoltDB, Clustrix, GenieDB.

The term was recently coined by the451group.
User Ranking: Blogger
Hospice_Houngbo   Business Intelligence: The Big Picture   1/26/2012 10:18:22 PM
NewSql databases?
What's NewSql and what advantage does it have over relational databases and NoSQL databases?


The blogs and comments posted on EnterpriseEfficiency.com do not reflect the views of TechWeb, EnterpriseEfficiency.com, or its sponsors. EnterpriseEfficiency.com, TechWeb, and its sponsors do not assume responsibility for any comments, claims, or opinions made by authors and bloggers. They are no substitute for your own research and should not be relied upon for trading or any other purpose.
Latest Blogs
Andrew Froehlich   5/22/2013   2 comments
One of the major benefits often touted by cloud service providers is the self-service portal. This is commonly presented as an easy-to-use, web GUI front end that allows end-users the ...
David Fletcher   5/22/2013   11 comments
In my previous blog post, I discussed some of my thoughts as we worked to implement a BYOD policy for the state of Utah. The implementation of the policy has helped us learn some things ...
David Fletcher   5/21/2013   5 comments
[Editor's Note: This is part of a series written by CIOs discussing their thought processes and lessons learned from major events in their tenures as CIO. Tomorrow we will post a companion ...
Aaron Weiss   5/21/2013   12 comments
CMOs and the CIOs enabling their activity need to ask themselves if the customer-facing mobile apps they are developing are worth the effort both from a cost perspective and a customer's ...
Ivan Schneider   5/20/2013   6 comments
In the prominent debate on "too-big-to-fail" banks, it has been suggested that diversified financial institutions have become too large and too complex to be safely managed. Various ...
Latest Archived Broadcast
Data visualization can make complex data easier to grasp. Our expert guest will talk about the hows, whys, and whats of bringing the big picture to your enterprise.
May 28th 2pm EDT Tuesday
On-demand Video with Chat
NBA CIO Michael Gliedman will tell us why the NBA decided to create NBA.com/stats
6/18/2013 -   Please join us for the "IT Convergence Strategies: Why, When and How " to learn more about: • 5 truths about infrastructure convergence today that go beyond the hype • How to exploit the 4 phases of convergence maximum efficiency and agility • Key milestones to plan for on the convergence journey • Why integrated management is a critical component of convergence plans • The importance of an open, modular approach, such as Dell’s active infrastructure, to building a converged data center
E2 IT Migration Zones
IT Migration Zone - UK
Application Audits Simplify Migration
Hardware Refresh Cycles Are Outdated
Office 365 Finds Fans
IT Migration Zone - FR
Windows Blue attendu en juin
Comment profiter d’une nouvelle expérience User Virtualization
S’équiper ou non d’un logiciel anti-virus ?
IT Migration Zone - DE
Leap Motion zeigt Gestensteuerung für Windows 8
Microsofts Surface Pro kommt nach Deutschland
Like Us on Facebook
Twitter Feed
Enterprise Efficiency Twitter Feed
Dell IT Insights
Dell Market Response Twitter Feed
E2 Linked-in Group Ad
Site Moderators Wanted
Enterprise Efficiency is looking for engaged readers to moderate the message boards on this site. Engage in high-IQ conversations with IT industry leaders; earn kudos and perks. Interested? E-mail:
moderators@enterpriseefficiency.com
Dell's Efficiency Modeling Tool
The major problem facing the CIO is how to measure the effectiveness of the IT department. Learn how Dell’s Efficiency Modeling Tool gives the CIO two clear, powerful numbers: Efficiency Quotient and Impact Quotient. These numbers can be transforma¬tive not only to the department, but to the entire enterprise.
Read the full report
The State of Enterprise Efficiency in the Virtual Era: Virtualization – Smart Approaches to Maximize Gains
Virtualization is a presence in nearly all enterprise data centers. But not all companies are using it to its best effect. Learn the common characteristics of success, what barriers companies face, and how to get the most from your efforts.
Read the full report
Informed CIO: Dollars & Sense: Virtual Desktop Infrastructure
Cut through the VDI hype and get the full picture -- including ROI and the impact on your Data Center -- to make an informed decision about your virtual desktop infrastructure deployments.
Read the full report
SPONSORED BY DELL
BRIEFINGS
CASE STUDIES
EBOOKS
PUBLIC SECTOR RESOURCES
VIDEOS
WHITE PAPERS
A Video Case Study – Translational Genomics Research Institute
e2 Video
On the Case
TGen IT: Where We're Going Next
7|11|12   |   08:12   |   10 comments

Now that TGen has broken new ground in genomic research by using Dell's storage, cloud, and high-performance computing solutions, the company discusses what will come next for it and for personalized medicine.
On the Case
Better Care Through Better Communications
6|6|12   |   02:24   |   12 comments

The achievements of the TGen/Dell project could improve how all people receive healthcare, because they are creating ways to improve end-to-end communication of medical data.
On the Case
TGen IT: Where We Are Now
5|15|12   |   06:58   |   5 comments

TGen is breaking new ground in genomic research by using Dell's storage, cloud, and high-performance computing solutions.
On the Case
TGen IT: Where We Were
4|27|12   |   06:45   |   10 comments

The Translational Genomics Research Institute wanted to save lives, but its efforts were hobbled by immense computing challenges related to collecting, processing, sharing, and storing enormous amounts of data.
On the Case
1,200% Faster
4|18|12   |   02:27   |   12 comments

Through their partnership, Dell and TGen have increased the speed of TGen’s medical research by 1,200 percent.
On the Case
IT May Improve Children's Chances of Survival
4|17|12   |   02:12   |   8 comments

IT is helping medical researchers reach breakthroughs in a way and pace never seen before.
On the Case
Medical Advances in the Cloud
4|10|12   |   1:25   |   5 comments

TGen and Dell are pushing the boundaries of computing, and harnessing the power of the cloud to improve healthcare.
On the Case
TGen: Living the Mission
4|9|12   |   2:25   |   3 comments

TGen's CIO puts the organizational mission at the heart of everything the IT staff does.
On the Case
TGen Speeding Up Biomedical Research to Save More Lives
4|5|12   |   1:59   |   8 comments

The Translational Genomics Research Institute is revamping its computing to improve speed, storage, and collaboration – and, most importantly, to save lives.
On the Case
Computing Power Helping to Save Children's Lives
3|28|12   |   2:13   |   3 comments

The Translational Genomics Institute’s partnership with Dell is enabling them to treat kids with neuroblastoma more quickly and save more lives.
Tom Nolle
VMWare & the Bicameral Model of MDM
5|22|13   |   2:14   |   No comments

VMware has a new solution to the MDM problem, two virtual phones inside a real phone, at least for Android phones. Currently limited to two models, the idea could expand and provide a way of letting companies harmonize their need to manage corporate use of phones while preserving BYOD.
Ivan Schneider
Clash of the Tableau 8: Release the Kraken!
5|17|13   |   2:42   |   No comments

Tableau 8 has some great data visualization and presentation capabilities, but it's best paired with a strong data analysis framework.
Tom Nolle
Using Virtualization – for Real!
5|13|13   |   2:10   |   2 comments

There's a lot of hype about virtualization of networks, NaaS, and SDN, but there's a couple of proven applications that enterprises could adopt right now and potentially save money and improve operations.
Tom Nolle
Is UC Becoming Oxymoronic or Just Moronic?
5|9|13   |   2:12   |   No comments

Skype/Outlook UC integration means we're going to have competition and fragmentation of UC client architectures, but is that bad? Modern devices can support IM, email, voice, and video clients, so maybe it's the back end of UC we need to be worried about.
E2 Editors
Windows vs. Integrated Circuit CPUs
4|17|13   |   4:45   |   5 comments

The editors make their predictions about what will win the next match-up in the E2 Tournament of IT Revolutionaries.
E2 Editors
Radio vs. Public Internet Access
4|17|13   |   4:34   |   14 comments

The editors make their predictions about what will win the next match-up in the E2 Tournament of IT Revolutionaries.
E2 Editors
Mainframes vs. Servers
4|17|13   |   4:34   |   16 comments

The editors make their predictions about what will win the next match-up in the E2 Tournament of IT Revolutionaries.
E2 Editors
TCP/IP vs. Printing Press
4|17|13   |   3:07   |   5 comments

The editors make their predictions about what will win the next match-up in the E2 Tournament of IT Revolutionaries.
E2 Editors
BYOD vs. E-Commerce
4|12|13   |   3:12   |   11 comments

The editors make their predictions about what will win the next match-up in the E2 Tournament of IT Revolutionaries.
E2 Editors
Telecommuting vs. Outsourcing
4|12|13   |   4:19   |   7 comments

The editors make their predictions about what will win the next match-up in the E2 Tournament of IT Revolutionaries.
E2 Editors
Personal Computer vs. Mobile Devices
4|12|13   |   4:28   |   20 comments

The editors make their predictions about what will win the next match-up in the E2 Tournament of IT Revolutionaries.
E2 Editors
Smartphones vs. Productivity Software
4|12|13   |   3:09   |   13 comments

The editors make their predictions about what will win the next match-up in the E2 Tournament of IT Revolutionaries.
Tom Nolle
There's More to Mobility Than the Mobile Worker
4|9|13   |   2:03   |   5 comments

Workers are now used to portable device support throughout their everyday lives. We should be looking at the policy of providing fixed-desk devices to support stationary workers. Could portable support be smarter?
Ivan Schneider
From Kim Jong-Un's Trackball to Nuance Voice Ads
4|5|13   |   3:21   |   9 comments

Input devices run the gamut, from the humble Missile Command-style trackball to advanced speech recognition. Unfortunately, these input devices can be used for evil as well as good. Case in point: mobile ads that want you to talk to them.
Tom Nolle
Data/Storage Wish List for Enterprises
4|3|13   |   2:19   |   1 comment

Enterprises want three things in storage systems: First is some speech-recognition way of capturing videoconference data for indexing; second is semantic/AI analysis of emails and IM for content indexing; third is a better system for managing hierarchical layers of storage.