Temporal Query Processig Using Sql Server

Temporal Query Processig Using Sql Server Mastan Vali Shaik Research Scholar, VELS University , Chennai , India P Sujatha Associate Professor, VELS University , Chennai , India Abstract

Most data sources in real-life are not static but change their information in time. This evolution of data in time can give valuable insights to business analysts. Temporal data refers to data, where changes over time or temporal aspects play a central role. Temporal data denotes the evaluation of object characteristics over time. One of the main unresolved problems that arise during the data mining process is treating data that contains temporal information. Temporal queries on time evolving data are at the heart of a broad range of business and network intelligence applications ranging from consumer behaviour analysis, trend analysis, temporal pattern mining, and sentiment analysis on social media, cyber security, and network monitoring. Social networks (SN) such as Facebook, twitter, LinkedIn contains huge amount of temporal information. Social media forms a dynamic and evolving environment. Similar to real-world friendships, social media interactions evolve over time. People join or leave groups; groups expand, shrink, dissolve, or split over time. Studying the temporal behaviour of communities is necessary for a deep understanding of communities in social media(SM). In this paper we focus on the use of temporal data and temporal data mining in social networks.
01 01 2017 09 01 2017 01 01 2017 495 505 10.21307/ijssis-2017-266 http://creativecommons.org/licenses/by-nc-nd/4.0 10.21307/ijssis-2017-266 https://www.sciendo.com/article/10.21307/ijssis-2017-266 https://www.sciendo.com/pdf/10.21307/ijssis-2017-266 10.21307/ijssis-2017-210 Aizat Azmi, Ahmad Amsyar Azman, Sallehuddin Ibrahim, and Mohd Amri Md Yunus, “Techniques In Advancing The Capabilities Of Various Nitrate Detection Methods: A Review”, International Journal on Smart Sensing and Intelligent Systems., VOL. 10, NO. 2, June 2017, pp. 223-261.10.21307/ijssis-2017-210 10.21307/ijssis-2017-212 Tsugunosuke Sakai, Haruya Tamaki, Yosuke Ota, Ryohei Egusa, Shigenori Inagaki, Fusako Kusunoki, Masanori Sugimoto, Hiroshi Mizoguchi, “Eda-Based Estimation Of Visual Attention By Observation Of Eye Blink Frequency”, International Journal on Smart Sensing and Intelligent Systems., VOL. 10, NO. 2, June 2017, pp. 296-307.10.21307/ijssis-2017-212 10.21307/ijssis-2017-215 Ismail Ben Abdallah, Yassine Bouteraa, and Chokri Rekik , “Design And Development Of 3d Printed Myoelctric Robotic Exoskeleton For Hand Rehabilitation”, International Journal on Smart Sensing and Intelligent Systems., VOL. 10, NO. 2, June 2017, pp. 341-366.10.21307/ijssis-2017-215 10.21307/ijssis-2017-218 S. H. Teay, C. Batunlu and A. Albarbar, “Smart Sensing System For Enhanceing The Reliability Of Power Electronic Devices Used In Wind Turbines”, International Journal on Smart Sensing and Intelligent Systems., VOL. 10, NO. 2, June 2017, pp. 407-42410.21307/ijssis-2017-218 10.21307/ijssis-2017-200 SCihan Gercek, Djilali Kourtiche, Mustapha Nadi, Isabelle Magne, Pierre Schmitt, Martine Souques and Patrice Roth, “An In Vitro Cost-Effective Test Bench For Active Cardiac Implants, Reproducing Human Exposure To Electric Fields 50/60 Hz”, International Journal on Smart Sensing and Intelligent Systems., VOL. 10, NO. 1, March 2017, pp. 1-1710.21307/ijssis-2017-200 10.21307/ijssis-2017-201 P. Visconti, P. Primiceri, R. de Fazio and A. Lay Ekuakille, “A Solar-Powered White Led-Based Uv-Vis Spectrophotometric System Managed By Pc For Air Pollution Detection In Faraway And Unfriendly Locations”, International Journal on Smart Sensing and Intelligent Systems., VOL. 10, NO. 1, March 2017, pp. 18-4910.21307/ijssis-2017-201 10.21307/ijssis-2017-202 Samarendra Nath Sur, Rabindranath Bera and Bansibadan Maji, “Feedback Equalizer For Vehicular Channel”, International Journal on Smart Sensing and Intelligent Systems., VOL. 10, NO. 1, March 2017, pp. 50-6810.21307/ijssis-2017-202 10.21307/ijssis-2017-205 Yen-Hong A. Chen, Kai-Jan Lin and Yu-Chu M. Li, “Assessment To Effectiveness Of The New Early Streamer Emission Lightning Protection System”, International Journal on Smart Sensing and Intelligent Systems., VOL. 10, NO. 1, March 2017, pp. 108-12310.21307/ijssis-2017-205 10.21307/ijssis-2017-208 Iman Heidarpour Shahrezaei, Morteza Kazerooni and Mohsen Fallah, “A Total Quality Assessment Solution For Synthetic Aperture Radar Nlfm Waveform Generation And Evaluation In A Complex Random Media”, International Journal on Smart Sensing and Intelligent Systems., VOL. 10, NO. 1, March 2017, pp. 174-19810.21307/ijssis-2017-208 10.21307/ijssis-2017-933 P. Visconti ,R.Ferri, M.Pucciarelli and E.Venere, “Development And Characterization Of A Solar-Based Energy Harvesting And Power Management System For A Wsn Node Applied To Optimized Goods Transport And Storage”, International Journal on Smart Sensing and Intelligent Systems., VOL. 9, NO. 4, December 2016 , pp. 1637-166710.21307/ijssis-2017-933 10.21307/ijssis-2017-935 YoumeiSong,Jianbo Li, Chenglong Li, Fushu Wang, “Social Popularity Based Routing In Delay Tolerant Networks”, International Journal on Smart Sensing and Intelligent Systems., VOL. 9, NO. 4, December 2016 , pp. 1687-170910.21307/ijssis-2017-935 10.21307/ijssis-2017-938 Seifeddine Ben Warrad and OlfaBoubaker, “Full Order Unknown Inputs Observer For Multiple Time-Delay Systems”, International Journal on Smart Sensing and Intelligent Systems., VOL. 9, NO. 4, December 2016 , pp. 1750-177510.21307/ijssis-2017-938 10.1504/IJWMC.2016.081164 Rajesh, M., and J. M. Gnanasekar. “Path observation-based physical routing protocol for wireless ad hoc networks.” International Journal of Wireless and Mobile Computing 11.3 (2016): 244-257.10.1504/IJWMC.2016.081164 Rajesh, M., and J. M. Gnanasekar. “Congestion control in heterogeneous wireless ad hoc network using FRCC.” Australian Journal of Basic and Applied Sciences 9.7 (2015): 698-702. Rajesh, M., and J. M. Gnanasekar. “GCCover Heterogeneous Wireless Ad hoc Networks.” Journal of Chemical and Pharmaceutical Sciences (2015): 195-200. 10.17654/CS016120019 Rajesh, M., and J. M. Gnanasekar. “CONGESTION CONTROL USING AODV PROTOCOL SCHEME FOR WIRELESS AD-HOC NETWORK.” Advances in Computer Science and Engineering 16.1/2 (2016): 19.10.17654/CS016120019 Rajesh, M., and J. M. Gnanasekar. “An optimized congestion control and error management system for OCCEM.” International Journal of Advanced Research in IT and Engineering 4.4 (2015): 1-10. 10.13005/ojcst/901.04 Rajesh, M., and J. M. Gnanasekar. “Constructing Well-Organized Wireless Sensor Networks with Low-Level Identification.” World Engineering & Applied Sciences Journal 7.1 (2016).10.13005/ojcst/901.04 L. Jamal, M. Shamsujjoha, and H. M. Hasan Babu, “Design of optimal reversible carry lookahead adder with optimal garbage and quantum cost,” International Journal of Engineering and Technology, vol. 2, pp. 44–50, 2012. 10.1109/TIM.2009.2022103 S. N. Mahammad and K. Veezhinathan, “Constructing online testable circuits using reversible logic,” IEEE Transactions on Instrumentation and Measurement, vol. 59, pp. 101–109, 2010.10.1109/TIM.2009.2022103 10.1109/TCAD.2005.858352 W. N. N. Hung, X. Song, G. Yang, J. Yang, and M. A. Perkowski, “Optimal synthesis of multiple output boolean functions using a set of quantum gates by symbolic reachability analysis,” IEEE Trans. on CAD of Integrated Circuits and Systems, vol. 25, no. 9, pp. 1652–1663, 2006. F. Sharmin, M. M. A. Polash, M. Shamsujjoha, L. Jamal, and H. M. Hasan Babu, “Design of a compact reversible random access memory,” in 4th IEEE International Conference on Computer Science and Information Technology, vol. 10, june 2011, pp. 103–107. Dr. AntoBennet, M, Sankar Babu G, Suresh R, Mohammed Sulaiman S, Sheriff M, Janakiraman G ,Natarajan S, “Design & Testing of Tcam Faults Using TH Algorithm”, Middle-East Journal of Scientific Research 23(08): 1921-1929, August 2015 . Dr. AntoBennet, M “Power Optimization Techniques for sequential elements using pulse triggered flipflops”, International Journal of Computer & Modern Technology , Issue 01 ,Volume01 ,pp 29-40, June 2015.