Ken North is editor of SQLSummit.com, WebServicesSummit.com, and GridSummit.com. He was the XML and Web Services Editor  for Dr. Dobb's. He wrote the Database Developer column for Web Techniques and Dr. Dobb's Sourcebook (CMP Media) and was a Contributing Editor for Internet Computing (Ziff-Davis). His articles have appeared in a variety of publications. Some of his white papers, magazine articles and source code are available on the Internet.

White Paper:

SQL Query Performance Metrics for ODBC and Oracle Call Interface explains API performance tests using Oracle Call Interface and wire protocol ODBC drivers from DataDirect Technologies.

 

 

Last Update: May 21, 2004


"Give and Take: Integrating Information in the 21st Century" (DB2 magazine, Quarter 2, 2004)

"XQuery and SQL: Vive la Différence" (DB2 magazine, Quarter 3, 2003)

"Benchmarking SQL Application Programming Interfaces" (The Data Administration Newsletter, July 2003)

"The Center of the Universe" (Intelligent Enterprise, May 2003)

"Schema, query: Is it database or XML?" (searchDatabase, February 2001)

 " XML and Databases: Too Much Confusion"  (XML-Journal, Volume 1, Number 2)

"Text Indexing, XML Searches, and other Database Tricks" (Web Techniques, February 2000) discusses storing XML in databases, indexing techniques, and SQL DBMS support for XML.

"Examining Visual Studio Database Developer Tools" (SQL Server, July 1999) discusses the database tools that are part of Microsoft Visual Studio.

The premiere issue of XML magazine included "Oracle: Powered by Java and XML". The article discusses Oracle's XML-related technologies and includes example Java code for storing XML documents in Oracle tables.

"Oracle 8i and JDeveloper Suite" (Web Techniques, December 1999) discusses Oracle's tool suite for developers using enterprise Java and XML.

"Oracle 8i, Java, and the Mustang Index" (Web Techniques, November 1999) discusses Oracle and development of server-side code for JServer. It's the first of two columns about Oracle 8i and JDeveloper Suite. 

"Extenders, UDFs, and Stored Procedures (Dr. Dobb's Journal, August 1999) explains object-relational database extensions. It also discusses how to use Java and other languages to develop stored procedures and to add functions to IBM DB2 SQL.

"The Ascendancy of Java Data Access" (Web Techniques, August 1999) discusses ancient Rome and the modern Web. It explains JDBC 2.0 and Java's support for object-relational databases.

"OLAP for Java Developers" (Java Pro, July 1999) is now available on the Web.   It discusses enterprise information portals (EIP), multidimensional data, star schemas, APIs and programming issues.

Interested in data modeling, object modeling, and content modeling. Read "Metadata, Modeling, and XML" (Web Techniques, June 1999). "Modeling, Data Semantics, and Natural Language" (Web Techniques, July 1999) explores semantic modeling, data models, Object-Role Modeling and Visio Enterprise.

"Cooking with Database Ingredients" (Web Techniques, April 1999) discusses Microsoft Visual InterDev and Visual Studio's database tools. "Cooking with Visual InterDev and Enterprise Application Ingredients" (Web Techniques, May 1999) explores VID and Visual Studio solutions for writing scalable enterprise applications.

"Java in the Database" (Java Pro, March 1999) explains SQLJ, Java classes installed in databases, and how the major SQL vendors are supporting Java in their servers.

"Tool Suites, MDX, and SQLJ" (Web Techniques, January 1999) discusses embedded SQL for Java and multidimensional expressions that extend SQL for querying OLAP servers. It was a Web Influence Top 100 selection for April 1999.

Transaction Processing with Java? Read "XA, Java Ease Distributed TP" in PC Week (December, 1998).

"Database Research: New Solutions for Accessing Information" (Web Techniques online) discusses similarity searching and domain vocabularies.

If you are looking for the companion source code for an article, or the article itself, check the lists below. If you don't find what you want, examine the following list of Web sites, select a site, and check its archives.

 

Interested in a tutorial?

"Distributed Transactions, SQL, and Application Servers" discusses XA, Java, and large-scale OLTP.
"Web Databases: Fun with Guests or Risky Business" (Web Techniques, March 1999) discusses mission-critical databases and SQL security techniques.
OLTP, OLAP, and OLCP -- what's the difference?
"Y2K, DBFs, and the Web" discusses Y2K problems with databases, browsers, scripting languages, operating systems, developer tools, and Java
  "Server-Side Procedures" explains SQL stored procedures (includes example SQL scripts)
"Java, JDBC, Stored Procedures, and Server-Mania" explains JDBC programs that use stored procedures. It also discusses Informix Dynamic Server and plug-ins such as the Web DataBlade. Includes Java code for enumerating a database's stored procedures.

"Microsoft APIs Expand Web Data Access Options" explains Universal Data Access with ODBC, OLE DB, and ADO
"New Servers, New Architectures, and Logic in the Database" explains extensible servers, universal databases, logic in the database, and SQL99 standards
"Distributed Computing and Windows NT 5.0" explains NT services that support distributed computing
"Portable SQL Programming with Java" explains writing interoperable code with Java and SQL
"Database Programming with OLE and ActiveX" explains OLE DB, ADO and Oracle Objects for OLE

