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 user-defined 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. One-phase commit: Does it make sense? InICPADS ’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. Sacks-Davis,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 TechnologyEDBT’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 (2014) Development of a Data Type Upgraded BIGINT to “INTCAL” Data Type in a RDBMS IJIRCST Vol-2 Issue-6 Page No-119-122] (ISSN 2347 - 5552). www.ijircst.org
Assistant Professor, MLR Institute of Technology & Management, Dundigal, Quthbullar(M),R.R.Distic,Telangana-500043.