Method and apparatus for database table definition

• US 20020147725A1
• Filed: 04/05/2002
• Published: 10/10/2002
• Est. Priority Date: 04/05/2001
• Status: Abandoned Application

• Current Assignee: Sun Microsystems Incorporated (Oracle Corporation)
• Original Assignee: Sun Microsystems Incorporated (Oracle Corporation)
• Inventors: Schoenheit, Frank, Janssen, Ocke
• Application Number:
  US10/118,201
• Publication Number:
  US 20020147725A1
• Time in Patent Office: Days
• US Class Current: 707/100
• CPC Class Codes: G06F 16/221 Column-oriented storage; Management thereof

Abstract

A computer-based method for defining properties of columns of database tables includes receiving a user input selecting at least one source column of a first database table as a source from which metadata defining the properties of said at least one source column is to be copied, receiving a user input selecting a location of a definition table as a target into which said metadata is to be copied wherein said definition table defines column properties of a second database table, and copying said metadata from said source to said target to define the properties of at least one column of said second database table such that said at least one column of said second database table corresponds to the definition of the properties of said at least one source column of said first database table selected as said source.

Claims

1. A computer-based method for defining properties of columns of database tables, said method comprising:

receiving a user input selecting at least one source column of a first database table as a source from which metadata defining the properties of said at least one source column is to be copied;

receiving a user input selecting a location of a definition table as a target into which said metadata is to be copied wherein said definition table defines column properties of a second database table; and

copying said metadata from said source to said target to define the properties of at least one column of said second database table such that said at least one column of said second database table corresponds to the definition of the properties of said at least one source column of said first database table selected as said source.

2. The method of claim 1, wherein

said selecting at least one source column is performed using a cursor and said copying is performed by using the copy and paste function of a clipboard.

3. The method of claim 1, wherein

said selecting and copying are performed by using a drag and drop function.

4. The method of claim 1, wherein said receiving a user input selecting at least one source column of a first database table as a source further comprises:

selecting a plurality of source columns of said first database table wherein said plurality of source columns includes said at least one source column.

5. The method of claim 1 wherein said metadata comprises:

a column name;

a column type; and

a description of the column data.

6. The method of claim 5 wherein said metadata further comprises:

a column length; and

a variable indicating whether data is required.

7. A computer-based method comprising:

receiving cursor information to determine one or more source columns of a first database table as a source location;

receiving a copy request for copying metadata information for said one or more source columns;

reading the metadata information for said one or more source columns;

receiving cursor information to determine a target location; and

copying the metadata information from said source location to said target location.

8. A computer-based method comprising:

defining a database table by a collection of sets of variables, each of said sets corresponding to one column of said database table;

defining properties of at least one column of said database table by a corresponding set of variables in said collection of sets of variables;

selecting a target location in said database table for a new column;

creating a new variable set at an intermediate location between already existing sets of variables to define the properties of said new column, if a set of variables already exists for said target location;

creating, alternatively, a new variable set at said target location, if a set of variables does not already exist for said target location; and

copying metadata variable values into said new variable set.

9. An apparatus for defining the properties of columns of database tables, said apparatus comprising:

means for receiving a user input selecting at least one source column of a first database table as a source from which metadata defining the properties of said at least one source column is to be copied;

means for receiving a user input selecting a location of a definition table as a target into which said metadata is to be copied wherein said definition table defines column properties of a second database table; and

means for copying said metadata from said source to said target to define the properties of at least one column of said second database table such that said at least one column of said second database table corresponds to the definition of the properties of said at least one source column of said first database table selected as said source.

10. The apparatus of claim 9, wherein

said selecting at least one source column is performed using a cursor and said copying is performed by using the copy and paste function of a clipboard.

11. The apparatus of claim 9, wherein

said selecting and copying are performed by using a drag and drop function.

12. The apparatus of claim 9, wherein said receiving a user input selecting at least one source column of a first database table as a source further comprises:

selecting a plurality of source columns of said first database table wherein said plurality of source columns includes said at least one source column.

13. The apparatus of claim 9, wherein said metadata comprises:

a column name;

a column type; and

a description of the column data.

14. The apparatus of claim 13, wherein said metadata further comprises:

a column length; and

a variable indicating whether data is required.

17. The computer program product of claim 16, wherein

said selecting at least one source column is performed using a cursor and said copying is performed by using the copy and paste function of a clipboard.

18. The computer program product of claim 16, wherein

said selecting and copying are performed by using a drag and drop function.

19. The computer program product of claim 16, wherein said receiving a user input selecting at least one source column of a first database table as a source further comprises:

selecting a plurality of source columns of said first database table wherein said plurality of source columns includes said at least one source column.

20. The computer program product of claim 16, wherein said metadata comprises:

a column name;

a column type; and

a description of the column data.

21. The computer program product of claim 20, wherein said metadata further comprises:

a column length; and

a variable indicating whether data is required.

15. An apparatus for defining the properties of columns of database tables, said apparatus comprising:

means for receiving cursor information to determine one or more source columns;

means for receiving a copy request for copying metadata information for said one or more source columns;

means for reading said metadata information for said one or more source columns;

means for receiving cursor information to determine a target location; and

means for writing the metadata information to said target location.

16. A computer program product having stored thereon computer readable instructions wherein execution of the computer readable instructions generates a method for defining the properties of columns of database tables, said method comprising:

receiving a user input selecting at least one source column of a first database table as a source from which metadata defining the properties of said at least one source column is to be copied;

receiving a user input selecting a location of a definition table as a target into which said metadata is to be copied wherein said definition table defines column properties of a second database table; and

copying said metadata from said source to said target to define the properties of at least one column of said second database table such that said at least one column of said second database table corresponds to the definition of the properties of said at least one source column of said first database table selected as said source.