System for forming queries to a commodities trading database using analog indicators
First Claim
1. A system for generating queries suitable for retrieving data from a database including a sequential history of commodity attributes, comprising:
- a display,a pointer device having a corresponding rendition on said display for choosing selections presented on said display,an event definition window sequence presented on said monitor having selections responsive to said pointer, for defining an event as one or more analog indicators from market attributes comprising;
market indicators, commodities, equities, transaction price, transaction volume, date, time, and the like for defining time correlated analog characteristics indicative of correlated analog characteristics indicative of a point in the sequential history when a temporal relation imposed upon selected market attributes is satisfied, anda report definition window sequence presented on said display having selections responsive to said pointer, for defining a set of analog markets, for each point in history corresponding to the satisfaction of said one or more analog indicators as one or more time-series defining the current market being temporally related to said event to be retrieved from said database allowing comparison of report presentations for identifying recurring trends as defined by patterns relating to historical antecedents to find periods with similar characteristics.
1 Assignment
0 Petitions
Accused Products
Abstract
A computerized data retrieval system, especially for commodity price information databases, having a windowing system which aids a user in creating and revising formal search language queries, a database searching engine responsive to such queries, means to generate and format results in both textual and graphic reports, and a capacity for echoing a formal search language query to a display in a near-natural language format for easy comprehension by the user as the query is constructed using the windowing system. The system has facilities for including domain knowledge in a query, such as market knowledge of calendar events, national holidays, triple-witching hours, and option contract expiration dates. The system has additional facilities that permit a user to include more fundamental domain knowledge, such as dates of political elections, date of issuance and value of company earning reports, the consumer price index, and so on. The near-natural language format of the query may be created and revised either through the windowing system or with a text editor.
-
Citations
18 Claims
-
1. A system for generating queries suitable for retrieving data from a database including a sequential history of commodity attributes, comprising:
-
a display, a pointer device having a corresponding rendition on said display for choosing selections presented on said display, an event definition window sequence presented on said monitor having selections responsive to said pointer, for defining an event as one or more analog indicators from market attributes comprising;
market indicators, commodities, equities, transaction price, transaction volume, date, time, and the like for defining time correlated analog characteristics indicative of correlated analog characteristics indicative of a point in the sequential history when a temporal relation imposed upon selected market attributes is satisfied, anda report definition window sequence presented on said display having selections responsive to said pointer, for defining a set of analog markets, for each point in history corresponding to the satisfaction of said one or more analog indicators as one or more time-series defining the current market being temporally related to said event to be retrieved from said database allowing comparison of report presentations for identifying recurring trends as defined by patterns relating to historical antecedents to find periods with similar characteristics. - View Dependent Claims (2, 3, 4, 5, 6, 13)
-
-
7. A method for extracting historical market information identifying recurring trends relating to securities traded in a market, the method comprising the steps of:
-
organizing in a computer data base historical market information according to attributes, the attributes comprising;
market indicators, commodities, equities, transaction price, transaction volume, date, time, and the like;providing a first windowing system embodying click on menus of the attributes for presentation in a report; providing a second windowing system embodying click on menus of a plurality of interrelated templates providing autosequencing for selecting a condition defining temporal fluctuations of the attributes; selecting one or more attributes from said first windowing system providing a SHOW attribute query construction; selecting one or more conditions from said second windowing system providing a WHEN condition query construction; retrieving, according to said selected SHOW attribute-WHEN condition query constructions, the selected attributes from the computer data base for each point in history corresponding to the satisfaction of the selected conditions; and generating, for each point in history corresponding to the satisfaction of the selected conditions, a report presentation for each of the retrieved attributes, whereby a plurality of report presentations is generated, one each for each point in history satisfying the selected conditions, allowing comparison among said plurality of report presentations for identifying recurring trends relating to the commodities traded in the market. - View Dependent Claims (8, 9, 10, 11, 12)
-
-
14. A method for analyzing fluctuations of time varying attributes generated by securities traded in a market, the method comprising the steps of:
-
gathering in digital form historical market information according to time varying attributes, said attributes comprising;
market indicators, commodity or equity transaction price, volume, date, time, and the like;specifying a criteria for temporally defining activities to be monitored relative to said attributes as analog indicators from said attributes for defining time correlated analog characteristics indicative of selected analog indicators by temporal fluctuations of the attributes; specifying at least one of said attributes as analog markets for graphic presentation; and collecting a plurality of graphic presentations representing specified attributes from said gathered digital historical market information corresponding temporally to said specified criteria representing said analog markets for each point in history corresponding to the satisfaction of said one or more analog indicators as one or more time-series defining the current market being temporally related to allow comparison of report presentations for identifying recurring trends as defined by patterns relating to historical antecedents to find periods with similar characteristics. - View Dependent Claims (15, 16)
-
-
17. A method for extracting historical market information identifying recurring trends relating to securities traded in a market, the method comprising the steps of:
-
organizing in a computer data base historical market information according to attributes, the attributes comprising;
market indicators, commodities, equities, transaction price, transaction volume, date, time, and the like;providing a first windowing system embodying click on menus for selecting analog markets from said attributes of market indicators, commodities, equities, transaction price, transaction volume, date, time, and the like for presentation in a report; providing a second windowing system embodying click on menus for selecting analog indicators from said attributes of market indicators, commodities, equities, transaction price, transaction volume, date, time, and the like for defining time correlated analog characteristics indicative of selected analog indicators by temporal fluctuations of the attributes; selecting one or more analog markets from said first windowing system; selecting one or more analog indicators from said second windowing system; retrieving, according to said selected analog markets and said selected analog indicators, the selected attributes from the computer data base for each point in history corresponding to the satisfaction of the defined time correlated analog characteristics indicative of the selected analog indicators; and generating, for each point in history corresponding to the satisfaction of the selected analog indicators, a report presentation for each of the retrieved analog markets, whereby a plurality of report presentations is generated, one each for each point in history satisfying the selected conditions, allowing comparison among said plurality of report presentations for identifying recurring trends as defined by patterns relating to historical antecedents to find periods with similar characteristics. - View Dependent Claims (18)
-
Specification