What is inverted file in PostgreSQL?

1.	What is inverted file in PostgreSQL?
Answer» In POSTGRESQL, an Inverted file is basically an index data STRUCTURE used for mapping content to its location to a database file, WITHIN a document, or in sets of documents. It is usually composed of all the distinct words found in a text and a list containing the occurrences of a WORD in the text. The inverted file is widely used in a data structure for document retrieval systems in supporting a full-text SEARCH.

Answer»

In POSTGRESQL, an Inverted file is basically an index data STRUCTURE used for mapping content to its location to a database file, WITHIN a document, or in sets of documents.

It is usually composed of all the distinct words found in a text and a list containing the occurrences of a WORD in the text.

The inverted file is widely used in a data structure for document retrieval systems in supporting a full-text SEARCH.

Discussion

No Comment Found

Related InterviewSolutions

What is a CTID of PostgreSQL?
How to take the backup of PostgreSQL?
How to enable debug mode in PostgreSQL?
How to check status of PostgreSQL server running or not?
What are the ODBC drivers that are available for PostgreSQL?
What is the command that can be used to allocate memory in postgreSQL?
How many byte Unique integers does OIDs in PostgreSQL?
What is inverted file in PostgreSQL?
What is the operator that is used for case-insensitive regular expression searches in PostgreSQL?
What is purpose of overlay function in PostgreSQL?

What is inverted file in PostgreSQL?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment