• https://doi.org/10.1007/978-1-4842-0280-7_13Copy DOI Icon

Building a View

  • Dec 29, 2014
  • Robin Dewson
Show More
  • Abstract
  • Literature Map
  • Similar Papers
Abstract

A view is a virtual table that, in itself, doesn’t contain any data or information. All it contains is the query that the user defines when creating the view. A view is a named query against one or more tables. Views are used as a security measure by restricting users to certain columns or rows from an underlying table, as a method of joining data from multiple tables and presenting it as if that data resided in one table, and as a method of returning summary data instead of detailed data. Another use for a view is to provide a method of accessing the underlying data in a manner that provides the end user with a business layout. For example, you will see within this chapter the building of a view that shows customer details along with enriched transaction details, thus making it easier for anyone interrogating your data, even someone who has no knowledge of the underlying data model, to access useful information.

Similar Papers
  • Conference Article

Exploring End-Users’ Engagement with Security Threats: A Survey-Based Investigation from Academic and Security Experts’ Perspective

  • Aug 26, 2023
  • Mousa Jari +2
  • Conference Article
  • Citations5

A domain-specific language for supporting event log extraction from ERP systems

  • May 01, 2018
  • Ana Pajic Simovic +2
  • Book Chapter
  • Citations4

Online Product Recommendation System Using Multi Scenario Demographic Hybrid (MDH) Approach

  • Jan 01, 2020
  • R V Karthik +1
  • Book Chapter
  • Citations4

Secure Smart Vehicle Cloud Computing System for Smart Cities

  • Jan 01, 2018
  • Trupil Limbasiya +1
  • News Article

CYBERNEWS

  • Nov 01, 2006
  • The Journal of the American Dental Association
  • Joe Hoyle
  • Research Article
  • Citations329

Self-efficacy in information security: Its influence on end users' information security practice behavior

  • May 27, 2009
  • Computers & Security
  • Hyeun-Suk Rhee +2
  • Conference Article
  • Citations1

Pragmatic data modelling and design for end users

  • Dec 05, 2000
  • C Churcher +2
  • Conference Article

Map legend and response design: how do they affect accuracy of GEOBIA results

  • Jan 01, 2016
  • J Radoux +1
  • Supplementary Content
  • Citations404

Understanding Nonmalicious Security Violations in the Workplace: A Composite Behavior Model

  • Oct 01, 2011
  • Journal of Management Information Systems
  • Ken H Guo +3
  • Conference Article

Enhanced interactive services for end users in IMS

  • Oct 01, 2009
  • Dalton Li +1
  • Conference Article
  • Citations3

Using geo-spatial session tagging for smart multicast session discovery

  • Mar 08, 2009
  • Piyush Harsh +1
  • Conference Article
  • Citations10

Using the Semantically Interoperable Biospecimen Repository Application, caTissue: End User Deployment Lessons Learned

  • Jan 01, 2010
  • Jack W London +1
  • Research Article
  • Citations5

Study of Video Conferencing Software Risks and Mitigation Strategies

  • Mar 08, 2022
  • Journal of The Colloquium for Information Systems Security Education
  • Yelena Arishina +2
  • Research Article
  • Citations1

Feedback of aggregate patient-reported outcomes (PROs) data to clinicians and hospital end users: findings from an Australian codesign workshop process

  • Jul 01, 2022
  • BMJ Open
  • Olivia Francis Ryan +11
  • Research Article

Secure ML Workflows Using Kubernetes: A CKS-Certified Perspective

  • Oct 30, 2023
  • International Journal of Emerging Research in Engineering and Technology
  • Karthik Allam
Cactus Communications logo

Copyright 2026 Cactus Communications. All rights reserved.