Abstract: A single virtual image of client information centrally located at an always-on network location for maintaining equivalency among multiple user devices. The image can be accessed by the user devices when coming online to upload and receive changes in the client information. A mid-tier system can be employed as the always-on central location with which the user client machines can communicate to maintain the same set of client information. Services in support thereof include an ownership service for dynamic selection of a designated client machine to take ownership for performing the actions on one client machine and arbitration of duplicate requests, a notification service for allowing data sources to publish cache update instructions to a central place, a roaming service for allowing clients machines to share state with each other, and an encryption service for secure storage and communications of client information.

Abstract: A thermally enhanced ball grid array package is disclosed. The package includes a base layer element and a flip chip die mounted on the base layer element. The die has a first surface electrically coupled to the base layer element, a second surface opposite to the first surface, and lateral sides. A molding compound encapsulates the base layer element and the lateral sides of the die. A surface is formed of the second surface of the die and an upper surface of the molding compound. A material is disposed on the surface, and a heat spreader is mounted on the material.

Abstract: Methods, systems, and computer program products detect and manage changes in business data integration (BDI) solutions. BDI solutions include extracting, mapping, or loading source information from disparate sources as targets presented to business applications that consume targets. A method involves detecting changes in a BDI solution, classifying each of the changes based on change severity, analyzing what objects would be impacted by the changes, determining whether the objects impacted by the changes can be change handled without user intervention, and change handling without user intervention all the objects impacted by changes that are not severe. Still further, the method involves committing changes to a metadata repository and creating a deployable checkpoint of the metadata repository where the deployable checkpoint is consistent for all the changes handled in the BDI solution.

Abstract: This document describes tools capable of modifying data records without human interaction, modifying data records responsive to analysis from various types of data-quality modules, and/or reversing modifications. These tools may also enable a data-quality module to find errors by analyzing fewer than all of the records as effectively as if the data-quality module analyzed all of the records.

Abstract: A process for finding a similar data records from a set of data records. A database table or tables provide a number of data records from which one or more canonical data records are identified. Tokens are identified within the data records and classified according to attribute field. A similarity score is assigned to data records in relation to other data records based on a similarity between tokens of the data records. Data records whose similarity score with respect to each other is greater than a threshold form one or more groups of data records. The records or tuples form nodes of a graph wherein edges between nodes represent a similarity score between records of a group. Within each group a canonical record is identified based on the similarity of data records to each other within the group.

Abstract: A system and method allowing for optimization of query execution in database environments is provided. In an illustrative implementation, a database having distributed partitioned views is provided such that queries may initiate at any of the participating data stores. In operation, an offered query is analyzed to determine if it has predicate expression and/or sub-queries. Using this information the expressions and/or sub-queries are analyzed and processed to determine if appropriate start-up filters are available for the offered query. The start-up filters are applied to the query such that during compile and/or run time, redundant partitions in the distributed partitioned database environment are eliminated during query execution.

Abstract: System(s) and/or method(s) (“tools”) are described that enable actions to be reused that are common to multiple similarity functions. The tools may do so, in one embodiment, by composing similarity functions into a single, composed function that performs actions once that are common to multiple similarity functions. This composed function may also permit data to be analyzed in one pass and/or render unnecessary a merge operation. The tools may also enable actions to be reused when a similarity function is performed multiple times. The tools may do so, in one embodiment, by retaining a result of performing an action and using that result when performing the similarity function again. The tools may also enable records to be compared using a flip-window algorithm. This algorithm may be an efficient way in which to compare records in a table to determine which of those records are similar or duplicates.

Abstract: System(s) and/or method(s) (“tools”) are described that enable multiple executable ETL (Extract, Transform, and Load) packages to be built based on a single template. The tools also enable multiple executable ETL packages to be altered by altering a single template and/or set of data parameters. In some embodiments the tools provide many types of templates that are capable, once instantiated with data parameters, of performing many different types of processes useful in extracting, transforming, and/or loading data from databases to a data warehouse. In so doing, the tools can help users to more easily, accurately, and/or robustly build ETL packages.

Abstract: A system and method allowing for optimization of query execution in database environments is provided. In an illustrative implementation, a database having distributed partitioned views is provided such that queries may initiate at any of the participating data stores. In operation, an offered query is analyzed to determine if it has predicate expression and/or sub-queries. Using this information the expressions and/or sub-queries are analyzed and processed to determine if appropriate start-up filters are available for the offered query. The start-up filters are applied to the query such that during compile and/or run time, redundant partitions in the distributed partitioned database environment are eliminated during query execution.

