Rails - Mar 2009 - ActiveRecord with **some** columns mapped to database?

Hi There.
I''m involved in creating a bridge between ROR and an open-source
database (OpenAccess, or OA for short) used for EDA (Electronic Design
Automation).

OA is a great database for capturing properties of hardware designs
(such as pins, ports, constraints on signals etc.), since it provides
very compact storage for designs which contain millions of objects,but
is not a relational database.
There is a preliminary OA<->Ruby bridge done in SWIG, so that we can
create OA objects through Ruby, store them in OA etc.

I would like to combine the two - i.e. have  n "activerecord"-like
object, where some columns are stored directly in an *SQL table, but
other columns are mapped to OA objects. That way I can use the Rails
framework while utilizing the compact OA database.


Is that doable? Any pointers or advice would be most welcome

Kretch
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

On Mar 10, 5:15 am, Kretch Kretchmer <rails-mailing-l...@andreas-
s.net> wrote:
> Hi There.
> I''m involved in creating a bridge between ROR and an open-source
> database (OpenAccess, or OA for short) used for EDA (Electronic Design
> Automation).
>
> OA is a great database for capturing properties of hardware designs
> (such as pins, ports, constraints on signals etc.), since it provides
> very compact storage for designs which contain millions of objects,but
> is not a relational database.
> There is a preliminary OA<->Ruby bridge done in SWIG, so that we can
> create OA objects through Ruby, store them in OA etc.
>
> I would like to combine the two - i.e. have  n
"activerecord"-like
> object, where some columns are stored directly in an *SQL table, but
> other columns are mapped to OA objects. That way I can use the Rails
> framework while utilizing the compact OA database.
>
store the OA data as a blob column on the corresponding activerecord
or store as a text column whatever info you need to get the info out
of OA ?

Fred
> Is that doable? Any pointers or advice would be most welcome
>
> Kretch
> --
> Posted viahttp://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Frederick Cheung wrote:
> On Mar 10, 5:15�am, Kretch Kretchmer <rails-mailing-l...@andreas-
> s.net> wrote:
>> create OA objects through Ruby, store them in OA etc.
>>
>> I would like to combine the two - i.e. have �n
"activerecord"-like
>> object, where some columns are stored directly in an *SQL table, but
>> other columns are mapped to OA objects. That way I can use the Rails
>> framework while utilizing the compact OA database.
>>
> 
> store the OA data as a blob column on the corresponding activerecord
> or store as a text column whatever info you need to get the info out
> of OA ?
> 
> Fred
The issue is that for a given object there might be a huge amount of 
data stored in OA (up to many millions of objects), so translating it to 
text and storing in activerecord will require lots of space and take a 
lot of time. I''m looking to combine the superior storage of OA with the
great infrastructure you get for activerecord

Kretch
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---