Browse Prior Art Database

Retrieving Unicode Data From Databases Using Brio Query

IP.com Disclosure Number: IPCOM000125967D
Original Publication Date: 2005-Jun-26
Included in the Prior Art Database: 2005-Jun-26
Document File: 2 page(s) / 70K

Publishing Venue

IBM

Abstract

A program is disclosed that a common solution for business intelligence (BI) tools and/or systems that require to work on multiple platforms using data stored in Unicode databases in different languages (ex : Kanji, Mandarin etc). This is a unique solution to use codepages automatically to map languages and retrieve data for reporting purposes.

This text was extracted from a PDF file.
At least one non-text object (such as an image or picture) has been suppressed.
This is the abbreviated version, containing approximately 54% of the total text.

Page 1 of 2

Retrieving Unicode Data From Databases Using Brio Query

Business Intelligence tools can retrieve data from databases and present to users and/or systems. Problem arises when the data stored in UNICODE databases in different languages (ex : Kanji, Mandarin etc).these tools do not return valid characters due to inherent limitations in them. This invention provides a seamless solution that selects the appropriate code page during the data extraction process so the data from the source can be extracted properly. The data retrieved using this idea can be used to generate multilingual reports for the end users or can be utilized by down stream systems for other analysis purposes.

This invention uses DB2 codepages to switch between languages. Just before executing the data extraction query to go against a table that contains language characters other than English the code page is set to that language.

It is assumed that user has needed client (or plug-in) installed on their workstation. During the initialization of the data extraction query the following changes are made to the DB2 Code page

This invention provides a method of retrieving UNICODE data from appropriate data sources, the method comprising of ; obtaining a the relevant code page that dictates the data retrieval. The code page information is then passed along to a universal procedure, that automates the tasks suchas; setting the appropriate connections and parameters both database and BI(Business Intelligence) client specific; required for the data retrieval. The retrieval procedure gets executed, yielding the data required.

For example DB2 set codepage = 943 (for Kanji)

[FIG 1] below outlines the solution detail :

1

Page 2 of 2

Procedure for UN ICODE data access to end-users and applications

Procedure for UN ICODE data access to end-users and applications

Procedure for UN ICODE data access to end-users and applications

Custom Code Procedure

Custom Code Procedure

Custom Code Procedure

Custom Code Procedure

[2]

[2]

[2]

Set LIBPATH

Set DB2INSTANCE

Set LIBPATH

Set DB2INSTANCE

Set LIBPATH

Set DB2INSTANCE

Set LIBPATH Set LIBPATH

Set DB2INSTANCE Set DB2INSTANCE

Initialize G raphics B uffer(O ptional)

Initialize G...