Speaker / Predavač : Danica Porobić
Title / Naslov: Mathematical algorithms in SQL Server
Abstract / Abstrakt:
In the first part of this talk we will present data types that model geometrical and geographical data in SQL Server 2008 database management system, as well as basic operation on that data. Emphasis will be put on set theorethical and numerical operations. Although these operations are mathematically trivial, complex algorithms are needed in order to achieve industry strength stability and robustness. In the second part of this talk we will present work in the area of large scale data analysis on an ordinary desktop computer. Modern applications for statistical and data mining do not take full advantage of the modern hardware trends. One approach that will be presented is the solution based on extensibility features of SQL Server which enables efficient processing of large ammounts of data.***Primena matematickih algoritama u SQL Serveru ***U prvom delu ovog izlaganja bice predstavljeni tipovi podataka koji opisuju geometrijske i geografske podatke u sistemu za upravljanje bazama podataka SQL Server 2008 i osnovne operacije nad njima. Bice stavljen akcenat na algoritme koji se koriste za skupovne i numericke operacije. Iako su ove operacije relativno jednostavne potrebni su kompleksni algoritmi da bi se dobila dovoljno stabilna implementacija za komercijalnu primenu. U drugom delu bice dat kratak pregled rada na temu analize velike kolicine podataka na obicnom licnom racunaru. Uocene su mane popularnih programa za statisticka i data mining proracunavanja koji ne mogu da iskoriste mogucnosti modernih visejezgarnih procesora. Bice prikazano jedno resenje bazirano na mogucnosti za prosirenje SQL Server sistema korisnickim programima koje omogucava obradu mnogo vece kolicine podataka.