IP Library Granted Patent US 10,909,131
Granted Patent B1
US 10,909,131 · App. 15/581,675 · Granted Feb 2, 2021

Method and system for indexing and searching data sub-streams

Inventors: Stephen G. Graham (Chapel Hill, NC); Aaron W. Spiegel (Stilwell, KS); Paul R. Kingston (Cumming, GA); Flavio Paiva Junqueira (Barcelona, ES); Dominique Prunier (Montreal, CA)
Assignee: EMC IP HOLDING COMPANY LLC
G06F16/248G06F16/2228G06F16/24568
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 10,909,131
App. No.
15/581,675
Granted
Feb 2, 2021
Kind
B1
Abstract

Systems and methods are disclosed for efficiently indexing stream data to facilitate full-text search of the stream data. A stream comprises large amount of data, only some of which is deemed useful for full-text search indexing. An administrator can specify an indexing specification for a stream. The indexing specification can specify one or more sub-streams within the stream for indexing, and/or specify one or more time intervals of stream data for indexing. A query against the stream can specify the indexing specification to use to index the stream before returning results for the query. The query can alternatively specify an indexing specification to apply to a previously indexed stream. Full-text search indexes generated using an indexing specification can return results that are more relevant to a user because the results are more narrowly focused than an index of, e.g., the entire stream.

Claims (96)

1. A computer-implemented method performed by a server for efficiently indexing a portion of a stream data, comprising:

accessing a stream database that has been declared searchable;

accessing a database of indexing specifications to determine whether an indexing specification exists for the stream data;

in response to determining that the indexing specification exists for the stream data:

receiving one or more stream index specifications associated with a stream, each of the one or more stream index specifications comprising one or more rules for indexing the stream, wherein a stream index specification specifies a portion of stream data of the stream to index and identifies a list of terms that should be indexed and a list of terms that should not be indexed; and

generating one or more stream indexes for the portion of stream data in accordance with the one or more stream index specifications;

otherwise, in response to determining that the indexing specification does not exist for the stream data, generating one or more stream indexes for the portion of the stream data in accordance with a default indexing scheme;

wherein the portion of stream data comprises a temporal subset of the stream data defined by an interval of time;

whereby only a portion of the temporal subset is indexed repeatedly for a plurality of intervals of time to generate a plurality of interval indexes to thereby reduce an amount of computing necessary to index the incoming streaming data; and,

when a number of intervals of time exceeds a threshold, merging the plurality of interval indexes and marking a previously written index for deletion to thereby reduce an amount of storage required for storing resulting indexing.

2. The method of claim 1 , further comprising:

receiving a change to one or more of the stream index specifications; and

generating one or more stream indexes for a second portion of the stream data in accordance with the one or more changed stream index specifications.

3. The method of claim 1 , wherein:

the stream comprises a plurality of sub-streams; and

the specified portion of the stream data comprises one or more sub-streams of the stream data.

4. The method of claim 3 , wherein:

the stream comprises stream data over a period of time;

the specified portion of the stream data comprises a sub-interval of the period of time; and

the portion of the stream data indexed includes only stream data which falls within the sub-interval and the subset of the plurality of streams.

5. The method of claim 1 , wherein:

the stream comprises stream data over a period of time;

the specified portion of the stream data comprises a sub-interval of the period of time;

and the method further comprises generating a full-text search index in response to a query against a stream index in the one or more stream indexes for the portion of the stream of data.

6. A non-transitory computer readable medium, programmed with executable instructions that, when executed by a processing system, perform operations comprising:

accessing a stream database to determine whether the stream data has been declared searchable;

in response to determining that the stream data has not been declared searchable, storing the stream data unindexed, and in response to determining that the stream data has been declared searchable:

accessing a database of indexing specifications to determine whether an indexing specification exists for the stream data;

in response to determining that the indexing specification exists for the stream data:

receiving one or more stream index specifications associated with a stream, each of the one or more stream index specifications comprising one or more rules for indexing the stream, wherein a stream index specification specifies a portion of stream data of the stream to index and identifies a list of terms that should be indexed and a list of terms that should not be indexed; and

generating one or more stream indexes for the portion of stream data in accordance with the one or more stream index specifications;

otherwise, in response to determining that the indexing specification does not exist for the stream data, generating one or more stream indexes for the portion of the stream data in accordance with a default indexing scheme;

wherein the portion of stream data comprises a temporal subset of the stream data defined by an interval of time;

whereby only a portion of the temporal subset is indexed repeatedly for a plurality of intervals of time to generate a plurality of interval indexes to thereby reduce an amount of computing necessary to index the incoming streaming data; and,

when a number of intervals of time exceeds a threshold, merging the plurality of interval indexes and marking a previously written index for deletion to thereby reduce an amount of storage required for storing resulting indexing.

7. The medium of claim 6 , further comprising:

