Table representation using natural language commands

FIELD: information technologies.

SUBSTANCE: method includes receiving information entered in natural language and analysis of information entered in natural language to identify contained in it semantic information. For part of information entered in natural language, correspondence with "command" objects and "object" objects of scheme based on semantic information and entered in natural language information. The method also contains representation of data from data source in a table of columns and rows on the basis of scheme and corresponding parts of information which has been entered in natural language.

EFFECT: providing more effective interface for creation and representation of table with information from data source.

35 cl, 5 dwg

 

The LEVEL of TECHNOLOGY

The present invention relates to a method of controlling the application by converting the user input into commands for the application. In particular, the present invention relates to the conversion of user input to the command to display information from a data source, such as a database.

In conventional computer systems, the user input is limited to a rigid set of user responses with a fixed format. For example, when using the command-line interface for user input must have a specific form that uniquely identifies a single command and the selected parameters from a limited and specific set of possible parameters. Similarly, using a graphical user interface to the user are only a limited set of features, and is relatively traditional for the developer to define the scope of the information input by the user, which consists of a limited set of commands or objects for each specific user input in a limited set of user input.

Limiting user a rigid set of allowed to enter information or answers, the computer system is s required from the user or operator of a significant level of skill. Traditionally, the user was responsible for mental transformation required tasks that must be performed in a specific input information, which recognize applications running in a computer system. For increased convenience and ease of use of computer systems, continuously ongoing effort to provide the application interface in natural language (NL). The interface in natural language extends the functionality of applications outside of a restricted set of input information and opens the computer system to enter information in the format of a natural language. The interface in natural language is responsible for the conversion of the relatively uncertain and extremely based on the context of the field of natural language in a precise and rigid set of input data, which requires a computer application.

Converting the entered natural language information to display information from a data source, such as a database, may be difficult to perform due to the custom nature of the data sources and the many ways of displaying information from a data source. In particular, the mapping tables for the analysis of information stored in the data source, execute certain commands from the user, identifying the x, what information should be displayed and how to display. Due to such a cumbersome interface that many users have difficulties in displaying spreadsheets for easy data analysis. Providing a friendly interface to create and display tables with information from the data source would provide a more effective tool for data analysis.

DISCLOSURE of INVENTION

The present invention relates to a method for application management, which includes processing data stored in a structured data source. This method includes receiving the entered natural language information and analysis are entered in natural language identification information contained semantic information. For part of the entered natural language information set consistent with the objects "command" and objects of the object schema, based on the semantic information and the entered natural language information. The method also includes displaying data from a data source in a table of columns and rows based on this diagram and respective parts are entered in natural language information.

Another aspect of the present invention relates to machine-readable media containing data in the page is churromania the data source, which include measurements and the values associated with these measurements. These commands include a user interface module configured to receive the entered natural language information and to display the table. The generation module tables set up to access the dimensions and values and to determine the schema to display image data and values. In addition, the interpretation module is configured to establish the correspondence between the terms in the input natural language information and the object of the object schema, which corresponds to the dimensions in the data source, and for generating candidate for interpretation of how to display data in the data source based on the entered natural language information, dimensions and diagram.

Another aspect of the present invention is a method of information processing for application management, which includes receiving the entered natural language information. Entered in natural language analyze information to identify it contains semantic information. This method also includes accessing the schema for object identification "command" and "object object"based on the semantic information and the entered natural language information, and perform the action svjazanno the application, based on the command object and the object "object".

BRIEF DESCRIPTION of DRAWINGS

Figure 1 - structural diagram of the configuration of the computing system.

Figure 2 - block diagram of a system for displaying a table based on user input.

Figure 3 - chart of exemplary schema.

Figure 4 - sequence of operations of an exemplary method of displaying tables.

5 is a screen shot of a user interface for receiving user input and to display information table.

The IMPLEMENTATION of the INVENTION

Figure 1 shows an example of the appropriate configuration of the computing system 100, which may embody the invention. The configuration of the computing system 100 is only one example of a corresponding computing configuration and does not introduce any limitations on the possibilities of use or functionality of the present invention. Computer configuration 100 should not be interpreted as having any dependency or requirement relating to any one or combination of components illustrated in the exemplary configuration 100.

The invention can work with a variety of other configurations of the generic or specific computing systems. Examples of well known computing the systems, environments and/or configurations that may be used with this invention include, but are not limited to, personal computers, server computers, handheld or laptop computers, multiprocessor systems, systems based on microprocessor, set top boxes, programmable consumer electronics, network PCs, minicomputers, mainframe (universal electronic computers), telephony systems, distributed computing environments that include any of the above systems or devices, and so on

This invention can be described in the General context for executing computer commands, such as program modules, executed by the computer. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform particular tasks or implement certain abstract data types. The invention may also be implemented in distributed computing environments where tasks are performed by remote processing devices that are linked through a communications system. In a distributed computing environment, the program modules may be located in both local and remote computer storage media including memory devices. The tasks performed in accordance with programmatie modules, described below using drawings. Specialists can translate the description and drawings as executed by the processor commands that can be recorded on machine-readable media of any kind.

