Forum: Ruby on Rails ActiveRecord with **some** columns mapped to database?

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
Kretch K. (Guest)
on 2009-03-10 07:15
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
Frederick C. (Guest)
on 2009-03-10 11:12
(Received via mailing list)
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
Kretch K. (Guest)
on 2009-03-10 16:00
Frederick C. 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
This topic is locked and can not be replied to.