Data source independent interface for an electronic bill presentment and payment system

• US 7,937,323 B2
• Filed: 09/30/2002
• Issued: 05/03/2011
• Est. Priority Date: 05/22/2002
• Status: Expired due to Fees

• Current Assignee: Pitney Bowes Incorporated (Böwe Systec AG)
• Original Assignee: Pitney Bowes Incorporated (Böwe Systec AG)
• Inventors: Wagner, Richard M., Clarke, William D.
• Primary Examiner(s): Patel; Jagdish N
• Assistant Examiner(s): Poe; Kevin
• Application Number:
  US10/260,593
• Publication Number:
  US 20030220873A1
• Time in Patent Office: 3,137 Days
• Field of Search: 705 37- 40, 705/34
• US Class Current: 705/40
• CPC Class Codes: G06Q 20/00 Payment architectures, schemes or protocols apparatus for performing or posting payment transactions G07F7/08, G07F19/00; electronic cash registers G07G1/12
• CPC Class Codes: G06Q 20/102 Bill distribution or payments
• CPC Class Codes: G06Q 20/14 specially adapted for billing systems
• CPC Class Codes: G06Q 30/04 Billing or invoicing

Abstract

An electronic bill presentment and payment system including an extensible, customizable, data source independent data layer for accessing a business data repository for processing billing information. The business data repositories use one or more data source formats. A business logic module generating business data requests for data from the business data repository in order to carry out processing of billing information. The business data requests are independent of the one or more data source formats of the business data repository. A data layer descriptor repository stores customizable data source descriptions for generating the data layer. The data layer is generated from the customizable descriptors in the data layer descriptor repository. The data layer module receives the data source independent business data requests and based on the request, the data layer implements a data source specific method for fulfilling the request by accessing data in the business data repository. The data layer module further returns a result back to the business logic module in data source independent format. The data layer descriptor repository preferably includes top-level listings of data sources in the system. The data layer descriptor repository further includes customized data source specifications for the each of the data sources listed in the customized set of data sources.

Claims

1. An electronic bill presentment computer system for processing business data to determine customer billing information and for providing the customer billing information to a remote customer over a network, the electronic bill presentment computer system comprising:

one or more memory devices comprising a business data repository, the business data repository storing business data using a plurality of data source formats,

one or more memory devices comprising a data layer descriptor repository including customizable data source descriptions for generating a data layer module on one or more computers in the system;

one or more computers comprising a business logic module for processing customer billing information, the business logic module generating business data requests for data from the business data repository, the business data requests being independent of the plurality of data source formats of the business data repository;

the data layer module, generated based on the data layer descriptor repository, interfacing between the business logic module and the business data repository, the data layer module receiving the data source independent business data requests and implementing a data source specific method for fulfilling the business data requests with data from the business data repository, the data layer module returning a result back to the business logic module in data source independent format;

wherein the data layer descriptor repository includes a top-level listing of a plurality of data sources comprising a customized set of data sources for a particular biller;

wherein the data layer descriptor repository includes customized data source specifications for each of the plurality of data sources listed in the customized set of data sources; and

wherein the data layer module includes a data source independent mapper for receiving data requests from the business logic module, the mapper selecting a data source specific implementation within the data layer, the data source specific implementation acting upon the data in the business data repository.

2. The system of claim 1 wherein the customized data source descriptions in the data layer descriptor repository are in XML format.

3. The system of claim 2 wherein the data layer module is comprised of Java code and SQL scripts for accessing the one or more data source formats.

4. A method for accessing business data in an electronic bill presentment computer system processing business data to determine customer billing information and for providing the customer billing information to a remote customer over a network, method comprising:

storing business data using a plurality of data source formats in a business data repository comprising one or more memory devices,

storing customizable data source descriptions in a data layer descriptor repository comprising one or more memory devices;

on one or more electronic bill presentment computers, processing customer billing information based on business data retrieved from the business data repository;

on one or more electronic bill presentment computers, generating business data requests for data from the business data repository, the business data requests being independent of the plurality of data source formats of the business data repository;

interfacing between a business logic module, on one or more electronic bill presentment computers, and the business data repository, the step of interfacing including receiving the data source independent business data requests and implementing a data source specific method for fulfilling the business data requests with data from the business data repository, the step of interfacing based on the customizable data source descriptions from the data layer descriptor repository;

returning a result back in data source independent format for use in the step of processing;

wherein the step of storing customizable data source descriptions includes storing a top-level listing of a plurality of data sources comprising a customized set of data sources for a particular biller;

wherein the step of storing customizable data source descriptions includes storing customized data source specifications for each of the plurality of data sources listed in the customized set of data sources; and

wherein the step of interfacing includes selecting a particular class of instructions based on a type of the plurality of data source formats in the business data repository.

5. The method of claim 4 wherein the step of storing customized data source descriptions in the data layer descriptor repository includes storing the descriptions in XML format.

6. The method of claim 5 wherein the step of interfacing is carried out by interfacing instructions comprised of Java code and SQL scripts for accessing the one or more data source formats.