receiving a change to one or more of the stream index specifications; and

generating one or more stream indexes for a second portion of the stream data in accordance with the one or more changed stream index specifications.

8. The medium of claim 6 , wherein:

the stream comprises a plurality of sub-streams; and

the specified portion of the stream data comprises one or more sub-streams of the stream data.

9. The medium of claim 8 , wherein:

the stream comprises stream data over a period of time;

the specified portion of the stream data comprises a sub-interval of the period of time; and

the portion of the stream data indexed includes only stream data which falls within the

sub-interval and the subset of the plurality of streams.

10. The medium of claim 6 , wherein:

the stream comprises stream data over a period of time;

the specified portion of the stream data comprises a sub-interval of the period of time;

and the method further comprises generating a full-text search index in response to a query against a stream index in the one or more stream indexes for the portion of the stream of data.

11. A processing system, comprising a hardware processor coupled to a memory programmed with executable instructions, that when executed by the processing system, perform operations comprising:

accessing a stream database to determine whether the stream data has been declared searchable;

in response to determining that the stream data has not been declared searchable, storing the stream data unindexed, and in response to determining that the stream data has been declared searchable:

accessing a database of indexing specifications to determine whether an indexing specification exists for the stream data;

in response to determining that the indexing specification exists for the stream data:

receiving one or more stream index specifications associated with a stream, each of the one or more stream index specifications comprising one or more rules for indexing the stream, wherein a stream index specification specifies a portion of stream data of the stream to index and identifies a list of terms that should be indexed and a list of terms that should not be indexed; and

generating one or more stream indexes for the portion of stream data in accordance with the one or more stream index specifications;

otherwise, in response to determining that the indexing specification does not exist for the stream data, generating one or more stream indexes for the portion of the stream data in accordance with a default indexing scheme;

wherein the portion of stream data comprises a temporal subset of the stream data defined by an interval of time;

whereby only a portion of the temporal subset is indexed repeatedly for a plurality of intervals of time to generate a plurality of interval indexes to thereby reduce an amount of computing necessary to index the incoming streaming data; and,

when a number of intervals of time exceeds a threshold, merging the plurality of interval indexes and marking a previously written index for deletion to thereby reduce an amount of storage required for storing resulting indexing.

12. The system of claim 11 , further comprising:

receiving a change to one or more of the stream index specifications; and

generating one or more stream indexes for a second portion of the stream data in accordance with the one or more changed stream index specifications.

13. The system of claim 11 , wherein:

the stream comprises a plurality of sub-streams; and

the specified portion of the stream data comprises one or more sub-streams of the stream data.

14. The system of claim 13 , wherein:

the stream comprises stream data over a period of time;

the specified portion of the stream data comprises a sub-interval of the period of time; and

the portion of the stream data indexed includes only stream data which falls within the sub-interval and the subset of the plurality of streams.

15. The system of claim 11 , wherein:

the stream comprises stream data over a period of time;

the specified portion of the stream data comprises a sub-interval of the period of time;

and the method further comprises generating a full-text search index in response to a query against a stream index in the one or more stream indexes for the portion of the stream of data.

16. The computer-implemented method of claim 1 , further comprising:

receiving a query from a client device for a subset of stream data, wherein the query includes a reference to a stream index of at least a portion of the subset of stream data, wherein the stream index was generated using the stream index specification;

identifying query results using the stream index of at least the portion of the subset of the stream data, wherein the query results identified using the stream index that was generated using the index specification limit the identified query results to those query results that match the stream index specification, wherein the stream index specification specifies a portion of the stream data to index and identifies a list of terms that should be indexed and a list of terms that should not be indexed; and

returning the query results to the client device.

17. The method of claim 16 , wherein the portion of the subset of the stream data comprises at least one of:

a sub-stream of the stream data indexed by the referenced index; or

a sub-interval of a period of time of the stream data indexed by the referenced index.

18. The non-transitory computer-readable medium of claim 6 , further comprising:

receiving a query from a client device for a subset of stream data, wherein the query includes a reference to a stream index of at least a portion of the subset of stream data, wherein the stream index was generated using the stream index specification;

identifying query results using the stream index of at least the portion of the subset of the stream data, wherein the query results identified using the stream index that was generated using the index specification limit the identified query results to those query results that match the stream index specification, wherein the stream index specification specifies a portion of the stream data to index and identifies a list of terms that should be indexed and a list of terms that should not be indexed; and

returning the query results to the client device.

19. The medium of claim 18 , wherein the portion of the subset of the stream data comprises at least one of:

a sub-stream of the stream data indexed by the referenced index; or

a sub-interval of a period of time of the stream data indexed by the referenced index.

20. The processing system, of claim 11 , further performing operations comprising:

receiving a query from a client device for a subset of stream data, wherein the query includes a reference to a stream index of at least a portion of the subset of stream data, wherein the stream index was generated using the stream index specification;

