Berthold J Reinwald from 6584 Whispering Pines Dr, San Jose, CA 95120, age 61, Phone: 4088359992

Resumes

Principal Research Staff Member At Ibm Research - Almaden

view source

Location:

San Francisco, CA

Industry:

Computer Software

Work:

Ibm
Principal Research Staff Member at Ibm Research - Almaden
Ibm
Research Staff Member

Education:

University of Erlangen - Nuernberg, Germany Jun 1993
Doctorates, Doctor of Philosophy, Computer Science University of Erlangen - Nuremberg 1983 - 1993
Doctorates, Doctor of Philosophy, Computer Science

Us Patents

System And Method For Adaptive Database Caching
view source
US Patent:

7395258, Jul 1, 2008
Filed:

Jul 30, 2004
Appl. No.:

10/902583
Inventors:

Mehmet Altinel - San Jose CA, US
Christof Bornhoevd - San Francisco CA, US
Chandrasekaran Mohan - San Jose CA, US
Mir Hamid Pirahesh - San Jose CA, US
Berthold Reinwald - Los Gatos CA, US
Saileshwar Krishnamurthy - Palo Alto CA, US
Assignee:

International Business Machines Corporation - Armonk NY
International Classification:

G06F 17/30
US Classification:

707 3
Abstract:

A local database cache enabling persistent, adaptive caching of either full or partial content of a remote database is provided. Content of tables comprising a local cache database is defined on per-table basis. A table is either: defined declaratively and populated in advance of query execution, or is determined dynamically and asynchronously populated on-demand during query execution. Based on a user input query originally issued against a remote DBMS and referential cache constraints between tables in a local database cache, a Janus query plan, comprising local, remote, and probe query portions is determined. A probe query portion of a Janus query plan is executed to determine whether up-to-date results can be delivered by the execution of a local query portion against a local database cache, or whether it is necessary to retrieve results from a remote database by executing a remote query portion of Janus query plan.

Entity-Based Business Intelligence
view source
US Patent:

7792856, Sep 7, 2010
Filed:

Jun 29, 2007
Appl. No.:

11/771668
Inventors:

Ariel Fuxman - San Jose CA, US
Peter Jay Haas - San Jose CA, US
Berthold Reinwald - San Jose CA, US
Yannis Sismanis - San Jose CA, US
Ling Wang - San Jose CA, US
Assignee:

International Business Machines Corporation - Armonk NY
International Classification:

G06F 17/30
G06F 7/00
US Classification:

707769, 707602, 707718
Abstract:

A method is disclosed for conducting a query to transform data in a pre-existing database, the method comprising: collecting database information from the pre-existing database, the database information including inconsistent dimensional tables and fact tables; running an entity discovery process on the inconsistent dimensional tables and the fact tables to produce entity mapping tables; using the entity mapping tables to resolve the inconsistent dimensional tables into resolved dimensional tables; and running the query on a resolved database to obtain a query result, the resolved database including the resolved dimensional table.

Discovering Topical Structures Of Databases
view source
US Patent:

7818323, Oct 19, 2010
Filed:

Feb 21, 2008
Appl. No.:

12/034964
Inventors:

Rajesh P. Manjrekar - San Jose CA, US
Berthold Reinwald - San Jose CA, US
John Sismanis - San Jose CA, US
Wensheng Wu - San Jose CA, US
Assignee:

International Business Machines Corporation - Armonk NY
International Classification:

G06F 7/00
G06F 17/30
US Classification:

707738, 707737, 707736, 707802, 707803
Abstract:

A system and method for automatically discovering topical structures of databases includes a model builder adapted to compute various kinds of representations for the database based on schema information and data values of the database. A plurality of base clusterers is also provided, one for each representation. Each base clusterer is adapted to perform, for the representation, preliminary topical clustering of tables within the database to produce a plurality of clusters, such that each of the clusters corresponds to a set of tables on the same topic. A meta-clusterer aggregates results of the clusterers into a final clustering, such that the final clustering comprises a plurality of the clusters. A representative finder identifies representative tables from the clusters in the final clustering. The representative finder identifies at least one representative table for each of the clusters in the final clustering.

Methods For Obtaining Improved Text Similarity Measures Which Replace Similar Characters With A String Pattern Representation By Using A Semantic Data Tree
view source
US Patent:

7945525, May 17, 2011
Filed:

Nov 9, 2007
Appl. No.:

11/937550
Inventors:

Rema Ananthanarayanan - New Delhi, IN
Sreeram V. Balakrishnan - Los Altos CA, US
Yuen Y. Lo - Cambridge MA, US
Berthold Reinwald - San Jose CA, US
Assignee:

International Business Machines Corporation - Armonk NY
International Classification:

G06F 17/00
US Classification:

706 45
Abstract:

