(John David Duncan) The MySQL database server features a distinctive modular architecture. The core “upper level” features of the server, such as the network layer, SQL parser, and query optimizer, are separated from the underlying data storage by a well-defined interface. Most MySQL databases s
Other News
Working XML: UML, XMI, and code generation, Part 1
(Benoît Marchal) This article is the first in a new series for the Working XML column that will explore the use of UML modeling tools, such as IBM Rational Rose and XSLT, to design XML applications. In this introductory article, I will discuss the basics of data modeling and introduce the techniques
Regular Expression Sample Application – User Search
Regular expressions specify patterns to search for in string data using standardized syntax conventions. A regular expression can specify complex patterns of character sequences. For example, the following regular expression: a(b|c)d searches for the pattern: ‘a’, followed by either ‘b’ or ‘c’
Adding a column default after table was created
(Craig Mullins) How can I add a default to a column after I have created the table? For example: create table myemp( eno int not null constraint pk_eno primary key, ename varchar(20), ecity varchar(10)) (R)
DB2 Tools Courses
DB2 Tools Courses Now available for a limited time at no cost: Convenient, comprehensive computer based training (CBT) courses for DB2 Tools. Train at your own pace, at any time or place. These engaging courses use the latest multimedia and instructional design to provide cutting edge learning.
Endeca Selected As Exclusive Provider of Guided Navigation For New IBM DB2 Search Software
Endeca, the leading provider of advanced search and Guided Navigation solutions, announced today a new exclusive partnership with IBM to bring the next-generation capabilities of Endeca’s Guided Navigation to IBM DB2 Information Integrator customers. According to the terms of the deal, IBM will
Introduction to MSSQL Server 2000 Analysis Services: Semi-Additive Measures and Periodic Balances
(William Pearson) Most of the measures with which we work in our daily Analysis Services environments are additive, and include various options for easy aggregation, comprised of the ever-familiar SUM, MAX, MIN and COUNT. Most base measures involving transactions, such as sales or direct expenses, a
Creating class diagrams with UML
(Kirk Knoernschild) In the first part of this series we looked at the basics of UML, it’s history and how to pick a UML tool. This time around we are going to explore how to use the Unified Modeling Language (UML) when developing Java applications. While we are using some basic Java for this exa
Identify and Count Characters
(Aui de la Vega) This function provides the number of times a pattern occurs in a string (VARCHAR2).
Oracle CSO: Security must be baked into coding culture
(Bill Brenner) Though Oracle CSO Mary Ann Davidson has lead a push for more secure software, her company has seen its share of criticism this year over how long it takes to acknowledge vulnerabilities and issue patches. (R)