PAUL NORMAN WEINBERG
Pilots at Wilshire Blvd, Los Angeles, CA

8510341, Aug 13, 2013

Nov 21, 2008

12/275934

Paul N. Weinberg - Los Angeles CA, US
Dave L. Sullivan - Canoga Park CA, US
Eugene Cherny - Sherman Oaks CA, US

SAP AG - Walldorf

G06F 7/00, G06F 17/30

707794, 707793

The reusable custom-defined nestable compound data type for construction of database objects of one or more embodiments of the invention provide advantages over traditional non-reusable structured tables of RDBM systems. The data structure of one or more embodiments of the invention may be thought of in part as a generalized form of a user defined compound data type that may be used to model various “exotic” data structures, such as flexible hierarchies and networks, in database schema. Thus, the system, methods and data structures of one or more embodiments of the invention may be used to define and instantiate structures that support the creation of flexible nested records that expose the relationship between parent records and private child sub-records in a database schema.

6754666, Jun 22, 2004

Aug 21, 2000

09/643208

David E. Brookler - Los Angeles CA
Ariel Hazi - Los Angeles CA
Dave L. Sullivan - North Hollywood CA
Dominic Tham - Los Angeles CA
Philip A. Tinari - Beverly Hills CA
Paul N. Weinberg - Los Angeles CA

A2i, Inc. - Los Angeles CA

G06F 1700

707102, 7071041, 705 29

The present invention provides for storage of data items with dissimilar structures in a single database table while minimizing the problems associated with prior approaches. In one aspect of the invention, a method of efficiently storing data items in a database management system (DBMS) is provided wherein each data item has at least one attribute associated with it, the method comprising identifying a set of attributes associated with each data item, creating, for use with all of the data items, a common data structure that excludes those attributes unique to any one of the data items, and associating each data item with attributes excluded from the data structure.

8341191, Dec 25, 2012

Nov 21, 2008

12/276096

Paul N. Weinberg - Los Angeles CA, US

SAP AG - Walldorf

G06F 17/30

707803, 707791

Methods and structures for utilizing reusable custom-defined nestable compound data types to permit product variations within an existing taxonomy are described. Multi-attribute Tuples representing individual product variations provide an efficient way to represent an irregular subset of all attribute permutations. Tuples, using the system, methods and structures of one or more embodiments of the invention, provide an elegant solution to efficiently represent the many variations.

7143339, Nov 28, 2006

Sep 20, 2001

09/960541

Paul N. Weinberg - Los Angeles CA, US
Ariel Hazi - Los Angeles CA, US
Dave L. Sullivan - Canoga Park CA, US
Philip A. Tinari - Beverly Hills CA, US
Alexander K. Alexandrov - Sherman Oaks CA, US
David E. Brookler - Los Angeles CA, US

SAP Aktiengesellschaft - Waldorf

G06F 17/00

715503, 715504, 715509

Embodiments of the invention improve upon current systems by allowing users to dynamically generate and repeatedly modify the appearance of any set of tabular data. When the system obtains input relating to formatting the table, the appearance of the table is dynamically modified so the users can instantaneously view any changes to the table caused by the input (e. g. , WYSIWYG). Users provide input (e. g. , layout information) that relates to various types of pivot operations, sorting operation, and/or merging operations performed on the table. The user may, for example, select a certain field and then initiate a pivot operation using the selected field. The system is configured in accordance with one embodiment of the invention so that the layout information is stored independent of and/or associated with the table data.

7725471, May 25, 2010

Jun 21, 2005

11/157485

Paul N. Weinberg - Los Angeles CA, US
Dave L. Sullivan - Canoga Park CA, US
David E. Brookler - Los Angeles CA, US
Philip A. Tinari - Beverly Hills CA, US
Eugene Cherny - Sherman Oaks CA, US

SAP, AG - Walldorf

G06F 17/30

707740, 707999004, 707999003, 707999102, 707769

