Big Science Data Coming to SQL Databases

Bremen, June 17, 2014 – Multi-dimensional sensor, image, simulation output, and statistics data make up for most of the “Big Data” in science and engineering. Last week, it has been decided to extend the SQL database language with massive multi-dimensional arrays. Initiated by Prof. Peter Baumann from Jacobs University, work has commenced on the forthcoming standard named SQL/MDA.

SQL has been tremendously successful in running any-size databases in business and administration. However, the “Big Data” in science are structured differently. Instead of simple tables, they often consist of multi-dimensional “data cubes”. In Geo sciences, for example, this encompasses 1-dimensional sensor data, 2-D satellite imagery, 3-D x/y/t image timeseries as well as x/y/z geophysical voxel data, and 4-D x/y/z/t weather data. In Life sciences, there is laserscan microscopy and brain scans. And it can grow as large as simulations of the whole universe when it comes to astrophysics.

But SQL is not able to find, filter, and process such arrays, and consequently today arrays largely are maintained outside databases. Recognizing this shortcoming, Peter Baumann, Professor of Computer Science at Jacobs University Bremen, and his group have long been researching on ways to extend SQL appropriately. The rasdaman system which the group has established effectively has coined a new technology, Array Databases. In a recent technology demonstration, more than 1,000 computers have collaborated in a cloud to jointly compute the result of one single database query. This “distributed query processing” means a massive speedup, and research challenges on multi-Petabyte data cubes can be answered that hitherto were unsolvable.

Meantime, international data centers use this tool to allow scientists gain unanticipated insights into their spatio-temporal data cubes, and rasdaman installations can be found at NASA, ESA, British Geological Survey, Plymouth Marine Laboratory, Deutscher Wetterdienst, and many more.

At last week’s meeting in Beijing all national bodies participating in the SQL working group of ISO unanimously have agreed on the importance of arrays in SQL. Following thorough assessment of all options available, the group has accepted the proposal of Baumann for further elaboration. The new standard will be named ISO 9075 SQL/MDA, for “Multi-Dimensional Arrays”.



Contact:

Heike Hoenig
Media & Communication
thinkdialog!
Email: Email Contact
www.think-dialog.de
Mobil: 0157 7393 7171




Review Article Be the first to review this article
Featured Video
Editorial
Latest Blog Posts
Joseph LopezPROSTEP INC Blog
by Joseph Lopez
OpenPDM MIGRATE supports Windchill Bulk Migrator
Roberto FrazzoliMCADCafe Editorial
by Roberto Frazzoli
A closer look at CCE’s EnSuite – Cloud ReVue LiveLink
Jobs
Mechanical Engineer II for Aehr Test Systems at Fremont, California
Service Software Expert-CATIA & CAA for Dassault Systemes at Shanghai, China
Director, Industrial Machinery Solutions- SISW PLM for Siemens AG at Livonia, Michigan
Product Design Engineer - Softgoods for Apple Inc at Cupertino, California
Mechanical Engineer in HVAC – Mid-Level for Gordon Prill, Inc at Sunnyvale, California
Electrical Engineer for Dinter Engineering at Reno, Nevada
Upcoming Events
The Design. Engineer. Build. Conference at Anaheim Convention Center Anaheim CA - Aug 10 - 12, 2021
RAPID + TCT at McCormick Place Chicago IL - Sep 13 - 15, 2021
FABTECH 2021 at McCormick Place Chicago IL - Sep 13 - 16, 2021
Western Manufacturing Technology Show WMTS 2021 at Edmonton Expo Center, Edmonton Canada - Sep 14 - 16, 2021



© 2021 Internet Business Systems, Inc.
670 Aberdeen Way, Milpitas, CA 95035
+1 (408) 882-6554 — Contact Us, or visit our other sites:
AECCafe - Architectural Design and Engineering EDACafe - Electronic Design Automation GISCafe - Geographical Information Services TechJobsCafe - Technical Jobs and Resumes ShareCG - Share Computer Graphic (CG) Animation, 3D Art and 3D Models
  Privacy PolicyAdvertise