Patents by Inventor Jiansheng Huang
Jiansheng Huang has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Patent number: 11836132Abstract: A method, system, and apparatus for managing a persistent query result set are disclosed. A resource manager is disclosed that receives a query from a client over a computer network. A computer database server is disclosed that executes the query and generates a result set based on and in response to the received query. An execution platform is disclosed that divides the result set into a plurality of chunks, wherein each chunk comprises a portion of the generated result set. The resource manager adds metadata to each of the plurality of chunks. A first chunk of the plurality of chunks comprises metadata pointing to the plurality of chunks. The resource manager delivers at least the first chunk of the plurality of chunks to the client in response to the query. The execution platform offloads the remaining plurality of chunks to cloud storage in parallel.Type: GrantFiled: April 17, 2020Date of Patent: December 5, 2023Assignee: Snowflake Inc.Inventors: Benoit Dageville, Jiansheng Huang, Shige Takeda, Abdul Q. Munir
-
Publication number: 20220179846Abstract: Systems, methods, and devices for batch ingestion of data into a table of a database. A method includes determining a notification indicating a presence of a user file received from a client account to be ingested into a database. The method includes identifying data in the user file and identifying a target table of the database to receive the data in the user file. The method includes generating an ingest task indicating the data and the target table. The method includes assigning the ingest task to an execution node of an execution platform, wherein the execution platform comprises a plurality of execution nodes operating independent of a plurality of shared storage devices collectively storing database data. The method includes registering metadata concerning the target table in a metadata store after the data has been fully committed to the target table by the execution node.Type: ApplicationFiled: February 25, 2022Publication date: June 9, 2022Inventors: Jiansheng Huang, Jiaxing Liang, Scott Ziegler, Haowei Yu, Benoit Dageville, Varun Ganesh
-
Patent number: 11294890Abstract: Systems, methods, and devices for batch ingestion of data into a table of a database. A method includes determining a notification indicating a presence of a user file received from a client account to be ingested into a database. The method includes identifying data in the user file and identifying a target table of the database to receive the data in the user file. The method includes generating an ingest task indicating the data and the target table. The method includes assigning the ingest task to an execution node of an execution platform, wherein the execution platform comprises a plurality of execution nodes operating independent of a plurality of shared storage devices collectively storing database data. The method includes registering metadata concerning the target table in a metadata store after the data has been fully committed to the target table by the execution node.Type: GrantFiled: March 26, 2019Date of Patent: April 5, 2022Assignee: Snowflake Inc.Inventors: Jiansheng Huang, Jiaxing Liang, Scott Ziegler, Haowei Yu, Benoit Dageville, Varun Ganesh
-
Publication number: 20220089526Abstract: A synthesis method for a candesartan cilexetil intermediate represented by formula (II) is provided. The method includes (1) dissolving a compound represented by formula (IV) to an aprotic solvent to obtain a first mixed solution, and dissolving a phase transfer catalyst and an azidation reagent to water to obtain a second mixed solution; (2) dropping the first mixed solution to the second mixed solution for azidation reaction, and after the reaction is ended, standing and layering same to obtain an organic phase containing a compound represented by formula (V); (3) dropping the obtained organic phase containing the compound represented by formula (V) to tertiary butyl alcohol for rearrangement reaction, and after the reaction is ended, concentrating same to obtain a solid or oily material, then adding a crystallizing solvent to the obtained solid or oily material for recrystallization, and separating same to obtain a crystal.Type: ApplicationFiled: January 2, 2019Publication date: March 24, 2022Inventors: Guoliang Tu, Jiansheng Huang, Lu Zhang, Tao Yang, Zunjun Liang
-
Patent number: 11055280Abstract: Systems, methods, and devices for batch ingestion of data into a table of a database. A method includes determining a notification indicating a presence of a user file received from a client account to be ingested into a database. The method includes identifying data in the user file and identifying a target table of the database to receive the data in the user file. The method includes generating an ingest task indicating the data and the target table. The method includes assigning the ingest task to an execution node of an execution platform, wherein the execution platform comprises a plurality of execution nodes operating independent of a plurality of shared storage devices collectively storing database data. The method includes registering metadata concerning the target table in a metadata store after the data has been fully committed to the target table by the execution node.Type: GrantFiled: November 27, 2018Date of Patent: July 6, 2021Assignee: Snowflake Inc.Inventors: Jiansheng Huang, Jiaxing Liang, Scott Ziegler, Haowei Yu, Benoit Dageville, Varun Ganesh
-
Patent number: 10997163Abstract: The subject technology at a data system, an ingest request to ingest one or more files into a table. The subject technology, after obtaining the ingest request and prior to the ingesting of the one or more files, persists the one or more files in a first file queue that corresponds to the table, the first file queue further corresponding to a client account, and the data system further comprising a second file queue that corresponds to both a second client account and a second table. The subject technology ingests, by one or more execution nodes, the one or more files into one or more micro-partitions of the table, each of the one or more micro-partitions comprising contiguous units of storage of a storage device.Type: GrantFiled: July 30, 2020Date of Patent: May 4, 2021Assignee: Snowflake Inc.Inventors: Benoit Dageville, Varun Ganesh, Jiansheng Huang, Jiaxing Liang, Haowei Yu, Scott Ziegler
-
Patent number: 10977245Abstract: The subject technology obtains, at a database system, an ingest request to ingest one or more files into a table of a database. The subject technology, after obtaining the ingest request and prior to the ingesting of the one or more files, persists the one or more files in a file queue that corresponds to the table. The subject technology assigns the one or more files to one or more execution nodes to be ingested into the table. The subject technology operates an ingest puller to poll the file queue. The subject technology ingests, by the one or more execution nodes, the one or more files into one or more micro-partitions of the table via one or more pipes.Type: GrantFiled: July 29, 2020Date of Patent: April 13, 2021Assignee: Snowflake Inc.Inventors: Benoit Dageville, Varun Ganesh, Jiansheng Huang, Jiaxing Liang, Haowei Yu, Scott Ziegler
-
Patent number: 10896172Abstract: Systems, methods, and devices for batch ingestion of data into a table of a database. A method includes determining a notification indicating a presence of a user file received from a client account to be ingested into a database. The method includes identifying data in the user file and identifying a target table of the database to receive the data in the user file. The method includes generating an ingest task indicating the data and the target table. The method includes assigning the ingest task to an execution node of an execution platform, wherein the execution platform comprises a plurality of execution nodes operating independent of a plurality of shared storage devices collectively storing database data. The method includes registering metadata concerning the target table in a metadata store after the data has been fully committed to the target table by the execution node.Type: GrantFiled: December 19, 2019Date of Patent: January 19, 2021Assignee: Snowflake Inc.Inventors: Benoit Dageville, Varun Ganesh, Jiansheng Huang, Jiaxing Liang, Haowei Yu, Scott Ziegler
-
Publication number: 20200356551Abstract: The subject technology obtains, at a database system, an ingest request to ingest one or more files into a table of a database. The subject technology, after obtaining the ingest request and prior to the ingesting of the one or more files, persists the one or more files in a file queue that corresponds to the table. The subject technology assigns the one or more files to one or more execution nodes to be ingested into the table. The subject technology operates an ingest puller to poll the file queue. The subject technology ingests, by the one or more execution nodes, the one or more files into one or more micro-partitions of the table via one or more pipes.Type: ApplicationFiled: July 29, 2020Publication date: November 12, 2020Inventors: Benoit Dageville, Varun Ganesh, Jiansheng Huang, Jiaxing Liang, Haowei Yu, Scott Ziegler
-
Publication number: 20200356552Abstract: The subject technology at a data system, an ingest request to ingest one or more files into a table. The subject technology, after obtaining the ingest request and prior to the ingesting of the one or more files, persists the one or more files in a first file queue that corresponds to the table, the first file queue further corresponding to a client account, and the data system further comprising a second file queue that corresponds to both a second client account and a second table. The subject technology ingests, by one or more execution nodes, the one or more files into one or more micro-partitions of the table, each of the one or more micro-partitions comprising contiguous units of storage of a storage device.Type: ApplicationFiled: July 30, 2020Publication date: November 12, 2020Inventors: Benoit Dageville, Varun Ganesh, Jiansheng Huang, Jiaxing Liang, Haowei Yu, Scott Ziegler
-
Publication number: 20200242118Abstract: A method, system, and apparatus for managing a persistent query result set are disclosed. A resource manager is disclosed that receives a query from a client over a computer network. A computer database server is disclosed that executes the query and generates a result set based on and in response to the received query. An execution platform is disclosed that divides the result set into a plurality of chunks, wherein each chunk comprises a portion of the generated result set. The resource manager adds metadata to each of the plurality of chunks. A first chunk of the plurality of chunks comprises metadata pointing to the plurality of chunks. The resource manager delivers at least the first chunk of the plurality of chunks to the client in response to the query. The execution platform offloads the remaining plurality of chunks to cloud storage in parallel.Type: ApplicationFiled: April 17, 2020Publication date: July 30, 2020Inventors: Benoit Dageville, Jiansheng Huang, Shige Takeda, Abdul Q. Munir
-
Patent number: 10671605Abstract: A method, system, and apparatus for managing a persistent query result set are disclosed. A resource manager is disclosed that receives a query from a client over a computer network. A computer database server is disclosed that executes the query and generates a result set based on and in response to the received query. An execution platform is disclosed that divides the result set into a plurality of chunks, wherein each chunk comprises a portion of the generated result set. The resource manager adds metadata to each of the plurality of chunks. A first chunk of the plurality of chunks comprises metadata pointing to the plurality of chunks. The resource manager delivers at least the first chunk of the plurality of chunks to the client in response to the query. The execution platform offloads the remaining plurality of chunks to cloud storage in parallel.Type: GrantFiled: April 12, 2016Date of Patent: June 2, 2020Assignee: Snowflake Inc.Inventors: Benoit Dageville, Jiansheng Huang, Shige Takeda, Abdul Q. Munir
-
Publication number: 20200125558Abstract: Systems, methods, and devices for batch ingestion of data into a table of a database. A method includes determining a notification indicating a presence of a user file received from a client account to be ingested into a database. The method includes identifying data in the user file and identifying a target table of the database to receive the data in the user file. The method includes generating an ingest task indicating the data and the target table. The method includes assigning the ingest task to an execution node of an execution platform, wherein the execution platform comprises a plurality of execution nodes operating independent of a plurality of shared storage devices collectively storing database data. The method includes registering metadata concerning the target table in a metadata store after the data has been fully committed to the target table by the execution node.Type: ApplicationFiled: December 19, 2019Publication date: April 23, 2020Inventors: Benoit Dageville, Varun Ganesh, Jiansheng Huang, Jiaxing Liang, Haowei Yu, Scott Ziegler
-
Publication number: 20190220459Abstract: Systems, methods, and devices for batch ingestion of data into a table of a database. A method includes determining a notification indicating a presence of a user file received from a client account to be ingested into a database. The method includes identifying data in the user file and identifying a target table of the database to receive the data in the user file. The method includes generating an ingest task indicating the data and the target table. The method includes assigning the ingest task to an execution node of an execution platform, wherein the execution platform comprises a plurality of execution nodes operating independent of a plurality of shared storage devices collectively storing database data. The method includes registering metadata concerning the target table in a metadata store after the data has been fully committed to the target table by the execution node.Type: ApplicationFiled: March 26, 2019Publication date: July 18, 2019Inventors: Jiansheng Huang, Jiaxing Liang, Scott Ziegler, Haowei Yu, Benoit Dageville, Varun Ganesh
-
Publication number: 20190163754Abstract: Systems, methods, and devices for batch ingestion of data into a table of a database. A method includes determining a notification indicating a presence of a user file received from a client account to be ingested into a database. The method includes identifying data in the user file and identifying a target table of the database to receive the data in the user file. The method includes generating an ingest task indicating the data and the target table. The method includes assigning the ingest task to an execution node of an execution platform, wherein the execution platform comprises a plurality of execution nodes operating independent of a plurality of shared storage devices collectively storing database data. The method includes registering metadata concerning the target table in a metadata store after the data has been fully committed to the target table by the execution node.Type: ApplicationFiled: November 27, 2018Publication date: May 30, 2019Inventors: Jiansheng Huang, Jiaxing Liang, Scott Ziegler, Haowei Yu, Benoit Dageville, Varun Ganesh
-
Patent number: 9965566Abstract: A system may include a network interface and a batch processor coupled to the network interface. The batch processor may be configured to obtain social network profiles corresponding to entities and to obtain a target criterion. The batch processor may be configured to identify at least some of the entities based on a relationship between the social network profiles and the target criterion and to transmit, via the network interface, a data file to a computing device of the at least some of the entities, wherein the data file contains information related, at least in part, to the target criterion.Type: GrantFiled: October 31, 2012Date of Patent: May 8, 2018Assignee: Microsoft Technology Licensing, LLCInventors: Jiansheng Huang, Sanjay Sureshchandra Dubey, Anmol Bhasin
-
Publication number: 20180057530Abstract: The present invention relates to a compound represented by formula (I). The present invention also relates to the use of a compound represented by formula (I) in the treatment of disorders resulting from cell proliferation and/or angiogenesis or disorders associated with or accompanying cell proliferation and/or angiogenesis.Type: ApplicationFiled: April 1, 2016Publication date: March 1, 2018Applicant: Zhejiang Hisun Pharmaceutical Co., Ltd.Inventors: Hua Bai, Niefang Yu, Jidong Wang, Xiaohe Zheng, Lifei Liu, Jiansheng Huang
-
Publication number: 20170293626Abstract: A method, system, and apparatus for managing a persistent query result set are disclosed. A resource manager is disclosed that receives a query from a client over a computer network. A computer database server is disclosed that executes the query and generates a result set based on and in response to the received query. An execution platform is disclosed that divides the result set into a plurality of chunks, wherein each chunk comprises a portion of the generated result set. The resource manager adds metadata to each of the plurality of chunks. A first chunk of the plurality of chunks comprises metadata pointing to the plurality of chunks. The resource manager delivers at least the first chunk of the plurality of chunks to the client in response to the query. The execution platform offloads the remaining plurality of chunks to cloud storage in parallel.Type: ApplicationFiled: April 12, 2016Publication date: October 12, 2017Inventors: Benoit Dageville, Jiansheng Huang, Shige Takeda, Abdul Q. Munir
-
Publication number: 20140122571Abstract: A system may include a network interface and a batch processor coupled to the network interface. The batch processor may be configured to obtain social network profiles corresponding to entities and to obtain a target criterion. The batch processor may be configured to identify at least some of the entities based on a relationship between the social network profiles and the target criterion and to transmit, via the network interface, a data file to a computing device of the at least some of the entities, wherein the data file contains information related, at least in part, to the target criterion.Type: ApplicationFiled: October 31, 2012Publication date: May 1, 2014Applicant: Linkedln CorporationInventors: Jiansheng Huang, Sanjay Sureshchandra Dubey, Anmol Bhasin
-
Patent number: 8655911Abstract: Techniques are provided for (1) extending SQL to support direct invocation of frequent itemset operations, (2) improving the performance of frequent itemset operations by clustering itemset combinations to more efficiently use previously produced results, and (3) making on-the-fly selection of the occurrence counting technique to use during each phase of a multiple phase frequent itemset operation. When directly invoked in an SQL statement, a frequent itemset operation may receive input from results of operations specified in the SQL statement, and provide its results directly to other operations specified in the SQL statement. By clustering itemset combinations, resources may be used more efficiently by retaining intermediate information as long as it is useful, and then discarding it to free up volatile memory.Type: GrantFiled: August 18, 2003Date of Patent: February 18, 2014Assignee: Oracle International CorporationInventors: Wei Li, Jiansheng Huang, Ari Mozes