The Database Management System (DBMS) project is a Java-based application that provides essential functionalities for managing databases and tables in MongoDB. It allows users to view, insert, update, and delete data in MongoDB collections using a user-friendly interface.
-
Database Operations:
- Create Database: Users can create new databases.
- Drop Database: Existing databases can be deleted.
-
Table Operations:
- Create Table: Tables can be created within databases, with customizable attributes and primary keys.
- Drop Table: Users can delete tables from databases.
- Insert Data: Data can be inserted into tables, populating them with records.
- Delete Data: Users can delete specific records or entire rows from tables.
-
Indexing:
- Create Index: Indexes can be created on tables to improve query performance.
-
Visual editor:
- Insert Data: Data can be inserted with a visual editor into the MongoDB collection.
- Delete Data: The user can delete the data from the MongoDB via selecting the row.
-
Selection:
- Select Data: Users can retrieve specific data from tables based on specified conditions using SQL SELECT statements.
- Filtering: Data retrieval can be filtered using WHERE clauses.
- Grouping: Retrieved data can be grouped based on specific attributes using GROUP BY clauses.
- Aggregate Functions: Users can perform aggregate functions such as SUM, COUNT, AVG, etc., on selected data.
- Joins: Tables can be joined together based on common attributes to retrieve combined data.
- Installation: Clone the repository to your local machine.
git clone https://github.com/kosa12/MiniDBMS
- Run the Application: Start the application by running the main Java program. This will launch the server and the GUI.
- Connect to Database: Connect to the MongoDB database using the provided interface in the GUI.
- Visual Editor: Use the visual editor to insert, delete, or update data records in the database.
- Manual Input: Alternatively, users can input specific commands to perform CRUD operations directly.
- Interact with GUI: Explore the various features of the GUI, including data visualization, query execution, and database management.
- Java Version: Java Development Kit (JDK) 8 or later.
- Network Connectivity: Internet access is required to connect to remote MongoDB servers. Ensure firewall settings allow communication over the specified port (27017).
- Java: The core programming language used for developing the application logic and server-side functionality.
- MongoDB: A NoSQL database used for storing and managing the structured data.
- JSON: Used for data interchange between the Java application and the MongoDB database.
- Socket Programming: Implemented for client-server communication, allowing multiple clients to interact with the server concurrently.
- Swing: Java's GUI toolkit utilized for building the graphical user interface, providing components such as buttons, text fields, and tables.
This project is licensed under the MIT License