(Dan Holme) In a typical content database, documents—their metadata and the binary large object (BLOB) that contains their content—tend to consume significant real estate. The content database becomes bloated by the BLOBs it stores.
Other News
The Effect of Max Active on DB2 for i Query Performance
(Anil K. Madan) This article explains how a high Max Active setting for a memory pool can affect the fair share of memory, thereby influencing the DB2 for i query optimizer to sometimes choose an inefficient access plan.
Usability Testing
Usability Testing Lately I’ve been taking time to review the concept of Usability and Usability testing. Whole disciplines have been built up around the practice. Some organizations find it extremely useful while others find it to be misdirection of resources. It seems that the design of the test itself may often be a cause of failure. Like any form of […]
Life After Upgrades
PASS 2011 Starts Today I’m sure many of us would like to be at PASS. For those of us who are not attending, don’t forget that there will be some interesting content available online. Check out www.sqlpass.org/summit for more details. If you’re attending the summit, don’t forget you have the opportunity to make donations helping the homeless in the Redmond […]
Advanced SQL/XML: Joins and FLWOR Expressions in the XMLTABLE Function
(Matthias Nicola) If you look at existing documentation and examples of the XMLTABLE function, you find that most examples use simple XPath expressions inside the XMLTABLE function and rarely more complex XQuery expressions such as FLWOR expressions. This is also true for my 2 articles on XMLTABLE:
Structured Data Gets a Lift
(Jennifer Zaino) How can you not be intrigued by a project whose tag line is, “an elevator for your data.” DataLift, funded by France’s Agence Nationale de la Recherchenatl, is that project, and it’s developing a platform for publishing structured data as Linked Data.
The impact of ASSM on Clustering of data
(Hemant K Chitale) Automatic Segment Space Management (“ASSM”) is designed to reduce block-level contention by multiple sessions concurrently attempting INSERTs by using a bitmap to identify blocks that are on the FreeList.
Silverlight: Basic Integration with SharePoint 2010 WCF Data Services
(Mahesh Sabnis) If you have a requirement of integrating SharePoint 2010 with various client applications built using WinForm, WPF and Silverlight etc. then you can make use of the various out-of-box programming facilities provided by SharePoint 2010.
The world has moved on, have you? Xml APIs you should avoid using.
(Pawel Kadluczka) There is a few Xml APIs you should not be using. In some cases the complier makes this obvious – the API is marked as obsolete and you will get a warning when compiling an application that uses any of these APIs. All the obsolete APIs have their replacements.
What is Sensitive Administrator Functionality in EBS?
(Sanjit Anand) These are Administrator / Developer Functionality.Some of Oracle EBS forms and pages allow a user to modify the functionality of the applications by specifying values such as