"Building Web Databases" explains Web database connectivity and JDBC
"Performance Testing, ODBC, and Native SQL APIs" explains SQL API performance testing software written in C
"The Future of Data Access" discusses data access APIs
"Understanding ODBC 3.0, Standards and OLE DB"
"JDBC turns up database heat under Java" explains Java Database Connectivity

"Streamline Database Applications" explains ODBC servers, RPCs and middleware
"Understanding Sniffers and Spies" explains database sniffers and trace tools
"Understanding OLE" explains COM, service layers and a list of standard interfaces
"Nile: Microsoft's Data Integration Initiative" explains OLE DB.
"Understanding ODBC and Multidatabase APIs" is a primer on the ODBC API and programming concepts.
"ODBC Reality and Developer Experiences" is feedback from ODBC developers.

Information about a product or technology?

"Cooking with Database Ingredients" (Web Techniques, April 1999) discusses Microsoft Visual InterDev and Visual Studio's database tools.
"Cooking with Visual InterDev and Enterprise Application Ingredients" (Web Techniques, May 1999) explores VID and Visual Studio solutions for writing scalable enterprise applications.
"Java, XA Ease Distributed TP" discusses the XA standard for distributed transaction processing and Java transaction processing APIs
"Dynamic Servers and Web Pages in a Database" discusses Informix Dynamic Server with Universal Data Option, the Web Integration Option, and Data Director for Web
"APIs for Universal Database Programming" explains programming solutions for IBM DB2 Universal Database

"IBM DB2 Goes from Glass House to Global Village" describes DB2 Universal Database
"Sybase Puts Java on Enterprise Pedestal" describes Sybase enterprise Java tools
"Visual Cafe' Pro Marries Java, Databases"
"Microsoft Takes Aim at Distributed Computing" describes ActiveServer and Microsoft distributed computing technologies
"Enterprise Developers Look Towards Tried and True" discusses messaging middleware, RPCs, and TP monitors

"ODBC Extends Reach to Servers and Web"
"Windows and Databases Meet the Inter(intra)net"

Try the Web sites below if you don't care for this selection of articles.

Looking for a Magazine's Web Site?

Ken's articles have run in these magazines that have a presence on the Internet:

If an article included example source code, the next section includes the date, description and file size of program files. ZIP files may require WinZIP, PKUNZIP or other utility to decompress ZIP archives. Computer publications are continually updating their Web archives. If you don't find an article or source code, check back at the site from time to time.

Interested in program examples and source code?

The articles below include source code and scripts written in Java, XML, SQL, Borland C++, Visual C++, C, and Visual Basic. If you are interested in examples for Visual Basic, C++, PowerBuilder, SQLWindows, ObjectView, AppWare or FoxPro, take a look at Windows Multi-DBMS Programming. It also contains data access macros for Excel and Word.

Magazine sites often provide a link to program archives on a Web page. If you can't find a link to code archives or an ftp server, send an e-mail message to the site Webmaster and ask for instructions.

 

 

(Dr. Dobb's Sourcebook, May/June 1997) "ODBC, JDBC and the Quest for a Black Box" includes a Java program that uses JDBC metadata methods to get type information. Click here for the German translation. Click here for the Chinese translation.

(Windows NT, February 1997) "Portable SQL Programming with Java" includes a Java program that demonstrates SQL parameter queries.

(Web Techniques, September 1996) "Building Web Databases" included a Java example of adaptive SQL programming. The program checks to see whether a data source supports the SOUNDEX() scalar function. Click here to download the listing.

(Dr. Dobb's Sourcebook of Database Programming, Jan/Feb 1996) "Performance Testing, ODBC, and Native SQL APIs" included a Windows C application for benchmarking ODBC versus native SQL APIs. Click here to download APIBENCH.ZIP (232k).

(Dr. Dobb's Journal, March 1994) "Database Development and Visual Basic 3.0" included an example application to demonstrate data access with data-aware controls and video playback with the Media Control Interface. The file size is 932k. Click here to download from Dr. Dobb's ftp server.

(Dr. Dobb's Sourcebook of Windows Programming, Fall 1993 Sourcebook) "A Generic SQL Class Library" included C++ classes for SQL programming. The library requires two files: SQL.ASC (53k) and SQLHDR.ZIP (13k). Click here to download WINDOWS.ZIP from Dr. Dobb's ftp server. Once you've downloaded the file extract SQL.ASC.

(DBMS, March 1994) "Understanding ODBC and Multidatabase APIs" included an example C++ program that reports whether an ODBC data source supports stored procedures: INTRGA.CPP (13k)

(Windows Tech Journal, September 1993) "Easy on the Eyes" included Borland C++ classes for speech generation and validated edit controls using OWL. The WinTech description said "Ken North's talking proofreader." Source code for that issue is in WTJ020.ZIP. PennWell is no longer publishing Windows Tech Journal, but the code archives are available from CompuServe (GO SDFORUM, download from the WinTech library).

(Visual Developer (formerly PC Techniques), April 1993) "Portable SQL Programming in C" includes source code for SQL programming for NetWare SQL and Q+E Database Library. All of the files for that issue are in PCTV4N1.ZIP (165K). Click here to download.

 

Ken North Home Page
Ken North Computing

Ken North

· Information Systems Consulting · Software Development · Seminars · Product Development

Copyright © 1997-2004,  Ken North. All rights reserved.

Last update: May 23, 2004