(Paul C. Zikopoulos and Roman B. Melnyk) Today’s databases (and especially data warehouses) have become so large, and their query workloads have become so complex, that it is often impractical and even unnecessary to retrieve all of the data that may be relevant to a particular query. Rather than us
Other News
Tuning DB2 SQL Access Paths
(Craig S. Mullins) Visual Explain is a phenomenal tool in IBM® DB2® Universal DatabaseTM that can be used by programmers and DBAs to detail the access paths chosen by the DB2 optimizer for SQL statements. Indeed, Explain should be a key component of your performance monitoring strategy. The informat
Synchronize Your Databases with .NET Web Services (Part I)
(Alex Homer) Te Web browser/Web server combination used today was originally designed to deliver HTML, which implicitly contains display information as well as data. But this doesn’t mean that the Web server must deliver HTML. When a page contains an element, or a hyperlink to a ZIP file, the
Oracle Database Resource Manager, Part 3: Conclusion
(Jim Czuprynski) The previous article in this series presented some actual examples of how to use the supplied DRM packages to create new resource plans, resource consumer groups and resource directives that bind them together. The concluding article in this series will discuss the creation of more
Microcontent Management with Syncato
(Kimbro Staken) In the past few years there’s been a surge in popularity for what has become known as blogging. The weblog (or “blog”) is an online journal of links and information. It seems everyone has one now. I’ve written a blog for several years now using Movable Type to manage it. Unfortunatel
Simple JDBC Operations from an Applet
(Umesh Kulkarni) This tip explains the steps required to set up an Oracle JDBC Connection from an applet and subsequently perform JDBC operations using the JDBC connection.
DTD and XML Schema Structures
(Deepak Vohra Ajay Vohra) This article compares Document Type Definition (DTD) and XML Schema elements. Java 2 Enterprise Edition (J2EE) developers use DTDs and schemas in J2EE/XML applications. When a DTD for an XML document is provided and validation with an XML Schema is required, the DTD-to-XML
A DTS Data Store
(Bruce Szabo) Data Transformation Services (DTS) is extremely useful in solving a number of problems.In some cases I have used it to solve data problems and in other cases I have used it to solve some tasks that have nothing to do with SQL. One difficulty I found with DTS was managing the different
Ownership Chains in Yukon
(Amol Kulkarni) When multiple database objects access each other sequentially, the sequence is known as a “chain.” Although such chains have no independent existence, when SQL Server is traversing the links in a chain, it evaluates user permissions on the constituent objects differently than it woul
Find primary key index
(Ravi Nookala) This tip is useful in locating the index name for a corresponding primary key constraint. It displays the details of the primary key along with the corresponding index name for a given owner and tablename. This script has been tested on 7x, 8x and 9x, and works on versions 8x or highe