Seqanswers Leaderboard Ad

Collapse

Announcement

Collapse
No announcement yet.
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Why does UCSC genome browser NOT using spatial index?

    UCSC genome browser uses binning strategy to retrieve genes more efficiently than simply creating a B-tree on the start and end coordinates. This certainly serves the purpose well because query ranges is not a strengthen of B-tree. But binning + B-tree basically provides a crude approximation to R-tree (using spatial index) that has already been implemented in MySQL. I'm wondering why is this spatial index not used in the first place? Is it because the spatial index is a relatively new feature that was not implemented in MySQL when the UCSC GB was developed? Just curious.

  • #2
    Best place to ask would be the UCSC genome browser help desk: genome at soe.ucsc.edu

    Comment


    • #3
      The major UCSC paper was published in 2002. MySQL has the spatial index since 5.0.16 if I am right. That was released in 11/2005.

      Comment

      Latest Articles

      Collapse

      • seqadmin
        Non-Coding RNA Research and Technologies
        by seqadmin




        Non-coding RNAs (ncRNAs) do not code for proteins but play important roles in numerous cellular processes including gene silencing, developmental pathways, and more. There are numerous types including microRNA (miRNA), long ncRNA (lncRNA), circular RNA (circRNA), and more. In this article, we discuss innovative ncRNA research and explore recent technological advancements that improve the study of ncRNAs.

        Nobel Prize for MicroRNA Discovery
        This week,...
        10-07-2024, 08:07 AM
      • seqadmin
        Recent Developments in Metagenomics
        by seqadmin





        Metagenomics has improved the way researchers study microorganisms across diverse environments. Historically, studying microorganisms relied on culturing them in the lab, a method that limits the investigation of many species since most are unculturable1. Metagenomics overcomes these issues by allowing the study of microorganisms regardless of their ability to be cultured or the environments they inhabit. Over time, the field has evolved, especially with the advent...
        09-23-2024, 06:35 AM

      ad_right_rmr

      Collapse

      News

      Collapse

      Topics Statistics Last Post
      Started by seqadmin, 10-11-2024, 06:55 AM
      0 responses
      11 views
      0 likes
      Last Post seqadmin  
      Started by seqadmin, 10-02-2024, 04:51 AM
      0 responses
      110 views
      0 likes
      Last Post seqadmin  
      Started by seqadmin, 10-01-2024, 07:10 AM
      0 responses
      114 views
      0 likes
      Last Post seqadmin  
      Started by seqadmin, 09-30-2024, 08:33 AM
      1 response
      121 views
      0 likes
      Last Post EmiTom
      by EmiTom
       
      Working...
      X