Hardware and software setup

What you need to install workbench. Visual Database Creation with MySQL Workbench

With the advent of the MySQL Workbench program as part of MySQL, the process of creating databases (DB) was greatly simplified. After all, what previously had to be done manually using a SQL script and command line, can now be done “in visual mode” using a friendly graphical interface.

Consider the process of creating a database using MySQL Workbench in more detail.

The screenshot below shows general form MySQL Workbench window.

In order to create a database, you need to right-click in the left panel in the area with the database list (marked as SCHEMAS) and select "Create Schema" in the context menu.

After that, a tab will appear in which you should specify the name of the new database and specify the sorting options. The database, for example, will be named mynewdatabase. You can either select sorting options from the drop-down list or leave the default ones (in this example left with the default settings).

After that, to continue creating the database, you should click the "Apply" button. The dialog box that appears will show the generated MySQL Workbench SQL database creation script. If necessary, this script can be edited directly in this window.

There is an Online DDL area at the top of the window. It is intended for setting script execution parameters. These options can be useful when manipulating an already existing database. When creating a database, it is recommended to leave the default values ​​(“Default”).

MySQL Workbench - software, created for database design. In the presence of a catalog of tools for operating and modeling the database. The tool is characterized by high performance.

The use of the software is recommended for complex transition. The tables display saved processes, foreign keys. An integrated shell is supported that allows you to write scripts. First of all, the program is a design tool for visual graphic representation. There is an editor that allows you to adjust requests with subsequent sending through the server. Accepted responses are presented in the form of tables. When rendered, the user retains the ability to make edits.

Download for free the full Russian version of MySQL Workbench from the official website without registration and SMS.

System requirements

  • Supported OS: Windows 10, Vista, 8.1, XP, 7, 8
  • Bit depth: 64 bit, 32 bit, x86

Open the start menu and type 'Workbench'. Select MySQL Workbench from the list.

A window called the home screen will open.

home screen

At the top you can see a list of connections to the DBMS. These controls are used to connect to the DBMS and direct control.

At the bottom is a list models. Models are used to visually design databases.

Connections

“Tile” connections

When you move the mouse cursor over the connection, the corner of the “tile” is bent. If you click on this “corner”, information about the connection will be displayed: DBMS version, date of last use, DBMS server address, login, etc.


Connection information

In the lower right corner there is a ‘Connect’ button that will open this connection.

The connection can also be opened by clicking on the “tile” itself.

Open the first connection in the list.

SQL query editor

After opening the connection, the SQL query editor window opens.


SQL Query Editor Window

In the center we see the query editing window.

back to home screen You can return by clicking on the icon in the upper left corner of the window.

On the left is a navigator that displays the main tasks and a list of database objects.

In the lower left corner there is an information window about the selected object.

On the right is the help window.

Below is the query history window.

In the upper right corner are controls that allow you to hide or show the sidebars.

Executing queries


SQL Editor - SQL Query Panel

Let's query the world database. First, let's select the world database as the active database.

To do this, find the world object in the navigator, and select it by double-clicking, or by right-clicking and selecting Set as Default Schema from the context menu.

Now we can query the world database.

Comment

You can also select an active base by running a query

USE schema_name;

For instance,

USE world;

To begin with, we will request a list of tables in the selected database. To do this, in the SQL query editing window, write

SHOW TABLES ;

When entering a query, the help window automatically displays hints on the syntax of the entered query, if this feature is enabled. To enable automatic suggestion, click the third toolbar button from the left in the help window.

Then click on the button for executing the query (yellow lightning), or select from the menu Query → Execute (All or Selection) . Keyboard shortcut - ctrl + shift + enter

Other SQL Query Window Bar Buttons

SQL Editor - Toolbar

From left to right, buttons:

    Open an SQL Script File: Loads the contents of a previously saved request from a file.

    Save SQL Script to File: Save request to file

    Execute SQL Script: Executes the selected part of the request, or the entire request if nothing is selected.

    Execute Current SQL script: Executes the expression that the text cursor is on.

