SHARE
Facebook X Pinterest WhatsApp

IBM DB2 or Other RDBMS Can’t Solve All Data Management Problems

Jun 1, 2010

Not all data management problems can be solved by a relational database, particularly when it involves giant sized chunks of data. IBM saw this and began offering a package of services called BigInsights Core that is based on Apache’s open source Hadoop. Hadoop, designed to filter, sort, and manage structured or unstructured data on a large server cluster, is comprised of two distributed systems:

  • Map/Reduce, a system that knows where data is stored on disks throughout the cluster and where the nearest processor to it is. When it comes time to sort or filter the data, it can give the orders to call up the data from disk in large chunks of 64 or 128 megabytes and move it to nearby processors.
  • And HDFS, or Hadoop File System, that knows how to distribute the data across a cluster in the first place.
  • After Hadoop has done its work, it’s possible for data warehouses, business analytics systems and relational databases to work with a more manageable results set.

Recommended for you...

Best Certifications for Database Administrators
Ronnie Payne
Oct 14, 2022
Become More Efficient at Writing TSQL by Creating Code Snippets
Gregory Larsen
Jun 30, 2021
Line Numbers in SQL Server Management Studio
Gregory Larsen
Sep 4, 2018
Couchbase Raises $60 Million to Fuel NoSQL Database Efforts
Sean Kerner
Jun 30, 2014
Database Journal Logo

DatabaseJournal.com publishes relevant, up-to-date and pragmatic articles on the use of database hardware and management tools and serves as a forum for professional knowledge about proprietary, open source and cloud-based databases--foundational technology for all IT systems. We publish insightful articles about new products, best practices and trends; readers help each other out on various database questions and problems. Database management systems (DBMS) and database security processes are also key areas of focus at DatabaseJournal.com.

Property of TechnologyAdvice. © 2025 TechnologyAdvice. All Rights Reserved

Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.