NA-MIC/ProjectWeek
Jan 2025 – Jan 2025
1 Month active
Languages Used
MarkdownPythonSQL
Technical Skills
BigQueryDICOMDICOM MetadataData EngineeringDatabase ManagementDatabase Querying
Marco Nolden
PROFILE
Marco Nolden
Developed a consolidated, user-facing documentation feature for the NA-MIC/ProjectWeek repository, focusing on DICOM metadata database workflows and SQLite usage. The work provided practical guidance on generating DICOM JSON representations and explored SQLite’s JSONB capabilities, with attention to compatibility issues such as numeric-key handling. Included were sample SQL queries for both SQLite and BigQuery to identify image types, count images and series by modality, and locate series containing the LOCALIZER ImageType. Supplemented documentation with a Python script demonstrating how to populate a SQLite database with DICOM JSON data, emphasizing clarity, reproducibility, and future experiment directions in data engineering contexts.
Overall Statistics
Feature vs Bugs
100%Features
Repository Contributions
3Total
Bugs
0
Commits
3
Features
1
Lines of code
184
Activity Months1
Your Network
62 peopleSame Organization
@dkfz-heidelberg.de20
Work History
January 2025
3 Commits • 1 Features
Jan 1, 2025January 2025 summary for NA-MIC/ProjectWeek: Focused on delivering a consolidated, user-facing feature for DICOM Metadata Databases Documentation and SQLite Usage. Key deliverables include guidance on generating DICOM JSON representations, exploration of SQLite JSONB capabilities, and sample SQL queries for SQLite and BigQuery to identify image types within DICOM datasets, with notes on potential pitfalls with numeric keys. Extended coverage includes SQL queries to count images and series per modality and to locate series containing a LOCALIZER ImageType; included findings, future experiment ideas, and a Python script demonstrating how to populate a SQLite database with JSON representations of DICOM files. Commits reflect a documentation-centric approach (Progress report; Update README.md; Update README.md).
3 Commits • 1 Features
Jan 1, 2025January 2025 summary for NA-MIC/ProjectWeek: Focused on delivering a consolidated, user-facing feature for DICOM Metadata Databases Documentation and SQLite Usage. Key deliverables include guidance on generating DICOM JSON representations, exploration of SQLite JSONB capabilities, and sample SQL queries for SQLite and BigQuery to identify image types within DICOM datasets, with notes on potential pitfalls with numeric keys. Extended coverage includes SQL queries to count images and series per modality and to locate series containing a LOCALIZER ImageType; included findings, future experiment ideas, and a Python script demonstrating how to populate a SQLite database with JSON representations of DICOM files. Commits reflect a documentation-centric approach (Progress report; Update README.md; Update README.md).
January 2025
Activity
Loading activity data...
Quality Metrics
Correctness86.6%
Maintainability86.6%
Architecture80.0%
Performance73.4%
AI Usage20.0%
Skills & Technologies
Programming Languages
MarkdownPythonSQL
Technical Skills
BigQueryDICOMDICOM MetadataData EngineeringDatabase ManagementDatabase QueryingJSONPython ScriptingSQLite
Repositories Contributed To
Overview of all repositories you've contributed to across your timeline