Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"

Re: SQL queries from weird data

by sundialsvc4 (Abbot)
on Feb 19, 2013 at 19:44 UTC ( #1019649=note: print w/replies, xml ) Need Help??

in reply to SQL queries from weird data

If the amount of data is at-all reasonable, you could write a script which populates additional SQL tables whose purpose is to index the data that you receive from this most-peculiar application.   Create a suitable primary-key column even if you have to do it by hand, then scan through the data inserting rows in other tables that consist of break-downs of what is in the original data.   For example, two entries in an index-table for row #1 would specify that it contains 'AA' and 'BB'.   Once you have done this, now you can begin to do sensible queries against the data that you get.

A script to parse the original data stem-to-stern, inserting descriptive records in other tables, would be fairly easy to write and could accomplish its work with a single pass through the data.   Now, you no longer have to depend upon its weirdnesses.   I truly believe that you will never get a truly-satisfactory program from the approach that you are pursuing right now.   I daresay that the incoming data is full of special-cases and exceptions that would vex you endlessly.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1019649]
[davies]: LanX: No. The mayor of London would better be described as the transport commisar for London. S/h/it doesn't have a tenth of the power of La Sturgeon (and therefore does <10% of the damage).
[LanX]: xD ... complicated countrie(s)

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (10)
As of 2017-12-15 18:19 GMT
Find Nodes?
    Voting Booth?
    What programming language do you hate the most?

    Results (440 votes). Check out past polls.