On 09/11/11 19:05, Steve Romanow wrote:
Are any of the multivalued fields associated to each other? You would
have a subtable per association, not per column.
The messiness still exists, it just needs to be managed.
And are you looking to export it to MySQL (or whatever), or are you
planing
[antli...@youngman.org.uk]
Sent: Thursday, November 10, 2011 4:54 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Suggestions for flattening Multivalues...
On 09/11/11 19:05, Steve Romanow wrote:
Are any of the multivalued fields associated to each other? You would
have a subtable per
I'm in the process of creating/updating a MySQL database for external
applications to analyze some of the data.
My initial method of dealing with a multivalued field, is to create it's own
table, keyed to the master table (1:n)
But this gets a little tedious if you have a bunch of multivalued
(or
Oracle, DB2, Progress, MySQL...)
http://youtu.be/aI9TcMfCRDg
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: November-09-11 10:34 AM
To: U2 Users
Subject: [U2] Suggestions for flattening
It might be worth doing some of this work with an ORM (Object Relation
Mapper). Almost all higher level languages have them. Once you get
things configured, the messiness of the joins is hidden behind
syntactic sugar.
Here is a comparison of a lot of them from wikipedia.
] Suggestions for flattening Multivalues...
It might be worth doing some of this work with an ORM (Object Relation
Mapper). Almost all higher level languages have them. Once you get
things configured, the messiness of the joins is hidden behind
syntactic sugar.
Here is a comparison of a lot
Welcome to Hell!
-Original Message-
From: George Gallen ggal...@wyanokegroup.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Wed, Nov 9, 2011 10:57 am
Subject: Re: [U2] Suggestions for flattening Multivalues...
I was looking more for ideas on how to setup the database
Subject: Re: [U2] Suggestions for flattening Multivalues...
I was looking more for ideas on how to setup the database structure to handle
the 1:n other than the Sidebar tables joined to the master table.
Right now, the scope of the data being moved off is fairly small, I didn't want
to involve any
with one that
Does not handle it natively!
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow
Sent: Wednesday, November 09, 2011 1:41 PM
To: U2 Users List
Subject: Re: [U2] Suggestions for flattening
it in the
database.
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben
Sent: Wednesday, November 09, 2011 2:03 PM
To: U2 Users List
Subject: Re: [U2] Suggestions for flattening Multivalues...
Whenever the fields
Subject: Re: [U2] Suggestions for flattening Multivalues...
Are any of the multivalued fields associated to each other? You would
have a subtable per association, not per column.
The messiness still exists, it just needs to be managed.
___
U2-Users mailing
2011 8:06 a.m.
To: U2 Users List
Subject: Re: [U2] Suggestions for flattening Multivalues...
For a couple of the fields, I've done this, but for most of them, there are no
range of counts. Oh well.
The only other method I'll use for some of the other fields is storing them
On 11/09/11 14:05, Steve Romanow wrote:
Are any of the multivalued fields associated to each other? You would
have a subtable per association, not per column.
This is precisely how Datatel reverse-engineered their back end from
Unidata to MSSQL.
--
Jeff Butera, Ph.D.
Manager of ERP
: Wednesday, November 09, 2011 2:15 PM
To: U2 Users List
Subject: Re: [U2] Suggestions for flattening Multivalues...
Why are you using MySql if you are after free you could use Postgresql which I
believe supported nested tables built in?
-Original Message-
From: u2-users-boun
Try MongoDB - It's a good match to a mvdbms and has drivers for most common
programming environments.
djm
phil walker-2 wrote:
Why are you using MySql if you are after free you could use Postgresql
which I believe supported nested tables built in?
-
Learn and Do
Excel and Share
I have used Sleepy Mongoose to push data to mongo via curl.
http://www.snailinaturtleneck.com/blog/2010/02/22/sleepy-mongoose-a-mongodb-rest-interface/
On Wed, Nov 9, 2011 at 3:07 PM, DavidJMurray (mvdbs.com)
nab...@mvdbs.com wrote:
Try MongoDB - It's a good match to a mvdbms and has drivers
16 matches
Mail list logo