(Peter Gulutzan) Andrey Hristov added “Events” for MySQL version 5.1 when he was working on his master’s thesis for the University of Applied Sciences in Stuttgart. We liked the feature a lot, and now Andrey works for MySQL. An inspiring story, eh? And now MySQL 5.1 is getting stabler, it’s “beta” i
Other News
Query Parameters and Information Handling with Databases
(Jim Keogh) In the preceding example, the value of the search criterion was inserted into the WHERE clause of the query. In the real world, however, the visitor to your web site usually enters the search value into a web form. Therefore, you need to have a placeholder for the search criterion in the
Leverage the Spatial Extender: Creating an automatically maintained spatial table from latitude-longitude column data (DB2 Edition)
(Robert Uleman) Whether derived from address information, acquired by GPS devices, or otherwise generated, many databases contain geographic coordinates of point locations as separate numeric columns in a table. In this form, however, they are not usable for detecting spatial relationships by using
Remove sensitive content from your XML samples with XSLT
(Uche Ogbuji) You might have run into this scenario if you work with XML files that contain sensitive data: You run into a problem, perhaps a bug, with your favorite XML processing tool. You need to send the vendor an example of a file that triggers the bug. You can’t just send random XML files beca
Magellan’s Second Voyage: Site Navigation Tools in ASP.Net 2.0, Part 2
(Peter Aitken) In a previous article, I introduced you to ASP.Net 2.0’s site navigation tools. We saw how the Menu, TreeView, and SiteMapPath controls can be bound to a Web.Sitemap file, to quickly and easily provide navigation elements on your pages. When you go beyond these basics, however, you wi
Create and Populate Treeviews Dynamically
(Nagasai Mattegunta) In my recent project, a part of requirement is, to generate KPI score card. The KPI score card is a chart showing the KPI in tree like structures. All the KPIs are categorised and each category represents a tree. The tree hirarchy is defiend in database. This basically requires
Cut storage consumption in half with DB2 Viper Compression
(Chris Eaton) The next new feature in Viper that I want to talk about is row compression. DB2 has a number of types of compression in v8. For example there is value compression where the storage space for nulls and system defined defaults can be compressed out. There is also MDC which results in sig
Best Practices for Using WebSphere Business Modeler and Monitor
(Stephen White) The purpose of this Redpaper is to provide guidance for the preparation of business process models, developed with the WebSphere Business Modeler, which will ultimately be monitored by the WebSphere Business Monitor. The model preparation, including business measure development, and
Efficiently Paging Through Large Result Sets in SQL Server 2000
(Scott Mitchell) When displaying large amounts of data to a user, it’s important that the information be presented in digestible chunks rather than slamming it all down their throats at once. For example, searching for “Microsoft” on Google returns approximately 2,190,000,000 results, but thankfully
Collaborate ’06 Preview: IOUG’s Kaplan on RAC, security, mobility and more
(Mark Brunelli) One of the biggest Oracle user conferences of the year — Collaborate ’06 — kicks off later this month in Nashville. The conference, which this year represents the combined efforts of the Independent Oracle Users Group (IOUG), the Oracle Applications Users Group (OAUG) and the Quest