Abstract: A database system receives a database language query specifying a grouping clause and one or more aggregate result values. The database system generates a pre-aggregation table based on the query. The database system generates an ingest query configured to generate data for populating the pre-aggregation table and a completion query configured to processes data stored in the pre-aggregation table. The database system periodically receives a set of input records and executes the ingest query to generate a set of pre-aggregation records. The set of pre-aggregation records are combined with the pre-aggregation table. The database system executes the completion query on the data stored in the pre-aggregation table to generate a result set and sends the generated result set to the requestor of the results.

Abstract: A system stores associates a database query with a name and stores versions of the database query. The system allows applications to execute a specific version of the database query by specifying the name of the database query and a version identifier. For example, the database query may be exposed as an endpoint of a REST API and invoked using calls to the REST API. This allows the applications to be designed without including the query definition within the code of the application. Continuous delivery of database query is performed by creating a new version of the database query that are tested using applications in a test environment. Once the new version of a database query meets test criteria, the new version of the database query is executed by applications running in production environment by sending API requests that identify the query name and the new version.

Abstract: A system stores associates a database query with a name and stores versions of the database query. The system allows applications to execute a specific version of the database query by specifying the name of the database query and a version identifier. For example, the database query may be exposed as an endpoint of a REST API and invoked using calls to the REST API. This allows the applications to be designed without including the query definition within the code of the application. Continuous delivery of database query is performed by creating a new version of the database query that are tested using applications in a test environment. Once the new version of a database query meets test criteria, the new version of the database query is executed by applications running in production environment by sending API requests that identify the query name and the new version.

Abstract: A real-time analytical database system allows queries on data obtained from a transactional system that is frequently updated by the transactional system. The real-time analytical database system receives change logs from the transactional system. The change logs describe operations performed by the transactional system. The real-time analytical database system stores a plurality of indexes in a key-value store, each index comprising key-value pairs. A key of a key-value pair is obtained by combining field data describing a field of a document. The real-time analytical database system determines modifications to the key-value pairs of the key-value store corresponding to the operations of the transactional system as represented by the received change logs. The real-time analytical database system receives and processes queries using the plurality of indexes.

Abstract: A search system processes queries for accessing information stored in documents. A document comprises fields. The search system stores a plurality of indexes in a key-value store. Each index comprises key-value pairs. A key of a key-value pair is obtained by combining field data describing a field of a document. The value of each field is stored as an individual key-value in the key-value store. The search system receives a query requesting information stored in documents and specifying a search criteria. The search system builds a key-expression based on the search criteria and uses one or more indexes to find key-value pairs matching the key-expression. The search system finds the requested information based on the matching key-value pairs and provides the requested information to the query source.

Abstract: The present invention provides high-throughput systems and methods for the fabrication and evaluation of electrode and electrolyte materials for solid oxide fuel cells. The present invention includes systems and methods for synthesizing and optimizing the performance of electrodes and electrode-electrolyte combinations and utilizes small-scale techniques to perform such optimization based on chemical composition and variable processing. Advantageously, rapid device performance systems and methods coupled with structural and surface systems and methods allow for an increased discovery rate of new materials for solid oxide fuel cells.

Abstract: A method is provided that includes heating a powder to a temperature that is below the melting point of the scintillator composition but is sufficiently high to form a coherent mass. The powder includes a scintillator composition. The coherent mass is polycrystalline and has a pulse height resolution that is less than 20 percent at 662 kilo electron volts; a light yield of more than 5000 photons per milli electron volt; or both a pulse height resolution that is less than 20 percent at 662 kilo electron volts and a light yield of more than 5000 photons per milli electron. A sintered body is provided also.

Abstract: A method of making a cubic halide scintillator material includes pressing a powder mixture of cubic halide and at least one activator under conditions of pressure, temperature, residence time and particle size effective to provide a polycrystalline sintered cubic halide scintillator having a pulse height resolution of from about 7% to about 20%. The conditions include a temperature ranging from about ambient temperature up to about 90% of the melting point of the cubic halide, a pressure of from about 30,000 psi to about 200,000 psi, a pressing residence time of from about 5 minutes to about 120 minutes and an average cubic halide particle size of from about 60 micrometers to about 275 micrometers.

Abstract: A sintered, annealed scintillator composition, which, prior to annealing, has a formula of A3B2C3O12, where A is at least one member of the group consisting of Tb, Ce, and Lu, or combinations thereof, B is an octahedral site (Al), and C is a tetrahedral site (also Al). One or more substitutions are included. The substitutions may may be partial or, in some cases, complete, and can include Al with Sc at B, up to two atoms of oxygen with fluorine and the same number of Ca atoms at A, replacement at B with Mg and the same number of atoms of oxygen with fluorine, replacement at B with a combination of Mg/Si Mg/Zr, Mg/Ti, and/or Mg/Hf, replacement at B with a combination of Li/Nb and/or Li/Ta, and at A with Ca and replacement of an equal number of B or C with silicon.

Abstract: A polycrystalline transparent ceramic article including lutetium is presented. The article includes an oxide with a formula of ABO3, having type A lattice sites and type B lattice sites. The lattice site A may further comprise a plurality of elements, in addition to lutetium. Type B lattice site includes aluminum. An imaging device, a laser assembly, and a scintillator including the lutetium-based article is provided. A method of making the above article is also provided.

