Re: [AccessD] InterSystems Caché database engine

Hi Jim

Interesting observations because I haven't been able to get hand on
any benchmark results.

However, it is not new, it has been around for several years, since
1997 I believe. Before that the engine ancestors lived outside the pc
world under the name MOMS. Some of our fellow list members may be able
to elaborate on that - I've never heard of it.

/gustav


> Gustav:

> Your comments are so timely. Today I went to lunch with a Database
> programming acquaintance and he was raving about this new database, Caché.
> He has worked extensively with Sybase right through to SQL2000 and Oracle
> from 5.1 to 9i and he is now working with this DB. He is totally impressed.
> He says that it runs about 50% faster for simple queries but when working
> with large Cubes experiences a steady 600 plus percent performance gain.

> He strongly recommended that I download the free evaluation copy, work my
> way through the tutorials and says they have been supplying excellent email
> support (free) when he has been running into problems.

> It was a very interesting lunch that extended almost a couple of hours.

> Jim

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gustav Brock
> Sent: Thursday, October 09, 2003 8:58 AM
> To: Access Developers discussion and problem solving
> Cc: accessdb2web at egroups.com
> Subject: Re: [AccessD] InterSystems Caché database engine


> Hi group

> Well, today I went to this hands-on seminar, and I'm impressed.

> The core of the engine is an object oriented data store. You create as
> easy as in Access - in a very nice designer using a basic like
> language - classes for storing data. When compiled, these classes are
> at once compiled too - and represented - as tables via ODBC and JDBC,
> classes via C++, Java, ActiveX (COM), .net and XML, and you can access
> the data simultaneous via all interfaces. These layers are all highly
> efficient they claim is the main reason for the high speed of the
> engine next to the speed of the engine itself.

> Further, you can create CSP pages similar to ASP and JSP pages with a
> direct connection to the engine. An add-in for Dreamweaver is offered
> with wizards for creating web pages. These pages are interesting as
> they offer live update of presented data via either a server call or a
> hidden frame meaning that requery or repaint of the displayed page is
> avoided - this is in my opinion mandatory for anything serious
> application-like running in a browser.

> The best perspective of this, in my eyes, is that you can start using
> the engine and your proven tools whatever they might be (Access) while
> moving to or adding other interfaces like another language, a browser
> interface, XML or web services (SOAP). Rome was not built in one day,
> remember.

> The engine scales to shadowed servers, clusters and TB size with no
> more efforts than within reach of a developer (we are impatient and
> really have no time for this, you know), and it runs on close to
> anything including WinNT/200x/XP, Redhat/Suse Linux, Solaris, OpenVMS,
> Tru64, HP-UX, AIX, and Win ME/98 - even Win95 - and MacOX with the
> next release - requiring modest hardware only.

> /gustav


>>> Just noticed this option for a free developer license:

>>>   http://www.intersystems.com/downloads/index.html

>>> Anyone having experience with this engine as a backend for Access or
>>> otherwise?

>>> The free license doesn't allow you to sell your apps. It is, however,
>>> not time limited.