- **Explain (All or Selection)**: Displays for the selected part of the query or the entire query information about the work of the optimizer.

    Stop the query being executed: Aborts the current request.

    Toggle whether execution of SQL script should continue after failed statements: Toggles behavior on errors in expressions. If the button displays a red circle, then the query execution is interrupted if one of the expressions fails to execute.

    Otherwise, if a green arrow is displayed, the expressions with errors are skipped and the query continues.

    Commit: Confirms the current transaction

    Rollback: Cancels the current transaction

    Toggle Auto-Commit Mode: If enabled, each expression will be automatically validated.

    Set Limit for Executed Queries: Limit the number of query results.

    Beautify SQL: Format query text.

    Find panel: Display the search bar in the query body.

    invisible characters: Display “invisible” characters.

    Wrapping: Enable word wrap.

The query result window will open.

In the center of the result window is the result of the query - in our case, a list of table names. On the right are display style selection buttons:

  • Result Grid– as a table (default)
  • Form Editor- as a form. Each entry opens on a separate page, at the top of the window there are arrows for navigating through the entries.
  • Field Types– Displays the attribute types of the result.
  • Query Stats– displays various query statistics
  • Execution Path– shows the algorithm of the optimizer

Let's see how the Country table is arranged. To do this, run the command

SELECT * FROM Country;

and choose the style of displaying the result Field Types.

Comment

Running a run query starts all expressions that are written in the query window. If several expressions are written in the query window, separated by a semicolon, they will be executed sequentially. Therefore, delete or comment on requests that have already been completed.

Comments in SQL begin with a double hyphen, like this:

A comment -- SHOW TABLES; SELECT * FROM Country;

V this moment we are interested in the attributes (columns) Name - the name of the country and LifeExpectancy - the average life expectancy of citizens.

Let's display a list of countries with an average life expectancy of citizens over 80 years. To do this, run the query

Another query that can be run on the Country table is the number of countries by government.

SELECT GovernmentForm, COUNT (Name) FROM Country GROUP BY GovernmentForm;

Database creation

To create a database, you can run a query

CREATE DATABASE db_name;

Create a database called myFirstDatabase:

CREATE DATABASE myFirstDatabase;

To display the created database in the list of objects, right-click on an empty space in the list and select Refresh All .

Select myFirstDatabase as active.

Create a table

Let's create a People table consisting of the id , name , birthday columns:

CREATE TABLE People ( id BIGINT AUTO_INCREMENT PRIMARY KEY , name TINYTEXT NOT NULL , birthday DATE );

Note There is a graphical table creation tool. We will analyze it when we work with the graphical database design tool.

Check that the table has been created:

SHOW TABLES ;

* FROM People;

Adding and editing data

When all columns of a table are selected, Workbench allows you to edit records directly through the query result interface. Select the style to display the result of the Form Editor , and enter values ​​for the name and birthday attributes. The latter is entered in the format YYYY-MM-DD , for example, for September 1, 2015, enter 2015-09-01 .

Leave the id field empty.

In the lower right corner of the result window, you can see the Apply and Revert buttons. The first one will generate and execute the INSERT SQL statement, and the second one will undo the changes.

Click on Apply , view the generated request, and apply it. If everything is done correctly, then a new record is inserted into the table. Complete a request

SELECT * FROM People;

again to be sure.

Note You can also add and edit entries in the result table display.

Deleting data

Data can be deleted from the results window using the Delete selected rows toolbar button.

Another way is to execute a SQL query

For example, let's delete an entry with some id value from the People table:

Substitute for 1 some of the existing values.

Note By default, Workbench executes queries with the SQL_SAFE_UPDATES option. This option prevents UPDATE and DELETE queries from being made without specifying a WHERE clause with a primary key (in this case, id).

Import and export

Export

In the navigator, select Data Export . Select the databases and tables you want to export. Optionally check other objects you want to export: Dump Stored Procedures and Functions , Dump Events , Dump Triggers .

Select Export to Self-Contained File and the file where the export will be saved.

Do not check Include Create Schema: this option will include the CREATE DATABASE statement in the export.

Click on the Start Export button.

