Instant JChem Dictionary

IJC expression

Definition

Project

All your data in IJC is organised into a project. You can have a single project, or if you need to keep your data separate then you can create a different project for each purpose. The Main contents of a project are displayed in the projects window.

Schema

An IJC Schema is a collection of Entities and Data Trees that are defined for a database connection. As such it reflects all the database tables and related artifacts available from the database connection.

Data Tree

A Data Tree in IJC provides a hierarchical representation of relational data, allowing master detail data to be represented. Views belong to a Data Tree, and display the data represented by it. You can create multiple Views for a Data Tree, and these Views will be coordinated in terms of data and selection.

When a query is performed, it is applied to the contents of the Data Tree.

View

A View in IJC offers a visual representation of data. For example, IJC currently supports two view types: the Grid View, which emphasizes data display from a single database table, and the Form View, which allows more complex reports to be built, including those for master-detail data.

Grid View

The Grid View provides a tabular (or spreadsheet like) view of data. It is the simplest View of data provided in Instant JChem. In comparison, the Form View provides a more sophisticated way to view data.

Form View

The Form View allows you to design a form which you can use to view and analyse your data. In comparison to the Grid View, it provides a more sophisticated way to view your data and allows you to use relational data.

Widget

A Widget is a component of the Form View. It occupies a rectangular region of the form and is responsible for displaying its data in a manner particular to the Widget.

Entity

An Entity represents a set of data that can be represented as a set of rows and columns. In the simplest case, it represents a database table, but more complex arrangements are also possible.

Relationship

A Relationship represents an association between rows in 2 Entities. For each row in one Entity there will be one or more associated rows in the other Entity. The type of Relationship provides a restriction on the number of associated rows.

Fields

Fields represent the columns of the row/column paradigm of an IJC Entity. Typically a field represents a column from a database table, though more complex arrangements are also possible. Some fields have values that are editable whilst other types have their values automatically generated.

Schema Editor

The Schema Editor allows you to manage all table Entities existing under a selected database connection. From the Schema Editor, you can view settings for tables as well as individual Fields. You can also edit tables and Fields, such as by adding or deleting, renaming or customizing. The Schema Editor can be accessed by choosing Edit Schema from the right-click menu of a connection node ( images/download/attachments/1804949/Connection16.gif or images/download/attachments/1804949/ConnectionRemote.gif ) in the Projects Window.