[MDEV-17467] Add linear regression functions (Full-time project) Created: 2018-10-16 Updated: 2022-04-05 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major |
| Reporter: | Ian Gilfillan | Assignee: | Nikita Malyavin |
| Resolution: | Unresolved | Votes: | 2 |
| Labels: | Compatibility, Functions, beginner-friendly, gsoc21, gsoc22 | ||
| Issue Links: |
|
||||||||
| Description |
|
The following linear regression functions exist in a number of other DBMSs, such as Oracle, PostgreSQL: REGR_SLOPE Some have also been added to Columnstore. |
| Comments |
| Comment by Vicențiu Ciorbaru [ 2018-10-19 ] |
|
Do take note that, if possible, these functions should support both addition and removal to allow fast window function execution. See Item_sum_count::add and Item_sum_count::remove for an example. If any new devs are interested in doing this, feel free to post a message here. |
| Comment by naveen [ 2018-10-29 ] |
|
I am interested in solving this. |
| Comment by Андрей [ 2018-11-08 ] |
|
Hi! I am a student from Far Eastern Federal University, Vladivostok. |
| Comment by Nikita Malyavin [ 2019-02-11 ] |
|
Unfortunately, Andrey has abandoned the scholarship, as well as this task, so it's free now. |
| Comment by Manish Rao [ 2019-02-11 ] |
|
Hey, I've experience with programming in C,C++ and Python.I'd like to work on this.I've studied DBMS as a part of the course work. |
| Comment by Rucha Deodhar [ 2019-03-10 ] |
|
Hey, I can help with this, I am good with c++. However, I am new to mariadb contributions. Can I get the link to file destination where I can find math functions? Any help is appreciated. |
| Comment by Nikita Malyavin [ 2019-11-25 ] |
|
still nobody is succeeded in beginning working on it, so applications are welcome |
| Comment by Chandan Prakash [ 2020-01-29 ] |
|
Hey , I am Chandan Prakash , new to this community. Please let me know how to get started on this issue. |
| Comment by Nikita Malyavin [ 2021-03-01 ] |
|
serg, do you propose to write those as UDFs? |
| Comment by Rajat Baxi [ 2021-03-14 ] |
|
Hello, I am Rajat Baxi, I have taken courses on Regression analysis, Programming in C/C++, and SQL. I would love to work on this project and already have MariaDB on my system. I would be grateful if anyone could guide me on how to start resolving this issue? |
| Comment by Robert Bindar [ 2021-04-08 ] |
|
Hey Rajatino16! I see you're interested in this task for GSoC 2021, thanks and sorry I totally missed your comment here. Can we please move this discussion on MariaDB Zulip? We will be in closer contact there and we won't end up in a situation like this where you ask a question and nobody sees it. Please tag my name in Zulip chat to discuss this further if you're still interested. |
| Comment by Xin Huang [ 2022-04-05 ] |
|
Hello! @Vicențiu Ciorbaru I am Xin Huang from Huazhong University of Science and Technology (HUST, China), a 1st computer graduate student. I want to work on this issue, but I am a MariaDB beginner, can you guide me on how to start this project? |