RU106407U1 - DYNAMIC WEB PAGE GENERATOR BASED ON ATTRIBUTES AND DATA STORED IN THE PROJECT DATABASE - Google Patents

Abstract

 A dynamic web page generator based on attributes and data stored in a project database, comprising a database including a metadata storage device and a data storage device, a metadata storage device is interconnected with a metadata management device and with a metadata obtaining device that is interconnected with a data management device that is interconnected with a search device, with an access control device that is connected with a metadata receiving device, with an authorization device, and with interface visualization device, which is interconnected with a data input device and with a data output device, which is connected with a logging device associated with a data input device and with a data storage device, which is connected with a device for generating statistical results.

Description

The utility model relates to computing, in particular to the processing of various types of data stored in a database using specific functions and devices. This useful model can find application for processing, storage, analysis and presentation of heterogeneous data about objects belonging to a common database, and the relationships between them.

A technical solution according to US Pat. RF invention №2365972, G06F 1/00 Programming interface for a computer platform

The invention relates to an application programming interface for a network platform on which developers can create web applications and web services. The technical result of the invention is to increase the efficiency of the programming interface. The technical result is achieved due to the fact that the programming interface includes various functionalities, namely the first group of services related to reusable user interface controls, the second group of services related to user interface dialogs and user interface wizards, and the third group of services related to expand the functionality of the user interface, and the fourth group of services related to the expansion of functionality s Desktop Experience)

However, this solution is intended to simplify and speed up the development of web applications and web services, but requires programming. And it is used only in the Windows environment.

Known hierarchical multi-level automated system for collecting and processing data according to the patent of the Russian Federation for utility model No. 43984, G06F 17/40

A hierarchical multi-level automated data collection and processing system, consisting of many data collection and processing links identical in structure and function, each of which contains an input template storage unit, a static reference information storage unit, an input data storage unit, a data input unit, an import unit , an export unit, an archiving unit, a recovery unit, an electronic data exchange unit between levels and a data backup storage unit, the fourth output of a vvo unit and the data is connected to the first input of the input data storage unit, the third output of which is connected to the first input of the export unit, which is connected through its second output to the second input of the electronic data exchange unit between the levels, the first output of which is connected to the second input of the import unit, which has a third the output is connected to the second input of the input data storage unit, the fourth output of which is connected to the first input of the archiving unit, the second output of which is connected to the first input of the data backup storage unit, the connection to apart from the second input of the recovery unit, it is carried out through its second output, and the first output of the recovery unit is connected to the input data storage unit through its fifth input, and the second output of the input template storage unit is connected to the first input of the data input unit, and characterized in that it includes an input information control unit, a dynamic reference unit, a template designer, an output document designer, an output document storage unit, an output document generation unit and an information exchange unit d on paper, the first output of the input information control unit is connected to the fifth input of the data input unit, the second output of which is connected to the first input of the dynamic reference unit, the second output of which is connected to the third input of the data input unit, which is connected in its sixth output to the first the input of the output document forming unit, the second output of the template designer is connected to the first input of the input template storage unit, the third output of which is connected to the sixth input of the template designer, the fourth and fifth output which is connected respectively to the third input of the dynamic reference block and to the second input of the static reference information storage block, as well as the first output of the output document template storage unit is connected to the third input of the output document designer, the seventh output of which is connected to the third input of the output document template storage unit, which is connected in its fifth output to the fourth input of the export block, the fifth and fourth outputs of the import block are connected respectively to the fourth input of the xp block and the fourth input of the input template storage unit, the fifth output of which is connected to the third input of the export unit, the second output of the input information control unit is connected to the first input of the import unit, and the second output of the output template storage unit is connected to the third input of the unit the formation of output documents, which through its second output is connected to the first input of the information exchange unit on paper.

However, this data collection and processing system does not describe the possibility of working with a database on the Internet / Intranet. In addition, the system works with a variety of data collection and processing links that are identical in structure and function.

Known Automatic generation of web forms from a database scheme for an application for invention 2008147887/09, G06F 17/30

Generating a web user interface in a computer system for interacting with a database comprising the steps of:

- perform access to the database display, and this database display is generated from a diagram describing the configuration of the data contained in the database, including a description of the relationship by the foreign key of the first table to the second database table;

- based on the presence of a foreign key relationship, they conclude that the ratio of the second table to the first table is also relevant, although the relationship of the second table to the first table is not explicitly described in the diagram;

