Open Access Journal

ISSN : 2394-2320 (Online)

International Journal of Engineering Research in Computer Science and Engineering (IJERCSE)

Monthly Journal for Computer Science and Engineering

Open Access Journal

International Journal of Engineering Research in Computer Science and Engineering (IJERCSE)

Monthly Journal for Computer Science and Engineering

ISSN : 2394-2320 (Online)

Call For Paper : Vol. 9, Issue 6 , 2022
Tracking of Change in Database at API Level

Author : Miss. Shivani Dhotre 1 Prof. V. S. Mahalle 2

Date of Publication :7th March 2016

Abstract: If the rising demand of real time data by modern applications is considered, the traditional techniques of keeping applications in sync with data in database server appears insufficient. Normally in client-server architecture, client needs to check the server frequently for data change. This approach is inefficient and non-reliable as the data may get change at any time irrespective of the time at which client check the server for changed data. As this task needs to be performed frequently it consumes system resources causing performance issues. Recently, some DBMS vendors are introducing APIs to cope with this issue. Each of the vendors follows different approach. Similarly, in this paper we are looking into Event driven approach of tracking data change. This is another such efficient approach of data change tracking. To implement this approach existing DBMS needs to be added with modules written in native language and client side application also needs to be added with API to register query for data change tracking. In addition we tried to focus solution for performance issues with the previously introduced approaches by different vendors. This approach will help applications which are using DBMS which lack data change tracking functionality to fulfill real time data need.

Reference :

    1. Brenda M. Michelson, "Event-Driven Architecture Overview", Sr. VP and Sr. Consultant, Patricia Seybold Group, pp. 2-3, Feb 2006
    2. DB-Engines (2016, Feb), DB Ranking - popularity ranking of database management systems
    3. Oracle - Database Change Notification [online] https://docs.oracle.com/cd/E11882_01/java.112/e16548/ dbchgnf.htm#JJDBC28815
    4. MS SQL Server - Track Data Changes (2016, Jan) https://msdn.microsoft.com/enus/library/bb933994.aspx
    5. Cesar Galindo-Legaria, Torsten Grabs, Christian Kleinerman, Florian Waas, "Database Change Notifications: Primitives for Efficient Database Query Result Caching", Proceedings of the 31st VLDB Conference, Trondheim, Norway, 2005 pp. 1276-1277
    6. Charles A. Bell, “Expert MySQL”, USA: Apress, 2007, pp.357-389 Kalen Delaney, Microsoft® SQL Server® 2008 Internals, Microsoft Press, 2009, pp. 77-85,146, 256–260
    7. K. S. Candan, D. Agrawal, W.-S. Li, O. Po, and W.- P.Hsiung. View Invalidation for Dynamic Content Caching in Multitiered Architectures. In Proc. of the Int’l. Conf. on Very Large Data Bases, pages 562–573, 2002
    8. P.-A° Larson, J. Goldstein, and J. Zhou. MTCache: Transparent Mid-Tier Database Caching in SQL Server. In Proc. of the IEEE Int’l. Conf. on Data Engineering, pages 177–189, 2004.
    9. Q. Luo, S. Krishnamurthy, C. Mohan, H. Pirahesh, H.Woo, B. G. Lindsay, and J. F. Naughton. Middle-tier database caching for e-business. In Proc. of the ACM SIGMOD Int’l. Conf. on Management of Data, pages 600–611, 2002.

Recent Article