Abstract: Systems and methods for asynchronous API-driven external application services for blockchain are provided. The blockchain may store profile data that permits asynchronous communications and data sharing among a plurality of trusted users, and an application server layer may act as a gateway to a blockchain system to selectively provide limited access to external application services to operate upon the blockchain data.

Abstract: The present disclosure relates generally to building surface products, for example, panels suitable for forming a building surface. The present disclosure relates more particularly to a building surface product including a gypsum panel with an upper edge that overlaps a lower edge of a neighboring gypsum panel.

Abstract: A system for testing abrasion resistance of a test specimen made of refractory material, wherein the system includes an insulated furnace with a first chamber having a refractory lining, a second chamber disposed within the first chamber, a tube for flowing pressurized air into the second chamber, a conduit for flowing heated air from a burner operating on a fuel to the second chamber, for mixing with the pressurized air, and an air gun for mixing an abrading material into the pressurized air prior to introduction to the test specimen.

Abstract: An approach for using functional indexes as a primary filter is provided. A database query that contains a reference to a column of a table, but does not contain any reference to a functional index based on that column, is received by a database server. The database server adds to the database query a reference to the functional index on the column. The database server determines if the database query should be executed using the functional index. If the database server determines that the database query should be executed using the functional index, then the database query is executed with the functional index. If the database server determines that the database query should not be executed using the functional index, then data that indicates that the functional index is not to be evaluated when the database query is executed is stored.

Abstract: A method for testing abrasion resistance of a test specimen made of refractory material, wherein the method includes using an insulated furnace with a first chamber having a refractory lining, a second chamber disposed within the first chamber, a tube for flowing pressurized air into the second chamber, a conduit for flowing heated air from a burner operating on a fuel to the second chamber, for mixing with the pressurized air, and an air gun for mixing an abrading material into the pressurized air prior to introduction to the test specimen.

Abstract: A system for testing abrasion resistance of a test specimen made of refractory material, wherein the system includes an insulated furnace with a first chamber having a refractory lining, a second chamber disposed within the first chamber, a tube for flowing pressurized air into the second chamber, a conduit for flowing heated air from a burner operating on a fuel to the second chamber, for mixing with the pressurized air, and an air gun for mixing an abrading material into the pressurized air prior to introduction to the test specimen.

Abstract: A method for testing abrasion resistance of a test specimen made of refractory material, wherein the method includes using an insulated furnace with a first chamber having a refractory lining, a second chamber disposed within the first chamber, a tube for flowing pressurized air into the second chamber, a conduit for flowing heated air from a burner operating on a fuel to the second chamber, for mixing with the pressurized air, and an air gun for mixing an abrading material into the pressurized air prior to introduction to the test specimen.

Abstract: The present invention relates to a security mailbox. The mailbox includes an inner and an outer sleeve which are slidably engaged with one another. Each sleeve has an alternating pattern of an opaque portion and a transparent portion. When the transparent portions are aligned with one another, the user is able to view the contents of the mailbox. The mailbox additionally includes a remote control for activating the power source, which slides the inner sleeve underlying the outer sleeve. In combination with a latch mechanism, this remote control also enables the user to open the mailbox door from a considerable distance away.

Abstract: The present invention relates to a security mailbox. The mailbox includes an inner and an outer sleeve which are slidably engaged with one another. Each sleeve has an alternating pattern of an opaque portion and a transparent portion. When the transparent portions are aligned with one another, the user is able to view the contents of the mailbox. The mailbox additionally includes a remote control for activating the power source, which slides the inner sleeve underlying the outer sleeve. In combination with a latch mechanism, this remote control also enables the user to open the mailbox door from a considerable distance away.

Abstract: A method and apparatus is disclosed for implementing descending indexes in a database management system. A key value to be inserted within an index is decomposed into individual data bytes, such as an integer character value, that make up the key value and dictate the location where the key value will be inserted relative to other key values. A first function is applied to the data sequences in order to generate a reversed key value having reversed sorting properties. The reversed key values are then inserted into the index. The resulting index thus contains key values that are sorted in descending order. Additionally, indexes may be created on multiple key columns, with the sub_keys being independently sorted in either ascending or descending order. The present invention also discloses transformations that may be performed by a server in order to properly interpret statements that require the creation of standard or functional indexes in descending order.