Referring to figure 1, an exemplary system for embodiments of the invention includes a General-purpose computing device in the form of a computer 110. The computer 110 may include the following components: a processor 120, system memory 130, and a system bus 121 that connects various system components including the system memory to the processor 120, but its composition is not limited. The system bus 121 may be any of several types of bus structures, including the memory bus or memory controller, a peripheral bus and a local bus using any of a variety of bus architectures. For example, and not as a limitation, this architecture includes a bus architecture, relevant industry standard (ISA)bus, a microchannel architecture (MCA)bus, enhanced standard architecture for industrial applications (EISA), local bus Association standards in the field of video electronics (VESA) and bus connections to peripherals (PCI), also known as the expansion bus.

The computer 110 typically includes a variety of machine-readable is the lei. Machine-readable media can be any available media that can be accessed computer 110, and they include both volatile and nonvolatile media, removable and non-removable media. For example, but not as a limitation, machine-readable media may include computer storage media and communication media. Computer storage media include volatile and nonvolatile, removable and non-removable media implemented using any method or technology for storage of information such as machine-readable commands, data structures, program modules or other data. Computer storage media include, but are not limited to, random access memory (OP), a persistent storage device (ROM), electrically erasable permanent memory (EEPROM), flash memory or other memory technology, CD-ROMs (CD-ROM), digital versatile disks (DVD) or other optical disk storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other medium that can be used to store the necessary information and can access the computer 110. Communication usually embody sitive is haunted by computer commands, data structures, program modules or other data in a modulated data signal such as a carrier, or use other transport mechanism and include any information delivery. The term "modulated data signal" means a signal that has one or more of its characteristics set or changed in such a manner as to encode information in the signal. For example, and not as a limitation, communication include communication channels, such as a wired network or direct-wired connection, and wireless communication channels, such as acoustic, RF, infrared and other wireless communication channels. Machine-readable media shall also include any combination of the above media.

The system memory 130 includes computer storage media in the form of volatile and/or nonvolatile memory, such as persistent storage device (ROM) 131 and random access memory (OP) 132. The system basic input / output system (BIOS) 133, which contains the basic routines that help to transfer information between elements within computer 110, for example, during start-up, is typically stored in ROM 131. RAM 132 typically contains data and/or program modules that are immediately on the vent for processing and/or currently being serviced by the processor 120. For example, but not as a limitation, figure 1 illustrates operating system 134, application programs 135, other modules 136 programs and data 137 programs.

The computer 110 may also include other removable/non-removable, volatile/nonvolatile computer storage media. For example, figure 1 shows the drive 141 on the hard drive, which reads or writes information on non-removable, nonvolatile magnetic disk drive, magnetic disk drive that reads information from or writes information on a removable nonvolatile magnetic disk 152, and an optical drive that reads information from or writes information on a removable nonvolatile optical disk 156 such as a CD-ROM (CD-ROM) or other optical media. Other removable/non-removable, volatile/nonvolatile computer storage media that can be used in the sample configuration, include a cassette magnetic tape, memory cards, digital versatile disks, digital video tape, solid state OD, solid state ROM, and the like, but are not limited to them. Drive 141 on the hard disk drive is typically connected to the system bus 121 through a medium pair (interface) with non-removable storage device, such as a tool, the interface 140 is, and drive 151 on a magnetic disk and an actuator 155 of the optical disk drive is typically connected to the system bus 121 through a medium pair (interface) from the removable storage device, such as a vehicle 150 pair.

Devices and associated computer storage media discussed above and shown in figure 1, provide storage of machine-readable commands, data structures, program modules and other data for the computer 110. In figure 1, for example, the drive 141 on the hard disk is shown as storage device operating system 144, application programs 145, other modules 146 programs and data 147 programs. It should be noted that these components can either be the same as the operating system 134, application programs 135, other modules 136 programs and data 137 programs, or different from them. Operating system 144, application programs 145, other modules 146 programs and data 147 programs assigned to other identifiers in order to show that they at least are other copies.

The user can enter commands and information into the computer 110 through input devices such as a keyboard 162, a microphone 163 and device 161 positioning, such as a mouse, trackball ("trackball") or the touch pad. Other input devices (not shown) may include himself joystick game pad, satellite dish, scanner, or similar device. For applications of natural user interface, the user can optionally communicate with your computer using your voice, handwriting information, the gaze (eye movement) and other characters. To facilitate the use of natural user interface, the computer may include microphones, tablets for recording, camera, motion sensors and other devices for fixing signs of the user. These and other input devices are often communicate with the processor 120 through a user input interface 160 that is associated with the system bus, but they can communicate with other interface and bus structures, such as a parallel port, game port or a universal serial bus (USB). A monitor 191 or other type of display device is also connected to system bus 121 via an interface, such as a video interface 190. In addition to the monitor, computers may also include other peripheral output devices, such as speakers 197 and printer 196, which may be connected through the interface 190 external devices output information.

The computer 110 may operate in a networked environment using logical connections to one or more remote t is the number of computers, such as a remote computer 180. The remote computer 180 may be a personal computer, a handheld device, a server, a router, a network PC, a peer network device or other common network node, and typically includes many or all of the elements described above relative to the computer 110. The logical connections depicted in figure 1 include a local area network (LAN) 171 and a wide area network (WAN) 173, but may also include other networks. Such network configurations typically used in offices, computer networks enterprise-wide, corporate networks (intranet) and the Internet.

