Internal Website Search
1-50 of 200 resultsIndex Definition Querying without indexes requires iteration over entity objects in the database one by ... indexes the iteration can be avoided and complex queries over millions of objects can be executed quickly. Index management introduces overhead in terms of maintenance time and storage space, so deciding | |
Database Management Settings indexes are handled. When a new index is defined for an existing entity class that already has instances stored in the database, the index cannot be used until all the existing instances are indexed . Indexing a large amount of data may take considerable processing time. The enabled attribute | |
WHERE clause (JPQL / Criteria API) and Indexes Formally, the WHERE clause functions as a filter between the FROM and the SELECT clauses. Practically, if a proper index is available , filtering is done earlier during FROM iteration. In the above population query, if an index is defined on the population field ObjectDB can use | |
ObjectDB Object Database Features queries with the same arguments). Many other internal caches. Indexing Single field and multi field ( composite ) indices. Collection and array elements are indexable (extremely fast JOIN queries). Map keys and values are indexable . Nested paths inside embedded objects are indexable . Indices | |
possible index required for improving query performance Hi, I have the following entity class: @Entity @Table @Indices({ @ Index (members={"relationshipType", "party"}), @ Index (members={"relationshipType", "otherParty"}), @ Index (members={"relationshipType ... as the number of relationships and BaseObjects grow. The query is using two indexed fields | |
Composite indexes Hi, I read your manual about defining Indexes for JPA Entities (http://www.objectdb.com/java/jpa/entity/ index ), but I still have some problems understanding how and when should I use them.   ... (...) } Here are my questions regarding composite indexes : #1. First of all - the first member in | |
javax.persistence.Index JPA Annotation Index Implemented Interfaces: Annotation Used in schema generation to specify creation of an index . Note that it is not necessary to specify an index for a primary key, as the primary key index will be created automatically. The syntax of the columnList element is a column_list , as | |
javax.persistence.Table.indexes JPA Annotation Attribute in javax.persistence.Table Index [] indexes default {} (Optional) Indexes for the table. These are only used if table generation is in effect. Note that it is not necessary to specify an index for a primary key, as the primary key index will be created automatically. Since: JPA 2.1 | |
javax.persistence.TableGenerator.indexes JPA Annotation Attribute in javax.persistence.TableGenerator Index [] indexes default {} (Optional) Indexes for the table. These are only used if table generation is in effect. Note that it is not necessary to specify an index for a primary key, as the primary key index will be created automatically. Since: JPA 2.1 | |
javax.persistence.JoinTable.indexes JPA Annotation Attribute in javax.persistence.JoinTable Index [] indexes default {} (Optional) Indexes for the table. These are only used if table generation is in effect. Since: JPA 2.1 | |
javax.persistence.CollectionTable.indexes JPA Annotation Attribute in javax.persistence.CollectionTable Index [] indexes default {} (Optional) Indexes for the table. These are only used if table generation is in effect. Since: JPA 2.1 | |
javax.persistence.SecondaryTable.indexes JPA Annotation Attribute in javax.persistence.SecondaryTable Index [] indexes default {} (Optional) Indexes for the table. These are only used if table generation is in effect. Since: JPA 2.1 | |
ListJoin.index() - JPA Method JPA Method in javax.persistence.criteria.ListJoin Expression index () Create an expression that corresponds to the index of the object in the referenced association or element collection ... for which an order column has been defined. Return: expression denoting the index Since: JPA 2.0 | |
javax.persistence.Index.name JPA Annotation Attribute in javax.persistence. Index String name default "" (Optional) The name of the index ; defaults to a provider-generated name. Since: JPA 2.1 | |
javax.persistence.Index.unique JPA Annotation Attribute in javax.persistence. Index boolean unique default false (Optional) Whether the index is unique. Since: JPA 2.1 | |
javax.persistence.Index.columnList JPA Annotation Attribute in javax.persistence. Index String columnList default null (Required) The names of the columns to be included in the index , in order. Since: JPA 2.1 | |
JDO Annotations for Index Definition The following annotations are used to define indexes on persistent fields: The Index Definition section of the ObjectDB manual explains these annotations in details. | |
JPA Entity Fields. An index on the owner field may accelerate the inverse query and the load of the inverse field. But even with an index , executing a query for loading a field is relatively slow. Therefore, if the employees | |
Query Parameters in JPA). Ordinal Parameters (? index ) In addition to named parameters, whose form is :name , JPQL also supports ordinal parameters, whose form is ? index . The following method is equivalent to the method | |
Database Explorer and embeddable classes) in the database and their persistent fields and indexes . The [Query] window enables ... execution plan. This is useful, for example, for checking which indexes are used. The Reset button clears | |
FROM clause (JPQL / Criteria API),FROM, GROUP, HAVING, IN, INDEX , INNER, IS, JOIN, KEY, LEADING, LEFT, LENGTH, LIKE,LOCATE, LOWER, MAX | |
Is ObjectDB scalable? What are its limitations? classes per database file. Up to 2,147,483,648 indexes per database file | |
Numbers in JPQL and Criteria Queries functions - when the return value is numeric, e.g. INDEX , SIZE. as string functions - when the return | |
ObjectDB Overview a single file. Advanced querying and indexing capabilities. Effective in heavy loaded multi-user | |
[ODB1] Chapter 4 - JDO Metadata identity supported by ObjectDB. To enforce unique values in a field you can define a unique index as ... of the element has effect only in index declarations, as explained in the next section. 4.5 Index Definition Querying a large extent without indexes may take a significant amount of time | |
combined index not used.properties.doubleValue In the class Action we have a combined index (see attachment) but in the query plan we can see that this index is not used: Query Plan Description ====================== Step 1: Process Action (a) instances ------------------------------------ [Step 1a] Scan index com.agile | |
Problem using "and" for joined entities and indexed fields Using @ Index for fields and filter more than one field with "and" predicate ends in empty result ... ({ @ Index (members = {"children.name"}), @ Index (members = {"children.age"}) })   | |
[ODB1] Chapter 9 - ObjectDB Explorer and selecting "Rebuild Class Extent". The "Rebuild All Indexes " command starts a thread that scans the entire database and rebuilds all the indexes . This tool is useful when adding a new index (in the JDO ... "Rebuild Class Indexes ". Server Tools In the server edition of ObjectDB, the Explorer supports transferring | |
Step 6: Set the Spring XML.DispatcherServlet 2 spring *.html 30 index .jsp The settings above routes web requests with .html suffix | |
Step 6: Set the Spring XML: spring org.springframework.web.servlet.DispatcherServlet 2 spring *.html 30 index .jsp The settings | |
Step 7: Run the Spring Web App At this stage your project should have the following structure: Use copy and paste to replace the content of the index .jsp file (which serves as the default front page) with the following redirection to the controller path: If Tomcat 6.0 is installed as a server in your Eclipse -  | |
Step 7: Run the Spring Web App At this stage your project should have the following structure: Use copy and paste to replace the content of the index .jsp file (which serves as the default front page) with the following redirection to the controller path: Assuming that Tomcat 6.0 is installed as a server in your NetBeans | |
javax.jdo.annotations.Index JDO Annotation Index Target: ElementType.TYPE, ElementType.FIELD, ElementType.METHOD Implemented Interfaces: Annotation Annotation for a database index . Used for database schema generation to create indexes . Corresponds to the xml element " index ". Since: JDO 2.1 Public Annotation Attributes Column | |
javax.jdo.annotations.Index.table JDO Annotation Attribute in javax.jdo.annotations. Index String table default "" Table for the index . This is needed iff annotating a type where the index is not defined on the primary table for the type. Since: JDO 2.1 | |
javax.jdo.annotations.Key.index JDO Annotation Attribute in javax.jdo.annotations.Key String index default "" The name of the index to generate. Since: JDO 2.1 | |
javax.jdo.annotations.Key.indexed JDO Annotation Attribute in javax.jdo.annotations.Key String indexed default "" Whether the value column(s) should be indexed . Since: JDO 2.1 | |
javax.jdo.annotations.Value.index JDO Annotation Attribute in javax.jdo.annotations.Value String index default "" The name of the index to generate. Since: JDO 2.1 | |
javax.jdo.annotations.Value.indexed JDO Annotation Attribute in javax.jdo.annotations.Value String indexed default "" Whether the value column(s) should be indexed . Since: JDO 2.1 | |
javax.jdo.annotations.Version.indexed JDO Annotation Attribute in javax.jdo.annotations.Version String indexed default "" Whether the version column(s) is(are) indexed . Since: JDO 2.1 | |
javax.jdo.annotations.Index.unique JDO Annotation Attribute in javax.jdo.annotations. Index String unique default "" Whether this index is unique Since: JDO 2.1 | |
javax.jdo.annotations.Index.columns JDO Annotation Attribute in javax.jdo.annotations. Index Column [] columns default {} Columns that compose this index . Since: JDO 2.1 | |
javax.jdo.annotations.Index.members JDO Annotation Attribute in javax.jdo.annotations. Index String[] members default {} Member (field and property) names that compose this index . Since: JDO 2.1 | |
javax.jdo.annotations.Index.name JDO Annotation Attribute in javax.jdo.annotations. Index String name default "" Name of the index Since: JDO 2.1 | |
javax.jdo.annotations.Join.index JDO Annotation Attribute in javax.jdo.annotations.Join String index default "" The name of the index to generate. Since: JDO 2.1 | |
javax.jdo.annotations.Join.indexed JDO Annotation Attribute in javax.jdo.annotations.Join String indexed default "" Whether the join column is indexed . Since: JDO 2.1 | |
javax.jdo.annotations.Discriminator.indexed JDO Annotation Attribute in javax.jdo.annotations.Discriminator String indexed default "" Whether the discriminator is indexed . Since: JDO 2.1 | |
javax.jdo.annotations.Element.index JDO Annotation Attribute in javax.jdo.annotations.Element String index default "" The name of the index to generate. Since: JDO 2.1 | |
javax.jdo.annotations.Element.indexed JDO Annotation Attribute in javax.jdo.annotations.Element String indexed default "" Whether the value column(s) should be indexed . Since: JDO 2.1 | |
[ODB1] Chapter 7 - JDOQL Queries are included in the result collection. If an index is defined for the age field (see section 4.5 | |
[ODB1] Chapter 1 - About ObjectDB of objects per second. Even queries on millions of objects are very fast, when proper indexes are defined |