Database system

Abstract

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.

Description

TECHNICAL FIELD [0001] The present invention relates to a database system into which information is stored as data made up of category names, title names, and the substantial contents, and more particularly to a system into which information belonging to all categories is stored in an extremely simple table structure and managed by small-scale software, which can be applied as an online database enabling storage and viewing from a client. BACKGROUND ART [0002] With widespread use being made of information devices such as personal computers and a fleshing out of online services via networks such as the Internet, the last few years have seen a dramatic increase in the number and variety of databases available. [0003] In the past, database models have included network, hierarchal, relational, and object-oriented types, with the relational database (hereinafter referred to as the RDB) being the most widely used at present, and the object-oriented database (hereinafter referred to as the...

AI Technical Summary

Benefits of technology

[0019] In this first invention, data of registered information belonging to all categories is managed using two tables having a simple structure.

[0036] As described above, the second invention performs registration of data into the first table and into the second table, while providing the first registration screen and the second registration screen as guidance screens, enabling management (entry, storage, searching, and output) of data using these two tables, this being made possible by the above-noted virtual nature of the first table. This virtual nature functions effectively as well in the generation of the second registration screen.

[0038] In the above-noted first and the second inventions, by providing a data type as a defined item of data attributes, it is possible to execute the above-noted functions of entry, storage, searching and output, and it is further desirable to provide data size as an additional attribute.

[0042] In addition to the above-noted data type and data size, if it is made possible to specify units and a range, it is possible to properly represent any attribute or function associated with each item of each phenomenon or event existing in the natural world, thereby not only simplifying the registration process, but also broadening the scope of content that can be registered.

[0048] In the second invention, if the first storage means stores the first registration screen provided with input fields in display sequence corresponding to the input fields for input of each item name, and the first registration means adds each input display sequence to the item data attributes corresponding to each item name, storing this in each data cell of the first table, and the data output means generates an output method, on which the display sequence for the substantial contents associated with each item name is set, based on the display sequence associated with the above-noted input, it is possible to arbitrarily set the display sequence for substantial contents associated with the item names, so that when displaying the information resulting from a search, it is not only possible to perform uniform registered information output, but also to perform output with a display screen layout that is suitable to the category.

[0051] In the above-noted case, in contrast to an online database of the past, which only had viewing and searching functions via a network, this invention makes it possible to perform database registration of information of any category extremely simply, while receiving online guidance.

Problems solved by technology

In the RDB, although the table structure is designed in accordance with conforming to the above-noted standard of normal forms, these standards are merely a system of logic, with actual tasks being performed sequentially while graphing a large number of individual file groups, thereby rendering the design of a table structure extremely complex and troublesome, and requiring the expenditure of a great amount of time and labor.

Additionally, in the operating process, if there is a change in an item or the like of one table, it is often necessary to make a change to related tables and programs, the resulting editing task also, as noted-above, being extremely difficult.

In the case of the OODB, because data and methods with regard to individual stored information are encapsulated in objects, in the case, for example, of a change made to items or data in a company employee database, it is necessary to open the object of each employee and make successive changes, and when this is associated with a method, it is necessary to do an in-depth study of whether an inheriting class would be influenced, the result usually being that it is necessary to perform more complex and difficult re-editing of the program than would have been involved with the RDB.

With regard to the ORDB, which is basically a hybrid of the RDB and the OODB, because its configuration is more complex, it is accompanied by the same problems as the RDB or the OODB.

Images