16 Sep 2008

About Oracle Tech and Apps

Hello again,

This time I want to write about something I learned after I got into
Oracle. Most people know Oracle by its database, which is still the
market leader until now. But, Oracle also has middleware (i.e. Oracle
Fusion Middleware), and a lot of application for various industries.
This segmentation follow the concept of "three-tier architecture",
which is a term for "database, application server, web browser / other
visualization".

Database is, well, you know, store whatever data you want to store,
mostly in tables. Oracle database also has some "enhancements" called
"Database Options". These database "enhancements" are optional
products, which if you "apply" it, your database can do more than just
storing and retrieving data. One example of this are functionality
such as clustering (called "Grid" by Oracle, another terms for
"running one database in a lot of computers").

Middleware is, for me, the most confusing one. In essential,
middleware is an application server. For example, you code some php
programs, and you put your files in a directory, in a computer which
runs a web server, that's a middleware (in the most simple form).
Middleware runs the logic on your code, accessing your data, and give
the data to your applications. Actually, some people like to think
that middleware is everything else which is not database or
applications.

Applications, is the one people interacting with. Most Oracle
Applications runs on web browser. Most Informatics Engineering major
people like me usually thinks application as a stand-alone software
that you can install such as PaintBrush, iTunes, or some other little
program that I code, etc. But in enterprise terms, application is a
big software, used by a lot of people, to access a lot of complicated
stuffs such as ordering stuffs from your supplier, generating
financial reports for tax, submitting data about a new employee, and
so on. Those applications runs somewhere in the company, accessed by
everyone with web browser, in real time (not so real actually,
sometimes it's very slow). In simple term, web application. For
applications, Oracle has application suite such as Oracle e-Business
Suite, JD Edwards, and PeopleSoft, and all those names comes with a
lot of modules inside, for many industries (from banks to factories to
mobile network providers).

That's all for now :)