Abstract: A computer implemented method receives a query to perform a join operation that joins a first table with a second table based on matching values in a selected column of the first table with values in a selected column of the second table, obtains a first dictionary for the selected column of the first table and a second dictionary for the selected column of the second table, and determines an output size of the join operation based on the first dictionary and the second dictionary. A dictionary for a given column includes a plurality of unique values in the given column and corresponding range indices. A count of a given unique value in the given column is mapped to a range associated with a range index corresponding to the given unique value. Related systems and software for implementing the method are also disclosed.

Abstract: A system and method including receiving a parameterized query including at least one parameter; determining a selectivity for variant filters associated with the parameterized query, the variant filters having at least a minimum influence threshold on a query plan optimization for the parameterized query; determining, based on the determined selectivity for the variant filters associated with the parameterized query, whether there is a cache hit or a cache miss with a cached query plan and a query plan of the parameterized query; in response to determining there is a cache hit, fetching the cached query plan and executing the cached query plan for the parameterized query; and in response to determining there is a cache miss, compiling and executing the query plan for the parameterized query.

Abstract: A solid state drive device includes a housing defining an interior space and first through fourth edges defining a perimeter thereof; and a package substrate module in the interior space. The package substrate module includes a package base substrate, a plurality of semiconductor chips mounted on the package base substrate, and an external connector corresponding to the third edge of the housing. The housing includes at least one groove adjacent to the first edge and a rail unit on each of the second and fourth edges.

Abstract: A solid state drive (SSD) device includes nonvolatile memory devices, a controller, a main power supply circuit and an auxiliary reprogram device. The controller controls the nonvolatile memory devices. The main power supply circuit provides an operation voltage to the nonvolatile memory devices and the controller using a supply voltage provided through a power line. The auxiliary reprogram device provides an auxiliary supply voltage to the nonvolatile memory devices and the controller and generates a reprogram command. The controller is configured to, if the SSD is not powered, perform periodically at a first period a reprogram operation on the nonvolatile memory devices.

Abstract: A beamformer for performing analog beamforming of ultrasound signals received from a plurality of transducer devices, the beamformer includes: first analog devices configured to output first ultrasound signals by delaying or transmitting the ultrasound signals based on a predetermined delay time; second analog devices configured to store first sub-ultrasound signals from among the first ultrasound signals, and to output the first sub-ultrasound signals depending on whether the first sub-ultrasound signals are repeatedly used; and a processor configured to control the delay time, and to perform the analog beamforming by summing the first ultrasound signals which correspond to the plurality of transducer devices and which are outputted depending on the delay time.

Abstract: A solid state drive device includes a housing defining an interior space and first through fourth edges defining a perimeter thereof; and a package substrate module in the interior space. The package substrate module includes a package base substrate, a plurality of semiconductor chips mounted on the package base substrate, and an external connector corresponding to the third edge of the housing. The housing includes at least one groove adjacent to the first edge and a rail unit on each of the second and fourth edges.

Abstract: A display apparatus includes a display unit, and a stand configured to support the display unit to stand on a horizontal plane, wherein the stand includes a first stand member and a second stand member coupled with each other in a front-rear direction.

Abstract: A printed circuit board (PCB) is disclosed on which various kinds of electronic components having diverse specifications may be mounted. The PCB includes a substrate base and a pad group formed on a surface of the substrate base. The pad group includes at least two pads. Each of the at least two pads includes a first sub-pad portion and a second sub-pad portion. The first sub-pad portion partially surrounds the second sub-pad portion. The second sub-pad portion of one of the at least two pads protrudes from an end portion of the first sub-pad portion toward another pad of the at least two pads.

Abstract: Disclosed is an electrolyte comprising (a) a eutectic mixture of an amide compound represented by the following chemical formula 1 or 2 and an ionizable lithium salt; and (b) a nitrile compound. The eutectic mixture and the nitrile compound in the electrolyte contribute to excellent thermal and chemical stability and sufficiently low viscosity and high ion conductivity. The electrolyte can be usefully applied as an electrolyte of electrochemical devices.

