Re: Question about an embedded database engine

Advantage.

"Ron L." <infopath@xxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:447c6625$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

I am looking for an embedded database engine for our analysis application.
The requirements include a good SQL implementation and TDataset
compatability - most of the work will be done by issuing SQL queries - but
some database updates are needed - where a TTable like functionality is
used.

Has.


The issue I need to resolve it concurrent use from my application. It is
currently implemented as a user-interface module that can execute multiple
instances of the analysis engine in concurrent threads.

Thread safe.

Any of the analysis
application threads can access the same database - and so can the
user-interface module. There is also a data transformation module that can
also execute concurrently and could also access the data.

The analysis engine and the data transformation module are each
implemented as an automation object in a stand-alone DLL - they are
executed in-process by the user-interface module.

We currently use MS SQL Server and everything works fine - since the
database server is external to the application and can handle multiple
connections open at once. Since we want to embed the database server for a
sepcific need - we no longer have this advantage and I do not want to
completly change our project's architecture to handle this.

My questions are:

1. Any of the leading products (Nexus, dbIsam etc...) can handle this
easly?
2. Do I need to implement the database access in yet another automation
object that the 3 other modules (user interface, analysis engine, data
transformation engine) will use?

Any pointers and thoughts would be helpful.



.

Relevant Pages

  • Re: Is it just me, or is Sqlite3 goofy?
    ... be saying it has gasoline engine. ... SQL database, with an SQL engine. ... criticisms directed at SQLite. ...
    (comp.lang.python)
  • RE: Criteria for importing tables from a odbc link
    ... I believe that it is an SQL database, ... You did not say what the back end database engine is. ... month in order to run a report. ...
    (microsoft.public.access.externaldata)
  • Question about an embedded database engine
    ... I am looking for an embedded database engine for our analysis application. ... The requirements include a good SQL implementation and TDataset ... currently implemented as a user-interface module that can execute multiple ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: MV and SQL
    ... >> get data into or out of a SQL DBMS is/was through SQL. ... >> was the only way to access the database. ... > engine for this kind of work was always Datatrieve. ... > The Datatrieve user didn't have to learn SQL. ...
    (comp.databases.theory)
  • Re: I dont know how to link VB to database (ODBC) table.
    ... The Provider/Driver -> Uses a Connection String to access a Database engine ... The Jet engine -> Uses your data store. ... Under TextBox Property ...
    (microsoft.public.vb.general.discussion)