Data processing: generic control systems or specific application – Specific application – apparatus or process – Article handling
Reexamination Certificate
1999-10-27
2001-07-24
Ellis, Christopher P. (Department: 3651)
Data processing: generic control systems or specific application
Specific application, apparatus or process
Article handling
C700S226000
Reexamination Certificate
active
06266575
ABSTRACT:
FIELD OF THE INVENTION
The present invention relates generally to manufacturing environments that wish to relate large amounts of information to a small identifier. More specifically, the present invention relates to a client-server system, method, and computer program for managing database driven insertion (DDI) and mail piece tracking (MPT) data for holding and managing mailroom data in a consistent and easy to use manner.
BACKGROUND OF THE INVENTION
Currently, it is common in mail processing for mail piece data to be handled utilizing a file-based system (i.e. using a flat ASCII file to hold all database driven insertion and mail piece tracking information). A client/server concept involves replacing flat files with a database server which maintains indices and relations between various data fields, as described further hereinbelow. Also as described further hereinbelow, utilizing a client-server concept, as according to the present invention, allows an interface to be developed for client programs to be able to read database driven insertion (DDI) data from the database and write mail piece tracking data back to the database.
Database driven insertion (DDI) is currently being accomplished in conventional mail processing by storing mail processing instructions in a flat ASCII file, reading an account number from paper via a laser scanner, calculating the offset of the data in the file that corresponded to the account number read, and reading the data at that offset point into the mail processing equipment. Mail piece tracking has been accomplished by storing information about a mailpiece back into the database driven insertion (DDI) file, or possibly a separate file whenever the mailpiece processing was complete. This was, and still is, the industry norm because it is believed that a database is not capable of keeping up with the read and write rates required for multiple mail processing machines. In contrast to this norm, the present invention, however, can and does keep up with the read and write rates required for multiple mail processing machines using the aforementioned client/server concept, as described further hereinbelow.
Database driven insertion (DDI) data typically describes to individual mail processing inserters which inserts to feed, how many sheets are in an account, what actions the inserter is to perform on the account, what address should be printed on the envelope, and/or other information as apparent to those of skill in the art.
Mail piece tracking (MPT) data typically describes what actually happened to the account during processing, i.e. what machine processed it, when the machine started processing it, when the machine finished processing it, which operators were running the machine, which inserts fed, and/or other information as apparent to those of skill in the art.
Using a database under a client/server architecture (as opposed to a flat ASCII file) for insertion and tracking has many significant advantages which will be readily appreciated by those of skill in the art. Clients (which can comprise mail inserters, mail sorters, printers, other applications, and/or other suitable clients as recognized by those of skill in the art of mail processing) can request and receive only the information they need which decreases the overall load borne by the communications network. Other clients (report generators) can create reports much easier with well known database reporting tools. The server provides a common repository for all mail piece tracking and database driven insertion data, which, in turn, allows management from one computer and location, i.e. centralized operation. The database server provides excellent file locking and read/write contention protection superior to that of ASCII flat files. The server also provides services to inform clients whether a record was updated “underneath” it. This provides site-wide duplicate checking for all mailpieces to ensure there are no duplicate mailpieces being processed. Additionally, the database server enforces data consistency. The server will not allow clients to write “invalid” data into the database. This is very difficult to enforce in file-based systems. The server further provides “stored procedures” which allow the server to change its functionality without necessarily modifying client code. Other advantages can also exist as recognized by those skilled in the art.
In view of the above, there remains much room for improvement in the art, particularly for a new system and method of “publishing” and “recording” database driven insertion and mail piece tracking data.
DISCLOSURE OF THE INVENTION
In accordance with the present invention, a novel client-server system, method, and computer program for managing database driven insertion (DDI) and mail piece tracking (MPT) data for holding and managing mailroom data in a consistent and easy to use manner is provided. “Managing” of data according to the present invention refers to a system that controls, utilizes, tracks, and reports on all aspects of database driven insertion and mail piece tracking data. By the client/server database architecture for managing database driven insertion and mailpiece tracking in a mail processing environment according this invention, a customer initially sets up a mail processing site by defining within the client/server architecture running database driven insertion and mail piece tracking system parameters such as Users, Privileges, JobSetups, Materials, etc., before any actual mail processing occurs. Next, the customer generates data (generally in a mainframe environment) that is intended to be printed and mailed. The data is run through a utility like Bell & Howell's Transformer™ or their own custom software to create a “side file” that contains the database driven insertion information required by a mail processing insertion device. Each print run has a matching side file generated for it. Material is printed and the side file is loaded/inducted into the database driven insertion and mail piece tracking system. The customer physically conveys the printed material to the inserter, loads the mail processing job currently programmed, places the materials called for by the mail processing job (e.g., inserts, printed materials, envelopes, etc . . . ) into the correct locations, and begins running the mail processing job. As a mail processing inserter reads each reader code or key that has been strategically placed on the mailpiece materials, the inserter makes a request for the database driven insertion data associated with that particular key from the database. The database sends the insertion data back to the inserter, which uses the data to determine what actions to perform on this particular account. As each mailpiece leaves the inserter, mail piece tracking data is written into the database associated with each database driven insertion record that records, for instance, the Machine, Operators, Time, Date, JobSetup, Inserts Fed, etc., for each mailpiece.
It is therefore an object of the present invention to provide a novel client-server system, method, and computer program for managing database driven insertion (DDI) and mail piece tracking (MPT) data for holding and managing mailroom data in a consistent and easy to use manner.
It is another object of the present invention to store all types of data in the database driven insertion server that are related to the other types of data in a way that makes generating very flexible and detailed reports very easy.
It is a further object of the present invention to be able to modify instructions regarding the processing of each mailpiece right up until the time the mailpiece is placed on a machine for processing.
It is a still further object of the present invention to generate a standard postal manifest that details all pieces processed and the amount owed the post office.
It is a still further object of the present invention to re-produce a list of mailpieces processed properly and mailpieces that did not process properly.
Some of the objects of the invention having b
Anderson, Jr. Ralph R.
Mackelprang Mark G.
Bell & Howell Mail and Messaging Technologies Company
Ellis Christopher P.
Jenkins & Wilson, P.A.
Tran Khoi M.
LandOfFree
Client-server system, method and computer product for... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Client-server system, method and computer product for..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Client-server system, method and computer product for... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2524215