search

hyrise / index_selection_evaluation

Platform to evaluate index selection algorithms
MIT License
80 stars 25 forks source link

Complete Microsoft SQL Server Support #30

Open Bensk1 opened 4 years ago

Bensk1 commented 4 years ago

Currently, complete support for Microsoft server is missing even though it seems to be almost done. There is mainly an issue with hypothetical indexes not properly picked up for TPC-H queries.

Another problem is the missing functionality to predict index sizes as it is provided by HypoPG.

malingaperera commented 3 years ago

Hi @Bensk1 I want to build the support for MS SQL Server for a project of mine (I already forked your project). From a simple pass, it looks like I need to write a SQL server connector in DBMS folder. Is that all? Do you see any blockers that prevent me from using this against MS SQL Server?

Are you planning to provide the MS SQL server support anytime soon?

Bensk1 commented 3 years ago

Hi @malingaperera, thanks for your interest.

From a simple pass, it looks like I need to write a SQL server connector in DBMS folder. Is that all?

Yes, you are correct, it's mainly about writing a database adapter. Hypothetical indexes in MS SQL Server are not as straightforward as they are in PostgreSQL but it should be doable.

Do you see any blockers that prevent me from using this against MS SQL Server?

Back in March I worked on supporting SQL Server but after creating a couple of hundreds or thousands hypothetical indexes the database server reproducibly crashed and I could not figure out why. If you give me a couple of days, I could share the prototypical code (nothing sophisticated) I wrote back then.

Are you planning to provide the MS SQL server support anytime soon?

Probably not.

malingaperera commented 3 years ago

If you can share the tried code that would be great. It will reduce my development time a lot. If I manage to get it to work, I can share the resulting code with you.