ActiveRecord with **some** columns mapped to database?

Rails
1

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

2

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

3

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