Abstract: Methods are provided for connecting two dissimilar materials. The methods can include: placing a first material within a groove of a second material, the first material leaving at least a portion of the groove vacant; and placing a third material upon the first material and over the groove; heating the second and third materials to a temperature sufficient to plasticize the second and third materials within the groove and form a mixture of the second and third materials within the groove. Friction stir welding tools are also provided that can include a frusta conical tip having an upper portion defining smooth sidewalls and a lower portion defining a roughened structure.

Abstract: A method for connecting two dissimilar materials having different melting points is described wherein a the materials are heated together to obtain plasticization of the lower melting point material within a prefigured geometry within a first material in such a way so as to form intermetallic features within a solid state joint.

Abstract: Methods and systems for performing database transactions include executing a first transaction request in a preplay mode that locks the requested data with a prefetch-lock and reads one or more requested data items from storage into a main memory buffer; locking the requested data items with a read/write lock after said data items are read into the main memory buffer; and performing the requested transaction on the data items in the main memory buffer using a processor.

Abstract: Methods are provided for connecting two dissimilar materials. The methods can include: placing a first material within a groove of a second material, the first material leaving at least a portion of the groove vacant; and placing a third material upon the first material and over the groove; heating the second and third materials to a temperature sufficient to plasticize the second and third materials within the groove and form a mixture of the second and third materials within the groove. Friction stir welding tools are also provided that can include a frusta conical tip having an upper portion defining smooth sidewalls and a lower portion defining a roughened structure.

Abstract: A method for solid state joining of dissimilar materials using a friction stir welding device wherein a pin is inserted through an aperture defined in a first material and a second material to hold the materials together and then held in place by friction stir welding a portion of the pin to a material adjacent said pin, or by friction stir welding a cap or plug that holds the pin in place to the adjacent material. The result is a connection or join wherein the central portion of the pin is not friction stir welded but the portions holding the pin in place (the ends or caps) generally are.

Abstract: A method for solid state joining of dissimilar materials using a friction stir welding device wherein a pin is inserted through an aperture defined in a first material and a second material to hold the materials together and then held in place by friction stir welding a portion of the pin to a material adjacent said pin, or by friction stir welding a cap or plug that holds the pin in place to the adjacent material. The result is a connection or join wherein the central portion of the pin is not friction stir welded but the portions holding the pin in place (the ends or caps) generally are.

Abstract: A method for solid state joining of dissimilar materials using a friction stir welding device wherein a pin is inserted through an aperture defined in a first material and a second material to hold the materials together and then held in place by friction stir welding a portion of the pin to a material adjacent said pin, or by friction stir welding a cap or plug that holds the pin in place to the adjacent material. The result is a connection or join wherein the central portion of the pin is not friction stir welded but the portions holding the pin in place (the ends or caps) generally are.

Abstract: Methods and a system are provided. A method includes maintaining an in-page log for records in each of a plurality of data pages of a multi-version database. The method further includes adding record update information to the in-page log when a corresponding one of the records is deleted or updated. The method also includes consulting the in-page log for a recently updated one of the records or a recently deleted one of the records to determine a record status thereof. The method additionally includes spilling, by a processor-based overflow manager, to overflow pages when the in-page log is full. The data pages include any of row-oriented data pages and column-oriented data pages.

Abstract: Methods and a system are provided. A method includes maintaining an in-page log for records in each of a plurality of data pages of a multi-version database. The method further includes adding record update information to the in-page log when a corresponding one of the records is deleted or updated. The method also includes consulting the in-page log for a recently updated one of the records or a recently deleted one of the records to determine a record status thereof. The method additionally includes spilling, by a processor-based overflow manager, to overflow pages when the in-page log is full. The data pages include any of row-oriented data pages and column-oriented data pages.

Abstract: An improved process for performing ultrasonic sensing and inspections wherein a cold-spray technique is used to kinetically bond powdered material to a substrate and then an EMAT sensor is magnetically attached to the coating. In use the ultrasound will transfer from the magnetostrictive layer into the substrate more effectively than any glued coating without concerns for long term degradation.

Abstract: A method includes the following steps. One or more records are accessed from a database memory bypassing a database access mechanism of a database system. Data representing access frequency of the one or more records are collected. The collected access frequency data for the one or more records are maintained. The access frequency data for the one or more records are aggregated until the access frequency reaches a threshold value. The aggregated access frequency data are asynchronously reported for the one or more records to the database system.

