eWEEK content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More.
110 Things You Should Know About Databases
210 Things You Should Know About Databases – Enhancements to XML File Management
Oracle Database 11g added among other things the ability to store XML data as a binary data type and extended greater support for XQuery, a proposed standard that allows users to extract information from an XML file. IBM also updated its XML technology in DB2 9.5, adding a standardized extension to XQuery that allows the user to modify, insert or delete individual elements and attributes within an XML document.
310 Things You Should Know About Databases – Compression Technology
Not new, but improved. 11g included OLTP (online transaction processing) table compression, as well as the ability to compress the unstructured or file data stored within the database. IBM has put an emphasis on compression capabilities in its DB2 product as well, and Microsoft’s SQL Server 2008 is expected to bring several compression features, such as backup compression, to its customers. Netezza, which specializes in analytic appliances, announced that it will add what it calls its “Compress Engine” to its data warehousing appliance this year.
410 Things You Should Know About Databases – Database Clusters on Virtual Environments
510 Things You Should Know About Databases – Moving Functionality Closer to the Storage Device
610 Things You Should Know About Databases – Automation for Managing Virtualized Databases
710 Things You Should Know About Databases – Column DBMS Models Catching On
810 Things You Should Know About Databases – Its MPP, Not MP3
910 Things You Should Know About Databases – Databases in the Cloud
1010 Things You Should Know About Databases – Spatial Data
1110 Things You Should Know About Databases – Database Migration Technology
ANTs Software has been working on technology it calls the Compatibility Server, which allows applications to connect to the new target database through the server without having to be recompiled or rewritten.