Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources

Apache Calcite is a foundational software framework that provides query processing, optimization, and query language support to many popular open-source data processing systems such as Apache Hive, Apache Storm, Apache Flink, Druid, and MapD. Calcite's architecture consists of a modular and extensible query optimizer with hundreds of built-in optimization rules, a query processor capable of processing a variety of query languages, an adapter architecture designed for extensibility, and support for heterogeneous data models and stores (relational, semi-structured, streaming, and geospatial). This flexible, embeddable, and extensible architecture is what makes Calcite an attractive choice for adoption in big-data frameworks. It is an active project that continues to introduce support for the new types of data sources, query languages, and approaches to query processing and optimization.Comment: SIGMOD'1

Description of the Fifth Instar of \u3ci\u3eApache Degeerii\u3c/i\u3e (Homoptera: Fulgoroidea: Derbidae)

(excerpt) Apache degeerii (Kirby) ranges from Maine south to Florida and west to Iowa and Texas; it has also been recorded from British Columbia and Washington (Metcalf 1945. Wilson and McPherson 1980). This derbid has been recorded from oak, beech, maple, and hickory (Swezey 19(4); otherwise no information on its biology is available

The Anthonomus juniperinus group, with descriptions of two new species (Coleoptera: Curculionidae)

The Anthonomus juniperinus (Sanborn) species group is defined and two new species, Anthonomus sanborni, new species, and A. rileyi new species, from the United States are described, keyed and illustrated. The three species of the group are associated with the plant genus Juniperus and the larvae of A. juniperinus are known to develop in fungal galls of Gymnosporangium spp. as well as fruits of the Eastern redcedar, Juniperus virginiana L. The biology of the group and its taxonomic relationships to other species of Anthonomus Germar are also discussed

Revision of the subgenus Cnemocyllus Dietz of the weevil genus Anthonomus Germar (Coleoptera: Curculionidae, Anthonomini)

Anthonomus (Cnemocyllus) decipiens Dietz is designated as type species of Cnemocyllus Dietz. The twenty-three North American species assigned to the Anthonomus subgenus Cnemocyllus include ten previously placed in the subgenus: A. albus Hatch, A. decipiens LeConte, A. dorothyae Hatch, A. elongatus LeConte, A. jacobinus Dietz, A. juncturus Fall, A. ligatus Dietz, A. pictus Blatchley, A. quesnelensis Sleeper, and A. tenuis Fall; three species formerly in Anthonomus but not in Cnemocyllus: A. stolatus Fall, A. inermis Boheman, and A. ornatulus Dietz; two species once in Epimechus Dietz but subsequently transferred to Anthonomus: A. arenicolor (Fall) and A. canoides (Fall); and eight new species: A. californiensis, new species (California and Baja California); A. bajaensis, new species (Baja California); A. intermedius, new species (Utah); A. extensus, new species (British Columbia, California, Idaho, Oregon, and Washington); A. deserticolus, new species (Arizona, Baja California, California, Guerrero, New Mexico, Sonora, and Texas); A. schuhi, new species (California and Oregon); A. latus, new species (California); and A. squamoerectus, new species (California and Oregon). The species of Anthonomus in the subgenus Cnemocyllus are distinguished from other Anthonomini by the combination of having vestiture of more-or-less broad, dense scales, 6 or 7 antennal funicular articles, a slender endophallic transfer apparatus and, in most, the slightly to strongly curved metatibia of the male. The tarsal claws are variable, toothed or untoothed. The names Anthonomus cycliferus (Fall), A. malkini Hatch and A. summeri Hatch are placed in new synonymy under A. jacobinus Dietz; A. cretaceus (Champion) is placed in new synonymy under A. decipiens LeConte; A. imbricus Hatch is placed in new synonymy under A. quesnelensis Sleeper; A. mannerheimi Dieckmann (A. brunnipennis Mannerheim, not Curtis) and A. subvittatus LeConte are placed in new synonymy under A. inermis (Boheman); A. minutus Hatch is placed in new synonymy under A. dorothyae Hatch. Adults of many of the species of the subgenus Cnemocyllus have been collected on plants in the family Asteraceae. The larvae of several of the species are known to develop on these plants

New species and records of Rhyssa and Rhyssella (Hymenoptera: Ichneumonidae: Rhyssinae) from Florida and Central America

Rhyssa neotropicae n. sp. is the first Rhyssa to be recorded from the New World tropics, where it was collected in cloud forest at 1800 m on Monte Uyuca near Zamorano, Honduras. It is closely related to the Nearctic R. hoferi Rohwer and R. howdenorum Townes but differs from all other Rhyssa by its complexly yellow and black marked head and body, whose color pattern mimics that of aggressive social vespid wasps (Agelaia) which occur in the same habitat. Rhyssa howdenorum Townes is recorded for the first time from Florida and Oklahoma. The genus Rhyssella, previously unknown in Florida, is represented in that state by R. perfulua n. sp., distinctive in its mostly orange brown coloration, and by R. humida (Say), a black and white species with fulvous on the thoracic pleura and propodeum.Rhyssa neotropicae n. sp. es la primera especie de su genero de ser senalada para la Region Neotropical, donde se la colecciono en selva humeda de alta montana a 1800 msnm en la cima del Monte Uyuca cerca de Zamorano en Honduras. Se trata de una especie muy afin a R. hoferi Rohwer y a R. howdenorum Townes, las cuales se distribuyen en el sur y centro de la Region Neartica, diferenciimdose, no obstante, R. neotropicae de todas las demas Rhyssa por su bello esquema de coloracion con intrincados dis enos amarillos y negros, a semejanza del que osten tan unos vespidos sociales agresivos (Agelaia), que abundan en los mismos ambientes. Se cita pol' primera vez a Rhyssa howdenorum Townes para Florida y Oklahoma. El genero Rhyssella, antes no conocido en la Florida, cuenta de hecho en este estado con 2 especies, R. perfulua n.sp., que destaca pOl' tener el cuerpo casi uniformemente de color castano claro anaranjado, y R. humida (Say), especie negra con dis enos blancos y las pleuras toracicas junto con el propodeo en gran parte de color claro, entre anaranjado y rojo

Benchmarking Distributed Stream Data Processing Systems

The need for scalable and efficient stream analysis has led to the development of many open-source streaming data processing systems (SDPSs) with highly diverging capabilities and performance characteristics. While first initiatives try to compare the systems for simple workloads, there is a clear gap of detailed analyses of the systems' performance characteristics. In this paper, we propose a framework for benchmarking distributed stream processing engines. We use our suite to evaluate the performance of three widely used SDPSs in detail, namely Apache Storm, Apache Spark, and Apache Flink. Our evaluation focuses in particular on measuring the throughput and latency of windowed operations, which are the basic type of operations in stream analytics. For this benchmark, we design workloads based on real-life, industrial use-cases inspired by the online gaming industry. The contribution of our work is threefold. First, we give a definition of latency and throughput for stateful operators. Second, we carefully separate the system under test and driver, in order to correctly represent the open world model of typical stream processing deployments and can, therefore, measure system performance under realistic conditions. Third, we build the first benchmarking framework to define and test the sustainable performance of streaming systems. Our detailed evaluation highlights the individual characteristics and use-cases of each system.Comment: Published at ICDE 201