(Andrei Cioroianu) Tag files are one of the most important new additions to JavaServer Pages (JSP) technology, allowing Web developers to build libraries of custom tags with the JSP syntax. The JSP tag files are translated into Java code automatically by the JSP container through the same process th
Other News
Model and design your database with Rational XDE Data Modeler
(David Bridgewater) This tutorial shows you how to use the Data Modeler within the Rational XDE toolset to manage your database design and maintenance. It takes you through all the steps required to create a logical model for your database, and to transform this into a physical diagram and set of sc
Computing Percentiles in SQL Server
(Bob Newstadt) Say you score 570 on the verbal section of the SAT. How well did you do? According to the College Board, 570 falls into the 71st percentile. This means you did better than 71% of the other students who took the test. Percentiles are a useful way to present rankings among a large popul
DB2 Basics: Fun with Dates and Times
(Paul Yip) Just updated with custom date/time formatting! This short article explains how to manipulate dates, times and timestamps using SQL on DB2 Universal Database for Windows, UNIX and Linux platforms.
XML for Web Designers
(Kevin Ruse) No doubt, you have heard about XML. XML is everywhere. For Web designers, that can add to the confusion. If something is everywhere, it’s nowhere. If only you heard “XML is the new HTML,” then maybe you could wrap your mind around it as a markup language. But chances are, you’ve hea
CASTing About For a Solution: Using CAST and Table Functions in PL/SQL
(Jim Czuprynski) Oracle 8i offered the CAST function, which allows a PL/SQL collection to be processed as if it was a normal table. When CAST is paired with table functions, it becomes even more powerful as a data manipulation toolset. This article provides a brief technical explanation of CAST
SQL Server Yukon – Next Generation Information Management System
(Benoyraj Baskaran) Yukon is a proposed new 32 – bit version of Microsoft SQL Server aka, MS SQL 2000, which is not yet released from Microsoft, which may expect to be release in the year 2004. It contains a lot of additional tools which improves a rich scale of performance, reliability and ease of
Non-Extractive Parsing for XML
(Jimmy Zhang) Text processing is one of the most common tasks in application development. Whether it is a Java Servlet or a VOIP application, the conversion from a raw text-based input message to a machine-readable internal representation almost always requires parsing (or tokenization), which, in i
Face Time With Martin Hubel
I have an application that queries and writes to 11 normalized tables. While performance testing, I noticed that when I put all of the tablespaces used by these tables in the same 32K buffer pool, the application ran much faster than when I allocated separate buffer pools. Each table is in its own t
Code Generation in the .NET Framework Using XML Schema
(Daniel Cazzulino) Learn the difference between typed datasets and classes generated by the xsd.exe tool, as well as how to extend this code generation process by reusing the infrastructure classes supporting it, while remaining compatible with the XmlSerializer.