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)

          4 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


          3. A Canon across the board printer is great for both the home and office. Furthermore, all ij.start.cannon printers are viable with practically every major operating system, including Windows, Android, and Apple iOS. A Canon printer will likewise give you the best quality and speed when printing document. Printing task can be finished rapidly and effectively with Canon printers.

            ReplyDelete