Computer assisted completion of hyperlink command segments

• US 10,678,787 B2
• Filed: 10/27/2017
• Issued: 06/09/2020
• Est. Priority Date: 05/14/2015
• Status: Active Grant

• Current Assignee: Deephaven Data Labs, LLC
• Original Assignee: Deephaven Data Labs, LLC
• Inventors: Wright, Charles
• Primary Examiner(s): Cortes, Howard
• Application Number:
  US15/796,230
• Publication Number:
  US 20180052879A1
• Time in Patent Office: 956 Days
• Field of Search: None
• CPC Class Codes: G06F 11/1451 by selection of backup contents
• CPC Class Codes: G06F 11/1464 for networked environments
• CPC Class Codes: G06F 11/1469 Backup restoration techniques
• CPC Class Codes: G06F 12/0261 using reference counting
• CPC Class Codes: G06F 12/084 with a shared cache
• CPC Class Codes: G06F 12/1483 using an access-table, e.g. matrix or list
• CPC Class Codes: G06F 15/17331 Distributed shared memory [DSM], e.g. remote direct memory access [RDMA]
• CPC Class Codes: G06F 16/113 Details of archiving lifecycle management in storage systems G06F3/0649; backup systems G06F11/1446
• CPC Class Codes: G06F 16/144 Query formulation
• CPC Class Codes: G06F 16/162 Delete operations erasing in storage systems G06F3/0652
• CPC Class Codes: G06F 16/215 Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: G06F 16/221 Column-oriented storage; Management thereof
• CPC Class Codes: G06F 16/2228 Indexing structures
• CPC Class Codes: G06F 16/2237 Vectors, bitmaps or matrices
• CPC Class Codes: G06F 16/2246 Trees, e.g. B+trees
• CPC Class Codes: G06F 16/2255 Hash tables
• CPC Class Codes: G06F 16/2264 Multidimensional index structures
• CPC Class Codes: G06F 16/2272 Management thereof
• CPC Class Codes: G06F 16/2282 Tablespace storage structures; Management thereof
• CPC Class Codes: G06F 16/2291 : User-Defined Types; Storage management thereof
• CPC Class Codes: G06F 16/23 : Updating
• CPC Class Codes: G06F 16/2308 : Concurrency control transaction processing G06F9/466
• CPC Class Codes: G06F 16/2358 : Change logging, detection, and notification replication G06F16/27
• CPC Class Codes: G06F 16/2365 : Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/2372 : Updates performed during offline database operations
• CPC Class Codes: G06F 16/2379 : Updates performed during online database operations; commit processing
• CPC Class Codes: G06F 16/242 : Query formulation
• CPC Class Codes: G06F 16/2428 : Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence
• CPC Class Codes: G06F 16/245 : Query processing
• CPC Class Codes: G06F 16/2453 : Query optimisation
• CPC Class Codes: G06F 16/24534 : Query rewriting; Transformation
• CPC Class Codes: G06F 16/24535 : of sub-queries or views
• CPC Class Codes: G06F 16/24537 : of operators
• CPC Class Codes: G06F 16/24539 : using cached or materialised query results
• CPC Class Codes: G06F 16/2455 : Query execution
• CPC Class Codes: G06F 16/24553 : of query operations
• CPC Class Codes: G06F 16/2456 : Join operations
• CPC Class Codes: G06F 16/24561 : Intermediate data storage techniques for performance improvement
• CPC Class Codes: G06F 16/2457 : with adaptation to user needs
• CPC Class Codes: G06F 16/24575 : using context
• CPC Class Codes: G06F 16/248 : Presentation of query results
• CPC Class Codes: G06F 16/254 : Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 16/27 : Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 16/278 : Data partitioning, e.g. horizontal or vertical partitioning
• CPC Class Codes: G06F 16/285 : Clustering or classification
• CPC Class Codes: G06F 16/9024 : Graphs; Linked lists G06F16/9027 takes precedence
• CPC Class Codes: G06F 16/907 : Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
• CPC Class Codes: G06F 16/951 : Indexing; Web crawling techniques
• CPC Class Codes: G06F 16/9535 : Search customisation based on user profiles and personalisation
• CPC Class Codes: G06F 16/9538 : Presentation of query results
• CPC Class Codes: G06F 16/9566 : URL specific, e.g. using aliases, detecting broken or misspelled links
• CPC Class Codes: G06F 16/9574 : of access to content, e.g. by caching
• CPC Class Codes: G06F 17/40 : Data acquisition and logging for input to computer G06F3/00
• CPC Class Codes: G06F 21/00 : Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
• CPC Class Codes: G06F 21/6209 : to a single file or object, e.g. in a secure envelope, encrypted and accessed using a key, or with access control rules appended to the object itself
• CPC Class Codes: G06F 2201/805 : Real-time
• CPC Class Codes: G06F 2201/84 : Using snapshots, i.e. a logical point-in-time copy of the data
• CPC Class Codes: G06F 2212/1052 : Security improvement
• CPC Class Codes: G06F 2212/154 : Networked environment
• CPC Class Codes: G06F 2212/163 : Server or database system
• CPC Class Codes: G06F 2212/60 : Details of cache memory
• CPC Class Codes: G06F 3/0481 : based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
• CPC Class Codes: G06F 3/0482 : Interaction with lists of selectable items, e.g. menus
• CPC Class Codes: G06F 3/0483 : Interaction with page-structured environments, e.g. book metaphor
• CPC Class Codes: G06F 3/04847 : Interaction techniques to control parameter settings, e.g. interaction with sliders or dials
• CPC Class Codes: G06F 3/0485 : Scrolling or panning
• CPC Class Codes: G06F 3/04895 : Guidance during keyboard input operation, e.g. prompting
• CPC Class Codes: G06F 3/0605 : by facilitating the interaction with a user or administrator
• CPC Class Codes: G06F 3/0656 : Data buffering arrangements
• CPC Class Codes: G06F 3/067 : Distributed or networked storage systems, e.g. storage area networks [SAN], network attached storage [NAS]
• CPC Class Codes: G06F 40/117 : Tagging; Marking up details of markup languages G06F40/143; Designating a block; Setting of attributes style sheets, e.g. eXtensible Stylesheet Language Transformation [XSLT], G06F40/154
• CPC Class Codes: G06F 40/134 : Hyperlinking
• CPC Class Codes: G06F 40/166 : Editing, e.g. inserting or deleting
• CPC Class Codes: G06F 40/174 : Form filling; Merging
• CPC Class Codes: G06F 40/177 : of tables; using ruled lines
• CPC Class Codes: G06F 40/18 : of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06F 40/183 : Tabulation, i.e. one-dimensional positioning
• CPC Class Codes: G06F 40/216 : using statistical methods
• CPC Class Codes: G06F 40/274 : Converting codes to words; Guess-ahead of partial word inputs
• CPC Class Codes: G06F 8/30 : Creation or generation of source code
• CPC Class Codes: G06F 8/41 : Compilation
• CPC Class Codes: G06F 8/427 : Parsing
• CPC Class Codes: G06F 8/60 : Software deployment
• CPC Class Codes: G06Q 40/04 : Trading; Exchange, e.g. stocks, commodities, derivatives or currency exchange
• CPC Class Codes: H04L 12/18 : for broadcast or conference , e.g. multicast
• CPC Class Codes: H04L 51/046 : Interoperability with other network applications or services
• CPC Class Codes: H04L 51/212 : using filtering or selective blocking
• CPC Class Codes: H04L 61/5069 : for group communication, multicast communication or broadcast communication
• CPC Class Codes: H04L 63/101 : Access control lists [ACL]
• CPC Class Codes: H04L 63/102 : Entity profiles
• CPC Class Codes: H04L 67/01 : Protocols
• CPC Class Codes: H04L 67/1001 : for accessing one among a plurality of replicated servers
• CPC Class Codes: H04L 67/141 : Setup of application sessions admission control or resource allocation in data switching networks H04L47/70
• CPC Class Codes: H04L 67/34 : involving the movement of software or configuration parameters network booting or remote initial program loading [RIPL] G06F9/4416
• CPC Class Codes: H04L 67/56 : Provisioning of proxy services store-and-forward switching systems in data switching networks H04L12/54
• CPC Class Codes: H04L 67/566 : Grouping or aggregating service requests, e.g. for unified processing
• CPC Class Codes: H04L 67/568 : Storing data temporarily at an intermediate stage, e.g. caching
• CPC Class Codes: H04L 67/5681 : Pre-fetching or pre-delivering data based on network characteristics
• CPC Class Codes: H04L 69/16 : Implementation or adaptation of Internet protocol [IP], of transmission control protocol [TCP] or of user datagram protocol [UDP]

