为什么银行或金融公司更喜欢 Oracle 而非其他 RDBMS 作为其“核心”数据库系统?

发布于 2024-08-29 21:17:21 字数 1431 浏览 6 评论 0原文

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(7

飞烟轻若梦 2024-09-05 21:17:21

Oracle 因更高的可靠性和安全性而享有盛誉。从历史上看,它的性能和规模都超过了任何其他 SQL 引擎。这种情况正在改变,但这种看法仍然存在。在许多市场,甲骨文仍然被视为黄金标准。金融服务似乎就是其中之一。

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.

淡淡绿茶香 2024-09-05 21:17:21

企业文化...历史...偏见...

并且Oracle是一个非常好的数据库,但现在还有很多其他数据库。

然而,如果金融机构一直存在,并且他们一直使用 Oracle(因为它曾经是同类中的佼佼者),那么那里就有投资。

而且,由于Oracle曾经在这个市场占据主导地位,所以在这些行业有经验的人已经更容易熟悉它并适应它,因此在构建新系统时它是一个“舒适”的选择。

Corporate Culture... History... Bias...

AND Oracle is a very good DB, but so are plenty of others these days.

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.

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.

给我一枪 2024-09-05 21:17:21

也使用PostgreSQL,Caixa(巴西的一家大银行)使用它:
任务关键型金融系统中的 PostgreSQL

PostgreSQL is also used, Caixa (a large bank in Brazil) uses it:
PostgreSQL in Mission-Critical Financial Systems

真心难拥有 2024-09-05 21:17:21

无论您收到哪个答案,很可能会根据操作员对所使用的 RDBMS 的个人舒适度而产生偏见。

与购买房屋相比,任何公司实体在更改工作解决方案时都需要填写更多的文书工作(从 1Tc 到 R2D2)并获得批准。

因此,如果您所谈论的环境正在使用 Ms Access,您会发现很难说服他们进行更改。

鉴于这一切,曾经有一段时间(不是遥远的过去/甚至仍然是今天)此类决策不是由开发商做出的,而是由成本计算公司做出的。

另一个笑话。考虑到程序员的年龄,您听说过 COBOL

Which ever answer you receive, will most likely be biast based on the OP's personal comfort with the RDBMS used.

Any corporate entity has more measures in paperwork, (From 1Tc to R2D2) to fill out, and get approved when changing working solutions than buying a house.

So if the environment you are talking about was using Ms Access, you would find it hard to convince them to change.

Given all that, there was a time (not to distant past/even still today) where these kind of decisions was not made by developers, but by the costing company.

Another joke. Given a programmers age, Have you ever heard of COBOL

我要还你自由 2024-09-05 21:17:21

除了前面提到的所有原因之外,Oracle 比 MS SQL 和其他产品(如 IBM DB、PostgreSQL 等)更受欢迎的原因还在于:

  • Oracle 是自 1977 年以来最古老的,所以我们谈论的是 37 年的历史。
    开发,而 MS SQL Server 自 1989 年以来基于 Sybase-SQL
    服务器是 MS、Ashton-Tate 和 Sybase 之间的联合项目。
  • Oracle 一直专注于数据库开发,而
    除了 Windows 操作系统和 Office 之外,微软还更关注
    .Net框架下的多种编程语言,并打包在Visual Studio下。
  • Oracle 数据库相对于 MS-SQL Server 的技术过剩问题
    主要是Oracle是跨平台的,根据数据库专家的说法
    执行查询速度更快,它有两个特点:MS-SQL Server
    目前还没有,一是oracle如何处理存储过程它可以
    将 SP 分组到包中,以便每个包都包含所有商店
    包裹在其中的过程可以作为一个单元来调用并执行
    由应用程序显式执行,但 MS SQL Server 无法完成
    迄今为止。
  • Oracle相对于MS SQL Server的商业营销主要来
    来自各大公司的 ERP 解决方案开发商倾向于
    与 MS SQL Server 相比,更喜欢 Oracle,因为它更容易部署和使用
    由于 Oracle 是在公司的基础设施上实施
    跨平台,因此他们认为安装和运行 Oracle 更快
    数据库,而使用 MS SQL Server 数据库则不会那么容易,除非整个平台是 Windows
    取决于 Windows NT 和 .Net 框架,这可能并不总是如此
    在公司的基础设施中使用或可用。

In addition to all the reasons that were mentioned Oracle is more preferred over MS SQL and other products like IBM DB, PostgreSQL and others is that:

  • Oracle is the oldest since 1977, so we are talking about 37 years of
    development, while MS SQL Server since 1989 based on Sybase-SQL
    Server a joined project between MS, Ashton-Tate, and Sybase.
  • Oracle has been specialized with Database development, whereas
    Microsoft was more focusing on Windows OS and Office in Addition to
    Variety of programming languages under the .Net framework, and packed under Visual Studio.
  • The technical excess aspects in Oracle database over MS-SQL Server
    are mainly that Oracle is cross platform, as per database experts it
    executes queries faster, and it has two thing that MS-SQL Server
    doesn't have yet , One is how oracle handles stored procedures it can
    group SPs in packages so that each package with all the stores
    procedures wrapped inside it can be called as a unit and executed
    explicitly by the application, which can't be done is MS SQL Server
    so far.
  • The commercial marketing of Oracle over MS SQL Server coming mainly
    from the major developers of ERP solutions for companies tends to
    prefer Oracle over MS SQL Server because it is easier to deploy and
    implement on the company's infrastructure due to that Oracle is
    cross-platform so they think it's quicker to install and run Oracle
    Database while it won't be as easy with MS SQL server Database unless the entire platform is Windows that
    depends on windows NT and .Net framework which might not be always
    used or available in the company's infrastructure.
国产ˉ祖宗 2024-09-05 21:17:21

ORACLE 在速度方面具有非常高的性能。在某些领域也有能力,并且在其程序 PL/SQL 上有更多的功能。 mysql/sql服务器也有存储过程,但不同的是ORACLE比其他服务器有更多的功能并且执行速度更快。它可以在其程序和查询上运行更高缓冲的多个事务。除此之外,它与其他 SQL 几乎相同

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

守护在此方 2024-09-05 21:17:21

例如 salesforce 和 amazon 也使用 Oracle (http://highscalability.com/amazon-architecture )和航班预订 (http://www.dbms2. com/2010/04/21/ita-software-needlebase-google/)。 Oracle 可以在多个操作系统上运行,因此与 MS SQL 相比,锁定更少。

闪回等功能 (http://www.oracle.com/technology /deploy/availability/htdocs/Flashback_Overview.htm)在客户端中很难实现。如果您不想从数据库中检索所有数据,则客户端无法执行哈希连接、分析查询和物化视图,因为这会花费太多时间。我知道 mysql 不能进行哈希连接。 Oracle 还可以自动并行化长时间运行的查询。

还支持在不脱机的情况下更改数据库架构。

Oracle 还具有加密和数据安全功能(甚至在行级别)。

我不认为金融公司会使用非酸性 nosql 系统。也许用于日志记录,但不适用于“重要”的东西。也许有些人使用 Berkeley DB,因为 Berkeley DB 有事务。

Oracle is also used by for instance salesforce and amazon (http://highscalability.com/amazon-architecture) and flight reservation (http://www.dbms2.com/2010/04/21/ita-software-needlebase-google/). And Oracle can run on multiple operating systems so you are less locked than MS SQL.

A feature like flashback (http://www.oracle.com/technology/deploy/availability/htdocs/Flashback_Overview.htm) 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.

There is also support for changing the database schema without going offline.

Oracle has also features for encryption and data security (even on row level).

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.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文