A Federated Database System is a Multidatabase Server which Provides Access and Integrate Data from different data sources so that information can be shared while controlling the business rules for access. Here is an example of joining two UDB databases …the entire exercise is divided into 5 basi
Other News
Useful Undocumented Extended Stored Procedures
(Alexander Chigrik) Extended stored procedure is a dynamic link library that run directly in the address space of SQL Server and is programmed using the SQL Server Open Data Services API. You can write your own extended stored procedure in a programming language such as C. You can run extended store
Alter table – good or bad?
(Nigel Rivett) You have a production table and wish to add or change a column. How do you do it? One way is to create a new table with the new structure, copy all the data across, delete the old table, rename the new table, apply constraint, foreign keys etc. A much simpler way is to use alte
Unify Data Access with Linked Servers
(Roger Jennings) The LinkSvrs.vbp project’s frmLinked form has textboxes to enter the master SQL Server name and initial catalog—OAKMONT-DC1 and BeckwithSQL, respectively—for most of this article’s examples. After connecting to the database, a listbox displays the friendly names and provider names o
Parsing XML with PHP
(Tobias Ratschiller) I will be the first to admit that I love computing standards. If every vendor adhered to an industry standard, I think the web would be a better medium for everyone. Using standardized data exchange formats, open, platform-independent computing models become feasible. It is for
Adding Value with Ultra Search
(Douglas Scherer) Oracle9i adds new multisource search capabilities through Oracle Ultra Search, which lets you easily combine data from multiple source types into one searchable index and provides a configurable crawler. The crawler visits the specified data sources at scheduled times, follows link
SQL Server: Advantages and Drawbacks of User-Defined Functions
(Baya Pavliashvili) In the previous article in this series, I introduced you to user-defined functions (UDFs), which are excellent tools for certain programming tasks. This article discusses the advantages and limitations that are associated with UDFs, and shows you the coding tasks that qualify as
The Trigger-Happy DBA – Part 2
(Steve Callan) Here is a problem many developers run into: ORA-04091 table owner.table_name is mutating, trigger/function may not see it. In many cases, the cause of this error is due to code within a trigger that looks at or touches the data within the table the trigger is being called or invoked f
XML DOM Tutorial — Free
The XML Document Object Model is a programming interface for XML documents. The DOM defines the way an XML document can be accessed and manipulated.
Migrating from SQL Links to dbExpress using IBM DB2
(Bob Swart) In this article, I will demonstrate two different data access technologies from Borland that are available to Delphi (and C++Builder) developers when they want to connect to IBM DB2 Universal Database (UDB) tables, and when they want to work with the data inside those DB2 tables. One