Best IT Recipes

Why are you using an Oracle database?

I am curious for technical reasons why you are choosing an Oracle database compared to the latest options:
1) Microsoft SQL Server
2) MySQL
3) PostgreSQL

What features or functionality justify the extra cost. I'm interested in technical arguments, not religious war. A friend asked me about this, and I always used one of the ones I listed 3. I did not know enough about Oracle Databases to offer my opinion.

Thank.

+81
comparison database oracle
Feb 11 '09 at 13:25
source share
8 answers

No one seems to be talking about the time cost of developers working with Oracle. Most developers who know any other db hate Oracle, those who do not assume that all DB and / or ORM tools are hard to use.

Sybase is also rarely mentioned. Choose any major investment bank and ask them what their main database is - Sybase will be represented in the vast majority. It is reliable (if not all of them cast it like a stone), fast (of course, with Sybase15), and it is extremely difficult for developers to work - time is money and paid developers to spend time on Oracle also delays the release date for new features.

If I started a business that I thought would scale to Amazon's proportions, I could consider BigData solutions, otherwise I would choose Sybase or SQL Server for Oracle every time. I say this has been working (like dev) with Oracle for 2 years now - its RUBBISH!

+31
Jan 04 '13 at
source share

Only Oracle and Microsoft SQLServer are closed, and when something goes wrong and you have a problem, the answer is just a phone call (and cash if the rate). In any case, MySQL and PostGre have several consulting services for enterprises, but in the end, these consultants are not really compatible with the product, because the product belongs to everyone. This is great because you can enter and correct code if you are well versed in C and relatively low-level programming, but if you do not find a solution, it may become a wild goose chase.

Now, since not everyone is qualified enough, and those companies that prefer money, prefer the security (in the business sense) of closed-source databases, the reason that these solutions have not gone out of business, in addition to the fact that their implementation are durable and cost money if you have one.

Now, finally, the most important difference between SQLServer and Oracle, and this difference is the OS, most users using Windows will adhere to, you guessed it, SQLServer, but if you work with flavors of Unix Oracle, this is your closed source solution In any case, I use Oracle in Solaris, but if our goal was Windows, I would probably use SQLServer, because both products are strong, but I believe that Microsoft has some special tricks under the hood to get maximum performance on the windows.

+27
Feb 11 '09 at 14:03
source share

Just to name a few:

  • Oracle Real Application Cluster - Provides Advanced Clustering Features
  • Oracle Data Guard - briefly provides physical and logical backup functions.
  • Oracle Exadata - implements storage with database support (which can filter predicates, filter projection columns, handle joins, speed up table space creation). The solution comes with HP servers, a full 24/7 warranty, and other nice things. This is pretty good for data-intensive applications (for example, by creating independent table space creation).
  • Oracle virtualization

And, of course, the magic of the brand;)

And when it comes to choosing an RDBMS? Usually the choice is pretty obvious - Oracle or the rest of the world. After that, you can narrow down your choices:

  • platform (Windows only)
  • weight (sqlite, MySQL, PostgreSQL, ...)
  • budget (initial cost of license, service + cost of support)
  • development prospects, for example:
    • Oracle Express → Oracle
    • SQL Server Express -> MSSQL
  • business prospects - a “safe, well-known product” or an open source product (pay attention to the quote around the first phrase). Another post tends to delve into this aspect.
+6
Feb 11 '09 at 13:33
source share

The real question is: which application will be used to use RDMS. You certainly don't need an oracle for your wordpress blog or twitter clone. But if you want to do serious business analysis, then Oracle may have some features that can help do this more efficiently than others.

Ms sql server is also very good, it has many functions. If you are on Linux and you need a database with the functions offered by ms sql, then the oracle would be a good choice.

+4
Feb 11 '09 at 13:40
source share

I think because Oracle was the first RDMS to support " sharding "

+3
Jan 6
source share

The costs of SQL Server and Oracle are not so far apart.

In fact, for small systems, the cost of Oracle vs Your Favorite Free Database is between zero (Oracle Express Edition) and not very large ($ 5,800 perpetual processor for Standard Edition One).

Here is a link to the features of various editions in 11g: http://www.oracle.com/database/product_editions.html .

List prices are available for all territories at http://store.oracle.com - usually large companies do not pay retail, of course;)

+2
Feb 11 '09 at 2:02
source share

Is the Oracle website justified? http://www.oracle.com/database/index.html has many reasons.

Also see http://www.learn.geekinterview.com/database/oracle/advantages-of-using-oracle.html

-7
Feb 11 '09 at 13:35
source share


More articles:


All Articles