You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Keeping in mind of these three anomalies of a Database Management System:
Insertion
Update
Deletion
This project will be isolated in such an efficient way that making changes directly in the PictoPy application or the actual folder will not cause any issues with our application.
Implementation Idea
Insertion Anomaly
When creating an image, PictoPy stores thumbnails in the images/PictoPy.thumbnails folder instead of the actual folder. This ensures that there is no additional folder associated with PictoPy within the base folder.
Deletion Anomaly
Application Side : When users want to delete an image, they receive an alert asking whether they want to delete it from the actual folder or only from the PictoPy database. If they choose to delete it only from the database, the image will be removed from the database while remaining in the actual folder. Otherwise, it will be deleted from both the database and the actual folder.
User Side : If users manually delete images from the actual folder without removing them from the PictoPy application, a scheduled algorithm will run at regular intervals (e.g., every 24 hours). This algorithm will check whether any file paths stored in the database correspond to deleted images in the actual folder. If such images are found, they will also be removed from the database.
Since the scheduled algorithm runs periodically, PictoPy will continue displaying the image's thumbnail stored in PictoPy.thumbnails until it is processed. Additionally, a warning will be displayed alongside the image, indicating that it has been deleted from the actual folder.
Update Anomaly
Edited images will be stored in a separate folder: images/edited_images.
This approach helps in isolating the entire application efficiently.
Record
I agree to follow this project's Code of Conduct
I want to work on this issue
The text was updated successfully, but these errors were encountered:
Describe the feature
Keeping in mind of these three anomalies of a Database Management System:
This project will be isolated in such an efficient way that making changes directly in the PictoPy application or the actual folder will not cause any issues with our application.
Implementation Idea
Insertion Anomaly
When creating an image, PictoPy stores thumbnails in the images/PictoPy.thumbnails folder instead of the actual folder. This ensures that there is no additional folder associated with PictoPy within the base folder.
Deletion Anomaly
Application Side : When users want to delete an image, they receive an alert asking whether they want to delete it from the actual folder or only from the PictoPy database. If they choose to delete it only from the database, the image will be removed from the database while remaining in the actual folder. Otherwise, it will be deleted from both the database and the actual folder.
User Side : If users manually delete images from the actual folder without removing them from the PictoPy application, a scheduled algorithm will run at regular intervals (e.g., every 24 hours). This algorithm will check whether any file paths stored in the database correspond to deleted images in the actual folder. If such images are found, they will also be removed from the database.
Since the scheduled algorithm runs periodically, PictoPy will continue displaying the image's thumbnail stored in PictoPy.thumbnails until it is processed. Additionally, a warning will be displayed alongside the image, indicating that it has been deleted from the actual folder.
Update Anomaly
Edited images will be stored in a separate folder: images/edited_images.
This approach helps in isolating the entire application efficiently.
Record
The text was updated successfully, but these errors were encountered: