THIS WEEK: Oracle administration

[searchDatabase]

Title: TechTarget

May 06, 2002 >> Receive this email as text  >> About this e-mail   In this Issue >> From the editor: The future of the DBMS >> Featured Topic: Oracle administration >> Expert Technical Advice: New expert advice, forum posts, and tech tips >> Site Highlights: * New Audio Archive: "Programming SQL Server 2000 with Visual Basic .NET" with Rick Dobson, Ph.D. * New: DB2 Tips Service * To Index or Not Index in DB2: A Vendor Connection Series with Precise Software - Tuesday and Thursday  From the Editor: by Tim DiChiara, Site Editor What does the future hold for the DBMS? That's the intriguing question that "Intelligent Enterprise" posed recently, as we highlighted in this news story The magazine gathered executives from IBM, NCR, and Oracle, and a Stanford computer science professor to give their proverbial two cents. The group identified the most promising current trends and the most pressing problems that they hope will be solved in the future: * Complex systems integration will remain a primary goal. Web services and XML will be key, giving one hope that the current hype is actually substantive. Consolidation and centralization will be necessary to simplify and connect diverse systems. *Database management will become more automated. Self-healing, self-configuring tools will gain prominence. Systems will "exploit the intelligence of the tools rather than of the human being." *The real-time enterprise will be the norm. Large-scale, real-time business intelligence will be possible. * BI technologies--data mining, OLAP, etc--will be fully integrated into the database engine. OLTP with decision support systems will become one. More and more work will be done in the database, rather than moving data out into the middleware. Conversely, other layers will adopt more database-like properties. *On the hardware front, there will be increased adoption of storage area networks, and low-cost, commodity computers arrayed in a rack of "blades" will dominate. * SQL will not die, but will adapt. It will merge with XML and be able to handle multimedia data and analytics. The notions of structured and unstructured data will converge. Other languages will continue to emerge and die over time, but SQL will remain a vibrant language "for centuries."Sorry Fabian * Relational technology will adapt and live on. Relational database servers will be repurposed for use with XML tools. So the future of data management can be summarized as follows: bigger, faster, and cheaper. That's no surprise to you DBAs in the trenches! What do you think the future of the DBMS holds? Click on over to our discussion forum and share your thoughts. I appreciate your feedback! Cheers, Tim  Featured Topic: Oracle administration by Tim DiChiara, Site Editor Oracle is as technically complex as it is dominant in the DBMS market. Oracle DBAs know that all too well. Will 100+ scripts and tips help? How about 300 expert answers to tough Oracle questions? It's all inside, and more... Read more about this topic  Expert Technical Advice: Featured Expert Karen Morton, Owner, Morton Consulting, Inc Category:Oracle Karen is an OCP with over 15 years IT experience and 10 years Oracle experience. She has co-authored several Oracle training coursebooks and taught hundreds of individuals in skills ranging from introductory Oracle to advanced DBA topics. Ask Karen your tough Oracle questions! View Answers This Week: In the forums >> Recursive relation in SQL Server 7 "MSC" is developing a data model that has a recursive relationship. The model is of a tree-structured organization. What is the best way to hold the hierarchy in the data model? Go to our "DBA Water Cooler" forum if you can lend MSC a hand. >> Intro copy: Online reorg for Oracle? Member "Curt" asks: Is there a third-party vendor tool that performs an "online" reorganization of Oracle tablespaces that also clusters the data? Go to our "DBA Water Cooler" forum if you can help. Tip of the Week: According to Fabian Pascal in his May column, among the regressive trends plaguing database practice, one gaining prominence is a return to the bad old days when data management was performed not by DBMSs and databases, but by application programs and files. A new generation of HTML/Java developers, who were not around to experience the plethora of problems caused by that approach, and who lack exposure to the concepts of database and data independence, are extending the object approach from programming to data management, for which it was not intended and is ill-suited. >> To a hammer, everything looks like a nail  Site Highlights New Audio Archive "Programming SQL Server 2000 with Visual Basic .NET" with Rick Dobson, Ph.D. View last week's discussion on combining VB.NET & SQL Server to create slick database solutions & XML web services. New: DB2 Tips Service Get tech tips delivered right to your in-box This new, free monthly service provides some-saving and problem-solving tech tips from experts like DB2 guru Craig Mullins. To Index or Not Index in DB2 A Vendor Connection Series with Precise Software ? Tuesday and Thursday In this 2-part series, master DB2 DBA Haim Kopans will provide valuable training that can help you significantly improve the performance of your production DB2 based applications. Tuesday's session, Theoretical Introduction, is followed by a Thursday discussion on Practical Case Analysis. Pre-register today! 2 Part DB2 Series Join our Vendor Connection Series this week with Precise Software: "To Index or Not Index in DB2" Register Today Web Services Advisor Visit sister site SearchWebServices and get the bi-weekly e-mail by Preston Gralla that explains topics such as SOAP, XML, WSDL and Web services security without all the hype. Subscribe Today Featured Topics Find over 40 targeted reports in one place. Visit and bookmark this page today. Click Here A B O U T   T H I S   E M A I L This e-mail is brought to you by TechTarget where you can get relevant search results from over 19 industry-specific Web sites. If you no longer wish to receive this newsletter simply reply to this message with "REMOVE" in the subject line. Please allow 24 hours for your "REMOVE" request to be processed. Copyright 2002 TechTarget, Inc. All rights reserved.