Abstract: Medical devices and methods for making and using medical devices are disclosed. An example medical device may include a guide extension catheter. The guide extension catheter may include a proximal member having a proximal end, a distal end, and a proximal diameter. The guide extension catheter may additionally include a collar member attached to an extension portion of the proximal member, where the extension portion may be located at the distal end of the proximal member. The extension portion may allow a delivery device to be inserted through the guide extension catheter to extend along a surface of the extension portion and align with a lumen of a distal sheath of the guide extension catheter.

Abstract: Disclosed herein are methods and compositions for manufacturing nanoparticle bacteriophage-based vaccines that are useful for anti-cancer treatments. Also disclosed herein are methods of using bacteriophage-based vaccines expressing aspartyl (asparaginyl) ?-hydroxylase for treating cancer.

Abstract: Medical devices and methods for making and using medical devices are disclosed. An example medical device may include a guide extension catheter. The guide extension catheter may include a proximal member having a proximal end, a distal end, and a proximal diameter. The guide extension catheter may additionally include a collar member attached to an extension portion of the proximal member, where the extension portion may be located at the distal end of the proximal member. The extension portion may allow a delivery device to be inserted through the guide extension catheter to extend along a surface of the extension portion and align with a lumen of a distal sheath of the guide extension catheter.

Abstract: A guide extension catheter may include a proximal shaft and a tubular distal sheath including an exchange channel allowing for access (e.g. side access) into the lumen. Guide extension catheters may be used in conjunction with a guide catheter and a medical device having a distal region disposed within the guide catheter and a proximal region disposed outside of the guide catheter. A portion of the proximal region of the medical device can be passed through the exchange channel and into the lumen, and the guide extension catheter can be advanced into the guide catheter over the medical device without removing the medical device from the guide catheter. The exchange channel can extend in a straight line path along the sheath, or may extend in an indirect path along the sheath.

Abstract: A method for query processing includes receiving a query, and determining a query type by determining if the query is a structured query language (SQL) query including multiple distinct aggregates (MDAs), or a SQL query including cube, rollup or grouping sets operations. Based on the determination, the method includes processing the query to generate an output, and performing a predetermined number of maximum group by operations on the output based on the query type to generate a response to the query.

Abstract: Medical devices, medical device systems, and methods for using the same are disclosed. An example medical device system may include a guide catheter having a proximal end, a distal end, and a lumen extending therebetween. The guide catheter may be designed to guide a therapeutic catheter to a target site. A guidewire may be disposed within the lumen of the guide catheter. The system may also include a trap balloon catheter including a catheter shaft and a balloon coupled to the catheter shaft. The trap balloon catheter may be designed to extend through the lumen of the guide catheter to a position adjacent to the distal end of the guide catheter. A trap balloon retainer may be coupled to the catheter shaft. The trap balloon retainer may be designed to prevent a distal end of the trap balloon catheter from extending distally beyond the distal end of the guide catheter.

Abstract: Medical devices, medical device systems, and methods for using the same are disclosed. An example medical device system may include a guide catheter having a proximal end, a distal end, and a lumen extending therebetween. The guide catheter may be designed to guide a therapeutic catheter to a target site. A guidewire may be disposed within the lumen of the guide catheter. The system may also include a trap balloon catheter including a catheter shaft and a balloon coupled to the catheter shaft. The trap balloon catheter may be designed to extend through the lumen of the guide catheter to a position adjacent to the distal end of the guide catheter. A trap balloon retainer may be coupled to the catheter shaft. The trap balloon retainer may be designed to prevent a distal end of the trap balloon catheter from extending distally beyond the distal end of the guide catheter.

Abstract: In an example, data from a source location is merged into a target location containing existing data, in which the source location and the target location contain tuples of data. For each tuple in the source location, during a single operation, a determination is made as to whether there is a matched tuple in the target location that satisfies a predetermined condition. For each matched tuple that satisfies the predetermined condition, the matched tuple in the target location is updated with a count value that is equal to a count of the matched tuple in the source location and the target location. In addition, for each tuple that does not have a matched tuple that satisfies the predetermined condition, the unmatched tuple is inserted into the target location.

Abstract: Medical devices and methods for making and using medical devices are disclosed. An example medical device may include a guide extension catheter. The guide extension catheter may include a proximal member having a proximal end, a distal end, and a proximal diameter. The guide extension catheter may additionally include a collar member attached to an extension portion of the proximal member, where the extension portion may be located at the distal end of the proximal member. The extension portion may allow a delivery device to be inserted through the guide extension catheter to extend along a surface of the extension portion and align with a lumen of a distal sheath of the guide extension catheter.

