US20060074879A1 - Easy-to-use data context filtering - Google Patents
Easy-to-use data context filtering Download PDFInfo
- Publication number
- US20060074879A1 US20060074879A1 US10/956,866 US95686604A US2006074879A1 US 20060074879 A1 US20060074879 A1 US 20060074879A1 US 95686604 A US95686604 A US 95686604A US 2006074879 A1 US2006074879 A1 US 2006074879A1
- Authority
- US
- United States
- Prior art keywords
- filter
- computer
- menu
- context
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Abandoned
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2428—Query predicate definition using graphical user interfaces, including menus and forms
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99931—Database or file accessing
- Y10S707/99933—Query processing, i.e. searching
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99931—Database or file accessing
- Y10S707/99933—Query processing, i.e. searching
- Y10S707/99934—Query formulation, input preparation, or translation
Definitions
- the present invention relates generally to the field of software applications. More particularly, the present invention relates to software applications that store and sort data, such as through data queries. More particularly still, aspects of the present invention relates to filtering of the data returned from query results.
- Typical spreadsheet and database applications comprise a large number of records of information, wherein each record comprises a predetermined number of fields.
- a database management system is typically used to provide the software tools to manipulate the database more simply.
- Example database management systems include Microsoft® Access, and Microsoft® SQL Server, among others. Databases generally allow users to establish complex data interrelationships that are not available in spreadsheets, which increases their power while also making database applications even more difficult for new users to master.
- a typical database management system provides the user the ability to add, modify or delete data, and the ability to query, sort, or recombine records in the database. Moreover, the usual system also provides functionality related to maintaining the security and integrity of the database data.
- Querying large quantities of data in a spreadsheet or database application can be a complex and daunting task, especially to new users. Determining how to specify a data query in a spreadsheet can also be difficult. Database applications can be especially difficult to use, since entire query languages are often used (such as Structured Query Language, or SQL) to enable more complex queries. The language of queries can be intimidating to new users, and thus a more user-friendly query interface is desirable.
- SQL Structured Query Language
- a computer-implemented method for graphical formulation of filter queries.
- a signal is received to filter a table.
- the context of a specified key field is analyzed, and a menu of filters based on that context is displayed.
- a filter selection is received, and the corresponding filter is created.
- the present invention relates to a system for easy-to-use data filtering.
- a menu module maintains a menu of filters.
- a receiving module receives filter signals and selections from the menu of filters.
- a filter module performs filtering.
- a display module displays the menu of filters and filter results, and a context analysis module analyzes the context of a particular table cell or column.
- the present invention relates to a method for the automated creation of filter queries.
- a data table is displayed.
- a signal to filter the table is received.
- the context of a specified column is analyzed, and a menu of filters is displayed based on that context.
- a filter selection is received, and a new filter is created and executed.
- the invention may be implemented as a computer process, a computing system or as an article of manufacture such as a computer program product or computer readable media.
- the computer readable media may be a computer storage media readable by a computer system and encoding a computer program of instructions for executing a computer process.
- the computer program readable media may also be a propagated signal on a carrier readable by a computing system and encoding a computer program of instructions for executing a computer process.
- FIG. 1 shows a database environment in which an embodiment of the present invention may be implemented.
- a tabular view contains unfiltered data. This tabular view of a database management system represents prior art.
- FIG. 2 illustrates an example of a suitable computing system environment on which an embodiment of the present invention may be implemented.
- FIG. 3 illustrates the operational flow of the operations performed in one embodiment of the present invention.
- FIG. 4 is a block diagram illustrating the modules that comprise one embodiment of the present invention.
- FIG. 5 illustrates an example screenshot where a signal to filter has been received, and a filter menu displayed. Unfiltered records may be seen in the background.
- FIG. 6 illustrates another example screenshot wherein a particular filter is being selected from a filter menu.
- FIG. 7 illustrates another example screenshot wherein the particular filter has been applied to the data, and the resulting filtered records can be seen.
- FIG. 1 illustrates a screenshot of a tabular view (also known as a table 102 ) of a product order database within a database management system.
- the table 102 includes a table comprised of multiple rows and columns of data. Each row of data generally comprises a single data record. Generally, each column of data in a database can be counted on to include data elements of a homogenous type. For example, the Order ID column 104 includes data elements in numeric format, the Customer column 106 includes data in the form of alphanumeric strings, the Order Date column 108 includes data in date format, and so on.
- the Order ID column 104 includes data elements in numeric format
- the Customer column 106 includes data in the form of alphanumeric strings
- the Order Date column 108 includes data in date format, and so on.
- One skilled in the art will appreciate that many other types of data can be kept in a database, and displayed using a table within a database management system.
- FIG. 2 is provided to illustrate an example of a suitable computing system environment on which embodiments of the invention may be implemented.
- system 200 includes at least one processing unit 202 and memory 204 .
- memory 204 may be volatile (such as RAM), non-volatile (such as ROM, flash memory, etc.) or some combination of the two.
- This most basic configuration is illustrated in FIG. 2 by dashed line 206 .
- the system may include at least one other form of computer-readable media.
- Computer-readable media can be any available media that can be accessed by the system 200 .
- Computer-readable media might comprise computer storage media and communication media.
- Computer storage media includes volatile and nonvolatile, removable and non-removable media implemented in any method or technology for storage of information such as computer readable instructions, data structures, program modules or other data.
- Memory 204 , removable storage 208 , and non-removable storage 210 are all examples of computer storage media.
- Computer storage media includes, but is not limited to, RAM, ROM, EPROM, EEPROM, flash memory or other memory technology, CD-ROM, digital versatile disks (DVD) or other optical storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other medium which can be used to store the desired information and which can accessed by system 200 . Any such computer storage media may be part of system 200 .
- System 200 may also contain a communications connection(s) 212 that allow the system to communicate with other devices.
- the communications connection(s) 212 is an example of communication media.
- Communication media typically embodies computer readable instructions, data structures, program modules or other data in a modulated data signal such as a carrier wave or other transport mechanism and includes any information delivery media.
- 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.
- communication media includes wired media such as a wired network or direct-wired connection, and wireless media such as acoustic, RF, infrared and other wireless media.
- the term computer readable media as used herein includes both storage media and communication media.
- the system 200 includes peripheral devices, such as input device(s) 214 and/or output device(s) 216 .
- Exemplary input devices 214 include, without limitation, keyboards, computer mice, pens, or styluses, voice input devices, tactile input devices and the like.
- Exemplary output device(s) 216 include, without limitation, devices such as displays, speakers, and printers.
- the display is a primary output device. Each of these devices is well know in the art and, therefore, not described in detail herein.
- FIG. 3 illustrates one embodiment of the invention in which a table is queried using context filtering.
- display table operation 302 displays a table (such as table 102 in FIG. 1 ).
- This table can include practically any type of data.
- Each column of data generally contains data of a single, homogenous data type, such as a series of dates, alphanumeric strings, or numbers.
- Receive operation 304 receives a signal to filter the table data when a user clicks on an appropriate graphical user interface (GUI) control sequence.
- GUI graphical user interface
- right-clicking the mouse on a particular column or column header causes a signal to be sent to receive operation 304 .
- left-clicking on a particular cell causes a signal to be sent to receive operation 304 .
- GUI controls or command sequences from an input device can be used to select data of a particular type.
- Examples include centering the mouse pointer on a given data element, column, or column header, accompanied by activating a certain mouse button.
- the keyboard could be used to make a selection.
- a combination of keyboard, mouse, trackball, or other input device actions could be used to select a data element, column, or column header.
- receive operation 304 may interpret the selection of a cell in a column as a signal to filter based on the entire column's contents. In an alternate embodiment, receive operation 304 may interpret the selection of a cell in a column as a signal to filter based specifically on the contents of that particular cell.
- the column the selection corresponds to becomes the “key field”, which is the column whose value will be used to decide whether each given row is filtered or not. For example, in order to omit from the query results, or “filter out”, all orders from table of product order data that were placed before 2004 , then the “order date” column must necessarily be a key field for such a query.
- filter options incorporating the value within the cell are possible (e.g., see example in FIGS. 5, 6 , and 7 , discussed later).
- data external to the data table can also be incorporated into a filter.
- filtering out orders in an order data table from “Today” requires external data (namely, today's date) to be retrieved and incorporated into the query, since the current date and time are always changing and thus not practical to store in a data table.
- analyze context operation 306 analyzes the selected data cell or column to determine what type of data it contains. Data filters appropriate to the determined type of data may then be added to a filter menu 502 (see FIG. 5 ).
- date-specific filter choices might include “Today,” which could be used to filter out all records that do not have a date matching today's date.
- “Yesterday” and “Tomorrow” are also date-specific filter choices that could be added to a filter menu by analyze context operation 304 .
- Other date-specific filter choices might include “This week”, “Last month”, “Last quarter”, “This year”, etc.
- Yet other date-specific filter choices might include “Newer than” the date contained in a cell if a particular cell is selected, “Older than” the date contained in a selected cell, or “Same month” as the date contained in a selected cell.
- the filter based on dates may involve an “All Dates in Period” filter.
- user options or choices for this type of filter might include “Quarter 1,” and/or “Quarter 2,” etc. to display all data associated with selected quarters, irrespective of the year.
- the choices may include months, such as “January,” “February,” “March,” etc. such that the user may choose these options to show only dates in the selected month period irrespective of the year value.
- common applications might then review and filter the first quarter sales over the last 5 years or all the birthdays in a given month for these examples, respectively.
- string-specific filters might include “Is,” which may filter out data records that do not match the string contained in a specified cell. Likewise, “is not” may filter out data records that do match the string contained in a specified cell. “Begins with” could be used to filter out records that do not contain a string beginning with a user-specified string, thus allowing for filtering by partially matching a given string. “Contains” may allow for a similar partial search, this type returning elements with strings that contain another given string. “Not blank” may filter out data records containing a blank string in a specified field.
- a list of values appearing in the column is presented to the user. Next to each value is a checkbox, or other control allowing for binary selection. Records containing values that do not match the selected (checked) values will be filtered out.
- number-specific filters enable filtering based on the content of numeric fields. For example, “Smallest 25” may filter out all but the records containing key fields representing the smallest 25 values in a key field. Such a filter may return more than 25 records if a column containing non-unique numbers exists, since SQL reports all numbers that “tie” for highest or lowest status when comparing numbers. For example, filtering out all records but those corresponding to the smallest 25 customer postal zip codes could still include a great many customer records, as many thousands of customers could reside in each postal zip code. As a further example, “Largest 100” would filter out all but the records containing key fields representing the largest 100 values in a key field.
- “Greater than average” would compute the average of a column of numbers, and then filter out records less than or equal to that average.
- “Less than average” would compute the average of a column of numbers, and then filter out records greater than or equal to that average.
- the user could specify two numbers using a “Between” filter, and records containing values not in the range formed by the two numbers would be filtered out.
- percentiles could be used to filter numeric values. For example, “Smallest 5 percent” or “Largest 25 percent” could be used to filter numbers based on their value relative to the other numbers in a table.
- a column containing cells with a very limited choice of values may cause analyze context operation 306 to add the actual values to a filter menu.
- a column that only allows “Yes” or “No” as possible values may cause analyze context operation 306 to add “Yes” and “No” filter options to a filter menu.
- analyze context operation 306 may determine that no additional filters need to be added to a filter menu.
- display operation 308 displays the menu of filters (for an example of a filter menu, see 602 in FIG. 6 ).
- the menu of filters displayed by display operation 308 may include default filters appropriate for all data types (such as “Equals”, discussed above).
- receive operation 310 receives a filter selection.
- this selection is made by hovering a mouse pointer over a given filter in a filter menu, and slicking a mouse button.
- any number of input device sequences could be use to select a filter from a filter menu without departing from the scope of the claimed invention.
- determine operation 312 determines whether a filter already exists for a selected table column. If a filter does already exist for a selected table column, flow branches YES to remove operation 314 . However, if no filter exists for a selected table column, flow branches NO to create operation 316 .
- two filters cannot be applied to the same table column, so if determine operation 312 determined that a filter already exists for a selected table column, then remove operation 314 is used to remove that filter to make way for a new one.
- create operation 316 next creates a new filter.
- This new filter includes a query encoded in a query language, such as SQL.
- multiple filters can be applied to the same table column, as long as those filters are not mutually exclusive.
- a filter query may be created that incorporates an SQL “where” qualifier.
- qualifier can also be used to find partial matches to query through the use of a regular expression, a search tool well known in the field. For example, a where query could be modified to query all records with a Country value starting with “L”. Likewise, specific ranges of numbers and/or dates can also be queried using the SQL where qualifier.
- a filter may incorporate an SQL “top” qualifier. This may be used to instruct a query to only return an arbitrary number of the top or bottom entries. For example, by adding Top (5) to a sales database query, only the top 5 sales figures will be returned for a given query instead of all sales. In the event of a tie, the exemplary sales database would return more than 5 records.
- top SQL qualifiers are provided as exemplary embodiments only, and other query qualifiers could be used in constructing a query without departing from the scope of the claimed invention. Further, some embodiments involve a spreadsheet, which may lack a query language, and instead perform queries directly upon the data.
- a filter query containing the appropriate SQL qualifiers is created, and stored in memory for further modification and/or later use.
- create operation 316 may also select a given filter on a filter menu by causing it to be highlighted whenever the filter menu is displayed.
- perform operation 318 performs filtering based on that filter.
- the query created by create operation 316 is issued to the database by the database management system in a query language.
- the filtering is performed directly by the application.
- the results may be stored in memory, or directed to display operation 320 (discussed below) for rendering.
- Display operation 320 renders the query results yielded by perform operation 318 on the screen.
- the results may be read from memory, piped directly to display operation 320 by perform operation 318 , or otherwise transmitted to display operation 320 for rendering.
- the results are rendered in place of the original, unfiltered table.
- the results may be rendered in an additional result table, which does not necessarily replace the original, unfiltered table.
- a “clear filters” control exists which enables the user to erase all filters currently in effect.
- the “clear filters” control may, additionally, reissue the current query with all filters turned off, and update the results on the screen accordingly.
- FIG. 4 is a block diagram illustrating the modules that comprise one embodiment of the present invention.
- An embodiment 400 may communicate with memory 420 when executing a query, performing a filter query, or receiving the results of the filter query.
- An embodiment 400 also communicates with a display device 430 in order to allow graphical selection of a cell, column, and filter, and to return results of a filter, among other things.
- a menu module 402 maintains the filter menu for a particular table column. This may include adding contextually appropriate filter options to a filter menu, removing contextually inappropriate filter options to a menu, and ordering filter options in a filter menu.
- a receive module 404 receives signals to filter records and filter selections from a filter menu. Input may be received from a GUI, via keyboard input or other input device, or by automated script or macro.
- a filter module 406 creates filters.
- filter module 406 also creates queries associated with the filters, and executes those queries.
- SQL is the predominant query language in the database field
- filter queries may be created in any query language including specialized versions of SQL such as HQL (Health Query Language), or query languages unrelated to SQL.
- Execution of a query may occur at the database management system level, or may be delegated to a lower-level program that accesses the database.
- Queries may be executed on the same system as the database management system is running, or sent out to one or more remote systems for execution. In the case of the latter, the remote system will return results, either directly or indirectly, to the database management system so that the results of the query may be displayed.
- Filters may also be applied directly to the data by a spreadsheet application, without the use of a query or a database management system.
- a display module 408 displays numerous aspects of the present invention.
- display module 408 may display a table in a spreadsheet or database management system. It may also display the menu of filters, discussed previously in conjunction with FIG. 3 . Further, it may display the results of a filter in the form of a table, or other suitable format.
- Display module 408 may interact with display device 430 to render an element that it is displaying.
- Context analysis module 410 analyzes the context of a particular cell or column in a data table. Appropriate (and inappropriate) filters may be derived using predetermined criteria (see discussion of analyze context operation 306 in conjunction with FIG. 3 ) or other criteria.
- FIG. 5 illustrates an example screenshot where a signal to filter has been received (not shown), and a filter menu 502 displayed. Unfiltered records 504 may be seen in the background, as a filter has not yet been selected from the filter menu 502 .
- the filter menu 502 was displayed when the user clicked on first a cell (not shown) in the Order Date column 506 (thus selecting Order Date as a key field upon which the subsequent filtering will take place), and then on Common Filters menu item 508 , although one skilled in the art will appreciate that this functionality could just as easily have been triggered by on a different cell or column and/or with a different menu item, button, mouse or keyboard sequence, or selection of a toolbar element without departing from the scope of the claimed invention.
- FIG. 6 illustrates another example screenshot wherein a particular filter 602 is being selected from a filter menu 604 .
- the particular filter 602 was selected by hovering a mouse pointer over it and left-clicking, although skilled in the art will appreciate that this selection could also made using other sequences and other input devices without departing from the scope of the claimed invention.
- FIG. 7 illustrates another example screenshot wherein the particular filter (not shown; see 602 in conjunction with FIG. 6 ) has been applied to the unfiltered data (not shown; see 102 in conjunction with FIG. 1 ), and the resulting filtered data 702 can be seen.
- the order date column 704 is shaded to draw attention to the fact that the filtered data 702 contains only records with an Order Date key field value in the month of May.
Abstract
Description
- The present invention relates generally to the field of software applications. More particularly, the present invention relates to software applications that store and sort data, such as through data queries. More particularly still, aspects of the present invention relates to filtering of the data returned from query results.
- In order to manage large quantities of data, computer software applications, such as spreadsheet and database applications have been developed to organize and store the data in a logical manner. Typical spreadsheet and database applications comprise a large number of records of information, wherein each record comprises a predetermined number of fields. In the context of a database, a database management system is typically used to provide the software tools to manipulate the database more simply. Example database management systems include Microsoft® Access, and Microsoft® SQL Server, among others. Databases generally allow users to establish complex data interrelationships that are not available in spreadsheets, which increases their power while also making database applications even more difficult for new users to master.
- A typical database management system provides the user the ability to add, modify or delete data, and the ability to query, sort, or recombine records in the database. Moreover, the usual system also provides functionality related to maintaining the security and integrity of the database data.
- Querying large quantities of data in a spreadsheet or database application can be a complex and daunting task, especially to new users. Determining how to specify a data query in a spreadsheet can also be difficult. Database applications can be especially difficult to use, since entire query languages are often used (such as Structured Query Language, or SQL) to enable more complex queries. The language of queries can be intimidating to new users, and thus a more user-friendly query interface is desirable.
- It is with respect to these considerations and others that the present invention has been made.
- In accordance with the present invention, a computer-implemented method is provided for graphical formulation of filter queries. A signal is received to filter a table. Next, the context of a specified key field is analyzed, and a menu of filters based on that context is displayed. A filter selection is received, and the corresponding filter is created.
- In accordance with other aspects, the present invention relates to a system for easy-to-use data filtering. A menu module maintains a menu of filters. A receiving module receives filter signals and selections from the menu of filters. A filter module performs filtering. A display module displays the menu of filters and filter results, and a context analysis module analyzes the context of a particular table cell or column.
- In accordance with yet other aspects, the present invention relates to a method for the automated creation of filter queries. A data table is displayed. A signal to filter the table is received. The context of a specified column is analyzed, and a menu of filters is displayed based on that context. A filter selection is received, and a new filter is created and executed. The invention may be implemented as a computer process, a computing system or as an article of manufacture such as a computer program product or computer readable media. The computer readable media may be a computer storage media readable by a computer system and encoding a computer program of instructions for executing a computer process. The computer program readable media may also be a propagated signal on a carrier readable by a computing system and encoding a computer program of instructions for executing a computer process.
- These and various other features as well as advantages, which characterize the present invention, will be apparent from a reading of the following detailed description and a review of the associated drawings.
-
FIG. 1 shows a database environment in which an embodiment of the present invention may be implemented. A tabular view contains unfiltered data. This tabular view of a database management system represents prior art. -
FIG. 2 illustrates an example of a suitable computing system environment on which an embodiment of the present invention may be implemented. -
FIG. 3 illustrates the operational flow of the operations performed in one embodiment of the present invention. -
FIG. 4 is a block diagram illustrating the modules that comprise one embodiment of the present invention. -
FIG. 5 illustrates an example screenshot where a signal to filter has been received, and a filter menu displayed. Unfiltered records may be seen in the background. -
FIG. 6 illustrates another example screenshot wherein a particular filter is being selected from a filter menu. -
FIG. 7 illustrates another example screenshot wherein the particular filter has been applied to the data, and the resulting filtered records can be seen. -
FIG. 1 illustrates a screenshot of a tabular view (also known as a table 102) of a product order database within a database management system. The table 102 includes a table comprised of multiple rows and columns of data. Each row of data generally comprises a single data record. Generally, each column of data in a database can be counted on to include data elements of a homogenous type. For example, theOrder ID column 104 includes data elements in numeric format, theCustomer column 106 includes data in the form of alphanumeric strings, theOrder Date column 108 includes data in date format, and so on. One skilled in the art will appreciate that many other types of data can be kept in a database, and displayed using a table within a database management system. - Despite the deceptively simple visual presentation of data in
FIG. 1 , up until now users still have had to manually formulate queries in a suitably structured query language, generally by designing and typing in query commands. So while database management systems may offer a straightforward view of data, formulating effective queries has remained a difficult skill to learn for spreadsheet users new to the world of databases. By allowing “canned” (manufactured in advance) queries to filter data, and allowing a simple query interface, the present invention allows database and spreadsheet products to be more accessible than ever before to new users - Given that the present invention may be implemented as a computer system,
FIG. 2 is provided to illustrate an example of a suitable computing system environment on which embodiments of the invention may be implemented. In its most basic configuration,system 200 includes at least oneprocessing unit 202 andmemory 204. Depending on the exact configuration and type of computing device,memory 204 may be volatile (such as RAM), non-volatile (such as ROM, flash memory, etc.) or some combination of the two. This most basic configuration is illustrated inFIG. 2 bydashed line 206. - In addition to the
memory 204, the system may include at least one other form of computer-readable media. Computer-readable media can be any available media that can be accessed by thesystem 200. By way of example, and not limitation, computer-readable media might comprise computer storage media and communication media. - Computer storage media includes volatile and nonvolatile, removable and non-removable media implemented in any method or technology for storage of information such as computer readable instructions, data structures, program modules or other data.
Memory 204,removable storage 208, andnon-removable storage 210 are all examples of computer storage media. Computer storage media includes, but is not limited to, RAM, ROM, EPROM, EEPROM, flash memory or other memory technology, CD-ROM, digital versatile disks (DVD) or other optical storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other medium which can be used to store the desired information and which can accessed bysystem 200. Any such computer storage media may be part ofsystem 200. -
System 200 may also contain a communications connection(s) 212 that allow the system to communicate with other devices. The communications connection(s) 212 is an example of communication media. Communication media typically embodies computer readable instructions, data structures, program modules or other data in a modulated data signal such as a carrier wave or other transport mechanism and includes any information delivery media. 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. By way of example, and not limitation, communication media includes wired media such as a wired network or direct-wired connection, and wireless media such as acoustic, RF, infrared and other wireless media. The term computer readable media as used herein includes both storage media and communication media. - In accordance with an embodiment, the
system 200 includes peripheral devices, such as input device(s) 214 and/or output device(s) 216.Exemplary input devices 214 include, without limitation, keyboards, computer mice, pens, or styluses, voice input devices, tactile input devices and the like. Exemplary output device(s) 216 include, without limitation, devices such as displays, speakers, and printers. For the purposes of this invention, the display is a primary output device. Each of these devices is well know in the art and, therefore, not described in detail herein. -
FIG. 3 illustrates one embodiment of the invention in which a table is queried using context filtering. In one embodiment of the present invention,display table operation 302 displays a table (such as table 102 inFIG. 1 ). This table can include practically any type of data. Each column of data generally contains data of a single, homogenous data type, such as a series of dates, alphanumeric strings, or numbers. - Receive
operation 304 receives a signal to filter the table data when a user clicks on an appropriate graphical user interface (GUI) control sequence. In one embodiment of the present invention, right-clicking the mouse on a particular column or column header (that column designating the “key field,” described below) causes a signal to be sent to receiveoperation 304. In an alternate embodiment of the present invention, left-clicking on a particular cell (the column the cell falls within then becoming the key field) in the table causes a signal to be sent to receiveoperation 304. One skilled in the art will appreciate that any number of possible GUI controls or command sequences from an input device can be used to select data of a particular type. Examples include centering the mouse pointer on a given data element, column, or column header, accompanied by activating a certain mouse button. Alternatively, the keyboard could be used to make a selection. Alternatively still, a combination of keyboard, mouse, trackball, or other input device actions could be used to select a data element, column, or column header. - In one embodiment, receive
operation 304 may interpret the selection of a cell in a column as a signal to filter based on the entire column's contents. In an alternate embodiment, receiveoperation 304 may interpret the selection of a cell in a column as a signal to filter based specifically on the contents of that particular cell. The column the selection corresponds to becomes the “key field”, which is the column whose value will be used to decide whether each given row is filtered or not. For example, in order to omit from the query results, or “filter out”, all orders from table of product order data that were placed before 2004, then the “order date” column must necessarily be a key field for such a query. - When a particular cell is selected (versus an entire column), filter options incorporating the value within the cell are possible (e.g., see example in
FIGS. 5, 6 , and 7, discussed later). - With respect to an alternative embodiment, data external to the data table can also be incorporated into a filter. For example, filtering out orders in an order data table from “Today” requires external data (namely, today's date) to be retrieved and incorporated into the query, since the current date and time are always changing and thus not practical to store in a data table.
- After receive
operation 304 receives a signal to filter, analyzecontext operation 306 analyzes the selected data cell or column to determine what type of data it contains. Data filters appropriate to the determined type of data may then be added to a filter menu 502 (seeFIG. 5 ). - For example, if the data type is determined to be a date, one or more filters appropriate to dates will be added to the filter menu (see 502,
FIG. 5 for an exemplary filter menu). Such date-specific filter choices might include “Today,” which could be used to filter out all records that do not have a date matching today's date. Similarly, “Yesterday” and “Tomorrow” are also date-specific filter choices that could be added to a filter menu by analyzecontext operation 304. Other date-specific filter choices might include “This week”, “Last month”, “Last quarter”, “This year”, etc. Yet other date-specific filter choices might include “Newer than” the date contained in a cell if a particular cell is selected, “Older than” the date contained in a selected cell, or “Same month” as the date contained in a selected cell. - In yet another embodiment, the filter based on dates may involve an “All Dates in Period” filter. For example, user options or choices for this type of filter might include “
Quarter 1,” and/or “Quarter 2,” etc. to display all data associated with selected quarters, irrespective of the year. In yet another example, the choices may include months, such as “January,” “February,” “March,” etc. such that the user may choose these options to show only dates in the selected month period irrespective of the year value. As such, common applications might then review and filter the first quarter sales over the last 5 years or all the birthdays in a given month for these examples, respectively. - In a given embodiment, other type-specific filters may exist for other data types. For example, string-specific filters might include “Is,” which may filter out data records that do not match the string contained in a specified cell. Likewise, “is not” may filter out data records that do match the string contained in a specified cell. “Begins with” could be used to filter out records that do not contain a string beginning with a user-specified string, thus allowing for filtering by partially matching a given string. “Contains” may allow for a similar partial search, this type returning elements with strings that contain another given string. “Not blank” may filter out data records containing a blank string in a specified field.
- In an alternate embodiment, a list of values appearing in the column is presented to the user. Next to each value is a checkbox, or other control allowing for binary selection. Records containing values that do not match the selected (checked) values will be filtered out.
- In another embodiment, number-specific filters enable filtering based on the content of numeric fields. For example, “
Smallest 25” may filter out all but the records containing key fields representing the smallest 25 values in a key field. Such a filter may return more than 25 records if a column containing non-unique numbers exists, since SQL reports all numbers that “tie” for highest or lowest status when comparing numbers. For example, filtering out all records but those corresponding to the smallest 25 customer postal zip codes could still include a great many customer records, as many thousands of customers could reside in each postal zip code. As a further example, “Largest 100” would filter out all but the records containing key fields representing the largest 100 values in a key field. “Greater than average” would compute the average of a column of numbers, and then filter out records less than or equal to that average. Similarly, “Less than average” would compute the average of a column of numbers, and then filter out records greater than or equal to that average. In another embodiment, the user could specify two numbers using a “Between” filter, and records containing values not in the range formed by the two numbers would be filtered out. - In yet another embodiment, percentiles could be used to filter numeric values. For example, “Smallest 5 percent” or “Largest 25 percent” could be used to filter numbers based on their value relative to the other numbers in a table.
- In one particular embodiment of the present invention, a column containing cells with a very limited choice of values may cause analyze
context operation 306 to add the actual values to a filter menu. For example, a column that only allows “Yes” or “No” as possible values may cause analyzecontext operation 306 to add “Yes” and “No” filter options to a filter menu. - One skilled in the art will appreciate that some filters may be appropriate to multiple data types. For example, “Equals” may be used to filter out all data records that are not equal to the contents of a selected cell. “Equals” may also be used to find a matching date, number, alphanumeric string, boolean value, etc.
- In one embodiment of the present invention, analyze
context operation 306 may determine that no additional filters need to be added to a filter menu. - After analyze
context operation 306 adds any appropriate filters to a filter menu,display operation 308 displays the menu of filters (for an example of a filter menu, see 602 inFIG. 6 ). The menu of filters displayed bydisplay operation 308 may include default filters appropriate for all data types (such as “Equals”, discussed above). - Once a filter menu has been displayed, receive
operation 310 receives a filter selection. In one embodiment, this selection is made by hovering a mouse pointer over a given filter in a filter menu, and slicking a mouse button. However, one skilled in the art will appreciate that any number of input device sequences could be use to select a filter from a filter menu without departing from the scope of the claimed invention. - After a filter selection has been received, determine
operation 312 determines whether a filter already exists for a selected table column. If a filter does already exist for a selected table column, flow branches YES to removeoperation 314. However, if no filter exists for a selected table column, flow branches NO to createoperation 316. - In an embodiment of the current invention, two filters cannot be applied to the same table column, so if determine
operation 312 determined that a filter already exists for a selected table column, then removeoperation 314 is used to remove that filter to make way for a new one. - If no filter existed for the specified table column, or if a filter did exist and was removed by
remove operation 314, createoperation 316 next creates a new filter. This new filter includes a query encoded in a query language, such as SQL. - In an alternative embodiment of the present invention, multiple filters can be applied to the same table column, as long as those filters are not mutually exclusive.
- In an embodiment involving a database, a filter query may be created that incorporates an SQL “where” qualifier. A where qualifier, when added to an SQL query, may be used to conduct a search or narrow down the results of a query. For example, appending “where Country=Lithuania” to the end of an SQL query will cause the query to return only results whose Country column value is equal to “Lithuania”. Likewise, appending “where OrderID=41475” to an SQL query will cause the query to return only results whose OrderID is equal to 41475. In this way, the where qualifier can be used to return arbitrarily wide or narrow lists of records that match the query.
- One skilled in the art will appreciate that, in addition to locating full matches, the where qualifier can also be used to find partial matches to query through the use of a regular expression, a search tool well known in the field. For example, a where query could be modified to query all records with a Country value starting with “L”. Likewise, specific ranges of numbers and/or dates can also be queried using the SQL where qualifier.
- In another embodiment, a filter may incorporate an SQL “top” qualifier. This may be used to instruct a query to only return an arbitrary number of the top or bottom entries. For example, by adding Top (5) to a sales database query, only the top 5 sales figures will be returned for a given query instead of all sales. In the event of a tie, the exemplary sales database would return more than 5 records.
- One skilled in the art will appreciate that the where and top SQL qualifiers are provided as exemplary embodiments only, and other query qualifiers could be used in constructing a query without departing from the scope of the claimed invention. Further, some embodiments involve a spreadsheet, which may lack a query language, and instead perform queries directly upon the data.
- In one embodiment involving a database, a filter query containing the appropriate SQL qualifiers is created, and stored in memory for further modification and/or later use.
- In one embodiment of the present invention, create
operation 316 may also select a given filter on a filter menu by causing it to be highlighted whenever the filter menu is displayed. - After a filter is created, perform
operation 318 performs filtering based on that filter. In a database embodiment, the query created by createoperation 316 is issued to the database by the database management system in a query language. In another embodiment, the filtering is performed directly by the application. The results may be stored in memory, or directed to display operation 320 (discussed below) for rendering. -
Display operation 320 renders the query results yielded byperform operation 318 on the screen. The results may be read from memory, piped directly todisplay operation 320 byperform operation 318, or otherwise transmitted to displayoperation 320 for rendering. The results are rendered in place of the original, unfiltered table. - In an alternate embodiment of the present invention, the results may be rendered in an additional result table, which does not necessarily replace the original, unfiltered table.
- In a particular embodiment of the present invention, a “clear filters” control exists which enables the user to erase all filters currently in effect. Optionally, the “clear filters” control may, additionally, reissue the current query with all filters turned off, and update the results on the screen accordingly.
-
FIG. 4 is a block diagram illustrating the modules that comprise one embodiment of the present invention. Anembodiment 400 may communicate withmemory 420 when executing a query, performing a filter query, or receiving the results of the filter query. Anembodiment 400 also communicates with adisplay device 430 in order to allow graphical selection of a cell, column, and filter, and to return results of a filter, among other things. - A
menu module 402 maintains the filter menu for a particular table column. This may include adding contextually appropriate filter options to a filter menu, removing contextually inappropriate filter options to a menu, and ordering filter options in a filter menu. - A receive
module 404 receives signals to filter records and filter selections from a filter menu. Input may be received from a GUI, via keyboard input or other input device, or by automated script or macro. - A
filter module 406 creates filters. In an embodiment involving a database,filter module 406 also creates queries associated with the filters, and executes those queries. While SQL is the predominant query language in the database field, filter queries may be created in any query language including specialized versions of SQL such as HQL (Health Query Language), or query languages unrelated to SQL. Execution of a query may occur at the database management system level, or may be delegated to a lower-level program that accesses the database. Queries may be executed on the same system as the database management system is running, or sent out to one or more remote systems for execution. In the case of the latter, the remote system will return results, either directly or indirectly, to the database management system so that the results of the query may be displayed. Filters may also be applied directly to the data by a spreadsheet application, without the use of a query or a database management system. - A display module 408 displays numerous aspects of the present invention. For example, display module 408 may display a table in a spreadsheet or database management system. It may also display the menu of filters, discussed previously in conjunction with
FIG. 3 . Further, it may display the results of a filter in the form of a table, or other suitable format. Display module 408 may interact withdisplay device 430 to render an element that it is displaying. -
Context analysis module 410 analyzes the context of a particular cell or column in a data table. Appropriate (and inappropriate) filters may be derived using predetermined criteria (see discussion of analyzecontext operation 306 in conjunction withFIG. 3 ) or other criteria. -
FIG. 5 illustrates an example screenshot where a signal to filter has been received (not shown), and afilter menu 502 displayed.Unfiltered records 504 may be seen in the background, as a filter has not yet been selected from thefilter menu 502. In the exemplary screenshot, thefilter menu 502 was displayed when the user clicked on first a cell (not shown) in the Order Date column 506 (thus selecting Order Date as a key field upon which the subsequent filtering will take place), and then on CommonFilters menu item 508, although one skilled in the art will appreciate that this functionality could just as easily have been triggered by on a different cell or column and/or with a different menu item, button, mouse or keyboard sequence, or selection of a toolbar element without departing from the scope of the claimed invention. -
FIG. 6 illustrates another example screenshot wherein aparticular filter 602 is being selected from afilter menu 604. In the exemplary screenshot, theparticular filter 602 was selected by hovering a mouse pointer over it and left-clicking, although skilled in the art will appreciate that this selection could also made using other sequences and other input devices without departing from the scope of the claimed invention. -
FIG. 7 illustrates another example screenshot wherein the particular filter (not shown; see 602 in conjunction withFIG. 6 ) has been applied to the unfiltered data (not shown; see 102 in conjunction withFIG. 1 ), and the resulting filtereddata 702 can be seen. Theorder date column 704 is shaded to draw attention to the fact that the filtereddata 702 contains only records with an Order Date key field value in the month of May. - One skilled in the art will appreciate that while the exemplary embodiments deal with only one filter for the sake of simplicity, multiple filters applied to multiple columns may be in effect simultaneously, thus allowing interaction of filters to more precisely focus a filter query. One skilled in the art will likewise appreciate that while exemplary embodiments were presented in the contexts of a spreadsheet, and a database application, the invention could be used in any context where specific data must be selected from a dataset. Further, the resulting specific data need not be displayed. It could instead be saved to memory, sent to a printer, emailed, or otherwise directed without departing from the scope of the claimed invention.
- The various embodiments described above are provided by way of illustration only and should not be construed to limit the invention. Those skilled in the art will readily recognize various modifications and changes that may be made to the present invention without following the example embodiments and applications illustrated and described herein, and without departing from the true spirit and scope of the present invention, which is set forth in the following claims.
Claims (22)
Priority Applications (6)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US10/956,866 US20060074879A1 (en) | 2004-09-30 | 2004-09-30 | Easy-to-use data context filtering |
EP05105142A EP1643386A3 (en) | 2004-09-30 | 2005-06-13 | Easy-to-use data context filtering |
JP2005175171A JP2006107431A (en) | 2004-09-30 | 2005-06-15 | Easy-to-use data context filtering |
KR1020050057767A KR20060048768A (en) | 2004-09-30 | 2005-06-30 | Easy-to-use data context filtering |
CNB2005100885152A CN100492359C (en) | 2004-09-30 | 2005-07-29 | Easy-to-use data context filtering |
US11/316,090 US7519585B2 (en) | 2004-09-30 | 2005-12-19 | Selection context filtering |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US10/956,866 US20060074879A1 (en) | 2004-09-30 | 2004-09-30 | Easy-to-use data context filtering |
Related Child Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US11/316,090 Continuation-In-Part US7519585B2 (en) | 2004-09-30 | 2005-12-19 | Selection context filtering |
Publications (1)
Publication Number | Publication Date |
---|---|
US20060074879A1 true US20060074879A1 (en) | 2006-04-06 |
Family
ID=35457392
Family Applications (2)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US10/956,866 Abandoned US20060074879A1 (en) | 2004-09-30 | 2004-09-30 | Easy-to-use data context filtering |
US11/316,090 Expired - Fee Related US7519585B2 (en) | 2004-09-30 | 2005-12-19 | Selection context filtering |
Family Applications After (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US11/316,090 Expired - Fee Related US7519585B2 (en) | 2004-09-30 | 2005-12-19 | Selection context filtering |
Country Status (5)
Country | Link |
---|---|
US (2) | US20060074879A1 (en) |
EP (1) | EP1643386A3 (en) |
JP (1) | JP2006107431A (en) |
KR (1) | KR20060048768A (en) |
CN (1) | CN100492359C (en) |
Cited By (16)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20070061298A1 (en) * | 2005-09-14 | 2007-03-15 | Wilson Jeff K | Method and apparatus for adding a search filter for web pages based on page type |
US20070282856A1 (en) * | 2006-04-28 | 2007-12-06 | Bmc Software, Inc. | Database Application Federation |
US20080005210A1 (en) * | 2006-06-30 | 2008-01-03 | Microsoft Corporation | Interval generation for numeric data |
US20080033471A1 (en) * | 2004-06-23 | 2008-02-07 | Bioprotect Ltd. | Device System And Method For Tissue Displacement Or Separation |
US20090319957A1 (en) * | 2006-01-30 | 2009-12-24 | Mainstream Computing Pty Ltd | Selection system |
US20100023127A1 (en) * | 2007-03-15 | 2010-01-28 | Ortho-Space Ltd. | Prosthetic devices and methods for using same |
US20100137999A1 (en) * | 2007-03-15 | 2010-06-03 | Bioprotect Led. | Soft tissue fixation devices |
US20130176315A1 (en) * | 2012-01-06 | 2013-07-11 | Heather L. Winkle | Analytical Charting |
US8635530B2 (en) | 2011-02-09 | 2014-01-21 | International Business Machines Corporation | Statistical filtering of data using graphical user interfaces in information technology systems |
US20140108902A1 (en) * | 2012-10-15 | 2014-04-17 | International Business Machines Corporation | Data filtering based on a cell entry |
US20140310649A1 (en) * | 2013-04-11 | 2014-10-16 | Apple Inc. | Pop-up menu interface |
US9235328B1 (en) * | 2014-09-23 | 2016-01-12 | Allscripts Software, Llc | Big data selector system and method |
US10156961B1 (en) * | 2013-09-24 | 2018-12-18 | EMC IP Holding Company LLC | Dynamically building a visualization filter |
US10331643B2 (en) * | 2012-09-25 | 2019-06-25 | Open Text Corporation | Generating context tree data based on a tailored data model |
US11238108B1 (en) * | 2020-07-28 | 2022-02-01 | Grey Wall Software Llc | Custom data filtering systems and methods |
US20220067811A1 (en) * | 2020-08-31 | 2022-03-03 | Coupang Corp. | Systems and methods for visual navigation during online shopping using intelligent filter sequencing |
Families Citing this family (16)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7970796B1 (en) * | 2006-12-01 | 2011-06-28 | Intuit Inc. | Method and system for importing data to a repository |
US8818987B2 (en) * | 2008-01-11 | 2014-08-26 | International Business Machines Corporation | Converting union commands to union all commands |
US20090228826A1 (en) * | 2008-03-04 | 2009-09-10 | Microsoft Corporation | Group filtering of items in a view |
US9081837B2 (en) * | 2010-10-28 | 2015-07-14 | Microsoft Technology Licensing, Llc | Scoped database connections |
KR101872748B1 (en) * | 2011-01-14 | 2018-06-29 | 아브 이니티오 테크놀로지 엘엘시 | Managing changes to collections of data |
US10366350B2 (en) | 2011-04-28 | 2019-07-30 | Oracle International Corporation | Enterprise compensation application supporting a large number of employees |
US9411797B2 (en) | 2011-10-31 | 2016-08-09 | Microsoft Technology Licensing, Llc | Slicer elements for filtering tabular data |
US20130145244A1 (en) * | 2011-12-05 | 2013-06-06 | Microsoft Corporation | Quick analysis tool for spreadsheet application programs |
US10311062B2 (en) * | 2012-08-21 | 2019-06-04 | Microsoft Technology Licensing, Llc | Filtering structured data using inexact, culture-dependent terms |
WO2014145610A1 (en) * | 2013-03-15 | 2014-09-18 | Vigor Systems Inc. | Methods and systems to display data records extracted from a database via a graphical user interface |
US9984114B2 (en) * | 2014-06-02 | 2018-05-29 | Microsoft Technology Licensing, Llc | Filtering data in an enterprise system |
US11042591B2 (en) | 2015-06-23 | 2021-06-22 | Splunk Inc. | Analytical search engine |
US10866994B2 (en) | 2015-06-23 | 2020-12-15 | Splunk Inc. | Systems and methods for instant crawling, curation of data sources, and enabling ad-hoc search |
CN107169076B (en) * | 2017-05-10 | 2020-06-05 | 北京京东尚科信息技术有限公司 | Method, system and computer readable storage medium for two-dimensional data cleansing |
KR101977101B1 (en) * | 2018-02-02 | 2019-06-19 | 주식회사 한글과컴퓨터 | Spreadsheet driving apparatus for providing a filtering function capable of setting search conditions and operating method thereof |
CN112434058B (en) * | 2020-11-24 | 2024-03-15 | 武汉虹信技术服务有限责任公司 | Java and MySQL-based data interaction method and computer readable medium |
Citations (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5701453A (en) * | 1993-07-01 | 1997-12-23 | Informix Software, Inc. | Logical schema to allow access to a relational database without using knowledge of the database structure |
US5963938A (en) * | 1996-05-17 | 1999-10-05 | Novell Inc. | Automatic, context-organizing, query interface |
US6122627A (en) * | 1997-05-09 | 2000-09-19 | International Business Machines Corporation | System, method, and program for object building in queries over object views |
US6473751B1 (en) * | 1999-12-10 | 2002-10-29 | Koninklijke Philips Electronics N.V. | Method and apparatus for defining search queries and user profiles and viewing search results |
US6484164B1 (en) * | 2000-03-29 | 2002-11-19 | Koninklijke Philips Electronics N.V. | Data search user interface with ergonomic mechanism for user profile definition and manipulation |
US6499029B1 (en) * | 2000-03-29 | 2002-12-24 | Koninklijke Philips Electronics N.V. | User interface providing automatic organization and filtering of search criteria |
US6505194B1 (en) * | 2000-03-29 | 2003-01-07 | Koninklijke Philips Electronics N.V. | Search user interface with enhanced accessibility and ease-of-use features based on visual metaphors |
US6662177B1 (en) * | 2000-03-29 | 2003-12-09 | Koninklijke Philips Electronics N.V. | Search user interface providing mechanism for manipulation of explicit and implicit criteria |
US6785668B1 (en) * | 2000-11-28 | 2004-08-31 | Sas Institute Inc. | System and method for data flow analysis of complex data filters |
Family Cites Families (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5787411A (en) * | 1996-03-20 | 1998-07-28 | Microsoft Corporation | Method and apparatus for database filter generation by display selection |
US6279016B1 (en) | 1997-09-21 | 2001-08-21 | Microsoft Corporation | Standardized filtering control techniques |
US7162471B1 (en) * | 1999-05-11 | 2007-01-09 | Maquis Techtrix Llc | Content query system and method |
US20020055981A1 (en) | 2000-08-31 | 2002-05-09 | Frederic Spaey | System and method for remotely browsing structured data |
JP2002366559A (en) * | 2001-06-05 | 2002-12-20 | Ricoh Co Ltd | Device and method for sorting document |
US20030065650A1 (en) * | 2001-10-03 | 2003-04-03 | Annand Ritchie I. | Method and query application tool for searching hierarchical databases |
CA2398103A1 (en) | 2002-08-14 | 2004-02-14 | March Networks Corporation | Multi-dimensional table filtering system |
US7441186B2 (en) * | 2004-01-23 | 2008-10-21 | Microsoft Corporation | System and method for automatically grouping items |
-
2004
- 2004-09-30 US US10/956,866 patent/US20060074879A1/en not_active Abandoned
-
2005
- 2005-06-13 EP EP05105142A patent/EP1643386A3/en not_active Withdrawn
- 2005-06-15 JP JP2005175171A patent/JP2006107431A/en active Pending
- 2005-06-30 KR KR1020050057767A patent/KR20060048768A/en not_active Application Discontinuation
- 2005-07-29 CN CNB2005100885152A patent/CN100492359C/en not_active Expired - Fee Related
- 2005-12-19 US US11/316,090 patent/US7519585B2/en not_active Expired - Fee Related
Patent Citations (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5701453A (en) * | 1993-07-01 | 1997-12-23 | Informix Software, Inc. | Logical schema to allow access to a relational database without using knowledge of the database structure |
US5963938A (en) * | 1996-05-17 | 1999-10-05 | Novell Inc. | Automatic, context-organizing, query interface |
US6122627A (en) * | 1997-05-09 | 2000-09-19 | International Business Machines Corporation | System, method, and program for object building in queries over object views |
US6473751B1 (en) * | 1999-12-10 | 2002-10-29 | Koninklijke Philips Electronics N.V. | Method and apparatus for defining search queries and user profiles and viewing search results |
US6484164B1 (en) * | 2000-03-29 | 2002-11-19 | Koninklijke Philips Electronics N.V. | Data search user interface with ergonomic mechanism for user profile definition and manipulation |
US6499029B1 (en) * | 2000-03-29 | 2002-12-24 | Koninklijke Philips Electronics N.V. | User interface providing automatic organization and filtering of search criteria |
US6505194B1 (en) * | 2000-03-29 | 2003-01-07 | Koninklijke Philips Electronics N.V. | Search user interface with enhanced accessibility and ease-of-use features based on visual metaphors |
US6662177B1 (en) * | 2000-03-29 | 2003-12-09 | Koninklijke Philips Electronics N.V. | Search user interface providing mechanism for manipulation of explicit and implicit criteria |
US6785668B1 (en) * | 2000-11-28 | 2004-08-31 | Sas Institute Inc. | System and method for data flow analysis of complex data filters |
Cited By (30)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20080033471A1 (en) * | 2004-06-23 | 2008-02-07 | Bioprotect Ltd. | Device System And Method For Tissue Displacement Or Separation |
US20070061298A1 (en) * | 2005-09-14 | 2007-03-15 | Wilson Jeff K | Method and apparatus for adding a search filter for web pages based on page type |
US20090319957A1 (en) * | 2006-01-30 | 2009-12-24 | Mainstream Computing Pty Ltd | Selection system |
US9122719B2 (en) * | 2006-04-28 | 2015-09-01 | Bmc Software, Inc. | Database application federation |
US20070282856A1 (en) * | 2006-04-28 | 2007-12-06 | Bmc Software, Inc. | Database Application Federation |
US20080005210A1 (en) * | 2006-06-30 | 2008-01-03 | Microsoft Corporation | Interval generation for numeric data |
US7937426B2 (en) | 2006-06-30 | 2011-05-03 | Mircosoft Corporation | Interval generation for numeric data |
US20100023127A1 (en) * | 2007-03-15 | 2010-01-28 | Ortho-Space Ltd. | Prosthetic devices and methods for using same |
US20100137999A1 (en) * | 2007-03-15 | 2010-06-03 | Bioprotect Led. | Soft tissue fixation devices |
US11033398B2 (en) | 2007-03-15 | 2021-06-15 | Ortho-Space Ltd. | Shoulder implant for simulating a bursa |
US8635530B2 (en) | 2011-02-09 | 2014-01-21 | International Business Machines Corporation | Statistical filtering of data using graphical user interfaces in information technology systems |
US20130176315A1 (en) * | 2012-01-06 | 2013-07-11 | Heather L. Winkle | Analytical Charting |
US10192331B2 (en) | 2012-01-06 | 2019-01-29 | Apple Inc. | Analytical charting |
US9224217B2 (en) * | 2012-01-06 | 2015-12-29 | Apple Inc. | Analytical charting |
US11567918B2 (en) | 2012-09-25 | 2023-01-31 | Open Text Corporation | Generating context tree data based on a tailored data model |
US10331643B2 (en) * | 2012-09-25 | 2019-06-25 | Open Text Corporation | Generating context tree data based on a tailored data model |
US10354003B2 (en) * | 2012-10-15 | 2019-07-16 | International Business Machines Corporation | Data filtering based on a cell entry |
US20160170954A1 (en) * | 2012-10-15 | 2016-06-16 | International Business Machines Corporation | Data filtering based on a cell entry |
US20140108902A1 (en) * | 2012-10-15 | 2014-04-17 | International Business Machines Corporation | Data filtering based on a cell entry |
US10460027B2 (en) * | 2012-10-15 | 2019-10-29 | International Business Machines Corporation | Data filtering based on a cell entry |
US9424244B2 (en) * | 2012-10-15 | 2016-08-23 | International Business Machines Corporation | Data filtering based on a cell entry |
US20140310649A1 (en) * | 2013-04-11 | 2014-10-16 | Apple Inc. | Pop-up menu interface |
US9317182B2 (en) * | 2013-04-11 | 2016-04-19 | Apple Inc. | Pop-up menu interface |
US10156961B1 (en) * | 2013-09-24 | 2018-12-18 | EMC IP Holding Company LLC | Dynamically building a visualization filter |
US10521076B1 (en) * | 2014-09-23 | 2019-12-31 | Allscripts Software, Llc | Big data selector system and method |
US9235328B1 (en) * | 2014-09-23 | 2016-01-12 | Allscripts Software, Llc | Big data selector system and method |
US11238108B1 (en) * | 2020-07-28 | 2022-02-01 | Grey Wall Software Llc | Custom data filtering systems and methods |
US11663272B2 (en) | 2020-07-28 | 2023-05-30 | Grey Wall Software Llc | Custom data filtering systems and methods |
US20220067811A1 (en) * | 2020-08-31 | 2022-03-03 | Coupang Corp. | Systems and methods for visual navigation during online shopping using intelligent filter sequencing |
US11449914B2 (en) * | 2020-08-31 | 2022-09-20 | Coupang Corp. | Systems and methods for visual navigation during online shopping using intelligent filter sequencing |
Also Published As
Publication number | Publication date |
---|---|
EP1643386A3 (en) | 2007-01-03 |
EP1643386A2 (en) | 2006-04-05 |
US7519585B2 (en) | 2009-04-14 |
JP2006107431A (en) | 2006-04-20 |
US20060101013A1 (en) | 2006-05-11 |
KR20060048768A (en) | 2006-05-18 |
CN1783072A (en) | 2006-06-07 |
CN100492359C (en) | 2009-05-27 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US7519585B2 (en) | Selection context filtering | |
US10579723B2 (en) | User interface for creating a spreadsheet data summary table | |
US9959267B2 (en) | Filtering user interface for a data summary table | |
US10565232B2 (en) | Constructing queries for execution over multi-dimensional data structures | |
EP1922649B1 (en) | Automated placement of fields in a data summary table | |
US6831668B2 (en) | Analytical reporting on top of multidimensional data model | |
US7925672B2 (en) | Metadata management for a data abstraction model | |
US7788257B2 (en) | Easy-to-use data report specification | |
Ravat et al. | Algebraic and graphic languages for OLAP manipulations | |
US20060116999A1 (en) | Sequential stepwise query condition building | |
JP2006172446A (en) | Complex data access | |
US20080163091A1 (en) | Filtering Data |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
AS | Assignment |
Owner name: MICROSOFT CORPORATION, WASHINGTON Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:COVINGTON, CLINTON D.;BEYENE, TIGINESH M.;DICKINSON, RICHARD;AND OTHERS;REEL/FRAME:015960/0041;SIGNING DATES FROM 19940930 TO 20040930 |
|
STCB | Information on status: application discontinuation |
Free format text: ABANDONED -- FAILURE TO RESPOND TO AN OFFICE ACTION |
|
AS | Assignment |
Owner name: MICROSOFT TECHNOLOGY LICENSING, LLC, WASHINGTON Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:MICROSOFT CORPORATION;REEL/FRAME:034766/0001 Effective date: 20141014 |