Utilizing the Binary Field to Optimize the Performance of the Relational Database

Abstract:

In practical relational database, there are many tables that the values of their most fields have only two kinds and the values of the left fields are all discrete. For this kind of table, the paper presented a new logical storage structure utilizing binary field to compress the data volume and by making binary operations and SQL statements combined to realize the new database operations to enhance their executing efficiency. Experimental results showed that the new storage structure indeed greatly reduced the physical storage space and optimized the performance of the relational database.

• Periodical: Advanced Materials Research (Volume 717)
• Pages: 633-637
• DOI: https://doi.org/10.4028/www.scientific.net/AMR.717.633
• Online since: July 2013
• Authors: Yi Xin Zhou, Xi Wang
• Keywords: Binary Field, Binary Operation, Database Operation, New Storage Structure

References

[1] WANG Shan, SA Shi-xuan: Introduction to Database System (the 4th Edition), Higher Education Press, Beijing (2006).

[2] HUANG Shao-hua, CHEN Cui-e: SQL Grammar Example Encyclopedia: General Solution of SQL Server & Oracle, Electronic Industry Press, Beijing (2008).

[3] Microsoft Corporation: MS SQL Server 2005 Books Online.

[4] DONG Jiong-ming: Binary and Logical Operation: the Base of Computer, Science Press, Beijing (1979).

[5] SHA Sha et al: Optimization of Database Performance: Principles and Techniques, Electronic Industry Press, Beijing (2004).