Question: Write a code in java that load a CSV data file and transform it into a BINARY file. You MUST name your binary file data.bin.

Write a code in java that load a CSV data file and transform it into a BINARY file. You MUST name your binary file data.bin. Subsequent queries will then operate on the binary file. You could use the Java Data Streams and Object Streams classes, but you are free to design the format of the binary file (compression libraries are allowed!).

Have a method that transform the CSV file with filename into a binary file. The filename of the binary file should be stored in your program.

Have another method prints the rows of the table where the value in column number columnNum is equal to the given value. Column numbers start from one.

Have another method that prints the rows of the table where the value in column number columnNum is greater than the given value.

Here is an example of what in the cvs file:

1|3691|O|194029.55|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | 2|7801|O|60951.63|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| 3|12332|F|247296.05|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| 4|13678|O|53829.87|1995-10-11|5-LOW|Clerk#000000124|0|sits. slyly regular warthogs cajole. regular, regular theodolites acro| 5|4450|F|139660.54|1994-07-30|5-LOW|Clerk#000000925|0|quickly. bold deposits sleep slyly. packages use slyly| 6|5563|F|65843.52|1992-02-21|4-NOT SPECIFIED|Clerk#000000058|0|ggle. special, final requests are against the furiously specia| 7|3914|O|231037.28|1996-01-10|2-HIGH|Clerk#000000470|0|ly special requests |

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!