Import

In the navigator, select Data Import/Restore . Select Import from Self-Contained File .

Select the database to be imported into from the Default Target Schema drop-down list. You can also create a new database by clicking the New...

Click Start Import .

Deleting tables

To delete tables use the query

DROP TABLE tbl_name;

Delete the People table

DROP TABLE People;

Deleting a database

To delete the database, use the query

DROP DATABASE tbl_name;

Delete table myFirstDatabase

DROP DATABASE myFirstDatabase;

The development of any electronic device is accompanied by physical or mathematical modeling. Physical modeling is associated with high material costs, since it requires the manufacture of mock-ups and their labor-intensive research. Often, physical modeling is simply not possible due to the extreme complexity of the device, for example, in the development of large and extra-large integrated circuits. In this case, resort to mathematical modeling using the means and methods of computer technology.

For example, the well-known P-CAD package contains a block of logical modeling of digital devices, but for beginners, including students, it presents significant difficulties in mastering. No less difficulties are encountered when using the DesignLab system. As the condition analysis showed software circuit modeling, at the stage of initial development of computer-aided design methods and at the stages of research and development, it is advisable to consider the possibility of using the following programs such as Electronics Workbench - EWB.
The Electronics Workbench circuit simulation system is designed for simulation and analysis electrical circuits fig.1. It is correct to say: a system for modeling and analyzing electrical circuits Electronics Workbench, but for brevity, hereinafter we will call it a program.
The Electronics Workbench program allows you to simulate analog, digital and digital-analog circuits of a high degree of complexity. The libraries available in the program include a large set of widely used electronic components. It is possible to connect and create new component libraries.

Component parameters can be changed in a wide range of values. Simple components are described by a set of parameters, the values ​​of which can be changed directly from the keyboard, active elements - by a model, which is a set of parameters and describes a specific element or its ideal representation.
The model is selected from the list of component libraries, the model parameters can also be changed by the user. A wide range of instruments allows you to measure various quantities, set input effects, build graphs. All devices are displayed in a form as close as possible to the real one, so working with them is simple and convenient.
Simulation results can be output to a printer or imported into a text or graphics editor for further processing. The Electronics Workbench program is compatible with the P-SPICE program, that is, it provides the ability to export and import circuits and measurement results in various versions of it.

The main advantages of the program
Saving time Working in a real laboratory requires a lot of time to prepare an experiment. Now, with the advent of Electronics Workbench, the electronic laboratory is always at hand, making the study of electrical circuits more accessible. Measurement reliability
In nature, there are no two completely identical elements, that is, all real elements have a wide range of values, which leads to errors during the experiment. In Electronics Workbench, all elements are described strictly set parameters, therefore, each time during the experiment, the result will be repeated, determined only by the parameters of the elements and the calculation algorithm.
Ease of measurements Learning is impossible without mistakes, and mistakes in a real laboratory are sometimes very expensive for the experimenter. Working with Electronics Workbench, the experimenter is insured against accidental electric shock, and the devices will not fail due to incorrect assembled circuit. Thanks to this program, the user has such a wide range of devices at his disposal, which is unlikely to be available in real life.
Thus, you always have a unique opportunity to plan and conduct a wide range of studies electronic circuits at minimal cost time. Graphic features Complex schemes take up a lot of space, while trying to make the image more dense, which often leads to errors in connecting conductors to circuit elements. Electronics Workbench allows you to place the circuit in such a way that all the connections of the elements and at the same time the entire circuit are clearly visible.

The intuitiveness and simplicity of the interface make the program accessible to anyone familiar with the basics of using Windows. Compatibility with P-SPICE The Electronics Workbench program is based on standard elements of the SPICE program. This allows you to export various models of elements and process the results using additional features. various versions P-SPICE program.

