Login| Sign Up| Help| Contact|

Patent Searching and Data


Title:
SQL AUTOMATIC GENERATION SYSTEM
Document Type and Number:
Japanese Patent JP2000222259
Kind Code:
A
Abstract:

To automatic generate a database definition SQL statement by editing information on database specifications, line by line, and generating the SQL statement corresponding to the record size of each piece of information.

The SQL automatic generation system 2 reads in the information of the database specifications 1, line by line (B1). Simultaneously with the read, it is decided which of table information A1, index information A2, and record quantity information A3 the read-in information is (B3). For example, when the read-in information is the table information A1, document file information of the database specifications 1 is edited and a Table definition statement (SQL statement) constituting a database definition SQL statement 3 is outputted. At the same time, the number of bytes needed to store the Table definition statement is calculated as a Table record size according to the 'column attribute' of the information of the database specifications 1 (B4).


Inventors:
YAMADA MASAHIRO
Application Number:
JP2074699A
Publication Date:
August 11, 2000
Filing Date:
January 28, 1999
Export Citation:
Click for automatic bibliography generation   Help
Assignee:
NEC CORP
International Classes:
G06F12/00; (IPC1-7): G06F12/00
Attorney, Agent or Firm:
Nobuo Takahashi (3 outside)