(Alejandro Gervasio) Design Patterns are, in my humble opinion, a very large and complex topic within the universe of software engineering, and certainly when applied particularly to PHP programming, they’re not the exception to the rule. If you’re making your first leaps into the theory and practic
Author: SSWUG Research
What is Metadata?
Metadata is any information that describes the data managed by an organization and the processes that affect that data. In other words metadata is organized documentation. (pdf)
Partitioning in DB2 Using the UNION ALL View
(Calisto Zuzarte, Robert Neugebauer, Natt Sutyanyong, Xiaoyan Qian and Rick Berger) In today’s relational databases, it is not uncommon to hear of terabyte-size databases. As it becomes necessary to store ever increasing volumes of data in a single table within the database, more people need to know
What’s new in System.Xml 2.0 – Introduction, XML readers & writers
(Alex Homer) While there have been many improvements and new features added to ADO.NET, the changes going on in the XML-related classes in version 2.0 have been even more dramatic. Through the XML InfoSet model defined by the World Wide Web Consortium (W3C), XML is evolving to become a universal dat
Tip: Use the Unicode database to find characters for XML documents
(Uche Ogbuji) The Unicode consortium is dedicated to maintaining a character set that allows computers to deal with the vast array of human writing systems. When you think of computers that manage such a large and complex data set, you think databases, and this is precisely what the consortium provi
XmlGridControl Editing XML Data in the PropertyGrid
(Michael Coyle) I’ve been using the XSD.exe for quite a while to generate classes from XML Schema Definition (XSD) files. These classes are uniquely suited for serializing/deserializing XML data into an object model that a programmer can use to manipulate data. When paired with a middleware prod
Oracle Can’t Stifle Open-Source Databases
(Charles Garry) Opinion: The open-source database community is too resilient and diffuse for even Oracle to subvert, despite the sinister conspiracy theories swirling around the recent buyouts of Innobase and Sleepycat Software.
Improving Database Performance with Partitioning
(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
Oracle Database 10g’s Automatic Storage Management Delivers Resilience, Simplicity and Lowers Costs
Oracle Database 10g’s Automatic Storage Management (ASM) delivers previously unattainable levels of storage management efficiency through highly automated, application-centric rules and policies that reduce many hands-on tasks to the point of elimination. Oracle customers shared their experiences wi
FIX: Error message 17883 may be logged in the error log when you try to manually update table statistics in SQL Server 2000
When you try to manually update table statistics in Microsoft SQL Server 2000, the following message may be logged in the SQL Server error log: DateTime server Error: 17883, Severity: 1, State: 0 DateTime server Process 905:0 (19c4) UMS Context 0x0000000053E318F0 appears to be non-yielding on