Movatterモバイル変換


[0]ホーム

URL:


US20230161760A1 - Applying data-determinant query terms to data records with different formats - Google Patents

Applying data-determinant query terms to data records with different formats
Download PDF

Info

Publication number
US20230161760A1
US20230161760A1US18/153,299US202318153299AUS2023161760A1US 20230161760 A1US20230161760 A1US 20230161760A1US 202318153299 AUS202318153299 AUS 202318153299AUS 2023161760 A1US2023161760 A1US 2023161760A1
Authority
US
United States
Prior art keywords
data
search
determinant
query
data record
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.)
Pending
Application number
US18/153,299
Inventor
Alexander Douglas James
Andrew Peters
Arun Ramani
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Cisco Technology Inc
Original Assignee
Splunk Inc
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Priority claimed from US15/967,587external-prioritypatent/US11106734B1/en
Priority claimed from US16/147,129external-prioritypatent/US11093564B1/en
Priority claimed from US16/264,299external-prioritypatent/US11392578B1/en
Application filed by Splunk IncfiledCriticalSplunk Inc
Priority to US18/153,299priorityCriticalpatent/US20230161760A1/en
Assigned to SPLUNK INC.reassignmentSPLUNK INC.ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS).Assignors: JAMES, ALEXANDER DOUGLAS, PETERS, ANDREW, RAMANI, ARUN
Publication of US20230161760A1publicationCriticalpatent/US20230161760A1/en
Assigned to SPLUNK LLCreassignmentSPLUNK LLCCHANGE OF NAME (SEE DOCUMENT FOR DETAILS).Assignors: SPLUNK INC.
Assigned to CISCO TECHNOLOGY, INC.reassignmentCISCO TECHNOLOGY, INC.ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS).Assignors: SPLUNK LLC
Assigned to SPLUNK LLCreassignmentSPLUNK LLCCHANGE OF NAME (SEE DOCUMENT FOR DETAILS).Assignors: SPLUNK INC.
Pendinglegal-statusCriticalCurrent

Links

Images

Classifications

Definitions

Landscapes

Abstract

Systems and methods are disclosed for flexibly applying a query term to heterogeneous data. A query system can receive a query that includes a data-determinant query term. As the system executes the query it can generate interim search results. As the system query processes the interim search results based on the query, it can apply the data-determinant query term to records of the interims search results based on the structure of the records.

Description

Claims (21)

