惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

Y
Y Combinator Blog
The GitHub Blog
The GitHub Blog
Vercel News
Vercel News
D
DataBreaches.Net
MongoDB | Blog
MongoDB | Blog
H
Help Net Security
小众软件
小众软件
美团技术团队
T
The Blog of Author Tim Ferriss
爱范儿
爱范儿
D
Docker
Martin Fowler
Martin Fowler
大猫的无限游戏
大猫的无限游戏
博客园 - 聂微东
Blog — PlanetScale
Blog — PlanetScale
H
Hackread – Cybersecurity News, Data Breaches, AI and More
罗磊的独立博客
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
V
V2EX
S
SegmentFault 最新的问题
云风的 BLOG
云风的 BLOG
B
Blog
雷峰网
雷峰网
The Cloudflare Blog

DEV Community

Authentication Security Deep Dive: From Brute Force to Salted Hashing (With Java Examples) Why AI Systems Don’t Fail — They Drift Spilling beans for how i learn for exam😁"Reinforcement Learning Cheat Sheet" I Replaced Chrome with Safari for AI Browser Automation. Here's What Broke (and What Finally Worked) How Python Borrows Other People's Work The $40 Architecture: Processing 1 Billion API Requests with 99.99% Uptime Vibe Coding: A Workflow Guide (From Zero to SaaS) Most webhook security guides protect the wrong side. The scary part is delivery. Headless CMS for TanStack Start: Build a Blog with Cosmic EU Age Verification App "Hacked in 2 Minutes" — What Actually Happened Comfy Cloud’s delete function does not actually remove files Running AI Models on GPU Cloud Servers: A Beginner Guide Event-driven media intelligence with AWS Step Functions and Bedrock I scored 500 AI prompts across 8 quality dimensions — here's what broke How to Call Google Gemini API from Next.js (Free Tier, No Backend Needed) The Portal Protocol: Reclaiming Human Connection in the Age of AI How to Fix Your Team's Scattered Knowledge Problem With a Self-Hosted Forum Intro to tc Cloud Functors: A Graph-First Mental Model for the Modern Cloud Designing Multi-Tenant Backends With Both Ownership and Team Access I Built a Neumorphic CSS Library with 77+ Components — Here's What I Learned PostgreSQL Performance Optimization: Why Connection Pooling Is Critical at Scale Cómo construí un SaaS multi-rubro para gestionar expensas en Argentina con FastAPI + Vue 3 🚀 I Built an Ethical Hacking Scanner Tool – Open Source Project I Replaced /usage and /context in Claude Code With a Single Statusline A Pythonic Way to Handle Emails (IMAP/SMTP) with Auto-Discovery and AI-Ready Design I Collected 8.9 Million Polymarket Price Points — Here's What I Found About How Markets Really Move EcoTrack AI — Carbon Footprint Tracker & Dashboard Everyone's Using AI. No One Agrees How. 5 self-hosted ebook managers worth trying in 2026 Building Your First AI Agent with LangChain: From Chatbot to Autonomous Assistant
Integrated Biological Data Collection Platform: An Archit...
Jeferson F Silva · 2026-06-01 · via DEV Community

Introduction

In contemporary research, the volume of biological data deposited in public repositories is growing exponentially. The Gene Expression Omnibus (GEO), NCBI Gene, PubMed, and UniProt accumulate thousands of new records daily, including sequences, expression profiles, scientific articles, and functional annotations. On the one hand, this scenario represents a unique opportunity for biomedical research. On the other hand, the diversity of data formats, access protocols, and metadata models creates a significant barrier: each source requires a specific collector, distinct rate-limiting strategies, and its own validation logic. Above all, the lack of standardization in data storage compromises the reproducibility of scientific studies. The need for integrated tools capable of unifying data extraction, curation, and persistence has been widely discussed. In practice, ad hoc solutions such as isolated scripts for individual repositories generate redundant work and make maintenance difficult. First and foremost, it is necessary to establish an architecture that treats data collection as a service rather than a collection of scattered artifacts.

This work presents Project 1 of the Integrated Bioinformatics Platform: a containerized Biomedical Data Collector coupled with a Data Lake. Its objective is to provide a REST API capable of triggering asynchronous data collections from the four aforementioned sources, storing immutable raw data in MinIO, and persisting metadata in PostgreSQL, all while ensuring traceability and resilience.

