New Posts, Page24

Raqsoft Blog

The disadvantages of SQL Computation(III)

To say the least, even if there is top, it only makes it easy to get the preceding part lightly. If we change the problem into getting the 6th place to the 10th place, or seeking the salesman whose sales amount is 10% more than that of the next one, the difficulty is still there. The reason causing this phenomenon lies...

2014-06-11 914 0 0

Hadoop is not a Low Cost Solution

Hadoop is a popular Parallel Computing System for Big Data, with the main feature of being cheap and able to scale out. However, “cheap” is limited to its hardware and software licensing, not the total cost. In terms of learning cost, development cost and management cost, Hadoop does not have advantage. In some cases, ...

2014-06-03 702 0 0

The Disadvantages of SQL Computation (II)

Moreover, SQL does not allow the value of a certain field to be a set (namely temporary table), so in this way, it is impossible to implement some computations even if we tolerate the over elaborate. If we change the problem into computing the salespersons whose sales amounts of all products rank among the top 10 place...

2014-05-30 902 0 0

The Disadvantages of SQL Computation (I)

SQL is invented primarily to provide a method to access structured data in order to transparentise the physical storage scheme, so a lot of various types of English vocabularies and syntaxes are used in SQL to reduce the difficulty in understanding and writing it. And the relational algebra as the basic theory of SQL i...

2014-05-29 884 0 0

Perfect Grouping and Summarizing: Equal, Align, and Enum

esProc provides three complete and powerful grouping methods, namely, Equal, Align, and Enum. With these functions, the true meaning of grouping and summarizing is restored and kept. Summarizing by group is the commonest function in the field of statistics analysis. It is usually used to analyze the analytic target as...

2014-05-28 664 0 0

How to Facilitate Relational Reference: Generic, Sequence, and Table Sequence

Based on the generic data type, esProc provides the sequence and the Table sequence for implementing the complete set-lizing and the much more convenient relational queries. The relation between the department and the employee is one-to-many and that between the employee and the SSN (Social Security Number) is one-to-...

2014-05-27 662 0 0

Intuitive Code Style: Cell, Reuse, and Indentation

esProc provides the functionalities of cell, reuse, and indentation for an intuitive analysis. The intuitive analysis enables the developers to code in a way more natural to human thought. esProc redefine the programming by composing the scripts in the two-dimensional cells from a business perspective at the very start...

2014-05-26 694 0 0

esProc’s Use in ETL

The purpose for ETL is to get higher quality data, with better performance, and in a more convenient way. Actual ETL tasks includes basic data migration, data correction, as well as many industry specific business logics, such as: 1.Transform the raw sales data from the store into data warehouse, with one table to stor...

2014-05-23 669 0 0

Solve Complex Computations in the Report

Reporting tool is good at chart & form design, style of landscaping, query interface, entry & report, and export & print. It is one of the tools that are applied most extensively. However, there are quite often complex computations in the report, which raises a very high requirement for technical capabil...

2014-05-22 797 0 0

ETL or ELT?

ETL process usually includes lot of business logics, which is beyond the reach of visual ETL tools. Most of times they need to be implemented through hard coding. For example, from the production database of a store, we need to ETL the consumer’s purchasing record into the membership score table in the query database....

2014-05-20 868 0 0

Grouping Function Comparison R Language vs. esProc

Grouping is to allocate the samples into several groups according to a specific flag. There is a difference between groups and the relative commonness shared by group members. The grouping plays an important role in statistical analysis. For example, the type grouping is used to differentiate the types of economy, soci...

2014-05-19 674 0 0

Program with Agile Syntax of esProc on Hadoop

Hadoop is an outstanding distributed computational system whose default developing mode is MapReduce coding. However, MapReduce is not specially designed for data computing. Plus, its syntax mechanism is cumbersome, the coding efficiency for computation is relatively low, and it is even more difficult to compose the u...

2014-05-15 686 0 0