21. A method, comprising:
receiving a plurality of data records, the plurality of data records having a plurality of formats;
identifying a data-determinant query term of a query to be applied to the plurality of data records;
determining a first data record of the plurality of data records has a first format of the plurality of formats;
applying the data-determinant query term to a first field of the first data record based on determining the first data record has the first format;
determining a second data record of the plurality of data records has a second format of the plurality of formats, wherein the second format is different from the first format;
applying the data-determinant query term to a second field of the second data record based on determining the second data record has the second format; and
generating a set of search results based on applying the data-determinant query term to the first field of the first data record and the second field of the second data record.
35. The method ofclaim 21, wherein applying the data-determinant query term to the second field of the second data record comprises:
determining that the data-determinant query term does not match a field identifier of the second data record;
identifying a dataset associated with the second data record based on the data-determinant query term;
determining a content value for the second data record based on a lookup operation using the dataset associated with the second data record; and
applying a search command of the data-determinant query term to the content value,
wherein the plurality of data records includes a third data record that corresponds to the second data record of the plurality of data records, and wherein the third data record includes a data structure identifier and a property identifier that correspond to the data-determinant query term and a property value that corresponds to the content value.
36. The method ofclaim 21, wherein applying the data-determinant query term to the second field of the second data record comprises:
determining that the data-determinant query term does not match a field identifier of the second data record;
identifying a dataset associated with the second data record based on the data-determinant query term;
determining a content value for the second data record based on a lookup operation using the dataset associated with the second data record; and
applying a search command of the data-determinant query term to the content value,
wherein the plurality of data records includes a third data record that corresponds to the second data record of the plurality of data records, and wherein the third data record includes a field identifier that corresponds to the data-determinant query term and a field value that corresponds to the content value.
37. The method ofclaim 21, wherein applying the data-determinant query term to the second field of the second data record comprises:
determining that the data-determinant query term does not match a field identifier of the second data record;
identifying a regular expression rule associated with the second data record based on the data-determinant query term;
determining a first field value of the second field of the second data record based on the regular expression rule; and
applying a search command of the data-determinant query term to the first field value,
wherein the plurality of data records includes a third data record that corresponds to the second data record of the plurality of data records, and wherein the third data record includes a field identifier that corresponds to the data-determinant query term and a second field value that corresponds to the first field value.
39. A computing system of a data intake and query system, the computing system comprising:
memory; and
one or more processing devices coupled to the memory and configured to:
receive a plurality of data records, the plurality of data records having a plurality of formats;
identify a data-determinant query term of a query to be applied to the plurality of data records;
determine a first data record of the plurality of data records has a first format of the plurality of formats;
apply the data-determinant query term to a first field of the first data record based on determining the first data record has the first format;
determine a second data record of the plurality of data records has a second format of the plurality of formats, wherein the second format is different from the first format;
apply the data-determinant query term to a second field of the second data record based on determining the second data record has the second format; and
generate a set of search results based on applying the data-determinant query term to the first field of the first data record and the second field of the second data record.
40. Non-transitory computer readable media comprising computer-executable instructions that, when executed by a computing system of a query system, cause the computing system to:
receive a plurality of data records, the plurality of data records having a plurality of formats;
identify a data-determinant query term of a query to be applied to the plurality of data records;
determine a first data record of the plurality of data records has a first format of the plurality of formats;
apply the data-determinant query term to a first field of the first data record based on determining the first data record has the first format;
determine a second data record of the plurality of data records has a second format of the plurality of formats, wherein the second format is different from the first format;
apply the data-determinant query term to a second field of the second data record based on determining the second data record has the second format; and
generate a set of search results based on applying the data-determinant query term to the first field of the first data record and the second field of the second data record.
US18/153,2992018-04-302023-01-11Applying data-determinant query terms to data records with different formatsPendingUS20230161760A1 (en)

Priority Applications (1)

Application NumberPriority DateFiling DateTitle
US18/153,299US20230161760A1 (en)2018-04-302023-01-11Applying data-determinant query terms to data records with different formats

Applications Claiming Priority (5)

Application NumberPriority DateFiling DateTitle
US15/967,587US11106734B1 (en)2016-09-262018-04-30Query execution using containerized state-free search nodes in a containerized scalable environment
US16/147,129US11093564B1 (en)2016-09-262018-09-28Identifying configuration parameters for a query using a metadata catalog
US16/264,299US11392578B1 (en)2018-04-302019-01-31Automatically generating metadata for a metadata catalog based on detected changes to the metadata catalog
US16/657,664US11573955B1 (en)2018-04-302019-10-18Data-determinant query terms
US18/153,299US20230161760A1 (en)2018-04-302023-01-11Applying data-determinant query terms to data records with different formats

Related Parent Applications (1)

Application NumberTitlePriority DateFiling Date
US16/657,664ContinuationUS11573955B1 (en)2018-04-302019-10-18Data-determinant query terms

Publications (1)

Publication NumberPublication Date
US20230161760A1true US20230161760A1 (en)2023-05-25

Family

ID=85156849

Family Applications (2)

Application NumberTitlePriority DateFiling Date
US16/657,664ActiveUS11573955B1 (en)2018-04-302019-10-18Data-determinant query terms
US18/153,299PendingUS20230161760A1 (en)2018-04-302023-01-11Applying data-determinant query terms to data records with different formats

Family Applications Before (1)

Application NumberTitlePriority DateFiling Date
US16/657,664ActiveUS11573955B1 (en)2018-04-302019-10-18Data-determinant query terms

Country Status (1)

