Thread View: borland.public.cppbuilder.database.multi-tier
2 messages
2 total messages
Started by Richard Ulrich
Sat, 22 Apr 2000 00:00
Really basic questions
Author: Richard Ulrich
Date: Sat, 22 Apr 2000 00:00
Date: Sat, 22 Apr 2000 00:00
28 lines
1802 bytes
1802 bytes
Hello, Although I have created a lot of single-workstation databases, what I know about multi-tier databases can be written on a postcard. So, here are my questions. We have a database that we access directly with the BDE. We figured that when we deploy it we might substitute TurboPower's FlashFiler, but hadn't decided. Anyway, it turns out that various users will want to be accessing (read and write) the database from their big-deal database servers; some use Oracle, some Maximo, some other that I haven't heard of. Also, some use microsoft ODBC. Question 1: do we have to worry about conflicts because different servers are trying to get at the data at the same time? Question 2: if we set up a simple client-server architecture with BDE, Interbase, or FlashFiler, does the Big Deal server have to go through FlashFiler to get at the data, and is that hard for them to do? Question 3: is Interbase the best bet, do you think? It may also be that the clients will want to grab the data, put it in their "official" database, and then have our program (a number-cruncher) get the info from there, whereever "there" is. Question 4: So ... what would I, a lowly workstation programmer, need to do so that my program can get at that data? Thanks much, Richard Ulrich
Re: Really basic questions
Author: Mark Cashman (TeamB)
Date: Fri, 28 Apr 2000 00:00
Date: Fri, 28 Apr 2000 00:00
28 lines
1842 bytes
1842 bytes
Hi, Richard! Client / server DBMS have their own specific architecture and access methods. In other words, a Syquest server cannot access an Oracle database, or vice versa. Property set up, your program can access your tables through any DBMS from dBase to Oracle. That uses the BDE as the abstraction layer, and will require you to have a configuration to load your datamodule tables / queries with the appropriate DBMS-peculiar table names (for instance, dBase needs the extension, SQL Server prefixes table names with dbo., etc.). But other than that, and using a reasonably constrained set of field tables common to all, you should have no trouble retargeting your app to another DBMS by simply redirecting the alias to the appropriate driver and database. If you must make available your data to other programs, your best bet is to write a DLL, COM object, or CORBA object which they can call upon, and with which you can hide your DBMS from them. I hope this gives you something useful to think about. ------ Mark Cashman, TeamB C++ Builder http://www.temporaldoorway.com/programming/index.htm C++ Builder, JBuilder programming information Home of The C++ Builder Programmer's Webring - Join us! ------
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads