From Papers to Property Tables: A Priority-Based LLM Workflow for Materials Data Extraction
Organizations: Department of Applied Mathematics and Statistics, Johns Hopkins University · Department of Mechanical Engineering, Johns Hopkins University
Abstract
Scientific data are widely dispersed across research articles and are often reported inconsistently across text, tables, and figures, making manual data extraction and aggregation slow and error-prone. We present a prompt-driven, hierarchical workflow that uses a large language model (LLM) to automatically extract and reconstruct structured, shot-level shock-physics experimental records by integrating information distributed across text, tables, figures, and physics-based derivations from full-text published research articles, using alloy spall strength as a representative case study. The pipeline targeted 37 experimentally relevant fields per shot and applied a three-level priority strategy: (T1) direct extraction from text/tables, (T2) physics-based derivation using verified governing relations, and (T3) digitization from figures when necessary. Extracted values were normalized to canonical units, tagged by priority for traceability, and validated with physics-based consistency and plausibility checks. Evaluated on a benchmark of 30 published research articles comprising 11,967 evaluated data points, the workflow achieved high overall accuracy, with priority-wise accuracies of 94.93% (T1), 92.04% (T2), and 83.49% (T3), and an overall weighted accuracy of 94.69%. Cross-model testing further indicated strong agreement for text/table and equation-derived fields, with lower agreement for figure-based extraction. Implementation through an API interface demonstrated the scalability of the approach, achieving consistent extraction performance and, in a subset of test cases, matching or exceeding chat-based accuracy. This workflow demonstrates a practical approach for converting unstructured technical literature into traceable, analysis-ready datasets without task-specific fine-tuning, enabling scalable database construction in materials science.
Figures & tables
| Extracted Field | Symbol |
|---|---|
| Metal Symbol | – |
| Sample ID | – |
| Synthesis Method | – |
| Treatment | – |
| Initial Temperature (K) | |
| Quasi-static Yield Stress (MPa) |
| Class | Rule Name | Description |
| Interpretation & Normalization | A. Symbol Disambiguation | Resolves ambiguous symbols to physical quantities |
| B. Uncertainty Extraction | Preserves original error formats (e.g., , parenthesis) | |
| Extraction Strategy & Priority | C. Data Priority | Define prioritization of extraction sources: Direct Calculated Figure |
| D. Record Identification and Grouping | Identify and extract parameters from text or tables | |
| E. Figure Extraction | Apply centroid logic to digitize data points from figures | |
| Physics Constraints & Derivations | F. Unit Conversion | Enforce canonical units across all output fields |
| Parameter | Formula (in SI units) |
|---|---|
| Longitudinal stress at HEL | |
| Shear stress at HEL | |
| Spall strength | |
| Bulk sound speed | |
| Shear modulus | |
| Bulk modulus |
Document Information Extraction
Document Information Extraction turns text, tables, forms, and images into structured, searchable data.
See all 279 papers