Simplifying Blockchain Data Exploration for Developers.

This case study explores the development of a groundbreaking decentralised application (dApp) frontend. This user-friendly interface empowers individuals to delve into the world of blockchain data. It grants seamless access to real-time information from major chains like Ethereum, Polygon, BNB Chain, Sui, and Avalanche. Users can navigate blockchain details with ease, execute custom queries, and effortlessly create personalised dashboards for organised data exploration.

Objectives.

The challenge was to build a secure and efficient data warehouse for Web3. This project aimed to seamlessly integrate real-time blockchain data with off-chain sources, creating a decentralised environment for applications, dashboards, and data analysis. The key hurdle was ensuring accessibility, efficiency, and cost-effectiveness for Web3 development.

Below are the quick objectives that were set for the tech team at Systango:

Efficient Data Warehousing: Create a high-throughput HTAP data warehouse.
Decentralised Power: Build a decentralised ecosystem for Web3 applications.
Blockchain Integration: Seamlessly integrate blockchain and off-chain datasets.
Data Agility: Enable flexible data transformation and ad hoc queries.
Low-Latency Access: Develop low-latency APIs for dApps.
Data Security: Implement zk-proof for query accuracy and data integrity.
Trustless Data Interaction: Facilitate secure smart contract data interaction.
Simplified Data Queries: Enable natural language interaction with blockchain data.
Personalised Dashboards: Offer customisation for branded dashboards.

Get a Quote

Our Solutions.

The solution involved developing an intuitive user interface that empowers users of all technical backgrounds to navigate and explore blockchain data. Integrating the OpenAI-powered Houston chatbot further enhanced accessibility by enabling natural language interaction with the platform. Additionally, the project addressed the challenge of data heterogeneity by normalising blockchain data from various sources, ensuring seamless integration and analysis. The solutions below collectively form the project’s foundation, delivering a comprehensive data environment tailored to the needs of Web3 development and secure, efficient data interaction.

User-Friendly Interface

With our UX team, we created a user-friendly interface/dashboard that allows users to explore blockchain data, run queries, and load their data by simply connecting their wallets.

OpenAI-Powered Chatbot

Integration of the Houston chatbot, powered by OpenAI, enabled users to generate SQL commands from natural language inputs, simplifying the querying process.

Hybrid Data Warehousing

Implemented a hybrid transactional/analytic (HTAP) data warehouse with row-based OLTP in-memory caching for extreme throughput and column-based GPU-accelerated OLAP for elastic scale-out.

Decentralised Data Environment

Created a decentralised data environment that empowers applications, dashboards, machine learning, and data science, simplifying Web3 development and reducing associated costs.

Blockchain Data Integration

Preloaded blockchain data from major chains (Ethereum, Polygon, BNB Chain, Sui, Avalanche), facilitating seamless integration with off-chain datasets from various sources, including databases, data warehouses, object storage, applications, and game servers.

Flexible Data Transformation

Enabled users to flexibly transform their data and execute ad hoc queries within the project environment.

Low-Latency API Access

Developed the capability to publish query results to new API endpoints, ensuring low-latency access for decentralised applications (dApps) to efficiently utilise the data.

Proof of SQL

Introduced “Proof of SQL” as a novel zk-proof mechanism, ensuring the accuracy of queries and the verifiable tamper proofs of both queries and underlying data.

Trustless Data Interaction

Enabled smart contracts to interact with data on their chain, other chains, and off-chain sources in a trustless and cryptographically guaranteed manner, enhancing data security and trust across the ecosystem.

Get a Quote