Abstract: The present disclosure provides tobacco Nic1b locus and associated genes (e.g., a group of ERF genes). Also provided are tobacco plants with altered total alkaloid and nicotine levels and commercially acceptable leaf grade, their development via breeding or transgenic approaches, and production of tobacco products from these tobacco plants. Further provided are compositions and methods for producing tobacco plants having novel mutations or alleles to reduce nicotine levels. Further provided are sequence polymorphisms and molecular markers for breeding tobacco with reduced nicotine or alkaloids while maintaining tobacco leaf grade and tobacco product quality.

Abstract: A lighting system for a ceiling grid system may provide lighting at a location below the ceiling grid system. The light fixture includes a light source and a support member, and the light fixture may provide diffusely reflected light to a ceiling grid opening. The light fixture may include a wall assembly that is adapted to be moved between a folded configuration and an unfolded configuration.

Abstract: A lighting system for a ceiling grid system may provide lighting at a location below the ceiling grid system. The light fixture includes a light source and a support member, and the light fixture may provide diffusely reflected light to a ceiling grid opening. The light fixture may include a wall assembly that is adapted to be moved between a folded configuration and an unfolded configuration.

Abstract: The present disclosure provides tobacco inbred plants TND950 (phph) SRC, Narrow Leaf Madole (phph) SRC, Narrow Leaf Madole SRC, CMS TND950 SRC, CMS Narrow Leaf Madole SRC, and CMS KY171 SRC, and hybrids PD7305 SRC, PD7309 SRC, PD7312 SRC, PD7318 SRC, and PD7319 SRC. The present disclosure also provides parts of such plants and products made from those parts. The present disclosure also includes progeny of the provided plants including hybrids.

Abstract: A system for providing end-to-end data protection between a transmitting end device and a receiving end device is presented. The system has a transmitting end device to calculate a first check value for a first message, which has first and second data blocks; the receiving end device; and a remapping device. The remapping device is configured to remap a data block among the first and second data blocks for generating a second message for the receiving end device. The remapping device also determines a remapping value based on the data block and the remapped data block, such that a second check value that would be calculated for the second message would be equal to the first check value, and wherein the second message comprises the other one of the first and second data blocks, the remapped data block, and the remapping value.

Abstract: The present disclosure provides the identification of tobacco Nic1 locus. Also provided are tobacco plants with altered total alkaloid and nicotine levels and commercially acceptable leaf grade, their development via breeding or transgenic approaches, and production of tobacco products from these tobacco plants. Also provided are compositions and methods for producing tobacco plants having novel Nic1 mutations or alleles to reduce nicotine levels. Further provided are sequence polymorphisms and molecular markers for breeding tobacco with reduced nicotine or nicotine free while maintaining tobacco leaf grade and tobacco product quality.

Abstract: A system for providing end-to-end data protection between a transmitting end device and a receiving end device is presented. The system has a transmitting end device to calculate a first check value for a first message, which has first and second data blocks; the receiving end device; and a remapping device. The remapping device is configured to remap a data block among the first and second data blocks for generating a second message for the receiving end device. The remapping device also determines a remapping value based on the data block and the remapped data block, such that a second check value that would be calculated for the second message would be equal to the first check value, and wherein the second message comprises the other one of the first and second data blocks, the remapped data block, and the remapping value.

Abstract: Disclosed herein are systems and methods for performing a geospatial-function join using an implied interval join. In an embodiment, a database platform receives a query that includes a geospatial-function join, which applies a geospatial-function predicate to a first geography data object of a first relation and a second geography data object of a second relation. The database platform processes the first and second relations through an interval join that applies an interval-join predicate that is implied by the geospatial-function predicate. The database platform obtains query results at least in part by implementing a filter that applies the geospatial-function predicate to an output of the interval join, and outputs the query results.

