viticulture software - vinesense
TRANSCRIPT
![Page 1: Viticulture Software - VineSense](https://reader033.vdocuments.us/reader033/viewer/2022052311/55c33545bb61eba03a8b45fb/html5/thumbnails/1.jpg)
Vinesense
Viticulture Software
- Software Maestro 5th Vinesense Team -
![Page 2: Viticulture Software - VineSense](https://reader033.vdocuments.us/reader033/viewer/2022052311/55c33545bb61eba03a8b45fb/html5/thumbnails/2.jpg)
Introduce our Team
Dooseong Eom front-end developer
Jongbeen Han front-end developer
Hyeonguk Ryu back-end developer
Jungun Park Team Leader
Wonkyun Lim researcher
![Page 3: Viticulture Software - VineSense](https://reader033.vdocuments.us/reader033/viewer/2022052311/55c33545bb61eba03a8b45fb/html5/thumbnails/3.jpg)
Introduce our Team
Sungahn Ko Postdoc
Brian Olsen Master of science student
![Page 4: Viticulture Software - VineSense](https://reader033.vdocuments.us/reader033/viewer/2022052311/55c33545bb61eba03a8b45fb/html5/thumbnails/4.jpg)
Problem state
Winemaker
“I would like to manipulate the outcome of the grape as wish” “Is there a software?”
![Page 5: Viticulture Software - VineSense](https://reader033.vdocuments.us/reader033/viewer/2022052311/55c33545bb61eba03a8b45fb/html5/thumbnails/5.jpg)
Code name : Vinesense
Get data related to grow grapes Show data on chart for analysis Then, analyze and estimate the quality of the grapes!
![Page 6: Viticulture Software - VineSense](https://reader033.vdocuments.us/reader033/viewer/2022052311/55c33545bb61eba03a8b45fb/html5/thumbnails/6.jpg)
When we arrived..
1. Desktop application based on Windows (MFC Application) 2. Used MySQL on database 3. Have Vineyard in California 4. Have Collected Data during 2 years (temperature, moisture)
(38.34942, -122.30068)
![Page 7: Viticulture Software - VineSense](https://reader033.vdocuments.us/reader033/viewer/2022052311/55c33545bb61eba03a8b45fb/html5/thumbnails/7.jpg)
Then, what can we do?
Make able to see the chart on web for winemaker anywhere, anytime!
![Page 8: Viticulture Software - VineSense](https://reader033.vdocuments.us/reader033/viewer/2022052311/55c33545bb61eba03a8b45fb/html5/thumbnails/8.jpg)
Requirement
Software part: 1. Base Framework is C++ 2. Database is MySQL 3. Their want to make software with ASP.NET 4. And Using MVC 5. Show data. Temperature, moisture, site, depth…
Research part : 1. Read thesis about wine and wine software 2. Compare with competitive software
![Page 9: Viticulture Software - VineSense](https://reader033.vdocuments.us/reader033/viewer/2022052311/55c33545bb61eba03a8b45fb/html5/thumbnails/9.jpg)
1. Market Research
2. Back-End Develop
3. Front-End Develop
![Page 10: Viticulture Software - VineSense](https://reader033.vdocuments.us/reader033/viewer/2022052311/55c33545bb61eba03a8b45fb/html5/thumbnails/10.jpg)
1. Market Research
2. Back-End Develop
3. Front-End Develop
![Page 11: Viticulture Software - VineSense](https://reader033.vdocuments.us/reader033/viewer/2022052311/55c33545bb61eba03a8b45fb/html5/thumbnails/11.jpg)
Market Research
Because we didn’t know about viticulture, grape and wine, We read articles, paper and so on. We check what elements affect the grape Specially and .
![Page 12: Viticulture Software - VineSense](https://reader033.vdocuments.us/reader033/viewer/2022052311/55c33545bb61eba03a8b45fb/html5/thumbnails/12.jpg)
Market Research
Searching for competitive products that have similar functionality to Vinesense and summarizing their pros and cons
![Page 13: Viticulture Software - VineSense](https://reader033.vdocuments.us/reader033/viewer/2022052311/55c33545bb61eba03a8b45fb/html5/thumbnails/13.jpg)
1. Market Research
2. Back-End Develop
3. Front-End Develop
![Page 14: Viticulture Software - VineSense](https://reader033.vdocuments.us/reader033/viewer/2022052311/55c33545bb61eba03a8b45fb/html5/thumbnails/14.jpg)
Back-End Develop
1. ASP.NET
2. Using MVC design pattern
3. MySQL database
Support Multi-Platform(Windows, OSX, Linux)
Support N-Screen(mobile, tablet, desktop)
Easy to deploy(just edit web server, apply anywhere)
![Page 15: Viticulture Software - VineSense](https://reader033.vdocuments.us/reader033/viewer/2022052311/55c33545bb61eba03a8b45fb/html5/thumbnails/15.jpg)
Old Schema
Back-End Develop - Problem
It is complicated. Query is slow
We need to develop a new and much improved database schema
![Page 16: Viticulture Software - VineSense](https://reader033.vdocuments.us/reader033/viewer/2022052311/55c33545bb61eba03a8b45fb/html5/thumbnails/16.jpg)
Old Schema New Schema
Improvement - Scalable sensor data
- Some query spend about 10min -> 3.172sec!
Back-End Develop - Problem
![Page 17: Viticulture Software - VineSense](https://reader033.vdocuments.us/reader033/viewer/2022052311/55c33545bb61eba03a8b45fb/html5/thumbnails/17.jpg)
1. Market Research
2. Back-End Develop
3. Front-End Develop
![Page 18: Viticulture Software - VineSense](https://reader033.vdocuments.us/reader033/viewer/2022052311/55c33545bb61eba03a8b45fb/html5/thumbnails/18.jpg)
Front-End Develop
1. Responsive web page
2. Show data by..
Underground, map, outside
Daily, Weekly, Monthly
Temperature, moisture
Depth, site
3. Using Highchart.js, moment.js
![Page 19: Viticulture Software - VineSense](https://reader033.vdocuments.us/reader033/viewer/2022052311/55c33545bb61eba03a8b45fb/html5/thumbnails/19.jpg)
Make, Break, Make
![Page 20: Viticulture Software - VineSense](https://reader033.vdocuments.us/reader033/viewer/2022052311/55c33545bb61eba03a8b45fb/html5/thumbnails/20.jpg)
We did it!
Now we give a demonstration
![Page 21: Viticulture Software - VineSense](https://reader033.vdocuments.us/reader033/viewer/2022052311/55c33545bb61eba03a8b45fb/html5/thumbnails/21.jpg)
Thank you
Vinesense
Software Maestro 5th