Abstract

Described are methods, systems and computer readable media for computer assisted completion of hyperlink command segments.

Claims

1. A system for computer processor assisted completion of command segments, the system comprising:

one or more hardware processors;

a computer console coupled to the one or more hardware processors;

a computer readable data storage device coupled to the one or more hardware processors, the computer readable data storage device having stored thereon software instructions that, when executed by the one or more hardware processors, cause the one or more hardware processors to perform operations including;

(a) using the computer processor for monitoring for input in a computer console command line interface;

(b) receiving, by the computer processor, one or more characters input into the computer console command line interface;

(c) receiving, by the computer processor, a first designated hot key character input into the computer console command line interface;

(d) upon receiving the first designated hot key character, using the computer processor for searching one or more potential command line completion sources in a computer memory for segment matches with the one or more received characters input into the computer console command line interface;

(e) if a plurality of segment matches is found, determining whether the plurality of segment matches have a common segment stem;

(f) if the common segment stem is found, displaying the common segment stem in the computer console command line interface and proceeding to step (j), wherein, if there is already a displayed command segment in the computer console command line interface, concatenating the common segment stem with the displayed command segment;

(g) if no common segment stem is found, displaying as one or more hyperlinks in proximity to the computer console command line interface at least a portion of the plurality of segment matches found in the one or more potential command line completion sources;

