(Alejandro Gervasio) Welcome to the final part of the series “Object Interaction in PHP: Introduction to Aggregation.” Certainly, we’ve had some hard work, but it’s been worth the gain. Implementing aggregation in PHP is one of the most powerful techniques currently available to reveal the strengths
Other News
Simulate variable arguments in PL/SQL
(Scott Stephens) There are different approaches that try to simulate variable arguments. However, since Oracle 8, there is a better method that developers often don’t consider: using a simple VARRAY to wrap the variable portion of code.
An introduction to MySQL permissions
(Ian Gilfillan) MySQL 5 offers a number of new storage engines (previously called table types). In addition to the default MyISAM storage engine, and the InnoDB, BDB, HEAP and MERGE storage engines, there are four new types: CSV, ARCHIVE, FEDERATED and EXAMPLE, as well as a new name for the HEAP sto
SAP explains analytics xApps
(Robert Westervelt) SAP is rolling out more than 200 composite applications that the software maker said will drive embedded analytics into its core applications and place user friendly analytical tools in the hands of end users. (R)
XML Summer School Offers Security Interop Tips
(Vance McCarthy) In the wake of the Microsoft/Sun plan to launch specs to better ensure interop and single sign-on (SSO) for web services security and identity, devs have been scrambling for real code and real details. This July, XML Summer School will provide devs their first hands-on look at desig
In Focus: Microsoft’s XML Move Will Hasten a New Era
(Doug Henschen) I’m old enough to remember the dawn of personal computing and the boon to productivity brought on by desktop applications such as word processing and spreadsheets. It was huge, back in the early ’80s, just to be able to do a simple mail merge. I’m sure Microsoft’s embrace of XML-base
Choosing Between the CLR and T-SQL in SQL Server 2005
(Randy Holloway) Microsoft’s integration of the .NET Framework and the CLR directly into the database engine in SQL Server 2005 is a key enhancement. The result is a major paradigm shift for database application developers and administrators, who can leverage the new functionality in many different
Permissions do not appear in the sysprotects table or in the output of the sp_helprotect stored procedure when you grant the permissions to an object in SQL Server 2000
Under certain circumstances, when you grant permissions to an object in Microsoft SQL Server 2000, the permissions that you granted do not appear in the sysprotects virtual table for that database or in the output that you obtain by running the sp_helprotect stored procedure.
XML Enablement: Providing Government Organizations with Information On-Demand
The unprecedented demands placed on government today, from maintaining Homeland Security to providing more services to citizens, has created a greater sense of urgency and higher degree of accountability at every level of the government. The need to obtain, share, and process dynamic, structured and
Oracle SQL and PL/SQL Development and Maintenance Concepts
Database programming has recently become more of a distinct discipline among other types of programming. Within this distinct discipline, Oracle — the predominant database server — has specific programming considerations, such as a dedicated programming language —PL/SQL, significant control over th