Patents by Inventor Tom Serio

Tom Serio has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).

  • Historical data warehousing system
    Patent number: 7664741
    Abstract: A method comprises obtaining data from a source system. Further, the obtained data is pre-processed by a stepwise operation to generate pre-processed data. The last operated upon data is recorded. In addition, the pre-processed data is transformed into subject-oriented data by utilizing reusable primary keys and Relational Database Management System dates in the source system to link related pre-processed data. Additionally, the subject-oriented data is stored in a data warehouse. The Relational Database Management System dates are utilized for distinctly characterizing the subject-oriented data when a plurality of tables containing data with duplicate primary keys are combined in the data warehouse.
    Type: Grant
    Filed: October 11, 2006
    Date of Patent: February 16, 2010
    Assignee: Amdocs Software Systems Limited
    Inventors: Ruth Lecheler-Moore, Tom Serio, Kirven Dunham, Larry T. Riggs
  • HISTORICAL DATA WAREHOUSING SYSTEM
    Publication number: 20070136330
    Abstract: A method comprises obtaining data from a source system. Further, the obtained data is pre-processed by a stepwise operation to generate pre-processed data. The last operated upon data is recorded. In addition, the pre-processed data is transformed into subject-oriented data by utilizing reusable primary keys and Relational Database Management System dates in the source system to link related pre-processed data. Additionally, the subject-oriented data is stored in a data warehouse. The Relational Database Management System dates are utilized for distinctly characterizing the subject-oriented data when a plurality of tables containing data with duplicate primary keys are combined in the data warehouse.
    Type: Application
    Filed: October 11, 2006
    Publication date: June 14, 2007
    Inventors: Ruth Lecheler-Moore, Tom Serio, Kirven Dunham, Larry Riggs
  • Historical data warehousing system
    Patent number: 7143099
    Abstract: Utilizing change data capture methodology, a computer facilitated historical data warehousing system accepts transactional/operational data having no directly tied dates from a legacy source system and processes that data into a subject-oriented format that is optimized for analytical and query reports via a two step process comprised of pre-processing and transforming. The pre-processing step entails a serial modification of data with only the last modification being recorded. The transforming step involves linking related data by utilizing reusable primary keys and dates obtained from an RDBMS in an operation system of the legacy source system that supplied the transactional/operational data.
    Type: Grant
    Filed: February 8, 2001
    Date of Patent: November 28, 2006
    Assignee: Amdocs Software Systems Limited
    Inventors: Ruth Lecheler-Moore, Tom Serio, Kirven Dunham, Larry T. Riggs
  • Historical data warehousing system
    Publication number: 20030014335
    Abstract: Utilizing change data capture methodology, a computer facilitated historical data warehousing system accepts transactional/operational data having no directly tied dates from a legacy source system and processes that data into a subject-oriented format that is optimized for analytical and query reports via a two step process comprised of pre-processing and transforming. The pre-processing step entails a serial modification of data with only the last modification being recorded. The transforming step involves linking related data by utilizing reusable primary keys and dates obtained from an RDBMS in an operation system of the legacy source system that supplied the transactional/operational data.
    Type: Application
    Filed: February 8, 2001
    Publication date: January 16, 2003
    Applicant: Output Technology Solutions, Inc.
    Inventors: Ruth Lecheler-Moore, Tom Serio, Kirven Dunham, Larry T. Riggs