(h) if a selection of one of the one or more hyperlinks in proximity to the computer console command line interface is received, displaying the selection of the one of the one or more hyperlinks in proximity to the computer console command line interface in the computer console command line interface;

(i) if one or more additional characters are received, displaying the one or more received additional characters in the computer console command line interface and proceeding to step (k);

(j) using the computer processor for monitoring for character input into the computer console command line interface;

(k) if a second designated hot key character is not received, repeat steps (a) through (i) to process a next command segment, wherein each command segment is processed for completion individually, and wherein one or more of the one or more additional characters or the one or more received characters input into the computer console command line interface and one or more of the first designated hot key character or the second designated hot key character are processed to iteratively create a full command from a plurality of command segments; and

(l) if the second designated hot key character is received, execute one or more command segments using the computer processor,

wherein, after input of a first command is started, when the one or more of the one or more received additional characters or the one or more received characters input into the computer console command line interface indicate a start of a second command separate from the first command, the searching includes narrowing the searching to a command syntax completion source of the one or more potential command line completion sources,

wherein the second command is not a parameter of the first command, and

wherein the execute command segments using the computer processor includes executing the first command and executing the second command.

2. The system of claim 1, wherein the one or more potential command line completion sources include at least one source from a command history, a command syntax file, a database name space source, or a table name source.

3. The system of claim 1, wherein the selection includes a cursor click operation.

4. The system of claim 1, wherein at least one of the first designated hot key character or a second designated hot key character includes a <

tab>

key character.

5. The system of claim 1, wherein displaying as one or more displayed hyperlinks in proximity to the computer console command line interface any of the plurality of segment matches found in the one or more potential command line completion sources includes displaying an indicator if one or more additional hyperlinks are available off-screen.

6. A method for computer processor assisted completion of command segments comprising:

(a) using the computer processor for monitoring for input in a computer console command line interface;

(b) receiving, by the computer processor, one or more characters input into the computer console command line interface;

(c) receiving, by the computer processor, a first designated hot key character input into the computer console command line interface;

(d) upon receiving the first designated hot key character, using the computer processor for searching one or more potential command line completion sources in a computer memory for segment matches with the received characters input into the computer console command line interface;

(e) when a plurality of segment matches is found, determining whether the plurality of segment matches have a common segment stem;

(f) when the common segment stem is found, displaying the common segment stem in the computer console command line interface, displaying as one or more first hyperlinks in proximity to the computer console command line interface at least a portion of a plurality of common segment matches found in the potential command line completion sources and proceeding to step (j), wherein, if there is already a displayed command segment in the computer console command line interface, concatenating the common segment stem with the displayed command segment;

(g) when no common segment stem is found, displaying as one or more second hyperlinks in proximity to the computer console command line interface at least a portion of the plurality of segment matches found in the one or more potential command line completion sources;

(h) when a selection of one of the one or more first hyperlinks or the one of the one or more second hyperlinks in proximity to the computer console command line interface is received, displaying the selection in proximity to the computer console command line interface;

(i) when one or more additional characters are received, displaying the one or more additional characters in the computer console command line interface;

(j) using the computer processor for monitoring for character input into the computer console command line interface; and

(k) when a second designated hot key character is received, repeating (a)-(j) to process a next command segment, wherein each command segment is processed for completion individually, and wherein one or more of the one or more additional characters or the one or more received characters input into the computer console command line interface and the first designated hot key character or the second designated hot key character are processed to iteratively create a full command from a plurality of command segments.

7. The method of claim 6, wherein the one or more potential command line completion sources include at least one source from a command history, a command syntax file, a database name space source, or a table name source.

8. The method of claim 6, wherein at least one of the first designated hot key character or a second designated hot key character includes a <

tab>

key character.

9. The method of claim 6, wherein displaying as one or more displayed hyperlinks in proximity to the computer console command line interface any of the plurality of segment matches found in the one or more potential command line completion sources includes displaying an indicator if one or more additional hyperlinks are available off-screen.

