background preloader

Databases

Facebook Twitter

Oracle Airlines Data Model. HadoopDB Project. DR@Y Database Research at Yale University HadoopDB is: A hybrid of DBMS and MapReduce technologies that targets analytical workloads Designed to run on a shared-nothing cluster of commodity machines, or in the cloud An attempt to fill the gap in the market for a free and open source parallel DBMS Much more scalable than currently available parallel database systems and DBMS/MapReduce hybrid systems.

HadoopDB Project

As scalable as Hadoop, while achieving superior performance on structured data analysis workloads For more detail, check out the DBMS Musings blog post, or the paper below. The Paper: HadoopDB: An Architectural Hybrid of MapReduce and DBMS Technologies for Analytical Workloads. News: Here is the latest paper on performance enhancements in HadoopDB published at SIGMOD'2011. Press: Links: Get HadoopDB Now! Project Members Contact E-mail Kamil Bajda-Pawlikowski, Azza Abouzeid, Daniel Abadi, or Avi Silberschatz ({kbajda, azza, dna, avi}@cs.yale.edu) for questions or comments. Database Trends and Applications. SQL Server Connectivity. Embedded databases for real-time, embedded systems – eXtremeDB in-memory database, Perst Java and C# database, SQL, XML. Database Performance Popcorn Samples. 25+ Alternative & Open Source Database Engines. Almost every web developer has a favorite database that he/she feels comfortable working with as all the tricks & gimmicks are already experienced.

25+ Alternative & Open Source Database Engines

It can be one of the popular databases below: or even simpler ones like XML, text, etc. It is understandable why these databases are frequently used; they are well-documented, have a community behind them, integrated with most popular CMSs', easy-to-use, offered by most of the hosting companies ,etc.. But there are also many other databases which are getting popular day-by-day & may have advantages over what you're already using. Here are 25+ open source alternative databases that you may consider using in your next project: MongoDB It is an open source, high-performance, scalable, schema-free & document-oriented (JSON-like data schemas) database. There are ready to use drivers for most popular programming languages like PHP,Python, Perl, Ruby, JavaScript, C++ + more.

Hypertable Apache CouchDB Neo4j Neo4j offer a massive scalability. Riak Memcached Redis. MongoDB. LucidDB. LucidDB is the first and only open-source RDBMS purpose-built entirely for data warehousing and business intelligence. It is based on architectural cornerstones such as column-store, bitmap indexing, hash join/aggregation, and page-level multiversioning. Most database systems (both proprietary and open-source) start life with a focus on transaction processing capabilities, then get analytical capabilities bolted on as an afterthought (if at all). By contrast, every component of LucidDB was designed with the requirements of flexible, high-performance data integration and sophisticated query processing in mind.

Moreover, comprehensiveness within the focused scope of its architecture means simplicity for the user: no DBA required. Still wondering why you might want to spend time trying out LucidDB when the open-source DBMS field is already crowded with so many good horses?