A Technique for Handling the SQL Aggregate Functions over Encrypted Data

Dr. Shaukat Ali; Huma Javed; Azhar Rauf

A Technique for Handling the SQL Aggregate Functions over Encrypted Data

Dr. Shaukat Ali * §

Contact

Huma Javed

Contact

Azhar Rauf

Contact

University of Peshawar, Pakistan

A Technique for Handling the SQL Aggregate Functions over Encrypted Data

Article Fingerprint

ReserarchID

CST598EO

A Technique for Handling the SQL Aggregate Functions over Encrypted Data Banner

Key Research Insights

Synthesized scholarly intelligence & interactive research assistant

Abstract

Data is a valuable source for the development of any organization. Most of the data are stored in the databases which necessitates its security. Many techniques can be used for database security among them one is the encryption of data in tables. Encryption is an effective security layer however, it has a flaw of performance degradation. Many techniques have been suggested in the literature to improve the data retrieval process in the encrypted data column, but some problems are unresolved, for example, the aggregate functions’ query. This paper proposes a new technique to run the aggregate function of SQL directly on encrypted data. The experimental results prove the hypothesis.

References

14 Cites in Article

Reference Format

P Ambhore,B Meshram,V Waghmare (2007). A implementation of object oriented database security.
E Bertino,C Bettini,E Ferrari,P Samarati (1996). A temporal access control mechanism for database systems.
E Bertino,P Samarti,S Jajodia (1997). An extended authorization mode.
J Sloan,R Sloan (2004). A layered design of discretionary access controls with decidable properties.
D Kiely (2005). Encryption.
R Agrawal,J Kiernan,R Srikant,Y Xu (2004). Order Preserving Encryption for Numeric Data.
Qi-Chun Huang (2009). Research on ciphertext index method for relational database.
Z Sesay,J Chen,D Xu (2004). A Secure Database Encryption Scheme.
R Sion (2005). Query Execution Assurance for Outsourced Databases.
Z Wang,W Wang,B Shi (2005). Storage and Query over Encrypted Character and Numerical Data in Database in Computer and Information Technology.
Y Zhang,-X Wang,Z Niu (2008). A Secure Cipher Index over Encrypted Character Data in Database.
H Hacigumus,B Iyer,C Li,S Mehrotra (2002). Executing SQL over encrypted data in the database-service-provider model.
Y Tang,L Zhang (2005). Adaptive Bucket Formation in Encrypted Databases.
TPC Benchmark Specification.

Download References

Funding

No external funding was declared for this work.

Conflict of Interest

The authors declare no conflict of interest.

Ethical Approval

No ethics committee approval was required for this article type.

Data Availability

Not applicable for this article.

How to Cite This Article

Dr. Shaukat Ali, Huma Javed, Azhar Rauf. 1970. "A Technique for Handling the SQL Aggregate Functions over Encrypted Data". Global Journal of Computer Science and Technology GJCST Volume 10 (GJCST Volume 10 Issue 8).

More Citation Formats

Select Citation Style:

Download Citation

GJCST Volume 10 Issue 8

Explore Journals Explore Volume Read This Issue

Journal Specifications

Crossref Journal DOI 10.17406/gjcst

Print ISSN 0975-4350

e-ISSN 0975-4172

Keywords

Not Found

Submission ReceivedFebruary 4, 2010
Peer Review Double Blind
Handling Editor
Accepted February 28, 2010
Published March 15, 2010

Version of record

v1.2

Issue date

September 20, 2010

Language

English

Experiance in AR

Explore published articles in an immersive Augmented Reality environment. Our platform converts research papers into interactive 3D books, allowing readers to view and interact with content using AR and VR compatible devices.

View in VR

Read in 3D

Your published article is automatically converted into a realistic 3D book. Flip through pages and read research papers in a more engaging and interactive format.

View in 3D

Article Matrices

Total Score: 148

Country: Unknown

Subject: Global Journal of Computer Science and Technology

Authors: Dr. Shaukat Ali, Azhar Rauf, Huma Javed (PhD/Dr. count: 1)

View Count (all-time): 207

Total Views (Real + Logic): 6146

Total Downloads (simulated): 252

Publish Date: 2010 03, Mon

Monthly Totals (Real + Logic):

