From: Isolde G. C. <jt...@ho...> - 2007-03-17 23:48:40
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> </head> <body bgcolor="#ffffff" text="#000000"> <img alt="oops" src="cid:par...@ho..." height="314" width="500"><br> Of course, doing so can require action on the part of the DBA to rebind the application code to the DBMS.<br> I have an application development group that wants to implement storage of XML strings as CLOBs.<br> As Alice might put it, IT just keeps getting "curiouser and curiouser. Instead of directly embedding SQL in the program, ODBC uses callable routines. Licensing is usually a dull topic useful for inducing sleep, but this book is different. Although database administrators usually are viewed as system "folk," they most definitely must be tied into the application development and design of their organization.<br> So there is an IDUG conference close to you that you should plan on attending. and it can be applied to database administration somewhat, too. But SHARE has thrived where others have failed due to its adaptability.<br> The DBA must be available to act as a conduit for information and education to flow to the developers who are actually writing the SQL.<br> I met folks that were operating system admins, LAN administrators and dozens of developers that were also going to be DBAs.<br> At IDUG you will get the opportunity to attend over a dozen different presentations on various DB2 topics.<br> Suffice it to say, it can be confusing to figure out whether you can back out to a previous mode or release from whatever current mode you are in. The DBA must understand how these extended data types are implemented by the DBMS vendor and be able to implement and administer any extended data types implemented in their databases.<br> ETL tools that automatically populate data changes from one database out to others can help to keep multiple copies of the same data synchronized. A current favorite though, is The Universal History of Computing: From the Abacus to the Quantum Computer by Georges Ifrah.<br> Here is where I get my greatest payback: What are other shops like mine doing? And how long are you going to stay in compatibility mode? " In other words, if you are a StorageTek customer who does not use Sun servers, you are hoping that Sun will continue to support other servers with its new storage stuff. And you can access your Empress data using your favorite language, too.<br> I'm starting with computer books as everyone reading this is probably in the field of IT. " The DBMS understands the state of the data it stores, and so it can produce efficient and dynamic access paths to the data.<br> When this happens, it is the power of blink that makes it so.<br> If creating software is your discipline, you absolutely need to read and understand the tenets in this book. Dealing with performance problems is usually the biggest post-implementation nightmare faced by DBAs.<br> Finally, I've just started reading Travels in Four Dimensions by Robin Le Poidevin.<br> Adding new features makes the database inherently more complex.<br> Enterprise applications characterized by complexity and high volume typically require high availability and multiple tiers to meet the business requirements of the enterprise.<br> My unit also supports Microsoft databases.<br> But sometimes you can find nuggets of wisdom in the strangest places.<br> Because data consumption and usage continues to grow, the DBA must be prepared to support more data, more users, and more connections.<br> This can speed up performance by reading data from the database without any concern for locking.<br> But the more interesting twist is the benefits that accrue from simply going to CM and staying there for awhile.<br> I met folks that were operating system admins, LAN administrators and dozens of developers that were also going to be DBAs. I'll blog a general interest entry like this every now and then.<br> The DBA must understand all of the physical nuances of each DBMS used by his organization in order to create efficient physical databases.<br> You can even set up your Empress embedded databases to enable dirty reads.<br> </body> </html> |