异构数据库系统在实践中有效吗？
我在数据库领域进行了一些探索，并想到了异构数据库的概念。 我用谷歌搜索并找到了这个 - 链接文本
我的问题是什么样的场景会付诸实践它真的有用吗？ 这是否只是另一件被考虑过但没有实施的事情，或者如果它被实施了，那么它就被限制在一个非常小众的领域？
干杯
I was probing around a bit in the realm of databases and hit the notion of having heterogeneous databases. I googled and found this - link text
My question is what kind of scenario would put this into practice and is it really useful? Is it just another thing which was thought about but not implemented or in case it was implemented, then it got restricted to a very niche area?
cheers
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
我想说是的，非常如此。 我熟悉的一种实现是将 MAS90 与 LOB 生产系统集成。 两者的数据都是重复的，但访问和使用的方式不同。
I would say yes, very much so. One implementation I am familiar with is integrating MAS90 with an LOB production system. The data is duplicated in both but accessed and used in different ways.
我以前曾在异构系统上工作过。 这是一个为大型大学管理留学项目的商业系统，他们在 Oracle、MySql 和 Sql Server 上都有安装。 不过，我是一名外部顾问，负责处理一个非常具体的转换项目，因此我没有看到使其在任何地方都能正常运行所涉及的许多问题。
我确实记得我必须处理的最大障碍是 Oracle 缺乏简单的自动增量式列，而必须设置单独的序列。 也存在许多数据类型不匹配的情况，但有一个非常好的系统来映射这些数据类型。
请注意，即使在这里，每个客户也只有一种数据库。 我们不必担心在数据库类型之间复制数据本身（除了一些常见的查找表）。 只是结构。
I've worked on a heterogeneous system before. It's a commercial system to manage study abroad programs for large universities, and they had installations on Oracle, MySql, and Sql Server. I was an outside consultant handling a very specific conversion project, though, so I didn't get to see many of the issues involved in making it work well everywhere.
I do remember that the single biggest hurdle I had to deal with was Oracle's lack of a simple autoincrement-style column and having to set up separate sequences instead. There were a number of datatype mismatches as well, but there was a pretty good system in place to just map those.
Note that even here, each customer only had one kind of database. We didn't have to worry about replicating data itself between db types (aside from a few common lookup tables). Just structure.
公司的不同部门可能使用不同的数据库。 我从以下
SQL Server
Oracle
Sybase IQ
Access
MySQL
FoxPro
Flat 文件
Excel 文件
中提取数据并推送数据SQL Server 数据库是所有数据的存储库，但它从许多不同的数据库中提取数据来填充数据，然后将数据推送到到不同的数据库供部门使用
Different departments in your company might use different databases. I pull data in and push data to from the following
SQL Server
Oracle
Sybase IQ
Access
MySQL
FoxPro
Flat files
Excel files
The SQL Server database is the repository off all the data but it pull from many different databases to populate data and then data will be pushed to different databases for departmental use