19 مستودعات
Processes that split a single record into multiple child rows based on defined logic.
Distinguishing note: None of the candidates address the data transformation process of splitting rows; they focus on UI or storage.
Explore 19 awesome GitHub repositories matching data & databases · Row Expansion. Refine with filters or upvote what's useful.
LanceDB is a vector database and columnar data store designed to function as a versioned dataset manager and vector search engine. It serves as a high-performance backend for indexing and retrieving high-dimensional embeddings, providing the foundation for machine learning data pipelines. The system distinguishes itself through a combination of cloud-native object storage and immutable version tracking, allowing for data time-travel and reproducible AI experiments. It integrates hybrid search capabilities, merging dense vector similarity with BM25 full-text search and SQL-like scalar filters
Splits single source rows into multiple rows to decompose complex documents or media into smaller chunks.
This project is a metadata query engine and indexer for markdown files, designed to transform YAML frontmatter and inline fields into dynamic tables and lists. It provides a background process that extracts tags and custom fields into a searchable database, enabling the automated indexing of notes. The system is distinguished by its dual approach to data retrieval: a dedicated query language for SQL-like filtering and grouping, and a JavaScript data API. This API allows for programmatic metadata extraction and the creation of custom views and extensions using TypeScript typings. Its broader
Transforms single rows containing arrays into multiple rows to simplify filtering and display.
JimuReport is an open-source reporting and dashboard engine designed to be embedded directly into Spring Boot applications. Its core identity centers on generating data reports and full-screen dashboards from natural language descriptions, eliminating the need for manual design. The platform also provides a conversational query interface that translates plain-language questions into database queries, returning results as tables and charts without requiring SQL knowledge. What distinguishes JimuReport is its integration of AI skills that can be installed with a single command, enabling report
Arranges rows into hierarchical groups based on a chosen field and computes subtotals for each group.
react-data-grid is a high-performance tabular interface for rendering and manipulating large datasets within a React application. It functions as a virtualized data table and editable spreadsheet component that supports hierarchical data grids with expandable and collapsible row groupings. The component maintains performance with massive datasets by rendering only the rows and columns currently visible in the viewport. It provides spreadsheet-like data manipulation, including cell editing and the ability to copy, paste, or drag values between cells. The grid supports advanced layout capabili
Organizes data into a tree structure with expandable and collapsible rows based on specified column keys.
react-data-grid is a high-performance table component for React designed to render large datasets using virtualization. It functions as a virtualizing data table that optimizes memory and performance by rendering only the rows and columns currently visible on the screen. The project provides a customizable spreadsheet interface featuring cell editing, column resizing, and pinned rows. It also acts as a hierarchical data grid, supporting row grouping and tree structures to organize complex nested information. The grid covers wide-ranging data management and display capabilities, including mul
Supports organizing data into a recursive tree structure with expandable and collapsible grouped categories.
Tabulator is an interactive data table library and virtual DOM data grid used to create high-performance tables from JSON or arrays. It functions as a hierarchical data viewer and a spreadsheet interface component, capable of rendering thousands of records efficiently through viewport-based virtualization and progressive loading. The library distinguishes itself by providing a full spreadsheet interface mode with multi-sheet management, cell range selection, and bulk copy-paste capabilities. It supports complex data architectures, including nested data field mapping, expandable tree structure
Organizes data into sections based on field values with support for multi-level nested groups.
Draws random subsets of training rows to speed up experimentation and iteration during model development.
SlickGrid is a high-performance JavaScript data grid and virtualized data table designed to render large datasets in the browser. It functions as a web spreadsheet component and tabular data manager, utilizing virtual scrolling to maintain responsiveness when displaying hundreds of thousands of entries. The library employs a canvas-based UI system to draw grid lines and elements, reducing the total number of DOM nodes. It separates raw data from visual presentation through column-based mapping and uses a formatter pipeline to transform data values into HTML strings. Capabilities include row
Converts flat data arrays into a hierarchical tree structure to allow for collapsible group rows and aggregations.
Materialize is a streaming SQL database that continuously ingests live data from sources such as Kafka, Redpanda, PostgreSQL, and MySQL, and incrementally maintains materialized views. It provides a PostgreSQL-compatible query engine that accepts standard SQL over the PostgreSQL wire protocol, enabling any existing SQL client or BI tool to query real-time data. The system also includes a Model Context Protocol (MCP) server that exposes live materialized view data to AI agents, providing fresh context without polling. Materialize distinguishes itself through its ability to offer configurable c
Splits a single HTTP request containing a JSON array or newline-delimited JSON into multiple rows automatically.
Masuit.Tools is a comprehensive static utility library for .NET and ASP.NET Core development. It provides a broad collection of reusable helper methods and infrastructure components that cover common programming tasks without requiring dependency injection or instance management. The library is organized as flat utility classes, making its functionality directly accessible from anywhere in a project. The toolkit distinguishes itself through a wide range of integrated capabilities that go beyond typical utility libraries. It includes a multithreaded range-request file downloader with pause and
Converts flat collections into hierarchical trees and retrieves ancestors, descendants, depth, and paths.
Apache Hive is a SQL-on-Hadoop data warehouse that enables querying and managing petabytes of data stored in distributed storage such as HDFS and cloud storage services. It provides a familiar SQL interface for batch analytics and reporting, supported by a core set of components including the HiveServer2 Thrift service for remote query execution, the Hive Metastore Service for central metadata management, the Hive ACID Transaction Engine for concurrent read-write operations, and the Hive LLAP Interactive Engine for low-latency analytical processing. The WebHCat REST API offers an HTTP interfac
Combines multiple input rows into a single output row, computing statistics like count, sum, average, and percentile.
This project is a React drag-and-drop tree component and tree data management utility used for rendering nested hierarchical data. It provides a sortable hierarchical list that allows users to manage parent-child relationships and visualize complex tree structures. The component enables interactive tree restructuring, where users can reorganize the hierarchy by dragging and dropping nodes to change their parent or sequence. It supports moving or copying nodes between different tree instances and provides controls to enforce movement restrictions based on custom logic or depth limits. The too
Transforms flat data collections into hierarchical tree structures and vice versa for storage and rendering.
Memgraph is an in-memory, distributed graph database designed for high-performance labeled property graph management. It utilizes a Cypher query engine for declarative data retrieval and manipulation, providing a scalable knowledge graph backend that integrates vector search and graph traversals. The system distinguishes itself as a real-time graph analytics platform, employing native C++ and CUDA implementations to execute complex network analysis and dynamic community detection on streaming data. It provides specialized support for AI integration, including GraphRAG capabilities, the constr
The product transforms a single list of values into individual rows for independent processing.
This library provides a framework for managing hierarchical data structures within relational databases using the nested set model. It integrates directly with the Laravel Eloquent object-relational mapping layer, allowing developers to store, query, and manipulate complex parent-child relationships within standard database tables. The package distinguishes itself by implementing boundary-based indexing to represent tree depth and node containment. This approach enables the retrieval of entire branches or specific ancestors, descendants, and siblings through optimized database queries rather
Converts flat database collections into nested arrays or ordered lists for rendering.
Ancestry is a materialized path tree library for managing hierarchical data models in relational databases. It provides a framework for organizing records into tree structures, allowing for the efficient retrieval of ancestors and descendants through path-based storage. The project distinguishes itself through specialized tools for maintaining tree integrity and transforming data. It includes a tree integrity manager to handle orphaned nodes and a JSON tree serializer that converts hierarchical database records into nested hashes or arrays for API responses. The library covers a broad range
Provides a system for handling orphaned nodes and maintaining structural consistency during parent record deletions.
Velociraptor is a digital forensics and incident response platform, endpoint detection and response system, and visibility tool. It provides a query engine and remote forensic collector used to hunt for indicators of compromise and perform triage across a fleet of hosts. The system is distinguished by its specialized query language for interrogating host state and parsing binary files. It features a notebook environment that combines markdown documentation with executable query cells to standardize investigative workflows and enable collaborative reporting. The platform covers a wide range o
Groups rows into bins using group-by clauses to calculate summary statistics like counts, sums, and rates.
qsv is a high-performance command line toolkit for querying, transforming, and analyzing comma-separated value files. It functions as a data wrangling interface and a tabular data profiler, featuring a query engine capable of executing SQL statements and joins directly on flat files without requiring a database. The project is distinguished by its ability to process massive datasets that exceed available system memory. This is achieved through disk-based external memory processing, including multithreaded merge sorting, on-disk hash tables for deduplication, and lightweight file indexing for
Implements row explosion to split a single record into multiple child rows based on a column separator.
Drift is a type-safe SQL persistence library and relational mapper that provides a structured way to map database tables to classes and execute SQL queries with build-time validation. It functions as a type-safe query builder and a wrapper for SQLite and PostgreSQL, eliminating manual result set parsing by binding query outputs to native objects. The project distinguishes itself through a build-time code generation system that produces type-safe APIs and validates raw SQL statements against database versions before execution. It features reactive query streaming, which transforms SQL queries
Computes summary statistics such as counts, sums, and averages across multiple rows using group-by clauses.
هذه المكتبة عبارة عن إطار عمل لمعالجة البيانات لـ JVM يوفر بيئة آمنة من حيث النوع (type-safe) لمعالجة البيانات الجدولية المهيكلة. تعمل كمجموعة أدوات شاملة لإجراء تحويلات البيانات المعقدة، والتجميعات، والتحليل الإحصائي، مع الاستفادة من التحقق من المخطط (schema) في وقت التجميع لضمان السلامة الهيكلية عبر خطوط أنابيب البيانات. يتميز المشروع بتكامله العميق مع بيئات دفاتر الملاحظات التفاعلية واستخدامه لتوليد الكود في وقت التجميع. من خلال اشتقاق المخططات وفرضها تلقائياً من المدخلات الخام، فإنه يولد أدوات وصول آمنة من حيث النوع تتيح الإكمال التلقائي في IDE والتحقق الثابت من أسماء الأعمدة. تسمح هذه البنية للمطورين بتنفيذ معالجة خطوط الأنابيب الوظيفية مع الحفاظ على أمان صارم للأنواع، مما يمنع بشكل فعال أخطاء وقت التشغيل أثناء معالجة البيانات. تدعم المكتبة مجموعة واسعة من سير عمل البيانات، بما في ذلك استيراد وتعيين مخططات قواعد البيانات العلائقية، وإجراء التحليل الجغرافي المكاني، وتنفيذ محاور البيانات المعقدة. تتضمن أدوات واسعة النطاق لإنشاء البيانات، والتصفية، والفرز، وحساب الإحصاءات الوصفية. علاوة على ذلك، يوفر إطار العمل إمكانيات قوية للتصور وإعداد التقارير، مما يسمح للمستخدمين بعرض جداول HTML تفاعلية، وتأليف المستندات، وإنشاء المخططات مباشرة من مجموعات البيانات المهيكلة. تم تصميم المكتبة للاستخدام السلس داخل بيئات تطوير Kotlin وJava، مع دعم متخصص لإدارة التبعيات المؤتمتة وتكامل النواة في دفاتر الملاحظات التفاعلية.
Computes mathematical aggregates like sums and standard deviations across row values.