50 Open Source Replacements for Proprietary Business Intelligence Software: Page 2

From simple spreadsheet applications to complete BI suites, the open source community has created dozens of applications that help enterprises store and analyze business data.


You Can't Detect What You Can't See: Illuminating the Entire Kill Chain

(Page 2 of 4)

13. DataCleaner

Replaces SnapLogic, Informatica

The "premier open source data quality solution," DataCleaner is useful for data profiling and DQ analysis, data cleansing, detecting and merging duplicates, and lightweight ETL tasks. It's also available in a commercial edition. Operating System: OS Independent.

Databases/Data Warehouses

14. Cassandra

Replaces Oracle NoSQL Database, Amazon SimpleDB

Used by Netflix, Twitter, Reddit, Cisco, Digg, eBay and many other companies with large, active data sets, Cassandra was developed by Facebook and is now managed by the Apache Foundation. Highly scalable, Cassandra has been known to hold more than 300TB of data in a cluster spread across more than 400 machines. Commercial support and services are available through third-party vendors. Operating System: OS Independent.

15. MongoDB

Replaces Oracle NoSQL Database, Amazon SimpleDB

Designed to support humongous data sets, MongoDB offers document-oriented storage with full index support. Project owner 10gen offers paid subscriptions with commercial support and additional features. Operating system: Windows, Linux, OS X, Solaris.

16. FlockDB

Replaces Oracle NoSQL Database, Amazon SimpleDB

Developed by Twitter, FlockDB is a distributed graph database that excels at storing social networking data. It was designed to handle massive horizontal scaling and high throughput. Operating System: OS Independent.

17. Hypertable

Replaces Oracle NoSQL Database, Amazon SimpleDB

Based on Google's Bigtable design, Hypertable offers NoSQL scalability that requires less hardware and less power than competing solution. Commercial support, training, and licenses are available. Operating System: Linux, OS X.

18. CouchDB

Replaces Oracle NoSQL Database, Amazon SimpleDB

Built for the Web, this Apache project offers document-based storage that you can access via HTTP with a browser. Key features include distributed scaling, eventual consistency, high availability, on-the-fly document transformation and real-time change notifications. Operating system: Windows, Linux, OS X, Android.

19. OrientDB

Replaces Oracle NoSQL Database, Amazon SimpleDB

OrientDB combines features of document databases and graph databases. Exceptionally fast, it can store 150,000 documents per second on standard hardware. Operating system: OS Independent.

20. MySQL

Replaces Microsoft SQL Server Standard

With a huge list of customers that includes Yahoo, LinkedIn, Alcatel-Lucent, Google, Nokia, YouTube, Craigslist, Sears and Zappos.com, Oracle-owned MySQL claims to be "the world's most popular open source database." It's available in multiple commercial editions as well as the free community version. Operating System: Windows, Linux, Unix, OS X.

21. PostgreSQL

Replaces Microsoft SQL Server Standard

PostgreSQL doesn't claim to be the most popular open source database, but it does claim to be the "most advanced." It's been around for more than 15 years and includes features like Multi-Version Concurrency Control (MVCC), point-in-time recovery, support for international characters, asynchronous replication, nested transactions (savepoints), online/hot backups, write ahead logging and more. Operating System: Windows, Linux, Unix, OS X.

22. Firebird

Replaces Microsoft SQL Server Standard

Now more than 30 years old, Firebird is a RBDMS with many SQL standard features. Key capabilities include excellent scalability, multiple platform support, multi-generation architecture, and logging and monitoring. Operating System: Windows, Linux, Unix, OS X, Solaris.

23. LucidDB

Replaces Teradata Database, Oracle, Microsoft SQL Server Standard

LucidDB claims to be "the first and only open-source RDBMS purpose-built entirely for data warehousing and business intelligence." It offers column-store tables, intelligent indexing, star join optimization, SQL support, intelligent prefetch and much more. Operating System: Windows, Linux.

24. HBase

Replaces Oracle NoSQL Database, Amazon SimpleDB

Managed by Apache, HBase is the distributed database used by Hadoop. Modeled after Google's Bigtable, it scales to billions of rows and millions of columns. Operating System: OS Independent.

25. Neo4j

Replaces Oracle NoSQL Database, Amazon SimpleDB

Neo4j calls itself the "world’s leading graph database" and claims to offer 1,000 times better performance than relational databases. The link above connects to downloads of the open source Community version; Advanced and Enterprise versions are available through Neo Technology. Operating System: Windows, Linux.


Replaces Oracle NoSQL Database, Amazon SimpleDB

Popular with telecom providers in Asia and Europe, Hibari is a distributed, linearly scalable, highly available, key-value, open source big data store. For commercial support, see Gemini Mobile. Operating System: OS Independent.

Page 2 of 4

Previous Page
1 2 3 4
Next Page

Tags: open source, business intelligence, BI, analytics

0 Comments (click to add your comment)
Comment and Contribute


(Maximum characters: 1200). You have characters left.



IT Management Daily
Don't miss an article. Subscribe to our newsletter below.

By submitting your information, you agree that datamation.com may send you Datamation offers via email, phone and text message, as well as email offers about other products and services that Datamation believes may be of interest to you. Datamation will process your information in accordance with the Quinstreet Privacy Policy.