When working in a LAN environment, the computer 110 is connected to the LAN 171 through a network interface or adapter 170. When working in the environment of the HS, the computer 110 typically includes a modem 172 or other means for establishing communications over the WAN 173, such as the Internet. The modem 172, which may be internal or external, may be connected to the system bus 121 via the user input interface 160, or other appropriate mechanism. In a network environment, program modules depicted relative to the computer 110, or parts thereof, may be stored in a remote storage device. For example and not as limitations, figure 1 illustrates remote application programs 185 as residing on a remote computer 180. The show is about, as illustrated network connections are shown as examples and can use other means of establishing communication between computers.

Typically, application programs 135 interact with the user via the command line or graphical user interface (GPI) input through the user interface 160. However, to simplify and expand the use of computer systems have been developed input device that can accept user-entered natural language information. Unlike natural language or speech graphical user interface is accurate. A well-designed graphical user interface usually does not create ambiguous references or requires that the host application has confirmed the specific interpretation of the input information received via the interface 160. For example, due to the fact that this interface is accurate, there is typically no requirement that the user made an additional request for the information entered, ie: "You clicked 'OK'?". Typically, the object model developed for the graphical user interface is mechanistic and very hard when it is executed.

In contrast to input information using a graphical password is defined interface request or command in a natural language are often not converted into one and in the sequence of function calls to the object model input information. Unlike rigid, mechanistic limitations of traditional information input through the command line or through a graphical user interface natural language is a means of communication, in which both parties-people rely on the intelligence of each other, often subconsciously, to resolve ambiguities. In fact, natural language are regarded as "natural" just because he is not mechanistic. People-the parties can resolve ambiguity based upon the context information and tips related to any actions surrounding the utterance. With people-people offer "Send the Protocol to those who participated in the review meeting on Friday" is a perfectly understandable without further explanation. However, from a mechanistic point of view of the individual parts of the machine must be defined, such as what exactly the document to which the meeting referred to, and to whom the document you want to send.

The present invention relates to the interpretation of the entered natural language information management application and associated actions. Can be determined scheme (algorithm) and to control the interpretation put on natures is nom language information and to initiate actions associated with the application. As a result, this scheme interacts with the application itself, and semantic interpretations entered by the user in natural language information. Professionals need to recognize that the circuit may be a separate code and/or may include application code. Aspects of the present invention can be used in many different configurations to provide improved user interface in natural language. One specific configuration, which may use aspects of the present invention involves the display of information from a structured data source, such as a database. This schema can be used to display a table of columns and rows, or, for example, from a single cell. In the case when displaying the single cell information, the information may be the answer to the question presented in natural language, instead of providing the data in table format. For example, the user can enter the question "How many claims paid California in 1999?". In this case, can be represented reply "3482", so you don't have to browse large amounts of data to find the answer.

Figure 2 shows a block diagram of a system for converting the entered user is in natural language information and to display tabular information, based on the entered natural language information. The system 200 includes a module 202 of the user interface module 204 table generation module 206 interpretation and the base 208 of the data. It should be noted that the base 208 of the data - the estimated data source. The data source can have many forms, such as a database SQL (structured query language), cube OLAP (online analysis) or a worksheet in Microsoft Excel. The user must ensure that the transfer is entered in natural language information module 202 of the user interface in the form of commands, questions or other input information related to the generation of the table. For example, the user can provide the question "Show gross profit for the plane and direction for the year", or "What was the total income for the 737 in 1999?", or just "profit". Module 202 of the user interface takes input in natural language information and provides it to the transmission module 204 table generation.

Module 204 table generation defines the schema of the commands and the corresponding attributes for the various commands that can be used when displaying the table. For example, the commands may include "new", "show", "add", "hide", "select", "filter", "clear", etc. and they include attributes, in addition to determine the Andes. Teams may also include printing a spreadsheet and create a chart from data in the database 208 of the data. The scheme may be secured to the module 206 interpretation to control the interpretation of the entered information. An alternative scheme may be used to display a single cell information. Module 204 table generation uses module 206 interpretation for assistance in determining what information should be displayed, based on the entered natural language information received from module 202 of the interface, and the particular pattern that controls the action, pre-formed to create and table generation. Module 204 table generation refers to the base 208 of the data to identify words and/or phrases that match the items stored in the data 208, and provides the transfer module 206 interpretation.

The module 206 interpretation parses input from a user, schema, and words and phrases from the database to generate candidates for semantic interpretation of what information to display to the user. First to the schematic analysis of the user input to provide semantic information to interpret what the user would like to display. For example, the named object in the input information may report the term to which that user wants to display as the page a row or column or within a table data region. Can also be used in other semantic techniques, such as identifying parts of speech, the use of partial compliance of the terms and/or method, which relies on certain parts of speech to determine the compliance, identification of morphological variants (i.e. "region" and "regional"), the decision of the concatenation of the names (i.e. "home owner" and "landlord"), date normalization (i.e. "1/1/04" and "1 January 2004"), identification of synonyms through a thesaurus of the words, the resolution changing the order of words (i.e. "total income" and "total income") and ways the ranking. Other semantic information can be identified by the module 206 interpretation, for example the negation of values (i.e. hide), comparison (i.e. values above the threshold value), etc.

