Journal "Software Engineering"
a journal on theoretical and applied science and technology
ISSN 2220-3397

Vol. 7, no 4 2016 year

DOI: 10.17587/prin.7.167-172
Implementation of NoClone Customer Access Protocol to MS SQL Server Database
O. V. Reshetnikova, ov13r@yandex.ru, Far Eastern State Transport University, Khabarovsk, 680021, Russian Federation
Corresponding author: Reshetnikova Olga V., Associate Professor, Far Eastern State Transport University, Khabarovsk, 680021, Russian Federation, e-mail: ov13r@yandex.ru
Received on December 28, 2015
Accepted on January 13, 2016

Earlier studies on the organization of NoClone models of database access have identified the need for more detailed study in this field, requiring improvement of approaches to application implementation, including test bench. A variant of implementation of the protocol to organize client access to a database for specified NoClone models is proposed, it allows to minimize the possibility of duplicated records. This protocol allows to flexibly formulate concrete requests in accordance with desired address model and at the same time to get standard expected result sets. The interaction is carried out in the format of one-sided dialogue initiated by exchange between data packages of a fixed structure. Translation process of data packages includes a compulsory filtration stage against prescribed structures. A package transmitted via protocol is represented as XML-object and transport mechanism of Service Broker MS SQL Server component is used for its physical transmission. NoClone protocol implementation is one of the key steps to build simulation environment of software interaction objects with databases.

Keywords: disconnected data access, duplicate records, protocol for data access, XML, send/receive message, Transact SQL, parsing strings
pp. 167–172
For citation:
Reshetnikova O. V. Implementation of NoClone Customer Access Protocol to MS SQL Server Database, Programmnaya Ingeneria, 2016, vol. 7, no. 4, pp. 167-172.