Abstract: In an embodiment, a data platform receives a query that includes a two-sided N dimensional interval join of first and second input relations, where N>1. The two-sided N dimensional interval join has an interval-join predicate that, in each of N dimensions, compares intervals determined from the first and second input relations. The data platform implements the interval join at least in part by identifying an intermediate relation that includes all combinations of a row from the first input relation and a row from the second input relation where, in each of the N dimensions, the intervals determined from the first and second input relations both overlap a common N dimensional domain region of an input domain of the first and second input relations. The data platform obtains and returns results of the query.

Abstract: In an embodiment, a data platform receives a query that includes a two-sided N dimensional interval join of first and second input relations. The data platform samples, with respect to each of one or more of the N dimensions, one or both of the first input relation and the second input relation with respect to an interval size of an interval determined from the input relation. The data platform demarcates the N dimensional input domain into non-overlapping N dimensional input-domain cells based on the sampling. The data platform implements the interval join using a query-execution plan that includes an equality join that is keyed on input-domain-cell identifiers of input-domain cells that at least partially overlap bounding polygons of the intervals determined from the first and second input relations. The equality join is followed in the query-execution plan by a filter that applies the interval-join predicate. The data platform obtains results of the query by executing the query-execution plan.

Abstract: In an embodiment, a database platform receives query instructions for a query on a database, where the query instructions include instructions for a geospatial-function join that includes a geospatial-function predicate. The database platform generates a query-execution plan based on the query instructions, including replacing the geospatial-function join with one or more interval joins that each include one or more predicates implied by the geospatial-function predicate. The database platform inserts, into the query-execution plan above the one or more interval joins, a filter operator that applies the geospatial-function predicate. The database platform obtains results of the query at least in part by executing the query-execution plan, and returns the query results in response to the query.

Abstract: In an embodiment, a data platform implements a two-sided N dimensional interval join using an N dimensional band join followed by a filter that applies a predicate of the interval join. The data platform generates first and second modified relations from first and second input relations. Each modified relation includes a copy of each row from the corresponding input relation for each input-domain cell that overlaps, in each of N dimensions, a bounding polygon of intervals determined from the row of the corresponding input relation. The data platform inserts, in each row in each modified relation, an input-domain-cell identifier of the corresponding overlapping input-domain cell and uses a hash-equality join that receives the first and second modified relations and that is keyed on the input-domain-cell identifiers. The data platform obtains results of a query by executing a query-execution plan that includes the query-plan section.

Abstract: Disclosed herein are systems and methods for pre-filter deduplication for multidimensional two-sided interval joins. In an embodiment, a data platform receives query instructions for a two-sided N dimensional interval join, where N is an integer greater than 1. The two-sided N dimensional interval join has an interval-join predicate that compares intervals determined from the input relations in each of N dimensions. The data platform implements the two-sided N dimensional interval join as a query-plan section that includes an N dimensional band join that is followed by a deduplication operator that is followed by a filter that applies the interval-join predicate. The N dimensional band join includes a hash join keyed to N dimensional domain cells overlapped at least in part by intervals determined from the input relations in each of the N dimensions. The deduplication operator removes duplicate rows from a potential-duplicates subset of the output of the N dimensional band join.

Abstract: Disclosed herein are systems and methods for pre-filter deduplication for multidimensional two-sided interval joins. In an embodiment, a data platform receives query instructions for a two-sided N dimensional interval join, where N is an integer greater than 1. The two-sided N dimensional interval join has an interval-join predicate that compares intervals determined from the input relations in each of N dimensions. The data platform implements the two-sided N dimensional interval join as a query-plan section that includes an N dimensional band join that is followed by a deduplication operator that is followed by a filter that applies the interval-join predicate. The N dimensional band join includes a hash join keyed to N dimensional domain cells overlapped at least in part by intervals determined from the input relations in each of the N dimensions. The deduplication operator removes duplicate rows from a potential-duplicates subset of the output of the N dimensional band join.

