Re: [GENERAL] set theory question

2011-02-05 Thread Vincent Veyron
Le vendredi 04 février 2011 à 19:08 +0100, Yeb Havinga a écrit : On 2011-02-03 18:41, Wappler, Robert wrote: On 2011-02-02, matty jones wrote: I am looking for a good book on the math and/or theory behind relational databases and associated topics.. I am looking some works on set

Re: [GENERAL] set theory question

2011-02-04 Thread Yeb Havinga
On 2011-02-03 18:41, Wappler, Robert wrote: On 2011-02-02, matty jones wrote: I am looking for a good book on the math and/or theory behind relational databases and associated topics.. I am looking some works on set theory, algebra, or any other books/papers on the mechanics that databases

Re: [GENERAL] set theory question

2011-02-03 Thread Andy Colson
On 2/2/2011 4:58 PM, matty jones wrote: I am looking for a good book on the math and/or theory behind relational databases and associated topics.. I am looking some works on set theory, algebra, or any other books/papers on the mechanics that databases are built on. I found one book online,

Re: [GENERAL] set theory question

2011-02-03 Thread Rich Shepard
On Thu, 3 Feb 2011, Andy Colson wrote: I am looking for a good book on the math and/or theory behind relational databases and associated topics. Dont know any books, but have you read the wikipedia page? Try any book by Edgar F. Codd. While at IBM he developed the concept of relational

Re: [GENERAL] set theory question

2011-02-03 Thread Wappler, Robert
On 2011-02-02, matty jones wrote: I am looking for a good book on the math and/or theory behind relational databases and associated topics.. I am looking some works on set theory, algebra, or any other books/papers on the mechanics that databases are built on. I found one book online, I

[GENERAL] set theory question

2011-02-02 Thread matty jones
I am looking for a good book on the math and/or theory behind relational databases and associated topics.. I am looking some works on set theory, algebra, or any other books/papers on the mechanics that databases are built on. I found one book online,

Re: [GENERAL] In theory question

2007-05-10 Thread Hannes Dorbath
On 09.05.2007 17:30, Erik Jones wrote: On 09.05.2007 16:13, Naz Gassiep wrote: I think this is close to what MySQL's query cache does. The question is if this should be the job of the DBMS and not another layer. At least the pgmemcache author and I think that it's better done outside the

[GENERAL] In theory question

2007-05-09 Thread Naz Gassiep
This may be a question for -hackers, but I don't like disturbing them unnecessarily. I've been having a look at memcached. I would like to ask, is there any reason that, theoretically, a similar caching system could be built right into the db serving daemon? I.e., the hash tables and libevent

Re: [GENERAL] In theory question

2007-05-09 Thread Michael Glaesemann
On May 9, 2007, at 9:13 , Naz Gassiep wrote: I've been having a look at memcached. I would like to ask, is there any reason that, theoretically, a similar caching system could be built right into the db serving daemon? This is all a bit above my head, but have you looked at pgmemcached?

Re: [GENERAL] In theory question

2007-05-09 Thread Hannes Dorbath
On 09.05.2007 16:13, Naz Gassiep wrote: This may be a question for -hackers, but I don't like disturbing them unnecessarily. I've been having a look at memcached. I would like to ask, is there any reason that, theoretically, a similar caching system could be built right into the db serving

Re: [GENERAL] In theory question

2007-05-09 Thread Tom Lane
Naz Gassiep [EMAIL PROTECTED] writes: I.e., the hash tables and libevent could sit on top of postmaster as an optional component caching data on a per-query basis and only hitting the actual db in the event of a cache miss? How does the cache know when the database contents change?

Re: [GENERAL] In theory question

2007-05-09 Thread Naz Gassiep
Hannes Dorbath wrote: I think this is close to what MySQL's query cache does. The question is if this should be the job of the DBMS and not another layer. At least the pgmemcache author and I think that it's better done outside the DBMS. See

Re: [GENERAL] In theory question

2007-05-09 Thread Joshua D. Drake
Naz Gassiep wrote: Hannes Dorbath wrote: I think this is close to what MySQL's query cache does. The question is if this should be the job of the DBMS and not another layer. At least the pgmemcache author and I think that it's better done outside the DBMS. See

Re: [GENERAL] In theory question

2007-05-09 Thread Naz Gassiep
This is exactly what I was asking about. So my theoretical idea has already been implemented. Now if only *all* my ideas were done for me by the time I came up with them :) Then you wouldn't be able to eventually patent them ;) What an un-BSD licensish thing to say :P

Re: [GENERAL] In theory question

2007-05-09 Thread PFC
This may be a question for -hackers, but I don't like disturbing them unnecessarily. I've been having a look at memcached. I would like to ask, is there any reason that, theoretically, a similar caching system could be built right into the db serving daemon? I.e., the hash tables and libevent

Re: [GENERAL] In theory question

2007-05-09 Thread Karsten Hilbert
On Wed, May 09, 2007 at 10:29:02AM -0700, Joshua D. Drake wrote: This is exactly what I was asking about. So my theoretical idea has already been implemented. Now if only *all* my ideas were done for me by the time I came up with them :) Then you wouldn't be able to eventually patent them

Re: [GENERAL] In theory question

2007-05-09 Thread Joshua D. Drake
Karsten Hilbert wrote: On Wed, May 09, 2007 at 10:29:02AM -0700, Joshua D. Drake wrote: This is exactly what I was asking about. So my theoretical idea has already been implemented. Now if only *all* my ideas were done for me by the time I came up with them :) Then you wouldn't be able to

Re: [GENERAL] In theory question

2007-05-09 Thread Alvaro Herrera
Joshua D. Drake wrote: Karsten Hilbert wrote: On Wed, May 09, 2007 at 10:29:02AM -0700, Joshua D. Drake wrote: This is exactly what I was asking about. So my theoretical idea has already been implemented. Now if only *all* my ideas were done for me by the time I came up with them :) Then

Re: [GENERAL] In theory question

2007-05-09 Thread Joshua D. Drake
Alvaro Herrera wrote: Joshua D. Drake wrote: Karsten Hilbert wrote: On Wed, May 09, 2007 at 10:29:02AM -0700, Joshua D. Drake wrote: This is exactly what I was asking about. So my theoretical idea has already been implemented. Now if only *all* my ideas were done for me by the time I came up

Re: [GENERAL] In theory question

2007-05-09 Thread David Fetter
On Wed, May 09, 2007 at 10:29:02AM -0700, Joshua D. Drake wrote: Naz Gassiep wrote: Hannes Dorbath wrote: I think this is close to what MySQL's query cache does. The question is if this should be the job of the DBMS and not another layer. At least the pgmemcache author and I think that it's

Re: [GENERAL] In theory question

2007-05-09 Thread Naz Gassiep
I have always found MySQL's query cache to be utterly useless. Think about it this way : It only works for tables that seldom change. It does not work for big tables (like the posts table of a forum) because the cache would have to be huge. So, the most frequent usage