Download - Nautilus
![Page 1: Nautilus](https://reader035.vdocuments.us/reader035/viewer/2022062419/558951f9d8b42adf0b8b4572/html5/thumbnails/1.jpg)
Nautilus
Owner : TZOMPANAKI AIKATERINI
Understanding query results origins
2%
![Page 2: Nautilus](https://reader035.vdocuments.us/reader035/viewer/2022062419/558951f9d8b42adf0b8b4572/html5/thumbnails/2.jpg)
Nautilus
• SQL Query development tool
• Why do I receive this tuple ?
• Why don’t I receive this tuple ?
• How to get the awaited results ?
• Started 2009
• Under development
2
![Page 3: Nautilus](https://reader035.vdocuments.us/reader035/viewer/2022062419/558951f9d8b42adf0b8b4572/html5/thumbnails/3.jpg)
Code location
• Main project :https://subversion.renater.fr/nautilus/trunk
Nautilus core + Why and Why Not algorithms
• New Query based explanation algorithms (Why Not Questions)
Stored in Gforge, conseil project
3
![Page 4: Nautilus](https://reader035.vdocuments.us/reader035/viewer/2022062419/558951f9d8b42adf0b8b4572/html5/thumbnails/4.jpg)
Why Not algorithms
• TedNaive : Full coverage – Time consuminghttps://gforge.inria.fr/scm/viewvc.php/trunk/TedNaive/?root=conseil
• TedRevised : Important coverage – Improved execution timehttps://gforge.inria.fr/scm/viewvc.php/trunk/TedRevised/?root=conseil
• NedExplain : Partial coverage – FasterRIP, goodnight sweet prince.
4
![Page 5: Nautilus](https://reader035.vdocuments.us/reader035/viewer/2022062419/558951f9d8b42adf0b8b4572/html5/thumbnails/5.jpg)
Code specs
• Java (as an eclipse Plugin)
• 28K lines of code
• 230 classes
5
![Page 6: Nautilus](https://reader035.vdocuments.us/reader035/viewer/2022062419/558951f9d8b42adf0b8b4572/html5/thumbnails/6.jpg)
People involved
6
• Past contributors :• Melanie Herschel
• Abhishek Choudhari (Summer intern 2012, INRIA)
• Hanno Eichelberger (Engineer, U Tübingen)
• Mathilde Verrier (Summer intern 2013, U Paris Sud)
• Current contributor
• Katerina Tzompanaki
• Alexandre Constantin (Engineer, CNRS) (valorisation-cleaning)
![Page 7: Nautilus](https://reader035.vdocuments.us/reader035/viewer/2022062419/558951f9d8b42adf0b8b4572/html5/thumbnails/7.jpg)
Architecture
7
![Page 8: Nautilus](https://reader035.vdocuments.us/reader035/viewer/2022062419/558951f9d8b42adf0b8b4572/html5/thumbnails/8.jpg)
Explanation manager Workflow
8
GUI
SQL Query
Database conf
Algorithm type
Tuple
SQL ParserDebugging scenario
DB
SQL Query
Query object
Artemis Why-Not NedExplain
TedExplain Conquer ConseilExplanation Graph
Provenance
Why Algorithm Why Not Algorithm
![Page 9: Nautilus](https://reader035.vdocuments.us/reader035/viewer/2022062419/558951f9d8b42adf0b8b4572/html5/thumbnails/9.jpg)
Technical Dependencies
• Eclipse (bundled as a plugin)• Postgres 9.1• ZQL (java sql parser)• db2jcc• jfreechart-1.0.13• jcommon-1.0.16• jgraph• swt• swtgraphics2d
9
![Page 10: Nautilus](https://reader035.vdocuments.us/reader035/viewer/2022062419/558951f9d8b42adf0b8b4572/html5/thumbnails/10.jpg)
TODO
TedNaive:• Implement TedRevised improving execution speed
Nautilus:• Redo NedExplain algorithm• Implement the query fixing functionality
10
![Page 11: Nautilus](https://reader035.vdocuments.us/reader035/viewer/2022062419/558951f9d8b42adf0b8b4572/html5/thumbnails/11.jpg)
Known Bugs
- Database connection is not closed when finishing a query analysis
11
![Page 12: Nautilus](https://reader035.vdocuments.us/reader035/viewer/2022062419/558951f9d8b42adf0b8b4572/html5/thumbnails/12.jpg)
Fin.
12
![Page 13: Nautilus](https://reader035.vdocuments.us/reader035/viewer/2022062419/558951f9d8b42adf0b8b4572/html5/thumbnails/13.jpg)
Paper
13
http://openproceedings.org/EDBT/2014/paper_204.pdf