Hewlett-packard Development Company, L.p.

Mingsheng Hong

William Frederick Mann, Iii

Shilpa Lawande

Lakshmikant Shrinivas

Andrew Allinson Lamb

Matthew Steven Fuller

Eric Kenneth McCall

Hongmin Fan

Rajat Venkatesh

Chang-Jian Sun

Priya Arun

A record-pattern expression of a record pattern of data records is translated to a character-pattern expression of a character pattern. A data-record series of data records is converted to a character string in which each character in the character string corresponds to a respective data record in the data-record series. Pattern instances of the character pattern in the character string are searched to identify ordinal character positions in the character string of characters in the character pattern instances. Data records at ordinal record positions in the record series of data records corresponding to the ordinal character positions are reported.

Data-record pattern searching

A database management system (DBMS) client calls an interface of a DBMS server to execute a statement that has been prepared to be executed in batch form in relation to a database managed by the DBMS server. The DBMS client provides a different batch of data to the DBMS server each time the DBMS client calls the interface. The DBMS server processes the different batch of data in accordance with the statement that has been prepared, to effectuate execution of the statement at the DBMS server on a batch basis in relation to the different batch of data. The DBMS server returns results of processing the different batch of data to the DBMS client, such that the DBMS client receives intermediate feedback as to status of processing the statement prior to the statement being completely processed.

Batch DBMS statement processing such that intermediate feedback is provided prior to completion of processing

Methods, systems, and apparatus, including computer programs encoded on a computer storage medium, for a database designer and a database storage designer. In one aspect, a method includes creating a set of candidate projections and progressively narrowing the set of candidate projections and a set of queries by eliminating candidate projections that do not satisfy a performance improvement criterion for remaining queries based on the properties associated with the candidate projections.

Database designer

Growing community of inventors

North Billerica, MA, United States of America

Mingsheng Hong