Database Analysis
A database is an organized collection of structured information or data that is usually stored electronically in a computer system. The database is usually controlled by a database management system (DBMS). When the data and DBMS, as well as the associated applications, are brought together, it is often referred to as the database system, abbreviated simply as database.
Data in the most common types of databases used in operations today are often modeled in rows and columns in a series of tables to make processing and querying data efficient. Thus, data can be easily accessed, managed, changed, updated, controlled and organized. Most databases use structured query language (SQL) for data writing and querying.
After the database is designed, it should be optimized for the purposes of accessing data without loss, protecting from data duplication, ensuring data consistency, etc. This optimization process may vary according to the user scenario, needs and relationships.
Main tests:
-
Chi-square test
-
ANOVA, kappa test, Odds Ratio
-
Correlation analysis
-
ANCOVA
-
MANOVA
-
McNemar Test
-
Fisher's exact test
-
Kolmogorov- Smirnov Test
-
Binomial Test
-
Mann-Withney U Test
-
Friedman Test
-
Post-hoc Tests
-
Kruskall-Wallis Test
-
Wicoxon Test