Script-Based Data Feed Management System
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional methods for managing data feeds require programmers to write separate programs in high-level languages for each data feed, leading to inefficiencies, increased maintenance costs, and complexity due to the proliferation of various programming languages.
Innovation Solution
A computer-implemented method using script files to specify queries, format, and disseminate database information, allowing users to select and format data feeds through a front-end system, with features like 'Control Feeds' for flow control and 'Schedule Feeds' for timed execution, leveraging pre-defined scripts to simplify data management.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If a programmer writes a separate program in high-level language for each data feed, then the data feed can be customized and delivered, but the time required for implementation and maintenance increases significantly
Solution Approach 1:
The patent uses simple text-based script files instead of complex high-level language programs. These script files are easy to create, modify, and discard, allowing users to quickly configure data feeds without requiring professional programming expertise or maintaining complex codebases.
Solution Approach 2:
The system introduces a script file as an intermediary between the user's data feed requirements and the database system. The script file translates user-friendly specifications into executable queries and formatting instructions, eliminating the need for programmers to write custom code for each data feed.
2Adaptability or versatility
If separate programs are written for each data feed, then specific queries and formats can be achieved, but the complexity of managing multiple programs in various languages increases
Solution Approach 1:
The patent standardizes all data feed configurations using a single text-based script file format with consistent syntax and structure. This homogeneous approach replaces the need to manage multiple programs in different high-level languages, making the system easier to learn, maintain, and extend.
Solution Approach 2:
The script file format serves multiple purposes: defining database queries, specifying data formatting, determining delivery methods, and configuring scheduling. This universal format consolidates what would otherwise require multiple separate programs into a single manageable file type.
3Productivity
If high-level language programs are used for data feeds, then functionality can be implemented, but the expertise and cost for programming and maintenance increase
Solution Approach 1:
The system replaces expensive, expertise-intensive high-level language programming with inexpensive, user-friendly text-based script files. These simple files can be created and modified by users without programming knowledge, dramatically reducing the skill barrier and operational costs.
Solution Approach 2:
The patent enables users to independently configure and manage their own data feeds by simply creating and editing text files. This self-service capability eliminates the need for professional programmers to write and maintain code for each data feed requirement.
Data Source
AI summary
Embodiments of the invention can include a system and method for managing a plurality of data feeds to be loaded into a database. The method includes obtaining a script which specifies a query. The method includes executing the query against a source to extract a result set and consulting the script to determine a format for the data feed. The method also includes converting the result set in accordance with the format to create the data feed and transporting the data feed to be loaded into the database.