× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hi Justin,

Just because the S/36 file has about 25 different formats, doesn't mean a
new set of tables would require 25 of them to replace it. Try combining
some of the formats into common, more generic formats, with column(s) to
differentiate between 2 or more old formats.

I'd be surprised if more abstract, generic structures couldn't whittle down
that count of 25 to a much smaller number.

Once that is done, I'd make SQL views over the results, to handle most of
the JOIN requirements, and to make querying the data easy. With the right
indexes in place and adequate hardware, that will likely perform well.

For performance reasons, I'd avoid storing that type of data as JSON or
XML, if it needed to be frequently parsed and queried.

Mike


date: Fri, 1 Apr 2016 01:24:59 +0000
from: Justin Taylor <JUSTIN@xxxxxxxxxxxxx>
subject: Re: Thoughts/experiences with JSON/XML on DB2

Fair enough.


I'm thinking along the lines of NoSQL, even though DB2 is not quite a
full-fledged NoSQL DB. I would be querying the JSON/XML directly, not
extracting it every time.


The S/36 file has about 25 different formats. I stepped back from the
multiple table approach when I realized how many tables and joins would be
required.



As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.