Spreadsheets are being used with many different purposes that range from toy applications to complete information systems. In any of these cases, they are often used as data repositories that can grow significantly. As the amount of data grows, it also becomes more difficult to extract concrete information out of them. This paper focuses on the problem of spreadsheet querying. In particular, we propose an expressive and composable technique where intuitive queries can be defined. Our approach builds on a model-driven spreadsheet development environment, and queries are expressed referencing entities in the model of a spreadsheet instead of in its actual data. Finally, the system that we have implemented relies on Google's query function for spreadsheets.

This paper presents a tool, named QUERYSHEET, to query spreadsheets. We defined a language to write the queries, which resembles SQL, the language to query databases. This allows to write queries which are more related to the spreadsheet content than with current approaches.

Let k be a positive integer and G be a k-connected graph. An edge-coloured path is rainbow if its edges have distinct colours. The rainbow k-connection number of G, denoted by rc_k(G), is the minimum number of colours required to colour the edges of G so that any two vertices of G are connected by k internally vertex-disjoint rainbow paths. The function rc_k(G) was first introduced by Chartrand, Johns, McKeon, and Zhang in 2009, and has since attracted considerable interest. In this paper, we consider a version of the function rc_k(G) which involves vertex-colourings. A vertex-coloured path is vertex-rainbow if its internal vertices have distinct colours. The rainbow vertex k-connection number of G, denoted by rvc_k(G), is the minimum number of colours required to colour the vertices of G so that any two vertices of G are connected by k internally vertex-disjoint vertex-rainbow paths. We shall study the function rvc_k(G) when G is a cycle, a wheel, and a complete multipartite graph. We also construct graphs G where rc_k(G) is much larger than rvc_k(G) and vice versa so that we cannot in general bound one of rc_k(G) and rvc_k(G) in terms of the other.

We introduce a class of finite semigroups obtained by considering Rees
quotients of numerical semigroups.
Several natural questions concerning this class, as well as particular
subclasses obtained by considering some special ideals, are answered while
others remain open. We exhibit nice presentations for these semigroups and
prove that the Rees quotients by ideals of N, the positive integers under
addition, constitute a set of generators for the pseudovariety of commutative
and nilpotent semigroups.

Os sistemas de memória transacional distribuída atuais recorrem essencialmente à distribuição ou à replicação total para distribuir os seus dados pelos múltiplos nós do sistema. No entanto, estas estratégias de replicação de dados apresentam limitações. A distribuição não oferece tolerância a falhas e a replicação total limita a capacidade de armazenamento do sistema. Nesse contexto, a replicação parcial de dados surge como uma solução intermédia, que combina o melhor das duas anteriores com o intuito de mitigar as suas desvantagens. Esta estratégia tem sido explorada no contexto das bases de dados distribuídas, mas tem sido pouco abordada no contexto da memória transacional e, tanto quanto sabemos, nunca antes tinha sido incorporada num sistema de memória transacional distribuída para uma linguagem de propósito geral. Assim, neste artigo propomos e avaliamos uma infraestrutura para replicação parcial de dados para programas Java bytecode, que foi desenvolvida com base num sistema já existente de memória transacional distribuída. A modularidade da infraestrutura que apresentamos permite a implementação de múltiplos algoritmos e, por conseguinte, avaliar em que contextos de utilização (workloads, número de nós, etc.) a replicação parcial se apresenta como uma alternativa viável a outras estratégias de replicação de dados.

The present paper presents a physical prototype that simulates the response of a single degree of freedom dynamic system, equipped with a novel semi-active vibration control device. This device comprises two superelastic NiTi elements working in phase opposition and aims to prevent deck unseating in simply supported bridges, during a seismic excitation. The special design of this device allows to avoid problems related to stress–relaxation phenomena and material degradation because of cyclic loading that have been observed in similar passive dissipation devices. The proposed design uses a strategy that permits the continuous adapting of the accumulated stress in the NiTi wires, on the basis of the response of the device to external excitations. Although unloaded, the NiTi elements remain strain/stress free, preventing stress–relaxation phenomena. With the occurrence of a dynamic excitation, a cumulative strain/stress process in the superelastic wires is initiated, enabling higher martensite transformation ratios and therefore increasing the damping capacities of the system while keeping the stresses in the wires inside a narrower superelastic window. The strain/stress accumulation in the superelastic wires is a direct result of the motion of the structure itself, with no need for external energy input.

The use of agar-based biomaterials for the development of emerging areas, such as tissue engineering or ‘smart materials’ production has recently gained great interest. Understanding how these gel-forming polysaccharides self-organise in aqueous media and how these associations can be tuned to meet the specific needs of each application is thus of great relevance. As an extension of previous pioneering research concerning the application of the microwave-assisted extraction (MAE) technique in the recovery of native (NA) and alkali-modified (AA) agars, this article focuses on the different molecular assemblies assumed by these novel NA and AA when using different MAE routes. The molecular architectures in dilute (5, 10, 50 and 100 mg mL
1) and concentrated (1.5% (w/w)) aqueous media were imaged by AFM and cryoSEM, respectively. Relevant structural and physicochemical properties were investigated to support the microscopic data. Different extraction routes led to polysaccharides with unique properties, which in turn resulted in different molecular assemblies. Even at 5 mg mL
1, AFM images included individual fibers, cyclic segments, aggregates and local networks. At higher polymer concentrations, the structures further aggregated forming multilayer polymeric networks for AA. The more compact and denser 3D networks of AA, imaged by cryoSEM, and their higher resistance to large deformations matched the 2D-shapes observed by AFM. Depending on the nature of the AA chains, homogeneous or heterogeneous growth of assemblies was seen during network formation. The obtained results support well the view of double helix formation followed by intensive double helix association proposed for agar gelation.

A new taxon of diplodocid sauropod, Kaatedocus siberi gen. et sp. nov., is recognized based on well-preserved cervical vertebrae and skull from the Morrison Formation (Kimmeridgian, Late Jurassic) of northern Wyoming, USA. A phylogenetic analysis places it inside Diplodocinae (Sauropoda: Flagellicaudata: Diplodocidae), as a sister taxon to a clade uniting Tornieria africana and the classical diplodocines Barosaurus lentus and Diplodocus. The taxon is diagnosed by a unique combination of plesiomorphic and derived traits, as well as the following unambiguous autapomorphies within Diplodocidae: frontals separated anteriorly by a U-shaped notch; squamosals restricted to the post-orbital region; presence of a postparietal foramen; a narrow, sharp and distinct sagittal nuchal crest; the paired basal tuber with a straight anterior edge in ventral view; anterior end of the prezygapophyses of mid- and posterior cervical vertebrae is often an anterior extension of the pre-epipophysis, which projects considerably anterior to the articular facet; anterodorsal corner of the lateral side of the posterior cervical vertebrae marked by a rugose tuberosity; posterior margin of the prezygapophyseal articular facet of posterior cervical vertebrae bordered posteriorly by conspicuous transverse sulcus; posterior cervical neural spines parallel to converging. The inclusion of K. siberi and several newly described characters into a previously published phylogenetic analysis recovers the new taxon as basal diplodocine, which concurs well with the low stratigraphical position of the holotype specimen. Dinheirosaurus and Supersaurus now represent the sister clade to Apatosaurus and Diplodocinae and therefore the most basal diplodocid genera. The geographical location in the less known northern parts of the Morrison Fm., where K. siberi was found, corroborates previous hypotheses on faunal provinces within the formation. The probable subadult ontogenetic stage of the holotype specimen allows analysis of ontogenetic changes and their influence on diplodocid phylogeny.

n/a