CountryLink
US (2)US11573955B1 (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
US12124460B2 (en)*2022-12-012024-10-22Sap SeDeep mining of enterprise data sources

Families Citing this family (8)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
US20210303793A1 (en)*2020-03-252021-09-30At&T Intellectual Property I, L.P.Root cause classification
US11770377B1 (en)*2020-06-292023-09-26Cyral Inc.Non-in line data monitoring and security services
US12321428B2 (en)*2021-07-082025-06-03Nippon Telegraph And Telephone CorporationUser authentication device, user authentication method, and user authentication computer program
EP4394760A4 (en)*2021-12-012024-11-27Samsung Electronics Co., Ltd. ELECTRONIC DEVICE AND METHOD FOR PROVIDING A LIST OF RECOMMENDED STATEMENTS
US12229081B2 (en)*2022-01-212025-02-18Dell Products, L.P.Extending filesystem domains with a domain membership condition
US12418545B1 (en)*2022-05-272025-09-16United Services Automobile Association (Usaa)Test data management ecosystem
US12332939B2 (en)*2022-06-242025-06-17Adobe Inc.Virtual knowledge graph construction for zero-shot domain-specific document retrieval
US11809508B1 (en)*2023-06-152023-11-07Geodex Inc.Artificial intelligence geospatial search

Citations (4)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
US20130191409A1 (en)*2012-01-192013-07-25Alibaba Group Holding LimitedIntelligent navigation of a category system
US9753974B2 (en)*2012-05-182017-09-05Splunk Inc.Flexible schema column store
US20180241819A1 (en)*2017-02-212018-08-23Level 3 Communications, LlcSystems and methods for content origin administration
US20190171751A1 (en)*2017-12-052019-06-06Oracle International CorporationContext-sensitive data retrieval and conversion

Family Cites Families (56)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
US5742809A (en)1990-08-311998-04-21Fujitsu LimitedDatabase generic composite structure processing system
FI91456C (en)1992-07-291994-06-27Nokia Telecommunications Oy A method for managing the resources allocated on a computer
US5963932A (en)1997-04-291999-10-05Oracle CorporationMethod and apparatus for transforming queries
US5895465A (en)*1997-09-091999-04-20Netscape Communications Corp.Heuristic co-identification of objects across heterogeneous information sources
US6009422A (en)1997-11-261999-12-28International Business Machines CorporationSystem and method for query translation/semantic translation using generalized query language
US6134559A (en)1998-04-272000-10-17Oracle CorporationUniform object model having methods and additional features for integrating objects defined by different foreign object type systems into a single type system
US6519603B1 (en)1999-10-282003-02-11International Business Machine CorporationMethod and system for organizing an annotation structure and for querying data and annotations
US20020029207A1 (en)2000-02-282002-03-07Hyperroll, Inc.Data aggregation server for managing a multi-dimensional database and database management system having data aggregation server integrated therein
US6925457B2 (en)2001-07-272005-08-02Metatomix, Inc.Methods and apparatus for querying a relational data store using schema-less queries
US7526425B2 (en)2001-08-142009-04-28Evri Inc.Method and system for extending keyword searching to syntactically and semantically annotated data
US7895191B2 (en)2003-04-092011-02-22International Business Machines CorporationImproving performance of database queries
US20050165761A1 (en)2004-01-222005-07-28Chan Eric J.Method and apparatus for data processing and retrieval
US7606791B2 (en)2004-06-032009-10-20International Business Machines CorporationInternal parameters (parameters aging) in an abstract query
US9256685B2 (en)2005-03-312016-02-09Google Inc.Systems and methods for modifying search results based on a user's history
US7937344B2 (en)2005-07-252011-05-03Splunk Inc.Machine data web
US8225294B2 (en)2006-04-272012-07-17Oracle America, Inc.Method and apparatus for expressing and checking relationships between types
US7979453B2 (en)2006-08-232011-07-12Innovative Solutions, Inc.Efficient search result update mechanism
EP2074505A4 (en)2006-10-052010-01-13Splunk IncTime series search engine
US8145677B2 (en)2007-03-272012-03-27Faleh Jassem Al-ShameriAutomated generation of metadata for mining image and text data
US8396846B2 (en)2007-12-132013-03-12International Business Machines CorporationDatabase trigger modification system and method
US9760612B2 (en)2008-02-262017-09-12Ab Initio Technology, LlcGraphic representations of data relationships
US8423534B2 (en)2008-11-182013-04-16Teradata Us, Inc.Actively managing resource bottlenecks in a database system
CA2709498A1 (en)2009-07-102011-01-10Xkoto Inc.System and method for subunit operations in a database
US20120239681A1 (en)2011-03-142012-09-20Splunk Inc.Scalable interactive display of distributed data
US9244956B2 (en)2011-06-142016-01-26Microsoft Technology Licensing, LlcRecommending data enrichments
US8983954B2 (en)2012-04-102015-03-17Microsoft Technology Licensing, LlcFinding data in connected corpuses using examples
US9130971B2 (en)2012-05-152015-09-08Splunk, Inc.Site-based search affinity
US20140040710A1 (en)2012-08-052014-02-06Stanley Benjamin SmithSystem for setting fees for iterative parsing, matching, and correlation of sets of text strings drawn from real time crowd-sourced streamed data and using said matches to initiate APIs or trigger alerts to participants in a crowd sourced pervasive computing environment.
US8788525B2 (en)2012-09-072014-07-22Splunk Inc.Data model for machine data for semantic search
WO2014052977A1 (en)2012-09-282014-04-03Oracle International CorporationAdaptive query optimization
US8805835B2 (en)2012-12-202014-08-12Clipcard Inc.Systems and methods for integrated management of large data sets
US9213726B2 (en)2013-04-152015-12-15Amazon Technologies, Inc.Database cost tracing and analysis
US10235391B2 (en)2013-06-182019-03-19Change Healthcare Holdings, LlcMethod and apparatus for implementing dynamic database traversal
US9215240B2 (en)2013-07-252015-12-15Splunk Inc.Investigative and dynamic detection of potential security-threat indicators from events in big data
US9430523B2 (en)2013-09-062016-08-30Sap SeEntity-relationship model extensions using annotations
US10127258B2 (en)2014-09-302018-11-13Splunk Inc.Event time selection output techniques
US9245057B1 (en)2014-10-092016-01-26Splunk Inc.Presenting a graphical visualization along a time-based graph lane using key performance indicators derived from machine data
US10037331B2 (en)2015-01-302018-07-31Splunk Inc.Source type management
US10459881B2 (en)2015-02-272019-10-29Podium Data, Inc.Data management platform using metadata repository
US9348880B1 (en)*2015-04-012016-05-24Palantir Technologies, Inc.Federated search of multiple sources with conflict resolution
US20170168881A1 (en)2015-12-092017-06-15Sap SeProcess chain discovery across communication channels
US11422898B2 (en)2016-03-252022-08-23Netapp, Inc.Efficient creation of multiple retention period based representations of a dataset backup
US10496605B2 (en)2016-04-292019-12-03Splunk Inc.Application deployment for data intake and query system
US10204032B2 (en)2016-05-272019-02-12Accenture Global Solutions LimitedGenerating test data from samples using natural language processing and structure-based pattern determination
US10691710B2 (en)2016-06-192020-06-23Data.World, Inc.Interactive interfaces as computerized tools to present summarization data of dataset attributes for collaborative datasets
US11157498B1 (en)2016-09-262021-10-26Splunk Inc.Query generation using a dataset association record of a metadata catalog
US11093564B1 (en)2016-09-262021-08-17Splunk Inc.Identifying configuration parameters for a query using a metadata catalog
US10606857B2 (en)2016-09-262020-03-31Splunk Inc.In-memory metrics catalog
US10528440B2 (en)2016-11-282020-01-07Sap SeMetadata cataloging framework
US10481766B2 (en)2017-02-102019-11-19Microsoft Technology Licensing, LlcInterfaces and methods for generating and applying actionable task structures
US11074267B2 (en)2017-03-202021-07-27Sap SeStaged approach to automatic data discovery and performance
US10268688B2 (en)2017-05-032019-04-23International Business Machines CorporationCorpus-scoped annotation and analysis
US10855793B2 (en)2017-09-252020-12-01Splunk Inc.Proxying hypertext transfer protocol (HTTP) requests for microservices
US11238049B1 (en)2018-04-302022-02-01Splunk Inc.Revising catalog metadata based on parsing queries
US11392578B1 (en)2018-04-302022-07-19Splunk Inc.Automatically generating metadata for a metadata catalog based on detected changes to the metadata catalog
US11216516B2 (en)2018-06-082022-01-04At&T Intellectual Property I, L.P.Method and system for scalable search using microservice and cloud based search with records indexes

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
US20130191409A1 (en)*2012-01-192013-07-25Alibaba Group Holding LimitedIntelligent navigation of a category system
US9753974B2 (en)*2012-05-182017-09-05Splunk Inc.Flexible schema column store
US20180241819A1 (en)*2017-02-212018-08-23Level 3 Communications, LlcSystems and methods for content origin administration
US20190171751A1 (en)*2017-12-052019-06-06Oracle International CorporationContext-sensitive data retrieval and conversion

Cited By (1)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
US12124460B2 (en)*2022-12-012024-10-22Sap SeDeep mining of enterprise data sources

Also Published As

Publication numberPublication date
US11573955B1 (en)2023-02-07

Similar Documents

PublicationPublication DateTitle
US11720537B2 (en)Bucket merging for a data intake and query system using size thresholds
US11968101B1 (en)Remote custom code pre-loading for hybrid playbook execution
US12026155B2 (en)Executing one query based on results of another query
US12093318B2 (en)Recommending query parameters based on tenant information
US11880558B1 (en)Interface layout profiles including interface actions in an information technology and security operations application
US11327992B1 (en)Authenticating a user to access a data intake and query system
US11113294B1 (en)Recommending query templates during query formation
US11620288B2 (en)Dynamically assigning a search head to process a query
US11263268B1 (en)Recommending query parameters based on the results of automatically generated queries
US11657057B2 (en)Revising catalog metadata based on parsing queries
US11216511B1 (en)Executing a child query based on results of a parent query
US11604799B1 (en)Performing panel-related actions based on user interaction with a graphical user interface
US11416465B1 (en)Processing data associated with different tenant identifiers
US11157497B1 (en)Dynamically assigning a search head and search nodes for a query
US11636128B1 (en)Displaying query results from a previous query when accessing a panel
US11620303B1 (en)Security essentials and information technology essentials for a data intake and query system
US11516069B1 (en)Aggregate notable events in an information technology and security operations application
US11799798B1 (en)Generating infrastructure templates for facilitating the transmission of user data into a data intake and query system
US12332999B1 (en)Expediting processing of events based on a specified duration
US11392578B1 (en)Automatically generating metadata for a metadata catalog based on detected changes to the metadata catalog
US20230161760A1 (en)Applying data-determinant query terms to data records with different formats
US12164889B1 (en)Selecting a custom function from available custom functions to be added into a playbook
US12045201B1 (en)Automatically configuring connectors of an information technology and security operations application
US11895126B1 (en)Analyzing data across tenants of an information technology (IT) and security operations application
US11916929B1 (en)Automatic assignment of incidents in an information technology (IT) and security operations application

Legal Events

DateCodeTitleDescription
STPPInformation on status: patent application and granting procedure in general

Free format text:DOCKETED NEW CASE - READY FOR EXAMINATION

ASAssignment

Owner name:SPLUNK INC., CALIFORNIA

Free format text:ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:JAMES, ALEXANDER DOUGLAS;PETERS, ANDREW;RAMANI, ARUN;REEL/FRAME:063023/0543

Effective date:20191119

STPPInformation on status: patent application and granting procedure in general

Free format text:NON FINAL ACTION MAILED

STPPInformation on status: patent application and granting procedure in general

Free format text:RESPONSE TO NON-FINAL OFFICE ACTION ENTERED AND FORWARDED TO EXAMINER

STPPInformation on status: patent application and granting procedure in general

Free format text:FINAL REJECTION MAILED

ASAssignment

Owner name:SPLUNK LLC, CALIFORNIA

Free format text:CHANGE OF NAME;ASSIGNOR:SPLUNK INC.;REEL/FRAME:069826/0065

Effective date:20240923

STPPInformation on status: patent application and granting procedure in general

Free format text:DOCKETED NEW CASE - READY FOR EXAMINATION

ASAssignment

Owner name:SPLUNK LLC, CALIFORNIA

Free format text:CHANGE OF NAME;ASSIGNOR:SPLUNK INC.;REEL/FRAME:072170/0599

Effective date:20240923

Owner name:CISCO TECHNOLOGY, INC., CALIFORNIA

Free format text:ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:SPLUNK LLC;REEL/FRAME:072173/0058

Effective date:20250722


[8]ページ先頭

©2009-2025 Movatter.jp