Use of Ruby on Rails for Oracle data warehouses
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 inna开发者_如何学Pythonte 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
精彩评论