Using semantic information and schema module 206 interpretation matches one or more jobs in the input natural language information with the command object schema and matches the other information in the input natural language information with one or more objects "frame" and/or one or more objects of the object schema. The schema may also include other objects, such as objects "designation" and "limitation"that can identify the other objects, and describe the properties of objects. When entered in natural language information set according to the schematic, decide on the candidates to interpret and send module 204 table generation.

In one exemplary embodiment, the module 202 of the user interface may be a spreadsheet application such as Microsoft Excel, provided by Microsoft Corporation, Redmond, Washington. The spreadsheet application may be configured to process and display all kinds of information database. For example, the spreadsheet application can be a tool to display the online analytical processing (OLAP). OLAP refers to the method of processing, which allows the user to easily and selectively extract and view data from the database in various ways. In the data model OLAP information considered conceptually as cubes, which consist of descriptive categories (dimensions, dimensions) and quantitative values (measures). Multidimensional data model facilitates users to formulate complex queries, organizing data in a report, the switching from the generic to the detailed data and filtering or separation of data into meaningful subsets. For example, the dimensions in the cube that contains commercial information, can in luceti in time, geographic location, product, channel, organization and scenario (budget and actual). Indicators can include dollar sales, sales in units, inventory, headcount, income and expenses.

Within each dimension of the data model OLAP data can be organized in a hierarchy that represents the levels of detail. For example, within the dimension of "time" one can distinguish the following levels: years, months, and days; similarly, within the measurement geography one can distinguish the following levels: country, region, state/province and city. A particular instance of the data model OLAP has a specific value for each hierarchy level. When viewing OLAP data the user moves up or down between levels in order to see more detailed or less detailed information.

In one of the embodiments of the present invention is introduced in a natural language information provided by the user, can be converted to create a so-called pivot table (PivotTable) in a spreadsheet application such as Microsoft Excel, based on the dimensions of the OLAP cube. The pivot table is an interactive table that can summarize large amounts of data. Interactive table display shows the user the opportunity to alternate (swap) rows and columns of information for so that the user viewed a different amount of data in the database 208 of the data, filter the data by displaying different pages and/or display information from the database. Summary table contains fields, each of which summarizes multiple rows of information from the original data. A summary table can also summarize data by using functions of summation, such as sums, counts, and/or the calculation of the average values of certain cells in the table. To create a PivotTable, the user can cause the module 204 table generation. In one embodiment, the implementation module 204 table generation - "wizard"that guides the user when entering information related to the display information table.

In this embodiment, the module 204 table generation can define the schema based on the actions available to create and modify a PivotTable. The diagram can be represented as a hierarchy of objects "command", "frame" and "object". Other objects may include named objects "designation", "limit" and "object". The object command identifies the tasks and activities the object frame" identifies steps related to how data should be displayed, and the object object identifies the data. Certain specimens of the s these objects can be used to provide the mapping information. These instances can inherit properties from the base class. The scheme is used by module 204 table generation to perform actions on the data to generate tables and module 206 interpretation to control the interpretation of user input.

Figure 3 - chart of exemplary schema that is used to move data fields between the axes in the table. The circuit 220 includes an object 222 "team", which is illustrative command "move axis". Object 222 "team" includes the corresponding object 224 "frame", frame, "move axis". Object 224 "frame" includes three corresponding object object 226, 228 and 230. Object 224 "frame" specifies that each object object 226, 228 and 230 with the object 222 "team". Objects object associated with data in the database 208 of the data. In one embodiment, the implementation of objects object can be associated with a column or row to be displayed. In the shown embodiment, the object 226 object is the default object, which in this case is a eld object and defines a field of data that must be moved. Thus, if the interpretation of the use of the information you entered does not identify a specific object needed to perform the commands in the object 222 "command"field of the object 26 is defined in the default which can be based on different rules. The object 228 object - the target object that defines the axis for which you want to display the data. Object 230 object - the original object that defines the current field, which should move to the other axis.

Figure 4 - sequence of operations of an exemplary method of displaying the user table. Method 250 begins at step 252, which cause the generation of the tables. At step 254, the generation module tables may also refer to the terms and/or phrases in a database corresponding to the dimensions, levels, measures, and/or items in the database 208 of the data that will be used to map terms from a user-entered information. Identified terms database can be maintained in the archive for future use to improve performance module 204 table generation. At step 256 the user accept the entered natural language information. Entered in natural language information can be of any shape, which includes the text entered from the keyboard, voice data and/or hand-written data, and it can be in any language, which includes English, German, French, Spanish, Japanese, etc.

Having entered in natural language and the formation at step 258 may perform a semantic analysis of the input information to identify semantic information associated with the entered information. Then you can get the candidates to the interpretation of the user-entered information based on semantic information and aligned to user-entered information with the units of the scheme as described above. It should be noted that the team does not need to be explicitly expressed in the input natural language information, but it may be implied in the entered information. For example, when writing information "apples and bananas" can be implied that you are using the command "show". Using candidate for interpretation, at step 262 may be displayed descriptions table candidate. The table description-the candidate may take many forms to create interactive, user-friendly interface. For example, while printing, the user can seem interpretation and/or a preview of the tables can be allocated recognized in terms of input data, may seem numerous tabular configuration (i.e. objects such as row or column), descriptions in natural language tables-candidates can be presented in the list, and the selection of ambiguous terms can be presented in a pop-up menu.

