Skip to main content
SpringerLink
Log in

proSQLite: Prolog File Based Databases via an SQLite Interface

  • Conference paper
Practical Aspects of Declarative Languages (PADL 2013)

Part of the book series: Lecture Notes in Computer Science ((LNPSE,volume 7752))

Included in the following conference series:

Abstract

We present a succinct yet powerful interface library to the SQLite database system. The single file, server-less approach of SQLite along with the natural integration of relational data within Prolog, render the library a useful addition to the existing database libraries in modern open-source engines. We detail the architecture and predicates of the library and provide example deployment scenarios. A simple bioinformatics example is presented throughout to illustrate proSQLitet’s main functions. Finally, this paper discusses the strengths of the system and highlights possible extensions.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 49.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Allen, G., Owens, M.: The Definitive Guide to SQLite (2010)

    Google Scholar 

  2. Angelopoulos, N., Costa, V.S., Camacho, R., Wielemaker, J., Azevedo, J., Wessels, L.: Integrative statistics for logical reasoning (2012), Conditional accept PADL 2013

    Google Scholar 

  3. Angelopoulos, N., Taylor, P.: An extensible web interface for databases and its application to storing biochemical data. In: WLPE 2010, Edinburgh, Scotland (July 2010)

    Google Scholar 

  4. Cabeza, D., Hermenegildo, M.: Distributed WWW programming using Ciao Prolog and the PiLLoW library. Theory and Practice of Logic Programming 1(3), 251–282 (2001)

    Article  Google Scholar 

  5. Costa, J., Rocha, R.: Global Storing Mechanisms for Tabled Evaluation. In: Garcia de la Banda, M., Pontelli, E. (eds.) ICLP 2008. LNCS, vol. 5366, pp. 708–712. Springer, Heidelberg (2008)

    Chapter  Google Scholar 

  6. Costa, V.S., Rocha, R., Damas, L.: The YAP Prolog system. Journal of Theory and Practice of Logic Programming 12, 5–34 (2012)

    Article  MathSciNet  MATH  Google Scholar 

  7. Draxler, C.: Accessing Relational and Higher Databases Through Database Set Predicates. PhD thesis, Zurich University (1991)

    Google Scholar 

  8. Gray, P.M.D., Lucas, R.J. (eds.): Prolog and Databases, Implementations and New Directions. Ellis Horwood Ltd., Chichester (1988)

    Google Scholar 

  9. Gray, P.M.D., Kemp, G.J.L., Rawlings, C.J., Brown, N.P., Sander, C., Thornton, J.M., Orengo, C.M., Wodak, S.J., Richelle, J.: Macromolecular structure information and databases. Trends in Biochemical Sciences 21, 251–256 (1996)

    Article  Google Scholar 

  10. Kemp, G.J.L., Iriarte, J.J., Gray, P.M.D.: Efficient Access to FDM Objects Stored in a Relational Database. In: Bowers, D.S. (ed.) BNCOD 1994. LNCS, vol. 826, pp. 170–186. Springer, Heidelberg (1994)

    Chapter  Google Scholar 

  11. Keshava Prasad, T.S., Goel, R., Kandasamy, K., Keerthikumar, S., Kumar, S.: Human protein reference database 2009 update. Nucleic Acids Research 37(suppl. 1), D767–D772 (2009)

    Google Scholar 

  12. Lucas, R., Keylink Computers Ltd: ProDBI: ODBC Interface for Quintus Prolog. Keylink Computers Ltd., Kenilworth (1997)

    Google Scholar 

  13. Mungall, C.: Experiences using logic programming in bioinformatics. In: Hill, P.M., Warren, D.S. (eds.) ICLP 2009. LNCS, vol. 5649, pp. 1–21. Springer, Heidelberg (2009)

    Chapter  Google Scholar 

  14. Szklarczyk, D., Franceschini, A., Kuhn, M., Simonovic, M., Roth, A., Minguez, P., Doerks, T.: The STRING database in 2011: functional interaction networks of proteins, globally integrated and scored. Nucleic Acids Research 39(suppl. 1), D561–D568 (2011)

    Google Scholar 

  15. The UniProt Consortium. Reorganizing the protein space at the universal protein resource (uniprot). Nucleic Acids Res. 40, D71–D75 (2012)

    Google Scholar 

  16. Wielemaker, J., Costa, V.S.: On the portability of prolog applications. In: Rocha, R., Launchbury, J. (eds.) PADL 2011. LNCS, vol. 6539, pp. 69–83. Springer, Heidelberg (2011)

    Chapter  Google Scholar 

  17. Wielemaker, J., Huang, Z., van der Meij, L.: SWI-Prolog and the Web. Theory and Practice of Logic Programming 8(3), 363–392 (2008)

    Article  MathSciNet  MATH  Google Scholar 

  18. Wielemaker, J., Schrijvers, T., Triska, M., Lager, T.: SWI-Prolog. Theory and Practice of Logic Programming 12(1-2), 67–96 (2012)

    Article  MathSciNet  MATH  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Bioinformatics and Statistics, Netherlands Cancer Institute, Amsterdam, Netherlands

    Sander Canisius, Nicos Angelopoulos & Lodewyk Wessels

  2. The Netherlands Consortium for Systems Biology (NCSB), Netherlands

    Nicos Angelopoulos & Lodewyk Wessels

Authors
  1. Sander Canisius
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Nicos Angelopoulos
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Lodewyk Wessels
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Department of Information Technology, Uppsala University, Box 337, 751 05, Uppsala, Sweden

    Kostis Sagonas

Rights and permissions

Reprints and permissions

Copyright information

© 2013 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Canisius, S., Angelopoulos, N., Wessels, L. (2013). proSQLite: Prolog File Based Databases via an SQLite Interface. In: Sagonas, K. (eds) Practical Aspects of Declarative Languages. PADL 2013. Lecture Notes in Computer Science, vol 7752. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-45284-0_15

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-45284-0_15

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-45283-3

  • Online ISBN: 978-3-642-45284-0

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation