RULES-BASED DATA MINING
First Claim
1. A system for forming a statement for a database comprising:
- a database stored on a computer-readable medium and having a schema;
a database connection module, for translating at least a portion of the schema into one or more objects and variables, where at least one object is associated with at least one variable, and creating a corresponding alias for the object and associated variable; and
a user interface module, for displaying the corresponding alias, and accepting at least one user input associated with the corresponding alias;
wherein the database connection module receives the user input, and forms a database statement from the corresponding alias and the user input.
1 Assignment
0 Petitions
Accused Products
Abstract
The present invention provides systems and methods for retrieving, modifying, and managing data in a database without knowing the underlying database schema. In preferred embodiments, the present invention provides a consistent Graphical User Interface (GUI) to allow an end user to interact with the underlying database without programming or writing Structured Query Language (SQL) or Hibernate Query Language (HQL) statements. The present invention improves upon existing database connectivity tools by adding a level of abstraction on top of the Open Database Connectivity (ODBC) or Java Database Connectivity (JDBC) and object/relational persistence and query service layers known in the art. In additional embodiments, the present invention provides an API to allow a computer program to interact with the underlying database, and allows the computer program to execute queries and integrate the results of these queries into the computer program'"'"'s internal system.
-
Citations
20 Claims
-
1. A system for forming a statement for a database comprising:
-
a database stored on a computer-readable medium and having a schema; a database connection module, for translating at least a portion of the schema into one or more objects and variables, where at least one object is associated with at least one variable, and creating a corresponding alias for the object and associated variable; and a user interface module, for displaying the corresponding alias, and accepting at least one user input associated with the corresponding alias; wherein the database connection module receives the user input, and forms a database statement from the corresponding alias and the user input. - View Dependent Claims (2, 3, 4, 5)
-
-
6. A method for forming a statement for a database, where the database has at least one table and the table has at least one column, comprising the steps of:
-
creating an object for the table; determining a variable for the object, where the variable corresponds to the column in the table; constructing a join path using the object and the variable; creating an alias for the join path; accepting at least one input associated with the alias; and forming a database statement from the input. - View Dependent Claims (7, 8, 9, 10, 11, 12, 13, 14, 15)
-
-
16. A computer-readable medium comprising one or more computer-executable instructions for:
-
creating an object for a table in a database; determining a variable for the object, where the variable corresponds to a column in the table; constructing a join path using the object and the variable; creating an alias for the join path; accepting at least one input associated with the alias; and forming a database statement from the input. - View Dependent Claims (17)
-
-
18. A computer system comprising one or more computer processors, system memory, and one or more physical computer-readable media having stored thereon computer-executable instructions, which, when executed, perform a method comprising:
-
creating an object for a table in a database; determining a variable for the object, where the variable corresponds to a column in the table; constructing a join path using the object and the variable; creating an alias for the join path; accepting at least one input associated with the alias; and forming a database statement from the input. - View Dependent Claims (19)
-
-
20. A system for forming a statement for a database comprising:
-
a database stored on a computer-readable medium and having a schema; a database connection module, for translating at least a portion of the schema into one or more objects and variables, where at least one object is associated with at least one variable, and creating a corresponding alias for the object and associated variable; and an application programming interface, for providing the corresponding alias to a computer program, and accepting a query associated with the corresponding alias from the computer program; wherein the database connection module receives the query, and forms a database statement from the corresponding alias and the query.
-
Specification