Development

The system architecture is divided into three main layers. The first is the API and orchestration layer, implemented using FastAPI. Its five endpoints — POST /collections, GET /collections, GET /collections/{id}, GET /collections/{id}/download/{dataset_id}, and GET /health — expose a clean interface for initiating and monitoring collection processes. The second layer is the collector engine, composed of abstract classes and concrete implementations for GEO, NCBI Gene, PubMed, and UniProt. Each collector follows the same lifecycle: fetch, validate, upload, and metadata generation. The third layer is the Data Lake, built on MinIO for object storage and PostgreSQL for relational metadata management. Docker Compose orchestrates the three primary services — API, PostgreSQL, and MinIO — as well as a one-shot job responsible for creating the raw-data bucket.

Furthermore, the collection workflow was designed with resilience in mind. When a user submits a POST request containing a source and an external_id, the system creates a Collection(status=pending) record in PostgreSQL and launches an asynchronous background task. This task updates the status to running, downloads data from the external source using configurable exponential retry and backoff mechanisms, validates both format and content, uploads the data to MinIO under the path raw/{source}/{external_id}/, and generates a metadata.json file alongside the collected data. Finally, it inserts the corresponding Dataset records and marks the collection as completed. In case of failure, the status is changed to failed, and the error message is preserved for later inspection.

The technology stack was selected carefully. The uv dependency manager was chosen due to its speed and reproducible lockfile mechanism. SQLAlchemy 2.0 in asynchronous mode, combined with Alembic migrations, provides a robust persistence layer. Pydantic v2 integrates seamlessly with FastAPI, allowing the same schemas to be reused for validation and automatic documentation. Testing frameworks such as pytest, httpx, pytest-asyncio, and respx enable HTTP request mocking without depending on external repositories. Meanwhile, ruff unifies linting and formatting, and mypy ensures type safety throughout the codebase.

As a result, the project directory structure reflects a clear separation of responsibilities. The app/ directory contains the submodules models/, schemas/, api/, collectors/, storage/, and utils/. Each collector resides in its own package — geo/, ncbi_gene/, pubmed/, and uniprot/ — facilitating the addition of new data sources in the future. The test suite mirrors the same organization, with dedicated modules for collectors, API functionality, and storage components.

Several design decisions are particularly important for scientific reproducibility. First, raw data immutability is enforced: once stored in MinIO, files cannot be modified. Every collection operation generates new files, even when the same external_id has already been collected. Likewise, the accompanying metadata.json file contains fields such as source, date, version, and parameters, ensuring complete data provenance. Additionally, fixing the random seed with random.seed(42) guarantees reproducibility for any sampling procedures that may occur. Consequently, researchers can trust that the same parameters will always produce identical datasets over time.

The data model itself is concise and functional. The Collection table stores a UUID identifier, source (geo, ncbi_gene, pubmed, or uniprot), external ID, status (pending, running, completed, or failed), MinIO storage path, JSONB metadata, error messages, and creation/update timestamps. The Dataset table, linked through a foreign key to Collection, records each individual file, including its name, format, size, SHA-256 checksum, and full MinIO path.

As a consequence, researchers can track the progress of any collection using simple HTTP requests. A Bash script utilizing curl and jq can initiate a collection, poll for completion, and list generated datasets in just a few lines of code. Both synchronous and asynchronous Python clients are also supported, as demonstrated in the usage documentation.

Conclusion

Project 1 establishes the foundation upon which the remaining fifteen projects of the platform will be built. In summary, it addresses the challenge of fragmented biological data sources by providing a unified API, immutable storage, and standardized metadata management. In this context, future projects focused on genomics, transcriptomics, proteomics, biomarker discovery, biological networks, molecular docking, and related domains will be able to consume curated and traceable datasets directly from the Data Lake. As a result, operational bottlenecks are eliminated, and the integrity, documentation, and reproducibility of raw data—the cornerstone of any scientific analysis—are ensured. Ultimately, Project 1 is far more than a data collector; it serves as the backbone of the entire Integrated Bioinformatics Platform.