skip to main content
10.1145/3221269.3222332acmotherconferencesArticle/Chapter ViewAbstractPublication PagesssdbmConference Proceedingsconference-collections
demonstration

Federated database system for scientific data

Published: 09 July 2018 Publication History

Abstract

Much like traditional databases, scientific data are managed in multiple separate databases by different sources and organizations. When such distributed data are analyzed together for more comprehensive understanding and prediction, it is necessary to access data via multiple simultaneous connections or collected in a single location. The inevitable consequence is, however, that a significant overhead is incurred due to differences in schemas, data transformation, and extraneous cost for storing intermediate data. This demo presents SDF, Scientific Database in Federation, which facilitates data sharing and exchange in order to support complex analytics with minimal integration overhead. SDF is currently implemented in SciDB using user-defined operators, providing two connection models, master-to-master and cluster-to-master, for a shared-nothing architecture.

References

[1]
Paul G Brown. 2010. Overview of SciDB: Large Scale Array Storage, Processing and Analysis. In Proceedings of the 2010 ACM SIGMOD Conference. ACM, Indianapolis, indiana, USA, 963--968.
[2]
Philippe Cudre-Mauroux, Hideaki Kimura, Kian-Tat Lim, Jennie Rogers, Samuel Madden, Michael Stonebraker, Stanley B Zdonik, and Paul G Brown. 2010. SS-DB: A Standard Science DBMS Benchmark. Extremely Large Databases Conference 2010.
[3]
Jennie Duggan, Aaron J Elmore, Michael Stonebraker, Magda Balazinska, Bill Howe, Jeremy Kepner, Sam Madden, David Maier, Tim Mattson, and Stan Zdonik. 2015. The BigDAWG Polystore System. ACM Sigmod Record 44, 2 (2015), 11--16.
[4]
MySQL. 2017. Federated Storage Engine of MySQL. https://dev.mysql.com/doc/refman/5.7/en/federated-storage-engine.html. (2017).
[5]
PostgreSQL. 2017. PostgreSQL 9.6.1 Documentation. https://www.postgresql.org/docs/9.6/static/postgres-fdw.html. (2017).
[6]
Amit P Sheth and James A Larson. 1990. Federated Database Systems for Managing Distributed, Heterogeneous, and Autonomous Databases. ACM Computing Surveys (CSUR) 22, 3 (1990), 183--236.

Cited By

View all
  • (2022)On Kubernetes-aided Federated Database Systems2022 IEEE International Conference on Cloud Computing Technology and Science (CloudCom)10.1109/CloudCom55334.2022.00011(1-8)Online publication date: Dec-2022
  • (2022)Federal database system based on foreign data wrapper2022 International Conference on Frontiers of Communications, Information System and Data Science (CISDS)10.1109/CISDS57597.2022.00025(112-116)Online publication date: Nov-2022
  • (2021)Efficient Approximate Range Aggregation over Large-scale Spatial Data FederationIEEE Transactions on Knowledge and Data Engineering10.1109/TKDE.2021.3084141(1-1)Online publication date: 2021

Index Terms

  1. Federated database system for scientific data

    Recommendations

    Comments

    Information & Contributors

    Information

    Published In

    cover image ACM Other conferences
    SSDBM '18: Proceedings of the 30th International Conference on Scientific and Statistical Database Management
    July 2018
    314 pages
    ISBN:9781450365055
    DOI:10.1145/3221269
    Permission to make digital or hard copies of part or all of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for third-party components of this work must be honored. For all other uses, contact the Owner/Author.

    Publisher

    Association for Computing Machinery

    New York, NY, United States

    Publication History

    Published: 09 July 2018

    Check for updates

    Author Tags

    1. SciDB
    2. federated database system
    3. scientific data

    Qualifiers

    • Demonstration

    Funding Sources

    Conference

    SSDBM '18

    Acceptance Rates

    SSDBM '18 Paper Acceptance Rate 30 of 75 submissions, 40%;
    Overall Acceptance Rate 56 of 146 submissions, 38%

    Contributors

    Other Metrics

    Bibliometrics & Citations

    Bibliometrics

    Article Metrics

    • Downloads (Last 12 months)5
    • Downloads (Last 6 weeks)1
    Reflects downloads up to 17 Jan 2025

    Other Metrics

    Citations

    Cited By

    View all
    • (2022)On Kubernetes-aided Federated Database Systems2022 IEEE International Conference on Cloud Computing Technology and Science (CloudCom)10.1109/CloudCom55334.2022.00011(1-8)Online publication date: Dec-2022
    • (2022)Federal database system based on foreign data wrapper2022 International Conference on Frontiers of Communications, Information System and Data Science (CISDS)10.1109/CISDS57597.2022.00025(112-116)Online publication date: Nov-2022
    • (2021)Efficient Approximate Range Aggregation over Large-scale Spatial Data FederationIEEE Transactions on Knowledge and Data Engineering10.1109/TKDE.2021.3084141(1-1)Online publication date: 2021

    View Options

    Login options

    View options

    PDF

    View or Download as a PDF file.

    PDF

    eReader

    View online with eReader.

    eReader

    Media

    Figures

    Other

    Tables

    Share

    Share

    Share this Publication link

    Share on social media