Data Warehouse Platforms Product Directory

This comprehensive PDF guide also features an introduction from expert William McKnight, who offers unbiased advice on selecting the right data warehouse platform for your business. McKnight explains his criteria for choosing the right data warehouse platform, discusses the advantages, disadvantages and differences of different data warehouse architecture types and reviews best practices for the data warehouse selection process.

Download the data warehouse platform product directory

This interactive product directory is a great resource for data warehouse platform vendor and product information. Whether you're just beginning the data warehouse evaluation process or looking to upgrade your data warehouse platform, you'll find valuable information about on-premise and on-demand data warehouse software from a variety of vendors in the data warehouse market.

Explore all of our data management product directories in the SearchDataManagement.com Product Directory Library.

Additional data warehouse platform resources:

Ask the Expert: DBMS and data warehouse help from Mark Whitehorn	Find data warehouse resources in a SearchDataManagement.com data warehouse tutorial
Inside the directory you'll find valuable advice on how to evaluate data warehouse platforms for your organization and choose the right tools for your business needs. For more data warehousing advice and tips, visit expert Mark Whitehorn's DBMS and data warehouse Ask the Expert section, where you can view a library of Q/As or submit a question of your own.	This data warehouse tutorial is is designed to help you evaluate, implement and manage data warehouse technology. Business and IT leaders will find best practices, technology recommendations and other advice for implementing sound data warehouse program.
Visit SearchDataManagement.com's data warehouse section	Discuss data warehousing with your peers on IT Knowledge Exchange
Our data warehouse topic section contains the latest news and information on data warehouse platform software and the data warehouse market. Find expert advice, news headlines, chapter downloads and more.	IT Knowledge Exchange and meet other professionals who are in the process of evaluating, deploying or using data warehouse platforms. IT Knowledge Exchange lets you ask or answer questions in extensive, topic-based IT forums.

Submit a product to the SearchDataManagement.com product directory

Is there a great product out there that you feel we should include in the data warehouse directory, or one of our other directories? Submit a product and we'll consider it for the next edition of our product directory. Already have a listing in one of our directories that you'd like to update? Send us an email. We're planning to launch a product directory every year for each of the following markets:

• Data quality product directory
• Business intelligence product directory
• Data warehouse platform product directory
• Master data management (MDM) platform directory

By William McKnight, President at McKnight Consulting Group

As companies consider their ability to manage the asset that is information, the data warehouse platform (and its database management system, DBMS) is the most important decision point. The platform is the foundational component of the tool selections, the consultancy hires, the architecture, etc. In short, it defines your information culture.

However, in selecting the platform to support the data warehouse, organizations are faced with an exponentially higher number of variations and distinct departures from the traditional online transactional processing (OLTP) database management systems than ever before.

Over time, data warehouse data volumes will continue to soar as history accumulates, syndicated data is collected and new sources with more detailed data are added. Furthermore, the community consuming the data continues to grow, expanding well beyond company boundaries to customers, supply chain partners and even the Internet. Companies need to make sure they choose a proven platform not just for the initial, known requirements but also with the ability to scale to future, to-bedetermined requirements.

Data warehouses, to be successful, need to provide:

• Quality data that is available.
• Architectures that provide low long-term total cost of ownership.
• Good query performance that results in increased interactive usage.
• The ability to get to real-time feeds.
• A platform to support mixed, unpredictable workloads.
• A scalable path forward as data needs grow.

Criteria for data warehouse platform selection
The decision process should go well beyond the usual consideration of the operational DBMS vendor. Today, that decision can be nuanced along several potential requirements, including:

• Active loading of data and immediate access to loaded data.
• A mixed workload upon the data.
• The immediate availability of information.

Read the rest of William's column by downloading the data warehouse platform product directory.

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Data warehouse software Why pay for a data warehouse appliance when you can get one free? In-database analytics pulls together SAS, data warehouse vendors Teradata takes a logical approach to data warehousing appliances BT taps open source BI software, homegrown DW to unlock customer data Bill pushes for data warehouse, XBRL to track TARP funds Teradata VP talks data warehouse appliances, reveals cloud and SSD plans Commodity hardware aiding data warehouse appliance performance, costs What does MapReduce and in-database technology mean for data warehouses? Columnar databases, appliances, cloud computing top BI trends Greenplum brings data warehousing in the cloud indoors Database management systems (DBMS) architecture and design Definition of primary, super, foreign and candidate key in the DBMS What is the difference between a logical and physical warehouse design? What are some emerging data warehouse and DBMS trends? Designing for performance: Strategic database application deployments An introduction to database transaction management Database access security: network authentication or data encryption? Static SQL vs. dynamic SQL for database application performance Executing SQL statements using prepared statements and statement pooling How to get data/database independence with a three-tier architecture How to select an MPP database: DB2 vs. Teradata Enterprise data architecture best practices Advantages and disadvantages of XML shredding How to shred XML with the DB2 XMLTABLE function Shredding XML docs into relational tables with annotated XML schemas Teradata takes a logical approach to data warehousing appliances Examples of single and bulk XML shredding of XML documents What is the difference between a logical and physical warehouse design? What are some emerging data warehouse and DBMS trends? Teradata VP talks data warehouse appliances, reveals cloud and SSD plans Selecting ODBC functions for optimized SQL statements Guidelines for managing data updates to optimize ODBC performance

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary data modeling  (SearchDataManagement.com) extract, transform, load  (SearchDataManagement.com) OLAP  (SearchDataManagement.com) tree structure  (SearchDataManagement.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary