Integrity for Join Queries in the Cloud

INTEGRITY FOR JOIN QUERIES IN THE CLOUD

ABSTRACT:

We address the problem of providing users with the ability to assess the integrity of join results produced by external computational providers and computed over externally stored databases. Our approach relies on different mutually supporting

techniques offering strong integrity protection guarantees at a limited cost. The application of the approach is completely transparent to the computational provider, against which data and query confidentiality are preserved. The paper introduces our techniques analytically, examining their protection guarantees and performance. It also illustrates experimental results, which confirm the effectiveness and efficiency of our solutions.

 

 EXISTING SYSTEM:

Cloud technology can see effective and widespread exploitation only if users have guarantees on the correct and proper working of the external services. The problem of providing integrity and confidentiality guarantees in distributed settings has been receiving considerable attention in recent years. Most solutions have addressed the protection of data confidentiality, typically against honest-but-curious servers and assuming a single cloud provider.

While research has focused on solutions assuming a single provider of cloud services, the market shows today a clear evolution toward the creation of a varied ecosystem, with the availability of a multitude of services managed by independent providers allowing selective adoption of functional abilities

DISADVANTAGES OF EXISTING SYSTEM:

   Work addressing integrity protection has mainly considered the problem of detecting possible misbehavior of the server storing the data, often assuming prior knowledge of the user on the data externally stored.

PROPOSED SYSTEM:

Providing protection guarantees, we enable users and companies to enjoy the benefit of the cloud marked and dynamically choose among available services the one that is less expensive for running their queries over external data. Our approach can also find application in a hybrid cloud scenario, enabling the cost benefits of public cloud providers and the level of trust that can be obtained from a private infrastructure. This work is in line with recent analyses that emphasize how query optimization in cloud scenarios should move from an analysis of computational costs to an analysis of economic costs.

ADVANTAGES OF PROPOSED SYSTEM:

v Detaching computation from storage, while ensuring security and privacy,

v Our solution supports the realization of a flexible market in cloud computation services, enabling users to acquire services from different providers with a significant economic gain.

SYSTEM ARCHITECTURE:

ALGORITHM:

SYSTEM CONFIGURATION:-

HARDWARE REQUIREMENTS:-

 ü Processor                  -        Pentium –IV

ü Speed                        -        1.1 Ghz

ü RAM                         -        512 MB(min)

ü Hard Disk                 -        40 GB

ü Key Board                -        Standard Windows Keyboard

ü Mouse                       -        Two or Three Button Mouse

ü Monitor                     -        LCD/LED

 SOFTWARE REQUIREMENTS:

 •         Operating system :         Windows XP.

•         Coding Language :         C#.Net.

•         Data Base             :         SQL Server 2005

•         Tool                     :         VISUAL STUDIO 2008.

REFERENCE:

Sabrina De Capitani di Vimercati, Sara Foresti, Sushil Jajodia, Stefano Paraboschi, and Pierangela Samarati, “Integrity for Join Queries in the Cloud”, IEEE TRANSACTIONS ON Cloud Computing, VOL 1,ISS 2, FEBRAURY 2013