In order to expand and collapse the table of contents, you must enable JavaScript in the browser.
(Collapse Contents)
Title Page
Preface
Chapter 1 Knowledge Data Management Feature
1.1 Overview of the Knowledge Data Management Feature
1.2 Examples of Using Knowledge Data
1.2.1 Example of Searching Text Data Based on Semantic Similarity
1.2.2 Example of Searching a Graph Based on Relationships
Chapter 2 Vector Data Management Feature
2.1 Setting Up the Vector Data Management Feature
2.2 Storing and Searching Vector Data
2.3 Protecting Vector Data
2.4 Performance Tuning for Similar Search of Vector Data
2.5 Using Vector Data by Applications
2.6 Quantitative Limits
Chapter 3 Semantic Text Search and Automatic Vectorization Feature
3.1 Overview of the Semantic Text Search and Automatic Vectorization Feature
3.2 Installation of Semantic Text Search and Automatic Vectorization
3.2.1 Operating Environment
3.2.2 Setup
3.2.2.1 Setting Up pgai
3.2.2.2 Setting Up pgx_vectorizer
3.2.2.3 Migration from Fujitsu Enterprise Postgres 17 SP1 and 17 SP2
3.2.3 Removing
3.2.4 Stopping the vectorize scheduler
3.2.5 Credentials Protection
3.2.5.1 Encrypting Credentials
3.2.5.2 Restrict Access to Credentials
3.3 Preparation for Semantic Text Search
3.3.1 Configuring Embedded Providers (for Workers)
3.3.2 Configuring Embedded Providers (for Semantic Text Search)
3.3.3 Definition of Vectorization
3.3.4 Granting Privilege to Execute Functions
3.4 Storing Vector Data for Semantic Text Search
3.5 Protecting Vector Data for Semantic Text Search
3.5.1 Encrypting Vector Data for Semantic Text Search
3.5.2 Restricting Access to Vector Data for Semantic Text Search
3.5.3 Recording Access to Vector Data for Semantic Text Search
3.6 Monitoring Vectorization Processing for Semantic Text Search
3.6.1 Checking the Vectorization Queue
3.6.2 Checking the Status of Vectorization Processing
3.6.3 Checking the Scheduler for Vectorization Processing
3.7 Temporarily Disabling Vectorization Processing for Semantic Text Search
3.8 Semantic Text Search
3.9 Changing the Vector Representation Used in Semantic Text Search
3.10 Performance Tuning of Semantic Text Search
3.11 Hybrid Search
3.12 Improving the Accuracy of Hybrid Search
3.12.1 Overview of Hybrid Search Tuning
3.12.2 Recording and Deleting Traces of Hybrid Search
3.12.3 Calculation of Search Accuracy Using External Tools
3.12.4 Calculation of Search Accuracy in the Database
3.12.4.1 Example of Calculating Search Accuracy in a Database
3.12.5 Tuning of Hybrid Search
3.13 Reference
3.13.1 Vectorization Functions
3.13.1.1 Defining Vectorization
3.13.1.2 Vectorization Schedule
3.13.1.3 Vectorizer Management Functions
3.13.2 Embedded Provider Management Functions
3.13.3 Search Functions
3.13.3.1 Semantic Text Search
3.13.3.2 Hybrid Search
3.13.3.3 Details of the pgx_hybrid_search Function
3.13.4 Tables/Views Created by Semantic Text Search and Automatic Vectorization Feature
3.13.5 Parameters
3.13.6 Evaluation of Knowledge Data Search
3.13.6.1 Concept of Evaluation for Knowledge Data Search
3.13.6.2 Evaluation Value per Record and Search Accuracy
3.13.6.3 Tuning the Combination Method of Hybrid Search
Chapter 4 Graph Management Feature
4.1 Overview of Graph Management Feature
4.2 Installation of Graph Management Feature
4.2.1 Setting Up the Graph Management Feature
4.2.2 Removing the Graph Management Feature
4.3 Creating a Graph
4.4 Storing Graph Data
4.5 Protecting Graph Data
4.5.1 Encrypting the Graph
4.5.2 Restricting Access to Graph
4.5.3 Recording Access to Graph
4.6 Searching Graph
4.7 Adding Labels to Graph
4.8 Performance Tuning of Graph Search
4.9 Using Graph Data in Applications
4.10 Visualizing Graph Data
4.11 Internal Structure of Graph Data
4.12 Quantitative Limits
4.13 Reference
Chapter 5 Model Management in the Database
5.1 Overview
5.2 Introduction/Setup
5.2.1 Setting Up Inference Server
5.2.2 Setting Up pgx_inference
5.2.3 Removing
5.2.4 Resource Control
5.2.5 Setting Privilege
5.2.6 Model Preparation
5.2.6.1 Database-side Model Specifications
5.2.7 Model Import
5.2.8 Model Load/Unload
5.2.9 Definition of Vectorization
5.2.10 Deletion of Imported Model
5.3 Usage Example
5.3.1 Model Import
5.3.2 Model Load/Unload
5.3.3 Definition of Vectorization
5.3.4 Deletion of Imported Model
5.4 Operaion
5.4.1 Backup/Restore
5.4.2 Streaming Replication/Database Multiplexing
5.4.3 Security
5.4.4 Monitoring/Tuning
5.4.4.1 Monitoring Target
5.4.4.2 Parameter Tuning
5.5 Reference
5.5.1 Functions
5.5.2 Tables/Views
5.5.3 Parameters
Top