Development of a Data Type Upgraded BIGINT to INTCAL Data Type in A RDBMS
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.
RDBMS, sql, data bases, tables, columns, Data types and records
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.
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.
R. Bayer, H. Heller, and A. Reiser. Parallelism and recovery in database systems.ACM Trans. Database Syst.5(2):139–156, 1980.
P. A. Bernstein and N. Goodman. Multiversion concurrency control - theory and algorithms. ACM Trans.Database Syst., 8(4):465–483, 1983.
P. A. Bernstein, V. Hadzilacos, and N. Goodman.Concurrency Control and Recovery in Database Systems.Addison-Wesley, 1987.
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.
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
[Mr. P.Sudheer , Mr. K.LNarasimharao, Mr. Yannam Apparao (2015) Development of a Data Type Upgraded BIGINT to INTCAL Data Type in A RDBMS IJIRCST Vol-3 Issue-1 Page No-15-19] (ISSN 2347 - 5552). www.ijircst.org
Currently working as Assistant Professor, MLR Institute of Technology & Management, Dundigal, Quthbullar(M),R.R.Distic,Telangana-500043