How Much Normalization is Enough? I’m pretty sure you’ve already had enough of this topic as well. I have had a number of contacts from accidental DBAs and new developers in appreciation of the great lessons shared from real world problem solving. J writes in with an ERD (Entity Relationship Diagram) emphasizing how detailed you can get with your normalization. […]
Other News
APEX 4.1 – Error Handling Improvements – Part 2
(Patrick Wolf) After yesterdays introduction into the new Error Handling Function Callback, I want to continue with another new feature in the error handling area – Error Display Location for Processes.
Download DB2 Express-C 9.7.4
(Antonio Cangiano) Last week IBM released DB2 Express-C 9.7.4. This new version of the free flagship database by IBM mostly focuses on enhancements rather than new features, as you can read in this developerWorks article by my colleague Raul, “What’s new with DB2 Express-C 9.7.4“.
Aggregating XML Node Text In A ColdFusion XML Document
(Ben Nadel) The other day, I was working with XML data that represented HTML markup coming back from a Yahoo! Query Language (YQL) request. By default, ColdFusion XML documents consider the XmlText value of an XML node to only be the aggregate of the text nodes that are the direct descendant of a gi
Spatial Types in the Entity Framework
(Pedro Ardila) One of the highly-anticipated features coming in the next version of Entity Framework is Spatial support. The team has been hard at work designing a compelling story for Spatial, and we would love to get your feedback on it. In this post we will cover:
The two even more fundamental performance metrics
(Baron Schwartz) In a recent blog post, I wrote about four fundamental metrics for system performance analysis. These are throughput, residence time, “weighted time” (the sum of all residence times in the observation period — the terminology is mine for lack of a better name), and concurrency.
Introduction to ASP.NET MVC 3
(ambilykk) ASP.NET MVC framework follows the well-defined MVC pattern to create a web application. MVC design pattern is used to separate the different parts of the application for more scalability, extensibility and testability purpose.
Legacy application modernization: Make SOA work for you
(Timothy Vibbert) For many years, numerous IT organizations developed applications within their own silos. Enterprises have received tremendous value from these assets — which now can be considered legacy applications — thanks to enhancements and feature enrichments.
Creating Standby database using Active Duplication – Oracle Database 11g
(Advait Deo) Oracle database 11g introduced a new feature called Active database duplication. Using this feature you can create a new database (primary/standby) from your current running database. This feature does not needs any backup to be taken, nor we have to do any restore.
One possible reason for increasing DSNZPARM MXDTCACH
(Willie Favero) I’ve been messing around with ZPARMs again. Between recent data warehousing on System z testing and trying to write a new DSNZPARM presentation based on the changes in DB2 9 and DB2 10, I’ve come across a few interesting tidbits I thought I should share.