Browse Prior Art Database

Storing and Accessing Large Amounts of Data in Lotus Notes

IP.com Disclosure Number: IPCOM000123962D
Original Publication Date: 1999-Aug-01
Included in the Prior Art Database: 2005-Apr-05
Document File: 1 page(s) / 43K

Publishing Venue

IBM

Related People

Modrak, GP: AUTHOR

Abstract

Disclosed is a system for storing and accessing large amounts of data in Lotus Notes* databases, with greatly reduced processing times and network traffic.

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 80% of the total text.

Storing and Accessing Large Amounts of Data in Lotus Notes

   Disclosed is a system for storing and accessing large
amounts of data in Lotus Notes* databases, with greatly reduced
processing times and network traffic.

   Data stored in Lotus Notes (or Notes) is in the form of
documents and views.  Data stored in a mainframe environment is
stored as records in files or datasets.  Performing a transfer of
data from the mainframe to Notes usually involves a one-to-one
mapping of mainframe records to Notes documents.  This is wasteful
of space, and extremely time-consuming.

   Accounting datasets transferred to Notes daily had transfer
times of 3 to 16 hours, with new and changed records in the range of
100,000.  A way was found to consolidate the data into similar
structures, and reduce the transfer time to 30 minutes, reducing the
changed records to 600 or so (a 1666:1 savings).  The data size was
reduced from 80 Meg to 10 Meg.

   A system of routines on the mainframe accepts the current
day's data, compares it to the old, rearranges it, and sends it to a
Notes server.  There a Notes agent (program) reads the records, and
assigns many multiples of them to one Notes document, based on the
reorganization done on the mainframe.

   Lotus Notes replication processes then transmit the
changes to other Notes servers, where the databases are Full-Text
indexed.  This FT-indexing allows the data to be used as a validation
template for user-supplied accounting data from...