A database system that accommodates any type of phenomenon or thing, with a simple table structure and an extremely small-scale program. Category identification information of the content to be registered, item names that represent an attribute and/or a function included in the category, and attributes of data representing the substantial contents of these items (item data attributes) are registered in each data cell of a data property table (21) in units of rows, and category identification information, title names, and substantial contents associated with each item are registered in data cells of a main data table (22) in units of rows. The item names of the table (21) and the substantial contents of the table (22) correspond by means of cell numbers, and when a database management system (10) performs data input, storage, searching, and output, the various methods are generated with row-direction data of the table (21) as a message.
Legal claims defining the scope of protection, as filed with the USPTO.
1. A database system while managing category names, which are abstract contents of registered information and a hierarchy thereof by a data dictionary file, registers category name, individual title name, and substantial contents of each piece of information being registered, wherein said system comprises: a first table and a second table, which are formed by data cells, and in said first table, category identification information of a category given by said data dictionary file is stored in a data cell of a specific column, and names of items which represent an attribute and/or a function associated with the category and item data attributes representing the substantial contents associated with said items are stored in other cells, each belonging to a row in which said category identification information is stored, and in said second table, category identification information and a title name are stored in each cell of two specific columns, the substantial contents associated with each item name being stored in other data cells, each belonging to a row in which category identification information and title names are stored, in the same sequence with regard to item names as the row-direction sequence of data cells into which are stored item names and item data attributes in said first table, and each of a method for input, storage, searching, and output of data associated with registered information being generated based on data stored in said first table, said data base system further comprising: a first storage means into which is stored a first registration screen onto which are disposed an input field for a category name, which is an abstract concept of handled information, an input field for each item name representing an attribute and/or a function associated with said category, and an input field for defining item data attributes for each item associated with said item names; a first display means for reading out and displaying a first registration screen of said first storage means; a first table formed by data cells; a first registration means, which uses data cells of a specific column of said first table as a storage area for category identification information given by said data dictionary file and assigns each data cell of other columns as a storage area for item names and item data attributes, and which, based on input into said each input field of said first registration screen, registers said category identification information, item names, and item data attributes in units of rows; a second display means for displaying a second registration screen, which generates a display method based on row-direction data associated with said category name of said first table, and on which is disposed an input field for a title name associated with said registered information, a display field for display of each item name, and an input field for substantial contents associated with each item name; a second table formed by data cells; a second registration means, which uses each data cell of two specific columns of said second table as storage areas for category identification information and title names and assigns each data cell of other columns as a storage area for substantial contents associated with said item names, and which, based on input into each input field in said second registration screen, stores category identification information, title name, and substantial contents associated with each item name in units of rows, this storage being performed so that row-direction sequence of said each data cell into which said substantial contents associated with each item name is stored is the same with regard to item names as a row-direction sequence of each data cell in said first table, into which are stored item names and item data attributes; a data output means, which, in a case in which an inquiry is made with various conditions, based on data registered in said first table associated from said data dictionary file, generates an access method for said second table and an output method for registered data obtained by that access method, these methods causing output of registered data in response to said inquiry.
2. A database system according to claim 1 , wherein a data type is provided as a defining item for said item data attributes.
3. A database system according to claim 2 , wherein a selection menu is provided for selection of character type, value type, data type, image type, or audio type as the data type defining said item data attributes.
4. A database system according to claim 2 , wherein a selection menu is provided that indicates data obtained by a link to another application and/or a link to another system as a data type defining said item data attributes.
5. A database system according to claim 1 , wherein a data type and data size are provided as defining items for said item data attributes.
6. A database system according to claim 1 , wherein a data type, a data size, a unit, and a range specification are provided as defining items for said item data attributes.
7. A database system according to claim 1 , wherein when said second registration means, based on input into said input fields of said second registration screen, stores substantial contents associated with each item name into each data cell of said second table, if the amount of data thereof is large, said data is stored into a second storage means having a large capacity, and only the corresponding address in said second storage means into which is stored said data is stored into the corresponding data cell of said second table.
8. A database system according to claim 1 , wherein said first storage means stores said first registration screen provided with input fields in a display sequence corresponding to input fields for input of each item name, said first registration means adds each input display sequence input to said item data attributes corresponding to each item name, stores said data attributes in data cells of said first table, and wherein said data output means generates an output method which sets the display sequence for the substantial contents associated with each item name based on said display sequence associated with said input.
9. A database system according to claim 1 , wherein in response to a connection request sent via a network from a client, a circuit connection is made with said client, and in response to a client-side registration request, said first registration screen generated by said first display means is provided to the client-side, and based on transmission of input data to said first registration screen by the client-side, the input data is registered into said first table, and based on said registered data associated with said category identification information of said first table, said second registration screen generated by said second display means is provided to the client-side, and based on transmission of input data to said second registration screen by the client-side, the input data is registered into said second table, and, based on an inquiry from a client-side, various inquiry screens prepared beforehand are provided to the client-side, and in response to inquiry condition, said data output means provide the registered data of said second table to the client-side.
Cooperative Patent Classification codes for this invention. Click any code to explore related patents in that topic.
April 30, 2001
November 9, 2004
Browse 5M+ US patents with plain-English claim translations and AI-generated analysis.