{"id":"https://openalex.org/W7021241883","doi":null,"title":"Natural Language Interface for Operational Forestry Data with Snowflake Cortex Analyst","display_name":"Natural Language Interface for Operational Forestry Data with Snowflake Cortex Analyst","publication_year":2024,"publication_date":"2024-01-01","ids":{"openalex":"https://openalex.org/W7021241883"},"language":"en","primary_location":{"id":"pmh:oai:www.theseus.fi:10024/873561","doi":null,"is_oa":true,"landing_page_url":"http://www.theseus.fi/handle/10024/873561","pdf_url":"http://www.theseus.fi/bitstream/10024/873561/2/Heinoja_Pyry.pdf","source":{"id":"https://openalex.org/S4306400928","display_name":"Theseus (Ammattikorkeakoulujen)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"fi=AMK-opinn\u00e4ytety\u00f6|sv=YH-examensarbete|en=Bachelor's thesis|"},"volume":null,"type":"dissertation","is_traditional":true,"indexed_in":[],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://www.theseus.fi/bitstream/10024/873561/2/Heinoja_Pyry.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":null,"display_name":"Heinoja, Pyry","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Heinoja, Pyry","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":true,"primary_topic":{"id":"https://openalex.org/T10181","display_name":"Natural Language Processing Techniques","score":0.25999999046325684,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10181","display_name":"Natural Language Processing Techniques","score":0.25999999046325684,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.20090000331401825,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.18070000410079956,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/natural-language-interfaces-to-databases","display_name":"natural language interfaces to databases","score":0.8289999961853027},{"id":"https://openalex.org/keywords/semantic-modeling","display_name":"semantic modeling","score":0.7110000252723694},{"id":"https://openalex.org/keywords/gpt-4o","display_name":"GPT-4o","score":0.8320000171661377},{"id":"https://openalex.org/keywords/non-technical-users","display_name":"non-technical users","score":0.7459999918937683},{"id":"https://openalex.org/keywords/business-rules","display_name":"business rules","score":0.33799999952316284}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7847999930381775},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.45339998602867126},{"id":"https://openalex.org/C113843644","wikidata":"https://www.wikidata.org/wiki/Q901882","display_name":"Interface (matter)","level":4,"score":0.4528999924659729},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.40459999442100525},{"id":"https://openalex.org/C174252522","wikidata":"https://www.wikidata.org/wiki/Q3816772","display_name":"Natural language user interface","level":3,"score":0.3955000042915344},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.3659000098705292},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3513999879360199},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3492000102996826},{"id":"https://openalex.org/C89505385","wikidata":"https://www.wikidata.org/wiki/Q47146","display_name":"User interface","level":2,"score":0.3391000032424927},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.3255999982357025},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.3215000033378601},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.3160000145435333},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.2994999885559082},{"id":"https://openalex.org/C137314826","wikidata":"https://www.wikidata.org/wiki/Q2330408","display_name":"Data mapping","level":2,"score":0.2825999855995178},{"id":"https://openalex.org/C90312973","wikidata":"https://www.wikidata.org/wiki/Q7449052","display_name":"Semantic data model","level":2,"score":0.27720001339912415},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.27489998936653137},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.26669999957084656},{"id":"https://openalex.org/C112972136","wikidata":"https://www.wikidata.org/wiki/Q7595718","display_name":"Stability (learning theory)","level":2,"score":0.2581999897956848},{"id":"https://openalex.org/C56288433","wikidata":"https://www.wikidata.org/wiki/Q58673","display_name":"Data manipulation language","level":2,"score":0.25769999623298645},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.25589999556541443},{"id":"https://openalex.org/C37789001","wikidata":"https://www.wikidata.org/wiki/Q782543","display_name":"Graphical user interface","level":2,"score":0.2517000138759613},{"id":"https://openalex.org/C112799922","wikidata":"https://www.wikidata.org/wiki/Q5104911","display_name":"Choquet integral","level":3,"score":0.2515000104904175},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.25130000710487366}],"mesh":[],"locations_count":1,"locations":[{"id":"pmh:oai:www.theseus.fi:10024/873561","doi":null,"is_oa":true,"landing_page_url":"http://www.theseus.fi/handle/10024/873561","pdf_url":"http://www.theseus.fi/bitstream/10024/873561/2/Heinoja_Pyry.pdf","source":{"id":"https://openalex.org/S4306400928","display_name":"Theseus (Ammattikorkeakoulujen)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"fi=AMK-opinn\u00e4ytety\u00f6|sv=YH-examensarbete|en=Bachelor's thesis|"}],"best_oa_location":{"id":"pmh:oai:www.theseus.fi:10024/873561","doi":null,"is_oa":true,"landing_page_url":"http://www.theseus.fi/handle/10024/873561","pdf_url":"http://www.theseus.fi/bitstream/10024/873561/2/Heinoja_Pyry.pdf","source":{"id":"https://openalex.org/S4306400928","display_name":"Theseus (Ammattikorkeakoulujen)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"fi=AMK-opinn\u00e4ytety\u00f6|sv=YH-examensarbete|en=Bachelor's thesis|"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W7021241883.pdf","grobid_xml":"https://content.openalex.org/works/W7021241883.grobid-xml"},"referenced_works_count":51,"referenced_works":["https://openalex.org/W1498436455","https://openalex.org/W1614298861","https://openalex.org/W1888026739","https://openalex.org/W1995341919","https://openalex.org/W2008398646","https://openalex.org/W2040870580","https://openalex.org/W2064675550","https://openalex.org/W2096178388","https://openalex.org/W2103920867","https://openalex.org/W2107878631","https://openalex.org/W2108598243","https://openalex.org/W2112796928","https://openalex.org/W2130942839","https://openalex.org/W2133564696","https://openalex.org/W2163922914","https://openalex.org/W2250539671","https://openalex.org/W2430301697","https://openalex.org/W2626778328","https://openalex.org/W2798812533","https://openalex.org/W2919115771","https://openalex.org/W2949202705","https://openalex.org/W2952380375","https://openalex.org/W2963341956","https://openalex.org/W3001279689","https://openalex.org/W3027879771","https://openalex.org/W3030163527","https://openalex.org/W3094502228","https://openalex.org/W3130319171","https://openalex.org/W3177828909","https://openalex.org/W3185341429","https://openalex.org/W4210928680","https://openalex.org/W4293819888","https://openalex.org/W4298185919","https://openalex.org/W4304194220","https://openalex.org/W4304195432","https://openalex.org/W4308672130","https://openalex.org/W4385571778","https://openalex.org/W4389984066","https://openalex.org/W4391212040","https://openalex.org/W4391876619","https://openalex.org/W4392616852","https://openalex.org/W4393065402","https://openalex.org/W4394778349","https://openalex.org/W4394867460","https://openalex.org/W4396571402","https://openalex.org/W4401306886","https://openalex.org/W4415795910","https://openalex.org/W4415798551","https://openalex.org/W7081978817","https://openalex.org/W7133224126","https://openalex.org/W7133225605"],"related_works":["https://openalex.org/W7155556877","https://openalex.org/W7106096062","https://openalex.org/W7218878642","https://openalex.org/W7168102455","https://openalex.org/W4285227295","https://openalex.org/W7083584081","https://openalex.org/W7214062957","https://openalex.org/W7202225005","https://openalex.org/W7165848495","https://openalex.org/W6903713604"],"abstract_inverted_index":{"This":[0],"thesis":[1],"investigates":[2],"the":[3,160,193,219],"development":[4,268],"and":[5,50,60,87,118,138,177,189,254,269],"evaluation":[6],"of":[7,72,115,156,171,217],"a":[8,51,68,74,78,89,107,214,262],"natural":[9,34,230],"language":[10,35,231,276],"interface":[11],"for":[12,40,209,229,264],"Ponsse's":[13,46],"customers'":[14],"forestry":[15],"operational":[16,41],"data":[17,32,48,242],"using":[18,97,275],"Snowflake's":[19],"Cortex":[20,125],"Analyst.":[21],"The":[22,43,93,233,257],"work":[23,65,220],"focuses":[24],"on":[25],"enabling":[26],"non-technical":[27],"users":[28],"to":[29,249,272],"query":[30,116,175],"structured":[31],"through":[33,106],"while":[36,159,237],"maintaining":[37],"calculation":[38,61],"reliability":[39],"decisions.":[42],"implementation":[44,216],"utilizes":[45],"Snowflake":[47],"platform":[49],"semantic":[52,85,178,250,266],"model":[53,179,267],"that":[54,111,236],"defines":[55],"domain-specific":[56,99],"terminology,":[57],"business":[58],"rules,":[59],"patterns.":[62],"\\n":[63,143,212],"\\nThe":[64,144],"involved":[66],"transforming":[67],"complex":[69],"star":[70],"schema":[71],"over":[73],"hundred":[75],"views":[76],"into":[77,102,223],"denormalized":[79],"table,":[80],"developing":[81],"an":[82,152,167],"incrementally":[83],"refined":[84],"model,":[86],"creating":[88],"comprehensive":[90],"testing":[91,252,259],"framework.":[92],"system":[94,110,255],"was":[95],"evaluated":[96],"71":[98],"questions,":[100],"categorized":[101],"three":[103],"complexity":[104,176],"levels,":[105],"custom-built":[108],"benchmarking":[109],"enabled":[112],"systematic":[113],"validation":[114],"accuracy":[117,150,165,188],"performance.":[119],"Four":[120],"configurations":[121,131,183,196],"were":[122,204],"tested,":[123],"comparing":[124],"Analyst\u2019s":[126],"default":[127,161,194],"open-source":[128,195],"models":[129],"against":[130],"with":[132,137,146,151,166],"OpenAI\u2019s":[133],"GPT-4o":[134,147,182],"enabled,":[135],"both":[136,187],"without":[139],"verified":[140],"SQL":[141],"examples.":[142],"configuration":[145,162],"achieved":[148],"88.17%":[149],"average":[153,168,207],"response":[154,169,190],"time":[155,170],"5.6":[157],"seconds,":[158],"reached":[163],"69.01%":[164],"14.1":[172],"seconds.":[173],"As":[174],"size":[180],"increased,":[181],"showed":[184,197],"stability":[185],"in":[186,200,206],"times,":[191],"whereas":[192],"significant":[198],"degradation":[199],"both.":[201],"Particular":[202],"challenges":[203],"observed":[205],"calculations":[208],"all":[210],"configurations.":[211],"\\nThrough":[213],"parallel":[215],"Vanna.AI,":[218],"provides":[221,261],"insights":[222],"multi-agent":[224],"versus":[225],"single-pass":[226],"architectural":[227],"approaches":[228],"interfaces.":[232],"findings":[234],"show":[235],"these":[238],"interfaces":[239],"can":[240],"improve":[241],"access,":[243],"building":[244],"them":[245],"requires":[246],"careful":[247],"attention":[248],"modeling,":[251],"methods,":[253],"design.":[256],"developed":[258],"framework":[260],"foundation":[263],"future":[265],"is":[270],"adaptable":[271],"other":[273],"systems":[274],"models.":[277]},"counts_by_year":[],"updated_date":"2026-11-07T11:25:07.637180","created_date":"2025-10-10T00:00:00"}