Additionally, the user can select partial ambiguity in descriptions of the candidates. For example, if the user enters "sale" in the input data, one of the candidates may include the term "number of sales", which is part of the base 208 of the data and can be equated to the term "sale". Providing an interactive approach to partial resolution of ambiguities, the user can select the "number of sales" as equivalent to the term "sale". This information (i.e. that equate the terms "sales" and "sales amount") can be maintained and additionally be used to control future interpretations.

If the user selects one of the table descriptions-candidates, then this particular table is then displayed at step 266. Alternative if desired, the table can be displayed "on the fly"when the term is recognized or changes occur in the user input. In addition, part of the entered natural language information can be used for recognition and visual indications terms when printing by the user. For example, when printing a user-recognized term may be different. When the table is displayed, the user can modify the table, providing an additional command or multiple commands to change the of the table or to display the new table. At step 268 may be used additional commands, for example, to allocate part of the table, hide, and/or to add rows and columns, sort, and filter information, as well as other teams. At step 266 may then be displayed in a new table.

Figure 5 shows an exemplary interface 300 used in accordance with one embodiments of the present invention. The interface 300 includes a screen 302 table for displaying information from the database 208 data in a table of columns and rows. In the shown embodiment, the total revenue for different types of aircraft are shown by region. The window 304 provides the user to view the description of the table and to provide input to a natural language, which is used by module 204 table generation. The window 304 includes a description of 306 table that describes the contents of the table that is currently being displayed on the screen 302. Additionally provide an example 308 input information to create the table. For the table display, the user can enter text in field 310. Additionally, as described above, the user can be provided with a description 312 candidates in the list so that the user can easily select one candidate from the list. Additionally, the user can provide the accept button 314, so he chose a specific arrangement (layout) table. For example, button 314 can change the measurement from columns to rows. In one embodiment, the implementation of a number of different locations (or configurations) may be limited based on the order of terms in the input natural language information.

In the example shown in figure 5, the user has entered in natural language information "to show the income for the aircraft and the region" in field 310 of the input information. Module 204 table generation, referring to the terms of the base 208 of the data identified the measurement of "total income", "aircraft type" and "name of the region". The module 206 interpretation using entered in field 310 of the information and dimensions in the database 208 data, converts the entered information and provides a description of the candidate show the total income by type of aircraft and the names of the regions" in field 312.

After the user has selected this interpretation, the current description 306 and the screen 302 table updates to show the selected table and the corresponding description. The user is then allowed to enter in field 310 additional commands in natural language that are related to the table on the screen 302 or which are relevant to the new table. For example, the user can provide commands to hide Australia", "show only 747", "allocated the ing income more than 10000 $" etc. In these examples, the application will hide the column, Australia, displays a table in which the data is associated only with the aircraft type 747, and will highlight the value of aggregate income, which more than 10000$, respectively.

In the above described embodiments provide the interface in natural language to display information from a data source, such as a database, in a table of columns and rows. This interface facilitates users to generate and display the tables used for data analysis. Thus, the analysis of the data using mapping tables can be executed more efficiently on time and more user-friendly way.

Although the present invention has been described in relation to specific embodiments, professionals need to recognize that changes may be made in form and detail without departing from the scope and forms of the invention.

1. A method of processing data stored in a structured data source, this method contains the steps:
accept the entered natural language information
analyze the entered natural language information to identify it contains semantic information,
set the according part of the entered natural language information with the command object and the object of the object schema, based on SEM is nicesly information and the entered natural language information and
display data from a data source in a table of columns and rows based on the schema and the corresponding parts of the entered natural language information
moreover, the step of matching further comprises matching a portion of the entered natural language information with the object of "frame" scheme and the "object frame" corresponds to the display data.

2. The method according to claim 1, additionally containing phase:
access the database to identify words and phrases associated with dimensions in the data source.

3. The method according to claim 2, in which the step of contacting further comprises identifying words and phrases related to the levels and values in the data source.

4. The method according to claim 1, in which the object "team" refers to the task that will be executed to display the data.

5. The method according to claim 1, in which the object "object" refers to the data in the data source or to objects in the application.

6. The method according to claim 1, additionally containing phase:
alter table based on additional accepted command.

7. The method according to claim 6, in which additional command selects the part of the table.

8. The method according to claim 6, in which additional command sorts the table.

9. The method according to claim 6, in which an additional command filters the information in the table.

10. The way is about to claim 6, where additional command adds information to the table.

11. The method according to claim 6, in which additional command removes information from the table.

12. The method according to claim 7, in which an additional command includes the exchange of information in columns and rows.

13. The method according to claim 1, additionally containing phase:
are candidates for interpretation, based on the entered natural language information.

14. The method according to claim 1, additionally containing phase:
provide an interactive user interface to enter information in natural language.

15. The method according to 14, further containing the step:
perform at least one of: specifying a recognized term in the input natural language information and provide candidates for interpretation when the user enters information in natural language.

16. The method according to claim 1, additionally containing phase:
display the description information in the table in natural language.

17. The method according to claim 1, additionally containing phase:
support archive displayed earlier tables for future use.

18. The method according to claim 1, additionally containing phase:
set the according part of the entered natural language information with words and phrases associated with the data source.

