View

View

A view is an SQL query stored in a database that is created using the CREATE VIEW statement. It is used to facilitate user queries and improve data security by hiding irrelevant portions of the database from a user for reasons of convenience or protection. Views allow different users to approach the database from different angles.From: Developing Windows-Based and Web-Enabled Information Systems [2019], Research and implementation of order-oriented textile production scheduling system [2023], Robot Technology and Applications [2020]

Databases

View Chapter

Purchase Book

Published in David Austerberry, Digital Asset Management, 2012

David Austerberry

The data manipulation language (DML) is used to access and manipulate records, specifically to select, insert, update, and delete records. The select statement is used to perform queries. A query results in a temporary table called a view, which forms a subset of the information stored within one or more tables. For example, you could return all the spot titles on a given tape number.

Research and implementation of order-oriented textile production scheduling system

View Article

Journal Information

Published in Journal of the Chinese Institute of Engineers, 2023

Heng Ding, Haoyu Gao, Yude Dong, Suyun Huang

In the structural design of a database, the database table is set with the machine, order, and user information as the main line (Zhu et al. 2013; Zhang 2014). Figure 3 shows the business model diagram for production planning. The textile production planning system uses an entity relationship (E – R) diagram entity-contact method to build a data model and then designs a basic data table (Shoval, Danoch, and Balabam 2004). Views are used in databases to facilitate user queries and improve data security. The stored procedure transfers a complicated data operation process to the database server to improve operation efficiency and ensure data integrity. Through triggers, the data of other tables associated with the table are modified when the table data changes. The database structure design is based on the needs of the enterprise, and it is easy to maintain and expand.

Explore chapters and articles related to this topic

Databases

Research and implementation of order-oriented textile production scheduling system