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
Mark Blackburn   4/23/2014   1 comment
The term "eating your own dog food" originated in a 1970s dog food commercial, but its use in the software business started with Microsoft in the late 1980s. The idea is that you use your ...
Andrew Froehlich   4/22/2014   20 comments
For those of us who study enterprise IT security, last year's Target store hack turned out to be a fantastic case study that was loaded with lessons to learn.
Brian Moore   4/21/2014   31 comments
Coming to a break room near you...
Sudha Nagaraj Bharadwaj   4/18/2014   13 comments
India will soon offer reliable, affordable, and efficient cloud services for the private sector through a unique government-private sector joint effort. With an eye on helping the micro, ...
Andrew Froehlich   4/16/2014   17 comments
With news that Google slashed the price of their big-data offering "Big Query" by up to 85 percent, one has to wonder if the move is to ward off competitors -- or simply that the ...
Latest Archived Broadcast
We talk with Bernard Golden about accelerating application delivery in the cloud.
On-demand Video with Chat
Register for this video discussion to learn how tablets can provide true business usability and productivity.
4/23/2014 - Dell Compellent performance and features make it an outstanding storage platform for SQL Server. Register for this webinar now.
4/29/2014 - Join Dell and Intel for an interactive discussion about implementing, refining and improving your virtual environment. Specifically we’ll discuss pain points virtualization can solve and those that it can create and how to prevent them.
E2 IT Migration Zones
IT Migration Zone - UK
Why PowerShell Is Important
Reduce the Windows 8 Footprint for VDI
Rethinking Storage Management
IT Migration Zone - FR
SQL Server : 240 To de mémoire flash pour votre data warehouse
Quand Office vient booster les revenus Cloud et Android de Microsoft
Windows Phone : Nokia veut davantage d'applications (et les utilisateurs aussi)
IT Migration Zone - DE
Cloud Computing: Warum Unternehmen trotz NSA auf die „private“ Wolke setzen sollten
Cloud Computing bleibt Wachstumsmarkt – Windows Azure ist Vorreiter
Like Us on Facebook
Twitter Feed
Enterprise Efficiency Twitter Feed
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
CASE STUDIES
EBOOKS
PUBLIC SECTOR RESOURCES
VIDEOS
WHITE PAPERS
WINDOWS SERVER 2012 RESOURCES
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
The Big Reason to Use Office

3|18|14   |   02:24   |   19 comments


Office and personal productivity tools come in a first-class and coach flavor set, but what makes the difference is primarily little things that most users won't encounter. What's the big issue in using something other than Office, and can you get around it?
E2 Editors
SPONSORED: Mobile Security — A Use Case

3|4|14   |   04:27   |   6 comments


New mobile security solutions can accommodate a wide array of needs, including those of a complex university environment.
Tom Nolle
Killing Net Neutrality Might Save You Money

1|16|14   |   2:13   |   11 comments


The DC Court of Appeals voided most of the Neutrality Order, and whatever it might mean for the Internet overall, it might mean better and cheaper Internet VPNs for businesses.
Tom Nolle
The Internet of Everythinguseful

1|10|14   |   2:18   |   19 comments


We really don't want an "Internet of Everything" but even building an Internet of Everythinguseful means setting some ground rules to insure there's value in the process and that costs and risks are minimized.
Tom Nolle
Maturing Google Chrome

12|30|13   |   2.18   |   25 comments


Google's Chrome OS has a lot of potential value and a lot of recent press, but it still needs something to make it more than a thin client. It needs cloud integration, it needs extended APIs via web services, and it needs to suck it up and support a hard drive.
Sara Peters
No More Cookie-Cutter IT

12|23|13   |   03.58   |   21 comments


Creating the right combination of technology, people, and processes for your IT organization is a lot like baking Christmas cookies.
Sara Peters
Smart Wigs Not a Smart Idea

12|5|13   |   3:01   |   46 comments


Sony is seeking a patent for wigs that contain computing devices.
Tom Nolle
Cloud in the Wild

12|4|13   |   02:23   |   15 comments


On a recent African trip I saw examples of the value of the cloud in developing nations, for educational and community development programs. We could build on this, but not only in developing economies, because these same programs are often under-supported even in first-world countries.
E2 Editors
SPONSORED: Is Malware Evading Your IPS?

11|18|13   |   03:16   |   4 comments


Intrusion prevention software is supposed to detect and block malware intrusions, but clever malware authors can evade your IPS in these five main ways.
Sara Peters
Where Have All the Mentors Gone?

9|27|13   |   3:15   |   38 comments


A good professional mentor can change your life for the better... but where do you find one?
Tom Nolle
SDN Wars & You Could Win

9|17|13   |   2:10   |   5 comments


VMware's debate with Cisco on SDN might finally create a fusion between an SDN view that's all about software and another that's all about network equipment. That would be good for every enterprise considering the cloud and SDN.
Ivan Schneider
The Future of the Smart Watch

9|12|13   |   3:19   |   39 comments


Wearing a bulky, oversized watch is good training for the next phase in wristwatches: the Internet-enabled, connected watch. Why the smartphone-tethered connected watch makes sense, plus Ivan demos an entirely new concept for the "smart watch."
Tom Nolle
Cutting Your Cloud Storage Costs

9|4|13   |   2:06   |   3 comments


Cloud storage costs are determined primarily by the rate at which files are changed and the possibility of concurrent access/update. If you can structure your storage use to optimize these factors you can cut costs, perhaps to zero.
Sara Peters
Do CIOs Need an IT Background?

8|29|13   |   2:11   |   23 comments


Most of the CIOs interviewed in the How to Become a CIO series did not start their careers as IT professionals. So is an IT background essential?
Ivan Schneider
The Internet Loves Birthdays

8|27|13   |   3:25   |   69 comments


The Internet has evolved into a machine for drumming up a chorus of "Happy Birthday" messages, from family, friends, friends of friends who you added on Facebook, random people that you circled on G+, and increasingly, automated bots. Enough already.