19. The method according to claim 1, in which the analysis further comprises identifying ambiguous terms in the input natural language information and provision of alternative candidates for ambiguous terms.

20. Machine-readable media containing commands for processing data in a structured data source, including the dimensions and the values associated with these dimensions, these commands include:
the user interface module, configured to receive the entered natural language information and to display the table,
the generation module tables configured to access the dimensions and values and to determine the schema to display data dimensions and values, and
the interpretation module, configured to perform semantic analysis of the entered natural language information to establish the correspondence between the terms in the input natural language information and the command object which refers to the task that will be executed by the object "object"and "object frame", which refers to how to display data schema corresponding to the dimensions in the data source, and to generate candidates for the interpretation of how to display data in the data source based on the entered natural language information, dimensions and diagram.

21. Machine-readable media according to claim 20, in which the user interface module is configured to submission of applications to the interpretation of the tables.

22. Being read to is a computer medium according to claim 20, in which the data source includes the levels associated with the dimensions.

23. Machine-readable media according to claim 20, in which the user interface module is configured to display the table of dimensions and values from the data source based on at least one of the candidates for the interpretation of the table.

24. Machine-readable media according to claim 20, in which the interpretation module is configured to compare the words and phrases in the input natural language information with the dimensions and values in the data source.

25. Machine-readable media according to claim 20, in which the user interface module set up for presentation to the user of a candidate for interpretation.

26. Machine-readable media on A.25, in which a candidate for the interpretation includes many configurations table, and at least one configuration associated with the same data.

27. Machine-readable media according to claim 20, in which the user interface module is configured to enable the user to select one of the candidates for interpretation to display the table associated with the selected candidate for interpretation.

28. The method of processing information to control the application, containing the steps:
accept entered on the natural the state language information analyze the entered natural language information to identify it contains semantic information,
refer to the schematic to identify the command object and object object, based on the semantic information and the entered natural language information, and
perform the action associated with the application based on the command object and the object object,
with the command object associated with the command executed in the application, and the object "object" is associated with the data used by the application when executing this command.

29. The method according to p, which application is a spreadsheet application.

30. The method according to p, in which the action includes
displaying data from a data source in a table of columns and rows based on the schema.

31. The method according to item 30, in which the action includes displaying a single cell information from a data source based on the entered natural language information.

32. The method according to p in which an appeal to the circuit further comprises identification of the object frame and the object frame establishes the correspondence between the subject object and the command object.

33. The method according to p, optionally containing a representation of a candidate for the interpretation of the entered natural language information based on the Birmingham and semantic information.

34. The method according to p, in which the reference to the scheme involves identification of multiple objects object.

35. The method according to p, in which the reference to the scheme involves identification of multiple objects "command".



 

Same patents:

FIELD: information technologies.

SUBSTANCE: invention is related to facilities of training and science research automation and may be used in interactive systems of research and development works automation in process of software (SW) verification in distributed computer complexes (DCC). Suggested method and system for its realisation provide complete manageability and observability of the main processes of SW initial code verification. At the same time at each level of DCC processes of SW initial code input and processing are combined along dependent or independent interface channels, on the basis of application of sensor or mechanical manipulators of computer operator workplace, network interfaces of local or global network Sections or points of SW initial code vulnerability are defined on the basis of SW initial code transformation into internal representation, which is stored in the form of databases and knowledge bases, and sections or points of SW initial code vulnerability are defined on the basis of automatic making and solving of according equation systems.

EFFECT: expansion of functional resources of DCC SW verification processes

9 cl, 40 dwg, 26 tbl

FIELD: information technologies.

SUBSTANCE: invention is related to facilities of training and research automation and may be used in interactive systems of research and development works automation in process of software (SW) verification in distributed computer complexes (DCC). Suggested method and device for its realisation provide complete manageability and observability of the main processes of SW initial code verification. At the same time processes of SW initial code input and processing are combined along dependent or independent interface channels, on the basis of application of sensor or mechanical manipulators of computer operator workplace, user interfaces of local or global network. Sections or points of SW initial code vulnerability are defined on the basis of SW initial code transformation into internal representation, which is stored in the form of databases and knowledge bases, and sections or points of SW initial code vulnerability are defined on the basis of automatic making and solving of according equation systems.

EFFECT: expansion of functional resources of DCC SW verification processes.

9 cl, 39 dwg, 26 tbl

FIELD: physics; computer facilities.

SUBSTANCE: offered invention concerns ways and systems for transformation of object of one type in object of other type. Transformation can be carried out in an augmented agent of serialisation which carries out serialisation, deserialisation and transformation of objects of various types. Changes during performance are imported to operation of an agent of serialisation by means of one or more procedures of expansion which realise required configuring for specific needs or expansion, thus not demanding replacements of other available procedures. On the basis of the information on the type, identified for initial object, object will converse to the intermediate representation which supposes change during performance, including change of names of object, types of object and object data. The intermediate representation of initial object change according to procedures of expansion which make changes to operation of a resort of serialisation during performance, and the intermediate representation will converse to target object or type.

EFFECT: possibility of change or configuring for specific needs of operation of transformation process to performance time.

35 cl, 7 dwg

FIELD: physics, computer engineering.

