1,105,380 Community Members

Database Handling

Member Avatar
nisbusiness
Newbie Poster
11 posts since Mar 2013
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 2 [?]
 
0
 

Which one is the most advance form of database?

Member Avatar
pritaeas
mod_pritaeas
11,309 posts since Jul 2006
Reputation Points: 1,420 [?]
Q&As Helped to Solve: 1,835 [?]
Skill Endorsements: 155 [?]
Moderator
Featured
Sponsor
 
0
 

PostGres, Oracle, SQL Server, MySQL for example. What are your requirements?

Member Avatar
IIM
Master Poster
742 posts since Jun 2011
Reputation Points: 163 [?]
Q&As Helped to Solve: 169 [?]
Skill Endorsements: 24 [?]
 
0
 

It depends on your requirement.

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

  • MySQL :- It is one of the most widely used open source RDMS.

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.,

  • 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

  • SQL Server:- If you are buliding microsoft apps then it will be better to go with SQL Server as there is quick support provided and performance is better of SQL Server with microsoft apps.
You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article