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
        Advanced Methods for the Detection of Infectious Disease
        by seqadmin




        The recent pandemic caused worldwide health, economic, and social disruptions with its reverberations still felt today. A key takeaway from this event is the need for accurate and accessible tools for detecting and tracking infectious diseases. Timely identification is essential for early intervention, managing outbreaks, and preventing their spread. This article reviews several valuable tools employed in the detection and surveillance of infectious diseases.
        ...
        Yesterday, 01:15 PM
      • seqadmin
        Strategies for Investigating the Microbiome
        by seqadmin




        Microbiome research has led to the discovery of important connections to human and environmental health. Sequencing has become a core investigational tool in microbiome research, a subject that we covered during a recent webinar. Our expert speakers shared a number of advancements including improved experimental workflows, research involving transmission dynamics, and invaluable analysis resources. This article recaps their informative presentations, offering insights...
        11-09-2023, 07:02 AM

      ad_right_rmr

      Collapse

      News

      Collapse

      Topics Statistics Last Post
      Started by seqadmin, Yesterday, 08:12 AM
      0 responses
      14 views
      0 likes
      Last Post seqadmin  
      Started by seqadmin, 11-22-2023, 09:29 AM
      1 response
      46 views
      0 likes
      Last Post VilliamPast  
      Started by seqadmin, 11-22-2023, 08:53 AM
      0 responses
      30 views
      0 likes
      Last Post seqadmin  
      Started by seqadmin, 11-21-2023, 08:24 AM
      0 responses
      23 views
      0 likes
      Last Post seqadmin  
      Working...
      X