Month 1: 33 views
Month 2: 57 views
Month 3: 27 views
Month 4: 52 views
Month 5: 36 views
Month 6: 46 views
Month 7: 33 views
Month 8: 30 views
Month 9: 27 views
Month 10: 42 views
Month 11: 45 views
Month 12: 21 views
Month 13: 33 views
Month 14: 41 views
Month 15: 35 views
Month 16: 34 views
Month 17: 44 views
Month 18: 34 views
Month 19: 22 views
Month 20: 24 views
Month 21: 42 views
Month 22: 28 views
Month 23: 31 views
Month 24: 29 views
Month 25: 32 views
Month 26: 36 views
Month 27: 42 views
Month 28: 20 views
Month 29: 26 views
Month 30: 32 views
Month 31: 24 views
Month 32: 29 views
Month 33: 25 views
Month 34: 33 views
Month 35: 28 views
Month 36: 42 views
Month 37: 13 views
Month 38: 19 views
Month 39: 14 views
Month 40: 20 views
Month 41: 20 views
Month 42: 26 views
Month 43: 29 views
Month 44: 25 views
Month 45: 42 views
Month 46: 26 views
Month 47: 22 views
Month 48: 39 views
Month 49: 37 views
Month 50: 38 views
Month 51: 28 views
Month 52: 21 views
Month 53: 16 views
Month 54: 43 views
Month 55: 29 views
Month 56: 26 views
Month 57: 21 views
Month 58: 34 views
Month 59: 22 views
Month 60: 21 views
Month 61: 41 views
Month 62: 39 views
Month 63: 42 views
Month 64: 38 views
Month 65: 37 views
Month 66: 26 views
Month 67: 23 views
Month 68: 29 views
Month 69: 14 views
Month 70: 38 views
Month 71: 37 views
Month 72: 29 views
Month 73: 29 views
Month 74: 41 views
Month 75: 15 views
Month 76: 27 views
Month 77: 32 views
Month 78: 20 views
Month 79: 36 views
Month 80: 40 views
Month 81: 30 views
Month 82: 31 views
Month 83: 22 views
Month 84: 28 views
Month 85: 38 views
Month 86: 35 views
Month 87: 38 views
Month 88: 30 views
Month 89: 36 views
Month 90: 26 views
Month 91: 44 views
Month 92: 18 views
Month 93: 27 views
Month 94: 19 views
Month 95: 32 views
Month 96: 28 views
Month 97: 34 views
Month 98: 24 views
Month 99: 22 views
Month 100: 22 views
Month 101: 44 views
Month 102: 44 views
Month 103: 41 views
Month 104: 33 views
Month 105: 25 views
Month 106: 42 views
Month 107: 25 views
Month 108: 32 views
Month 109: 28 views
Month 110: 31 views
Month 111: 32 views
Month 112: 23 views
Month 113: 30 views
Month 114: 37 views
Month 115: 29 views
Month 116: 37 views
Month 117: 32 views
Month 118: 18 views
Month 119: 28 views
Month 120: 24 views
Month 121: 16 views
Month 122: 32 views
Month 123: 24 views
Month 124: 18 views
Month 125: 22 views
Month 126: 36 views
Month 127: 25 views
Month 128: 26 views
Month 129: 17 views
Month 130: 38 views
Month 131: 31 views
Month 132: 41 views
Month 133: 45 views
Month 134: 35 views
Month 135: 31 views
Month 136: 28 views
Month 137: 30 views
Month 138: 29 views
Month 139: 38 views
Month 140: 30 views
Month 141: 33 views
Month 142: 19 views
Month 143: 37 views
Month 144: 30 views
Month 145: 20 views
Month 146: 26 views
Month 147: 29 views
Month 148: 33 views
Month 149: 38 views
Month 150: 32 views
Month 151: 32 views
Month 152: 46 views
Month 153: 27 views
Month 154: 37 views
Month 155: 23 views
Month 156: 29 views
Month 157: 31 views
Month 158: 45 views
Month 159: 34 views
Month 160: 41 views
Month 161: 45 views
Month 162: 16 views
Month 163: 16 views
Month 164: 38 views
Month 165: 21 views
Month 166: 40 views
Month 167: 36 views
Month 168: 21 views
Month 169: 40 views
Month 170: 20 views
Month 171: 16 views
Month 172: 24 views
Month 173: 26 views
Month 174: 28 views
Month 175: 32 views
Month 176: 21 views
Month 177: 20 views
Month 178: 43 views
Month 179: 35 views
Month 180: 19 views
Month 181: 12 views
Month 182: 29 views
Month 183: 27 views
Month 184: 32 views
Month 185: 26 views
Month 186: 46 views
Month 187: 16 views
Month 188: 22 views
Month 189: 23 views
Month 190: 37 views
Month 191: 22 views
Month 192: 40 views
Month 193: 29 views
Month 194: 31 views
Month 195: 24 views
Month 196: 40 views
Month 197: 48 views
Month 198: 45 views
Month 199: 33 views

Total Views: 6.1K

Total Downloads: 252

All Trends