2021 Annual Summary | Review of Grape City Software Development Technology (Part 2)

2021 Annual Summary | Review of Grape City Software Development Technology (Part 2)

In the last section, we introduced some new explorations and attempts in the control field of Grape City in the past year.

(Details: https://www.cnblogs.com/powertoolsteam/p/15882644.html )

Including the collection table to solve the problem of combining the traditional high-performance structured table (Grid) with the formula calculation engine (CalcEngine) in the front-end spreadsheet, and the performance improvement and compatibility expansion of complex reports in different platforms, in addition to the control technology related Content. Regarding the low-code and BI data analysis that has been in the limelight in recent years, we also have some new content to share with you.

Embedded BI, a powerful tool for data visualization

Data visualization has also been a hot topic in recent years.

In mid-2021, we have also made new breakthroughs in the field of data BI.

Wax (Wyn Analytic Expression) analysis language system

This year, for BI data analysis, we newly developed the Wax engine.

The essence of the Wax engine is a complex SQL generator. It parses Wax statements and expressions, then analyzes the topological structure of the data model, combines the two to generate an abstract syntax tree, and performs repeated optimization iterations to finally generate SQL suitable for the target database. statement. During this process, we have performed a lot of optimization on key components such as graph operations to ensure performance and the quality of the final SQL product.

Different from the traditional BI implementation, Wax does not need Cube, but chooses to connect to an advanced OLAP database as an alternative, and generates the most appropriate SQL according to its characteristics to meet the needs of query performance. Based on this, in future versions, the Wax engine will support more types of OLAP databases. On the premise that the hardware is powerful enough, Wax will release the unlimited potential of the OLAP database behind it.

The Wax language can implement almost any query required by users, making it possible to build complex analyses such as RFM and DuPont.

From a usage perspective, Wax allows users to build advanced analysis in a low-code form, which works well with the drag-and-drop feature of previous versions that focused on building general analysis, providing users with more degrees of freedom. At present, from the perspective of similar analysis language support in the industry, Wax is superior in light weight and generality.

Strong reusability of Wax

We also put a lot of thought into high reusability when designing Wax.

• In addition to OLAP databases, the Wax engine can also generate SQL suitable for mainstream OLTP databases. Products using Wax components can directly query and analyze the target database in the form of Wax statements.

Wyn uses this to enable real-time data analysis.

Including push datasets and streaming datasets, Wyn can receive data, clean it and dump it to an in-memory database or a persistent columnar database, and execute SQL generated by the Wax engine on these databases when the dashboard issues a query to get analytics result.

• The Wax engine itself is a tightly packaged, zero-dependency independent module that can be redistributed as a nuget package. This means that other products can also install Wax modules to provide data analysis capabilities.
• The core code of the Wax engine is platform-independent, and has only a small amount of language related, and can be easily rewritten in other languages (such as Java, etc.).

Real-time data access in push streaming mode

The underlying implementation of streaming datasets and push datasets is a callable WebAPI. Data collected by IoT devices such as device sources, sensors, servers, and testing instruments can be pushed to Wyn Enterprise by calling this WebAPI, and displayed on the dashboard in real time, fully satisfying various real-time data monitoring needs.

If a worker wants to do a good job, he must first sharpen his tools. As Gartner analysts said, augmented analysis will shape the future trend of big data, and we also hope to provide you with stronger support in the BI field in the future.

Build blocks and develop immediately

In 2021, with the blessing of the digital background, in addition to data BI, low-code is also a year in the limelight.

Under the accumulation of decades of control technology, Grape City's low-code is also making continuous efforts to allow developers to quickly build applications like building blocks. And this year, we brought movable type to the cloud, and on the basis of privatization deployment, we developed a public cloud service with exclusive resources, which is often referred to as PaaS.

Movable Type Cloud is built on cloud-native K8S container technology and .NET Core cross-platform technology. On the basis of satisfying enterprise-level application development, it maximizes the technical advantages brought by the public cloud. Regarding the related content of K8S, we have published a serial: Docker and k8s series of grievances and grievances, the details are as follows:

Chapter 1: The grievances between Docker and k8s (1) - Cloud Foundry before PaaS

Chapter 2: The grievances between Docker and k8s (2) - Implementing "containers" with the simplest technology

Chapter 3: The grievances between Docker and k8s (3) - Docker in the back wave is menacing

Chapter 4: The grievances and grievances between Docker and k8s (4) - the end of closed source in the cloud native era

Chapter 5: The grievances between Docker and k8s (5) - Kubernetes innovation

Chapter 6: The grievance between Docker and k8s (6) - "Container Orchestration" staged the "Terminator" blockbuster

Chapter 7: The grievances between Docker and k8s (7) - "Service Discovery" Dafa lets your internal and external interactions take off in place

Chapter 8: The grievances between Docker and k8s (8) - Looking back at an overview of Kubernetes

In terms of functions: Movable Type Cloud is fully compatible with applications deployed by On-Promise privatization, and can easily migrate local applications to the cloud;

Operation and maintenance: The movable type grid cloud provides a rich monitoring interface, which can monitor the CPU, disk and network of the server in an all-round way;

In terms of performance: a stable and highly available cluster deployment environment provides support for the healthy and stable operation of applications;

At the same time, the movable type grid cloud can be used in combination with the cloud mall. The cloud mall provides a large number of applications and components, which is convenient for users to quickly build applications and avoid repeated wheel building.

Summarize

The development of technology has no boundaries, and everything grows and flourishes.

Every year, many "back wave" technologies are constantly updated and upgraded, and many "front wave" technologies are coming.

You may not come empty-handed, but you can come home full of things.

Here we draw a successful conclusion to 2021, and 2022 will bring you more interesting and serious content.