1. A method for integrating relational database operations through a hardware accelerator coupled with a host system running a relational database management system for a relational database, said method comprising:
receiving a relational query having one or more tasks related to at least one row of the relational database;
compiling the tasks into a program of database machine code operations specifying a stream of operations for the tasks;
executing the program of database machine code operations in a dataflow architecture query processing module implemented using said hardware accelerator, wherein the dataflow architecture query processing module includes at least one node configured to receive and process its input as data configured to arrive from at least one other node associated with the at least one node, and wherein said database machine code operations are executed within said hardware accelerator without software; and
providing a result for the tasks based on the program of database machine code operations.
2. The method of claim 1, wherein the program of database machine code operations are configured to convert rows of data into a column store format.
3. The method of claim 1, wherein the program of database machine code instructions are configured for compression of data from the relational database.
4. The method of claim 1, wherein the program of database machine code instructions are configured for decompression of data from the relational database.
5. The method of claim 1, wherein the program of database machine code instructions are configured for encryption of data from the relational database.
6. The method of claim 1, wherein the program of database machine code instructions are configured for a projection operation.
7. The method of claim 1, wherein the program of database machine code instructions are configured for a predicate filtering operation.
8. The method of claim 1, wherein the program of database machine code instructions are configured for a groupby aggregation.
9. The method of claim 1, wherein the program of database machine code instructions are configured for an orderby limit operation.
10. The method of claim 1, wherein the program of database machine code instructions are configured for a hash join operation.
11. The method of claim 1, wherein the program of database machine code instructions are configured for a sorted merge join operation.
12. The method of claim 1, wherein the program of database machine code instructions are configured for a merge sort operation.
13. A method for integrating relational database operations through a hardware accelerator coupled with a host system running a relational database management system for a relational database, said method comprising:
receiving a relational query having one or more tasks related to at least one row of the relational database;
compiling the tasks into a program of database machine code operations specifying a stream of operations for the tasks;
executing the program of database machine code operations in a dataflow architecture query processing module implemented using said hardware accelerator, wherein the program of database machine code operations are configured to convert rows of data into a column store format; and
providing a result for the tasks based on the program of database machine code operations.
14. The method of claim 13 wherein the program of database machine code instructions are configured for compression of data from the relational database.
15. A computing device that includes:
a hardware accelerator; and
one or more processors configured to:
integrate relational database operations through the hardware accelerator when coupled with a host system running a relational database management system for a relational database;
receive a relational query having one or more tasks related to at least one row of the relational database;
compile the tasks into a program of database machine code operations specifying a stream of operations for the tasks;
execute the program of database machine code operations in a dataflow architecture query processing module implemented using said hardware accelerator, wherein the dataflow architecture query processing module includes at least one node configured to receive and process its input as data configured to arrive from at least one other node associated with the at least one node, and wherein said database machine code operations are executed within said hardware accelerator without software; and
provide a result for the tasks based on the program of database machine code operations.
16. The computing device of claim 15, wherein the program of database machine code operations are configured to convert rows of data into a column store format.
17. The computing device of claim 15, wherein the program of database machine code instructions are configured for compression of data from the relational database.
18. The computing device of claim 15, wherein the program of database machine code instructions are configured for decompression of data from the relational database.
19. The computing device of claim 15, wherein the program of database machine code instructions are configured for encryption of data from the relational database.
20. The computing device of claim 15, wherein the program of database machine code instructions are configured for a projection operation.
21. The computing device of claim 15, wherein the program of database machine code instructions are configured for a predicate filtering operation.
22. The computing device of claim 15, wherein the program of database machine code instructions are configured for a groupby aggregation.
23. The computing device of claim 15, wherein the program of database machine code instructions are configured for an orderby limit operation.
24. The computing device of claim 15, wherein the program of database machine code instructions are configured for a hash join operation.
25. The computing device of claim 15, wherein the program of database machine code instructions are configured for a sorted merge join operation.
26. The computing device of claim 15, wherein the program of database machine code instructions are configured for a merge sort operation.
27. A non-transitory computer readable storage medium storing at least executable code for integrating relational database operations through a hardware accelerator coupled with a host system running a relational database management system for a relational database, wherein when executed the executable code causes:
receiving a relational query having one or more tasks related to at least one row of the relational database;
compiling the tasks into a program of database machine code operations specifying a stream of operations for the tasks;
executing the program of database machine code operations in a dataflow architecture query processing module implemented using said hardware accelerator, wherein the dataflow architecture query processing module includes at least one node configured to receive and process its input as data configured to arrive from at least one other node associated with the at least one node, and wherein said database machine code operations are executed within said hardware accelerator without software; and
providing a result for the tasks based on the program of database machine code operations.
28. The non-transitory computer readable storage medium of claim 27, wherein the program of database machine code operations are configured to convert rows of data into a column store format.
29. The non-transitory computer readable storage medium of claim 27, wherein the program of database machine code instructions are configured for compression of data from the relational database.
30. The non-transitory computer readable storage medium of claim 27, wherein the program of database machine code instructions are configured for decompression of data from the relational database.
31. The non-transitory computer readable storage medium of claim 27, wherein the program of database machine code instructions are configured for encryption of data from the relational database.
32. The non-transitory computer readable storage medium of claim 27, wherein the program of database machine code instructions are configured for a projection operation.
33. The non-transitory computer readable storage medium of claim 27, wherein the program of database machine code instructions are configured for a predicate filtering operation.
34. The non-transitory computer readable storage medium of claim 27, wherein the program of database machine code instructions are configured for a groupby aggregation.
35. The non-transitory computer readable storage medium of claim 27, wherein the program of database machine code instructions are configured for an orderby limit operation.
36. The non-transitory computer readable storage medium of claim 27, wherein the program of database machine code instructions are configured for a hash join operation.
37. The non-transitory computer readable storage medium of claim 27, wherein the program of database machine code instructions are configured for a sorted merge join operation.
38. The non-transitory computer readable storage medium of claim 27, wherein the program of database machine code instructions are configured for a merge sort operation.
The claims below are in addition to those above.
All refrences to claim(s) which appear below refer to the numbering after this setence.
1. A process for preparing the polyurethane derivative, the process comprising:
providing a polyurethane comprising a urethane amino moiety;
providing a multifunctional linker reagent of a formula:
LG-RL-(FG)n
wherein n is an integer from 1 to 3, FG is a functional group selected from the group consisting of a halogen, a carboxyl group, a sulfonate ester, and an epoxy group, LG is a leaving group selected from the group consisting of a halogen, a carboxyl group, a sulfonate ester, and an epoxy group, and RL is an (n+1)-valent organic radical comprising at least one carbon atom;
providing a protected thiol-containing reagent of a formula R\u2014C(O)SH, or a salt thereof, wherein R is a C1 to C6 alkyl group;
reacting the multifunctional linker reagent with the urethane amino moiety to form a polyurethane substituted with at least one substituent group of a formula
\u2014RL-(FG)n;
reacting the polyurethane substituted with at least one substituent group with a protected thiol-containing reagent to form the polyurethane comprising the thiol substituent pendant from a urethane nitrogen.
2. The process of claim 1, wherein RL is a bivalent organic radical selected from the group consisting of C1 to C18 alkylene, C1 to C18 alkyleneamino, C1 to C18 alkyleneoxy, C1 to C18 haloalkylene, C2 to C18 alkenylene, C6 to C18 arylene, a modified C2 to C18 alkenylene having at least one carbon substituted by a halogen group, C2 to C18 alkenylene having one or more O, S, or N atoms incorporated into an alkenylene chain, a bivalent heterocyclic radical, and mixtures thereof.
3. The process of claim 2, wherein RL is a member selected from the group consisting of C1 to C6 alkylene.
4. The process of claim 2, wherein RL is butylene, FG is a bromo group, LG is a bromo group and n is 1.
5. The process of claim 1, wherein LG is a bromo group.
6. The process of claim 1, wherein the sulfonate ester is a member selected from the group consisting of mesylate, triflate, and tosylate.
7. The process of claim 1, wherein the sulfonate ester is a member selected from the group consisting of a \u03c9-bromoalkyl mesylate, a \u03c9-bromoalkyl triflate, and a \u03c9bromoalkyl tosylate.
8. The process of claim 1, wherein the multifunctional linker reagent is a member selected from the group consisting of a dibromoalkyl compound, a bromo-carboxyalkyl compound, and a bromo-epoxyalkyl compound.
9. The process of claim 8, wherein the dibromoalkyl compound is a 1,\u03c9-dibromoalkyl compound or a substituted 1,\u03c9-dibromoalkyl compound.
10. The process of claim 9, wherein the dibromoalkyl compound is a C2-C61,\u03c9-dibromoalkyl compound.
11. The process of claim 9, wherein the dibromoalkyl compound is 1,6-dibromohexane or 1,4-dibromobutane.
12. The process of claim 8, wherein the bromo-carboxyalkyl compound is a \u03c9-bromocarboxylic acid or a substituted \u03c9-bromocarboxylic acid.
13. The process of claim 8, wherein the bromo-epoxyalkyl compound is epibromohydrin.
14. The process of claim 1, wherein the process is conducted in a presence of an aprotic solvent.
15. The process of claim 14, wherein the aprotic solvent is a member selected from the group consisting of N,N-dimethylacetamide, N,N-dimethyl formamide, 1-methyl-2-pyrrolidinone, tetrahydrofuran, dioxane, and dimethyl sulfoxide.
16. The process of claim 1, wherein the process is conducted in a presence of a base soluble in the aprotic solvent.
17. The process of claim 16, wherein the base is a member selected from the group consisting of sodium hydride, lithium diisopropylamide, and sodium.
18. The process of claim 16, wherein the base is potassium tert-butoxide, dimsyl sodium, lithium hydride, sodium amide, lithium N,N-dialkylamide, or lithium N,N-dicyclohexylamide.
19. The process of claim 16, wherein the base is lithium tert-butoxide.
20. The process of claim 18, wherein the multifunctional linker reagent is 1,6-dibromohexane, and the base is lithium diisopropylamide.
21. The process of claim 9, wherein the multifunctional linker reagent is 1,4-dibromobutane.
22. The process of claim 1, wherein the protected thiol-containing reagent is thiolacetic acid.
23. The process of claim 1, wherein the protected thiol-containing reagent is tetrabutylammonium thioacetate.
24. A process of preparing a polyurethane derivative, the process comprising:
providing a polyurethane;
providing a multi-functional linker, wherein the multi-functional linker has a leaving group and a functional group;
providing a protected thiol-containing reagent comprising a thiolic moiety;
contacting the polyurethane with the multi-functional linker in the presence of an aprotic solvent and a base such that the leaving group reacts with the polyurethane to form a polyurethane substituted with at least one substituent group; and
contacting the polyurethane substituted with at least one substituent group with a protected thiol-containing reagent such that the functional group reacts with the thiolic moiety to form the polyurethane derivative having a thiol substituent comprising a sulfur atom connected to the polyurethane derivative and a fragment connected to the sulfur atom, wherein the thiol substituent is pending from the polyurethane derivative, provided that when the fragment is remove, the sulfur atom remains pending from the polyurethane derivative.
25. The process of claim 24, wherein the leaving group is a bromo group and the functional group is a member selected from the group consisting of halogen, a sulfonate ester, a carboxyl group, and an epoxy group.
26. The process of claim 24, wherein the multi-functional linker is represented by the formula:
Br\u2014RL-(FG)n
wherein n is an integer from 1 to 3, FG is a functional group selected from the group consisting of a halogen, a carboxyl group, a sulfonate ester, and an epoxy group, and RL is an (n+1)-valent organic radical comprising at least one carbon atom.
27. The process of claim 24, wherein the thiol substituent by the formula:\u2014RL -(S\u2014R1)n
wherein n is an integer from 1 to 3, and R1 is at least one of C(O)R3 and SR4, wherein R3 is a C1 to C6 alkyl group and R4 is a heterocyclic group or an electron deficient aromatic group.