International Journal of Innovative Research in Computer Science and Technology
Year: 2015, Volume: 3, Issue: 1
First page : ( 15) Last page : ( 19)
Online ISSN : 2350-0557.
Article Tools: Print the Abstract | Indexing metadata | How to cite item | Email this article | Post a Comment
Mr. P.Sudheer , Mr. K.LNarasimharao, Mr. Yannam Apparao
Traditional Database Management System which only provide for primitive data types such as INTEGER and CHARACTER. The data types offered in commercial database systems, CHAR INTEGER NUMBER, VARCHAR, VARCHAR2(),are sufficient for most relational database applications but range wise varing from one data type to on their data type now beginning to realize that the ability to create userdefined data types can greatly simplify their database design, in existing system the data type int range from -2,147,483,648 to 2,147,483,647. This paper proposed new data type in sql named “ INTCAL “ range between from -9,223,372,036,854,775,999 to 9,223,372,036,854,775,999.
[1]M. Abdallah, R. Guerraoui, and P. Pucheral. Onephase commit: Does it make sense? In ICPADS ’98: Proceed-ings of the 1998 International Conference on Parallel and Distributed Systems , page 182, Washington, DC, USA, 1998. IEEE Computer Society.
[2]Y. J. Al-Houmaily and P. K. Chrysanthis. 1-2pc: the one-two phase atomic commit protocol. In Proceedings of the 2004 ACM Symposium on Applied Computing (SAC), Nicosia, Cyprus, March 14-17, pages 684–691, 2004.
[3]R. Bayer, H. Heller, and A. Reiser. Parallelism and recovery in database systems.ACM Trans. Database Syst.5(2):139–156, 1980.
[4]P. A. Bernstein and N. Goodman. Multiversion concurrency control - theory and algorithms. ACM Trans.Database Syst., 8(4):465–483, 1983.
[5]P. A. Bernstein, V. Hadzilacos, and N. Goodman.Concurrency Control and Recovery in Database Systems.Addison-Wesley, 1987.
[6]W. Cellary and G. Jomier. Consistency of versions in object-oriented databases. In D. McLeod, R. SacksDavis,and H.-J. Schek, editors, 16th International Conference on Very Large Data Bases, August 13-16, 1990, Brisbane,Queensland, Australia, Proceedings, pages 432–441. Morgan Kaufmann, 1990.
[7]I.-M. A. Chen, V. M. Markowitz, S. Letovsky, P. Li, and K. H. Fasman. Version management for scientificdatabases. In P. M. G. Apers, M. Bouzeghoub, and G. Gardarin, editors,Advances in Database Technology- EDBT’96, 5th International Conference on Extending Database Technology, Avignon, France, March 25-29,1996, Proceedings ,volume 1057 ofLecture Notes in Computer Science, pages 289–303. Springer, 1996
Currently working as Assistant Professor, MLR Institute of Technology & Management, Dundigal, Quthbullar(M),R.R.Distic,Telangana-500043
No. of Downloads: 8 | No. of Views: 1405