Data Manipulation Languages as an Analytical Visualization Tool in the Geosciences: A Case Study of the Seismic Catalog of the University of São Paulo Seismology Center
Background: Scientific figures are often treated as illustrations, although their evidential value depends on whether they can be traced to, and regenerated from, the underlying data. Methods: We evaluated a catalog of 4986 seismic events recorded by the Seismology Center of the University of São Paulo (USP) between 22 May 2023 and 21 May 2026, stored in a dimensional Data Warehouse and analyzed with SQL-based OLAP queries (aggregations by year, magnitude scale, region, weekday, semester and author; contingency tables; continuous percentiles; Top-N rankings). Results: The queries reproduced well-established seismological patterns: shallow events (≤10 km; 52.2%) of moderate to strong magnitude predominated (median 4.81), epicenters traced plate boundaries, and Brazilian intraplate events were weaker than international ones. The same queries exposed two data-quality problems: duplicated spellings of an author name and eight magnitude scales instead of the six defined in the model. Conclusions: Mediating visualization through data manipulation languages gives figures reproducibility, traceability, computational accuracy and, in principle, scalability, and adds a diagnostic capacity that purely illustrative charts lack. These languages are therefore a central methodological tool for environmental and geological data analysis, with reliability that remains conditional on the quality of data loading and modeling.
Authors
- Marcelo Augusto de Araújo (ORCID: https://orcid.org/0009-0007-7803-6141)
Publication Details
- Journal
- Preprints.org
- Published
- 2026-11-17
- DOI
- https://doi.org/10.20944/preprints202611.1611.v1
- Primary Topic
- Scientific Computing and Data Management
- Type
- preprint