Skip to main content

Top 5 Best Databases

As part of the contest we conducted recently, I got many comments from the TechProceed.com readers who choose their favorite database.

Based on this data, the top spot goes to.. MySQL


If you are new to any of the top 5 database mentioned here, please read the rest of the article to understand more about them.





1. MySQL




MySQL is used in almost all the open source web projects that require a database in the back-end. MySQL is part of the powerful LAMP stack along with Linux, Apache and PHP.

This was originally created by a company called MySQL AB, which was acquired by Sun Microsystems, which was acquired by Oracle. Since we don’t what Oracle will do with MySQL database, open source community has created several forks of MySQL including Drizzle and MariaDB.






Following are few key features:
  • Written in C and C++.
  • MyISAM storage uses b-tree disk tables with index compression for high performance.
  • Support for partitioning and replication.
  • Support for Xpath, full text search.
  • Support for stored procedures, triggers, views etc.,
Additional Information:

2. PostgreSQL





PotgreSQL is a open source object-relational database system. It runs on most *nix flavours, Windows and Mac OS. This has full support for joins, views, triggers, stored procedures etc.,

Following are few key features:
  • MVCC – Multi-Version Concurrency Control
  • Hot backups and point-in-time recovery
  • Support for tablespaces
  • Asynchronous replication
  • Highly scalable
Additional Information:

3. Oracle





Oracle is the best database for any mission critical commercial application. Oracle has following four different editions of the database: 1) Enterprise Edition 2) Standard Edition 3) Standard Edition One 4) Express Edition

Following are few key features of the oracle database.
  • Real Application Cluster (RAC)
  • Data Guard for standby database
  • Virtual Private Database
  • Automatic Memory, Storage and Undo Management
  • OLAP, Partitioning, Data Mining
  • Advance Queuing, XML DB, Support for Spatial data
  • Flashback Database, Query, Table and Transaction
Additional Information:

4. SQLite




SQLite does not work like a traditional client-server model with standalone process. Instead, it is a self-contained, server-less SQL database engine.
Main Features of SQLite:
  • Zero configuration with no setup or admin tasks.
  • Complete database is stored in a single disk file.
  • No external dependencies
  • Supports database of several TB in size
  • Work on most *nix flavors, Mac OS X, windows. It’s also cross-platform.
  • WinCE is supported out-of-the box
Additional Information:

5. Microsoft SQL Server

This is Microsoft’s flagship Database product. If you are stuck in a company that heavily uses Microsoft products, you might end-up working on MS SQL Server.

Labels:

Comments

Post a Comment

Popular posts from this blog

Ask a Question and get the best possible Answer!

What’s the best way to ask a question ? The easiest way to contact me about any computer problems or issues is via email. You can reach me via email at snehal [at] techproceed [dot] com. I will respond to as many emails as I can, but due to the large volume of emails that I recieve every day, there is no guarantee that I will get back to you.  If you have any other inquires, questions, comments, ideas, etc, feel free to fill the form given below and I will do my best to respond.  Submit an article to see it on Techproceed ! Are you interested to see your article on TechProceed for the benefit of IT community?  I believe that personally accessible technology is the foundation of humanity’s future. To that end I help people to understand and safely use personal computers and related technology so that they can do more, be more, grow more and connect more than ever before, and be an active participant in that future.  You could submit...
Read more

What's Hot

Ask Snehal AI The world's best virtual tarot This Virtual tarot that that can answer all kinds of questions. Questions about the present, the past, and your future. He can be a bit temperamental, requiring that each question be presented with a petition of "Snehal, please answer the following question" or "Snehal, please answer" before each question is asked. Failure to correctly petition will not bring results.    http://asksnehal.techproceed.com/        What's Hot ?                 This section provides a snapshot of what's on the public's collective mind by allowing users to view the fastest-rising searches for different points of time. It also highlights search terms that have suddenly become the most popular among the rest.  Following list is updated day by day, dynamically: Share Files of Any Size Online via Private Torrent in...
Post a Comment
Read more

How To Read Medium Articles for Free

I’m a regular Medium user and I read Medium articles almost every day. A few years back I didn’t have Medium membership—so, I had to find ways how to read Medium articles for free. I was able to find some ways to bypass Medium’s paywall system and read an unlimited amount of articles every day. I’ll share exactly how to read Medium articles for free in this article. Medium is a great blogging platform. This platform allows anyone to publish and read articles, but some of the articles on Medium are behind a paywall, which means they require a paid membership to read. Medium offers every user 3 free articles to read every month. That means you can read up to 3 articles that are published behind the Medium paywall. Stories that aren’t behind the Medium paywall are forever free to read. Here’s how to read Medium articles for free: You can read Medium articles for free by using the incognito mode of your browser, using extensions of Chrome, using the Telegram instant view from...
Post a Comment
Read more