Databases in the world

The following are the different Database Management Systems (DBMS) in the world.

DBMS	Company	From
4th Dimension	4D S.A.S	1984
ADABAS	Software AG	1970
Adaptive Server Enterprise	Sybase	1987
Advantage Database Server	Sybase	1992
Altibase	Altibase Corp.	2000
Apache Derby	Apache	2004
Asql	Marko Tasic	2009
Datacom	CA Inc.	---
DB2	IBM	1982
DBISAM	Elevate Software	---
Datawasp	Significant Data Systems	2008
ElevateDB	Elevate Software	---
FileMaker	FileMaker	1984
Firebird	Firebird project	2000
Informix	IBM	1985
HSQLDB	HSQL Development Group	2001
H2	H2 Software	2005
Ingres	Ingres Corp.	1974
InterBase	CodeGear	1985
LucidDB	The Eigenbase Project	2007
MaxDB	SAP AG	---
Microsoft Access	Microsoft	1992
Microsoft Visual Foxpro	Microsoft	---
Microsoft SQL Server	Microsoft	1989
MonetDB	The MonetDB Developer Team	2004
MySQL	Oracle Corporation(previously Sun)	1996
HP NonStop SQL	HP	1987
Omnis Studio	TigerLogic Inc	1982
OpenBase SQL	OpenBase International	1991
Oracle	Oracle Corporation	1979
Oracle Rdb	Oracle Corporation	1984
OpenEdge	Progress Software Corporation	1984
OpenLink Virtuoso	OpenLink Software	1998
Pervasive PSQL/Bitrieve	Pervasive Software	---
Polyhedra DBMS	ENEA AB	1993
PostgreSQL	PostgreSQL Global Development Group	1989
Pyrrho DBMS	University of Paisley	2005
RBase	RBase	---
RDM Embedded	Birdstep Technology	1984
RDM Server	Birdstep Technology	1990
ScimoreDB	Scimore	2005
SmallSQL	SmallSQL	2005
SQL Anywhere	Sybase	1992
SQLite	D. Richard Hipp	2000
Superbase	Superbase	1984
Teradata	Teradata	1984
Valentina	Paradigma Software	1998

What's New in Oracle 9i (New features in Oracle 9i)

The following new features were introduced with Oracle 9i:

Oracle 9i Release 1 (9.0.1) - June 2001

• Traditional Rollback Segments (RBS) are still available, but can be replaced with automated System Managed Undo (SMU). Using SMU, Oracle will create it's own "Rollback Segments" and size them automatically without any DBA involvement.
• Flashback query (dbms_flashback.enable) - one can query data as it looked at some point in the past. This feature will allow users to correct wrongly committed transactions without contacting the DBA to do a database restore.
• Use Oracle Ultra Search for searching databases, file systems, etc. The UltraSearch crawler fetches data and hand it to Oracle Text to be indexed.
• Oracle Nameserver is still available, but deprecate in favor of LDAP Naming (using the Oracle Internet Directory Server). A nameserver proxy is provided for backwards compatibility as pre-8i client cannot resolve names from an LDAP server.
• Oracle Parallel Server's (OPS) scalability was improved - now called Real Application Cluster (RAC). Full Cache Fusion implemented. Any application can scale in a database cluster. Applications don't need to be cluster aware anymore.
• The Oracle Standby DB feature renamed to Oracle Data Guard. New Logical Standby databases replay SQL on standby site allowing the database to be used for normal read write operations. The Data Guard Broker allows single step fail-over when disaster strikes.
• Scrolling cursor support. Oracle9i allows fetching backwards in a result set.
• Dynamic Memory Management - Buffer Pools and shared pool can be resized on-the-fly. Introduced sga_max_size parameter. This eliminates the need to restart the database each time parameter changes were made.
• On-line table and index reorganization.
• VI (Virtual Interface) protocol support, an alternative to TCP/IP, available for use with Oracle Net (SQL*Net). VI provides fast communications between components in a cluster.
• Build in XML Developers Kit (XDK). New data types for XML (XMLType), URI's, etc. XML integrated with AQ.
• Cost Based Optimizer now also considers memory and CPU, not only disk access cost as before.
• Automatic Segment Space Management introduced in Oracle 9.0.1
• PL/SQL programs can be natively compiled to binaries.
• A new SQL feature introduced in Oracle Database 9i, which allowing us to return values from DML, by using DML RETURNING clause. For example: INSERT INTO customers (...) VALUES (...) RETURNING cust_id into l_cust_id;
• Deep data protection - fine grained security and auditing. Put security on DB level. SQL access does not mean unrestricted access.
• Resumable backups and statements - suspend statement instead of rolling back immediately.


