Database As A Service Research Articles

Implementing Encrypted Database for Concurrent Access in Cloud Environment

Background/Objectives: Database as a Service (DBaaS) model is used to manage databases in public cloud environment. Placing critical data on the cloud environment outside the organization that should have guarantee that data is secure, confidential and available at any time to legitimate user. User should be able to retrieve cloud database efficiently. Methods: Architecture proposed in this work provides data confidentiality for cloud databases. It is designed to allow multiple and independent clients to connect to the cloud without intermediate server. Data is encrypted before upload to the cloud. Multiple cryptography techniques are used to convert plaintext into encrypted data. Data will not be exposed to the cloud provider and any other public user who are not registered to access the database. Encrypted query submission model is used to secure the query values and maintain confidentiality. Findings: By using adaptive encryption system does not require the choice of encryption scheme must be adopted for each database column and SQL operation at design time. Encryption schemes are able to perform most of the query operations on encrypted cloud database. In this system set of queries are not decided at design time. It works even when set of query will change dynamically. This is not possible with the existing system. Application/Improvements: Using adaptive encryption scheme most of the operations are performed on encrypted cloud database. Execution time of various SQL operations is improved as compared to the previous system. Keywords: Adaptive, Confidentiality, Encryption, Public Cloud, Security

The Design of mBodyCloud System for Sensor Information Monitoring in the Mobile Cloud Environment

Recently, introduced a cloud computing technology to the IT industry, smart phones, it has become possible connection between mobility terminal such as a tablet PC. For dissemination and popularization of movable wireless terminal, the same operation have focused on a viable mobile cloud in various terminal. Also, it evolved Wireless Sensor Network(WSN) technology, utilizing a Body Sensor Network(BSN), which research is underway to build large Ubiquitous Sensor Network(USN). BSN is based on large-scale sensor networks, it integrates the state information of the patient's body, it has been the need to build a managed system. Also, by transferring the acquired sensor information to HIS(Hospital Information System), there is a need to frequently monitor the condition of the patient. Therefore, In this paper, possible sensor information exchange between terminals in a mobile cloud environment, by integrating the data obtained by the body sensor HIS and interoperable data DBaaS (DataBase as a Service) it will provide a base of mBodyCloud System. Therefore, to provide an integrated protocol to include the sensor data to a standard HL7(Health Level7) medical information data.

Processing secure, verifiable and efficient SQL over outsourced database

Database as a Service (DBaaS) economically enables the customers with limited resources to outsource large-scale databases to the cloud. However, it becomes a very challenging problem that how to execute SQL on outsourced databases while protecting the confidentiality of outsourced databases at the same time. In this paper, we present a novel protocol to enable secure and efficient database outsourcing. First, we propose a new cloud database model by introducing computation service providers (CSPs), which can accommodate the conventional DBaaS model; the CSPs undertake most of the postprocessing and reconstruction burden for database query. Next, we design our database outsourcing protocol SecureDBS by leveraging a secret sharing mechanism and a novel tree-based order-preserving encryption (OPE) mechanism. The proposed protocol supports various SQL queries, including selection, update, insertion, and aggregate queries. Further, we present a mechanism to detect malicious behaviors of the cloud. Finally, we theoretically show that our protocol is correct, secure and efficient, and experimentally demonstrate that the protocol is efficient for practical usage.

Database-as-a-Service for Big Data: An Overview

The last two decades were marked by an exponential growth in the volume of data originating from various data sources, from mobile phones to social media contents, all through the multitude devices of the Internet of Things. This flow of data can’t be managed using a classical approach and has led to the emergence of a new buzz word: Big Data. Among the research challenges related to Big Data there is the issue of data storage. Traditional relational database systems proved to be unable to efficiently manage Big Data datasets. In this context, Cloud Computing plays a relevant role, as it offers interesting models to deal with Big Data storage, especially the model known as Database as a Service (DBaaS). We propose, in this article, a review of database solutions that are offered as DBaaS and discuss their adaptability to Big Data applications.

Design of Integrated Medical Information System Based on The Cloud

Today, the medical information system has evolved in the way of integrated healthcare IT information systems. Therefore, it is trying to build advanced U-Healthcare service. Though the U-Healthcare environments is exchanged the information between systems in many cases, however since the each system is different, the integration and exchange of data is difficult. To overcome this problem, in this paper it proposes that we suggests a possible DBaaS(DataBase as a Service) for the heterogeneous integration of medical information management and data exchange. First, the proposed system builds DBaaS cloud by integrating the meta-DB Schema level and DB Schema for each hospital. And, the mapping the schema data and the existing hospital information system is possible using the International Standard HL7. By applying the proposed method to the hospital system, it comes true the efficient exchange of information between the patients, doctors, staffs through the data mapping of the one to multi-system.

