Hi, If it suits to you to extract a T24 table into one Oracle table then you should use XML type columns in the Oracle table. You can easily extract the data from T24 into a flat file. For the multivalue fields you could represent the data as XML tree. The data upload into a relational database is very fast. Even with such Extracted data, you don't need more than one table, and normalized SQL statements or so, because you have a table with XML type variable in which you'll hold your multivalue fields' data - represented as XML tree data structure.
The 'harder' way afterwards is the SQL queries' design, where you'll have to use XQuery for the XML columns. Kind regards -Igor Micev On Oct 27, 8:46 am, VK <kzm...@yahoo.com> wrote: > Hi, > sort of DWH thing? I believe basic routine pushing data might be the > simplest choice. Even if you're doing 10 millions of records, it > shouldn't be that much. Incremental upload will make it even faster > (if applicable). Not sure about the format that Oracle understands but > probably something like csv might work. > > Once upon a time Temenos had a module in Globus which did exactly that > - extracted data, normalized it and prepared sql statements to be put > to Oracle. > > VK > > On Oct 26, 5:38 pm, "Samith Bulathgama" <bulathg...@gmail.com> wrote: > > > > > > > > > Thanks VK, > > > I'm trying to extract the data from jBase database & upload them to an > > oracle database (after formatting) . The table can be any table within the > > jBase & I should be able to handle a volume like couple of millions (say 10 > > million or more, but not always) records from jBase. This is the reason I > > was checking for the performance. > > > As I understand the available methods for me are, > > > 1. Using a Basic routine > > 2. Through JDBC connection > > 3. Using jRemote as you mentioned. > > > Any suggestions will help. > > > Best Regards, > > Samith > > > -----Original Message----- > > From: jbase@googlegroups.com [mailto:jbase@googlegroups.com] On Behalf Of VK > > Sent: Wednesday, October 26, 2011 8:52 AM > > To: jBASE > > Subject: Re: How to know the Multi-Value & Sub-Value position of the data > > > when extracted using JDBC > > > Hi, > > sorry no idea about performance. Also, I never used jdbc. But if you give > > more detail about the task in general - maybe you'll get more advices > > regarding possible data retrieval methods. > > > VK > > > On Oct 25, 7:51 pm, Samith Bulathgama <bulathg...@gmail.com> wrote: > > > Thank for this VK. Any idea about the performance between two methods, > > when we extract large number of records. > > > > ---------------------- > > > > Best Regards, > > > Samith > > > > Sent from my mobile device > > > > On Oct 24, 2011, at 9:17 AM, VK <kzm...@yahoo.com> wrote: > > > > > Hi, > > > > just my 2 cents. > > > > > If you're on Java path, why not use jRemote? > > > > > VK > > > > > On Oct 19, 9:45 am, Samith Bulathgama <bulathg...@gmail.com> wrote: > > > >> Thanks Pat, > > > > >> Which means, there is no straight forward technic available to > > > >> identify the relative multivalue (& subvalue) positions once > > > >> extracted the jBase data through JDBC..? > > > >> Best regards, > > > >> Samith > > > > >> On Tue, Oct 18, 2011 at 9:26 PM, pat <pat...@gmail.com> wrote: > > > >>> Easiest way to observe the mapping, would be to put 'meaningful' > > > >>> data in a 'record' > > > > >>> Eg : > > > > >>> F_BATCH_JBL testrecord > > > > >>> 006 Attr6_mv1]Attr6_mv2 > > > >>> ... > > > >>> ... > > > >>> 011 Attr11_mv1_sv1\Attr11_mv1_sv2]Attr11_mv2_sv1\Attr11_mv2_sv2 > > > >>> etc > > > > >>> [ where ']' are Multivalue marks, and '\' are Subvalue marks ] > > > > >>> Then, using the output for the above record, you should be able to > > > >>> observe the 'order' these fields are extracted / displayed, from > > > >>> which you should be able to implement a method of determining the > > > >>> 'general case' 'mapping' > > > > >>> On Oct 16, 5:45 pm, Samith Bulathgama <bulathg...@gmail.com> wrote: > > > >>>> Dear All, > > > > >>>> I’m doing some basic tests with JDBC connections with jBase (TAFC > > > >>>> Major > > > >>> 09.0 > > > >>>> , Minor 0.0 on Red Hat Enterprise Linux Server release 5.5, jDK > > 1.6). > > > > >>> -- > > > >>> Please read the posting guidelines at: > > > >>>http://groups.google.com/group/jBASE/web/Posting%20Guidelines > > > > >>> IMPORTANT: Type T24: at the start of the subject line for > > > >>> questions specific to Globus/T24 > > > > >>> To post, send email to jBASE@googlegroups.com To unsubscribe, > > > >>>send email to jbase-unsubscr...@googlegroups.com > > > >>> For more options, visit this group at > > > >>>http://groups.google.com/group/jBASE?hl=en > > > > > -- > > > > Please read the posting guidelines > > > > at:http://groups.google.com/group/jBASE/web/Posting%20Guidelines > > > > > IMPORTANT: Type T24: at the start of the subject line for questions > > > > specific to Globus/T24 > > > > > To post, send email to jBASE@googlegroups.com To unsubscribe, send > > > > email to jbase-unsubscr...@googlegroups.com > > > > For more options, visit this group > > > > athttp://groups.google.com/group/jBASE?hl=en > > > -- > > Please read the posting guidelines > > at:http://groups.google.com/group/jBASE/web/Posting%20Guidelines > > > IMPORTANT: Type T24: at the start of the subject line for questions specific > > to Globus/T24 > > > To post, send email to jBASE@googlegroups.com To unsubscribe, send email to > > jbase-unsubscr...@googlegroups.com > > For more options, visit this group > > athttp://groups.google.com/group/jBASE?hl=en -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to jBASE@googlegroups.com To unsubscribe, send email to jbase-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
