Virtual Data Federation for Editable Cross-Server Datasets

The patent segments the federated data into a separate virtual table that is distinct from the original source datasets. This allows the federated view to be manipulated independently while the original data remains intact and unchanged. The segmentation is achieved through virtual table generation that references source tables without physically copying or modifying them.

The patent creates a virtual copy of the federated data structure that does not physically replicate the actual data. Instead, it generates a virtual table that references and queries the original source datasets dynamically. This virtual copy can be modified without affecting the source data, as it is merely a view rather than a physical duplicate.

The patent segments access control by creating a separate virtual table layer between the source datasets and the user interface. This virtual table can have its own access control mechanisms that are independent from the source dataset permissions, allowing fine-grained control over who can access federated data without exposing the underlying source data structure.

The virtual table acts as an intermediary layer that mediates between the source datasets and the users. It provides a controlled interface that can enforce privacy policies and access controls independently of the source data, preventing direct access to original datasets while still enabling federated data queries.

The patent implements self-service through automated virtual table generation that requires minimal manual intervention. The system automatically discovers source datasets, generates appropriate virtual tables, and establishes relationships without requiring specialist data federation experts. Users can perform federation operations through simple interface interactions rather than complex manual processes.

The patent changes the fundamental parameters of data federation from physical data movement and manual integration to virtual table generation and automated query composition. This parameter change transforms the process from time-intensive manual work to rapid automated operations, significantly improving productivity while reducing the skill level required.

The patent uses virtual copying to create federated views without physically copying data. The virtual tables are generated instantly by establishing references to source datasets, eliminating the time-consuming data movement and transformation processes that occur in traditional federation. This approach achieves unified data views in seconds rather than weeks.

The patent performs preliminary actions by pre-defining the virtual table structure and relationships before actual data queries are executed. The virtual tables are set up in advance with their metadata and relationships, allowing rapid query execution without needing to perform complex data integration operations at query time.