Automation of Web-Portal Construction Processes with SQL Server for the Black Sea Ecosystem Monitoring

Authors: Gia Surguladze, Nino Topuria, Ana Gavardashvili, Tsatsa Namchevadze

Abstract:

The present article discusses design and development of Information System for monitoring ecology within the Black Sea basin of Georgia. Sea parameters, river, estuary, vulnerable district, water sample, etc. were considered as the major parameters of the sea ecosystem. A conceptual schema has been developed for the Black Sea ecosystem based on object-role model. The experimental database for the Black Sea ecosystem has been constructed using Ms SQL Server, while the object-role model NORMA has been developed using graphical instrument Ms Visual Studio within the integrated environment of .NET Framework 4.5. Web portal has been designed based on Ms SharePoint Server. The server database connection with web-portal has been carried out by means of External List of Ms SharePoint Server Designer.

Keywords: Web-application, service-oriented architecture, database, object-role modelling, SharePoint, Black sea, river, estuary, ecology, monitoring system, automation of data processing.

Digital Object Identifier (DOI): doi.org/10.5281/zenodo.1317228

References:

[1] Surguladze G., Turqia E., Topuria N., Gavardashvili A. Construction of the Multimedia Databases and Users Interfaces for Ecological System of Black Sea with Orm/Erm. in ebook “Information and Computer Technology, Modeling and Control”. ISBN: 978-1-53612-094-3. Series: Computer Science, Technology and Applications. Nova Science Publishers. © Copyright, 2017, 3rd Quarter. USA. cht.45, - pp.1-8
[2] Supatashvili G., Kajaia G. Environment and People. TSU Publishing House, Tbilisi, 2001.
[3] Gavardashvili A.G. The Program Software to Create United Database of Black Sea Ecological Characteristics. Collected Papers of Water Management Iinstitute of Georgian Technical University, # 68, Tbilisi, 2013, pp. 27-32.
[4] Chogovadze G., Prangishvili A., Surguladze G. Hybrid Software Technologies and Data Engineering for Management Information Systems. ISBN 978-9941-20-790-7. Georgian Technical University. © Publication House "Technical University", Tbilisi, 2017. -1001 p.
[5] Namchevadze Ts., Gobiani I., Abuladze T. The Questions of Relational Databases Projection. VIII Intern. Scientific and Practical Conf., "Internet and Society", Akaki Tsereteli State University, Kutaisi, 2017, pp.204-206.
[6] Surguladze G., Topuria N., Gavardashvili A. Determination of the Ecological Parameters of the Black Sea and Designing its Multimedia Base based on the Object-Role Modeling, XXVII Intern.Conf., “Problems of Decision Making under Uncertainties”, Kiev-Batumi. 2016, pp.65-68
[7] Halpin T. ORM 2 Graphical Notation, Neumont University. 2005, http://www.orm.net/pdf/ORM2_TechReport1.pdf.
[8] Surguladze G., Topuria N., Meladze G. Database Management Systems Structures Design: ORM/ERM, Ms SQL Server. GTU, Tbilisi, 2007, http://www.gtu.edu.ge/katedrebi/¬kat94/pdf/OrmErm-31.pdf.
[9] Wedekind H., Surguladze G., Topuria N. Design and Implementation of Distributed Office-systems Databases with UML-technology. GTU, "Technical University", Tbilisi, 2006.
[10] Topuria N., Business Processes Automation SharePoint Server-based, GTU, "Technical University", monography, Tbilisi. 2017.
[11] Gavardashvili A. Results of the field-and-scientific study in the water area of the estuaries of the major rivers of the Black Sea and sea ports on the territory of Georgia. 17th Intern. Conf. on „Environmental Sciences and Engineering“. Paris, FRANCE, 2015, pp. 2305-2309.
[12] Gavardashvili A. The Research of Black Sea Ecological Condition in the Border of Georgia by Using of Reliability and Risk Theory. 19th Intern.Conf. on „Environmental Sciences and Engineering“. Amsterdam, The Netherlands, 2017, pp. 2095-2099.