(Martin Widlake) A negative impact of using Index Organized Tables is that inserts are and updates can be significantly slowed down. This post covers the former and the reasons why – and the need to always run tests on a suitable system. (I’m ignoring deletes for now – many systems never actually de
Other News
International Open Government Datasets: Bring on the Semantic Search!
(Jennifer Zaino) Ten years (and change) since the publication of The Semantic Web article in Scientific American, co-author Jim Hendler says he is “very, very happy and optimistic about the state of semantic technologies and the Semantic Web.”
An ALTER USER to change password updates the timestamp of the password file
(Hemant K Chitale) Apparently, upto 11.2.0.1, the password file is opened and verified and then closed when an ALTER USER … IDENTIFIED BY … is issued for any database account.
IDisposable and Thread Safety
The IDisposable interface should be applied to classes that hold unmanaged resources, either directly or indirectly. When developing using parallel programming or multi-threading techniques, IDisposable should be implemented in a thread-safe manner.
MarkLogic: First steps with the MarkLogic hadoop connector (MarkLogic 5.0-1)
(Alex Bleasdale) If you’ve just installed MarkLogic 5 and you’re interested in spending some time checking out the hadoop connector, this may be a useful accompaniment to all the documentation available from the newly [re]launched MarkLogic Developer Community site.
Finding the Source of Your SQL Server Database I/O
(Gregory A. Larsen) When you are considering performance tuning, what do you look for? There are many things that can affect SQL Server performance: CPU usage, I/O, memory utilization, bad execution plans, inappropriate or missing indexes, and so on. The one thing I tend to find most often when a qu
How To Search for Multiple Occurrences of a String in a ListView
(Ged Mead) In an earlier blog I showed how to search for a word or phrase in any column of a list view, and then select and highlight any rows that contained the search word or phrase. In that first example, I restricted the search in two ways.
The DB2Night Show #Z13: (Almost) Live from IBM IOD 2011
(Scott Hayes) 90% of our studio audience learned something! During this unique show, we gathered up IBM representatives and IBM DB2 GOLD consultants and had them share their perspectives on the IBM Information on Demand 2011 conference.
How to work with the nested GridView (a GridView inside another GridView) and populate the data?
(SheoNarayan) To work with nest GridView (a GridView inside another GridView), we can follow this approach.
Using One Object Per Event Type With Publish And Subscribe (Pub/Sub)
(Ben Nadel) Yesterday, I was reading an interesting article by Miller Medeiros that compared different types of publish and subscribe mechanisms. Publish and Subscribe (Pub/Sub) is nothing new – if you use jQuery at all, you’ve probably been using Pub/Sub a lot (even without thinking about it).