Patents by Inventor Stefan Richter
Stefan Richter 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).
-
Publication number: 20230064151Abstract: A source table organized into a set of batch units is accessed. The source table comprises a column of data corresponding to a semi-structured data type. One or more indexing transformations for an object in the column are generated. The generating of the one or more indexing transformation includes converting the object to one or more stored data types. A pruning index is generated for the source table based in part on the one or more indexing transformations. The pruning index comprises a set of filters that index distinct values in each column of the source table, and each filter corresponds to a batch unit in the set of batch units. The pruning index is stored in a database with an association with the source table.Type: ApplicationFiled: October 18, 2022Publication date: March 2, 2023Inventors: Mahmud Allahverdiyev, Thierry Cruanes, Ismail Oukid, Stefan Richter
-
Patent number: 11593379Abstract: A query directed at a table organized into a set of batch units is received. The query comprises a predicate for which values are unknown prior to runtime. A set of values for the predicate are determined based on the query. An index access plan is created based on the set of values. Based on the index access plan, the set of batch units are pruned using a pruning index associated with the table. The pruning index comprises a set of filters that index distinct values in each column of the table. The pruning of the set of batch units comprises identifying a subset of batch units to scan for data that satisfies the query. The subset of batch units of the table are scanned to identify data that satisfies the query.Type: GrantFiled: May 31, 2022Date of Patent: February 28, 2023Assignee: Snowflake Inc.Inventors: Max Heimel, Ismail Oukid, Linnea Passing, Stefan Richter, Juliane K. Waack
-
Publication number: 20230019945Abstract: A table organized into a set of batch units is accessed. A set of N-grams are generated for a data value in the source table. The set of N-grams include a first N-gram of a first length and a second N-gram of a second length where the first N-gram corresponds to a prefix of the second N-gram. A set of fingerprints are generated for the data value based on the set of N-grams. The set of fingerprints include a first fingerprint generated based on the first N-gram and a second fingerprint generated based on the second N-gram and the first fingerprint. A pruning index that indexes distinct values in each column of the source table is generated based on the set of fingerprints and stored in a database with an association with the source table.Type: ApplicationFiled: September 29, 2022Publication date: January 19, 2023Inventors: Ismail Oukid, Stefan Richter
-
Publication number: 20230002215Abstract: MEMS devices include a suspended element connected to a fixed part of a substrate by one or more flexures, wherein the one or more flexures are configured to permit movement of the suspended element relative to a fixed part of the substrate. An actuator coupled to the suspended element and a damping structure coupled to the suspended element extends into a gap between the suspended element and the fixed part of the substrate. One or more fluid confinement structures are configured to permit movement of the damping structure within a limited portion of the gap and to confine a viscoelastic fluid to the limited portion of the gap.Type: ApplicationFiled: September 8, 2022Publication date: January 5, 2023Inventors: Stefan Richter, Johannes Kindt, Veljko Milanovic
-
Patent number: 11544269Abstract: A query directed at a source table organized into a set of batch units is received. The query includes a pattern matching predicate that specifies a search pattern. A set of N-grams are generated based on the search pattern. A pruning index associated with the source table is accessed. The pruning index comprises a set of filters that index distinct N-grams in each column of the source table. The pruning index is used to identify a subset of batch units to scan for matching data based on the set of N-grams generated for the search pattern. The query is processed by scanning the subset of batch units.Type: GrantFiled: March 29, 2022Date of Patent: January 3, 2023Assignee: Snowflake Inc.Inventors: Thierry Cruanes, Benoit Dageville, Ismail Oukid, Stefan Richter
-
Patent number: 11494384Abstract: A source table organized into a set of batch units is accessed. The source table comprises a column of data corresponding to a semi-structured data type. One or more indexing transformations for an object in the column are generated. The generating of the one or more indexing transformation includes converting the object to one or more stored data types. A pruning index is generated for the source table based in part on the one or more indexing transformations. The pruning index comprises a set of filters that index distinct values in each column of the source table, and each filter corresponds to a batch unit in the set of batch units. The pruning index is stored in a database with an association with the source table.Type: GrantFiled: March 16, 2022Date of Patent: November 8, 2022Assignee: Snowflake Inc.Inventors: Mahmud Allahverdiyev, Thierry Cruanes, Ismail Oukid, Stefan Richter
-
Patent number: 11487763Abstract: A table organized into a set of batch units is accessed. A set of N-grams are generated for a data value in the source table. The set of N-grams include a first N-gram of a first length and a second N-gram of a second length where the first N-gram corresponds to a prefix of the second N-gram. A set of fingerprints are generated for the data value based on the set of N-grams. The set of fingerprints include a first fingerprint generated based on the first N-gram and a second fingerprint generated based on the second N-gram and the first fingerprint. A pruning index that indexes distinct values in each column of the source table is generated based on the set of fingerprints and stored in a database with an association with the source table.Type: GrantFiled: February 1, 2022Date of Patent: November 1, 2022Assignee: Snowflake Inc.Inventors: Ismail Oukid, Stefan Richter
-
Patent number: 11472697Abstract: MEMS devices include fluid confinement structures on either a fixed part of a substrate and/or on a suspended element. The fluid confinement structures may be configured to confine a viscoelastic fluid in a limited part of a gap between one or more vertical sidewalls of both the fixed part of the substrate and either the suspended element or the drive beam or both the suspended element and drive beam such that one part of the gap is bridged by the fluid and another part of the gap is not, The structures may be configured to prevent flow of the fluid to other parts of the gap.Type: GrantFiled: July 12, 2018Date of Patent: October 18, 2022Assignee: MIRRORCLE TECHNOLOGIES, INC.Inventors: Stefan Richter, Johannes Kindt, Veljko Milanovic
-
Publication number: 20220292098Abstract: A query directed at a table organized into a set of batch units is received. The query comprises a predicate for which values are unknown prior to runtime. A set of values for the predicate are determined based on the query. An index access plan is created based on the set of values. Based on the index access plan, the set of batch units are pruned using a pruning index associated with the table. The pruning index comprises a set of filters that index distinct values in each column of the table. The pruning of the set of batch units comprises identifying a subset of batch units to scan for data that satisfies the query. The subset of batch units of the table are scanned to identify data that satisfies the query.Type: ApplicationFiled: May 31, 2022Publication date: September 15, 2022Inventors: Max Heimel, Ismail Oukid, Linnea Passing, Stefan Richter, Juliane K. Waack
-
Patent number: 11435000Abstract: The invention relates to a mechanical seal arrangement comprising a mechanical seal including a rotating slide ring (2) and a stationary slide ring (3) which define a sealing gap (4) between seal faces (21, 31), a shaft sleeve arrangement (5), comprising a split shaft sleeve with a first annular sleeve part (51) and a second annular sleeve part (52), which are connected to each other by means of a snap-in connection (6), wherein the rotating slide ring (2) is arranged on the shaft sleeve arrangement (5), and wherein the snap-in connection (6) comprises at least one snap-in nose (60) and one snap-in recess (61) receiving the snap-in nose (60) to allow the first sleeve part (51) to engage with the second sleeve part (52).Type: GrantFiled: January 22, 2019Date of Patent: September 6, 2022Assignee: EagleBurgmann Germany GmbH & Co. KGInventors: Stefan Richter, Alfred Matuschek, Hans Steigenberger
-
Publication number: 20220277013Abstract: A source table organized into a set of micro-partitions is accessed by a network-based data warehouse. A pruning index is generated based on the source table. The pruning index comprises a set of filters that indicate locations of distinct values in each column of the source table. A query directed at the source table is received at the network-based data warehouse. The query is processed using the pruning index. The processing of the query comprises pruning the set of micro-partitions of the source table to scan for data matching the query, the pruning of the plurality of micro-partitions comprising identifying, using the pruning index, a sub-set of micro-partitions to scan for the data matching the query.Type: ApplicationFiled: March 15, 2022Publication date: September 1, 2022Inventors: Thierry Cruanes, Benoit Dageville, Ismail Oukid, Stefan Richter
-
Patent number: 11406998Abstract: In order to create a rotating unit for a coating lance device for thermally coating an interior, it is provided that the rotary drive is implemented as a hollow-shaft motor coaxial with the axis of rotation of the tool holder, and wherein the tool holder and the coating material feed, as well as the process media feed, are located centrally relative to the hollow-shaft motor. Furthermore, in order to create a coating lance device for thermally coating an interior, it is proposed to provide such a rotating unit; at least one linear actuator for axial and/or lateral positioning of the rotating unit relative to an interior to be coated; and stationary supply connections for supplying electricity to the coating lance, and for the coating material feed, and for the process media feed.Type: GrantFiled: March 26, 2020Date of Patent: August 9, 2022Assignee: Volkswagen AktiengesellschaftInventors: Stefan Richter, Mike Hirschfeldt, Klaus Stefan Klimek, Philipp Marian Mueller
-
Patent number: 11402760Abstract: An optical arrangement for a lithography apparatus has a microsystem with a mirror array. A respective mirror of the mirror array is set up to reflect working light of the lithography apparatus on its front side and also a measuring beam on its rear side. One or more radiation sources, which are provided outside the microsystem, are set up to provide the respective measuring beam. One or more sensor units are set up to sense a tilting angle of a respective mirror in dependence on the respectively reflected measuring beam.Type: GrantFiled: September 21, 2021Date of Patent: August 2, 2022Assignee: Carl Zeiss SMT GmbHInventors: Jan Horn, Stefan Richter
-
Publication number: 20220215027Abstract: A query directed at a source table organized into a set of batch units is received. The query includes a pattern matching predicate that specifies a search pattern. A set of N-grams are generated based on the search pattern. A pruning index associated with the source table is accessed. The pruning index comprises a set of filters that index distinct N-grams in each column of the source table. The pruning index is used to identify a subset of batch units to scan for matching data based on the set of N-grams generated for the search pattern. The query is processed by scanning the subset of batch units.Type: ApplicationFiled: March 29, 2022Publication date: July 7, 2022Inventors: Thierry Cruanes, Benoit Dageville, Ismail Oukid, Stefan Richter
-
Publication number: 20220207041Abstract: A source table organized into a set of batch units is accessed. The source table comprises a column of data corresponding to a semi-structured data type. One or more indexing transformations for an object in the column are generated. The generating of the one or more indexing transformation includes converting the object to one or more stored data types. A pruning index is generated for the source table based in part on the one or more indexing transformations. The pruning index comprises a set of filters that index distinct values in each column of the source table, and each filter corresponds to a batch unit in the set of batch units. The pruning index is stored in a database with an association with the source table.Type: ApplicationFiled: March 16, 2022Publication date: June 30, 2022Inventors: Mahmud Allahverdiyev, Thierry Cruanes, Ismail Oukid, Stefan Richter
-
Patent number: 11372860Abstract: A query directed at a table organized into a set of batch units is received. The query comprises a predicate for which values are unknown prior to runtime. A set of values for the predicate are determined based on the query. An index access plan is created based on the set of values. Based on the index access plan, the set of batch units are pruned using a pruning index associated with the table. The pruning index comprises a set of filters that index distinct values in each column of the table. The pruning of the set of batch units comprises identifying a subset of batch units to scan for data that satisfies the query. The subset of batch units of the table are scanned to identify data that satisfies the query.Type: GrantFiled: August 31, 2021Date of Patent: June 28, 2022Assignee: Snowflake Inc.Inventors: Max Heimel, Ismail Oukid, Linnea Passing, Stefan Richter, Juliane K. Waack
-
Publication number: 20220156264Abstract: A table organized into a set of batch units is accessed. A set of N-grams are generated for a data value in the source table. The set of N-grams include a first N-gram of a first length and a second N-gram of a second length where the first N-gram corresponds to a prefix of the second N-gram. A set of fingerprints are generated for the data value based on the set of N-grams. The set of fingerprints include a first fingerprint generated based on the first N-gram and a second fingerprint generated based on the second N-gram and the first fingerprint. A pruning index that indexes distinct values in each column of the source table is generated based on the set of fingerprints and stored in a database with an association with the source table.Type: ApplicationFiled: February 1, 2022Publication date: May 19, 2022Inventors: Ismail Oukid, Stefan Richter
-
Patent number: 11318833Abstract: It is provided an adjustment mechanism, comprising a closure flap for at least partially closing a closure opening on a vehicle, via which, when the closure flap is opened, a connection element for connecting a line and/or a port for topping up a liquid, in particular a fuel, is accessible, a drive for adjusting the closure flap by external force in response to an operator control event, and an electronic control unit which is coupled to the drive and by means of which the drive is activated to open the closure flap in response to an operator control event which is detected in a contactless manner, and, on the other hand, is automatically stopped or reversed in so far as, when the closure flap closes, a possible obstacle is detected in a contactless manner in the adjustment path of the closure flap by means of an anti-pinch mechanism.Type: GrantFiled: January 13, 2017Date of Patent: May 3, 2022Assignee: BROSE FAHRZEUGTEILE GMBH & CO. KOMMANDITGESELLSCHAFTInventors: Ralf Daiminger, Stefan Richter
-
Patent number: 11321325Abstract: A query directed at a source table organized into a set of batch units is received. The query includes a pattern matching predicate that specifies a search pattern. A set of N-grams are generated based on the search pattern. A pruning index associated with the source table is accessed. The pruning index comprises a set of filters that index distinct N-grams in each column of the source table. The pruning index is used to identify a subset of batch units to scan for matching data based on the set of N-grams generated for the search pattern. The query is processed by scanning the subset of batch units.Type: GrantFiled: July 29, 2021Date of Patent: May 3, 2022Assignee: Snowflake Inc.Inventors: Thierry Cruanes, Benoit Dageville, Ismail Oukid, Stefan Richter
-
Patent number: 11308090Abstract: A source table organized into a set of batch units is accessed. The source table comprises a column of data corresponding to a semi-structured data type. One or more indexing transformations for an object in the column are generated. The generating of the one or more indexing transformation includes converting the object to one or more stored data types. A pruning index is generated for the source table based in part on the one or more indexing transformations. The pruning index comprises a set of filters that index distinct values in each column of the source table, and each filter corresponds to a batch unit in the set of batch units. The pruning index is stored in a database with an association with the source table.Type: GrantFiled: August 4, 2021Date of Patent: April 19, 2022Assignee: Snowflake Inc.Inventors: Mahmud Allahverdiyev, Thierry Cruanes, Ismail Oukid, Stefan Richter