Abstract: Functionalities of new data types are enabled for data stored using native data types (“recognized data types”) supported by DBMSs. Values having a latent data type may be stored using a recognized data type of a DBMS. That is, a value stored in a database table may be recognized by a DBMS as having a recognized data type (e.g., character string) but the value may also include information that indicates the value conforms to a particular latent data type. DBMSs compile database statements. The database statement can contain multiple expressions that may specify a latent data type or that may have a recognized data type but that also imply latent data types. By determining that various expressions have latent data types, operations that rely on the expressions as having a latent data type may be validated in a query and executed accordingly.

Abstract: Herein are fine grained updates to pieces of JavaScript object notation (JSON) documents by database statements that can update, delete, and insert parts of JSON documents. In an embodiment, a computer receives a request that specifies a modification of a JSON document that is stored in a compressed format in persistent storage. The modification adds additional content to the JSON document, and/or replaces an old value in the JSON document with a new value that is not a same size as the old value. The modification is recorded in a change log. The change log is eventually applied to the compressed format of the JSON document in the persistent storage without entirely rewriting the compressed format of the JSON document in the persistent storage.

Abstract: Herein are fine grained updates to pieces of JavaScript object notation (JSON) documents by database statements that can update, delete, and insert parts of JSON documents. In an embodiment, a computer receives a request that specifies a modification of a JSON document that is stored in a compressed format in persistent storage. The modification adds additional content to the JSON document, and/or replaces an old value in the JSON document with a new value that is not a same size as the old value. The modification is recorded in a change log. The change log is eventually applied to the compressed format of the JSON document in the persistent storage without entirely rewriting the compressed format of the JSON document in the persistent storage.

Abstract: A method of operating an aircraft engine coupled to a wing of an aircraft including: setting a pitch of a plurality of rotor blades of a rotor assembly of the aircraft engine at non-uniform pitch angles along a circumferential direction of the aircraft engine such that the plurality of rotor blades define a first pitch at a first position and a second pitch at a second position, wherein the second position is 180 degrees offset from the first position, and wherein the first pitch is different from the second pitch.

Abstract: An aircraft equipped with a distributed fan propulsion system and methods of operating such aircraft are provided. In one aspect, an aircraft includes a wing having a top surface and a bottom surface. The aircraft also has a distributed propulsion system that includes a suction fan array having one or more fans mounted to the wing and a pressure fan array having one or more fans mounted to the wing. The fans of the suction fan array are each positioned primarily above the top surface of the wing and the fans of the pressure fan array are each positioned primarily below the bottom surface of the wing. The fans of the suction fan array are controllable independent of the fans of the pressure fan array so that the air pressure above and/or below the wing can be locally controlled, allowing for adjustment of lift on the wing.

Abstract: An aircraft equipped with a distributed unducted fan propulsion system is provided. In one aspect, an aircraft includes a body defining a lateral centerline that separates the body into a first side and a second side. One or more first unducted fans are mounted to the first side of the body. The one or more first unducted fans are rotatable in a first direction. One or more second unducted fans are mounted to the second side of the body. The one or more second unducted fans are rotatable in a second direction that is opposite the first direction.

Abstract: Provided is an improved filtration module assembly comprising a vessel having a filtration cartridge disposed within it and a header coupled to an end of the vessel, the header including a housing having an open-ended upper end and a lower end, and an end cap including a portion that mates with a complimentary structure defined by the inner all of the open ended upper end of the housing to removable engage with the housing and the end cap may further define a passageway for fluid to flow out of the vessel. The filtration module assembly may enable an improved manifold arrangement used to communicate fluids to and from a filtration system comprising a plurality of such modules and the configurations of the present invention may facilitate improved operation of such filtration systems.

Abstract: The present invention relates to a method of activating an organic coating to enhance adhesion of the coating to a further coating and/or to other entities comprising applying a solvent and a surface chemistry and/or surface topography modifying agent to the organic coating. The invention also relates to a coated substrate having an activated coating, wherein the adhesion of the coating to a further coating and/or other entities has been enhanced by application of a solvent and a surface chemistry and/or surface topography modifying agent to the coating. The invention further relates to an activation treatment for an organic coating to enhance adhesion of the coating to a further coating and/or to other entities comprising a solvent and a surface chemistry and/or surface topography modifying agent and a method for the preparation of the activation treatment.

Abstract: Herein are fine grained updates to pieces of JavaScript object notation (JSON) documents by database statements that can update, delete, and insert parts of JSON documents. In an embodiment, a computer receives a request that specifies a modification of a JSON document that is stored in a compressed format in persistent storage. The modification adds additional content to the JSON document, and/or replaces an old value in the JSON document with a new value that is not a same size as the old value. The modification is recorded in a change log. The change log is eventually applied to the compressed format of the JSON document in the persistent storage without entirely rewriting the compressed format of the JSON document in the persistent storage.

