i'm about to design a web application that possibly will connect to different databases. these databases contains the data that i need. the problem is they have varying structures. how is it possible to extract the information that i need. is there a software that could help?
i have an idea though but i'm not sure if it's okay. I'll ask each database administrator the queries necessary in order to access the information that i need. is this a stupid idea? can you suggest an alternative?
2007-08-25 19:11:58 · 4 answers · asked by andy 2 in Computers & Internet ➔ Programming & Design
You could isolate the differences from your application by creating views to the different data sources, once for each source. You application then will have a standard "view" of those different sources.
2007-08-25 19:14:55 · answer #1 · answered by BigRez 6 · 0⤊ 0⤋
It is an idea.
AS an alternative you could use the databases as they are and convert the resultsets into the desired structure for your application. In this way you are not dependent on the extra work of the database administrators.
2007-08-25 19:18:26 · answer #2 · answered by gjmb1960 7 · 0⤊ 0⤋
How can you write queries if you don't know the databases? (type of sql they're using, name of fields.. etc), you should try to find all that out by yourself before asking him because they're busy people.
2007-08-25 19:24:08 · answer #3 · answered by Anonymous · 0⤊ 0⤋
its a good idea. besides which, they're the best ones who can help you solve the problem.
2007-08-25 19:15:43 · answer #4 · answered by Mars 4 · 0⤊ 0⤋