Abstract: The described embodiments relate generally to methods for enhancing cosmetic surfaces of friction stir processed parts. More specifically a method for applying cold spray over a weld line generated by friction stir processing is disclosed. Methods are also disclosed for blending the cold spray applied over the weld line with a cosmetic surface portion of the friction stir processed parts. In some embodiments cold spray can be used to create a cosmetic joint between various parts. Structural joints between first and second substrates may also be formed via solid state deposition. Such joints may be strengthened through use of a hidden weld, mechanical interlocking between the substrates, and/or coupling via fasteners.

Abstract: A method for connecting two dissimilar materials having different melting points is described wherein a the materials are heated together to obtain plasticization of the lower melting point material within a prefigured geometry within a first material in such a way so as to form intermetallic features within a solid state joint.

Abstract: Staging data record changes from a faster storage medium to a slower storage medium using data query rewriting is provided. In response to receiving a data query corresponding to a particular data record, it is determined whether the data query is one of a transactional data query or an analytical data query. In response to determining that the data query is a transactional data query, the transactional data query is rewritten to apply transactional delta changes to the particular data record on a storage-class memory of a computer. In response to determining that the data query is an analytical data query, the analytical data query is rewritten to select and reconcile each data record corresponding to the particular data record stored on the storage-class memory with the particular data record stored on a persistent data storage device of the computer.

Abstract: Staging data record changes from a faster storage medium to a slower storage medium using data query rewriting is provided. In response to receiving a data query corresponding to a particular data record, it is determined whether the data query is one of a transactional data query or an analytical data query. In response to determining that the data query is a transactional data query, the transactional data query is rewritten to apply transactional delta changes to the particular data record on a storage-class memory of a computer. In response to determining that the data query is an analytical data query, the analytical data query is rewritten to select and reconcile each data record corresponding to the particular data record stored on the storage-class memory with the particular data record stored on a persistent data storage device of the computer.

Abstract: The described embodiments relate generally to methods to enhance cosmetic surfaces of friction stir processed parts. More specifically a method for applying cold spray over a weld line generated by the friction stir processing is disclosed. Methods are also disclosed for blending the cold spray applied over the weld line in with a cosmetic surface portion of friction stir processed parts. In some embodiments cold spray can be used to on its own to create a cosmetic join between various parts.

Abstract: A method includes the following steps. One or more records are accessed from a database memory bypassing a database access mechanism of a database system. Data representing access frequency of the one or more records are collected. The collected access frequency data for the one or more records are maintained. The access frequency data for the one or more records are aggregated until the access frequency reaches a threshold value. The aggregated access frequency data are asynchronously reported for the one or more records to the database system.

Abstract: Managing a multi-version data record database is provided. A mapping is maintained between a logical record identifier and committed and uncommitted physical record identifiers corresponding to data records using an indirection mapping table. Entries are updated within an index to point to the logical record identifier instead of the committed and uncommitted physical record identifiers. The committed physical record identifier corresponding to a data record is read from the indirection mapping table to access a committed version of the data record while a writer is modifying the data record to prevent the writer from blocking a reader. An uncommitted physical record identifier corresponding to the data record is written in the indirection mapping table to insert a new uncommitted version of the data record within a data table while the reader is reading the committed version of the particular data record to prevent the reader from blocking the writer.

Abstract: Methods and a system are provided. A method includes maintaining an in-page log for records in each of a plurality of data pages of a multi-version database. The method further includes adding record update information to the in-page log when a corresponding one of the records is deleted or updated. The method also includes consulting the in-page log for a recently updated one of the records or a recently deleted one of the records to determine a record status thereof. The method additionally includes spilling, by a processor-based overflow manager, to overflow pages when the in-page log is full. The data pages include any of row-oriented data pages and column-oriented data pages.

Abstract: Methods and a system are provided. A method includes maintaining an in-page log for records in each of a plurality of data pages of a multi-version database. The method further includes adding record update information to the in-page log when a corresponding one of the records is deleted or updated. The method also includes consulting the in-page log for a recently updated one of the records or a recently deleted one of the records to determine a record status thereof. The method additionally includes spilling, by a processor-based overflow manager, to overflow pages when the in-page log is full. The data pages include any of row-oriented data pages and column-oriented data pages.