(Charles Sterling) I want to create a Windows Application that allows a user to enter/edit/access data that he or she creates without connecting to a remote database. I want all of the data accessing to be local. Is this possible? I was thinking maybe using XML files to store the data and read the d
Other News
XML Repositories: Do We Need Them?
(Adam Bosworth) As XML starts to be used more and more ubiquitously in the industry, both for integrating applications using XML messages and for describing metadata, a hard issue has started to emerge. How do you store XML and retrieve it? Should you use SQL databases or the file system or an XML r
Database Wars: Microsoft vs. DB2
(Vincent Ryan) Microsoft and IBM took very different approaches to developing and marketing high-performance databases, but they arrived in the same place with the same desire: to blanket all-size enterprises with database solutions tailored to the customer’s needs. Microsoft is moving up from t
Installation Cookbooks: Installing Oracle9i
(Steve Callan) When people talk about installing Oracle, more times than not they are referring to installing the program files for the relational database management system (RDBMS) application. Other people use the word Oracle somewhat loosely when referring to any Oracle product (e.g., Forms & Rep
Date, Math and Text Functions in SQL Server 2000
(Baya Pavliashvili) In the previous articles in this series, I introduced you to aggregate and system-related functions. This article continues to explore various types of built-in functions. I will walk you through the most useful functions that fall into date and time, math, and text function cate
The Heterogeneous DBA: Surviving in a Multi-Database Environment
(Chuck Sodowsky) The concept behind the database goes back long before computers and automation were available to businesses. Properly indexed and labeled files and records have always been necessary for a business to get ahead in a competitive environment. Even when paper and ledgers were the data
Modernizing the Mainframe – Unleashing the power of XML and Web services
(Joe Gentry) Central Hudson Gas and Electric, a New York State utility company, wanted to find a way to improve its customer service by creating a Web-based platform where customers could view and retrieve bills online. Replacing or rewriting the company’s 20-year old mainframe billing application w
Using Check Constraints to Simulate Domains
(Craig S. Mullins) All of the popular RDBMS products provide table check constraints: Oracle, Informix, DB2, Sybase, and Microsoft SQL Server. Check constraints enable enhanced data integrity without requiring procedural logic (such as in stored procedures and triggers). Let’s examine the basics of
DTD for Customizing Graphs in Oracle Reports
Reports Builder provides the Graph Wizard to insert graphs in both Paper and Web Reports. Reports Builder uses what you specify on each page of the Graph Wizard to create an XML file (graph.xml). This XML file is used to create the look-and-feel of the resulting graph at runtime. A common require
Overview of DB2’s XML Capabilities: An introduction to SQL/XML functions in DB2 UDB and the DB2 XML Extender
(Cindy Wong) The eXtensible Markup Language (XML) can be used to exchange data between computers. The DB2 XML Extender allows you to integrate IBM DB2 Universal Database (DB2 UDB) with XML. This document will introduce you to the SQL/XML functions available with DB2 UDB version 8 and the DB2 XML Ext