A
A
Arseniy2014-05-29 09:12:15
SQL
Arseniy, 2014-05-29 09:12:15

Is it possible to pick up some kind of mat. model to the program for profiling SQL queries?

In general, this situation: At the time of taking the topic for the diploma, we were convinced that the mat. the model is not required, but almost by the time of the pre-defense, everything suddenly changed and now they do not allow if there is at least some mat in the diploma. models. I consulted with the mathematicians of my university, but as I understand it, they did not even understand what my program was about ... Please, tell me at least some kind of mat. the model is applicable to my task (absolutely any.
About the program:
The program listens on the port and intercepts all SQL queries (like MySQLProxyServer), then calculates the execution time, how much these packets weigh, how many lines came. Then it profiles and shows the query execution plan. Well and (in the future) there will be monitoring of the DBMS for load.A
few screenshots:
de35f37c0b5e4b059942e182832bb23f.jpg5f32c05090d647748a7988e130a2927a.jpg79e7d20ecdb645658951896d63527c5f.jpg

Answer the question

In order to leave comments, you need to log in

1 answer(s)
F
Fadmin, 2014-06-02
@Fadmin

I also did not really understand the essence of your program,
try to pay attention to the queries themselves and relational algebra.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question