Export Citations
Save this search
Please login to be able to save your searches and receive alerts for new content matching your search criteria.
- research-articleAugust 2024
PHREESQL: A toolkit to efficiently compute and store geochemical speciation calculation
Computers & Geosciences (CGEO), Volume 190, Issue CAug 2024https://doi.org/10.1016/j.cageo.2024.105640AbstractBoth abiotic and biotic natural spheres benefit from the high reactivity of natural waters, which are ubiquitous on planet Earth. The use of speciation-solubility codes like PHREEQC can provide a deeper understanding of aqueous equilibria and ...
Graphical abstract
Display Omitted
Highlights- PHREESQL enables to permanently store and browse PHREEQC output in a SQL database.
- The code is released as an open source library and as a command line application.
- PHREESQL is ready to be embedded into third-party geochemical ...
- research-articleFebruary 2024
Linking Entities across Relations and Graphs
ACM Transactions on Database Systems (TODS), Volume 49, Issue 1Article No.: 2, Pages 1–50https://doi.org/10.1145/3639363This article proposes a notion of parametric simulation to link entities across a relational database 𝒟 and a graph G. Taking functions and thresholds for measuring vertex closeness, path associations, and important properties as parameters, parametric ...
- research-articleMarch 2024
Database management system performance comparisons: A systematic literature review
Journal of Systems and Software (JSSO), Volume 208, Issue CFeb 2024https://doi.org/10.1016/j.jss.2023.111872AbstractEfficiency has been a pivotal aspect of the software industry since its inception, as a system that serves the end-user fast, and the service provider cost-efficiently benefits all parties. A database management system (DBMS) is an integral part ...
- research-articleDecember 2023
Query-based denormalization using hypergraph (QBDNH): a schema transformation model for migrating relational to NoSQL databases
Knowledge and Information Systems (KAIS), Volume 66, Issue 1Jan 2024, Pages 681–722https://doi.org/10.1007/s10115-023-02017-yAbstractWith the emergence of NoSQL databases, many large applications have migrated from relational databases (RDB) due to their superior flexibility and performance. Database migration from RDB to NoSQL databases involves schema transformation and data ...
- research-articleSeptember 2023
Controlling entity integrity with key sets
Journal of Computer and System Sciences (JCSS), Volume 136, Issue CSep 2023, Pages 195–219https://doi.org/10.1016/j.jcss.2023.04.004AbstractCodd's rule of entity integrity stipulates that every table has a primary key. Key sets can control entity integrity when primary keys do not exist. While key set validation is quadratic, update maintenance for unary key sets is ...
-
- research-articleJanuary 2023
Teaching Old DB Neu(ral) Tricks: Learning Embeddings on Multi-tabular Databases
CODS-COMAD '23: Proceedings of the 6th Joint International Conference on Data Science & Management of Data (10th ACM IKDD CODS and 28th COMAD)January 2023, Pages 87–94https://doi.org/10.1145/3570991.3571041The lack of robust representation learning techniques tailored for relational data has led to the underwhelming application of ML models to handle database relevant downstream tasks. Recent works that attempt to embed tabular data into a low ...
- ArticleNovember 2022
Towards a Complete Direct Mapping from Relational Databases to Property Graphs
AbstractIt is increasingly common to find complex data represented through the graph model. Contrary to relational models, graphs offer a high capacity for executing analytical tasks on complex data. Since a huge amount of data is still presented in terms ...
- review-articleOctober 2022
RDF/OWL storage and management in relational database management systems: A comparative study
Journal of King Saud University - Computer and Information Sciences (JKSUCIS), Volume 34, Issue 9Oct 2022, Pages 7604–7620https://doi.org/10.1016/j.jksuci.2021.08.018AbstractThis paper details RDF/OWL storage and management in two popular Relational Database Management Systems (RDBMSs): Oracle and Virtuoso. Popularity, sustainability, and conformance with the SPARQL language are the main reasons for ...
- ArticleApril 2022
-join: Efficient Join with Versioned Dimension Tables
- ArticleDecember 2021
Journey of Database Migration from RDBMS to NoSQL Data Stores
Big-Data-Analytics in Astronomy, Science, and EngineeringDec 2021, Pages 159–177https://doi.org/10.1007/978-3-030-96600-3_12AbstractMigration is a complex process involving many challenges while migrating from an existing system to a new one. Database migration involves schema transformation, migration of data, complex query support, and indexing. This paper presents a) ...
- research-articleOctober 2021
Ontology learning from relational databases
Information Sciences: an International Journal (ISCI), Volume 577, Issue COct 2021, Pages 280–297https://doi.org/10.1016/j.ins.2021.06.074AbstractAn ontology is a formal, explicit specification of a shared conceptualization. Ontologies are used in many fields, such as software engineering, information extraction, semantic search, knowledge management, recommender systems, ...
- research-articleAugust 2021
Approaches to Enforce Privacy in Databases: Classical to Information Flow-Based Models
Information Systems Frontiers (KLU-ISFI), Volume 23, Issue 4Aug 2021, Pages 811–833https://doi.org/10.1007/s10796-021-10178-wAbstractEver since databases became an ubiquitous part of enterprises or businesses, security and privacy became a requirement. Traditionally, privacy was realized through various methods of database access control and relied much on the use of statically ...
- research-articleJune 2021
Some Properties Related to Reduct of Consistent Decision Systems
Cybernetics and Information Technologies (CYBAIT), Volume 21, Issue 2Jun 2021, Pages 3–9https://doi.org/10.2478/cait-2021-0015AbstractReduct of decision systems is the topic that has been attracting the interest of many researchers in data mining and machine learning for more than two decades. So far, many algorithms for finding reduct of decision systems by rough set theory ...
- research-articleFebruary 2021
Efficient local locking for massively multithreaded in-memory hash-based operators
- ArticleSeptember 2020
Verify a Valid Message in Single Tuple: A Watermarking Technique for Relational Database
Database Systems for Advanced ApplicationsSep 2020, Pages 54–71https://doi.org/10.1007/978-3-030-59410-7_4AbstractThe leakage of sensitive digital assets is a major problem which causes huge legal risk and economic loss. Service providers need to ensure data security for owners. Robust watermarking techniques play a critical role in ownership protection of ...
- ArticleJune 2020
Recommendations for Evolving Relational Databases
Advanced Information Systems EngineeringJun 2020, Pages 498–514https://doi.org/10.1007/978-3-030-49435-3_31AbstractRelational databases play a central role in many information systems. Their schemas contain structural and behavioral entity descriptions. Databases must continuously be adapted to new requirements of a world in constant change while: (1) ...
- research-articleApril 2020
Ontology of Crop Pest Control
ICISS '20: Proceedings of the 3rd International Conference on Information Science and SystemsMarch 2020, Pages 8–12https://doi.org/10.1145/3388176.3388208Domain ontology of crop pest control consists of hierarchically structured biological and chemical information and concepts on crops, pests, pest control measures and relations among them. Despite vertical relations in hierarchies, the knowledge about ...
- short-paperFebruary 2020
Generation of Test Cases for Testing SuperSQL
iiWAS2019: Proceedings of the 21st International Conference on Information Integration and Web-based Applications & ServicesDecember 2019, Pages 430–436https://doi.org/10.1145/3366030.3366131SuperSQL is an extension of SQL which generates data in various formats like HTML, PDF, XML, among many others. The same data is represented in different forms according to the user, due to which it is called a data representation and publishing ...
- research-articleDecember 2019
On the Codd semantics of SQL nulls
Information Systems (ISYS), Volume 86, Issue CDec 2019, Pages 46–60https://doi.org/10.1016/j.is.2018.08.001AbstractTheoretical models used in database research often have subtle differences with those occurring in practice. One particular mismatch that is usually neglected concerns the use of marked nulls to represent missing values in theoretical ...
Highlights- SQL nulls are commonly interpreted as non-repeating marked nulls, but even simple queries may produce answers that break this interpretation.
- short-paperSeptember 2019
Facilitating Learning by Practice and Examples: a Tool for Learning Table Normalization
BCI'19: Proceedings of the 9th Balkan Conference on InformaticsSeptember 2019, Article No.: 35, Pages 1–4https://doi.org/10.1145/3351556.3351589We describe the design and evaluation of a web-based tool to help students learn database normalization, which is an important topic in relational database design. Compared with existing systems, our tool has the advantage of allowing a user to practice ...