(Matt Bauer) Mobile applications and technologies have created an increased need for storing, mapping, and analyzing spatial data. Traditional database techniques have stored this spatial data in X and Y columns to form various geometries. This technique allows only limited indexing and querying, ma
Other News
Oracle9iR2 Shared Pool Advisory
(James Koopmann) If you want to get the most out of Oracle, you will have to learn how to size its internal memory structures. Let’s take a look at the Shared Pool, what it is composed of, and a new tool that Oracle has given us tune it. As an Oracle DBA, you quickly learn one the golden rule in
What’s new with MapPoint 2004, anyway? (Hint: XML!)
(Steve Lombardi) There are two ways a developer can leverage MapPoint 2004 in their applications. First off, it is very easy to use Visual Basic for Applications (VBA) to quickly customize the UI. This is a great way to go if the MapPoint ‘out of the box’ User Interface is close to what you need, an
Review: eXpress Persistent Objects for .NET
(Mike Gunderloy) Here’s another product to make the link between objects in your .NET code and a database for persistent storage. The DevExpress folks have done a good job of making the most common case easy.
Combining Triggers and UDFs
(Kulvir Singh Bhogal and Kwang Sik Kang) Ever notice how DBAs in large enterprises are frightened by the thought that their data is being manipulated by applications without their knowledge? They may not like it, but it’s an inescapable reality. This article outlines how to use triggers and UDFs
How to Build a Metadata Bridge for DB2 Cube Views
(John Poelman) The target audience for this article are technical managers and staff who are interested in developing or integrating OLAP applications on top of IBM® DB2® Universal Database™ V8 (UDB) using the DB2 Cube Views application programming interface (API). The information is especially rele
Taking Up Collections
During its lifetime, Oracle PL/SQL has become faster, easier to use, and richer in its feature set. Oracle Database 10g continues this PL/SQL tradition of speed, ease, and feature growth by offering a useful array of enhancements, including: –Dramatically faster excution speed, thanks to transp
Installing and Running the JDBCTM API Test Suite
The JDBCTM API test suite contains tests useful for testing a driver based on JDBC technology (“JDBC driver”) for it’s conformance to the requirements of the JavaTM 2 Platform Enterprise Edition (J2EETM). This test suite is intended to assist driver vendors in preparing their drivers for certificati
Replication Monitoring Center for DB2
Replication Monitoring Center for DB2 is a software tool that supports DB2 replication supervision. It is used atop DB2 DataPropagator, the DB2 UDB data replication feature. The Replication Monitoring Center for DB2 is used to supervise replication scenarios, reporting configuration, and operational
SQL Date Handler function
If you’ve ever written a script that needs to UPDATE or INSERT Date values in a database AND you live outside of North America, then I’d nearly bet that (like me) you’ve stayed up until midnight cursing the fact that all dates in SQL Server and MS-Access are natively converted from US date format (