Sap Ag

Sap Se

Azi, Inc.

Therogel, Inc.

A21, Inc.

A2i, Inc.

Paul N Weinberg

David E Brookler

Dave L Sullivan

Philip A Tinari

Ariel Hazi

Richard T Endo

Nathan F Yospe

Eugene Cherny

Wenphing Lo

Dominic Tham

Ronen Cohen

Rich Endo

Anat Levi Segal

Matan Arazi

Alexander K Alexandrov

Phil Tinari

David Poyourow

Mark Hanson

Zheng Liu

Xidong Zheng

Yvette B Scherpenborg

Representing an XML Schema Definition and Data within a Relational Database Management System using a Reusable Custom-Defined Nestable Compound Data Type. These Data Types provide a natural representation and storage of an XML schema definition and the corresponding XML data. Data Types are created in a RDBMS to store the hierarchical data of a XML data file. Hierarchical data may be imported into a RDBMS by populating the Data Type Fields with the values of data held in the XML data file. The data contained in the RDBMS may also be published to an XML data file.

Method of representing an XML schema definition and data within a relational database management system using a reusable custom-defined nestable compound data type

System and method for performing Unicode matching for comparing and merging similar data objects having Unicode strings that are equivalent yet not exact matches. Unicode characters are characterized by number of strokes, stroke order, radicals, geometry, phonemes in association with input method editor and keyboard characteristics such as location of a character on an IME or keyboard (or number of GUI interface interactions used in entering the character, e.g., via tapping where 'a' on a mobile device keyboard takes 1 tap of a key, 'b' takes 2 taps). These characteristics associated with code points and IME's/keyboards are utilized to create subdomains for matching and determining &#x201c;distance&#x201d; to other Unicode code points (e.g., number of keyboard keys away). Allows for determining whether close, yet incorrect data entry may have taken place. Enables merging of duplicate data objects into master data object where minor differences or spelling errors introduce actually represent duplicate data.

System and method for performing Unicode matching

A method for generating and using a reusable custom-defined nestable compound data type for use as a database qualifier provides significant advantages over using traditional non-reusable structured tables of RDBM systems is described. The method and data structures of the invention may be used to define and instantiate flexible nested-record structures that reverse and better expose the relationship between parent records and private child sub-records in a database schema to provide improved referential integrity and visibility into database structure.

Method for generating and using a reusable custom-defined nestable compound data type as database qualifiers

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.

System, method and structures for a reusable custom-defined nestable compound data type for construction of database objects

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.

Interface and method for extensible grouping of screen elements in real time

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.

Methods and structures for utilizing reusable custom-defined nestable compound data types to permit product variations within an existing taxonomy

Methods for enforcing group oriented workflow requirements for multi-layered documents. Embodiments allow results of multi-layered operations to dictate the flow of tasks that occur on a multi-layered document. Flow is directed to roles and may be directed by the data values operated on in addition to multi-layered operation results. The system enables the workflow enabled creation and maintenance of multi-layered documents that minimize repeated data to ensure the highest possible data integrity when targeting a publication at multiple audiences. When a publication is changed and requires maintenance, use of a defined workflow for updating the publication ensures consistency in each publication. Embodiments may comprise performance metrics for monitoring and benchmarking publication processes.

Method for enforcing group oriented workflow requirements for multi-layered documents

Conditionally branching a validation allows branch-specific child validations to execute based on the values of data in a specific record. This allows for example a conditional branch to call another validation to validate records having particular category field values, family values and/or audience level/name/values. Embodiments comprise an interface that assists users through the use of automatic tokenizing and/or pick lists of field names and fields values, including a measurement builder for entering legal tokenized measurement values with applicable units of measure. Embodiments of the invention allow knowledgeable users to rapidly create expressions to ensure that the legal syntax and semantics of an expression are not violated while providing the user with pick lists and measurement values within legal ranges and with applicable units of measure. Validations rules are generated and performed on desired records in a computer system database without requiring programs, scripts or queries to be written.

Method for conditionally branching a validation

A lightweight, flexible, aerating, compressive, thermal material. Perforations allow the treatment area to aerate. Thermal capacity of the invention allows for hot or cold treatment in a manner that compressively supports the object undergoing thermal treatment while maintaining maximum mobility. The material is made from an elastomer such as polyurethane with the addition of silicon and vegetable oil. Resin is used to color the product.

Tubular compressive device and methods of use relating to same

Embodiments of the invention improve upon existing auto formatting functions for tables presented in a graphical user interface by providing an improved mechanism for changing table columns in real-time. One embodiment of the invention incorporates a callback or module in a program implementing the mechanism for changing table columns in real-time that intercepts a table column resize event and automatically resizes the other columns in the table. In resizing the table columns the module can employ various approaches. The system may utilize the various resizing approaches to arrive at a desired result.

Method for reallocating table formats in real-time

One or more embodiments of the invention enable a user to search for at least one value in layers of audience specific data comprising language, regional, regulatory and/or cultural specific values per layer. The word 'audience' for the purposes of this specification means a group of document consumers such as people or computers that are associated with a language, country, region, regulation or culture. A search utilizing at least one embodiment of the invention occurs with respect to data that makes use of rule-based inheritance. For a three level inheritance embodiment, there are 8 permutations involving a NULL value in at least one of the layers, instead of making the user calculate the proper mask, the Current Audience Layer mask can be logical ORed with the Primary Audience Layer Mask or the Secondary Audience Layer Mask in order to create the desired search combination. In addition, predefined audience layer operators may also be used comprising 'has value', &#x201c;is missing value&#x201d;, &#x201c;inherits primary&#x201d;, &#x201c;inherits secondary&#x201d;, &#x201c;inherits any&#x201d; and &#x201c;does not inherit&#x201d;. These predefined masks save the user from generating a bit mask for searching by hand.

Method for testing layered data for the existence of at least one value

A method for generating properly formed expressions used as validation expressions and search filters for computer system database applications. One or more embodiments of the invention for example comprise an interface that assists users through the use of automatic tokenizing and/or pick lists of field names and fields values, including a measurement builder for entering legal tokenized measurement values with applicable units of measure. Embodiments of the invention allow knowledgeable users to rapidly create expressions to ensure that the legal syntax and semantics of an expression are not violated while providing the user with pick lists and measurement values within legal ranges and with applicable units of measure. Validations rules are generated and performed on desired records in a computer system database without requiring programs, scripts or queries to be written. A validation expression returns a Boolean result that signifies a success or failure result and may be performed manually or automatically.

Method for generating properly formed expressions

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.

Method for performing expression-based validation

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.

Method and apparatus for generating and utilizing qualifiers and qualified taxonomy tables

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.

Growing community of inventors

Los Angeles, CA, United States of America

Paul N Weinberg