SmartSLA: Cost-Sensitive Management of Virtualized Resources for CPU-Bound Database Services

Virtualization-based multi-tenant database consolidation is an important technique for database-as-a-service (DBaaS) providers to minimize their total cost which is composed of SLA penalty cost, infrastructure cost and action cost. Due to the bursty and diverse tenant workloads, over-provisioning for the peak or under-provisioning for the off-peak often results in either infrastructure cost or service level agreement (SLA) penalty cost. Moreover, although the process of scaling out database systems will help DBaaS providers satisfy tenants’ service level agreement, its indiscriminate use has performance implications or incurs action cost. In this paper, we propose SmartSLA, a cost-sensitive virtualized resource management system for CPU-bound database services which is composed of two modules. The system modeling module uses machine learning techniques to learn a model for predicting the SLA penalty cost for each tenant under different resource allocations. Based on the learned model, the resource allocating module dynamically adjusts the resource allocation by weighing the potential reduction of SLA penalty cost against increase of infrastructure cost and action cost. SmartSLA is evaluated by using the TPC-W and modified YCSB benchmarks with dynamic workload trace and multiple database tenants. The experimental results show that SmartSLA is able to minimize the total cost under time-varying workloads compared to the other cost-insensitive approaches.

Design Support for Performance Aware Dynamic Application (Re-)Distribution in the Cloud

The wide adoption of the cloud computing paradigm by many different domains has increased both the number and type of available offerings as a service, e.g. Database-as-a-service (DBaaS) or Platform-as-a-Service (PaaS), and with them the possibilities to deploy and operate an application partially or completely in the cloud. The need for providing design support to application developers in this environment is the focus of this work. Toward this goal, in the following we first scope the discussion on the persistence layer of applications and we investigate the effect of different deployment scenarios on the performance of the application over time. Based on the results of this analyses we then propose an application (re-)distribution design support process, which we evaluate empirically by means of a well-known application. The results of this evaluation both highlight the strengths of our proposal, and at the same time, provide a clear path for the following steps in our work.

OLTP-Bench

Benchmarking is an essential aspect of any database management system (DBMS) effort. Despite several recent advancements, such as pre-configured cloud database images and database-as-a-service (DBaaS) offerings, the deployment of a comprehensive testing platform with a diverse set of datasets and workloads is still far from being trivial. In many cases, researchers and developers are limited to a small number of workloads to evaluate the performance characteristics of their work. This is due to the lack of a universal benchmarking infrastructure, and to the difficulty of gaining access to real data and workloads. This results in lots of unnecessary engineering efforts and makes the performance evaluation results difficult to compare. To remedy these problems, we present OLTP-Bench, an extensible "batteries included" DBMS benchmarking testbed. The key contributions of OLTP-Bench are its ease of use and extensibility, support for tight control of transaction mixtures, request rates, and access distributions over time, as well as the ability to support all major DBMSs and DBaaS platforms. Moreover, it is bundled with fifteen workloads that all differ in complexity and system demands, including four synthetic workloads, eight workloads from popular benchmarks, and three workloads that are derived from real-world applications. We demonstrate through a comprehensive set of experiments conducted on popular DBMS and DBaaS offerings the different features provided by OLTP-Bench and the effectiveness of our testbed in characterizing the performance of database services.

Syncing Mobile Applications with Cloud Storage Services

