UNION ALL performance improvement: Business analytics often involves time-series data, which is data generated or aggregated daily, weekly, monthly or at other intervals. By storing time-series data in separate tables —one table for each time interval—and using a UNION ALL view over those tables, you can avoid potentially costly table updates. Amazon Redshift now runs UNION ALL queries up to 10 times faster if they involve joins, and up to 2 times faster if they don’t involve any joins. This performance improvement is automatic and requires no action on your part and is available in version 1.0.1057 and above. For more information about UNION ALL views and time-series tables, see Using Time-Series Tables in the Amazon Redshift Database Developer Guide.
T.J.
The best description of T.J Rodgers, the founding CEO of Cypress, is that he’s “an engineer’s engineer’. An engineer’s curiosity took him into areas like optical networking and solar power, buying optical specialist HiBand Semiconductor in 2001 and investing $8 million in Sun Power in 2002. In 2005 Sun Power had an IPO in which …
GloFo enhances 130nm SiGe RF process
GloFo has enhanced its 130nm RF SiGe process to deliver 5G performance. The technology is optimized for customers who need improved performance solutions for automotive radar, satellite communications, 5G millimeter-wave base stations and other wireless and wireline communication network applications. GLoFo’s SiGe 8XP technology is the latest extension to the company’s 130nm high-performance SiGe family …
ARM, AMD, Huawei, IBM, Qualcomm, Mellanox and Xilinx team up on datacentre
ARM, AMD, Huawei, IBM, Qualcomm, Mellanox and Xilinx have joined forces to bring a high-performance open acceleration framework to data centers. The companies are collaborating on the specification for the new Cache Coherent Interconnect for Accelerators (CCIX). For the first time in the industry, a single interconnect technology specification will ensure that processors using different …
ARM, AMD, Huawei, IBM, Qualcomm, Mellanox and Xilinx team up on datacentre
Socionext evaluation kit for 360deg WAV system
Socionext, the Panasonic-Fujitsu SoC jv, has introduced an evaluation package for its 360° Wrap-Around View (WAV) system. The package combines the hardware, software and support services necessary for initial evaluation and development of the WAV system. Customers lacking resources to evaluate the system themselves can now develop their own customized systems with this new solution. …
LoRa eval kit aimed at metro area networks
Microchip has released LoRa wireless evaluation kits, claiming them to be the first on the market. They provide all the components needed to create a low-power 10 mile range network for North America (915MHz, kit DV164140-2) or for Europe (868MHz DV164140-1). Each kit includes two wireless sensors (‘motes’) based on Microchip’s RN2483 or RN2903 LoRa …
Sounds Like Plessey
To specify Plessey loudspeakers is to ensure outstanding reliability. So, 55 years ago, ran an ad in Electronics Weekly’s edition of April 26th 1961. The ad continued: Careful design, up-to- date manufacturing methods and stringent tests together provide a service unsurpassed in the industry. Outstanding features of the latest types include a choice of motor …
Sealing nylon 3D prints
Laser sintered nylon 3D prints are porous – with a surface like Trebor mints according to 3Dprint-UK, unless they get treated in some way. Sealing the material, which seems to be it is PA2200, to stop it getting grubby or leaking water into one-off enclosures is not an exact science. 3D print firm Shapeways has …
Raspberry Pi needs 10 million connectors
A Hong Kong-based connector manufacturer says it has shipped ten millionth dual USB connectors for the Raspberry Pi. Global Connector Technology (GCT) dual, USB type A is used in the Raspberry Pi and the supplier says it has seen a big rise in sales from the multiple subcontractors handling Pi production. Two dual USB connectors …
New topology gives TI 10MHz dc-dc conversion
Texas Instruments has unveiled a new dc-dc topology, and with it is claiming industry’s highest current density for a 12V, 10A, 10MHz dc-dc converter at 50A/cm3. Similar to a two-phase buck converter, the added series capacitor allows the switching transistors to operate at half the input voltage, more than halving switching losses, TI energy systems …