Explore chapters and articles related to this topic
Homomorphic Encryption
Published in Kevin E. Foltz, William R. Simpson, Enterprise Level Security 2, 2020
Kevin E. Foltz, William R. Simpson
Stored procedures are groups of SQL statements and control statements. They offer many benefits, including performance, security, scalability, and maintainability. However, they require extending CryptDB to support creating, dropping, and calling these stored procedures.
Research and implementation of order-oriented textile production scheduling system
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.
Backward chaining inference as a database stored procedure – the experiments on real-world knowledge bases
Published in Journal of Information and Telecommunication, 2018
Tomasz Xie¸ski, Roman Simiński
The second approach assumes that the inference process is being realized fully on the server side. A dedicated PHP implementation was previously analysed (Simiński & Manaj, 2015). In this work, utilization of stored procedures (within the database server) is considered. A client device uses Rest API services, sends the goal and facts to the server and receives information about the goal confirmation (and optional details) – Figure 3 illustrates the presented approach. The utilization of a server-side implementation minimizes the network traffic, as only a single request is necessary. The usage of database server's stored procedures ensures independence from the used programming tools – only a connection to the database server and a simple API is required. The main research goal of this paper was the experimental evaluation of the backward chaining inference algorithm implementation as a stored procedure and a comparison (of such implementation) with inference performed on preloaded knowledge bases (on local devices). Considered approaches are quite different from the implementation point of view.