NDLI: An intention-based approach to the updatability of views in relational databases

Please wait, while we are loading the content...

Performance analysis of black hole attack in MANET

Frag-shells cube based on hierarchical dimension encoding tree

DNS amplification attack detection and mitigation via sFlow with security-centric SDN

The effects of ambient scent on hedonic experience on online shopping

Big data analysis on secure VoIP services

Toward accessibility with usability: understanding the requirements of impaired uses in the mobile context

Architectural framework in next learning support environment

Design & development of digital learning resource (BMT): blended learning approach

Web-based application for learning Malaysian sign language

Discovering users navigation of online newspaper using Markov model

Improvement of user authentication scheme preserving uniqueness and anonymity for connected health care

Experiments on images displayed for praising and scolding in e-learning systems

An intention-based approach to the updatability of views in relational databases

A proposal of event study methodology with Twitter sentimental analysis for risk management

Lecturers' perception on social media networks uses in education

Top-k frequent induced subgraph mining on a sliding window using sampling

Study on proactive auto scaling for instance through the prediction of network traffic on the container environment

Cryptanalysis and improvement of robust authentication scheme for telecare medicine information systems

Dynamic weighted sequential pattern mining for USN system

A proposed model of online information grounds

Fusion of face recognition and facial expression detection for authentication: a proposed model

Effects of quizzes in marking supported e-learning

Feature expression of frequency transform regarding daily power demand information

Salt hero: an interactive application for learning salt in chemistry

Identifying major contents among web pages with search engine suggests by modeling topics

Immersive browsing in an image sphere

TopicWave: visual exploration for topics with hierarchical time-varying data

Study on user customized data service model for improving data service reliability

Efficient query processing on distributed stream processing engine

WARP: an web-based adaptive remote display protocol for improvement of user experience

Collection of responsive utterances to show attentive hearing attitude to speakers

Improving the accuracy of signature authentication using the eight principles of Yong

A collaborative filtering method based on empathy with reviewers

C&C session detection using random forest

Cache-assisted amorphous cell association for heterogeneous content delivery networks

Improving read performance by isolating multiple queues in NVMe SSDs

Centralized management solution for vagrant in development environment

An enhanced unlinkable anonymous payment scheme based on near field commnication

Effectively mining time-constrained sequential patterns of smartphone application usage

Heterogeneous AdaBoost with stochastic algorithm selection

Identifying user profile using Facebook photos

An optimal data fusion for distributed multisensor systems: covariance extension method

A method of collecting know-how knowledge based on question-answer examples and search engine suggests

A flexible architecture for orchestrating network security functions to support high-level security policies

Clustering picture books based on an infant's developmental reactions in reviews on picture books

A trajectory analysis system for social media contents using AsterixDB

Topology and survivability analysis for flight flow networks: case studies of three China airline companies

Information diffusion on Facebook: a case study of the sunflower student movement in Taiwan

Internet of family: increasing social presence of family members via sharing ambient IoT usage data

Cryptanalysis and improvement of a biometric and smart card based remote user authentication scheme

A study on authentication mechanism in SEaaS for SDN

Low-power backscatter relay network

Coordinated-beam selection scheme using mobility pattern of mobile device in 5G mobile communication systems

Computer simulation of tree mapping approach to project the future growth of forest

Geometric progression algorithm for adjacent band power allocation in OFDM based cognitive radio

Modularity approach for community detection in complex networks

Predicting political affiliation of posts on Facebook

Analysis and comparison of fax spam detection algorithms

A novel available bandwidth estimation method for mobile networks using a train of packet groups

CPE: a cloud server performance evaluation model

Multimedia data for efficient detection of visual objects

CLOSER: applying aggregation for effective event reconstruction of cloud service logs

Standard-based patient-centered personal health record system

SkyCube-tree based query processing in OLAP skyline cubes

An efficient similar image search framework for large-scale data on cloud

Collaborative filtering algorithm based on rating distance

Physical learning support using a smartphone with image processing technologies

Advising cache for lower cache

A quantitative analysis of fault tolerance mechanisms for parallel machine learning systems with parameter servers

Lumen boundary detection in IVUS medical imaging using structured element

Answer ranking based on named entity types for question answering

Children book app as emotional learning media

Two-stage approach to named entity recognition using Wikipedia and DBpedia

Parameter manipulation attack prevention and detection by using web application deception proxy

Virtual running model for locating road intersections using GPS trajectory data

An efficient resource allocation scheme for scalable video multicast in LTE-advanced networks

Syntactic pattern recognition of car driving behavior detection

Constructing virtual IoT network topologies with a brain-inspired connectivity model

Performance improvement of I/O intensive OLAP with dynamic control of file storing location

Static analysis with paragraph vector for malware detection

Design of a trivia game for traveling and domestic enjoyment in Japan

Accessible multimodal-interaction platform for computer-supported collaborative learning system

Transportation mode inference using environmental constraints

Classification of short comments by weighted tree kernels using the hierarchy of Wikipedia

Object lifetime trend of modern Android applications for GC performance improvement

Application power consumption estimation considering software dependency in Android

CFFQ: I/O scheduler for providing fairness and high performance in SSD devices

