We help IT Professionals succeed at work.

Few simple questions about oracle and D2k

raghav3 asked
Hi all
Here are few general questions about oracle and D2k
1. What is diff between Oracle and MS Access?
2. How good is Oracle compared to any other database?
3. Diff between Oracle 8 and earlier versions?
4. How good is D2k compared to VB or any other front end?
5. What is Relational Database?

Pls give me the accurate answers.
Watch Question

To answer some of your questions
The difference between Oracle and MS Access is massive. If you are going to have more than a few concurrent users at a time then don't touch MS Access with a barge pole. For instance Access doesn't handle locking well. While one user updates a record the entire table(file) is locked, preventing all other users from updating any records in that table. Oracle however uses record locking, so the other users can update other records in the same table.

My experience is virtually all Oracle. I've come across MS Access, Fox Pro, Sybase, Ingres, Informix, DB2, SQLServer and none of them have given me a reason to change my career path from moving from Oracle.

3) Oracle 8 started to introduce object features as well as many others. I'd suggest 8.1.7 to start with, it's an improvement on 7.x. I only got my hands on 9i last week for NT so I cannot comment on that yet.

4) Developer is good in that you can quickly knock up some very complex forms and reports in it, but I have to admit that VB has greater flexability. Now where I work we're deploying new systmes via the web, so it's going towards a combination of COM, ASP, VB and IIS.

There are many books on relational design and I'm sure there's loads of better answers here on this very site, but basically the data is denormalised. Data is treated and stored as enities and the relationship between these enities.


There are books written about all these questions. Let me try to briefly explain.

1. Oracle is just better in multiuser environment. If I am not mistaken access get's often corrupted and is limited to 1GB. Access is good for single user or a small workgroup.

2. In big enterprises Oracle databases have often a very good reputation (security,reliablity,....) . However DB2 and SQL-SERVER from microsoft are getting closer, also because of a lower costprice from sql-server. Oracle however runs on a lot more operating systems (VAX,UNIX,WINDOWS related) than sql-server does.

Also read this : http://www.networkcomputing.com/608/608robertson.html

3. Some new key functionality in 8 : working with objects, patitioned tables, enforcing contraints, usage of instead of triggers, idex-organised tables, index partitions, parallel DML, ......

also look at www.oracle.com

4. D2K ??

5. A type of database management system (DBMS) that stores data in the form of related tables. Relational databases are powerful because they require few assumptions about how data is related or how it will be extracted from the database. As a result, the same database can be viewed in many different ways.

An important feature of relational systems is that a single database can be spread across several tables. This differs from flat-file databases, in which each database is self-contained in a single table.

Almost all full-scale database systems are RDBMS's. Small database systems, however, use other designs that provide less flexibility in posing queries.


The info is not sufficient. D2K means Developer2000

Oracle Forms / Reports / Graphics hasn't been called "Developer 2000" for years.
It was renamed to "Developer", then became part of the "Oracle Internet Developer Suite", which has now been renamed to "Oracle9i Developer Suite"

Components of Oracle9i Developer Suite are
*) Oracle Designer including Oracle Software Configuration Manager (Oracle SCM)
*) Oracle Forms Developer
*) Oracle JDeveloper including Oracle Business Components for Java.  
*) Oracle Reports Developer
*) Oracle Discoverer
*) Oracle Warehouse Builder.

Just don't ask me to explain Oracle's naming standards !!!
Top Expert 2008

Question 3:
On Oracle 7.3 and Oracle 8 did not suport Internet, HTML, JAVA, XML, those tools began to be supported
with Oracle 8i and 9i (i = Internet)

On Oracle 7.3 is a nice DB, but you did not support table partitioning, index partitioning, a lot DB
parameters have to be set and restart the DB, you have objects option (on entreprise versions only)and
the large objects was up to 2GB

