SEMay 1, 2012
Migration of data for iKnow application at EURM - a case studyMarko Vučković, Toni Stojanovski
Software evolves. After many revisions and improvements software gets retired and replaced. When replacement takes place, one needs to migrate the data from the old database into the new database, so the new application can replace the old application. Student administration application (SAA) currently used by European University (EURM) has been outgrown by the university, and needs replacement. iKnow application developed as part of the iKnow Tempus project is scheduled to replace the existing Student Administration application at EURM. This paper describes the problems that were encountered while migrating the data from the old databases of SAA to the new database designed for the iKnow application. The problems were resolved using the well-known solutions typical for an ETL process, since data migration can be considered as a type of ETL process. In this paper we describe the solutions for the problems that we encountered while migrating the data.
CRMay 1, 2012
Using parallel processing for file carvingNebojša Škrbina, Toni Stojanovski
File carving is one of the most important procedures in Digital Forensic Investigation (DFI). But it is also requires the most computational resources. Parallel processing on Graphics Processing Units have proven to be many times faster than when executed on standard CPU. This paper is inspecting the algorithms and methods to use parallel processing for development of file carving tools that will do their job much faster than the conventional DFI tools.
DBFeb 15, 2012
Scalability of Data Binding in ASP.NET Web ApplicationsToni Stojanovski, Ivan Velinov, Marko Vučkovik
ASP.NET web applications typically employ server controls to provide dynamic web pages, and data-bound server controls to display and maintain database data. Most developers use default properties of ASP.NET server controls when developing web applications, which allows for rapid development of workable applications. However, creating a high-performance, multi-user, and scalable web application requires enhancement of server controls using custom-made code. In this empirical study we evaluate the impact of various technical approaches for paging and sorting functionality in data-driven ASP.NET web applications: automatic data paging and sorting in web server controls on web server; paging and sorting on database server; indexed and non-indexed database columns; clustered vs. non-clustered indices. We observed significant performance improvements when custom paging based on SQL stored procedure and clustered index is used.
SEJan 4, 2012
Rapid Application Development Using Software FactoriesToni Stojanovski, Tomislav Dzekov
Software development is still based on manufactory production, and most of the programming code is still hand-crafted. Software development is very far away from the ultimate goal of industrialization in software production, something which has been achieved long time ago in the other industries. The lack of software industrialization creates an inability to cope with fast and frequent changes in user requirements, and causes cost and time inefficiencies during their implementation. Analogous to what other industries had done long time ago, industrialization of software development has been proposed using the concept of software factories. We have accepted this vision about software factories, and developed our own software factory which produces three-layered ASP.NET web applications. In this paper we report about our experience with using this approach in the process of software development, and present comparative results on performances and deliverables in both traditional development and development using software factories.
SEJan 4, 2012
Order Handling in Convergent EnvironmentsJordan Vrtanoski, Toni Stojanovski
The rapid development of IT&T technology had big impact on the traditional telecommunications market, transforming it from monopolistic market to highly competitive high-tech market where new services are required to be created frequently. This paper aims to describe a design approach that puts order management process (as part of enterprise application integration) in function of rapid service creation. In the text we will present a framework for collaborative order handling supporting convergent services. The design splits the order handling processes in convergent environments in three business process groups: order capture, order management and order fulfillment. The paper establishes abstract framework for order handling and provides design guidelines for transaction handling implementation based on the checkpoint and inverse command strategy. The proposed design approach is based in a convergent telecommunication environment. Same principles are applicable in solving problems of collaboration in function of order processing in any given heterogeneous environment.
SEJan 1, 2012
Empirical study of performance of data binding in ASP.NET web applicationsToni Stojanovski, Marko Vučković, Ivan Velinov
Most developers use default properties of ASP.NET server controls when developing web applications. ASP.NET web applications typically employ server controls to provide dynamic web pages, and data-bound server controls to display and maintain database data. Though the default properties allow for fast creation of workable applications, creating a high-performance, multi-user, and scalable web application requires careful configuring of server controls and their enhancement using custom-made code. In providing commonly required functionality in data-driven ASP.NET web applications such as paging, sorting and filtering, our empirical study evaluated the impact of various technical approaches: automatic data binding in web server controls; data paging and sorting on web server; paging and sorting on database server; indexed and non-indexed database columns; clustered vs. non-clustered indices. The study observed significant performance differences between various technical approaches.