DB2 includes two distinct storage mechanisms: one for efficiently managing traditional SQL data types, and another for managing XML data. The underlying storage mechanism is transparent to users and applications; they simply use SQL (including SQL with XML extensions or SQL/XML) or XQuery to work with the data.
XML data is stored in columns of DB2 tables that have the XML data type. XML data is stored in a parsed format that reflects the hierarchical nature of the original XML data. As such, pureXML uses trees and nodes as its model for storing and processing XML data. If you instruct DB2 to validate XML data against an XML schema prior to storage, DB2 annotates all nodes in the XML hierarchy with information about the schema types; otherwise, it will annotate the nodes with default type information. Upon storage, DB2 preserves the internal structure of XML data, converting its tag names and other information into integer values. Doing so helps conserve disk space and also improves the performance of queries that use navigational expressions. However, users aren't aware of this internal representation. Finally, DB2 automatically splits XML nodes across multiple database pages, as needed.
XML schemas specify which XML elements are valid, in what order these elements should appear in XML data, which XML data types are associated with each element, and so on. pureXML allows you to validate the cells in a column of XML data against no schema, one schema, or multiple schemas. pureXML also provides tools to support evolving XML schemas.
IBM has enhanced its programming language interfaces to support access to its XML data. These enhancements span Java (JDBC), C (embedded SQL and call-level interface), COBOL (embedded SQL), PHP, and Microsoft's .NET Framework (through the DB2.NET provider).
Read more about this topic: Pure XML
Other articles related to "technical information, information":
... The maximum speed of an EF-1 as built was 35 miles per hour (56 km/h) ... Higher speeds led to excessive strain on the traction motor armatures ...
... The current members of CENDI are Defense Technical Information Center (United States Department of Defense) Office of Research and Development and Office of Environmental Information (United States ...
... The turquoise/cream colour became a new standard for the 218, whilst the 217 ... in the burgundy and beige remained a loner, for almost thirty years, until 001 ... (ex 217 001) became the second locomotive from the V160 family to receive this colour scheme ... By the late 2000s the turquoise/cream colour had virtually, the last representative being DB AutoZug 218 320. ...
... Colour Blind was edited at PabloPost at Pinewood Studios ... Editor, Ralston Humble, developed an entirely new way to produce the special effect of Dan's changing skin colour by using Rotoscoping and Color grading and layering them on to the original film to get the final result ...
Famous quotes containing the words information and/or technical:
“I believe it has been said that one copy of The Times contains more useful information than the whole of the historical works of Thucydides.”
—Richard Cobden (18041865)
“The axioms of physics translate the laws of ethics. Thus, the whole is greater than its part; reaction is equal to action; the smallest weight may be made to lift the greatest, the difference of weight being compensated by time; and many the like propositions, which have an ethical as well as physical sense. These propositions have a much more extensive and universal sense when applied to human life, than when confined to technical use.”
—Ralph Waldo Emerson (18031882)