Abstract: A method and apparatus is disclosed for implementing descending indexes in a database management system. A key value to be inserted within an index is decomposed into individual data bytes, such as an integer character value, that make up the key value and dictate the location where the key value will be inserted relative to other key values. A first function is applied to the data sequences in order to generate a reversed key value having reversed sorting properties. The reversed key values are then inserted into the index. The resulting index thus contains key values that are sorted in descending order. Additionally, indexes may be created on multiple key columns, with the sub_keys being independently sorted in either ascending or descending order. The present invention also discloses transformations that may be performed by a server in order to properly interpret statements that require the creation of standard or functional indexes in descending order.

Abstract: A method and system for recovering after failure of a first server to which a client was connected for accessing a resource is provided. When it is detected that a connection between the first server and the client has failed, the client is automatically connected with a second server that has access to the resource. After automatically connecting the client, the client accesses the resource through the second server. The client stores information about the state of the session with the first server so that processing can continue where it left off after the client connects with the second server. The client may be pre-connected to the second server prior to the failure of the first server to reduce the latency caused by switching in response to a failure. The second server may be configured to pre-parse the commands that the client issues to the first server to further reduce the latency associated with switching to the second server.

Abstract: The present invention provides a uniqueness-required index and a corresponding non-uniqueness count to support deferred uniqueness constraint enforcement. A uniqueness-required index stores duplicate occurrences of indexed data values that occur during statement or transaction processing. The non-uniqueness count associated with the uniqueness-required index provides a count of the number of indexed data values that occur more than once in the index. Where a non-uniqueness count is not equal to zero, a uniqueness constraint violation remains unresolved. Where an unresolved constraint violation exists at enforcement time, the effects of the processing are removed. A currently non-unique count can be used to represent the number of uniqueness-required indexes that are "currently non-unique". The currently non-unique count can be examined to determine whether there are any unresolved uniqueness constraint violations.

Abstract: The present invention provides a uniqueness-required index and a corresponding non-uniqueness count to support deferred uniqueness constraint enforcement. A uniqueness-required index stores duplicate occurrences of indexed data values that occur during statement or transaction processing. The non-uniqueness count associated with the uniqueness-required index provides a count of the number of indexed data values that occur more than once in the index. Where a non-uniqueness count is not equal to zero, a uniqueness constraint violation remains unresolved. Where an unresolved constraint violation exists at enforcement time, the effects of the processing are removed. A currently non-unique count can be used to represent the number of uniqueness-required indexes that are "currently non-unique". The currently non-unique count can be examined to determine whether there are any unresolved uniqueness constraint violations.

Abstract: A method and apparatus for executing queries on a set of data that has been partitioned into a plurality of partitions based on a partitioning key is provided. A query is received that includes a reference to a second key. The second key is not part of the partitioning key but has a predetermined correlation with the partitioning key. This second key is referred to as an overlapping partition key. A subset of the plurality of partitions is selected to be scanned based on the reference to the second key and the predetermined correlation with the partitioning key. The query is then executed by scanning only those partitions of the plurality of partitions that belong to the subset of partitions. The overlapping partition key provides for reduced query execution time even when the partitioning key is not directly involved in the query. Specifically, the overlapping partition key permits a partial table scan in situations that would require a fill table scan with partitioning alone.

Abstract: A method and apparatus are disclosed for enabling a constraint without prohibiting updates to the constrained data during the validation portion of the enablement process. A constraint is first enforced. While the constraint is being enforced, the pre-existing data are inspected to determine whether the constraint is valid. Because the constraint is in force for all changes to the data during the validation process, the constraint will be enabled if the pre-existing data conforms with the constraint. A serialization value is stored in the constraint definition. Whenever the constraint definition is changed, the serialization value is changed. The serialization value of a constraint definition is recorded before validating the constraint. After validating the constraint, the serialization value in the constraint definition is compared to the recorded serialization value to determine whether the constraint definition was changed during the validation process.