dbTalk Databases Forums  

Re: Book about query processing / query optimization searched

comp.databases comp.databases


Discuss Re: Book about query processing / query optimization searched in the comp.databases forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Cimode
 
Posts: n/a

Default Re: Book about query processing / query optimization searched - 10-04-2007 , 11:44 AM






On 4 oct, 18:14, Elcaro Nosille <Elcaro.Nosi... (AT) mailinator (DOT) com> wrote:
Quote:
I'm looking for a book that describes query-processing and
query-optimization according to the current state of the art.

Has anyone read the following title?

"Principles of Database Query Processing
for Advanced Applications"
ISBN-10: 1558604340
http://www.amazon.com/dp/1558604340/
A total waste of time and money...(it does cost 67$ !!!)

Except from the first few lines...

*In a relational database, data is organized into table format*




Reply With Quote
  #2  
Old   
Cimode
 
Posts: n/a

Default Re: Book about query processing / query optimization searched - 10-04-2007 , 04:50 PM






On 4 oct, 19:05, Elcaro Nosille <Elcaro.Nosi... (AT) mailinator (DOT) com> wrote:
Quote:
Cimode schrieb:

A total waste of time and money...(it does cost 67$ !!!)

Why?
Cause you will get a better value by people who do not continuously
redefine RM.

http://www.amazon.com/dp/0201485559?...BE2TV51AMAPF4&


Quote:
Except from the first few lines...
*In a relational database, data is organized into table format*

Do you think you can estimate the quality of a book by evaluating
the first lines?
I dunno but thanks to some people like F.PASCAL and a few others, I
can smell cookbook declarations and non commitment to terminology from
miles.



Reply With Quote
  #3  
Old   
--CELKO--
 
Posts: n/a

Default Re: Book about query processing / query optimization searched - 10-05-2007 , 09:08 AM



Database Tuning by Dennis Shasha $ Philippe Bonnet (ISBN
1-55860-753-6) is a pretty good overview. But I would head for
academic publications like TODS from ACM and look at articles. Cheap,
fast storage and parallelism in the hardware is changing everything.

--CELKO--




Reply With Quote
  #4  
Old   
MeBuggyYouJane
 
Posts: n/a

Default Re: Book about query processing / query optimization searched - 10-12-2007 , 10:15 PM



--CELKO-- wrote:
Quote:
Database Tuning by Dennis Shasha $ Philippe Bonnet (ISBN
1-55860-753-6) is a pretty good overview. But I would head for
academic publications like TODS from ACM and look at articles. Cheap,
fast storage and parallelism in the hardware is changing everything.

--CELKO--



hmmm. You've been following my sundry blogging?? Just kidding. But
not about the point. I don't follow hardware all that closely; then I
ran across a reference to an interview with Linus Torvalds, which I
read. In it, he referred to file systems and the looming presence of
solid state disks.

Which got me to thinking: if there's no rotational delay in the file
system, then what happens to the standard objection to the Relational
Database; joins are toooooo sloooow. And then, why not, finally, follow
the mantra: one fact, one place, one time?

Mayhaps this will shut up the knuckleheads.


Reply With Quote
  #5  
Old   
--CELKO--
 
Posts: n/a

Default Re: Book about query processing / query optimization searched - 10-13-2007 , 09:02 AM



Quote:
if there's no rotational delay in the file system, then what happens to the standard objection to the Relational Database; joins are toooooo sloooow. And then, why not, finally, follow the mantra: one fact, one place, one time?
I was looking at 8GB memory sticks at Costco yesterday under $20.00.
Look at WX 2 (nee White Cross), Teradata, SAND and Vertica for column
oriented RDBMS products.

In my next book, I carry things one step further. JOINs will become
cheaper than computations in the near future -- they are mostly
equality tests or simple comparisons. So more stuff will be done by
table look up in parallel hardware.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.