(Andi Gutmans) PHP 5 (PHP: Hypertext Preprocessor Version 5) was officially released on July 13, 2004. Not surprising, the release was widely covered by the media due to the leadership role PHP plays in the Web application market. It is true that technologies such as .NET and J2EE have had more

(Scott Stephens) The UNIX command file attempts to identify a file type based on bytes in a file rather than on the file extension. For example, every GIF file starts with the letters GIF, and every JPEG file begins with the value 0xffd8 in big-endian order. (R)

(Rahul Srivastava) The W3C XML Schema Datatype Specification defines numerous datatypes for validating the element content and the attribute value. These datatypes can be used to validate only the scalar content of elements, and not the non-scalar or mixed content. The text enclosed between the

(Jeff Hunter) In Oracle, releases before Oracle9i, the Cost Based Optimizer (CBO) would only use a composite index (sometimes referred to as a concatenated index) if you referenced the index prefix column in the WHERE clause of the SQL statement. If the SQL statement omitted the index prefix column

IDC believes that organizations wishing to move in an evolutionary way to Grid/Utility Computing architectures would be well advised to consider Oracle’s Oracle 10g family of products. Applications currently written for Oracle’s application server or data management software will be able to take

(Steve Callan) At the end of Part One, we were at the point where MySQL was ready to be installed. In part two of this series, we will go through some quick setup steps, create a user with some privileges, and load data – using several methods – into a MySQL database. Once the setup of the MySQL dat

(Brad Cowdrey) Part 6 of this series takes an in depth look at analytical windowing and aggregation comparison through examples including syntax and behavior. In addition, this article will build on the information and examples from the previous articles in the series. All of the examples run off of

(Kimberly Floss) A big challenge DBAs face is aligning database resources with the real-world demands of daily business and realigning those resources as demands change—especially in terms of meeting SLAs (service-level agreements) with internal and external customers. Oracle Database Resource M

(Roy Mark) Oracle will drop its efforts to block PeopleSoft’s defense to Oracle’s hostile takeover bid if PeopleSoft’s shareholders fail to tender a majority of their shares by Nov. 19, according to an Oracle letter sent to a Delaware court. The development could lead to Oracle abandoning its ho

JDBC (Java Database Connectivity) is a standard Java interface for connecting from Java to relational databases. The JDBC standard was defined by Sun Microsystems, allowing independent providers to implement and extend the standard with their own. In addition to supporting the standard JDBC API,