I am not a fundamentalist at any database, but I want to see differences between vendors.
For example, I mostly use Oracle and I think other (MySQL, SQL Server, PostgreSQL, ...) can not do this:
- < Li> query.
- Query. ORACL's Connect is a limited edition of the standard SQL recursive SQL. DB2 and MSS are very difficult for the UK iterative "Common Table Expression" code but provide more power than by Oracle's connectivity. (The next version of the Oracle database should be a real recursive SQL, though.)
Flash back is actually a unique Oracle feature that shows how deep the Oracle is built. In opposition to traditional pessimistic locking, how Oracle works with MVCC interaction; And concurrency handling is one of those places where there is a lot of difference between the database (though most DBMSs are just moving away from concurrency based on pessimistic locking). The fact is that Oracle is made firmly on MVCC, in my opinion, is an important advantage.
Regarding top results: All DBMSs have methods to do this.
In addition:
SQL-wise: Oracle has the most advanced and standard-collateral datetime handling. Oracle is strong on the OLAP-related work (but both of which are DB2 and MSSQL; OLAP functions are areas where Open Source DBMSes have some difficulty). Recently, Oracle has basically ignored the SQL standard, compliance with its standards is stabilizing (unlike MSSQL, for example, which has improved here); Due to the large market share of Oracle, I blame it on ego.
Conceptual: Examples of two different methods of disposing of Oracle and MySQL databases. In Oracle, it takes forever to create a database, and a database is a very heavy weight item, so in the Oracle world, several tables are included in a different "schema" in a database MySQL, The database is a very light weight item, so the mescalator has several databases that are comparatively lower in each of the tables (which is probably that they lack the schema. Do not complain rays).
Oracle (such as DB2) is an example of a DBMS, which includes almost the entire operating system: it exhibits many features, such as the files system of DBMS operating system such as DSDML / MISQL / PostGLSLL and Virtual Memory System Handle Personally, I like the latter approach, but Oracle's display is very much in the way of Oracle It does not matter if the operating system is being used.
Compared to MSSQL, Oracle runs on many platforms (like most other DBMSs; MSSQL is probably the only important DBMS that runs on only windows).
Oracle offers another method of clustering compared to most other DBMS: RAC. I've heard many horror stories about RAC, but if you can do it, it would be fair to say that you have a very powerful (and costly) clustering solution.
In relation to management, I oracle
Again, there are serious pricing differences, of course: the value of Oracle lot is high and growing is.
Comments
Post a Comment