Abstract: An ultrasound probe includes a plurality of transducer elements configured to transmit ultrasound waves to an object and receive ultrasound echo signals corresponding to the transmitted ultrasound waves from the object, wherein the plurality of transducer elements are classified to be included in a plurality of first sub-arrays, a plurality of first analog beamformers configured to generate first synthesized signals by performing first beamforming on each of the ultrasound echo signals received by the plurality of transducer elements included in each of the plurality of the first sub-arrays, and a second analog beamformer configured to generate a second synthesized signal by performing second beamforming on the first synthesized signals generated by the plurality of first analog beamformers.

Abstract: A display apparatus includes a display unit, and a stand configured to support the display unit to stand on a horizontal plane, wherein the stand includes a first stand member and a second stand member coupled with each other in a front-rear direction.

Abstract: An electrolyte includes an eutectic mixture composed of (a) a hetero cyclic compound having a predetermined chemistry figure, and (b) an ionizable lithium salt. An electrochemical device having the electrolyte. The eutectic mixture included in the electrolyte exhibits inherent characteristics of an eutectic mixture such as excellent thermal stability and excellent chemical stability, thereby improving the problems such as evaporation, ignition and side reaction of an electrolyte caused by the usage of existing organic solvents.

Abstract: A solid state drive (SSD) device includes nonvolatile memory devices, a controller, a main power supply circuit and an auxiliary reprogram device. The controller controls the nonvolatile memory devices. The main power supply circuit provides an operation voltage to the nonvolatile memory devices and the controller using a supply voltage provided through a power line. The auxiliary reprogram device provides an auxiliary supply voltage to the nonvolatile memory devices and the controller and generates a reprogram command. The controller is configured to, if the SSD is not powered, perform periodically at a first period a reprogram operation on the nonvolatile memory devices.

Abstract: A printed circuit board (PCB) is disclosed on which various kinds of electronic components having diverse specifications may be mounted. The PCB includes a substrate base a substrate base and a pad group formed on a surface of the substrate base. The pad group includes at least two pads. Each of the at least two pads includes a first sub-pad portion and a second sub-pad portion. The first sub-pad portion partially surrounds the second sub-pad portion. The second sub-pad portion of one of the at least two pads protrudes from an end portion of the first sub-pad portion toward another pad of the at least two pads.

Abstract: A beamformer for performing analog beamforming of ultrasound signals received from a plurality of transducer devices, the beamformer includes: first analog devices configured to output first ultrasound signals by delaying or transmitting the ultrasound signals based on a predetermined delay time; second analog devices configured to store first sub-ultrasound signals from among the first ultrasound signals, and to output the first sub-ultrasound signals depending on whether the first sub-ultrasound signals are repeatedly used; and a processor configured to control the delay time, and to perform the analog beamforming by summing the first ultrasound signals which correspond to the plurality of transducer devices and which are outputted depending on the delay time.

Abstract: An electrode assembly and a method of manufacturing the same are provided. The electrode assembly includes a first electrode laminate formed by stacking one or more electrode units having a first area, and a second electrode laminate formed by stacking one or more electrode units having a second area different from the first area. The first electrode laminate and the second electrode laminate are stacked on each other in a direction perpendicular to a plane and have a step portion formed by a difference in areas of the first and second electrode laminates, the step portion is present on at least one side of four sides of the electrode assembly, at least one step portion includes at least a portion of tape taped across a stacked side, and the portion of tape has a form corresponding to a stepped shape of the step portion.

Abstract: A broadcast receiving apparatus is provided, which includes an interface unit connected to a server; a storage unit storing information on the broadcast receiving apparatus, a display unit displaying a UI (User Interface) for selecting the information on the broadcast receiving apparatus, and a control unit controlling the interface unit to transfer the information on the broadcast receiving apparatus selected through the UI to the server.

Abstract: An electrode assembly and a method of manufacturing the same are provided. The electrode assembly includes a first electrode laminate formed by stacking one or more electrode units having a first area, and a second electrode laminate formed by stacking one or more electrode units having a second area different from the first area. The first electrode laminate and the second electrode laminate are stacked on each other in a direction perpendicular to a plane and have a step portion formed by a difference in areas of the first and second electrode laminates, the step portion is present on at least one side of four sides of the electrode assembly, at least one step portion includes at least a portion of tape taped across a stacked side, and the portion of tape has a form corresponding to a stepped shape of the step portion.