This project is a C++ application that integrates with an Oracle database using the sqlAPI++ library. It includes a graphical user interface built using the wxWidgets library.
Query Cure is a database diagnosis tool which is made using C++. It can be installed on any client/server where the diagnosis is run. The tool will gain insights based on the database and display suggestions on how to improve the performance such as denormalization, indexing, clustering, etc. It involves the following components:
It can collect performance metrics and data from the Oracle database server. This data can include information on CPU utilization, memory usage, disk I/O, and other database-related statistics.
It can analyze the data collected and identify any performance issues or bottlenecks in the database. This can involve identifying slow-running queries, inefficient indexing, or other performance-related issues.
Once the tool has identified performance issues, it should provide recommendations for improving the performance of the database. This can include suggestions for tuning the database configuration, optimizing SQL queries, or adding or modifying database indexes.
The tool should be able to generate reports that summarize the performance of the database, including any issues that were identified and any recommendations for improvement.
It monitors the performance of the database over time and provides alerts if performance issues occur. This can include monitoring the database for spikes in resource utilization or other anomalies that could indicate a performance problem.
Used as the IDE and debugger for the project.
Used for the logic implementation and connection to SQL databases.
Used as a C++ library to implement a graphical interface.
C++ library that allows PL/SQL statements to be run from C++ functions.
Used to test the application and interact with Oracle databases.
Used to develop and test the application.
- Install Oracle Express Edition, Oracle Install Client and set up a database..
- Install wxWidgets 3.1.5 or later on your system.
- Install SQLAPI++.
- Clone this repository to your local machine
git clone https://github.com/IbrahimSiddiqui007/QueryCure.git
. - Open the solution file
*.sln
in Visual Studio 2022. - Build the project.
- Run the application.
Here are some suggestions to consider when working with this software stack:
- Consider using a version control system like Git to manage your codebase and collaborate with others.
- Be aware of the security risks associated with interacting with databases and take appropriate measures to protect sensitive data.
- Use automated testing frameworks and unit testing to ensure that the application is robust and reliable.
- Keep in mind the end-users of the application and ensure that the GUI design and user experience are intuitive and user-friendly.
- None
To contribute to this project, please submit any issues or pull requests on the GitHub repository.
This project is licensed under the GPL-3.0 license. See the LICENSE file for details.