Components and experimentation
The program component libraries include passive elements, transistors, controlled sources, controlled switches, hybrid elements, indicators, logical elements, trigger devices, digital and analog elements, special combinational and sequential circuits.
Active elements can be represented by models of both ideal and real elements. It is also possible to create your own element models and add them to the element libraries. The program uses a large set of instruments for measurements: an ammeter, a voltmeter, an oscilloscope, a multimeter, a Bode plotter (plotter of the frequency characteristics of circuits), a function generator, a word generator, a logic analyzer and a logic converter.
Circuit Analysis Electronics Workbench can analyze DC and AC circuits. When analyzing at direct current, the operating point of the circuit in the steady state of operation is determined. The results of this analysis are not reflected on the instruments, they are used for further analysis of the circuit. AC analysis uses the results of DC analysis to obtain linearized models of non-linear components.
Analysis of circuits in AC mode can be carried out in both time and frequency domains. The program also allows you to analyze digital-analog and digital circuits. In Electronics Workbench, you can explore transients when exposed to circuits of input signals of various shapes.

Operations performed during analysis:
Electronics Workbench allows you to build circuits of varying degrees of complexity using the following operations:
. selection of elements and devices from libraries,
. moving elements and schemes to any place of the working field,
. rotation of elements and groups of elements by angles that are multiples of 90 degrees,
. copying, pasting or deleting elements, groups of elements, circuit fragments and entire circuits,
. changing the color of conductors,
. color highlighting of circuit outlines for easier perception,
. simultaneous connection of several measuring instruments and observation of their testimony on monitor screen,
. assigning a symbol to an element,
. changing the parameters of elements in a wide range. All operations are performed using the mouse and keyboard. Control only from the keyboard is not possible.

By configuring devices, you can:
. change instrument scales depending on the measurement range,
. set the operating mode of the device,
. set the type of input actions on the circuit (constant and harmonic currents and voltages, triangular and rectangular pulses).
The graphical capabilities of the program allow:
. simultaneously observe several curves on the chart,
. display curves on graphs in different colors,
. measure the coordinates of points on the graph,
. import data into a graphics editor, which allows you to make the necessary transformations of the picture and output it to the printer.
Electronics Workbench allows you to use the results obtained in the P-SPICE, PCB programs, as well as transfer the results from Electronics Workbench to these programs. You can insert a diagram or a fragment of it into text editor and print in it explanations or comments on the operation of the circuit.

Working with Electronics Workbench
The Electronics Workbench program is designed for modeling and analysis of electronic circuits. The capabilities of the Electronics Workbench v.5 program are roughly equivalent to those of the MicroCap program and allow you to perform work from simple experiments to statistical modeling experiments.
When creating a schematic, Electronics Workbench allows you to:
- select elements and devices from libraries,

Move elements and schemes to any place of the working field,

Rotate elements and their groups by angles that are multiples of 90 degrees,

Copy, paste or delete elements, fragments of diagrams,

Change conductor colors

Highlight circuit outlines with color,

Simultaneously connect several measuring devices and observe their readings on the monitor screen,
- assign symbols to elements,

Change element settings.

By changing the device settings, you can:
- change instrument scales depending on the measurement range,

Set the operating mode of the device

Set the type of input actions on the circuit (constant or harmonic currents or voltages, triangular or rectangular pulses).

Insert a scheme or its fragment into a text editor, in which an explanation of the operation of the scheme is printed.

Electronics Workbench Components
After launching WEWB32, the menu bar and component bar appear on the screen.
The component panel consists of icons of component fields, and the component field consists of conditional images of components.
A mouse click on a component icon opens the field corresponding to that icon.
Below are some of the elements from the component fields:

Basic (basic components)

Connecting node

The node is used to connect conductors and create control points.

Resistor

Resistor resistance can be set as a number in Ohm, kOhm, MOhm

Capacitor

the capacitance of the capacitor is given by a number indicating the dimension (pF, nF, μF, mF, F).

Key

A key controlled by a key. Such keys can be closed or opened using controlled keys on the keyboard. (The name of the control key can be entered from the keyboard in the dialog box that appears after double-clicking on the image of the key.)

Sources

Land

The "Ground" component has zero voltage and serves as a reference point for potentials.

A source constant voltage 12V

EMF of a constant voltage source is indicated by a number with an indication of the dimension (from μV to kV)

DC power supply 1A

