The application is in restaurant.py . The files.txt (eg AFORA.txt) are the data from the random generator to fill the database in the code insert_data_from_file.py or ins_r1.py, ins_r2.py . The r20, r1000, r5000 (_index / _noindex .db) are the databases each with and without indexes that are used at the files time_query1(/2/3).py for statistics reasons about the need of indexes that are shown in file diagram_time.py . Also, there are some extra queries in SQL in files SQL_queries.py and SQL_queries_new.py.
-
Notifications
You must be signed in to change notification settings - Fork 0
This application manages restaurant reservations, optimizes table allocation (including table merging for larger groups), and handles customer reviews. It evaluates query performance for operations with varying database sizes (20, 1,000, and 5,000 records) both with and without indexing, providing insights into database optimization.
georgiabasa/restaurant
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
About
This application manages restaurant reservations, optimizes table allocation (including table merging for larger groups), and handles customer reviews. It evaluates query performance for operations with varying database sizes (20, 1,000, and 5,000 records) both with and without indexing, providing insights into database optimization.
Topics
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published