identifying query results using the stream index of at least the portion of the subset of the stream data, wherein the query results identified using the stream index that was generated using the index specification limit the identified query results to those query results that match the stream index specification, wherein the stream index specification specifies a portion of the stream data to index and identifies a list of terms that should be indexed and a list of terms that should not be indexed; and

returning the query results to the client device.

21. The system of claim 20 , wherein the portion of the subset of the stream data comprises at least one of:

a sub-stream of the stream data indexed by the referenced index; or

a sub-interval of a period of time of the stream data indexed by the referenced index.

Assignments (8)
RELEASE OF SECURITY INTEREST IN PATENTS PREVIOUSLY RECORDED AT REEL/FRAME (053546/0001) Recorded Jun 23, 2022
From: THE BANK OF NEW YORK MELLON TRUST COMPANY, N.A., AS NOTES COLLATERAL AGENT
To: DELL MARKETING L.P. (ON BEHALF OF ITSELF AND AS SUCCESSOR-IN-INTEREST TO CREDANT TECHNOLOGIES, INC.); DELL INTERNATIONAL L.L.C.; DELL PRODUCTS L.P.; DELL USA L.P.; EMC CORPORATION; DELL MARKETING CORPORATION (SUCCESSOR-IN-INTEREST TO FORCE10 NETWORKS, INC. AND WYSE TECHNOLOGY L.L.C.); EMC IP HOLDING COMPANY LLC
Reel/Frame 071642/0001 →
RELEASE OF SECURITY INTEREST IN PATENTS PREVIOUSLY RECORDED AT REEL/FRAME (042769/0001) Recorded Apr 26, 2022
From: THE BANK OF NEW YORK MELLON TRUST COMPANY, N.A., AS NOTES COLLATERAL AGENT
To: DELL PRODUCTS L.P.; EMC CORPORATION; EMC IP HOLDING COMPANY LLC (ON BEHALF OF ITSELF AND AS SUCCESSOR-IN-INTEREST TO MOZY, INC.); DELL MARKETING CORPORATION (SUCCESSOR-IN-INTEREST TO WYSE TECHNOLOGY L.L.C.)
Reel/Frame 059803/0802 →
RELEASE OF SECURITY INTEREST AT REEL 042768 FRAME 0585 Recorded Nov 2, 2021
From: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH
To: DELL PRODUCTS L.P.; EMC CORPORATION; EMC IP HOLDING COMPANY LLC; MOZY, INC.; WYSE TECHNOLOGY L.L.C.
Reel/Frame 058297/0536 →
SECURITY AGREEMENT Recorded Apr 22, 2020
From: CREDANT TECHNOLOGIES INC.; DELL INTERNATIONAL L.L.C.; DELL MARKETING L.P.; DELL PRODUCTS L.P.; DELL USA L.P.; EMC CORPORATION; FORCE10 NETWORKS, INC.; WYSE TECHNOLOGY L.L.C.; EMC IP HOLDING COMPANY LLC
To: THE BANK OF NEW YORK MELLON TRUST COMPANY, N.A.
Reel/Frame 053546/0001 →
SECURITY AGREEMENT Recorded Mar 21, 2019
From: CREDANT TECHNOLOGIES, INC.; DELL INTERNATIONAL L.L.C.; DELL MARKETING L.P.; DELL PRODUCTS L.P.; DELL USA L.P.; EMC CORPORATION; FORCE10 NETWORKS, INC.; WYSE TECHNOLOGY L.L.C.; EMC IP HOLDING COMPANY LLC
To: THE BANK OF NEW YORK MELLON TRUST COMPANY, N.A.
Reel/Frame 049452/0223 →
PATENT SECURITY INTEREST (CREDIT) Recorded Jun 12, 2017
From: DELL PRODUCTS L.P.; EMC CORPORATION; EMC IP HOLDING COMPANY LLC; MOZY, INC.; WYSE TECHNOLOGY L.L.C.
To: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH, AS COLLATERAL AGENT
Reel/Frame 042768/0585 →
PATENT SECURITY INTEREST (NOTES) Recorded Jun 12, 2017
From: DELL PRODUCTS L.P.; EMC CORPORATION; EMC IP HOLDING COMPANY LLC; MOZY, INC.; WYSE TECHNOLOGY L.L.C.
To: THE BANK OF NEW YORK MELLON TRUST COMPANY, N.A., AS COLLATERAL AGENT
Reel/Frame 042769/0001 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Apr 28, 2017
From: GRAHAM, STEPHEN G.; SPIEGEL, AARON W.; KINGSTON, PAUL R.; PAVIA JUNQUEIRA, FLAVIO; PRUNIER, DOMINIQUE
To: EMC IP HOLDING COMPANY LLC
Reel/Frame 042180/0601 →
Cited By (3)
US 12,314,265 US 12,423,133 US 12,493,652