Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Forget regular expressions. You should just chew through each stream. Advancing and sorting matches as you can. Some pseudo code:</p> <pre><code>Using Streams A and B, and Objects Match and NoMatch FETCH next Line of A into LineA FETCH next Line of B into LineB WHILE Neither stream is at end of file: WHILE TimeStamp in LineA &lt; TimeStamp in LineB: ADD LineA to NoMatch FETCH next Line of A into LineA WHILE TimeStamp in LineA = TimeStamp in LineB: Add (LineA, LineB) to Match FETCH next Line of A into LineA FETCH next Line of B into LineB WHILE A is not at End of File ADD LineA to NoMatch FETCH next Line of A into LineA </code></pre> <p>This will handle repeats in A, but not in B. To handle repeats in B, you have to maintain memory of past lines:</p> <pre><code>Using Streams A and B, and Objects Match, NoMatch and Temp FETCH next Line of A into LineA FETCH next Line of B into LineB WHILE Neither stream is at end of file: CLEAR Temp WHILE TimeStamp in LineA &lt; TimeStamp in LineB: ADD LineA to NoMatch FETCH next Line of A into LineA WHILE TimeStamp in LineA = TimeStamp in LineB: ADD (LineA, LineB) to Match ADD LineA to Temp SET Temp Timestamp to LineA Timestamp FETCH next Line of A into LineA FETCH next Line of B into LineB WHILE TimeStamp in LineB = Temp TimeStamp: FOR Line IN Temp: ADD (Line, LineB) TO Match FETCH next Line of B into LineB WHILE A is not at End of File ADD LineA to NoMatch FETCH next Line of A into LineA </code></pre> <p>EDIT: I was ambiguous about how to determine EOF. Let us presume that reading after EOF returns and empty string (as it does in python). Implementation works more like this:</p> <pre><code>Using Streams A and B, and Objects Match, NoMatch and Temp FETCH next Line of A into LineA FETCH next Line of B into LineB WHILE Neither LineA nor LineB is an Empty String: CLEAR Temp WHILE LineA is not an Empty String, AND TimeStamp in LineA &lt; TimeStamp in LineB: ADD LineA to NoMatch FETCH next Line of A into LineA WHILE LineA is not an Empty String, AND TimeStamp in LineA = TimeStamp in LineB: ADD (LineA, LineB) to Match ADD LineA to Temp SET Temp Timestamp to LineA Timestamp FETCH next Line of A into LineA FETCH next Line of B into LineB WHILE LineB is not an Empty String, AND TimeStamp in LineB = Temp TimeStamp: FOR Line IN Temp: ADD (Line, LineB) TO Match FETCH next Line of B into LineB //At this point, Either LineA is empty (meaning there are no more strings to match), //or LineB is empty (meaning there are no more matches to find). If the first is true, //This loop will be skipped. Otherwise, this loop will put what's left of A into the //Not Matched Object. WHILE LineA is not an Empty String: ADD LineA to NoMatch FETCH next Line of A into LineA </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POmatching and unmatched lines from two large data sets
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USFrankieTheKneeMan
    1. USFrankieTheKneeMan
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COthank you very much, Frankie! I will have to try your solution tomorrow and I'll give you feedback. thanks again
      singulars
      1. PO
      1. USteachamantofish
    2. COIf this works for you, please accept the answer. Beware, though: This implementation does not handle empty lines in the file well.
      singulars
      1. PO
      1. USFrankieTheKneeMan
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload