LBSZone - Location and Privacy

Location Technology, Privacy, & Security

  • NEWS
    • Business
    • mobile mapping
    • fleet management
    • iOS
    • Android
    • Developer
    • infographics
  • Features
    • AroundtheWeb
  • Telematics
  • Drones
  • Events
  • Blog
  • CAREERS
    • Work from home
  • Subscribe
    • Weekly Newsletter
    • LBSzone Daily News Update
    • LBSzone PR Contacts
    • RSS
  • About Us
    • Partners Sites
      • GISuser
      • GeoJobsBIZ
      • LiDAR news
      • Amerisurv
    • Advertise
    • LBSzone Online Media Kit
    • Event Media Partner
You are here: Home / Press / Business / Big Science Data Coming to SQL Databases

Big Science Data Coming to SQL Databases

June 20, 2014 By LBSzone

Bremen, June 17 – 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”.

Email: info@think-dialog.de
www.think-dialog.de





Related articles:

  • A general idea about Operational DatabasesA general idea about Operational Databases
  • Dev Tip – Coursera Data Analysis Specialization TrackDev Tip – Coursera Data Analysis Specialization Track
  • Dev Tp – Week-end Tech Reading: Suggested Free ResourcesDev Tp – Week-end Tech Reading: Suggested Free Resources
  • Samsung PhD Fellowship Program Recognizes Best and Brightest Student InnovatorsSamsung PhD Fellowship Program Recognizes Best and Brightest Student Innovators
  • Hidden Genius Project, and Code.org join to host Hour of Code during Computer Science WeekHidden Genius Project, and Code.org join to host Hour of Code during Computer Science Week
  • Intel® RealSense™ Technology Extends to New Platforms and DevicesIntel® RealSense™ Technology Extends to New Platforms and Devices

Filed Under: Business, Developer

Recent Posts

Tracking #COVID-19 Vaccinations with the I Got Vaccinated map

Free dog walking app raises $30,000 to end shelter dog killing

Semtech and Digital Matter Announce New Battery-Powered Indoor/Outdoor Asset Tracker Using LoRa Edge™

SPOT Partners With Battlbox to Drive Awareness of Winter Safety

Telenav to Provide EV Navigation for Xpeng’s European Customers


shop for geogeek swag

twitter

Location Tech News

Tracking #COVID-19 Vaccinations with the I Got Vaccinated map

Free dog walking app raises $30,000 to end shelter dog killing

Semtech and Digital Matter Announce New Battery-Powered Indoor/Outdoor Asset Tracker Using LoRa Edge™

SPOT Partners With Battlbox to Drive Awareness of Winter Safety

Telenav to Provide EV Navigation for Xpeng’s European Customers

Everbridge Unveils Next-Generation Front-End Alerting Interface for Industry-Leading Global Public Warning Platform

Tuya Smart Releases New Smart Outdoor Solutions During CES 2021

More Posts from this Category

Copyright Spatial Media LLC 2003 - 2015