Dear Readers,
My name is Franz Devantier, creator of this blog. I am an Oracle Certified
Professional (OCP DBA 11g) Security DBA.
I will be sharing with you the basic duties of an Oracle DBA, and also
some of the undocumented, and not so well known tasks.
General Database Support
When I talk about database support, I refer to support for a selection of the more popular databases.
Oracle has nearly fifty percent of the market, so I will talk mainly about Oracle. Behind Oracle we have DB2 and MS SQL-Server. You get DB2 for Windows as well, so there is really no excuse for not getting up to speed on DB2. MySQL and PostgreSQL is also quite popular these days.
We must not forget the smaller databases like MS Access, Clarion, and the small desktop DB's for smaller applications. Actually you can even set up a database in a spreadsheet if you want to. Perl is a good language to move data around a widely diverse environment, because it can access a large set of databases, from within the code.
However because Oracle has the market share, and is the most robust, and complex and I believe the best database on the planet; we will focus on Oracle. You will find that all of the concepts that we learn in Oracle are defined to some extent in many of the more elementary databases. SQL-Server/Sybase and DB2 are the closest behind Oracle from a technical point of view. After that with a few exceptions, the other database technology is far behind. So we are going to hang onto the most powerful, and most complicated Database on the planet, and then if we need to work on one of the others afterwards, it should not be too much of an adjustment.
Also keep in mind that companies should use the database that is most fitting for the application. For example if you are only going to be handing a few hundred records a month in a very small accounting system, then it would be a waist to buy an Oracle database for the purpose. A simple Access or Dbase type of database, or even a spreadsheet, may have fulfilled the purpose adequately. So I really believe in implementing the right technology for the Job, rather than the best that is available. So on some sites I would suggest that the community edition of MySQL is more than adequate; whereas on other sites I would recommend, that they budget for an Enterprise edition Oracle database, or even an Oracle Appliance, or a Exadata, Exalagic, or Spark Super Clusters. It all depends on what you intend doing with your database.
Franz Devantier,
Also keep in mind that companies should use the database that is most fitting for the application. For example if you are only going to be handing a few hundred records a month in a very small accounting system, then it would be a waist to buy an Oracle database for the purpose. A simple Access or Dbase type of database, or even a spreadsheet, may have fulfilled the purpose adequately. So I really believe in implementing the right technology for the Job, rather than the best that is available. So on some sites I would suggest that the community edition of MySQL is more than adequate; whereas on other sites I would recommend, that they budget for an Enterprise edition Oracle database, or even an Oracle Appliance, or a Exadata, Exalagic, or Spark Super Clusters. It all depends on what you intend doing with your database.
Franz Devantier,
Need a database health check?
Income
stabilizer (win-win opportunity)
Join the
carefully selected and tested cash-flow generating program below to potentially
create a long-term residual or annuity type income for yourself.
|
Traffic Wave - Free Report:
The report will give you all the information you need to start making a nice long-term
residual income for yourself.
|
