we want to migrate our application from (linux code-grep, cut, wc.....cammande) to JAVA or PRO C
the application takes on input flat files (4 flate file per minutes) each file containes 100.000 lines to reformate with grep command and then load them into a partitionned database 10g
what do you suggeste me you experts to implement for the best use of my database
solution 1 : the use of java code rather then linux code
solution 2 : the use of C /pro C code rather then linux code and java code
solution 3 : the use of external tables in oracle (consider my flat files as external table) and contain do all the trasformation with native SQL code rather then linux code and java code and C code
I realy need your help,
we don't want to use teradata cause of the expencive price, and we ask me to make optimum developpement
If pressed, I would probably go for option 3.
Te "optimum" you want is dependent on the needs and objectives of your organization, so I cannot answer what is best for you.
What's wrong with grep, sed and awk?