The current of the DC source is set by a number indicating the dimension (from μA to kA)

AC voltage source 220 V / 50 Hz

The effective value (root-mean-sguare-RMS) of the source voltage is given by a number indicating the unit (from μV to kV). It is possible to set the frequency and the initial phase.

AC source 1 A/1 Hz

The effective value of the source current is given by a number indicating the dimension (from μA to kA). It is possible to set the frequency and the initial phase.

Clock generator 1000 Hz / 50%

The generator generates a periodic sequence of rectangular pulses. You can adjust the amplitude of the pulses, the duty cycle and the frequency of the pulses.

Indicators (Instruments from the library of indicators)

The simplest instruments are the voltmeter and ammeter. They automatically change the measuring range. In one scheme, you can use several of these devices at the same time.

Voltmeter

A voltmeter is used to measure AC or DC voltage. The thick lined side of the rectangle corresponds to the negative terminal.
Double-clicking on the voltmeter image opens a dialog box for changing the voltmeter parameters:
-values internal resistance(default 1MΩ),
- type of measured voltage (DC-constant, AC-variable).
When measuring alternating sinusoidal voltage (AC), the voltmeter shows the effective value

Ammeter

An ammeter is used to measure AC or DC current. The thick lined side of the rectangle corresponds to the negative terminal.
Double-clicking on the image of the ammeter opens a dialog box for changing the parameters of the ammeter
Internal resistance values ​​(default 1mΩ),
Type of measured voltage (DC-constant, AC-variable).
When measuring alternating sinusoidal voltage (AC), the ammeter shows the effective value

instruments

1.Function generator

The generator is an ideal voltage source that generates sinusoidal, or triangular, or rectangular waveforms. The middle terminal of the generator, when connected to the circuit, provides a common point for reading the amplitude of the alternating voltage. To read the voltage relative to zero, this pin is grounded. The leftmost and rightmost pins are used to supply a signal to the circuit. The voltage on the right terminal changes in a positive direction relative to the common terminal, on the left terminal - in a negative direction.
Double-clicking on the generator image opens an enlarged generator image where you can set:
- the shape of the output signal,
- output voltage frequency (Frequency),
- duty cycle (Duty cycle),
- output voltage amplitude (Amplitude),
- the constant component of the output voltage (Offset).

2. Oscilloscope

There are four input terminals on the oscilloscope image
- top right clip - common,
- lower right - synchronization input,
- The left and right bottom terminals represent the Channel A and Channel B inputs, respectively.
Double-clicking on the thumbnail of an oscilloscope opens an image of a simple oscilloscope model on which you can set
- the location of the axes along which the signal is delayed,
- the desired scale of the sweep along the axes,
- offset of the origin along the axes,
- capacitive input (AC button) or potential input (DC button) of the channel,
- synchronization mode (internal or external).

The Trigger field is used to determine the start of the sweep on the oscilloscope screen. The buttons in the Edge line set the moment of triggering the oscillogram on the positive or negative edge of the pulse at the synchronization input. The Level field allows you to set the level above which the sweep is triggered.
Buttons Auto, A, B, Ext set synchronization modes
-Auto - automatic start sweep when you turn on the circuit. When the beam reaches the end of the screen, the waveform is recorded from the beginning of the screen,
-A - the trigger is the signal at input A,
-B - triggering is the signal at input B,
-Ext - External start. In this case, the trigger signal is the signal applied to the clock input.

Pressing the EXPAND button on a simple oscilloscope model opens the expanded oscilloscope model. Unlike a simple model, there are three information boards here, which display the measurement results. In addition, directly below the screen there is a scroll bar that allows you to observe any time interval from the moment the circuit is turned on to the moment the circuit is turned off.

On the oscilloscope screen there are two cursors (red and blue), marked 1 and 2, with which you can measure the instantaneous voltage values ​​at any point on the oscillogram. To do this, the cursors are dragged with the mouse to the required position (the triangles in the upper part of the cursor are captured with the mouse).
The coordinates of the intersection points of the first cursor with oscillograms are displayed on the left board, the coordinates of the second cursor on the middle board. The right panel displays the values ​​of the differences between the corresponding coordinates of the first and second cursors.
The Reduce button provides a transition to a simple oscilloscope model.

