Some considerrations about Oracle
We often opposed Windows and Linux / Unix and many questions arise when choosing a database. Each system has its advantages and disadvantages and Oracle has the main advantage of being perfectly integrated with Windows.
We often opposed Windows and Linux / Unix and many questions arise when choosing a database. Each system has its advantages and disadvantages and Oracle has the main advantage of being perfectly integrated with Windows. This full integration exploits the most advanced Windows features. Oracle's main strength is the portability of its database. Today, there is a group of some machines that Oracle prioritizes. Windows is one of them, as well as Linux, HP / UX (Hewlett Packard), Solaris (Sun) and Aix (IBM). That is to say that any release of a new version of Oracle will be synchronized as a priority for all of these platforms.
Oracle 10g: One technological strain
What is important is that all these versions are from the same technological strain. All functions available to developers for one of these versions can be found in others. It is worth to talk about the Oracle porting on different machines, because, to equivalent version number, they are the same products. This offers great advantages because it allows you to::
• have a single database for personal development, a working group or the entire company;
• to support projects ranging from simple, requiring little power, to more complex, which requires a lot;
• Use the right machine at the right place according to your needs, your budget, with a suitable power;
• Use Oracle with the operating system that you are familiar;
• authorize a flexible architecture, incorporating different technologies (client-server, Internet, Java, etc)., United by a single database;
• meet the technological choices of firms in ensuring consistency around the database;
• changing the operating system that hosts databases without jeopardizing applications
Why not a standard database like Microsoft Access
The question is legitimate, why not prefer a database like Microsoft Access compared to Oracle?
The main drawback of Microsoft Access (or more generally of this type of bases) is that with every use of the entire database it is the whole database that is transferred to the client. In addition, there is data locking at each update, which often block other users.
The strong point of Access is its integration: data management, development tools, creation of editions. Easy to use for small configurations (few simultaneous users low volume, low transaction), this type of database should be limited to this use.
Why not a "free" Database?
Excellent "free" databases exist. The LAMP platform (Linux, Apache, MySQL, PHP) has popularized MySQL. Other database, such as SQL Lite (which now supports PHP), Postgres, etc.., can compete with oracle on some points.
Some comparatives place at the same technical level the free databases and Oracle. This is partly true for Postgres, but other database are technically far behind Oracle.Does this mean that we must neglect them? They are often excellent choice for storing data from a front-end Web and costs to have a MySQL database in a hosting company have nothing to do with those needed to host an Oracle database.
Another limitation of free software: software publishers have developed their applications with a stable base, mature, widely used in companies: Oracle.
It will take a complete overhaul of their software to change their database. Again, they will choose a free base if it offers all the guarantees (performance, functional range, technical support, etc.). that customers expect.