# category：Course

## esProc Charts: The Sector Element

Used only in polar coordinates, the sector element is usually for plotting a pie chart. Here we’ll explain how it is employed and its properties. 1. Data properties Through the following pie chart for displaying vault results, we’ll discuss the basics of plotting the sector element.   A 1 =canvas() 2 =demo....

2015-06-01 465

## esProc Charts: The Column Element

The column element is frequently used in plotting various charts. We’ve made some studies about it in esProc Charts: Coordinate Axes through examples. Here we’ll illustrate the setting of its properties and their roles. 1. Data properties The plotting algorithm below for plotting a clustered column chart of gym results...

2015-05-28 627

## esProc Charts: The Line Element

We learned how to plot a dot chart element using logical coordinates in esProc Charts: The Dot Element. Here we’ll learn about plotting the line element. The line element is another one of the most basic chart elements, which is positioned by at least two pairs of logical coordinates. If there are more logical coordina...

2015-05-26 593

## esProc Charts: The Axis Element

In esProc Charts: Coordinate Axes, we learned the basic usages of different coordinate axes and the setting of their properties. Once a logical axis is properly defined, the logical coordinates on it can be transformed into corresponding physical coordinates, according to which a certain chart element can be plotted. &...

2015-05-22 603

## esProc Charts: The Dot Element

We talked about different types of coordinate axis used in esProc in esProc Charts: Coordinate Axes and learned that a chart element can be plotted on the coordinate plane after defining a pair of axes. From this article, we’ll discuss how to plot a chart according to specified position starting from the simplest dot e...

2015-05-20 624

## esProc Charts: Coordinate Axes

In esProc Charts: Coordinate Systems and Coordinate Transformation, we discussed the relation between logical axes and physical axes in plotting a chart with esProc, as well as how to position an axis and a chart element on the canvas. esProc provides a variety of logical axes for plotting different styles of charts. L...

2015-05-18 618

## esProc Charts: Coordinate Systems and Coordinate Transformation

Regarding the chart element plotting, compared with setting the appearance properties for a chart element like color and line style, it is more important to specify its position. When plotting a chart, statistical values are often used to determine its position. Therefore you will need to create a coordinate system on ...

2015-05-14 590

## Application of Index Sequences in esProc

In databases, creating appropriate indexes for tables can greatly increase query efficiency. Similarly, index sequences can be created for record sequences or table sequences in esProc to increase efficiency in querying data repeatedly.  For example, we need to access the food order Order_Foods.txt repeatedly. ...

2015-05-13 419

## Using Cursor in esProc

With esProc, you can handle the structured big data easily, and perform data computing and analysis without difficulty. Because the big data table cannot be loaded into the memory all at once, the basic solution is using cursor to handle it. 1. Basic principle of cursor The esProc cursor is like the database cursor in ...

2015-05-12 429

## Referencing Thinking in esProc

1. Foreign key referencing The foreign key is a common concept for various relational databases. In a relational table, you can define one or multiple fields as the foreign key. The foreign key field values can be associated with the data in another table. For example, in the game scoring report, player scores are usua...

2015-05-11 606

## esProc Set Thinking

1. Sequences and sets in esProc Unlike traditional programming languages, esProc employs sets commonly. In fact, the sequence in esProc belongs to the field of set. So it’s quite important to deeply understand the concept of sets when using esProc. Like an integer and a string, the set is a basic esProc data type; it c...

2015-05-07 424

## esProc Integration & Application: Integration by BIRT

esProc provides standard JDBC to integrate with BIRT and other reporting tools. Here we’ll explain the process of integration of esProc and BIRT in development environment and WEB application environment. 1. Integration in development environment 1.1  Create configuration files Create the two configuration files –...

2015-04-27 1258

## esProc Integration & Application: License and Encryption

1. File encryption esProc provides ways of encrypting cellset files to protect them from unauthorized access or use. There are two levels of encryption: Execution privilege：By this privilege, users can set parameters, execute the cellset and see the cell values; they can also view the cellset descriptions and cell tips...

2015-04-24 389

## esProc Charts: The Basics

esProc provides flexible charting functionality. It allows users to define parameters and data used for charting with the graphics editor, and to draw various styles of charts as needed using drawing functions. 1. General charting procedure Let’s learn of the general procedure of charting in esProc through the followin...

2015-04-23 538

## Using Sequence Numbers and Locating Data in esProc

1. Accessing members Members in a set of esProc (sequence) are organized in order. Therefore, you can reference a member in a set with its sequence number. The more flexible use of sequence numbers, the better esProc functions to make operations simpler and more efficient. Thus sequence numbers or an integer sequence (...

2015-04-02 539