- automatically generate a website for the database in accordance with the display of the database, and the website is configured to provide many web forms with navigation links for interacting with data, including the first web form for interacting with data from the first table, wherein the first web form is configured with a navigation link to the second web form, which uses the derived relation to provide a view of the first table in the context of a row of the second table.

However, in the generation method described above, the structure of the web interface directly depends on the structure of tables in the database. Based on what we can conclude that the database does not use stored procedures, and the web interface works directly with tables, which affects the security of the web application.

Known long-term storage of types and instances of NET data according to the patent of the Russian Federation for the invention No. 2400803, G06F 7/10, G06F 17/30.

The invention relates to computer systems, and in particular to methods, systems and computer software products for creating database structures and for storing data in response to attributes. The technical result is to provide an optimization approach to the storage of arbitrary data structures. A general mechanism is provided for storing data objects in databases without significant dependence on the underlying data warehouse. Instead of turning to a programmer’s expertise to find out how the database structure might look like, data types are defined and supplemented by programmer attributes that indicate what the corresponding data will be used for, and without the programmer determining the database structure that will be used to store the data. After that, the database is created dynamically to meet the needs offered by the augmented attributes. In particular, a number of different tables are created in accordance with the planned needs for accessing data. When doing this, an optimized database can be created to provide the desired results, without requiring the programmer to have any special knowledge regarding databases and related database schemas.

However, in this system, in the process of working with the database, you must first create tables, configure the database. As a result, the time spent on the development and implementation of applications and the requirements for the qualifications of specialists increase.

The technical problem, which this utility model is aimed at, is to reduce the time spent on developing web applications without the use of programming (with the possibility of increasing functionality using programming). As a result, a web interface designed for remote work of users is formed, built on the basis of the attributes of indicators and data proper coming from the database. The web interface also implements the functions of search, sorting, filtering, pagination, checking files for viruses, calculating indicators stored in the database.

This problem is solved in that the Dynamic Web Page Generator based on attributes and database data contains a database including a metadata storage device and a data storage device, a metadata storage device is interconnected with a metadata management device and with a metadata obtaining device that is interconnected with the device data management, which is interconnected with a search device, with an access control device that is interconnected with a metadata receiving device, with an authorization device tion and imaging device interface, which is interconnected with the input device and output device data associated with the logging device associated with the data storage device is associated with the forming apparatus of the statistical results.

The essence of the utility model is explained in the block diagram of the generator of dynamic web pages based on attributes and data stored in the project database, figure 1 and contains the following devices:

1 - A metadata storage device, in particular, a control computer, including a processor and a structured data storage subsystem, which are the characteristics of the described indicators for the purposes of their identification, search, evaluation, management;

2 - A data storage device, in particular, a control computer, including a processor and a storage subsystem for unstructured data entered by users.

3 - A metadata management device, in particular, a host computer, including a processor, a data storage subsystem, and a metadata input and display device, provides maintenance of the structure of the indicator tree, indicator attributes, data attributes, directories, access to indicators and data attributes.

4 - A device for obtaining metadata, in particular, a control computer, including a processor and RAM, dynamically forms a structure of indicators with attributes;

5 - A data management device, in particular, a control computer, including a processor, a data storage subsystem, as well as a data input and display device, provides for the formation of a data packet.

6 - Access control device, in particular, a control computer, including a processor, a data storage subsystem, provides a restriction of user access rights at the level of indicators and data attributes to metadata and data storage devices.

7 - The authorization device, in particular, the control computer, which includes the processor and the storage subsystem, provides verification of the necessary parameters and provides access rights to certain users.

8 - Interface visualization device, in particular, one or more user terminals connected to the control computer of network communication equipment with data display devices connected to them.

9 - Data input device, in particular, one or more user terminals connected to the control computer via network communication equipment, with input devices connected to them, such as a keyboard and / or mouse, providing support for the input mode through the interface in data storage device (2).

10 - Data output device, in particular, one or more user terminals connected to the control computer via network communication equipment, with data display devices connected to them.

11 - A logging device, in particular, a control computer, including a processor and a data storage subsystem, provides a chronological record with varying degrees of detail of information about events occurring in the system (errors, warnings, messages) in the data storage subsystem (logging).

12 - A device for generating statistical results, in particular, a control computer, including a processor and RAM, provides the formation of summary statistics based on the results of the search.

13 - A search device, in particular, a control computer connected via a shared bus or other communication channels to a data storage device, including a processor and RAM, dynamically generates a set of search queries received from users via a web interface, and transfers the result to data output device (10).

