Patents by Inventor John Wan

John Wan 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: 11966409
    Abstract: Systems and methods for implementing extensible attributes in ETL are disclosed. In some examples, attributes configured at a source file may be extracted from the source file. The extracted attributes can be mapped to a target column of a data warehouse table, and then a dynamic ETL script may be generated. The dynamic script may be executed to move data associated with the attributes to an appropriate new column of the data warehouse.
    Type: Grant
    Filed: April 14, 2020
    Date of Patent: April 23, 2024
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: Dylan Wan, Francoise J. Lawrence, Justin Hyde, Amit Goyal, Saurabh Verma, John D. Poole
  • Patent number: 11934922
    Abstract: A computer system, product, and method are provided. The computer system includes an artificial intelligence (AI) platform operatively coupled to a processor. The AI platform includes tools in the form of a machine learning model (MLM) manager, a metric manager, and a training manager. The MLM manager accesses a plurality of pre-trained source MLMs, and inputs a plurality of data objects of a test dataset into each of the source MLMs. The test dataset includes the plurality of data objects associated with respective labels. For each source MLM, associated labels are generated from the inputted data objects and a similarity metric is calculated. The MLM manager selects a base MLM to be used for transfer learning from the plurality of source MLMs based upon the calculated similarity metric. The training manager trains the selected base MLM with a target dataset for the target domain.
    Type: Grant
    Filed: October 9, 2020
    Date of Patent: March 19, 2024
    Assignee: International Business Machines Corporation
    Inventors: Parul Awasthy, Bishwaranjan Bhattacharjee, John Ronald Kender, Radu Florian, Hui Wan
  • Publication number: 20240068096
    Abstract: In some embodiments, a showerhead assembly includes a heated showerhead having a heater plate and a gas distribution plate coupled together; an ion filter spaced from the heated showerhead; a spacer ring in contact between the heated showerhead and the ion filter; a remote plasma region between the heated showerhead and the ion filter; an upper isolator spaced from the spacer ring and supported on the ion filter; a sealing ring fastened to the heated showerhead sealing against the upper isolator and pushing the upper isolator against the ion filter; a gap between a bottom of the gas distribution plate and a top of the ion filter, the gap being in fluid communication with the remote plasma region; a first passage extending through the heater plate; and a second passage in communication with the first passage and extending through the gas distribution plate, the second passage extending to the gap.
    Type: Application
    Filed: May 18, 2023
    Publication date: February 29, 2024
    Inventors: Anantha K. SUBRAMANI, Seyyed Abdolreza FAZELI, Yang GUO, Chandrashekara BAGINAGERE, Ramcharan SUNDAR, Steven MOSBRUCKER, John LEE, Yiyang WAN, Shumao ZHANG, Dhritiman Subha KASHYAP, Azhar ALI M.A
  • Publication number: 20200300878
    Abstract: The present invention provides an array-type fecal occult blood detection analyzer. The array-type fecal occult blood detection analyzer comprises: a sample box frame (1) for carrying multiple sample boxes (11), the sample box frame (1) is an array-type structure; a conveying unit (2) for conveying the sample box frame (1), the conveying unit (2) comprises: a linear track (21) for supporting the sample box frame (1), and a driving device (23) for driving the sample box frame (1) so as to realize reciprocating linear movement; a downwards-pressing device (5) for downwards pressing the sample boxes (11); and an information collection device (4) for collecting color ribbon information presented on the test strip in the sample box (11) and label information on the sample box (11).
    Type: Application
    Filed: November 29, 2016
    Publication date: September 24, 2020
    Applicant: W.H.P.M. BIORESEARCH AND TECHNOLOGY CO., LTD.
    Inventors: John WAN, Zejiang LI
  • Patent number: 10684300
    Abstract: A rotating disc type fecal occult blood detection analyzer is used for detecting sample boxes (16). A sample box (16) comprises a transparent sleeve, and a fecal collector and a test strip provided in the transparent sleeve. The rotating disc type fecal occult blood detection analyzer comprises: a disc-shaped sample box holder (17) carrying multiple sample boxes (16); a driving device for driving the sample box holder (17) to rotate; a pressing device for pressing the sample boxes (16) down; and an information collecting device for collecting color ribbon information presented on the test strips in the sample boxes (16) and label information on the sample boxes (16). The rotating disc type fecal occult blood detection analyzer is small in size and compact in structure It is portable and makes detection more flexible.
    Type: Grant
    Filed: September 29, 2016
    Date of Patent: June 16, 2020
    Assignee: W.H.P.M BIORESEARCH AND TECHNOLOGY CO., LTD.
    Inventors: John Wan, Zejiang Li, Qingwei Shen
  • Patent number: 10390803
    Abstract: The present invention provides a feces sampling and detecting device and a method for detecting feces based on the feces sampling and detecting device. The device includes a detector, a casse with detecting strips provided in the detector, a collector accommodated in the detector detachably, a feces sampler for sealing the collector detachably, and at least one puncturing part arranged at a bottom of the detector facing one side of the collector. The feces sampling and detecting device can detect collected feces quickly, thereby avoiding feces sample from nature changing in an interval period, and preventing liquid in the collector from entering the detector to influence safety of the device of the present invention.
    Type: Grant
    Filed: February 28, 2014
    Date of Patent: August 27, 2019
    Assignee: W.H.P.M. BIORESEARCH AND TECHNOLOGY CO., LTD.
    Inventors: John Wan, Chunhua Yuan, Qinghai Xia
  • Patent number: 10384205
    Abstract: The invention provides a collection and detection integrated device with a mis-assembling prevention structure. The collection and detection integrated device with a mis-assembling prevention structure comprises: a detector; a test strip holder, detachably arranged in the detector; a collector, detachably contained in the detector; a faeces collection piece and a cushion block, configured to detachably seal the collector; and a piercing part, arranged on a bottom surface of the detector and configured to pierce the collector, wherein the test strip holder and the collector are contained in the detector side by side, the collector is located between the test strip holder and the detector, a first outer side face of the collector is adjacent to an inner side wall of the detector, a second outer side face of the collector is adjacent to the test strip holder, and the first outer side face and the second outer side face of the collector are asymmetric structurally.
    Type: Grant
    Filed: May 19, 2016
    Date of Patent: August 20, 2019
    Assignee: W.H.P.M. BIORESEARCH AND TECHNOLOGY CO., LTD.
    Inventors: John Wan, Qinghai Xia, Panpan Hou, Jie Liu
  • Patent number: 10359443
    Abstract: An automatic fecal occult blood detecting analyzer used to detect a sample box is provided. The analyzer has a feeding chain and a main conveying chain. A plurality of clamping devices for clamping the sample box are provided on the feeding chain and the main conveying chain, respectively. A transferring device of the analyzer transfers the sample box from the feeding chain to the main conveying chain. The analyzer also has a pressing device and an image acquisition device for acquiring tape information presented on test strips of the sample box on the main conveying chain. Continuous detection and accurate location of a plurality of the sample boxes can be implemented without turning over and tilting the sample boxes.
    Type: Grant
    Filed: December 24, 2015
    Date of Patent: July 23, 2019
    Assignee: W.H.P.M. BIORESEARCH AND TECHNOLOGY CO., LTD.
    Inventors: John Wan, Chunhai Zou, Qinghai Xia, Jie Liu
  • Publication number: 20180340950
    Abstract: A rotating disc type fecal occult blood detection analyzer is used for detecting sample boxes (16). A sample box (16) comprises a transparent sleeve, and a fecal collector and a test strip provided in the transparent sleeve. The rotating disc type fecal occult blood detection analyzer comprises: a disc-shaped sample box holder (17) carrying multiple sample boxes (16); a driving device for driving the sample box holder (17) to rotate; a pressing device for pressing the sample boxes (16) down; and an information collecting device for collecting color ribbon information presented on the test strips in the sample boxes (16) and label information on the sample boxes (16). The rotating disc type fecal occult blood detection analyzer is small in size and compact in structure It is portable and makes detection more flexible.
    Type: Application
    Filed: September 29, 2016
    Publication date: November 29, 2018
    Applicant: W.H.P.M BIORESEARCH AND TECHNOLOGY CO., LTD.
    Inventors: John WAN, Zejiang LI, Qingwei SHEN
  • Patent number: 10132741
    Abstract: An integrated sampling and detecting device is provided. The device has a detector; a test strip holder, detachably provided in the detector; a collector, detachably contained in the detector; a faeces sample piece and a cushion block, for detachably sealing the collector; and a piercing part, provided on a bottom surface of the detector and configured to pierce the collector. The test strip holder and the collector are contained in the detector side by side. The collector is located between the test strip holder and the detector. A first outer side face of the collector is adjacent to an inner side wall of the detector. A second outer side face of the collector is adjacent to the test strip holder. A horizontal cross-section of the piercing part adapts to a bottom surface of the collector.
    Type: Grant
    Filed: December 27, 2016
    Date of Patent: November 20, 2018
    Assignee: W.H.P.M. BIORESEARCH AND TECHNOLOGY CO., LTD.
    Inventors: John Wan, Qinghai Xia, Panpan Hou, Jie Liu
  • Patent number: 10001494
    Abstract: The present invention discloses an automatic fecal occult blood detector for detecting a sample kit, comprising: a feed passage and a discharging passage which are provided in parallel and convey a sample kit separately; a transfer platform configured between the feed passage and the discharging passage; a push rod configured to push the sample kit on the feed passage onto the discharging passage through the transfer platform; and an image capturing device provided on one side of the discharging passage to acquire the color band information presented on a test strip. In the present invention, the parallel arrangement of the feed passage and the discharging passage shortens the whole length of the automatic detector, meeting the requirement that the color band information of the test strip is automatically acquired after the sample kit is left in the device a certain time.
    Type: Grant
    Filed: October 24, 2014
    Date of Patent: June 19, 2018
    Assignee: W.H.P.M. BIORESEARCH AND TECHNOLOGY CO., LTD
    Inventors: John Wan, Yunfei Zhang, Jie Liu, Qinghai Xia
  • Publication number: 20180052096
    Abstract: An integrated sampling and detecting device is provided. The device has a detector; a test strip holder, detachably provided in the detector; a collector, detachably contained in the detector; a faeces sample piece and a cushion block, for detachably sealing the collector; and a piercing part, provided on a bottom surface of the detector and configured to pierce the collector. The test strip holder and the collector are contained in the detector side by side. The collector is located between the test strip holder and the detector. A first outer side face of the collector is adjacent to an inner side wall of the detector. A second outer side face of the collector is adjacent to the test strip holder. A horizontal cross-section of the piercing part adapts to a bottom surface of the collector.
    Type: Application
    Filed: December 27, 2016
    Publication date: February 22, 2018
    Applicant: W.H.P.M. BIORESEARCH AND TECHNOLOGY CO., LTD.
    Inventors: JOHN WAN, QINGHAI XIA, PANPAN HOU, JIE LIU
  • Publication number: 20180031590
    Abstract: The present invention provides a fully automatic fecal occult blood detecting analyzer, which is used to detect a sample box (30). The sample box (30) includes a transparent sleeve and a feces collector and test strips provided in the transparent sleeve. The fully automatic fecal occult blood detecting analyzer includes a feeding chain (10) and a main conveying chain (20); a plurality of clamping devices (40) for clamping the sample box (30) are provided on the feeding chain (10) and the main conveying chain (20), respectively; a transferring device is configured to transfer the sample box (30) from the feeding chain (10) to the main conveying chain (20); a pressing device (90); and an image acquisition device is configured to acquire colored tape information presented on the test strips in the sample box (30) on the main conveying chain (20).
    Type: Application
    Filed: December 24, 2015
    Publication date: February 1, 2018
    Applicant: W.H.P.M. BIORESEARCH AND TECHNOLOGY CO., LTD.
    Inventors: John WAN, Chunhai ZOU, Qinghai XIA, Jie LIU
  • Publication number: 20170189900
    Abstract: The invention provides a collection and detection integrated device with a mis-assembling prevention structure. The collection and detection integrated device with a mis-assembling prevention structure comprises: a detector; a test strip holder, detachably arranged in the detector; a collector, detachably contained in the detector; a faeces collection piece and a cushion block, configured to detachably seal the collector; and a piercing part, arranged on a bottom surface of the detector and configured to pierce the collector, wherein the test strip holder and the collector are contained in the detector side by side, the collector is located between the test strip holder and the detector, a first outer side face of the collector is adjacent to an inner side wall of the detector, a second outer side face of the collector is adjacent to the test strip holder, and the first outer side face and the second outer side face of the collector are asymmetric structurally.
    Type: Application
    Filed: May 19, 2016
    Publication date: July 6, 2017
    Applicant: W.H.P.M. BIORESEARCH AND TECHNOLOGY CO., LTD.
    Inventors: John WAN, Qinghai XIA, Panpan HOU, Jie LIU
  • Patent number: D776290
    Type: Grant
    Filed: June 29, 2015
    Date of Patent: January 10, 2017
    Assignee: W.H.P.M. BIORESEARCH AND TECHNOLOGY
    Inventors: John Wan, Qinghai Xia, Jie Liu
  • Patent number: D776291
    Type: Grant
    Filed: June 29, 2015
    Date of Patent: January 10, 2017
    Assignee: W.H.P.M. BIORESEARCH AND TECHNOLOGY
    Inventors: John Wan, Qinghai Xia, Dandan Yang
  • Patent number: D776292
    Type: Grant
    Filed: November 25, 2015
    Date of Patent: January 10, 2017
    Assignee: W.H.P.M. BIORESEARCH AND TECHNOLOGY
    Inventors: John Wan, Qinghai Xia, Panpan Hou, Jie Liu
  • Patent number: D782058
    Type: Grant
    Filed: April 27, 2016
    Date of Patent: March 21, 2017
    Assignee: W.H.P.M. BIORESEARCH AND TECHNOLOGY CO., LTD.
    Inventors: John Wan, Zhejiang Li, Qingwei Shen
  • Patent number: D797303
    Type: Grant
    Filed: July 23, 2015
    Date of Patent: September 12, 2017
    Assignee: W.H.P.M. BIORESEARCH AND TECHNOLOGY CO., LTD.
    Inventors: John Wan, Qinghai Xia, Panpan Hou
  • Patent number: D825773
    Type: Grant
    Filed: July 27, 2017
    Date of Patent: August 14, 2018
    Assignee: W. H. P. M. BIORESEARCH AND TECHNOLOGY CO., LTD.
    Inventor: John Wan