Cloud data storage is an option available almost on any mobile platform. Nowadays, there are multiple solutions for syncing data in mobile applications. The aim of the paper is to analyze mobile application developers ' possibilities for syncing content using major free cloud storage providers. The paper describes the cloud computing in mobile context and highlights cloud providers APIs. Experimental residis are analyzed in order to identify the best cloud storage solution for syncing mobile applications, depending on the operating system on which they are implemented.Keywords: Cloud Computing, Mobile Application, Data Synchronization, Application Programming Interface, REST, OAuth1 IntroductionWe are living in the era of agile and always-available data storage [1], where it is very important to have instant and permanently access to the data, personal and private, with which we are operating at work or at home. The development of mobile technologies and the spectacular growth of mobile devices users created this opportunity to quickly read our emails, to view our documents from shared folders, to access all the data saved in the cloud directly from the personal smart-phone or tablet.The mobile devices that we are taking with us every day represents mobile clients for our cloud storage subscriptions that we have to main providers, such as Dropbox, SkyDrive, Google Drive, Box, and so on. It is very important to have the same or a similar user experience on each mobile device, independently by the operating system.The choice of a certain cloud storage provider (CSP) depends on the facilities provided, the user experience and the storage amount space that he offers. Some mobile operators provides also cloud storage solutions, such as Orange Cloud, which allow to store your digital content, secure in the cloud, available anytime and anywhere [8].Figure 1 presents the storage and backup settings for iCloud solution, which is integrated in every iOS operating system. Apple provides by default a 5 GB free storage plan for every iOS user.The paper is structured in five sections, as follows. The section Cloud Computing in Mobile Context describes the main types of cloud computing facilities and their advantages when they are used in mobile environments.Section Comparative Analysis analyzes experimental results and findings for main cloud providers on the market, such as Dropbox, SkyDrive and Box, in the mobile context.Section Cloud providers API presents all related information to use cloud providers APIs in order to develop mobile applications, on different operating systems, which can store their data in the cloud.The paper ends with Conclusion and future work section that summarize important research results of this analysis and identifies future development possibilities.2 Cloud Computing in Mobile ContextBecause many hardware and software manufacturers have invested a lot in cloud computing solutions, the evolution of public and private cloud has increased in terms of users, security, infrastructure and data storage, [14], In few years we will assist at the moment when a user will go at work or at home with the same tablet that will be docked in a keyboard and will access all the data from the cloud. The desktop computers will disappear slowly and will be replaced with simple monitors or mobile tablets that will use the desktop virtualization technology. When data storage in the cloud will be cheaper, companies will replace all the hardware equipment with these simple monitors in order to use platform as a service (PaaS), software as a service (SaaS), storage as a service (STaaS), security as a service (SECaaS), data as a service (DaaS), database as a service (DBaaS) or test environment as a service (TEaaS) [2],Figure 2 below presents the cloud computing architecture integrating all related cloud solutions.In [1] is presented a set of challenging storage issues for researchers and engineers. …

Cryptograph Index Technology Based on Bucket Partitioning and B+ Tree

Database encryption is the last defense to ensure data security, resolving the problem of insecurity caused by unencrypted data directly stored in database. At the same time, Database encryption has brought a new troubleencryption makes query efficiency become obviously slow. Cryptograph index is an effective method. In the DAS(Database as a service) model, a method based on bucket partitioning and B+ tree, which utilizes B+ tree to sort data in the bucket and improves the efficiency due to reduce the amount of processing data, is put forth in this paper. Finally, the paper has made an analysis on its performance.

XPath Query Completeness Verification Algorithms in DAS

With the development in the application environment of database management system, the related technologies such as data management and data access have become more and more complex and the cost of maintenance has been more and more expensive. The problems that how to enable enterprises to focus on the ir expert areas and outsource the unfamiliar enterprise information systems to others , thus to save a lot of resources but receive the same quality of service s, are widely concerned by the database research and application areas. Database as a service (DAS), which means that enterprises outsource the database system to some database service providers (DSP) who manage the massive data and provide high-quality data management service becomes an important application in nowadays . To enjoy services provided by a third party, we need to ensure the correctness and completeness of query results. This paper pospose an algorithm which provides an authentication method for the query results returned from a possible malicous server on which database is outsourced and query is evaluated. The basic idea is to build some Merkle hash trees twice to verify the correctness and completeness of the query results. We have demonstrated the effectiveness of our method in experiments.

Research and design of querying approach for XML encrypted data

The structural characteristics of XML database document have been fully made use of and combined with the encoding theory of Dewey code to design an encrypted XML algorithm called Index Layered Itersection Scan Algorithm(ILISA)under the model of Database as A Service(DAS).The data retrieval of tree structure was turned into the data retrieval of sequential list form.The authors applied the interpolation search algorithm instead of depth-first or breadth-first search,which had brought a good time complexity.And a data structure of XML index table was designed to reduce the search space greatly.Finally,the complexity of ILISA was described and the efficiency of ILISA was proved.

A cooperative framework for XML database-as-a-service

More and more frequently, database-as-a-service (DAAS) applications are emerging on the web. In this paper, we address the problem of evaluating a heavy load of subscribed queries in the DAAS model, where the traditional XML data management strategy leads to many drawbacks, such as overload of the service provider and the waste of bandwidth when a large number of service queries are executed on the service provider due to huge XML message sizes. We propose a new framework to efficiently process multi-queries among the cooperative service clients. System maintenance issues are also discussed. The experimental results demonstrate that the proposed approach substantially saves more bandwidth than traditional ones.