3. Plotter (Bode plotter)

Used to build amplitude-frequency (AFC) and phase-frequency<ФЧХ) характеристик схемы.
The plotter measures the ratio of signal amplitudes at two points in the circuit and the phase shift between them. For measurements, the plotter generates its own frequency spectrum, the range of which can be set when setting up the device. The frequency of any AC source in the circuit under study is ignored, but the circuit must include some kind of AC source.
The plotter has four clamps: two input (IN) and two output (OUT). The left pins of the IN and OUT inputs are connected to the points under test, and the right pins of the IN and OUT inputs are grounded.
Double-clicking on the plotter image opens its enlarged image.

The MAGNITUDE button is pressed to get the frequency response, the PHASE button - to get the phase response.
The VERTICAL panel defines:
-initial (I) value of the vertical axis parameter,
-final (F) value of the vertical axis parameter
- type of vertical axis scale - logarithmic (LOG) or linear (LIN).
The HORIZONTAL panel is set up in the same way.
Upon receipt of the frequency response, the voltage ratio is plotted along the vertical axis:
- on a linear scale from 0 to 10E9;
- on a logarithmic scale from -200 dB to 200 dB.
Upon receipt of the PFC, degrees from -720 degrees to +720 degrees are plotted along the vertical axis.
The horizontal axis always represents the frequency in Hz or derived units.
The cursor is located at the beginning of the horizontal scale. The coordinates of the cursor moving point with the graph are displayed in the information fields at the bottom right.

circuit modeling
The circuit under study is assembled on the working field using the mouse and keyboard.
When building and editing schemes, the following operations are performed:
-selection of a component from the library of components;
- selection of an object;
- movement of the object;
-copying objects;
-removal of objects;
- connection of circuit components with conductors;
-setting the values ​​of the components;
- connection of measuring devices.
After building the circuit and connecting devices, the analysis of the operation of the circuit begins after pressing the switch in the upper right corner of the program window (in this case, the moments of the circuit time are shown in the lower left corner of the screen).
Pressing the switch again stops the circuit.
You can pause while the circuit is running by pressing the F9 key on the keyboard; pressing F9 again restarts the circuit (a similar result can be achieved by pressing the Pause button located under the switch.)
The choice of the component necessary for constructing the circuit is made after selecting the field of components containing the necessary element. This element is captured by the mouse and moved to the working area.
Selecting an object. When selecting a component, left-click on it. In this case, the component turns red. (You can remove the selection by clicking anywhere in the workspace.)
Moving an object. To move an object, select it, place the mouse pointer on the object and, holding down the left mouse button, drag the object.
The object can be rotated. To do this, you must first select the object, then right-click and select the desired operation.
-Rotate (rotate 90 degrees),
-Flip vertical (flip vertically),
-Flip horizontal (flip horizontally)
Copying of objects is carried out by the Copy command from the Edit menu. Before copying the object must be selected. When the command is executed, the selected object is copied to the buffer. To paste the contents of the clipboard into the workspace, select the Paste command from the Edit menu
Removing objects. Selected objects can be deleted with the Delete command.
Connection of circuit components with conductors. To connect components with conductors, you need to move the mouse pointer to the pin of the component (in this case, a black dot will appear on the pin). Pressing the left mouse button, move the mouse pointer to the pin of the component you want to connect to, and release the mouse button. The terminals of the components will be connected by a conductor.
The color of the conductor can be changed by double-clicking on the conductor with the mouse and selecting the desired color from the window that appears.
Removing a conductor. If, for any reason, the conductor needs to be removed, it is necessary to move the mouse pointer to the output of the component (a black dot should appear). By pressing the left mouse button, move it to an empty area of ​​the working field and release the mouse button. The conductor will disappear.