• List partitioning- partitioning on a list of values.
• ETL (Extract, Transformation, Load) Operations - with external tables and pipelining.
• Oracle OLAP- Express functionality included in the DB.
• Data Mining - Oracle Darwin's features included in the DB.
• DBA can specify a default temporary tablespace for the database.
• In Oracle9i, significant improvements have been made to materialized view refresh:
  • Fast refresh is now possible on materialized views that contain joins and aggregates even when base table data has changed using DMLs. In Oracle8i, fast refresh was possible, on materialized views that contain joins and aggregates, only if base table data was inserted using SQL*Loader direct path.
  • Fast refresh is possible after partition maintenance operations, such as TRUNCATE PARTITION, on tables referenced in the materialized view.
  • A new mechanism called Partition Change Tracking (PCT) has been introduced. This mechanism keeps track of the base table partitions that have been updated since the materialized view was last refreshed. This allows Oracle to identify fresh data in the materialized view.

Oracle 9i Release 2 (9.2.0) - May 2002

• Locally Managed SYSTEM tablespaces.
• Oracle Streams - new data sharing/replication feature (can potentially replace Oracle Advance Replication and Standby Databases).
• XML DB (Oracle is now a standards compliant XML database).
• Data segment compression (compress keys in tables - only when loading data).
• Cluster File System (CFS) for Windows and Linux (raw devices are no longer required).
• Create logical standby databases with Data Guard.
• Java JDK 1.3 used inside the database (JVM).
• New system privilege, "GRANT ANY OBJECT PRIVILEGE" is introduced to control the grant and revoke object privileges.
• Oracle Data Guard Enhancements (SQL Apply mode - logical copy of primary database, automatic failover).
• DBMS_XPLAN Introduced in Oracle 9.2, displays execution plans in EXPLAIN plan table.
• Security Improvements - Default Install Accounts locked, VPD on synonyms, AES, Migrate Users to Directory.

What's New in 10g...

First day in Job (@IDRBT)

It's 19th Jan 2006 ....

5 O'clock: Just got down in Secunderabad railway station from Narasapur Express, after spending joyful Sankranti holidays.
These are more jubilant days because I got job.
After 2 hours of sleep, make myself ready to go to Masabtank.

9 O'clock: I have reached IDRBT.
Stepped in, with so many hopes and anxiety ....

10 O'clock: I met HR person(Ashok).
One more guy (Naveen Chandra) also come to join on that day. We both introduced ourselves.
It took two hours to fill all the forms.

12 O'clock: Then Ashok introduced Rafi and he took us to INFINET where other new joiners were sitting (and eagerly waiting to work).

At the time of interview, I came to know Joseph and Krishna Prasad.
Here, I met new buddies Chinnapa Reddy, Unni Krishnan, Gaurav Sharma.
Gaurav Sharma was already started working.
We had round table conference (sorry...there were only chairs) for half an hour.

1 O'clock: Went to cafeteria, had delicious lunch.
Here I met two of our female mates Jhansi and Vani.
After discussing our interview experiences, we went to library, not to study, just to browse.
4 O'clock: Again went to cafeteria, had Tea and spent time in the lawn.
I went to library and sent a mail to all my classmates saying that I got job.

6 O'clock: First day of job is completed with soooo many certificates, forms, signs and handshakes.

This sweet journey has lasted for 21 months in IDRBT ... Thanks to all Buddies.

Database of Life

Make your life as deep as a database
Be always as unique as a primary key
Be productive as an index
Take others good habits as a foreign key....!!!

Share your joys with others as a cluster
Keep note of your activities as good as data dictionary
Grant some privileges to others as a role
Secure the things as a dba....!!!

Do the things in order as a rowid
Follow your resolution as strict as a sequence
Light others life as a trigger
Be prepared for the worst as an exception....!!!

Always be fruitful as a function
Forgive others as a rollback transaction
Always help others like checkpoint
Choose the best path like an optimizer....!!!

Project yourself the best like a view
Don't expect anything from others(procedures) and
Be thankful to god as a commit transaction...!!!