Abstract: An exemplary computer-implementable method includes providing a trigger that executes a script upon receipt of change information for changing reference information or an instruction associated with change information for changing reference information, in response to execution of the script, allocating memory for processing the change information and based on the processing of the change information, building an index associated with a fuzzy lookup service. Various other exemplary methods, devices, systems, etc., are also disclosed.

Abstract: A thermally enhanced ball grid array package is disclosed. The package includes a base layer element and a flip chip die mounted on the base layer element. The die has a first surface electrically coupled to the base layer element, a second surface opposite to the first surface, and lateral sides. A molding compound encapsulates the base layer element and the lateral sides of the die. A surface is formed of the second surface of the die and an upper surface of the molding compound. A material is disposed on the surface, and a heat spreader is mounted on the material.

Abstract: A system and method allowing for optimization of query execution in database environments is provided. In an illustrative implementation, a database having distributed partitioned views is provided such that queries may initiate at any of the participating data stores. In operation, an offered query is analyzed to determine if it has predicate expression and/or sub-queries. Using this information the expressions and/or sub-queries are analyzed and processed to determine if appropriate start-up filters are available for the offered query. The start-up filters are applied to the query such that during compile and/or run time, redundant partitions in the distributed partitioned database environment are eliminated during query execution.

Abstract: A process for finding a similar data records from a set of data records. A database table or tables provide a number of data records from which one or more canonical data records are identified. Tokens are identified within the data records and classified according to attribute field. A similarity score is assigned to data records in relation to other data records based on a similarity between tokens of the data records. Data records whose similarity score with respect to each other is greater than a threshold form one or more groups of data records. The records or tuples form nodes of a graph wherein edges between nodes represent a similarity score between records of a group. Within each group a canonical record is identified based on the similarity of data records to each other within the group.

Abstract: A system and method allowing for optimization of query execution in database environments is provided. In an illustrative implementation, a database having distributed partitioned views is provided such that queries may initiate at any of the participating data stores. In operation, an offered query is analyzed to determine if it has predicate expression and/or sub-queries. Using this information the expressions and/or sub-queries are analyzed and processed to determine if appropriate start-up filters are available for the offered query. The start-up filters are applied to the query such that during compile and/or run time, redundant partitions in the distributed partitioned database environment are eliminated during query execution.

Abstract: A system and method allowing for optimization of query execution in database environments is provided. In an illustrative implementation, a database having distributed partitioned views is provided such that queries may initiate at any of the participating data stores. In operation, an offered query is analyzed to determine if it has predicate expression and/or sub-queries. Using this information the expressions and/or sub-queries are analyzed and processed to determine if appropriate start-up filters are available for the offered query. The start-up filters are applied to the query such that during compile and/or run time, redundant partitions in the distributed partitioned database environment are eliminated during query execution.

Abstract: Two substrates each carrying MEMS or MOEMS structures are bonded face to face and interconnected to form a compact surface-mountable package.

Abstract: A MEMS/MOEMS device is provided on a first substrate which is bonded to a second substrate to form a package. Interconnections may be provided via the second substrate and an hermetic seal may be formed to protect the MEMS/MOEMS device from outgassing.

Abstract: An index is used for a query that contains an original condition having a comparison based on a function. An implied condition is first identified and applied to values in a column having multiple rows. An index is used to identify rows having values meeting the implied condition. Finally, the query is executed over the index using the original condition. Flags may be used to identify how to handle exceptions during run time. A table may be used to provide bounds for multiple different functions.

Abstract: A system and methods allowing for the transparent updates of views in database environments is provided. In operation, the partitioned view may be modified, deleted, or replaced using a portioning function. A partitioning function operates on data in the database environment to provide updates of partitioned views. The partitioning function is generated for each partitioned view. The partitioning function is generated by loading the partitioning constraint expression on the partitioning column for each child table of the partitioned view. The tables are remapped such that a view column is superimposed on the partitioning column. The resulting remapped table is stored in an array of expressions that are then processed to produce the partitioning function. The partition-id of each table in the partitioned view is set based on their order of appearance in the initial view definition. Further, the present invention contemplates partitioned column updates and non-partitioned column updates.

Abstract: Die pads are provided which reduce moisture retention and thermal mismatch by employing a number of die pad sections or a die pad support portion with a number of relief regions. In each case, the die pad area to die area ratio is reduced to improve the thermal mismatch between the die and the die pad. Also, the die pad sections or relief regions are arranged in a spaced apart fashion to provide moisture escape paths between the die and the die pad.