Databases have become the universal means of storing information that is accessed in real time. In a perfect world, databases should function all the time without needing any major maintenance such as a reorganization. However maintenance remains necessary in order to eliminate performance degra
Author: SSWUG Research
Storing XML in Relational Databases
(Igor Dayen) There are various ways to solve the problem of effective, automatic conversion of XML data into and out of relational databases. Database vendors such as IBM, Microsoft, Oracle, and Sybase have developed tools to assist in converting XML documents into relational tables.
Understanding Oracle XML DB
This series of tutorials uses the Simple XML Based Content Management Application to demonstrate programming techniques that take advantage of the features of Oracle XML DB, a feature of Oracle 9i Database Release 2. The Oracle XML DB is fully compliant with the W3C XML data model thereby provid
Tip: Parsing XML documents partially with StAX
(Berthold Daum) The Streaming API for XML (StAX), introduced in the previous tip, provides not only an XML parser that is fast, easy to use, and has a low memory footprint, but one that also provides a filter interface that allows programmers to hide unnecessary document detail from the application’
Avoiding the ORA-12154: TNS: could not resolve service name error
(Steve Callan) Where were you when Oracle9i was released? Okay, so it wasn’t that memorable of an event for most users, DBA’s, and the rest of the world. However, given that Oracle9i was released over two years ago, it is interesting to note that its new features are still being announced, highlight
Simple Object Access Protocol (SOAP)
(Brian Travis and Mae Ozkan) The Simple Object Access Protocol (SOAP) is a standard that has provided a simple solution to a complex problem. The problem is that integrating systems is difficult. That’s not really news, but it is a fact that many I.T. professionals are well aware of. The main area o
Leveraging IT Assets
(Anupam Singh) XML is establishing itself as the standard for exchange of information across enterprises. However, the technology that allows enterprise-class applications to deal with XML processing is still not clearly formulated. This causes most enterprise customers to implement their own archit
Introduction to DataSets with Visual Basic .NET
(Rod Stephens) Loading a DataSet from a database requires much less code than building one inline, though the code is a bit more complicated. Program FromDB shows how you can load a DataSet from a database. Program FromDB uses the code shown in Listing 2 to load its DataSet. The program begins w
Stored Procedures on PHP and Microsoft SQL Server
(David Clark) Though it’s not as common a combination as PHP and MySQL, PHP and Microsoft SQL Server can be a powerful team. You can query SQL Server databases easily and effectively using the PEAR database abstraction layer, just as you would a MySQL database. But once you start trying to use one o
XML Q&A with Darshan Singh
In this article, a continuing series, managing editor Darshan Singh responds to questions asked by visitors. In this part: –Using WinInet to call a Web service –DOM and limiting the size of XML document –Binary data from Visual Basic 6.0 to ASP.NET Web service