Cookies help us display personalized product recommendations and ensure you have great shopping experience.

By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    data analytics and truck accident claims
    How Data Analytics Reduces Truck Accidents and Speeds Up Claims
    7 Min Read
    predictive analytics for interior designers
    Interior Designers Boost Profits with Predictive Analytics
    8 Min Read
    image fx (67)
    Improving LinkedIn Ad Strategies with Data Analytics
    9 Min Read
    big data and remote work
    Data Helps Speech-Language Pathologists Deliver Better Results
    6 Min Read
    data driven insights
    How Data-Driven Insights Are Addressing Gaps in Patient Communication and Equity
    8 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: Positioning your Database Start Up for Data Warehousing
Share
Notification
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Big Data > Data Mining > Positioning your Database Start Up for Data Warehousing
Business IntelligenceData MiningData Warehousing

Positioning your Database Start Up for Data Warehousing

TonyBain
TonyBain
6 Min Read
SHARE

Guinness World Record 1PB Data Warehouse Achie...Image via Wikipedia

Contents
#1 Be Bigger, Faster & Cheaper#2 Be Smaller, Faster & Cheaper#3 Be Specialized

BI/Data Warehousing is an easier market to enter for new database platform vendors. This is for a few reasons. Firstly, most BI deployments are custom built projects for each organization. This means the ability to pick and choose various layers of the stack is much greater. 

Secondly, BI/DW projects success/failure metrics are often tied to database platform driven properties – performance, scalability, load times etc. The ability to stray outside any existing database platform “standards” to choose a platform that better meets key metrics is more tolerable.

More Read

Social Business By Design: Transformative Social Media Strategies for the Connected Company
The Dark Matter of Data
Revolution Analytics Hosts Contest on Business Predicting the Future
New data streams expose world’s hidden history
Data Warehouse “as a Service” – A Good Pick for Mid-Sized Companies

Thirdly, because the ratio of BI to OLTP is low, the associated impact of violating a corporate standard is much lower. With OLTP applications typically deployed in the hundreds or the thousands within the enterprise, lack of firm standards could end up with dozens of different database platforms requiring operational support, spread across hundreds of systems. On the other hand, violating the standard for a handful of DW systems is unlikely to turn into the management nightmare that would occur with the former situation.

The data warehouse database platform has been an area of heavy innovation and many …

Guinness World Record 1PB Data Warehouse Achie...Image via Wikipedia

BI/Data Warehousing is an easier market to enter for new database platform vendors. This is for a few reasons. Firstly, most BI deployments are custom built projects for each organization. This means the ability to pick and choose various layers of the stack is much greater. 

Secondly, BI/DW projects success/failure metrics are often tied to database platform driven properties – performance, scalability, load times etc. The ability to stray outside any existing database platform “standards” to choose a platform that better meets key metrics is more tolerable.

Thirdly, because the ratio of BI to OLTP is low, the associated impact of violating a corporate standard is much lower. With OLTP applications typically deployed in the hundreds or the thousands within the enterprise, lack of firm standards could end up with dozens of different database platforms requiring operational support, spread across hundreds of systems. On the other hand, violating the standard for a handful of DW systems is unlikely to turn into the management nightmare that would occur with the former situation.

The data warehouse database platform has been an area of heavy innovation and many newcomers have appeared over the last 5 years. If you are going to enter this space you better make sure you have your point of difference pitch really honed. 

In addition you should:

  • Ensure you are supporting standard interfaces (OLE-DB or ODBC).  Being the greatest data warehouse platform that your customers can’t write reports for isn’t going to be a great sell.
  • Ensure you are providing a good standard set of tools. Query tools, design tools, data loading/integration tools etc.  If you are small getting any of the third party tool vendors to pay attention to you is going to be difficult. Use compatible interfaces where you can to ease this but also make sure include your own support.

Strategies include the following.

#1 Be Bigger, Faster & Cheaper

At the top end of town, large data warehouses are getting larger. Multi TB data warehouses are common; PB and multi-PB are at the leading edge. But at the same time the response time requirements are getting smaller.

Horizontally partitioned, distributed, highly scalable database platforms are the only way to fulfill these requirements. Doing this on traditional platforms (Oracle, SQL Server, Teradata, DB2) can be difficult and/or costly. If you can make it simpler, while being scalable, faster & cheaper (cheaper licenses, less hardware, less difficult to deploy and manage) you’ll have a good story to tell.

Netezza, Greenplum, Vertica & Aster Data are examples in this group.

#2 Be Smaller, Faster & Cheaper

At the other end of the spectrum there are organizations that just want their report queries to run faster. They may not want to build a multi PB data warehouse, they may just have a few hundred GB of data and want snappy, easier report style queries to run quickly. Providing a simple, cheap database platform that is easy to implement and easy to migrate to means organizations can quickly start receiving bang for their buck.

Kickfire & Infobright are examples in this group.

#3 Be Specialized

Similar to what I spoke about in the Enterprise OLTP post, picking a specialization and focusing is always a good method for getting a foot inside the door (albeit in a limited initial capacity). Focusing on a specialization and packaging up your database platform with re-built tools applicable for that specialization can be a great way to out maneuver the competitors. Such examples of pre-packaged tools include reports, dashboards, alters and other analysis targeted towards that specialization. This can further save your customers time and money from removing the need to build such capabilities be-spoke.

Tenbase & SenSage are examples in this group.

Reblog this post [with Zemanta]


Link to original postInnovations in information management

Share This Article
Facebook Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

AI Document Verification for Legal Firms: Importance & Top Tools
AI Document Verification for Legal Firms: Importance & Top Tools
Artificial Intelligence Exclusive
AI supply chain
AI Tools Are Strengthening Global Supply Chains
Artificial Intelligence Exclusive
data analytics and truck accident claims
How Data Analytics Reduces Truck Accidents and Speeds Up Claims
Analytics Big Data Exclusive
predictive analytics for interior designers
Interior Designers Boost Profits with Predictive Analytics
Analytics Exclusive Predictive Analytics

Stay Connected

1.2kFollowersLike
33.7kFollowersFollow
222FollowersPin

You Might also Like

The Future of Soccer is in its Analytics

7 Min Read

Aligning Big Data

14 Min Read

A Big Cryptographic Boost for On-Demand BI and Extranets?

7 Min Read

Crossing the Language Chasm: Extracting Information from Foreign-Language Text

6 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

giveaway chatbots
How To Get An Award Winning Giveaway Bot
Big Data Chatbots Exclusive
AI chatbots
AI Chatbots Can Help Retailers Convert Live Broadcast Viewers into Sales!
Chatbots

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-25 SmartData Collective. All Rights Reserved.
Go to mobile version
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?