ObjectDB ObjectDB
Home » Forum » Partial Indexing

Partial Indexing

#1
gzdillon
gzdillon's picture
Joined on 2011-05-17

I have a question about partial indexing.

For example, a field of String type ttt, will be distinguished by the first 5 characters, then I can make a index of substr(ttt,1,5) in MySQL.

With ObjectDB, how can I write the annotation for this purpose?

TIA

=========================================================================
There's never been infinity. Cantor's diagonal proof is completely wrong.
✂
edit
delete
#2
support
support's picture
Joined on 2010-05-03

Currently ObjectDB supports only indexing of complete fields (single field or multiple fields).

The obvious workaround is to add to the entity class an additional field that will hold the partial content. You can keep that partial field synchronized with the main field by using a callback method (which will be annotated with @PrePersist and @PreUpdate). The new field should be indexed and used in queries.

ObjectDB Support
ObjectDB - Fast Object Database for Java (JPA/JDO)
✂
edit
delete
#3
gzdillon
gzdillon's picture
Joined on 2011-05-17

Thanks! Your reply do make sense.

=========================================================================
There's never been infinity. Cantor's diagonal proof is completely wrong.
✂
edit
delete

Reply

To post on this website please sign in.

About ObjectDB Getting Started Support
DBMS Features Quick Tour with JPA ObjectDB FAQ
Editions and Prices JPA Console Tutorial ObjectDB Manual
Licence Web App Tutorial Forum
Attributions Java EE JPA Tutorial Issue Tracking
Privacy Spring MVC JPA Tutorial Website Search
Terms of Use Download ObjectDB Contact Us

Which JPA is Faster?

 

See a comparison of Hibernate, EclipseLink, OpenJPA, DataNucleus, MySQL, PostgreSQL, Derby, HSQLDB, DB4O by Versant, H2 Database, SQLite and ObjectDB

in the JPA Benchmark.

Copyright © 2003, 2010, 2023  ObjectDB Software, all rights reserved. The JPA API Reference Documentation (JavaDoc) on this website is derived with some adjustments from the open source JPA 2 RI (EclipseLink) and is available under the terms of the Eclipse Public License, v. 1.0 and Eclipse Distribution License, v. 1.0. The JDO API Reference Documentation (JavaDoc) on this website is derived with some adjustments from the JDO 2.2 API and is available under the terms of the Apache License, v. 2.0. Images on this website are available under these licecnes. Documentation on this website explains how to use JPA in the context of the ObjectDB Object Database but mostly relevant also for ORM JPA implementations, such as Hibernate (and HQL), EclipseLink, TopLink, OpenJPA and DataNucleus. ObjectDB is not an ORM JPA implementation but an Object Database (ODBMS) for Java with built in JPA 2 support.