[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: Something altogether different?


user agent key collection db

Hi,



"The problem he found with centralizing processing--with stored 
procedures and triggers and so forth--is that it doesn't scale."

    What is that suppose to mean ? Big databases are kept in server 
farms with some kind of load balancing between them. You have a trigger 
attached to a table. Each time you perform an operation the trigger will 
fire. If the trigger is processor-intensive you will need additional 
processors to handle the load or additional servers to share the load. 
Either way, there are ways to scale such configurations.


"His talk also implied that it restricts users from making innovative 
connections."

    ?!!?!?! How is that ? Nobody forces you to use triggers and stored 
procedures and foreign keys. You use them if they are appropriate for 
your application. What is an innovative connection any way ?


"XQuery and Web Services were too big and came too late, however. Nobody 
actually wants to use them, even if they know how."

    It seems to me that "web services" is becoming a cool buzz-word in 
the IT  industry. Maybe I am wrong ?


"It would be a very simple and database-independent protocol that would 
make all data in the world open."

    In what way open ? Perhaps someone should explain what means that 
today's data is closed.
 

"The entire relational approach, from the canon of Third Normal Form 
(three is a holy number) to the enormously complex collection of 
analytic functions, subqueries, and other ways to impose structure in 
SQL, is an attempt to be as precise as possible about the data chosen 
and returned."

    I am not a DB expert but in my understanding a good DB design is 
made in order to avoid duplicate information, increase performance, 
integrity a.s.o. I never heard of somebody designing a DB for "precision".


"Bosworth isn't interested in that. If the user gets a few hundred 
results and has to scroll through them a little bit, that's fine. We 
don't need no stinkin' metadata or knowledge management."

    Most applications are not tolerant to such behavior. And I am not 
sure that the users would accept such a behavior in the first place. 
What is more expensive: processor time or user time ?

    Anyway, this discussion is purely theoretical because from the 
article I do not see any indication as to how this would be possible.


"But his brief critique of the trend toward putting more and more 
features into the database engine--a critique that he whisked through on 
the way to grander visions--left open a question about the basic 
philosophy of SQL."

    This is not a problem of SQL or foreign keys or whatever. This is 
the problem of the database vendor trying to sell the next DB version.

"This centralized control is a relic of the 1970s, when corporate staff 
would sit at command-line processors and type in SQL to do what they 
wanted."

    This is complete bullshit. Current applications make heavy use of 
foreign keys. It's a very efficient way to ensure that the information 
in the database is correct regardless of what is happening with the 
application manipulating the database (and everybody knows that a lot of 
things can happened with the application manipulating the database - 
including *bad* programming; not all software houses have programmers to 
match those that wrote Postgres or Oracle)

"Nowadays, when an application and even a Web interface stand between 
the user and the database engine, the never-trust-the-user philosophy is 
less valid."

    Who can blindly trust the data that they receive from a web 
interface ? This is a sure recipe for disaster.



    To be honest I do not understand what this article propagating. What 
is the revolutionary thing ? If somebody has time, I ask him to drop me 
a line or two about this.

-- 
Regards,
Razvan

SCJP preparation material:

www.mihaiu.name/2004/sun_java_scjp_310_035/index.html
www.mihaiu.name/2004/sun_java_scjp_310_035_test1/index.html
www.mihaiu.name/2004/sun_java_scjp_310_035_test2/index.html
www.mihaiu.name/2004/sun_java_scjp_310_035_test3/index.html
www.mihaiu.name/2004/sun_java_scjp_310_035_test4/index.html


PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
 

Stylus Studio has published XML-DEV in RSS and ATOM formats, enabling users to easily subcribe to the list from their preferred news reader application.


Stylus Studio Sponsored Links are added links designed to provide related and additional information to the visitors of this website. they were not included by the author in the initial post. To view the content without the Sponsor Links please click here.

Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.