Parameter values ​​are set in the component's properties dialog box, which is opened by double-clicking on the component image (Value tab).
Each component can be given a name (Label tab)
Connecting devices. To connect the device to the circuit, you need to drag the device from the toolbar to the working field with the mouse and connect the device leads to the points under study. Some devices must be grounded, otherwise their readings will be incorrect.
An enlarged instrument image appears when you double-click on the thumbnail image.
Exercise: Assemble the voltage divider circuit shown in the figure.
- Apply a sinusoidal voltage with a frequency of 3 kHz and an amplitude of 5 V to the circuit input from the function generator,
- Connect the same signal to channel A of the oscilloscope,
- Connect to the output of the divider channel B of the oscilloscope,
- highlight the conductors of channel A and channel B with different colors,
- Turn on the circuit, if necessary, change the settings of the measuring instruments,
-Go to advanced oscilloscope model. Using the cursor and the left information board, measure the amplitude value of the output signal.
-In addition, connect voltmeters to the input and output and turn on the circuit again.
Get the correct voltmeter readings.

Word generator
The diagram displays a reduced image of the word generator

The 16 outputs at the bottom of the generator feed the bits of the generated word in parallel.
The clock signal output (bottom right) is fed with a sequence of clock pulses at a given frequency.
The sync input is used to supply a clock pulse from an external source.
Double-click to open an enlarged image of the generator

The left side of the generator contains 16 bit words specified in hexadecimal code. Each code combination is entered using the keyboard. The number of the cell being edited (from 0 to 03FF, i.e. from 0 to 2047) is highlighted in the Edit box. During the operation of the generator, the address of the current cell (Current), the initial cell (Initial) and the final cell (Final) are displayed in the Address section. Issued to 16 outputs (at the bottom of the generator) code combinations are displayed in ASCII code and binary code (Binary).
The generator can operate in step, cyclic and continuous modes.
-Step button puts the generator in step mode;
- Burst button - in cyclic mode (all words are sent to the generator output once in sequence;
-Cycle button - in continuous mode. To stop continuous operation, press the Cycle button again.
The Trigger panel determines the moment the generator starts (Internal - internal synchronization, External - external synchronization when the data is ready.)
The external synchronization mode is used when the device under test can acknowledge (acknowledge) the receipt of data. In this case, the device, along with the code combination, receives a signal from the Data ready terminal, and the device under test must issue a data receive signal, which must be connected to the Trigger terminal of the word generator. This signal produces the next start of the generator.
The Breakpoint button breaks the generator in the specified cell. To do this, select the desired cell with the cursor, and then click the Breakpoint button
The Pattern button opens a menu with which you can
Clear buffer - erase the contents of all cells,
Open - load code combinations from a file with .dp extension.
Save - write all the combinations typed on the screen to a file;
Up counter - fill the screen buffer with code combinations, starting from 0 in the zero cell and then adding one in each subsequent cell;
Down counter - fill the screen buffer with code combinations, starting with FFFF in the zero cell and then decreasing by 1 in each subsequent cell;

Shift right - fill every four cells with combinations 8000-4000-2000-1000 and shift them to the right in the next four cells;
Shift left - the same, but shifted to the left.

Logic analyzer
A reduced image of the logic analyzer is displayed on the diagram

The logic analyzer is connected to the circuit using the pins on its left side. Simultaneously, signals can be observed at 16 points of the circuit. The analyzer is equipped with two sight lines, which allows you to get readings of time intervals T1, T2, T2-T1, as well as a horizontal scroll bar

The Clock block contains terminals for connecting a conventional External and selective Qualifier source of trigger signals, the parameters of which can be set using the menu called by the Set button.
You can trigger on the rising (Positive) or falling (Negative) edge of the trigger signal using an external (External) or internal (Internal) source. In the Clock qualifier window, you can set the value of the logical signal (0.1 or x) at which the analyzer is launched.
External synchronization can be carried out by a combination of logic levels applied to the inputs of the analyzer channels.

Liked the article? Share with friends!
Was this article helpful?
Yes
Not
Thanks for your feedback!
Something went wrong and your vote was not counted.
Thank you. Your message has been sent
Did you find an error in the text?
Select it, click Ctrl+Enter and we'll fix it!