Sunday, October 28, 2012

Episode 20: Query Languages


Download

News
Tool of the Biweek

Query Languages

History
  • SQL
    • Used to query databases
  • SPARQL
    • Used to query semantic webs

    Features
    • Can be interfaced from multiple different systems
    • Can be Transactional

        Strengths
        • Designed to handle large amount of data efficiently

        Weaknesses
        • Relational vs Non Relational
        • Maintenance Costs

          Tools
          • SQL Database Engines
            • SQLite, Mysql, postgresql
          • NoSQL query languages
            • HiveQL, CassandraQL
          • SPARQL Engines
            • SPARQL Engine (Java)

          Uses
          • Web Projects
            • wordpress, django, phpbb
          • Semantic Web Analysis
            • dbpedia (semantic web version of wikipedia)

          2 comments:

          1. I love your show and usually listen it trough a podcast APP.
            This is the first time i go to the site and i have one remark.
            A grey download text in the grey background make it really hard to find.

            ReplyDelete
          2. Awesome show guys! I just started listening a few days ago to this episode and it got me thinking about how I am structuring a database for a project I am working on. I was wondering if you could cover a few topics a bit further in detail for SQL databases: Triggers and Creating a secure log-in within SQL.

            Thanks and keep up the great work!

            Jake

            ReplyDelete