Abstract: A method for creating a self-configuring database system using a reusable custom-defined nestable compound data type of the invention provides significant advantages over using traditional non-reusable structured tables of RDBM systems. A data structure concept and associated method support creating a self-configuring database system programmatically responsive to importing data using schema descriptions in multiple formats. Thus, the method and data structures of the invention may be used to define and instantiate flexible nested record structures that reverses and better exposes the relationship between parent records and private child sub-records in a database schema.

Abstract: Enables locating and merging potential data record matches. Enables locating duplicates through the definition of matching strategies. Each strategy may include transformations, matching rules and scoring thresholds to implement fuzzy matches that match closely related data records that are not exact matches. Performing a search allows for narrowing down the records to a desired set on which to apply a given matching strategy. Merging is performed on the potential duplicates thus located to consolidate data and remove duplicates. By narrowing down the records to a closely related set via a search, merging is simplified to work on a small number of closely related records, thus simplifying the process. The total matching score obtained via execution of match strategies may be utilized to determine which potential record(s) to merge for example. May utilize past user input to provide intelligent inputs for rules, tokens, weights, fields, parameters or any other past user input.

Abstract: A method for metadata verification of a data repository of a computer system is described comprising accessing a data repository through a data profiler program, querying the data repository for metadata information about the data repository, presenting statistics regarding the metadata information using the profiler, analyzing the metadata information to identify suspect metadata information from the data repository and presenting the suspect metadata information for inspection using the profiler.

Abstract: 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.

Abstract: Adaptive matching of similar data in a data repository to determine if two or more data items are related in accordance with configurable criteria. Matches are adapted by learning and presenting appropriate match criteria based on previous user input. The system can merge the data items into one master data item, group similar items and perform further processing based on the result. The configurable match criteria presented to a user are adapted by the system based on previous interactions of the system with users. Matching is performed by selecting data items to match, removing frequently used strings, normalizing data, tokenizing multi-word data items, assigning weights to each token, calculating a score using the assigned weights, generating groups of similar records, assigning thresholds for match levels. Adapting choices of match criteria for a user based on past interaction allows for rapid match creation and match maintenance that optimizes data integrity across an enterprise.

Abstract: Enables a database generator interface configured to map complex constructs and semantics so internal complexities are hidden while providing efficient internal storage and speed. Extracts and analyzes complex relationships in database and exposes schema as XSD to allow for external interfacing. Presents a list of tables and fields that exist in database and accepts user input to determine which tables and fields to create an interface for. Lookup fields are listed which allow for user input for specifying which fields to create XSD enumeration lists for. The generated XSD file may be saved and utilized by other mapping tools to allow for interfacing with other databases. Mapping the schema of a extended SQL database allows for users with limited understanding of the internals of the extended SQL database to connect the database to other systems using commonly available tools. May be coupled with web services to provide universal access.

Abstract: A data generator for database schema verification, system sizing and functional test of data dependent applications. Allows for generation of data from random values or from working databases which may be profiled to generate patterns for occurrences of values and sizes of values. The data may be filled with a fill rate that dictates the percentage of fields assigned nulls. Cardinality allows for a fixed number of values to occur across the records for a field. May utilize reference data associated with an existing database to fill fields. Qualifiers and multi-value fields may be filled to mimic real data. Maximum, nominal and average number of occurrences of sizes of data and qualifiers and multi-value data may be specified. May also utilize dictionaries to fill. Hierarchical levels and number of child nodes may also be specified and used in filling taxonomy tables and hierarchy tables for example.

Abstract: A schema modeler for generating an efficient database schema. Provides intelligent choices for schema structure, generates efficient schemas while minimizing the amount of experience required by a database designer. Architectural elements of a schema design are proposed based on field inputs such as field type or relationship. Schema information is manually entered or imported. Configured for structural compatibility and semantic compatibility checking on fields and relationships for data integrity due to nested structure denormalization, inspection of lookup tables that can hold an unlimited number of records, inspection of taxonomy defined on a non-main table, and inspection of the schema for the existence of a main table. Provide suggested field types or schema structures that allow for a more efficient schema to be generated. Field types may include qualifier, multi-lingual, calculation and may include family or attribute table suggestions as well.

Abstract: Enables locating and merging potential data record matches. Enables locating duplicates through the definition of matching strategies. Each strategy may include transformations, matching rules and scoring thresholds to implement fuzzy matches that match closely related data records that are not exact matches. Performing a search allows for narrowing down the records to a desired set on which to apply a given matching strategy. Merging is performed on the potential duplicates thus located to consolidate data and remove duplicates. By narrowing down the records to a closely related set via a search, merging is simplified to work on a small number of closely related records, thus simplifying the process. The total matching score obtained via execution of match strategies may be utilized to determine which potential record(s) to merge for example. May utilize past user input to provide intelligent inputs for rules, tokens, weights, fields, parameters or any other past user input.

Abstract: Adaptive matching of similar data in a data repository to determine if two or more data items are related in accordance with configurable criteria. Matches are adapted by learning and presenting appropriate match criteria based on previous user input. The system can merge the data items into one master data item, group similar items and perform further processing based on the result. The configurable match criteria presented to a user are adapted by the system based on previous interactions of the system with users. Matching is performed by selecting data items to match, removing frequently used strings, normalizing data, tokenizing multi-word data items, assigning weights to each token, calculating a score using the assigned weights, generating groups of similar records, assigning thresholds for match levels. Adapting choices of match criteria for a user based on past interaction allows for rapid match creation and match maintenance that optimizes data integrity across an enterprise.

Abstract: A user interface for parsing unstructured data using pattern recognition. The patterns used in parsing data are formed from regular expressions. The parsed data may be displayed in a first format and unmatched strings in the unstructured text may be displayed in a second format. A format may comprise a desired color, font or any other user interface parameter. In addition, the data that parses according to a pattern may be placed in a column associated with the pattern in a tabular user interface, for example a spreadsheet like Excel™. Associating a pattern with a position to display successful matches in allows for breaking unstructured text into pieces associated with a particular field or column. Modification of the patterns allows for more and more of the unstructured text to match the patterns and when the data has been parsed to the desired level, the data may be imported into a database.

Abstract: A composite solid electrolyte having a transference number above 0.5 for use in primary or secondary electrochemical cells. The solid electrolyte includes non-conductive oxide particles, of less than 5 microns in size, an alkali metal salt coating or in contact with these particles, an insulating elastomer forming a complex with the salt, and a solvent. Batteries and multi-cell batteries contain such solid electrolyte, and such batteries can be assembled with the cathod in the discharged state.

Abstract: A system for the supply of electrical energy by means of one or more high-power electrochemical cells. The system comprises a housing, such cell or cells being located at least partially in said housing and a fan or fans actuated during heavy discharge of the cell or cells to prevent the temperature rise of the cell or cells above a certain value. The system is of importance for high power cells, such as the various types of lithium cells, calcium, lithium alloy and calcium alloy cells. Temperature sensing means and a switch can be provided adapted to actuate the fan or fans when the temperature exceeds a certain value so as to provide cooling forced air circulation.

Abstract: The invention relates to a multi-cell battery of electro-chemical cells of the type which is likely to be severely damaged and which is apt to release a substantial quantity of heat when short-circuited.According to the invention, the multi-cell unit is provided with a certain filler in the space between the constituent electrochemical cells, which is either a solid with a melting point in a predetermined range of temperature, or a liquid. The filler ought to be electrically non-conducting, and its quantity ought to have an adequate heat capacity and it ought also to be capable to transfer heat to adjacent cells.