(Ed Tittel) As I write this tip, I’m nearing the midpoint of a two-week stint at the TechTarget Expert Answer Center, where I’m blogging daily and answering member questions about—you guessed it—XML topics, tools, and technologies. This tip is an expanded version of a blog I wrote on February 15, 20
Other News
XML Schema 1.1 Part 2: Datatypes
XML Schema: Datatypes is part 2 of the specification of the XML Schema language. It defines facilities for defining datatypes to be used in XML Schemas as well as other XML specifications. The datatype language, which is itself represented in XML, provides a superset of the capabilities found in XML
Get off to a fast start with DB2 Viper
(C. M. Saracco) You’ve probably heard the buzz about DB2’s new Viper release — IBM’s first database management system to support both tabular (SQL-based) and hierarchical (XML-based) data structures. If you’re curious about DB2’s new “native” support for XML and want to get off to a fast start, you
How To Receive Data from a Single Table, continued
(Bryan Sylverson) Figure 3-7 introduces you to functions and illustrates how you use them in column specifications. A function performs an operation and returns a value. For now, don’t worry about the details of how the functions shown here work. You’ll learn more about all of these functions in cha
Stored Procedures, UDFs and Triggers—Common Logic or Common Problem?
DB2 Stored Procedures, user-defined functions, and triggers are becoming more prevalent on the mainframe, and can be part of a valuable implementation strategy. Use of these advanced database objects dramatically extends the capabilities of the database, and can be a performance benefit—or a perform
Seattle Movie Finder: An AJAX- and REST-Powered Virtual Earth Mashup
(Dare Obasanjo) I am a big fan of movies, especially summer blockbusters. Last summer I saw Fantastic Four, War of the Worlds, Batman Begins and Mr. and Mrs. Smith. Every Friday I visit sites like MSN Movies and IMDB to learn what new movies are available in my neighborhood and in what theaters they
Having Fun with Code Snippets
(Deborah Kurata) There are some pieces of code that you write over and over again. Some of these pieces make sense as standard components or standard methods, such as logging or validation. Other pieces are more unique and cannot easily be made into standard methods, like Property procedures, For lo
SQL Performance: Get The Right Index
(george.p.alexander) The power of getting the right index for your query is absolutely amazing. I was doing some checking on this test environment that was set up and had this Stored Procedure that takes around 4 minutes and 35 seconds. Our UAT guys wanted the thing to perform in a jiffy. Performanc
Advanced Query Writing
(Andrew Oppel) SQL functions were introduced in Chapter 4. The topics that follow describe functions that were not covered in Chapter 4 but which you will find useful. In addition to character and mathematical functions, selected date and time functions are also included. Remember that all SQL
Oracle Challenges Google With New Enterprise Search Engine
(Charles Babcock) Oracle followed Google into the enterprise search arena, offering a search engine that it says can ferret out information buried in E-mail, corporate documents, and even mainframe applications.