On Oracle 8 can support bitmap index, table partitioning, index partiotiong, advanced replication, reverse
index, advanced security, and large objects (up to 4GB) objects option (on entreprise versions only,
the parameters are set but you have to restart the DB there are some diferences on rowid  from the older

On Oracle 8i supports all from the others versions plus internet, it's more easy to manage large objects
with more size, there are some diferences on rowid from the older version.

On Oracle 9i support Internet integration, it's more "inteligent" DB, it can be auto tune, supports
the application server (before were sold separtly), almost all the DB parameters can be set without
restarting the DB

This is a litle of the main diferences from all the versions.

For more information you can visit www.oracle.com or technet.oracle.com

Be aware that Oracle issued a desupport notice on Oracle 8.0.5 last year.
Product:                             Oracle8, version 8.0.5
Error Correction Support ends on:     June 30, 2000
Extended Assistance Support ends on:      June 30, 2003
This means any errors found in 8.0.5 since June last year are not going to be fixed. All support stops in June 2003.
Error correction support for Oracle8, Release 8.0.6 is also scheduled to cease on 30 September 2001.
It appears Oracle are pushing people to use 8.1.7 at the moment, though the experts think 8.1.6 still has life in it!

Why Move to Oracle9i Database:
Oracle9i Database will support the second wave of the internet revolution into the wireless world. It is a leap past the technology of Oracle8i, not only in Java support but also in both scalability and recoverability.

Clustering technology is finally here, allowing you to scale dynamically and instantly (Compaq's True 64-bit).
You can change table storage, index operations, analyze tables and indexes, change partitions, and add partitions while the database is in use, minimizing downtime.
Oracle9i Database provides the options for trial recovery as well as resumable recovery, minimizing recovery time.
Oracle9i also lets you perform block-level recovery, maximizing availability.
You can change data cache and shared pool without database restarts, increasing performance. For example:
To read Rich Niemiec's Oracle OpenWorld presentation "Performance Tuning for the Expert," go to http://www.tusc.com/oracle/
db_block_buffers becomes db_cache_size
buffer_pool_keep (recycle) becomes db_keep_cache_size

You can use multiple block sizes?for example, small block sizes for systems with heavy transaction processing and large block sizes for data warehouses:
db_block_size (main cache uses this block size)
db_2k_cache_size, db_4k_cache_size... db_32k_cache_size
(specify these)

You can perform system-managed undo instead of using rollback segments, saving maintenance time:
undo_management, undo_tablespace, and undo_retention
(be careful setting these).

Why Move to Oracle9i Application Server:
Oracle9i Application Server is a completely different product from Oracle Application Server, and it's a full two orders of magnitude faster. Oracle9iAS uses the Apache listener, whereas OAS used the SpyGlass listener. The new listener is more than 100 times faster than OAS. For example, during my testing, Oracle9iAS processed 2,300 pages per second, compared to OAS at 50 pages per second and Oracle Application Server at 200 pages per second. And Oracle9iAS with HTTP 1.1 (Internet Explorer 5.0 and higher, or Netscape 4.7 and higher) processed 5,200 pages per second. Your times may vary, but you can expect substantial improvements.
In addition, Oracle9iAS has the latest version of Oracle Portal, providing browser-based access to everything and giving you the ability to consolidate your Web sites.

And finally, Oracle9iAS has Web-page and table caching.
Top Expert 2008

Question 2:
The big three are considered:   ORACLE, DB2 & SQLServer

There are a number of good sources:

1)   GartnerGroup  -- IT industry research group --   (pay service)   www.gartnergroup.com

several good papers:
*   Database Management Systems: Software Comparison
   16 October 2000
   Scott Beall , Robert Hodges
   Database Management Systems category contains database applications ranging
   from the personal desktop to comprehensive enterprise solutions; covers simple,
   dictionary driven, hierarchical, relational and object oriented database types that
   enable individuals, workgroups, enterprises, or consortiums of enterprises to access,
   manage and distribute information. Each software profile is presented in a concise
   format with specifications supplied by the vendor, and a brief text description.
   These profiles do not provide ranking or rating information, and they are intended
   as a starting point for software product research.

*    2000 Database Management Systems Software Market
    21 June 2001
    Colleen Graham
    Gartner Dataquest's 2000 Database Management System Software Worldwide
    market statistics is the first in a series of reports presenting the statistics for the
    information management software market worldwide. This report presents a DBMS
    market share survey overview, research metric definitions, regional definitions,
    product definitions, exchange rate definitions and DBMS vendor revenue for new
    license sales for the years 1998 to 2000 by market segment and geography.
    Statistics for data warehouse software and business intelligence software will be
    published separately.

*    DBMS Market Shares
    3 July 2000
    Betsy Burton , Jon Rubin , Norma Schroder
    Driven by e-commerce, data warehousing and packaged applications data
    requirements, the DBMS market grew 18 percent in 1999. The fastest-growing
    relational segment accounted for more than 75 percent of the $8 billion total.

#1   Oracle  with  31.1%
#2   IBM DB2  with 29.9
#3   Microsoft  with 13.1%
#4   Informix   with 4.3%
#5  Sybase  with 3.3%
The remaining 18.3% is divided up among vendors having less than 2% shares..

2)    MetaGroup   --  another IT industry group   --  (pay service)  www.metagroup.com

