Online database modeling

• US 8,326,902 B2
• Filed: 08/27/2010
• Issued: 12/04/2012
• Est. Priority Date: 10/07/2009
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: McArdle, Leon James, Warner, Mark Paul Hamilton, Cobb, John Laurence
• Primary Examiner(s): Corrielus, Jean M
• Application Number:
  US12/869,972
• Publication Number:
  US 20110082889A1
• Time in Patent Office: 830 Days
• Field of Search: 707/792, 707/802, 707/679
• US Class Current: 707/972
• CPC Class Codes: G06F 16/288 Entity relationship models

Abstract

Aspects of the present invention relate to methods and system of implementing online database modeling. The method includes providing an database modeling diagram framework. The framework is in communication with an online database, and the online database provides access to live data. The method further includes providing online access to the online database for the database modeling diagram framework via an intermediary API, representing a database structure of the online database in a database model within an interface of the database modeling diagram framework, and populating the database model with live data from the online database. Further, the method includes displaying the database model with the live data from the online database within the database modeling diagram framework interface.

Claims

1. A method of implementing online database modeling, the method comprising:

providing a database modeling diagram framework, wherein the framework is in communication with an online database, and wherein the online database provides access to live data;

providing, via an intermediary API, access to the online database for the database modeling diagram framework;

representing a database structure of the online database in a database model within an interface of the database modeling diagram framework;

populating the database model with live data from the online database;

displaying the database model with the live data from the online database within the database modeling diagram framework interface

receiving a request to change the database model for the online database;

determining whether the change is impermissible; and

displaying an indication within the user interface indicating that the change was not propagated within the online database diagram, otherwise propagating the received changes and providing an updated view of the online database model reflecting the change.

2. The method of implementing online database modeling as in claim 1, wherein the change includes one of:

a table deletion, a column deletion, or a variable type change.

3. The method of implementing online database modeling as in claim 1, wherein the online database comprises one or more of:

a JDBC database, an SQL server database, a Sybase database, or an Oracle DB2 database.

4. A non-transitory computer-readable medium having sets of instructions stored thereon which, when executed by a computer, cause the computer to:

provide a database modeling diagram framework, wherein the framework is in communication with an online database, and wherein the online database provides access to live data;

provide online access to the online database for the database modeling diagram framework via an intermediary API;

represent a database structure of the online database in a database model within an interface of the database modeling diagram framework;

populate the database model with live data from the online database; and

display the database model with the live data from the online database within the database modeling diagram framework interface;

receive a request to change the database model for the online database, wherein the request is to create a new table within the online database model;

determine whether the change is impermissible; and

display an indication within the user interface indicating that the change was not propagated within the online database diagram, otherwise propagate the received changes and provide an updated view of the online database model reflecting the change.

5. The non-transitory computer-readable medium as in claim 4, wherein the change includes one of:

a table deletion, a column deletion, or a variable type change.

6. A system for implementing online database modeling, the system comprising:

a computer system configured to provide a database modeling diagram framework, wherein the framework is in communication with an online database, and wherein the online database provides access to live data; and

an online database in communication with the framework via an intermediary API;

wherein the database modeling diagram framework is configured to represent a database structure of the online database in a database model within an interface of the database modeling diagram framework, populate the database model with live data from the online database, display the database model with the live data from the online database within the database modeling diagram framework interface;

receive a request to change the database model for the online database;

determine whether the change is impermissible; and

display an indication within the user interface indicating that the change was not propagated within the online database diagram, otherwise propagate the received changes and provide an updated view of the online database model reflecting the change.

7. The system for implementing online database modeling as in claim 6, wherein the online database comprises one or more of:

a JDBC database, an SQL server database, a Sybase database, or an Oracle DB2 database.