Category Archives: Computing in memory

Code Examples of esProc Foreign Key Function

If k (a single field or a combination of fields) is table M’s primary key, and k, at the same time, exists in table B, then k is regarded as B’s foreign key. The foreign key defines a relationship between … Continue reading

Posted in Computing in memory | Tagged , , | Leave a comment

An Example of esProc Set Operations

There are a lot of occasions when set operations are needed to do structured data summarizing and analysis. For example, to list all students who have published papers, find the employees who have participated in all trainings and select students … Continue reading

Posted in Computing in memory | Tagged , , | Leave a comment

esProc Performs Inner and Outer Joins: Code Examples

Related computing includes inner join and outer join. The outer join can be further divided into left join, right join, and full join. esProc performs these joins conveniently. In the discussion below, we’ll learn how esProc does the job using … Continue reading

Posted in Computing in memory | Tagged , , , , | Leave a comment

Grouping In-memory Data Using esProc: Code Examples

Using esProc, it is quite convenient to group data in memory. There are several main types of grouping based on how data is grouped. Here we’ll illustrate equal grouping, alignment grouping and enumeration grouping respectively with an example. Equal grouping … Continue reading

Posted in Computing in memory | Tagged , , , , | Leave a comment

An esProc Code Example of Computing Link-Relative Ratio and Year-on-year Comparison

A link-relative ratio is a percentage got by comparing the data of current period and that of the previous period. Usually the interval between the two periods is a month (sometimes an hour, a day, a week and a quarter). … Continue reading

Posted in Computing in memory | Tagged , , , | Leave a comment