Re: Temporal databases MySQL

2005-04-19 Thread Daniel BODEA
like access, assuming you can't go to the MySql 5 release. Ed -Original Message- From: news [mailto:[EMAIL PROTECTED] On Behalf Of Daniel BODEA Sent: Saturday, April 09, 2005 8:46 PM To: mysql@lists.mysql.com Subject: Re: Temporal databases MySQL I was thinking about the following model

Re: Re: Temporal databases MySQL

2005-04-12 Thread Daniel BODEA
://www.dbpd.com/vault/9810snod.html -Original Message- From: news [mailto:[EMAIL PROTECTED] On Behalf Of Daniel BODEA Sent: Tuesday, April 05, 2005 11:11 AM To: mysql@lists.mysql.com Subject: Re: Temporal databases MySQL Hi Shawn, I really meant temporal and not temporary. Temporal as in TSQL2

Re: Temporal databases MySQL

2005-04-09 Thread Daniel BODEA
on a given SQL engine (MySQL in this case). Not being that familiar with the inner workings of MySQL though, I can only submit the module above to the attention of MySQL specialists who may have the time to post back their thoughts. Thanks, Daniel Daniel BODEA [EMAIL PROTECTED] wrote in message

Re: Temporal databases MySQL

2005-04-05 Thread Daniel BODEA
Hi Shawn, I really meant temporal and not temporary. Temporal as in TSQL2. Databases that on the one hand accumulate all changes to data over time along with accurate time information and on the other hand provide varying degrees of transparency in querying this data based on the theory of

Temporal databases MySQL

2005-04-04 Thread Daniel BODEA
Greetings everyone, I haven't been able to find any piece of information on temporal databases and MySQL except the code from the TAU Project which seems to be experimental at best. Not even discussions on the mailing lists or on the forums but while I was looking for temporal, people may have

Re: Querying on subsets of one-to-many and many-to-many

2004-10-27 Thread Daniel BODEA
to some predefined criteria which wouldn't have left any possibility of ordering the results according to however I eventually wanted them. Daniel - Original Message - From: [EMAIL PROTECTED] To: Daniel BODEA [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, October 26, 2004 6:41 PM

Querying on subsets of one-to-many and many-to-many

2004-10-26 Thread Daniel BODEA
Greetings, I have several solutions to a problem which requires temporary or cache tables but the different solutions are time consuming to test for performance and I was wondering if anyone had more information on this than myself. The server is 3.23.40 without possibility for upgrade to 4.x

Re: Querying on subsets of one-to-many and many-to-many

2004-10-26 Thread Daniel BODEA
trip only. Daniel - Original Message - From: [EMAIL PROTECTED] To: Daniel BODEA [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, October 26, 2004 3:41 PM Subject: Re: Querying on subsets of one-to-many and many-to-many Under most circumstances, even with data tables as large