(Matt Hines) Oracle has again increased its cash offer, but says this will be the last attempt to acquire its rival. Oracle said that it has increased its cash offer for enterprise software maker PeopleSoft to $26 per share, presenting its rival’s shareholders with a $9.4bn hostile takeover bid.
Other News
An Introduction to Schematron
(Eddie Robertsson) The Schematron schema language differs from most other XML schema languages in that it is a rule-based language that uses path expressions instead of grammars. This means that instead of creating a grammar for an XML document, a Schematron schema makes assertions applied to a spec
Use REORGCHK to update table statistics
When you update table statistics using the RUNSTATS command, it requires that you run the command against each table, one by one. REORGCHK gives you the capability to update the statistics of a group of tables or all the tables in the database, with only one command.
Reporting Services: An Offer You Can’t Refuse
(Michael Otey) SQL Server 2000 Reporting Services is one of the best late Christmas gifts you’ll ever receive. Reporting Services—an add-on for SQL Server 2000 that delivers report authoring, management, and delivery capabilities—fills the one big hole that still exists in SQL Server: the inability
Everyplace Makes Data Mobile
(Rick Grehan) DB2 Everyplace gets high points for ease of installation: I had a handheld database ready and synchronized not more than an hour or so after I’d installed the product. All the tools and their controls were arranged so that it was easy to figure out what to do and in what order.
Using LogMiner
(Frank Pantaleo) This tip is about using LogMiner to replicate data between a production instance and a remote instance. The biggest advantage is this technique does not require any changes to the production instance if you are just capturing inserts. If you want to capture updates/deletes there are
Check if IP address is in private IP range
(kgayda) Function to allow for checking if an IP address is a private IP address. Will convert the IP to a bigint equivalent if within the private range, otherwise it will return null if IP is a public address. (R)(script)
XML Namespaces FAQ
(Ronald Bourret) The XML namespaces recommendation defines a way to distinguish between duplicate element type and attribute names. Such duplication might occur, for example, in an XSLT stylesheet or in a document that contains element types and attributes from two different DTDs. An XML namespac
Store large XML documents in relational databases
(Brian Schaffner) When storing XML documents in relational databases, you may experience difficulties depending on your approach and, in particular, the size of the documents. This column will examine some specific problems related to large XML documents and the techniques to overcome them. (R)
DB2 UDB V8 and WebSphere V5 Performance Tuning and Operations Guide
(Whei-Jen Chen, Peter Z. He, Andreas Paulsen, Sunminder S Saini and Kang Young Ying) This Redbook discusses the integrated environment of DB2 UDB and WebSphere Application Server (WAS) including design considerations, best practices, operation, monitoring and performance tuning. We provide an ove