10. The method of claim 6,

wherein, after input of a first command is started, when the one or more of the one or more received additional characters or the one or more received characters input into the computer console command line interface indicate a start of a second command separate from the first command, the searching includes narrowing the searching to a command syntax completion source of the one or more potential command line completion sources.

11. The method of claim 10, wherein the second command is not a parameter of the first command.

12. The method of claim 6, wherein the selection of the one of the one or more hyperlinks is received when a user clicks on the one of the one or more hyperlinks.

13. The method of claim 6,

wherein, when the plurality of segment matches includes too many matches to display, the displaying as one or more displayed hyperlinks includes:

displaying as the one or more displayed hyperlinks a first portion of the plurality of segment matches;

presenting an indicator of too many matches to display; and

displaying an additional page of matches to display a second portion of the plurality of segment matches as one or more additional hyperlinks, the second portion consisting of one or more segment matches of the plurality of segment matches not included in the first portion of the plurality of segment matches.

14. A nontransitory computer readable medium having stored thereon software instructions that, when executed by one or more computer processors, cause the one or more processors to perform operations including:

(a) using the one or more computer processors to monitor for input in a computer console command line interface;

(b) receiving, by the one or more computer processors, one or more characters input into the computer console command line interface;

(c) receiving, by the one or more computer processors, a first designated hot key character input into the computer console command line interface;

(d) upon receiving the first designated hot key character, using the one or more computer processors for searching one or more potential command line completion sources in a computer memory for segment matches with the received characters input into the computer console command line interface;

(e) if a plurality of segment matches is found, determining whether the plurality of segment matches have a common segment stem;

(f) if the common segment match is found, displaying the common segment match in the computer console command line interface and proceeding to step (k), wherein, if there is already a displayed command segment in the computer console command line interface, concatenating the common segment stem with the displayed command segment;

(g) if no common segment stem is found, displaying as one or more displayed hyperlinks in proximity to the computer console command line interface at least a portion of the plurality of segment matches found in the one or more potential command line completion sources;

(h) receiving by the computer processor a selection of one of the one or more hyperlinks in proximity to the computer console command line interface or one or more additional characters;

(i) if the selection of one of the one or more hyperlinks in proximity to the computer console command line interface is received, displaying the selection of one of the one or more hyperlinks in proximity to the computer console command line interface in the computer console command line interface;

(j) if the one or more additional characters are received, displaying the one or more additional characters in the computer console command line interface and proceeding to step (l);

(k) using the computer processor for monitoring for character input into the computer console command line interface;

(l) if a second designated hot key character is not received, repeat steps (a) through (j) to process a next command segment, wherein each command segment is processed for completion individually, and wherein one or more of the one or more additional characters or the one or more characters input into the computer console command line interface and one or more of the first designated hot key character or the second designated hot key character are processed to iteratively create a full command from a plurality of command segments; and

(m) if the second designated hot key character is received, execute the command segments using the computer processor.

15. The nontransitory computer readable medium of claim 14, wherein the one or more potential command line completion sources include at least one source from a command history, a command syntax file, a database name space source, or a table name source.

16. The nontransitory computer readable medium of claim 14, wherein the selection includes a cursor click operation.

17. The nontransitory computer readable medium of claim 14, wherein at least one of the first designated hot key character or a second designated hot key character includes a <

tab>

key character.

18. The nontransitory computer readable medium of claim 14, wherein displaying as one or more displayed hyperlinks in proximity to the computer console command line interface any of the plurality of segment matches found in the one or more potential command line completion sources includes displaying an indicator if one or more additional hyperlinks are available off-screen.

19. The nontransitory computer readable medium of claim 14,

wherein, after input of a first command is started, when the one or more of the one or more received additional characters or the one or more received characters input into the computer console command line interface indicate a start of a second command separate from the first command, the searching includes narrowing the searching to a command syntax completion source of the one or more potential command line completion sources.

20. The nontransitory computer readable medium of claim 19, wherein the second command is not a parameter of the first command.

21. The nontransitory computer readable medium of claim 14, wherein the selection of the one of the one or more hyperlinks is received when a user clicks on the one of the one or more hyperlinks with a cursor.

22. The nontransitory computer readable medium of claim 14,

wherein, when the plurality of segment matches includes too many matches to display, the displaying as one or more displayed hyperlinks includes:

displaying as the one or more displayed hyperlinks a first portion of the plurality of segment matches;

presenting an indicator of too many matches to display; and

displaying an additional page of matches to display a second portion of the plurality of segment matches as one or more additional hyperlinks, the second portion consisting of one or more segment matches of the plurality of segment matches not included in the first portion of the plurality of segment matches.