The process of making databases available to users via a browser has thus far been complex, time consuming, and therefore expensive. These projects have typically taken a lot of time because of the lengthy learning curve and the time-intensive nature of coding. (R,doc)

(W. Jason Gilmore) Within the past two years, Oracle, IBM and Microsoft have all released freely available versions of their flagship database servers, a move that would have been unheard of just a few years ago. While their respective representatives would argue the move was made in order to better

(Lenz Grimmer) Linden Lab is the company behind the virtual world simulation Second Life (SL) in which users (the residents) can freely roam around and actively participate in the creation and development of the virtual world and their own appearance (their avatars). To facilitate this, Second Life

(Eric Lai) Ingres was spun out of CA late last year to develop and sell the durable database technology that was released to the open-source community a year earlier. Dave Dargo, Ingres’ chief technology officer, talked about the status of the new company and its place in the database community last

(Kaj Arnö) During one of the coldest days in early February, I invited the new MySQL AB CTO, Taneli Otala, for dinner to my home in Grankulla, Finland. Taneli was spending over a week with Michael ‘Monty’ Widenius, our company founder, main architect and CTO since many years.

Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored functions. Some of restrictions apply only to stored functions, and not to stored procedures.

(Andrew Oppel) From Chapter 1, you should recall that a view is a stored database query that provides a database user with a customized subset of the data from one or more tables in the database. Note that Microsoft Access uses the term query instead of view. The inherent beauty of views is that, on

(Robin Schumacher) A few years ago, I wrote an article entitled “The Foundation of Excellent Performance” (still available at http://www.tdan.com/i016fe03.htm) where I argued against the notion that SQL code was the number one contributor to performance in a database-driven system. Instead, I stated

(Joris Evers) The so-called LAMP stack of open-source software has a lower bug density–the number of bugs per thousand lines of code–than a baseline of 32 open-source projects analyzed, Coverity, a maker of code analysis tools, announced.

Referential integrity is an important concept in database design. The term refers to a state when all the references in a database are valid and no invalid links exist between the various tables that make up the system. When referential integrity exists, any attempt to link to a record which does no