Clusterpoint Server automatically creates and maintains
complete database
index: Clusterpoint Index, which is used for high performance
data access and search in all of your stored documents.

This our indexing model radically differs from relational SQL
world. In relational database systems indexes have
to be specified for fast search, with primary and secondary keys,
applied in application specific way across certain normalized
multi-table database structure. It requires a lot of efforts
and often painstaking attention to technical details to get the
indexing system right from database architects developing SQL systems.
As rather complex indexing system, it is prone to many
database administration and software development errors. It
is often quite expensive to maintain knowledge and application software
versioning
over the relational database life-cycle, and one of the key reasons for
this cost is underlying complexity of legacy database indexing system.
Relational indexing requires a customized design of all
database
entities and relationships. It is very often started as
a one-person concepted custom design of the database and its indexing
model, quickly gets outdated or sophisticated when database is
developed and when it goes into real life production and maintenance.
Most legacy
relational databases gradually becomes heavy to use and understand by
follow-up application developers. We believe that this legacy
indexing model is aging, based on more than 30-years ago developed
SQL database architecture concept. Today available hardware
capacity
and processing power also makes this model outdated and obsolete.
It
simply is too complex to design, maintain and to use it efficiently, it
requires complex software and complex knowledge to manage all that
complexity.
Unlike relational databases, Clusterpoint Server indexes entirely everything that goes into our XML database: all data items, texts, dates, numbers, strings, relations etc. It also uses very special type of index data storage which we have developed to implement generic and absolutely scalable indexing system for a massively distributed database architecture, potentially running across large number of hardware servers (in 1000s of servers storing only parts of total database). Clusterpoint Index is a full database content index, and takes advantage of modern hardware capacity: abundance of disk storage and RAM memory, cheap CPU power and ubiquitous networking. Hardware and storage cost is nearly nothing compared to the cost of software development, integration and maintenance today. To simplify database management complexity, we simplified database indexing to the ultimately possible: index everything which may be searched for. Clusterpoint Index is designed for high-speed search in any database structure. It is a database structure independent index and therefore much more simple to use and manage than a fixed-structure relational SQL index. It eliminates the need to "know" about the index structure in application software and therefore cuts of lot of index-specific application programming efforts from database software developers agenda. Also DBAs have much less problems to handle with a single uniform database index, compared to often bizarre indexing systems in SQL world they need to support for each particular database.
Clusterpoint Index is being updated in real-time, when new documents are being stored into Clusterpoint storage or existing ones modified or deleted.