Integrating adaptive boosting and support vector machines with varying kernels

Energy level-based efficient wireless power and information transfer in sensor networks

A study of enhancement of ranging performance of beacons through improvement of the smart phone's gyroscope: focusing on the Bluetooth low energy

A PSO-based virtual SDN customization for multi-tenant cloud services

Mechanism to continue system availability during cyber threat scenario

An optimal investment scheme based on ATM considering cloud security environment

Pre-interaction identification by dynamic grip classification

A development of power consumption measurement system for Android smartphones

Construction and analysis of easily fold-able processes for computer-aided origami

Pipeline-based processing of the deep learning framework caffe

Leveraging BLE and social trust to enable mobile in situ collaborations

Ushare: user controlled social media based on blockchain

Accelerated test for applications with client application and server software

On unconditionally binding code-based commitment schemes

Agent-mediated academic advising system: nodal approach on knowledge management system towards achieving students' graduate-on-time

Agent-oriented simulation: new advantages in simulation optimization

SOUYA: an open extensible search service to build rich-content applications

An IoT based monitoring framework for software defined 5G mobile networks

Biometric authentication by handwriting with single direction using self-organizing maps

Design and implementation of SDN-based lightweight IPv6 mobility manager in ONOS

A fast recovery scheme based on detour planning for in-band openflow networks

Real-time background subtraction based on GPGPU for high-resolution video surveillance

Software defined networking-based one-packet DDoS mitigation architecture

Improving NIC algorithm using different binary structure elements for multi-modal foreground detection

Joint optimization of sensing period and transmission time for energy-efficient CRSNs

A matching game approach for resource allocation in wireless network virtualization

An intention-based approach to the updatability of views in relational databases

Content Provider	ACM Digital Library
Author	Masunaga, Yoshifumi
Abstract	Views are essential for relational databases in that they could provide a high degree of logical data independence. However, although views are a useful tool for queries, they present significant problems if insertions, deletions, or rewrites are expressed using views. This is due to the fact that views are not base relations stored in a relational database but virtual in the sense of being merely definitions of queries issued to a relational database. While the view update problem has attracted the attention of many scientists and business people, a complete resolution to this problem is still an open issue unfortunately. In this paper, in contrast to the traditional approaches such as the syntax-based approach and the semantics-based approach, an intention-based approach is presented to resolve this problem. By introducing the pro forma guessing of update intention approach, Cartesian product views and join views become updatable while they are not updatable in the traditional sense. This is due to the fact that in certain cases the user's view update intention can be guessed uniquely by checking the extension of each view update transformation candidate, which is calculated using temporarily materialized views. In addition to the above results, the updatability of other basic views such as union views, difference set views, intersection views, projection views, and selection views is re-examined under the intention-based approach. Based on the result, an algorithm is presented to determine whether a given view, defined arbitrarily by using relational algebra operations recursively, is updatable or not. Compared to the traditional approach, it is shown that the intention-based approach realizes richer solution to view updatability problem.
Starting Page	1
Ending Page	8
Page Count	8
File Format	PDF
ISBN	9781450348881
DOI	10.1145/3022227.3022239
Language	English
Publisher	Association for Computing Machinery (ACM)
Publisher Date	2017-01-05
Publisher Place	New York
Access Restriction	Subscribed
Subject Keyword	Relational algebra Join views Intention-based approach Views Materialized views Updatability of views Relational databases Cartesian product views View update problem
Content Type	Text
Resource Type	Article

Central Library (ISO-9001:2015 Certified)
Indian Institute of Technology Kharagpur
Kharagpur, West Bengal, India | PIN - 721302

See location in the Map
03222 282435
Mail: support@ndl.gov.in

Sl.	Authority	Responsibilities	Communication Details
1	Ministry of Education (GoI), Department of Higher Education	Sanctioning Authority	https://www.education.gov.in/ict-initiatives
2	Indian Institute of Technology Kharagpur	Host Institute of the Project: The host institute of the project is responsible for providing infrastructure support and hosting the project	https://www.iitkgp.ac.in
3	National Digital Library of India Office, Indian Institute of Technology Kharagpur	The administrative and infrastructural headquarters of the project	Dr. B. Sutradhar bsutra@ndl.gov.in
4	Project PI / Joint PI	Principal Investigator and Joint Principal Investigators of the project	Dr. B. Sutradhar bsutra@ndl.gov.in Prof. Saswat Chakrabarti will be added soon
5	Website/Portal (Helpdesk)	Queries regarding NDLI and its services	support@ndl.gov.in
6	Contents and Copyright Issues	Queries related to content curation and copyright issues	content@ndl.gov.in
7	National Digital Library of India Club (NDLI Club)	Queries related to NDLI Club formation, support, user awareness program, seminar/symposium, collaboration, social media, promotion, and outreach	clubsupport@ndl.gov.in
8	Digital Preservation Centre (DPC)	Assistance with digitizing and archiving copyright-free printed books	dpc@ndl.gov.in
9	IDR Setup or Support	Queries related to establishment and support of Institutional Digital Repository (IDR) and IDR workshops	idr@ndl.gov.in