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.
Abstract: Modelling of building processes of a multimodal
freight transportation support information system is discussed based
on modern CASE technologies. Functional efficiencies of ports in
the eastern part of the Black Sea are analyzed taking into account
their ecological, seasonal, resource usage parameters. By resources,
we mean capacities of berths, cranes, automotive transport, as well as
work crews and neighbouring airports. For the purpose of designing
database of computer support system for Managerial (Logistics)
function, using Object-Role Modeling (ORM) tool (NORMA–Natural ORM Architecture) is proposed, after which Entity
Relationship Model (ERM) is generated in automated process.
Software is developed based on Process-Oriented and Service-Oriented architecture, in Visual Studio.NET environment.
Abstract: Data warehouse is a dedicated database used for querying and reporting. Queries in this environment show special characteristics such as multidimensionality and aggregation. Exploiting the nature of queries, in this paper we propose a query driven design framework. The proposed framework is general and allows a designer to generate a schema based on a set of queries.