Abstract: In an embodiment, a data platform receives a query that includes a two-sided N dimensional interval join of first and second input relations. The data platform samples, with respect to each of one or more of the N dimensions, one or both of the first input relation and the second input relation with respect to an interval size of an interval determined from the input relation. The data platform demarcates the N dimensional input domain into non-overlapping N dimensional input-domain cells based on the sampling. The data platform implements the interval join using a query-execution plan that includes an equality join that is keyed on input-domain-cell identifiers of input-domain cells that at least partially overlap bounding polygons of the intervals determined from the first and second input relations. The equality join is followed in the query-execution plan by a filter that applies the interval join predicate. The data platform obtains results of the query by executing the query-execution plan.

Abstract: In an embodiment, a data platform implements a two-sided N dimensional interval join using an N dimensional band join followed by a filter that applies a predicate of the interval join. The data platform generates first and second modified relations from first and second input relations. Each modified relation includes a copy of each row from the corresponding input relation for each input-domain cell that overlaps, in each of N dimensions, a bounding polygon of intervals determined from the row of the corresponding input relation. The data platform inserts, in each row in each modified relation, an input-domain-cell identifier of the corresponding overlapping input-domain cell and uses a hash-equality join that receives the first and second modified relations and that is keyed on the input-domain-cell identifiers. The data platform obtains results of a query by executing a query-execution plan that includes the query-plan section.

Abstract: Provided herein are systems and methods for indexed geospatial predicate search. An example method performed by at least one hardware processor includes decoding a query with a geospatial predicate. The geospatial predicate is configured between a geography data column and a constant geography object. The method further includes computing a first covering for a data value of a plurality of data values in the geography data column. The first covering includes a first set of cells in a hierarchical grid representation of a geography. The first set of cells represents a surface of the geography associated with the data value. A second covering is computed for the constant geography object. A determination is made on whether to prune at least one partition of a database organized into a set of partitions and including the geography data column based on a comparison between the first covering and the second covering.

Abstract: Disclosed herein are systems and methods for point-based relation splitting in geospatial-function-implied interval joins. In an embodiment, a data platform receives a query that applies a geospatial-function predicate to first and second geography data objects from first and second relations. The second relation is divided into point and non-point subsets based on the second data geography object. The data platform routes the point subset along a first path that includes a one-sided interval join that applies, to the first relation and the point subset, an interval-join predicate implied by the geospatial-function predicate. The data platform routes the non-point subset along a second path that does not include the one-sided interval join. The data platform obtains query results at least in part with a filter that applies the geospatial-function predicate to outputs of the one-sided interval join and the second path, and outputs the query results.

Abstract: The present disclosure provides tobacco inbred plants TND950 (phph) SRC, Narrow Leaf Madole (phph) SRC, Narrow Leaf Madole SRC, CMS TND950 SRC, CMS Narrow Leaf Madole SRC, and CMS KY171 SRC, and hybrids PD7305 SRC, PD7309 SRC, PD7312 SRC, PD7318 SRC, and PD7319 SRC. The present disclosure also provides parts of such plants and products made from those parts. The present disclosure also includes progeny of the provided plants including hybrids.

Abstract: Disclosed herein are systems and methods for implementing multidimensional two-sided interval joins on a distributed hash-based-equality-join infrastructure. In an embodiment, a data platform receives, for a query on a database, query instructions that include a two-sided N-dimensional interval join of a first input relation and a second input relation, where N is an integer greater than 1. The two-sided N-dimensional interval join has an interval-join predicate that, in each of N dimensions, compares an interval determined from the first input relation with an interval determined from the second input relation. The data platform generates a query-execution plan that implements the two-sided N-dimensional interval join as a query-plan section that includes an N-dimensional band join followed by a filter that applies the interval-join predicate to a band-join output of the N-dimensional band join. The data platform obtains results of the query at least in part by executing the query-execution plan.