Why Banks or Financial Companies prefer Oracle than other RDBMS for their “Core” systems? - OracleConnections2024-03-28T17:25:10Zhttp://www.oracleconnections.com/forum/topics/why-banks-or-financial-companies-prefer-oracle-than-other-rdbms?groupUrl=oracle-financial&feed=yes&xn_auth=noAny corporate entity has more…tag:www.oracleconnections.com,2014-01-24:6612035:Comment:457322014-01-24T08:10:02.653ZChere Drainhttp://www.oracleconnections.com/profile/ChereDrain
<p>Any corporate entity has more measures in paperwork, <em>(From 1Tc to R2D2)</em> to fill out, and get approved when changing <em>working solutions</em> than buying a house.</p>
<p>So if the environment you are talking about was using Ms Access, you would find it hard to convince them to change.</p>
<p>Any corporate entity has more measures in paperwork, <em>(From 1Tc to R2D2)</em> to fill out, and get approved when changing <em>working solutions</em> than buying a house.</p>
<p>So if the environment you are talking about was using Ms Access, you would find it hard to convince them to change.</p> Oracle is also used by for in…tag:www.oracleconnections.com,2013-08-19:6612035:Comment:296872013-08-19T09:32:04.946ZMark Sloanhttp://www.oracleconnections.com/profile/MarkSloan
<p>Oracle is also used by for instance salesforce and amazon (<a href="http://highscalability.com/amazon-architecture" target="_blank">http://highscalability.com/amazon-architecture</a>) and flight reservation (<a href="http://www.dbms2.com/2010/04/21/ita-software-needlebase-google/" target="_blank">http://www.dbms2.com/2010/04/21/ita-software-needlebase-google/</a>). And Oracle can run on multiple operating systems so you are less locked than MS SQL.</p>
<p>A feature like flashback (…</p>
<p>Oracle is also used by for instance salesforce and amazon (<a href="http://highscalability.com/amazon-architecture" target="_blank">http://highscalability.com/amazon-architecture</a>) and flight reservation (<a href="http://www.dbms2.com/2010/04/21/ita-software-needlebase-google/" target="_blank">http://www.dbms2.com/2010/04/21/ita-software-needlebase-google/</a>). And Oracle can run on multiple operating systems so you are less locked than MS SQL.</p>
<p>A feature like flashback (<a href="http://www.oracle.com/technology/deploy/availability/htdocs/Flashback_Overview.htm" target="_blank">http://www.oracle.com/technology/deploy/availability/htdocs/Flashback_Overview.htm</a>) is very hard to implement in the client. Hash joins, analytical queries and materialized views are not stuff the client can do if you don't want to retrieve all the data from the database because that takes too much time. I've understood that mysql can't do a hash join. Oracle can also automatically parrallelize long running queries.</p>
<p>There is also support for changing the database schema without going offline.</p>
<p>Oracle has also features for encryption and data security (even on row level).</p>
<p>I don't think that financial companies are going to use non-acid nosql systems. Maybe for logging but not for the "important" stuff. Maybe some use Berkeley DB because Berkeley DB has transactions.</p> ORACLE has a very high perfor…tag:www.oracleconnections.com,2013-08-19:6612035:Comment:298752013-08-19T09:30:36.915ZAlex Johnhttp://www.oracleconnections.com/profile/AlexJohn
<p><span>ORACLE has a very high performance when it comes to speed. Also the capacity in some fields and has more functionality on its procedures PL/SQL. The mysql/sql server also has stored procedures but the difference is ORACLE has more functions and executes faster compared to others. It can operate more higher buffering multiple transactions on its procedures and queries. Aside from that its almost the same with the other SQL's</span></p>
<p><span>ORACLE has a very high performance when it comes to speed. Also the capacity in some fields and has more functionality on its procedures PL/SQL. The mysql/sql server also has stored procedures but the difference is ORACLE has more functions and executes faster compared to others. It can operate more higher buffering multiple transactions on its procedures and queries. Aside from that its almost the same with the other SQL's</span></p> Corporate Culture... History.…tag:www.oracleconnections.com,2013-08-19:6612035:Comment:298712013-08-19T09:29:02.366ZDerek Shephardhttp://www.oracleconnections.com/profile/DerekShephard
<p>Corporate Culture... History... Bias...</p>
<p>AND Oracle is a very good DB, but so are plenty of others these days.</p>
<p>However, if the financial institution has been around forever, and they've used Oracle forever (since it WAS once in a class of its own), there's an investment there.</p>
<p>Also, since Oracle once dominated this market, people with experience in these industries are already more likely to be familiar with it and comfortable with it, so when building a new system it's a…</p>
<p>Corporate Culture... History... Bias...</p>
<p>AND Oracle is a very good DB, but so are plenty of others these days.</p>
<p>However, if the financial institution has been around forever, and they've used Oracle forever (since it WAS once in a class of its own), there's an investment there.</p>
<p>Also, since Oracle once dominated this market, people with experience in these industries are already more likely to be familiar with it and comfortable with it, so when building a new system it's a "comfortable" choice.</p> Oracle has a reputation for b…tag:www.oracleconnections.com,2013-08-19:6612035:Comment:297722013-08-19T09:27:30.295ZGeorge Burkehttp://www.oracleconnections.com/profile/GeorgeBurke
<p><span>Oracle has a reputation for better reliability and security. Historically, it has outperformed and out-scaled any other SQL engine. This is changing, but the perception is still there. In many markets, Oracle is still perceived as the gold standard. Financial services seems to be one of them.</span></p>
<p><span>Oracle has a reputation for better reliability and security. Historically, it has outperformed and out-scaled any other SQL engine. This is changing, but the perception is still there. In many markets, Oracle is still perceived as the gold standard. Financial services seems to be one of them.</span></p>