esProc Download
Recent Comments
Even For OBIEE, its… on 6 Desktop BI Tools Marco on Seven analysis tools: R langua… lkafle on An example to illustrate hadoo… lkafle on Five methods of data consolida…
Category Archives: Unique
Structured Data Computing: the Focus of Routine Data Analysis
Essentially, the main content of various data analyses in our routine business is the structured data computing. For example: Compute the link relative ratio and year-on-year comparison of each business branch’s monthly sales during a specified period of time. Implementation … Continue reading
Constants in esProc
In esProc computing, we may frequently use constants or store the data in the cell directly. In this article, let’s learn the usage of constants in the esProc. 1.Directly using constant in the expression Constants can be directly used in … Continue reading
Alignment Grouping and Enumeration Grouping in esProc
Grouping records is often required during presenting and analyzing data in databases. Though records can group the designated fields by using Group By statement in SQL statements, this type of grouping serving the purpose of summary is too simple to … Continue reading
esProc’s Option Syntax
1. esProc’s function options Many functions in esProc can use function options with which the same function can have different work patterns. The basic format of function options is f@o(…) in which o is f function’s option. For example: We … Continue reading
Binary File in esProc
In esProc, we often use two kinds of data file: The normal txt file and the binary file, of which the binary file adopts compressed encoding of low CUP consumption, meaning that a compressed binary file will take less space … Continue reading
Process Text Files with esProc
It is quite convenient to process data from text files with esProc, which provides many functions for processing text files: import various text files; process big text files; visit text files of hdfs; as well as general operations, such as, … Continue reading
Principle and Use of External Memory Sorting in esProc
It is often required to sort records of tables during data analysis and computing. In esProc, sort function is used to sort data of sequences or table sequences. External memory sorting is required when data being sorted are massive and … Continue reading
Posted in Data Analytics, Program Language, Unique
Tagged esPrc, external memory, sort, use
Leave a comment
Aggregate Operations over Cursor in esProc
The data volume of big data table is usually quite huge, which makes it impossible to retrieve all data in the big data table. In view of this, the data processing over big data table is usually to serve two … Continue reading
Posted in Unique
Leave a comment
esProc’s Prime Keys and Their Index Function
In an esProc table sequence, a field or certain fields can be designated as the prime key(s). In this case, some special functions can be employed to make query based on the prime key(s). This can both simplify the code … Continue reading
esProc’s Multilayer Parameters
esProc provides a large number of functions, many of which use many parameters. In order to clearly judge positions of these function parameters, and make writing and reading easier, esProc is specially equipped with multilayer separators of function parameters. 1. … Continue reading
esProc 