Abstract: Disclosed herein is a composition comprising a composition comprising a polymeric material; and a ceramic antiferroelectric particle. Disclosed herein too is a method of tuning a dielectric constant of a composition comprising subjecting a composition comprising a polymeric material and a ceramic antiferroelectric particle to a biasing electric field; and changing the dielectric constant of the composition. Disclosed herein too is a method comprising blending a polymeric material with ceramic antiferroelectric particles to form a composition. Disclosed herein too is a method comprising blending a polymeric material with ceramic antiferroelectric particles to form a composition; applying an electrical field to the composition; and reorienting the ceramic antiferroelectric particles.

Abstract: An electrochemical cell structure comprises a conductive base defining a plurality of holes passing through the conductive base and a microporous cellular substrate disposed on the conductive base. In another embodiment, an electrochemical cell structure comprises a conductive base defining a plurality of holes passing through the conductive base, a coarse microporous cellular substrate disposed on the conductive base and a fine microporous cellular substrate disposed on the coarse microporous cellular substrate.

Abstract: An etchant including a halogenated salt, such as Cryolite (Na3AlF6) or potassium tetrafluoro borate (KBF4), is provided. The salt may be present in the etchant in an amount sufficient to etch a substrate and may have a melt temperature of greater than about 200 degrees Celsius. A method of wet etching may include contacting an etchant to at least one surface of a support layer of a multi-layer laminate, wherein the support layer may include aluminum oxide; or contacting an etchant to at least one surface of a support layer of a multi-layer laminate, wherein the etchant may include Cryolite (Na3AlF6), potassium tetrafluoro borate (KBF4), or both; and etching at least a portion of the support layer. The method may provide a laminate produced by growing a crystal onto an aluminum oxide support layer, and chemically removing at least a portion of the support layer by wet etch. An electronic device, optical device or combined device including the laminate is provided.

Abstract: A scintillator composition comprising a garnet represented by (M1-x-yNxAy)3(Al5-a-bCaDb)O12, where M comprises yttrium, or terbium, or gadolinium, or holmium, or erbium, or thulium, or ytterbium, or lutetium, or combinations thereof, where N comprises additives including a lanthanide, or an alkali metal, or an alkaline earth metal, or combinations thereof, where A comprises a suitable activator ion including cerium, or europium, or praseodymium, or terbium, or ytterbium, or combinations thereof, where C or D comprises lithium, or magnesium, or gallium, or an element from group IIIa, or IVa, or Va, or IIId transition metal, or IVd transition metal, or combinations thereof, where x ranges from about 0 to about 0.90, y ranges from about 0.0005 to about 0.30, and a sum of a and b ranges from about 0 to 2.0.

Abstract: Zirconia-containing ceramic compositions that are capable of providing thermal barrier coatings wherein the zirconia is stabilized in the cubic crystalline phase. These compositions comprise at least about 50 mole % zirconia and a stabilizing amount up to about 49 mole % of a stabilizer component comprising: (1) a first metal oxide selected from the group consisting of ytterbia, neodymia, mixtures of ytterbia and neodymia, mixtures of ytterbia and lanthana, mixtures of neodymia and lanthana, and mixtures of ytterbia, neodymia and lanthana in an amount of from about 5 to about 49 mole % of the composition; and (2) a second metal oxide selected from the group consisting of yttria, calcia, ceria, scandia, magnesia, india and mixtures thereof in an amount of about 4 mole % or less of the composition. The ceramic composition further comprises one or more of a third metal oxide selected from the group consisting of: (a) hafnia in an amount from about 0.

Abstract: A method of manufacturing a detector array for an imaging system, the method comprising providing a pixelated scintillator having a plurality of lost molded pixels comprising a scintillator material adapted to detect radiation.

Abstract: A method of making a multi-cation ceramic having an average grain size of less than 1 micron is provided. The method includes the steps of providing at least a first material and a second material, wherein the first material comprises a first cation and the second material comprises a second cation, and wherein the first cation and the second cation are different from each other and each of the first material and the second material are nanopowders; forming a mixture comprising the first material and the second material; forming a green body from the mixture; and forming a dense multi-cation ceramic material comprising the first cation and the second cation, wherein the dense multi-cation ceramic material comprises a major phase comprising the first cation and the second cation and that is different from the first material and the second material. The multi-cation ceramic has a high density and high in-line transmission.

Abstract: A composition is disclosed that includes an at least partially stabilized zirconia matrix with a pentavalent oxide first dopant and an oxide second dopant. A coated article is disclosed for use in a high temperature a gas turbine. The coated article can include an yttria-stabilized zirconia, a pentavalent oxide first dopant, and an oxide second dopant. The ratio of the pentavalent oxide second dopant to the oxide third dopant can be less than or equal to about 1. The composition can reduce sintering of the thermal barrier coating.

Abstract: A scintillator composition of a halide perovskite material of at least one ABX3 type halide perovskite, at least one activator for the matrix material and optionally at least one charge compensator to assist the incorporation of the activator in the perovskite lattice and any reaction products thereof. Radiation detectors that use the scintillators are also described, as are related methods for detecting high-energy radiation and method of producing an activated halide-perovskite based scintillator crystal.

Abstract: Ceramic compositions comprising a main ceramic component comprising from about 63 to about 99 mole % zirconia and from about 1 to about 37 mole % hafnia. These compositions further comprise at least about 4 mole % of a stabilizer metal oxide selected from the group consisting of yttria, calcia, ceria, scandia, magnesia, india, lanthana, gadolinia, neodymia, samaria, dysprosia, erbia, ytterbia, europia, praseodymia, and mixtures thereof. These ceramic compositions are useful in preparing thermal barrier coatings having reduced thermal conductivity for the substrate of articles that operate at, or are exposed to, high temperatures, as well as good producibility and impact/erosion resistance. Inclusion of hafnia also maintains the reduced conductivity of the thermal barrier coating after thermal exposure due to better sintering resistance.