Re: Help needed in on-line access of Oracle server.
Date: 24 Sep 1994 14:06:59 -0500
Message-ID: <361tcj$3u7_at_sleepy.cc.utexas.edu>
Hi! You Oracle experts out there:
I am working on a project for a major airline. We're trying to move the airline's databases (flight info, reservation system and crew management system) from the legacy system (IMS) to a unix oracle database server. At the same time, we are also developing a decision support system to help the airline deal with irregular operations (e.g., delays, cancellations and aircraft swaps due to bad weather, mechanical problems or air traffic control). I am responsible for developing the models and writing the solver engine in C. Since I am not a database people and I've never used Oracle before and I do need to access the info on the database server in real-time as input to my model. I have some questions about accessing the Oracle database.
I can inmagine two ways to access the database:
Problem is, how? Do I use imbedded SQL commands or function calls from Oracle?
2. If I can't imbed the commands in my C codes, then I can use SQL to
query the database server separately and output the results to a
text file and then read the file from my program. But since I need to access
the database server in real-time and each time the info may be different,
it should be quick. Actually, we're going to have some GUIs. For instance,
the flight controller may input some parameters (e.g., city name,
time bank during which delays occur), then somehow the program will
Still, the question is, how?
I am sorry if these questions sound too basic. My only experience with databases are as a user, and really have no ideas of database programming.
I am seeking some general pointers. If you can point me to some relevant refs, especially books that can get me started quickly, I will be most grateful.
Thanks a lot.
Guo Received on Sat Sep 24 1994 - 21:06:59 CEST