Work with virtual data

Virtual data are data that are not persistent in a database. These data are stored only in memory and are used to:

     Validate a data model by manipulating and querying the data in a database sandbox.

     Generate test data.

      To fill in virtual data: You can fill in virtual data manually, or you can populate the grid automatically using the data generators (see the section “Assign Data Generator settings”).

      To populate the virtual data grid automatically:

1.    Open the “Virtual data” form by clicking on “Tools\Virtual Data”. On the “Data” tab select the column that you want to fill in with virtual data. You need to set the number of rows that you want to populate in the grid.

2.    Then, click the populate buttonimage.

image

You can delete all populated data by clicking the delete button image . You can also add, edit, or delete a single row.

      To populate the virtual data grid manually:

Use the toolbar buttons to manually fill in the grid. You can also edit or delete an existing row.

Note: If you fill in data manually, be careful when the data type is serial or auto-increment; you need to respect the sequencing rule. If you insert random data, an issue can arise when you generate persistent data from the virtual data to populate your database.

     To view virtual data:

You can display the data as a grid or as a form. To switch the view, click the Grid View button image  or the Form View button imageat the bottom.

Button

Description

image

Add record: Fill in a new record manually.

image

Delete record: Delete any selected record(s).

image

Edit records: Edit an existing record.

image

Apply changes: Apply the changes made to a record.

image

Discard changes: Cancel all edits made to a record.

image

Set number of rows: Set the number of rows that you want to populate in the grid.

image

Populate the grid: Populate the grid using the data generators.

image

Clear the grid: Clear all existing data in the grid.

image

First record: Move to the first record.

image

Last record: Move to the last record.

image

Next record: Move to the next record.

image

Previous record: Move to the previous record.

image

Grid view: Switch to grid view.

image

Form view: Switch to form view.

 

     To query virtual data:

You can manipulate virtual data by using the query tool, accessed by clicking the “Query” tab.

 

image

 

Use the toolbar buttons to do the following:

Button

Description

image

Open a saved SQL query

image

Save an SQL query

image

Execute an SQL query

image

Navigate to the previous query

image

Navigate to the next query

image

First record: Move to the first record.

image

Last record: Move to the last record.

image

Next record: Move to the next record.

image

Previous record: Move to the previous record.

 

Available in: Professional and Enterprise Editions