SUBSTANCE: invention is related to processing of electronic ink. Method of the first data structure matching with the second data structure consists in the following: for every unit of the second data structure it is defined whether this unit received change from appropriate unit in the first data structure; for every unit in the second data structure, for which it has been defined that it received change from appropriate unit in the first data structure, attempt of access is realised to this unit in the first data structure; if mentioned unit in the first data structure is unachievable, realisation of mentioned change is prevented in the second data structure; if it is achievable - it is defined, when mentioned change in relation to the second data structure creates optional collision, and sometimes obligatory collision; if change creates optional collision, it is defined whether it is prohibited by collision criteria; if optional collision is not prohibited, mentioned change is performed; if it is prohibited - realisation of mentioned change is prevented, at that mentioned collision criteria prohibit removal of ink strokes from end unit under fixed unit.

EFFECT: expansion of method functional resources.

12 cl, 49 dwg

FIELD: physics, computer facilities.

SUBSTANCE: invention concerns computer facilities. The system of transformation of the files, having at least one file, associated with one or more non-structured properties is given. The output agent of properties of a file manipulates with non-structured properties according to one or several structured properties, associated with medium of storehouse of the structured objects. If not structured file be used in a context of medium of storehouse of the structured objects, unfolding operation is carried out for updating of not structured properties in a file in the structured properties approaching for operation in the environment of storehouse of structured objects. If concerning the developed device the manipulation in the environment of storehouse of the structured objects be executed, operation of compression or an inverse transformation is carried out for updating of properties in the file.

EFFECT: interaction and compatibility possibility between non-compatible data systems.

26 cl, 9 dwg

FIELD: computer science, in particular, engineering of automated system for distributed processing of text documents.

SUBSTANCE: system contains block for receiving text documents, blocks for identification of base address of text documents, block for selection of structure of text document, block for modifying record address for text document, block for selecting sections of text documents, block for addressing sections of text documents, block for modifying record address of text document, block for selecting sections of text documents, block fro addressing sections of text documents, block for modifying reading address of text document section, block for receiving text documents of executives, block for identification of base address of documenting of sections of text documents, block for recording number of completed tasks, block for modification of address of record of completed tasks, block for commutation of channels for dispensing text documents and block for dispensing data and control signals.

EFFECT: increased speed of operation of system by means of localization of addresses of text documents in system database by identifiers of the very text documents.

13 dwg

FIELD: the invention refers to the system of remote training.

SUBSTANCE: the system has an arrangement for providing training in rendering training services through a net; an arrangement for transmitting texts connected with training aids, an arrangement for evaluation of reception of the answer through a net; an arrangement for transmitting of evaluation of transmitting the result of evaluation to a user; a database about members supporting training; an arrangement for selection of supporting members for reception of inquiry about support from the user through a net and for selection of a member for training in required field of specialization; an intermediary arrangement for connection for fulfillment of the role of the mediator at connecting the contact address of the selected member supporting training and the user through a net.

EFFECT: allows to provide services in training with dynamically changing training changes depending from the evaluation of the degree of perception in remote system with corresponding support.

6 cl, 9 dwg

The invention relates to the publishing industry and can be used for the preparation and issue of reference books
The invention relates to the field of electronics and is designed, for example, to use auxiliary data arrays in the conversion process and/or verification of computer codes in the form of symbols, and the corresponding portions of the image
The invention relates to the field of electronics and can be used, for example, in the way of interrelated activation computer code in the form of symbols and corresponding portions of the image

FIELD: the invention refers to the system of remote training.

SUBSTANCE: the system has an arrangement for providing training in rendering training services through a net; an arrangement for transmitting texts connected with training aids, an arrangement for evaluation of reception of the answer through a net; an arrangement for transmitting of evaluation of transmitting the result of evaluation to a user; a database about members supporting training; an arrangement for selection of supporting members for reception of inquiry about support from the user through a net and for selection of a member for training in required field of specialization; an intermediary arrangement for connection for fulfillment of the role of the mediator at connecting the contact address of the selected member supporting training and the user through a net.

EFFECT: allows to provide services in training with dynamically changing training changes depending from the evaluation of the degree of perception in remote system with corresponding support.

6 cl, 9 dwg

FIELD: computer science, in particular, engineering of automated system for distributed processing of text documents.

SUBSTANCE: system contains block for receiving text documents, blocks for identification of base address of text documents, block for selection of structure of text document, block for modifying record address for text document, block for selecting sections of text documents, block for addressing sections of text documents, block for modifying record address of text document, block for selecting sections of text documents, block fro addressing sections of text documents, block for modifying reading address of text document section, block for receiving text documents of executives, block for identification of base address of documenting of sections of text documents, block for recording number of completed tasks, block for modification of address of record of completed tasks, block for commutation of channels for dispensing text documents and block for dispensing data and control signals.

EFFECT: increased speed of operation of system by means of localization of addresses of text documents in system database by identifiers of the very text documents.

13 dwg

FIELD: physics, computer facilities.

SUBSTANCE: invention concerns computer facilities. The system of transformation of the files, having at least one file, associated with one or more non-structured properties is given. The output agent of properties of a file manipulates with non-structured properties according to one or several structured properties, associated with medium of storehouse of the structured objects. If not structured file be used in a context of medium of storehouse of the structured objects, unfolding operation is carried out for updating of not structured properties in a file in the structured properties approaching for operation in the environment of storehouse of structured objects. If concerning the developed device the manipulation in the environment of storehouse of the structured objects be executed, operation of compression or an inverse transformation is carried out for updating of properties in the file.

