With the powerful computational ability of esProc, user can efficiently achieve the complicated computation objective, and accomplish the online query analysis with an interactive IDE. That is the primitive OLAP. By utilizing the data computation power of esProc, the complex computation related to multiple sources and databases crossing can be achieved, and the pressure can be alleviated on the side of report tool so as to boost the overall performance. esProc can easily and conveniently complete the computation such as summarizing & sorting, data retrieving and even write-back. Compared with stored procedure, it is much simpler to write and invoke esProc no matter independently or in your program.
Features: SQL has the complete computational ability as the commonest language in database computations, but the level it supports is relatively too low. In particular, the non-stepped computation, unordered set, incomplete set-lization, lacking the object reference, which makes it cumbersome and difficult to comprehend when using SQL to complete the data computation. esProc is superior to the SQL. Regarding the same issues, esProc accordingly establishes the stepped thinking, set thinking, serial number thinking, reference thinking, and other thinking modes, based on which, it is much simpler. The innovative code of grid style is intuitive and easy to understand, which will give users a brand new experience of script-programming. The plentiful data computation class library, covering summarization, filtering, sorting, grouping, and connecting. You can easily complete all types of computation. The set-based dynamic language is much freer to develop the computation target. The ever present ordered set and dissociative record objects make every type of aggregate computation much more convenient, the order-related computation can be implemented easily. Heterogeneous data sources is supported by esPorc. user can view the computations in esProc, arrange and output the results to various data sources in the required format, or supply it to the report or external application via calling.
No comments:
Post a Comment