Here’s a outline-style look at the different storage elements involved in an Oracle database system.
Other News
Oracle Scheduler
(Arup Nanda) Some of you may use the dbms_job package extensively to submit database jobs to be run in the background, control the time or interval of a run, report failures, and much more. However, I have a feeling that most of you don’t. The problem with the package is that it can handle only
Enterprise Manager 10g Backup, Recovery and Disaster Recovery Considerations
The newest release of Oracle Enterprise Manager Grid Control presents a dramatic architectural departure from the previous releases, incorporating a portable browser based interface to the management console and Oracle’s application server technology to serve as the middle-tier Management Service (O
Create a Lotus Notes application to access DB2 using Domino Designer
(Long Fong Yee and Suita Gupta) This article will show you how easy it is to create an IBM Lotus Notes application, using Domino Designer, to access enterprise data stored in an IBM DB2 Universal Database (UDB). You will learn how to create an application to select, update, delete and insert data. Y
Granting SA Rights to Developers
(Brian Moran) Last month, in “SQL Server Profiler: For Developers, Too” (http://www.winnetmag.com/article/articleid/43268/43268.html ), I encouraged you to integrate SQL Server Profiler into your unit-testing process. IT professionals typically think of Profiler as a DBA tool, but in my article, I o
myLittleAdmin Web-Based SQL Manager Packs a Big Punch
(Anthony Wilko) When a host decides to offer Microsoft SQL Server databases as a feature, customers need a way to access their databases. Usually it is through one of several ways.
Amazon’s Web Services and XSLT
(Bob DuCharme) Amazon Web Services (AWS) provide two ways to get XML versions of the information that Amazon’s customers ordinarily get from HTML web pages: a SOAP interface and a REST interface. It’s nice to see the pains that Amazon takes to make it clear that, when it says “web services” it doesn
Distributed Backup Checking
(Kevin O’Donovan) Having just read Santveer Singh’s article Which databases are being backed up (another look), I thought the following might add something to it. Our situation is slightly more complex. We develop software applications that make use of replicated databases. Our users are distrib
Exception handling
(Paul Yip, Drew Bradstock and Hana Curtis) Anticipating and handling conditions is part and parcel of good, robust programming style. With DB2 SQL procedures, this is accomplished through the use of condition handlers. In fact, it is also desirable to be able to check for and act on warnings that ma
Transfer XML Data to Microsoft Office Excel 2003 with Microsoft Visual Basic .NET
(Frank Rice) Learn different ways to transfer data from an Access database to Microsoft Office Excel 2003. These include using the user-interface, programmatically creating an XML file, transforming the data and reading it into Excel, and automating Excel and programmatically reading the data file.