DID YOU KNOW? DTIC has over 3.5 million final reports on DoD funded research, development, test, and evaluation activities available to our registered users. Click HERE
to register or log in.
Meta- Analysis of Performance Characteristics of Modern Database Schemas
Industry and academia alike are more commonly using databases as solutions to advanced and complex problems. Unfortunately, not all database schemas are created equal and can yield different advantages in different areas. To try to understand what database schema might be best suited for a users needs, we sought out to distinguish how databases are measured against each other, what their performance characteristics are, and what advantages each type of database inherently possesses. To allow for the ingestion of data across the five different categories of database schemas, we used a met-analysis of past literature and aggregated the data to form the basis of data to analyze. The data was then used to compare which database schemas exhibited the best performance for accuracy, scalability, transactions, query latency, and writing latency. After analyzing the data, a mix of NoSQL databases performed the best for scalability, transactions, and query and writing latency, making them advantageous for database solutions for unique problems. Relational databases maintained the best accuracy among databases and are the cheapest solution, making them suitable for basic databasing needs. Most importantly, many applications will require some degree of individualized investigation to understand what schema would be best suited.
Approved For Public Release