Abstract: The present invention relates to a method of activating an organic coating to enhance adhesion of the coating to a further coating and/or to other entities comprising applying a solvent and a surface chemistry and/or surface topography modifying agent to the organic coating. The invention also relates to a coated substrate having an activated coating, wherein the adhesion of the coating to a further coating and/or other entities has been enhanced by application of a solvent and a surface chemistry and/or surface topography modifying agent to the coating. The invention further relates to an activation treatment for an organic coating to enhance adhesion of the coating to a further coating and/or to other entities comprising a solvent and a surface chemistry and/or surface topography modifying agent and a method for the preparation of the activation treatment.

Abstract: Described is a system, method, and computer program product to perform bi-directional mapping of hierarchical data (e.g. JSON, XML) to database object types (e.g., user defined database object types).

Abstract: A joint for coupling a wing tip to a wing base includes a linking member that extends from a first end to a second end. The linking member first end is coupleable to the wing base, and the linking member second end is coupleable to the wing tip. The linking member defines first second hinge lines that are substantially parallel. The joint also includes at least one actuator. A first end of each at least one actuator is coupled to the linking member, and a second end of each at least one actuator is coupleable to one of the wing base and the wing tip. The at least one actuator is operable to rotate the wing tip about the first and second hinge lines between a first orientation and a second orientation relative to the wing base.

Abstract: Functionalities of new data types are enabled for data stored using native data types (“recognized data types”) supported by DBMSs. Values having a latent data type may be stored using a recognized data type of a DBMS. That is, a value stored in a database table may be recognized by a DBMS as having a recognized data type (e.g., character string) but the value may also include information that indicates the value conforms to a particular latent data type. DBMSs compile database statements. The database statement can contain multiple expressions that may specify a latent data type or that may have a recognized data type but that also imply latent data types. By determining that various expressions have latent data types, operations that rely on the expressions as having a latent data type may be validated in a query and executed accordingly.

Abstract: Techniques are described herein for using user-defined aggregate functions for updating inverted index tables. A user-defined aggregate function is registered in a database system for updating an index table based on changes stored in a staging table. A query specifying the user-defined aggregate function may be executed in parallel to parallelize the updating of the index table.

Abstract: Provided is an improved filtration module assembly comprising a vessel having a filtration cartridge disposed within it and a header coupled to an end of the vessel, the header including a housing having an open-ended upper end and a lower end, and an end cap including a portion that mates with a complimentary structure defined by the inner all of the open ended upper end of the housing to removable engage with the housing and the end cap may further define a passageway for fluid to flow out of the vessel. The filtration module assembly may enable an improved manifold arrangement used to communicate fluids to and from a filtration system comprising a plurality of such modules and the configurations of the present invention may facilitate improved operation of such filtration systems.

Abstract: Functionalities of new data types are enabled for data stored using native data types (“recognized data types”) supported by DBMSs. Values having a latent data type may be stored using a recognized data type of a DBMS. That is, a value stored in a database table may be recognized by a DBMS as having a recognized data type (e.g., character string) but the value may also include information that indicates the value conforms to a particular latent data type. DBMSs compile database statements. The database statement can contain multiple expressions that may specify a latent data type or that may have a recognized data type but that also imply latent data types. By determining that various expressions have latent data types, operations that rely on the expressions as having a latent data type may be validated in a query and executed accordingly.

Abstract: The present disclosure generally relates to semiconductor structures and, more particularly, to via and skip via structures and methods of manufacture. The method includes: forming a first metallization layer with a first capping layer over the first metallization layer; forming a second metallization layer with a second capping layer over the second metallization layer; forming a partial skip via structure to the first metallization layer by removing a portion of the first capping layer and the second capping and depositing conductive material in an opening formed in the second metallization layer; forming a third capping layer over the filled partial skip via and the second capping layer; and forming a remaining portion of a skip via structure in alignment with the partial skip via structure by opening the third capping layer to expose the conductive material of the partial skip via.

Abstract: Provided is an improved filtration module assembly comprising a vessel having a filtration cartridge disposed within it and a header coupled to an end of the vessel, the header including a housing having an open-ended upper end and a lower end, and an end cap including a portion that mates with a complimentary structure defined by the inner all of the open ended upper end of the housing to removable engage with the housing and the end cap may further define a passageway for fluid to flow out of the vessel. The filtration module assembly may enable an improved manifold arrangement used to communicate fluids to and from a filtration system comprising a plurality of such modules and the configurations of the present invention may facilitate improved operation of such filtration systems.

Abstract: The present disclosure generally relates to semiconductor structures and, more particularly, to dielectric repair for via and skip via structures and methods of manufacture. The method includes: etching a via structure in a dielectric layer; repairing sidewalls of the via structure with a repair agent; and extending the via structure with an additional etching into a lower dielectric layer to form a skip via structure exposing a metallization layer.