Browse Prior Art Database

Configurable Data Querying via Sametime Connect Instant Messaging and Lotus Notes

IP.com Disclosure Number: IPCOM000012991D
Original Publication Date: 2003-Jun-12
Included in the Prior Art Database: 2003-Jun-12

Publishing Venue

IBM

Abstract

The following research disclosure is based on the generic implementation of a query 'Bot' (robot), an automated process that is used to perform the task of querying data sources within a the Lotus Sametime Instant Messaging (IM) environment.

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 27% of the total text.

Page 1 of 13

Configurable Data Querying via Sametime Connect Instant Messaging and Lotus Notes

1. Technology Summary The following is a summary of technologies used in the functioning of the Bot: Technology Platform Type Usage Lotus Sametime Services Instant Messaging

Provides the 'place' for users to Serverconnect. The Bot connects to this place as a user.

Java 'Bot' Custom

                    Connects to the Lotus Sametime ApplicationServices. Processes messages from users as requests for data. Interacts with the Query Repository. This technology piece has been built specifically for the data querying function
Lotus Notes/Domino Server The Lotus Notes/Domino Server provides a location to host Lotus Notes databases. This is in the same physical location as the Bot

Query Repository Custom

A Lotus Notes application that Applicationresides on the Lotus/Domino Server.

                               Stores queries that can be used multiple times by the Bot. This technology piece has been built specifically for the data querying function
Lotus Notes Databases Application Lotus Notes Databases can be used as sources of data for querying. Queries can be created in the Query Repository that will be run against a Lotus Notes data source

Relational Databases Application /

Relational Databases can be used as Serversources of data for querying. Queries can be created in the Query Repository that will be run against a relational data source

The following sections contain descriptions of the custom built items

1a) Query Repository The Query Repository is a Lotus Notes databases that stores queries for use by the Query Bot. These queries are indexed by the name of a command.

Having a repository of this nature provides for the following: * Removal of hardcoded query logic from the application * The ability to configure queries within a user friendly interface * Having a storage mechanism where other pieces of data that are pertinent to the Bot application can be stored

The Query Repository supports the following query types:

Lotus Notes queries to gather fielded data from a single document by using a key to

search the first sorted column of a Lotus Notes Database view. Lotus Notes queries to gather fielded data from one or more documents using the

'Search' feature in conjunction with one or more parameters. Lotus Notes queries to gather fielded data from one or more documents using the


1.


2.


3.

1

Page 2 of 13


4.

table using an SQL Select statement.

Each query in the Query Repository is indexed by a command name. This equates to a command that an IM user can input in their message to the Bot.

Each command is contained within a separate lotus notes document within the Query Repository, and these can be created and viewed using Views within the Query Repository

The following is a list of configurable fields in a command: Field Type Options Mandat Descriptionory

Comm
Editableand Y The name of the command to be used. This is an index value used for looking up a command


Param
Editableeters Y Number of Parameters to us...