将 Ruby on Rails 用于 Oracle 数据仓库
有人可以帮我指点一个在 Oracle 数据仓库中使用 Ruby on Rails 的示例吗？该数据仓库具有如下属性：
与许多 Oracle 系统的情况一样，对象不仅仅是在数据表的形式，但在计算机科学意义上是真正的对象。在本例中，对象是在 PL/SQL 包和存储过程的帮助下定义的。
Oracle 系统利用了串联主键和索引组织表 (IOTS) 等功能。 [ 在索引组织表中，没有单独的索引；部分或全部列定义索引。]
Oracle 系统利用附加的 Oracle 功能进行优化，例如数据分区、SQL*结果缓存等。
整个系统架构是平衡的，因为某些业务逻辑可以驻留在数据库中的 PL/SQL 存储过程中。但没有采取“教条”或“纯粹”的方法。在平衡方法中，不同类型的业务逻辑不仅仅使用 PL/SQL 来完成。它还可以驻留在借助现代规则或工作流引擎完成的规则或工作流系统中。最后，还可以借助用 Ruby 或 Ruby On Rails 编写的组件来完成数据视图和业务逻辑，以便获得这些工具提供的好处，并且可以补充 PL/SQL 组件固有的使用许多（或大多数）具有复杂性质的 Oracle 系统。
如果某些问题的答案是“否”，是否有人可以帮助我们提供指导，以便我们可以将 Ruby 和 Ruby On Rails 功能添加到具有这些功能的 Oracle 数据库中。我很高兴生成其他类型的 Ruby 包装器和其他文件来执行该任务。
谢谢
Could someone give me a hand by pointing me to an example of the use of Ruby on Rails with an Oracle data warehouse that has attributes such as the following:
As is the case with many Oracle systems, the objects are not simply in the form of data tables, but are true objects in the computer science sense. In this case, the objects are defined with the help of PL/SQL packages and stored procedures.
The Oracle system makes use of such features as concatenated primary keys and Index Organized Tables ( IOTS ). [ In Index Organized Tables, there is no separate index; some or all of the columns define the index.]
The Oracle system makes use of additional Oracle features for optimization such as data partitions, SQL*Result caches, and so on.
The overall system architecture is balanced in the sense that some of the business logic can reside in the database in PL/SQL stored procedures. But there is no "dogmatic" or "purist" approach that is taken. In the balanced approach, business logic of different kinds is not solely done using PL/SQL. It can also reside in systems of rules or workflows done with the help of modern rules or workflow engines. Finally, views of the data as well as business logic can also be done with the help of components written in Ruby or Ruby On Rails, in order to reap the benefits that these tools provide and that can complement the use of PL/SQL components innate to many ( or most ) Oracle systems of complex nature.
If the answer to some of the question is "No", is there someone that can help give us guidance so that we can add Ruby and Ruby On Rails capabilities to an Oracle database with those features. I am happy to generate additional kinds of Ruby wrappers and other files in order to carry out that task.
Thanks
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论