The embodiments of the invention provide methods for obtaining improved text similarity measures. More specifically, a method of measuring similarity between at least two electronic documents begins by identifying similar terms between the electronic documents. This includes basing similarity between the similar terms on patterns, wherein the patterns can include word patterns, letter patterns, numeric patterns, and/or alphanumeric patterns. The identifying of the similar terms also includes identifying multiple pattern types between the electronic documents. Moreover, the basing of the similarity on patterns identifies terms within the electronic documents that are within a category of a hierarchy. Specifically, the identifying of the terms reviews a hierarchical data tree, wherein nodes of the tree represent terms within the electronic documents. Lower nodes of the tree have specific terms; and, wherein higher nodes of the tree have general terms.

System And Method For Adaptive Database Caching
view source
US Patent:

7945577, May 17, 2011
Filed:

May 19, 2008
Appl. No.:

12/123101
Inventors:

Mehmet Altinel - San Jose CA, US
Chandrasekaran Mohan - San Jose CA, US
Mir Hamid Pirahesh - San Jose CA, US
Berthold Reinwald - Los Gatos CA, US
Saileshwar Krishnamurthy - Palo Alto CA, US
Assignee:

International Business Machines Corporation - Armonk NY
International Classification:

G06F 17/00
US Classification:

707769
Abstract:

A local database cache enabling persistent, adaptive caching of either full or partial content of a remote database is provided. Content of tables comprising a local cache database is defined on per-table basis. A table is either: defined declaratively and populated in advance of query execution, or is determined dynamically and asynchronously populated on-demand during query execution. Based on a user input query originally issued against a remote DBMS and referential cache constraints between tables in a local database cache, a Janus query plan, comprising local, remote, and probe query portions is determined. A probe query portion of a Janus query plan is executed to determine whether up-to-date results can be delivered by the execution of a local query portion against a local database cache, or whether it is necessary to retrieve results from a remote database by executing a remote query portion of Janus query plan.

Entity-Based Business Intelligence
view source
US Patent:

7979436, Jul 12, 2011
Filed:

Jun 5, 2008
Appl. No.:

12/133552
Inventors:

Ariel Fuxman - San Jose CA, US
Peter Jay Haas - San Jose CA, US
Berthold Reinwald - San Jose CA, US
Yannis Sismanis - San Jose CA, US
Ling Wang - San Jose CA, US
Assignee:

International Business Machines Corporation - Armonk NY
International Classification:

G06F 7/00
US Classification:

707737
Abstract:

A method is disclosed for conducting a query to transform data in a pre-existing database, the method comprising: collecting database information from the pre-existing database, the database information including inconsistent dimensional tables and fact tables; running an entity discovery process on the inconsistent dimensional tables and the fact tables to produce entity mapping tables; using the entity mapping tables to resolve the inconsistent dimensional tables into resolved dimensional tables; and running the query on a resolved database to obtain a query result, the resolved database including the resolved dimensional table.

Method For Estimating The Number Of Distinct Values In A Partitioned Dataset
view source
US Patent:

7987177, Jul 26, 2011
Filed:

Jan 30, 2008
Appl. No.:

12/022601
Inventors:

Kevin Scott Beyer - San Jose CA, US
Rainer Gemulla - Dresden, DE
Peter Jay Haas - San Jose CA, US
Berthold Reinwald - San Jose CA, US
John Sismanis - San Jose CA, US
Assignee:

International Business Machines Corporation - Armonk NY
International Classification:

G06F 17/00
G06F 17/30
US Classification:

707713, 707600, 707698, 707719, 707747
Abstract:

The task of estimating the number of distinct values (DVs) in a large dataset arises in a wide variety of settings in computer science and elsewhere. The present invention provides synopses for DV estimation in the setting of a partitioned dataset, as well as corresponding DV estimators that exploit these synopses. Whenever an output compound data partition is created via a multiset operation on a pair of (possibly compound) input partitions, the synopsis for the output partition can be obtained by combining the synopses of the input partitions. If the input partitions are compound partitions, it is not necessary to access the synopses for all the base partitions that were used to construct the input partitions. Superior (in certain cases near-optimal) accuracy in DV estimates is maintained, especially when the synopsis size is small. The synopses can be created in parallel, and can also handle deletions of individual partition elements.

Invocation Of Web Services From A Database
view source
US Patent:

8166006, Apr 24, 2012
Filed:

Sep 28, 2001
Appl. No.:

09/968353
Inventors:

Larry Brown - Austin TX, US
James C. Kleewein - San Jose CA, US
Berthold Reinwald - Los Gatos CA, US
Peter M. Schwarz - San Jose CA, US
Charles Daniel Wolfson - Austin TX, US
Assignee:

International Business Machines Corporation - Armonk NY
International Classification:

G06F 17/30
US Classification:

707702
Abstract:

The present invention provides a method, system and program product for integrating a service external to a database into a database such that the service may be easily invoked from the database. Preferably, the service is a web service available over the internet The service may be invoked from any of a number of invoking mechanisms of the database. In a first specific embodiment, the mechanism comprises a user-defined function within an SQL statement. In a second specific embodiment, the mechanism comprises a virtual table. In a third specific embodiment, the mechanism comprises a stored procedure. In a fourth specific embodiment, the mechanism comprises a trigger. In a fifth specific embodiment, the mechanism comprises a federated table accessed via a nickname and implemented using a wrapper.