| Title | Date Added | Company | |
|---|---|---|---|
![]() |
pureXML in DB2 9: Which Way to Query Your XML Data? | 2007-08-28 | IBM |
| DB2 9 introduces pureXML support, which means that XML data is stored and queried in its inherent hierarchical format. To query XML data, DB2 offers two languages, SQL/XML and XQuery. One can use XQuery and SQL separately, but one can also use XQuery embedded in SQL and vice versa. This gives the user a lot of flexibility and options for querying the XML data. Each of these options is useful under certain circumstances. This paper describes these options, their respective advantages and disadvantages, and guidelines for choosing the right one for one's needs. This paper has been updated for DB2 9.5.
Tags: Programming Languages, Database Management |
|||
![]() |
Bank Improves Risk Analysis and Efficiency With an Intelligent Single View of Customer | 0000-00-00 | Microsoft |
| Sasfin Bank is a South African bank providing financial services for entrepreneurs. It wanted to create a single view of the customer that would help provide information required for risk analysis, compliance with Basel II regulation, and for making insightful business decisions. To do this, Sasfin took on a top challenge in the banking industry: connecting disparate systems across the bank. To better manage customer information and proactively comply with regulation, Sasfin implemented an enterprise customer management content and business intelligence solution based on the 2007 Microsoft Office system, including XML integration capabilities and file format.
Tags: CRM Software, Business Intelligence - Data Warehousing, |
|||
![]() |
Global Contractor Increases Engineer Productivity by Improving Document Control | 0000-00-00 | Microsoft |
| TGE Gas Engineering (TGE) is an independent engineering, procurement, and construction contractor specifically engaged in the design and construction of natural gas plants. The technical documentation developed by engineers must comply with contract terms and conditions. However, sometimes documents do not follow the Document Control Department rules and procedures, which results in additional time and costs for TGE to rework the documents, impacting customer satisfaction. TGE was looking for tools to improve the quality of technical documentation and accelerate the document control process. TGE chose the 2007 Microsoft Office system, including the new Office XML format, and expects to reduce the number of rejected documents, decrease the document creation and approval cycle time, improve compliance, and decrease project and administration costs.
Tags: Document Management, Word Processing |
|||
![]() |
Program With XML for DB2, Part 2: Leverage Database Support for XML in Your Application Architecture | 2007-08-02 | IBM |
| XML's status in databases has changed in the last couple of years from a temporary worker to that of a first class citizen. No longer does it need to morph its identity in order to fit into the relational world. It proudly maintains its hierarchical heritage, even while exploiting the power and stability of the relational database world. In fact, some of its relational neighbors have adapted techniques that make them look like XML in order to exploit the richness of the hierarchical XML model. This paper showcases how the new XML storage and query environment plays into the XML data model. It shows how once the user adapt to the new XML-based application development architecture, the database schemas become much simpler and more natural.
Tags: Programming Languages, Database Management |
|||
![]() |
Mashing Google Maps With Oracle Database | 2007-08-01 | Oracle |
| As one may know, Oracle has had the ability to generate XML on the fly from the database for a number of years. In addition to generating XML from an Oracle database, it is relatively trivial to publish the generated data XML on the Web using a variety of languages such as with Java Servlets and JDBC. What one possibly haven't seen yet is how easy it is to take dynamically generated XML data from an Oracle database and mash it together with Web page using the Google Maps API. For example, if one has an Oracle database filled with interesting geo-related data, one can very easily integrate this data with Google's JavaScript Maps API.
Tags: Database Management, Web Services |
|||
![]() |
Ziemann+Bauer Brings Speed, Accuracy, and Multilingual Capability to Its Document Creation | 0000-00-00 | Oracle |
| Ziemann+Bauer GmbH is a subsidiary of the international Ziemann Group and the world's major production site for brewing vessels and brewery tanks. Ziemann+Bauer wanted to speed and customize generation of business documentation in the different departments. The challenge was to consolidate data from the various divisions of the company to reduce costs, paper, and resources and enable publication of multilingual documentation throughout the group via intranet and e-mail. The company implemented Oracle BI Publisher, achieving innovative and simple reporting methodologies for all kinds of documents. They consolidated complex data structures for fast, transparent access to various data sources, including Web services, databases, and XML data.
Tags: Business Intelligence - Data Warehousing |
|||
![]() |
Programming With XML for DB2, Part 1: Understand the XML Data Model | 2007-07-19 | IBM |
| A primary goal of XML is to make the application development process simple, cheap, portable, and of high quality. XML programming is bringing about the same kind of radical shift in the application development paradigm in this decade as object methodologies did in the last decade. In the first of a series on programming with XML for IBM DB2 for Linux UNIX, and Windows, one will learn the basics of the XML data model and the advantages it brings to the programming environment over a pure object model.
Tags: Programming Languages, Application Development |
|||
![]() |
XML in a Non-Unicode Database: Handle Code Page Conversion in XML Data in DB2 for Linux, UNIX, and Windows | 2007-07-19 | IBM |
| This paper explains how to use the XML native data type in a non-Unicode database in DB2 Viper 2. The paper provide tips on how to avoid substitution characters, pointers for query structuring and character reference usage, and explanations of the new utility User-Defined Functions (UDFs) shipping with the product. In DB2 9, the only way to include XML data in a database was to have a UTF-8 code set for the database. This restriction was true even if the XML data included only ASCII code points. XML is stored in the database in a binary format, and the text nodes are stored as UTF-8 code points.
Tags: Programming Languages, Database Management |
|||
![]() |
TechNet Webcast Express: Working With Office Open XML File Format: Microsoft Office Excel (Level 100) | 2007-06-19 | Microsoft |
| The attendee of this webcast will learn more about the benefits of open XML format. This includes creating an Excel spreadsheet and using the Excel XML container.
Tags: Web Services, Spreadsheets |
|||
![]() |
TechNet Webcast Express: Working With Office Open XML File Format: Microsoft Office Word (Level 100) | 2007-06-19 | Microsoft |
| The attendee of this webcast will learn more about the benefits of open XML format. This includes creating a new file in Word and using the Word XML container.
Tags: Web Services, Word Processing |