EFFECT: interaction and compatibility possibility between non-compatible data systems.

26 cl, 9 dwg

FIELD: physics, computer engineering.

SUBSTANCE: invention is related to processing of electronic ink. Method of the first data structure matching with the second data structure consists in the following: for every unit of the second data structure it is defined whether this unit received change from appropriate unit in the first data structure; for every unit in the second data structure, for which it has been defined that it received change from appropriate unit in the first data structure, attempt of access is realised to this unit in the first data structure; if mentioned unit in the first data structure is unachievable, realisation of mentioned change is prevented in the second data structure; if it is achievable - it is defined, when mentioned change in relation to the second data structure creates optional collision, and sometimes obligatory collision; if change creates optional collision, it is defined whether it is prohibited by collision criteria; if optional collision is not prohibited, mentioned change is performed; if it is prohibited - realisation of mentioned change is prevented, at that mentioned collision criteria prohibit removal of ink strokes from end unit under fixed unit.

EFFECT: expansion of method functional resources.

12 cl, 49 dwg

FIELD: physics; computer facilities.

SUBSTANCE: offered invention concerns ways and systems for transformation of object of one type in object of other type. Transformation can be carried out in an augmented agent of serialisation which carries out serialisation, deserialisation and transformation of objects of various types. Changes during performance are imported to operation of an agent of serialisation by means of one or more procedures of expansion which realise required configuring for specific needs or expansion, thus not demanding replacements of other available procedures. On the basis of the information on the type, identified for initial object, object will converse to the intermediate representation which supposes change during performance, including change of names of object, types of object and object data. The intermediate representation of initial object change according to procedures of expansion which make changes to operation of a resort of serialisation during performance, and the intermediate representation will converse to target object or type.

EFFECT: possibility of change or configuring for specific needs of operation of transformation process to performance time.

35 cl, 7 dwg

FIELD: information technologies.

SUBSTANCE: invention is related to facilities of training and research automation and may be used in interactive systems of research and development works automation in process of software (SW) verification in distributed computer complexes (DCC). Suggested method and device for its realisation provide complete manageability and observability of the main processes of SW initial code verification. At the same time processes of SW initial code input and processing are combined along dependent or independent interface channels, on the basis of application of sensor or mechanical manipulators of computer operator workplace, user interfaces of local or global network. Sections or points of SW initial code vulnerability are defined on the basis of SW initial code transformation into internal representation, which is stored in the form of databases and knowledge bases, and sections or points of SW initial code vulnerability are defined on the basis of automatic making and solving of according equation systems.

EFFECT: expansion of functional resources of DCC SW verification processes.

9 cl, 39 dwg, 26 tbl

FIELD: information technologies.

SUBSTANCE: invention is related to facilities of training and science research automation and may be used in interactive systems of research and development works automation in process of software (SW) verification in distributed computer complexes (DCC). Suggested method and system for its realisation provide complete manageability and observability of the main processes of SW initial code verification. At the same time at each level of DCC processes of SW initial code input and processing are combined along dependent or independent interface channels, on the basis of application of sensor or mechanical manipulators of computer operator workplace, network interfaces of local or global network Sections or points of SW initial code vulnerability are defined on the basis of SW initial code transformation into internal representation, which is stored in the form of databases and knowledge bases, and sections or points of SW initial code vulnerability are defined on the basis of automatic making and solving of according equation systems.

EFFECT: expansion of functional resources of DCC SW verification processes

9 cl, 40 dwg, 26 tbl

FIELD: information technologies.

SUBSTANCE: method includes receiving information entered in natural language and analysis of information entered in natural language to identify contained in it semantic information. For part of information entered in natural language, correspondence with "command" objects and "object" objects of scheme based on semantic information and entered in natural language information. The method also contains representation of data from data source in a table of columns and rows on the basis of scheme and corresponding parts of information which has been entered in natural language.

EFFECT: providing more effective interface for creation and representation of table with information from data source.

35 cl, 5 dwg

FIELD: information technologies.

SUBSTANCE: in invention it is automatically detected, which is the category of printed document, and unauthorised printing is prevented. In method printed document is analysed for availability of confidential information, system comprises user device, printing device, server of printing control service, converter unit, server of databases, file storage, unit of recognition, server of context analysis and alarm service.

EFFECT: provision of information safety, detection of document flows containing confidential information and requiring high extent of control.

2 cl

FIELD: information technology.

SUBSTANCE: method provides a preliminary presentation which automatically shows the intended outcome of applying one or another control to data. This is preferred when analysing electronic worksheet data by formatting certain data based on the control condition. The method involves identification of one or more data parametres subject to formatting based on the condition on display, selection of a predefined condition and automatic temporary application of that predefined condition to parametre(s), display of the temporary preliminary presentation on the display of the said predefined condition applied to data which correspond to the said predefined condition. The method also enables preliminary change of conditions and parametres applied to data, and automatically provide corresponding preliminary presentation of the effect of such application of the altered conditions with respect to displayed data.

EFFECT: faster formatting of displayed data.

27 cl, 28 dwg

Up!