An embodiment of the invention comprises a method and apparatus for structuring, storing and retrieving data in database systems utilizing relational objects referred to as qualifiers. Catalog data are segregated into one or more primary tables (e. g. , main tables), one or more lookup tables, and one or more qualified lookup tables following a predefined set of categories and a taxonomy. Qualified lookup tables comprise a special type of fields referred to as qualifiers. Searches are conducted in embodiments of the invention by determining a set of lookup fields, performing a lookup in one or more lookup tables, and retrieving data values which include association values with records that belong to one or more primary tables. The qualifiers are then used to narrow the search space by selecting only those values that satisfy the selection criteria with regard to the qualifiers. In embodiments of the invention, only a small set in the primary table are traversed to retrieve eligible records.

8370757, Feb 5, 2013

Jul 30, 2005

11/192990

Phil Tinari - Los Angeles CA, US
David Brookler - Los Angeles CA, US
Paul Weinberg - Los Angeles CA, US

SAP AG - Walldorf

G06F 3/048

715764, 345619, 345681

When a set of screen elements are identified as a family a bounded extent is placed around the identified elements. Items can be automatically grouped based on their association with a set of data defined in a DBMS as a family, for example. When one of the elements within the group is moved, the extent automatically resizes to a new geometry that fits around each of the elements within the group. If an element within the group is moved against the extent and then extended beyond the boundaries of the extent, the extent automatically resizes to cover a bigger area; if an element within the group that is against the extent is moved inside the boundary of the extent, the extent automatically resizes to cover a smaller area. It is possible to nest a set of these extensible groups within a single extensible group thereby providing maximum flexibility while still maintaining optimal flexibility. In addition, it is possible to “unlink” an item so that it maintains its association with the group but does not effect the extent.

7725483, May 25, 2010

Jul 29, 2005

11/193306

David Poyourow - Los Angeles CA, US
Richard T. Endo - Los Angeles CA, US
Paul N. Weinberg - Los Angeles CA, US

SAP, AG - Walldorf

G06F 7/00, G06F 17/00, G06F 15/16

707763, 707705, 707758

Expression-based data may comprise data that is processed by a validation expression for example. After a validation expression is created it may then be performed with respect to one or more data values or data records. A validation expression returns a Boolean result that signifies a success or failure result. A validation expression can define complex intra-record tests and inter-record tests with unlimited complexity. In order to improve processing of validations, the system uses virtual data known as calculation fields. Calculation fields are stored in memory at runtime and not in a database thereby eliminating the necessity of selecting and updating records in the database. A dirty bit identifying fields and attributes that need to be calculated based on a dependent data may be used to defer calculation to a later time when the calculation field is displayed or a sort operation occurs for example.

7356492, Apr 8, 2008

Aug 4, 2004

10/911232

Ariel Hazi - Los Angeles CA, US
Paul N. Weinberg - Los Angeles CA, US
Matan Arazi - Los Angeles CA, US
Dave L. Sullivan - Sherman Oaks CA, US
Philip A. Tinari - Beverly Hills CA, US
David E. Brookler - Los Angeles CA, US

SAP, Aktiengesellschaft - Walldorf

G06F 17/30

705 27

A system and method for providing a timeshared electronic catalog is disclosed. The system comprises an electronic database having a plurality of data records that comprise a master data set. The system comprises at least a first and second subset of the data records, wherein each subset comprises one or more data records selected from the master data set. The system includes a software program comprising a data record masking module for selectively providing a first view for displaying one of the subsets to a first user. Each of the plurality of data records contains a plurality of data elements, or fields, or attributes. The data record masking module is further for selecting which data elements are provided in the view. The system further includes a means for selectively providing which executable features from a plurality of executable features may be provided with each view.

7734625, Jun 8, 2010

Jul 29, 2005

11/193013

Paul N. Weinberg - Los Angeles CA, US
Richard T. Endo - Los Angeles CA, US
Wenphing Lo - Alhambra CA, US

SAP, AG - Walldorf

G06F 17/30

707736, 707754, 707805

A method for performing expression-based validation with records in a computer system database, eliminating the need to write programs or scripts. A validation expression can define complex intra-record tests and inter-record tests and may be performed manually against one or more records and have a success or failure indicated for each record in an interface. A validation expression may be placed into one or more groups and performed as a group with the success or failure indicated for each record. A validation expression may be initiated from workflows to implement a business process with system-enforced data integrity. A validation expression may be manually executed or automatically executed when attempting record update to prevent the entry of invalid data and ensure data integrity. A validation expression may also be used to search using the Boolean result of validation expressions.