Jim Lawrence
accessd at shaw.ca
Thu Oct 20 14:01:14 CDT 2005
Steve: Some would say that you should be using an Oracle BE with their Developer tools for the FE (java). Runs in both environments as well but the price tag is quite different. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Conklin Sent: Thursday, October 20, 2005 6:57 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Data interface The best way Do any of these alternatives ship with native UI and/or report building? Or am I still looking at ASP/ASP.net or Access/ODBC or VB 6/net and maybe Crystal with all of the aforementioned? In particular, is there an Access equivalent (that is,one-stop shopping, not mysql with kylix or anything like that) that runs on Linux? Tia Steve -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Thursday, October 20, 2005 8:17 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Data interface The best way Hi Shamil I think you would have a nice experience with Caché. It's quite fun - and a much different feeling - to deal with tables and related tables directly as persistent classes. And stored procedures etc. can be written in either VB syntax or CachéScript which is more like C syntax. "Embedded" SQL can be used too. /gustav >>> shamil at users.mns.ru 19-10-2005 13:47 >>> Hi Gustav, Yes, there is no single answer to all needs. Yes, speed isn't that important sometimes. As for "an object design down to the lowest level" - this is still questionable here how it should be done - and it's getting the more questionable what this design should be the more I'm getting into the modern methods of OOP&D... ...it looks like the more popular is getting a "good old idea" of OOP founders (Grady Booch etc.) that objects are not "encapsulated data with behavior" but behavior first of all and encapsulated data are secondary... ...as far as I see this idea is getting into mainstream R&D... ...and as far as I may guess true OO DBMS of the future (5-10 years from now?) will be quite different from what we see now on the market (I could be missing something) - the query result of such OO DBMS database will be objects with behavior not just data, and object with behavior first of all... ...this is where LINQ will evolve as far as I may guess (is Caché doing something like that there days?)... ...how this will be done technically is an open question - will they store something like .NET assemblies in OO database together with data or...? ...the effective OODBMS of the future will become reality when relatively cheap mutlicore processors with hundreds(thousands, ...?) of cores will become everyday and mass market things not "expensive technical miracles"... ...will MS be leading in this area in 10 years from now or not? They have just lost Ward Cunningham who left them to join Eclipse Foundation (http://www.microsoft-watch.com/article2/0,1995,1872348,00.asp?kc=MWRSS02129 TX1K0000535)... Shamil ----- Original Message ----- From: "Gustav Brock" <Gustav at cactus.dk> To: <accessd at databaseadvisors.com> Sent: Tuesday, October 18, 2005 8:20 PM Subject: Re: [AccessD] Data interface The best way Hi Shamil You are right - there is no single answer to all needs and that counts for db engines as well. I have no idea where, say, Caché is faster than other solutions, if any, but I'm sure in _some_ cases it will be. It is difficult to say as Intersystems as well as other suppliers are very reluctant to publish comparable benchmarks which reflect real scenarios. You can also turn it upside down; in some cases speed is not that important and for such scenarios it an object design down to the lowest level could be preferable. As for sheer speed using code, some years ago I posted to the list a routine for recursive lookup (self referencing a table) using DAO only - and it ran at a speed that surprised me. /gustav -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com