System and method for integrating and accessing multiple data sources within a data warehouse architecture

A method for maintaining a data warehouse, comprising:

• identifying a data source of interest;
• updating a metadata to reflect information available from said source, wherein said metadata comprises domain specific knowledge obtained by analyzing said data source, and wherein said metadata represents at least one abstract concept, at least one database description, at least one transformation and at least one mapping;
• automatically generating a mediator based on said metadata, wherein said mediator comprises data management code, wherein said code defines a translation library and a mediator class;
• and
• writing a wrapper for said source which calls said mediator, wherein said method is applied to data warehousing applications in the domain of protein sequence and structure analysis.

A computer-useable medium embodying computer program code for maintaining a data warehouse by executing the steps of:

• identifying a data source of interest;
• updating a metadata to reflect information available from said source, wherein said metadata comprises domain specific knowledge obtained by analyzing said data source, and wherein said metadata represents at least one abstract concept, at least one database description, at least one transformation and at least one mapping;
• automatically generating a mediator based on said metadata, wherein said mediator comprises data management code, wherein said code defines a translation library and a mediator class;
• and
• writing a wrapper for said source which calls said mediator, wherein said method is applied to data warehousing applications in the domain of functional genomics and proteomics.

A computer-useable medium embodying computer program code for maintaining a data warehouse by executing the steps of:

• identifying a data source of interest;
• updating a metadata to reflect information available from said source, wherein said metadata comprises domain specific knowledge obtained by analyzing said data source, and wherein said metadata represents at least one abstract concept, at least one database description, at least one transformation and at least one mapping;
• automatically generating a mediator based on said metadata, wherein said mediator comprises data management code, wherein said code defines a translation library and a mediator class;
• and
• writing a wrapper for said source which calls said mediator, wherein said method is applied to data warehousing applications in the domain of protein sequence and structure analysis.

A method for maintaining a data warehouse, comprising:

• identifying a data source of interest;
• updating a metadata to reflect information available from said source, wherein said metadata comprises domain specific knowledge obtained by analyzing said data source, and wherein said metadata represents at least one abstract concept, at least one database description, at least one transformation and at least one mapping;
• automatically generating a mediator based on said metadata, wherein said mediator comprises data management code, wherein said code defines a translation library and a mediator class;
• and
• writing a wrapper for said source which calls said mediator, wherein said method is applied to data warehousing applications in the domain of astrophysics and climate modeling.