Theses and Dissertations

Permanent URI for this collectionhttp://ir.daiict.ac.in/handle/123456789/1

Browse

Subject: search.filters.subject.Database design

Search Results

Now showing 1 - 2 of 2
  • Thumbnail Image
    ItemOpen Access
    Secure SQL with access control for database as a service model
    (Dhirubhai Ambani Institute of Information and Communication Technology, 2014) Dave, Jay; Das, Manik Lal
    Rapid growth of internet and networking technology emerges "Software as a service model". In this model, application service providers (ASP) provides each functionality of software over internet. ASP provides access of software to users on internet. However, large data of a great number of users may raise problem of storage at ASP site. Database as a service model is more appropriate model for ASPs. This model allows all privileges of database to its users over internet. ASPs can store their large data on database provider. Database provider serves each functionality of database over network. However, this model raises problems of confidentiality of data. Confidential data of users are stored at untrusted database provider. Theft of sensitive data is possible at database provider site. An outside attacker can attack on database provider and snoops confidential data. Curious or malicious database administrator can also steal sensitive data. We studied present encryption schemes which provide confidentiality to database as a service model. First we studied scheme of Hakan, et al.[6], which provides security by storing encrypted form of whole tuple in database. However, this scheme results more computation at ASP site. Second scheme, CryptDB[7] does not have this problem. CryptDB provides security by encrypting data with different encryption methods. However, this scheme removes randomness of such cipher texts which do not need randomness removal. This issue results equality relation leakage and order relation leakage of cipher texts. We focused on solving these limitations and providing more secure scheme. We proposed solution to limitations of CryptDB. For that, ASP partitions attributes and encrypts each partition with different key. This solution makes sure by removing randomness from appropriate partition which contains such cipher texts (which need randomness removal). Cipher texts of other partition are secured with randomness. We elaborated all schemes with examples. We listed analysis of proposed solution to issue of CryptDB. We gave security proofs for our proposed solution. We also implemented a module of this scheme.
  • Thumbnail Image
    ItemOpen Access
    Design and development of an ontology for an agriculture information system
    (Dhirubhai Ambani Institute of Information and Communication Technology, 2007) Goyal, Shweta; Chaudhary, Sanjay
    Conceptual structures (Information theory); Knowledge representation (Information theory); Semantic networks (Information theory). Traditional sources of information like books, agricultural extension officer are unable to provide specific information required by a farmer. There is a need to build an ontology based agriculture information system which can provide scientific, relevant and contextual information about various aspects of crop production cycle. The aim is to develop a domain dependent ontology that will cover various aspects of crop production cycle. AGROVOC vocabulary developed by Food and Agriculture Organization is used for indexing and retrieving data in agricultural information systems. In the proposed research work, AGROVOC is used as base vocabulary to develop the proposed ontology (AGRIont). The ontology is developed by using open source tool Prot´eg´e 3.2. The ontology developed serves as a building block to an agriculture information system that answers the farmer’s queries in their own native language and helps them in making decisions about various aspects of crop production cycle. In this work, stages of ontology development, structure of ontology developed, architecture, query flow and process of query formulation for the proposed system are discussed in detail. At the end, guidelines to build an ontology, conclusions and future work are given.