I would look at Oracle or DB2,  lastly possiblely sqlserver

Oracle & DB2 comprise most of the RDBMS market,  followed only by SQLServer...  (apx 80%+ of the market)

So in the basic questions:
How will  technologies and architectures evolve to manage increasinglydemanding transactional workloads?
How scalable and availabile is the database engines under transactional workloads?
How will DBMS scalability and availability be impacted by the choice of packaged applications?
How will RDBMS products scale on the majorhardware  platforms?

There is a criteria I use for evaluating a database:
1. Platform scalability & Portability    --  are you locked into on OS & Platform (such as windows & 
2. Extensibility--  such as internal supprt
3. Very large user populations support (concurrently)
4. Very Large Database   (terabyte+ support)
5. Very high availability    (7x24 operations)
6. Support long term --  from both vendor & ability to get in-house support people...

Oracle & DB2  are pretty much platform indendant, they both have excellent records for supporting  both
large amounts of data & very large user populations.
Most major third party packages are written for them , so porting issues are reduced.
They both have very extensive features (such as java internal to the database, etc etc)
The long term support issues are a big key --  especially from a position of enlightened self interest
From the developer perspective:
easier for the user to move around in the job market when the  platform is one of the more common..

From the Company perspective:  
easier to find support people to hire....

Also -- it depends upon the industry and shop you want to work for:
want to work in small to midsize shops -- probably sqlserver
Banking & Insurance -- probably  db2
pharmaceuticals & areospace -- probably oracle...
Top Expert 2008

Question 4:

Developer 2000 (Forms, Reports, Graphics) are DB-centric RAD (Rapid Aplication Development Tools). They give the programmers the possibility easy and prompt to create Oracle (and via ODBC other DBMS) applications. They have also:
1. Integrated Project Builder which gives the possibility to maintain and transfers projects
2. Forms server and Reports server which can be used to deploy Forms and Reports on the WEB (it seems that Forms on the WEB are appropriate only for backoffice aims).

BUT it is not easy to learn Forms and Reports. It takes at least 4 months to become Forms/Reports programmer. The Developer/2000 track on OCP (called OCP application developer, OCP Internet application developer - I have both OCP certificates) is the hardest OCP track. The DBA track is also complex, but not so hard as these. So think before dive in Forms and Reports.
Top Expert 2008

Question 1:
Oracle and Access can not be compared at all.

Oracle is Data Base. MS Access is much more like a file processing system with some features of a database. And this manifests in the prices.

Oracle is robust, fault-tolerant, scalable, multi-user, multiplatform Data Base Management System for medium and big enterprises.

Access is for SOHO (small office/Home Office) applications


Good coverge!

Explore More ContentExplore courses, solutions, and other research materials related to this topic.