Re: Design help

From: Neil Talsania <neil.talsania_at_kodak.com>
Date: Tue, 30 Apr 2002 12:32:32 -0400
Message-ID: <aamh64$fts$1_at_news.kodak.com>


[Quoted] [Quoted] Thanks for the thought, but since hiring a contractor to do this is not an [Quoted] option, let me throw some more thoughts out. I am not looking for a solution to my problem. I am looking for possibilities.

What I am really looking for is some paths to go down and research. For example, last night I read a chapter in an oracle XML book, and it gave a very simply example, where you created an XML file with an editor, putting [Quoted] the query into the XML file, and when you loaded that file into a browser, [Quoted] the results were displayed. As I read this in the bookstore and thus did not [Quoted] have access to my computer, I could not see what it took to get it to work. [Quoted] But something was automatically translating from the query into the results. [Quoted] It is not clear what needs to be done to accomplish this. Any clues? IF I [Quoted] dont have a web server running would this still work? Does this approach really get me anything for free? If all XML would buy me would be a standard [Quoted] language to aid in the data passing, then you would be right, and the technology wouldnt matter, but if the oracle utilites interact with the XML [Quoted] and make some things happen in the background, then it would be worth considering.

I was hoping to not have to buy the book just yet, until I felt confident [Quoted] that it was the path to go down.

Thanks
Neil

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3CCEB576.D61B82A9_at_exesolutions.com...
> Neil Talsania wrote:
>
> > Hi,
> > I am new to database work, and am looking for help in figuring out
> > possible design options, or really what the best tool for the job might
be.
> >
> > The task is to fit into an existing client server application an oracle
> > database on the server side. Basically the client picks a file on the
> > server, a TCP/IP socket is opened and then the data is transmitted from
the
> > server to the client for display. What we want to do now, is have the
user
> > instead of sending a file name to the server, really send search
criteria to
> > the server. Eventually the client needs to get the data from the server
in
> > the same way it currently does. So, one thing might be for the server to
> > return to the client the filename to open.
> >
> > Now, my initial thoughts were to modify the client to get the attribute
> > values to query on, transmit those to the client over the socket
connection,
> > modify the server to use embedded SQL to query the oracle database, and
then
> > return the results of the query again through the socket.
> >
> > I am wondering if XML would make this any easier? If the client server
> > interaction were web based, then I could see how it would be a huge
benefit,
> > but since it is not, I am not so sure. IF the client builds the xml file
> > with the SQL embedded in the <query> tag, how does the server actually
get
> > the results of the query? How should it connect to the database server?
> > Should it still use embedded SQL and parse the XML file, extract out the
> > query, and then make the SQL call? Or can some of this happen
automatically?
> >
> > Any help or suggestions would be greatly appreciated.
> >
> > Thanks
> > Neil
>
> I don't see that the specific technology implementation, XML or whatever,
makes
> the slightest bit of difference.
>
> But the kind of design help you are asking for is not just a simple matter
of
> suggesting that you do A, B, and C. It is the kind of thing that, if you
are new
> to database work as you state, you should hire a contractor to do. Someone
with
> previous experience.
>
> Daniel Morgan
>
Received on Tue Apr 30 2002 - 18:32:32 CEST

Original text of this message