The information arrays stored in the database contain data on the following objects:

- Data, which is information entered by the user through the web interface into the database.

- Attributes for data, associating data for belonging to a certain category, for example, to a territory and / or organization, etc.

- Access to data attributes, organized for the possibility of differentiating access to data at the category level.

- Indicators grouped according to certain characteristics in a list of a hierarchical type. This list contains indicators responsible for menu items, sections, table and list headings, the names of indicators for which data is stored.

- Attributes by indicators that describe the properties of an indicator, including the functions it performs, assigned to a specific indicator. Depending on the attributes, a metric can be a menu item, a section, a column heading in a table or list, as well as a lower-level element, that is, a metric with which data is directly associated.

- Access to indicators, allows you to set the rules for working with a specific indicator or group of indicators. At the same time, access is configured at any level of the hierarchical structure of indicators (from the menu to the lower level), and the ability to enable or disable viewing, editing or creating data for a specific indicator or group of indicators is also implemented.

- Files represented by lower level indicators for which the data type is set - “files”. Files are stored in a database in various formats of electronic documents, graphic images and other things.

- News, as an integral part of the database used to work with news information. The news information stored in the database can be classified according to territorial characteristics, as well as establish links with files of various types.

- Top news, as a special component of the database, formed as a result of the procedure for processing an array of news information based on the date of publication.

- The guest book, as an integral part of the database, used to work with information presented in text form and containing short notes, various wishes, comments, in order to organize feedback with users.

- External pages as an integral part of the database with the opportunity to display pages of external web applications as part of the web interface.

The operation of the dynamic web page generator based on attributes and data stored in the project database occurs as follows:

The metadata storage device (1) and the data storage device (2) are part of an existing or newly created database using ORACLE technologies. Using the metadata management device (3), the structure of the indicator tree is formed, the attributes of indicators and data are defined, reference books are maintained, and the levels of user access to indicators and data attributes are differentiated. These actions are performed through the interface without using programming. In this interface, the administrator can simultaneously see the tree-like structure of the indicators, the attributes of the indicator, the presence of attributes to the data and data for the indicator selected in the tree. Based on the created structure of the indicator tree, indicator attributes, and data attributes, the metadata obtaining device (4) dynamically forms an analog of this structure in the web interface. The data management device (5), using the information stored in the data storage device (2), generates a data packet taking into account the information received in the metadata receiving device (4). The content of incoming data packets is limited in the access control device (6), which uses the access rights information received from the metadata storage device (1). The interface visualization device (7), based on the information received from the data management device (5) and the metadata receiving device (4), taking into account the restrictions imposed by the access control device (6), displays the web user interface. Data input devices (9) and data output device (10) through an interface visualization device (7) allow users with administrator rights to remotely control content in real time. The user has the ability to view information through a data output device (10) using the search, filtering, sorting and navigation procedures on menu items. The search procedure is implemented in the search device (13). The authorization device (8) allows you to switch to a mode of working with the system adapted for a particular user. All basic user actions associated with authorization, data input / output, are recorded in the data storage device (2) using the logging device (11). The device for generating statistical results (12) implements the function of viewing the results associated with statistics of user actions in the system, the amount of information stored in the data storage device (2), etc.

Thus, the task of quickly creating an information portal (website) for working with a specific subject area defined by the user at the stage of forming the database was solved, and the opportunity to carry out operational modernization of the portal was also provided. The project is entrusted to the metadata administrator, who creates the structure of indicators, associates the necessary attributes and sets access rights to the database. The dynamic web interface of the information portal (website) is automatically generated. It contains common interface elements for developing web pages: menus, buttons, bookmarks, lists, directories, tables, etc. The formation of the elements of the web interface is associated with the structure of indicators and attributes stored in the project database. Portal users have the ability to remotely manage content while working with specific portal web pages without thinking about the technologies for creating the web interface and the portal as a whole.

Claims (1)

A dynamic web page generator based on attributes and data stored in a project database, comprising a database including a metadata storage device and a data storage device, a metadata storage device is interconnected with a metadata management device and with a metadata obtaining device that is interconnected with a data management device that is interconnected with a search device, with an access control device that is connected with a metadata receiving device, with an authorization device, and with interface visualization device, which is interconnected with a data input device and with a data output device, which is connected with a logging device associated with a data input device and with a data storage device, which is connected with a device for generating statistical results.