Abstract: A query that is submitted to a database is analyzed so as to determine a join order restriction. The join order restriction is associated with a join between two tables of a plurality of tables of the database that participate in the query. The join order restriction constrains its associated join to be executed prior to another join of the query. At least one join plan is generated, the join plan being constrained by the join order restriction. Different join plans include different join orders. A join plan is selected from among the join plans for execution of the query.

Abstract: In an example, data from a source location is merged into a target location containing existing data, in which both the source location and the target location contain tuples of data. For each tuple in the source location, during a single operation, a determination is made as to whether there is a matched tuple in the target location that satisfies a predetermined condition. For each matched tuple that satisfies the predetermined condition, the matched tuple in the target location is updated with a count value that is equal to a count of the matched tuple in the source location and the target location. In addition, for each tuple that does not have a matched tuple that satisfies the predetermined condition, the unmatched tuple is inserted into the target location.

Abstract: Medical devices and methods for making and using medical devices are disclosed. An example medical device may include a guide extension catheter. The guide extension catheter may include a proximal shaft having a first outer diameter. A distal sheath may be attached to the proximal shaft and may have a second outer diameter greater than the first outer diameter. The distal sheath may be designed to extend past a coronary ostium and into a coronary artery so that another medical device can pass therethrough toward the coronary artery. An expandable balloon may be coupled to the distal sheath.

Abstract: Medical devices and methods for making and using medical devices are disclosed. An example medical device may include a guide extension catheter. The guide extension catheter may include a proximal member having a proximal end, a distal end, and a proximal diameter. The guide extension catheter may additionally include a collar member attached to the distal end of the proximal member, the collar member comprising a base portion and one or more ribs connected to the base portion and extending distally away from the base portion. In still some additional embodiments, the guide extension catheter may further include a distal sheath member attached to the collar member, the distal sheath member having a distal diameter larger than the proximal diameter.

Abstract: Medical devices, medical device systems, and methods for using the same are disclosed. An example medical device system may include a guide catheter having a proximal end, a distal end, and a lumen extending therebetween. The guide catheter may be designed to guide a therapeutic catheter to a target site. A guidewire may be disposed within the lumen of the guide catheter. The system may also include a trap balloon catheter including a catheter shaft and a balloon coupled to the catheter shaft. The trap balloon catheter may be designed to extend through the lumen of the guide catheter to a position adjacent to the distal end of the guide catheter. A trap balloon retainer may be coupled to the catheter shaft. The trap balloon retainer may be designed to prevent a distal end of the trap balloon catheter from extending distally beyond the distal end of the guide catheter.

Abstract: In some examples, formatting semi-structured data in a database includes obtaining semi-structured data in a column store database, assigning the semi-structured data to a semi-structured column with a key and value format, and formatting the semi-structured data with an optimal search format.

Abstract: According to an example, a method for executing a query having multiple set operators includes adding an additional column that associates an identifier of the result table with data contained in the input result table in each input result table of an input query. The method also includes performing a Union All operation on the data contained in the input result tables to generate an intermediate result set, performing a Group By operation on the data contained in the intermediate result set to generate a grouped result set, wherein the Group By operation operates on various groups of rows and returns one row per each of the various groups, adding aggregation columns in the grouped result set containing counts of a number of times that each tuple exists in each of the input result tables, and applying a predicate on the grouped result set to execute the query.

Abstract: A record-pattern expression of a record pattern of data records is translated to a character-pattern expression of a character pattern. A data-record series of data records is converted to a character string in which each character in the character string corresponds to a respective data record in the data-record series. Pattern instances of the character pattern in the character string are searched to identify ordinal character positions in the character string of characters in the character pattern instances. Data records at ordinal record positions in the record series of data records corresponding to the ordinal character positions are reported.

Abstract: A system is described including a diverter valve operable to divert at least a portion of water flowing through a first water line to a first volume; a first float valve controlling water flow from a second water line to a second volume; and a second float valve controlling water flow from the first volume to the second volume.

Abstract: A method for query processing includes receiving a query, and determining a query type by determining if the query is a structured query language (SQL) query including multiple distinct aggregates (MDAs), or a SQL query including cube, rollup or grouping sets operations. Based on the determination, the method includes processing the query to generate an output, and performing a predetermined number of maximum group by operations on the output based on the query type to generate a response to the query.

Abstract: In an example, data from a source location is merged into a target location containing existing data, in which both the source location and the target location contain tuples of data. For each tuple in the source location, during a single operation, a determination is made as to whether there is a matched tuple in the target location that satisfies a predetermined condition. For each matched tuple that satisfies the predetermined condition, the matched tuple in the target location is updated with a count value that is equal to a count of the matched tuple in the source location and the target location. In addition, for each tuple that does not have a matched tuple that satisfies the predetermined condition, the unmatched tuple is inserted into the target location.