Patents Issued in April 19, 2018
-
Publication number: 20180107671Abstract: A data processing system and method include processing circuitry configured to receive sensor data from a plurality of field devices and convert the sensor data to field data, receive a first source file having first field data exported from a first editor, receive a second source file having second field data exported from a second editor, filter the first and second field data according to one or more conditions, generate multiple worksheets based upon the one or more conditions of the filtered first and second field data, extract the filtered first and second field data from source fields of the first source file and the second source file and map the extracted first and second field data into related worksheet fields of the multiple worksheets, and export the multiple worksheets having the mapped and extracted first and second field data in an export file.Type: ApplicationFiled: October 17, 2016Publication date: April 19, 2018Applicant: Yokogawa Electric CorporationInventors: Haydee Lavisores PleƱos, Acelython Ordillo Navarro, Ying Tzu Huang
-
Publication number: 20180107672Abstract: A method of and apparatus for content assembly is provided by which an automation playlist of media events is created and published as a podcast. The publishing includes a podcast automation interface defining: a web syndication format, one or more RSS (Really Simple Syndication) channels for the publishing of the podcast, one or more RSS (Really Simple Syndication) variables for the publishing of the podcast, a podcast feed, wherein the podcast automation interface is used to create or update a local copy of one or more of: an RSS file or a web feed and distribute the podcast over a network.Type: ApplicationFiled: December 19, 2017Publication date: April 19, 2018Applicant: iHeartMedia Management Services, Inc.Inventors: David C. Jellison, JR., Shawn Coffman, Dustin Bond
-
Publication number: 20180107673Abstract: A video ingest, search and delivery solution is provided in which videos and their associated metadata are ingested based on ingest criteria. Moments in the metadata are identified by parsing comments in the metadata for comments that reference a time in the video. Moments are recorded with the referenced time and the text of the comment. Videos are rated and may be delivered to users based at least in part on the rating. Moments may be displayed together with the video by displaying the text of moments at the associated time in the video as the video is being delivered. The text of moment records may be searched based on search parameters received form a user to identify videos to deliver to the user.Type: ApplicationFiled: October 6, 2017Publication date: April 19, 2018Applicant: Unreel Entertainment LLCInventors: DANIEL GOIKHMAN, KRISHNA ARVAPALLY, LATHA MADURI DODDIKADI, AKSHAY ARVAPALLY
-
Publication number: 20180107674Abstract: Systems, computer-readable mediums, and methods are configured to receive a first request to write a first data block to a solid state storage device. A second request is received to associate the first data block with a first snapshot identifier (ID). The first data block is stored on the solid state storage device in response to the first request. The first data block is stored on a first segment of a plurality of physical segments of memory on the solid state storage device. A first data pointer that corresponds to the first snapshot ID is generated in response to the second request. The first data pointer points to the first data block stored on the solid state storage device.Type: ApplicationFiled: October 17, 2016Publication date: April 19, 2018Inventors: Jared Cantwell, Saxon Parker
-
Publication number: 20180107675Abstract: A communication system includes a recording medium and a recording device that writes file data into the recording medium. The recording medium includes a storage that stores configuration information as management information about a file system of the recording medium, and a configuration information updating unit that updates the configuration information. The recording device includes an updating instruction unit that transmits an updating instruction for updating the configuration information based on the file data, to the recording medium, an acquisition unit that acquires the configuration information after transmission of the updating instruction, and a writing unit that writes the file data into the storage based on the configuration information acquired by the acquisition unit.Type: ApplicationFiled: December 18, 2017Publication date: April 19, 2018Inventors: Nobuhiko ARASHIN, Takuji MAEDA, Akira YAMASAKI
-
Publication number: 20180107676Abstract: A method of operating a database system to select multiple files distributed across a plurality of file folders is disclosed. The method generates a first graphical user interface formatted for presentation at a client device and having a first list of selectable files contained in a first file folder maintained by the database system. A first user input is received that identifies at least one selected file from the first list of selectable files, and the database system generates a second graphical user interface formatted for presentation at the client device and having a second list of selectable files contained in a second file folder. A second user input is received that identifies at least one selected file from the second list of selectable files. The database system performs an action involving the selected files from the first list and involving the selected files from the second list.Type: ApplicationFiled: October 17, 2016Publication date: April 19, 2018Applicant: salesforce.com, inc.Inventor: Darshil Vipul Vora
-
Publication number: 20180107677Abstract: In a high insert throughput in a database system, the database management system (DBMS) caches, asynchronously from data insert transactions, a list of storage location identifiers for storage locations in a table space in the database system. When a request for an insert transaction with an insert size is received from an agent, the DBMS identifies a storage location on the list with an amount of free space meeting the insert size. The DBMS removes the storage location identifier from the list and returns the storage location identifier for the storage location. When the insert transaction completes, the DBMS determines a remaining free space at the storage location and adds the storage location identifier to the list according to the remaining free space. By removing storage location identifiers from the list, another agent cannot receive the same storage location identifier for a parallel task. Thus, space contention is avoided.Type: ApplicationFiled: October 16, 2016Publication date: April 19, 2018Inventors: Oliver DRAESE, Robert W. LYLE, Kalpana SHYAM, George F. WANG, Julie A. WATTS, Shirley ZHOU
-
Publication number: 20180107678Abstract: An approach to de-duplicating data in an electronic text repository by performing the following steps: (i) processing one or more text documents associated with an electronic text repository to identify first instances of a plurality of words; (ii) adding words associated with the identified first instances of the plurality of words to a list, wherein each word added to the list is assigned a unique serial number; and (iii) replacing the plurality of words included in the one or more text documents with serial numbers corresponding to the words associated with the list for generating one or more reduced documents.Type: ApplicationFiled: October 13, 2016Publication date: April 19, 2018Inventors: Olympia Gluck, Itzhack Goldberg, Harry R. McGregor, Christopher B. Moore, Neil Sondhi
-
Publication number: 20180107679Abstract: A cluster file replication system is provided. Each controller of the plurality of controllers is configured to access a filesystem having a plurality of files including a system database of a controller having state information of the plurality of controllers. Each controller is further configured to have one or more service agents. The one or more service agents of each controller is configured to respond to one of the plurality of controllers becoming a master controller of the cluster. The one or more service agents of each controller is configured to set up one or more objects that react to the state information and coordinate replication of changes to the files, system database and state information from the master controller to follower controllers in the cluster. The one or more objects on each of the follower controllers is supportive of the follower controllers receiving the changes but disabled from initiating the replication. A method for cluster file replication is also provided.Type: ApplicationFiled: October 18, 2016Publication date: April 19, 2018Inventors: Gagandeep Arneja, Justin Costa-Roberts, Andre Pech, Hua Zhong, Arturo Escaip
-
Publication number: 20180107680Abstract: A computer-implemented method for transferring a reserve to a target host, according to one embodiment, includes granting to a source system, by a control unit, a reserve for a volume of a storage device. A push reserve command is received from the source system. The push reserve command specifies: a transfer of the reserve to a target system, parameter data identifying the target system, and path information specifying the source system. The reserve is transferred only to the target system in response to release of the reserve by the source system.Type: ApplicationFiled: December 14, 2017Publication date: April 19, 2018Inventors: Susan K. Candelaria, Mark P. Gardiner, Clint A. Hardy, Matthew J. Kalos, William R. White, Stephen G. Wilkins, Harry M. Yudenfriend
-
Publication number: 20180107681Abstract: A system and method for outputting weather data associated with a user-specified location based on a user-specified weather inquiry, including weather data output based on user-specified weather conditions, locations output based on a user-specified weather inquiry, notifications output regarding weather-related warnings, and notifications output based on weather-related notification thresholds.Type: ApplicationFiled: December 15, 2017Publication date: April 19, 2018Applicant: Accuweather, Inc.Inventors: R. Lee Rainey, Bill Vincent, Casey McGeever, Michelle L. Massung, Gregg Pavlik
-
Publication number: 20180107682Abstract: Example embodiments that analyze images to categorize images cluster the images within a same category. Images with mutual semantic similarity are in a same cluster. When an input image is compared to multiple clusters within a same category, there is an increased likelihood of accurate categorization of the input image.Type: ApplicationFiled: October 16, 2016Publication date: April 19, 2018Applicant: eBay Inc.Inventors: Qiaosong Wang, Robinson Piramuthu
-
Publication number: 20180107683Abstract: A method includes obtaining from an online social media site a plurality of instances of images of objects associated with a person; analyzing with a data processor the plurality of instances of the images with a plurality of predetermined style classifiers to obtain a score for each image for each style classifier; and determining with the data processor, based on the obtained scores, a likely preference of the person for a particular style of object. The plurality of instances of images of objects associated with the person can be images that were posted, shared or pinned by person, and images that the person expressed a preference for. In a non-limiting embodiment the object is clothing, and the style can include a fashion style or fashion genre including color preferences. A system and a computer program product to perform the method are also disclosed.Type: ApplicationFiled: December 14, 2017Publication date: April 19, 2018Inventors: Richard T. Goodwin, Pu Huang, Ying Li
-
Publication number: 20180107684Abstract: Example embodiments that analyze images to characterize aspects of the images rely on a same neural network to characterize multiple aspects in parallel. Because additional neural networks are not required for additional aspects, such an approach scales with increased aspects.Type: ApplicationFiled: October 16, 2016Publication date: April 19, 2018Applicant: eBay Inc.Inventors: Mohammadhadi Kiapour, Ajinkya Gorakhnath Kale, Robinson Piramuthu, Licheng Yu
-
Publication number: 20180107685Abstract: Systems, methods, and computer program products for identifying a candidate product in an electronic marketplace based on a visual comparison between candidate product image visual content and input query image visual content. Embodiments generate and store descriptive image signatures from candidate product images or selected portions of such images. A subsequently calculated visual similarity measure serves as a visual search result score for the candidate product in comparison to an input query image. Any number of images of any number of candidate products may be analyzed, such as for items available for sale in an online marketplace. Image analysis results are stored in a database and made available for subsequent automated on-demand visual comparisons to an input query image. The embodiments enable substantially real time visual based product searching of a potentially vast catalog of items.Type: ApplicationFiled: October 16, 2016Publication date: April 19, 2018Applicant: eBay Inc.Inventors: Ajinkya Gorakhnath Kale, Fan Yang, Qiaosong Wang, Mohammadhadi Kiapour, Robinson Piramuthu
-
Publication number: 20180107686Abstract: The present disclosure discloses a search method and apparatus. A specific implementation of the method comprises: receiving first information for searching, the first information for searching comprising an image for searching; determining an image attribute tag selected by a selection operation as being second information for searching in response to detecting the selection operation of the preset image attribute tag, the image attribute tag being used for indicating an attribute of the image; sending the received first information for searching and the determined second information for searching to a server, so that the server conducts a search according to the first information for searching and the second information for searching to obtain and send a first image search result; and receiving and displaying the first image search result sent by the server. This implementation improves the search efficiency.Type: ApplicationFiled: June 6, 2017Publication date: April 19, 2018Inventor: Hui QI
-
Publication number: 20180107687Abstract: A method includes: recognizing, based on a taken image obtained by taking an image of an object, a description of an attribute of the object and the type of act of the object; storing the recognized description of the attribute of the object and type of act of the object in a database; judging whether the frequency of occurrence of an act of the recognized type is less than a previously set threshold value by referring to the database; and outputting, if a judgment is made that the frequency of occurrence is less than the threshold value, an instruction to create, as learning data, computer graphics (CG) data describing a state in which the object having the attribute whose description is different from the recognized description of the attribute is doing the act of the recognized type based on the taken image.Type: ApplicationFiled: September 22, 2017Publication date: April 19, 2018Inventors: TORU TANIGAWA, YUKIE SHODA, TETSUJI FUCHIKAMI
-
Publication number: 20180107688Abstract: Example embodiments of the present disclosure include a system comprising a computer-readable storage medium storing at least one program and a computer-implemented method for providing an image appended search string. In example embodiments, a selection of an image is received. The image is a search result from a plurality of search results obtained based on a matching process performed on a current search string. A keyword corresponding to the selected image is determined. The keyword corresponding to the selected image is appended to the current search string. The plurality of search results is refined based on the appending of the keyword. The refined search results are then caused to be presented.Type: ApplicationFiled: December 19, 2017Publication date: April 19, 2018Inventors: Michael George Lenahan, Ben Mitchell, R. J. Pittman, Dave Lippman
-
Publication number: 20180107689Abstract: This disclosure relates to a system for acquiring and sharing annotations of images over a network based on fingerprint identification techniques for digital images. The system allows users to annotate images found on the network that are not controlled by the user. Annotations are stored on a database, thereby allowing multiple users to access to all annotations associated with that image. The database includes a āfingerprint valueā that is associated with each image, and which allows the image to be identified when viewed, regardless of that image's URL or website location. The complete annotation data for the image being viewed may then be presented to the viewer of the image in a website browser or other viewing application.Type: ApplicationFiled: October 16, 2017Publication date: April 19, 2018Inventors: Andrew Grossman, Tom Marlin
-
Publication number: 20180107690Abstract: An approach for enabling collaborative development of a database application is provided. Specifically, this approach provides a database development and collaboration tool (DDCT), which can be utilized by multiple developers involved in a particular software project, to enable automated synchronization and database version control by allowing a database development language and data changes to be stored in a metadata form that is general to more than one database management system (DBMS). Each developer is united and able to collaborate through the system, thus ensuring that a change to a database structure and/or data in a static data table created in a particular database language by one developer is automatically incorporated in the overall development process. Furthermore, the DDCT provides the opportunity to maintain a single repository entry for more than one DBMS, which simplifies synchronization.Type: ApplicationFiled: December 11, 2017Publication date: April 19, 2018Inventors: Marina A. Greenstein, Galina Grunin, Maria N. Schwenger, Pandikumar Swamikrishnan
-
Publication number: 20180107691Abstract: Aspects of a multi-level electrical distribution control system associated with an electrical distribution grid are disclosed. Data access and processing across the multi-level control system and the electrical distribution grid can provide improved utilization of energy within the electrical distribution grid. Further, dynamic reconfiguration of the electric distribution grid can be based distributed processing and access to information relating to the electrical distribution control system or electrical distribution grid. An encapsulated DNNC data element is disclosed as an efficient and secure means of accessing data across the multi-level electrical distribution control system or the associated electrical distribution grid.Type: ApplicationFiled: December 15, 2017Publication date: April 19, 2018Inventors: Ethan Clair Boardman, Subrahmanyam Saraswati Venkata
-
Publication number: 20180107692Abstract: A computer-implemented method, system, and computer program product are described for initiating and displaying, at a user interface, an editor adapted to generate a plurality of configuration models, receiving a selection of at least one country from a plurality of countries. The method can include retrieving a data model and reference data associated with the at least one country, populate a plurality of attributes from the data model in the user interface and populating a plurality of selectable input mappings in the user interface. The method may also include populating a plurality of selectable output mappings in the user interface and generating at least one configuration model, in response to receiving at least one selection for the input mappings and at least one selection for the output mappings.Type: ApplicationFiled: October 17, 2016Publication date: April 19, 2018Inventors: Ronald Dupey, Jeffrey Woody, Ryan Champlin
-
Publication number: 20180107693Abstract: A data archive constructed from source data, whose structure and associated schemas can evolve based on the generated responses to user data requests. Based on the analysis of the responses, the schema and/or archive structure can be modified to provide greater knowledge, definition and operations available to be performed on the data, as well as to reduce the processing and storage costs associated with housing and accessing the data within the archive.Type: ApplicationFiled: December 15, 2017Publication date: April 19, 2018Inventor: Eric Justin Kraemer
-
Publication number: 20180107694Abstract: A computer-implemented method for performing a data quality function includes receiving, at a data quality function process, at least one record from a source, where the record includes data, semantic annotations and data quality annotations associated with the data in the record. The semantic annotations are attributes that define the data including input format and output format and the data quality annotations are attributes that define data quality rules to be applied to the data. The data quality function process automatically maps the semantic annotations to data quality input fields and to data quality output fields. The data quality function process applies the data quality rules to the data using the data quality annotations to perform a data quality function. The data quality function process performs the data quality function on the data and outputs the data to a destination in a format defined by the data quality output fields.Type: ApplicationFiled: October 17, 2016Publication date: April 19, 2018Inventors: Ronald Dupey, Ryan Champlin
-
Publication number: 20180107695Abstract: The disclosure relates to technology for mining data in a database by recursively mining a conditional frequent pattern tree (FP-tree) for frequent items of each conditional pattern base for each node in an FP-tree to obtain frequent patterns. For each branch in the FP-tree, a single-item node table (NT) is generated for which a selected one of the frequent items appears in the node of the branch. The single-item NT including a list of all of the frequent items appearing in the FP-tree and a corresponding frequent item count. For each single-item NT of each branch generated for the selected one of the frequent items, the frequent item count of each frequent item is summed in the single-item NT formed for each branch to generate a combined single-item NT, and association rules based on the frequent patterns are generated for each of the frequent items and the combined single-item NT.Type: ApplicationFiled: October 19, 2016Publication date: April 19, 2018Applicant: Futurewei Technologies, Inc.Inventors: Kai Yang, Tao Quan, Yanjia Sun
-
Publication number: 20180107696Abstract: Systems, methods, and computer-readable media for determining column ordering of a data storage table for search optimization are described herein. In some examples, a computing system is configured to receive input containing statistics of a plurality of queries. The computing system can then determine a new column order (i.e., layout) based at least in part on the statistics. In some example techniques described herein, the computing system can determine the new column order based at least in part on the hardware components storing the data storage table, storage system parameters, and/or user preference information. Example techniques described herein can apply the new column order to data subsequently added to the data storage table. Example techniques described herein can apply the new column order to existing data in the data storage table.Type: ApplicationFiled: June 3, 2016Publication date: April 19, 2018Applicant: MICROSOFT TECHNOLOGY LICENSING, LLCInventors: Thomas MOSCIBRODA, Liang Jeff CHEN, Xiao HUANG, Ying YAN, Yueguo CHEN, Xudong ZHENG, Haoqiong BIAN
-
Publication number: 20180107697Abstract: Reverse database query mapping. A database query to be executed on a computing platform against a database managed by the computing platform is received. Query mapping information is stored in a memory system accessible to the one or more processors. A source query corresponding to a query identifier is retrieved in response to statistical analysis. One or more potential indexes are generated for use with the source query, wherein at least one of the one or more potential indexes can function to improve performance of the source query.Type: ApplicationFiled: October 17, 2016Publication date: April 19, 2018Inventors: Awais TARIQ, Rohitashva MATHUR, Arup DUTTA, Prem VEERAMANI, Jesse COLLINS
-
Publication number: 20180107698Abstract: Embodiments of methods, apparatuses, devices and/or systems for manipulating hierarchical sets of data are disclosed.Type: ApplicationFiled: November 2, 2017Publication date: April 19, 2018Inventors: Karl Schiffmann, Mark Andrews, Jack J. LeTourneau
-
Publication number: 20180107699Abstract: A table operation system capable of altering the configuration of a table such that a condition for obtaining easily analyzable information can be designated is provided. A data acquiring means 72 specifies individual tables to serve as reference destinations of designated respective foreign key columns and, for each combination of key values in primary key columns of the specified individual tables, acquires a total value of relation values in a designated relation value column. A grouping means 73 groups the respective key values in the primary key columns of the individual tables on the basis of the total value acquired for each combination of the key values in the primary key columns of the individual tables and a statistical model of a designated type. An attribute value column adding means 74 adds, to each individual table, an attribute value column of which attribute value is identification information on a group to which each key value in each primary key column of each individual table belongs.Type: ApplicationFiled: February 25, 2016Publication date: April 19, 2018Applicant: NEC CORPORATIONInventor: Shinji NAKADAI
-
Publication number: 20180107700Abstract: Data entities in a client-server system are accessed. The client-server system comprises a set of clients, a server system, and a repository for storing a plurality of data entities. The server system comprises an inter-transactional cache, the inter-transactional cache being accessible for each client of the set of clients. A first client of the set of clients comprises a first intra-transactional cache. If a copy of a first data entity is in the inter-transactional cache, a version identifier of the original first data entity is read from the repository. If the copy of the first data entity is to be accessed with an exclusive lock, a copy of the copy of the first data entity is added to the first intra-transactional cache. The copy of the copy of the first data entity in the first intra-transactional cache is accessed for further processing of the first data entity by the first client.Type: ApplicationFiled: December 13, 2017Publication date: April 19, 2018Inventors: FRANK NEUMANN, GERHARD PFAU
-
Publication number: 20180107701Abstract: A mechanism is provided for updating attribute value information for a data table. The data table involves a set of attributes. The data table has multiple records associated with multiple data blocks. Attribute value information is associated with each data block of the multiple data blocks. The attribute value information is descriptive of at least one attribute of the set of attributes. A first data block may be marked as modified in response to a delete process for deleting from a first data block of the multiple data blocks a record having at least one attribute value that is used for generating the attribute value information of the first data block. In response to scanning the marked first data block, the attribute value information associated with the first data block may be updated based on the scan results.Type: ApplicationFiled: October 17, 2016Publication date: April 19, 2018Inventors: Thomas F. Boehme, Andreas Brodt, Alexander Lang, Oliver Schiller
-
Publication number: 20180107702Abstract: In some embodiments, a system for automatically identifying synonyms within a token-based data management system includes a database configured to store a plurality of records, and a computing device having a synonym locator configured to create a token synonym mapping by automatically identifying token synonyms within the plurality of records based on a statistical analysis of the plurality of records. The token synonym mapping includes a first token linked to a second token, where the second token is a valid synonym of the first token. The computing device includes a synonym standardizer configured to standardize at least one record of the plurality of records based on the token synonym mapping such that, when the at least one record includes the second token, the synonym standardizer is configured to automatically replace the second token with the first token.Type: ApplicationFiled: October 14, 2016Publication date: April 19, 2018Inventors: Jim Havlicek, Tim Parker
-
Publication number: 20180107703Abstract: A method for maintaining consistency in distributed databases includes receiving, by a coordinator from an application server, a transaction initiation message for a transaction. Additionally, the method includes determining whether to generate a distributed transaction identifier (DXID) for the transaction, including determining whether the transaction will be performed on a single data node or on multiple data nodes, determining to generate the DXID in response to determining that the transaction will be performed on the multiple data nodes, and generating, by the coordinator, the DXID corresponding to the transaction in response to determining to generate the DXID for the transaction. The method also includes sending, by the coordinator directly to a first data node, the DXID, sending, by the coordinator directly to a second data node, the DXID, and performing the transaction using the DXID.Type: ApplicationFiled: December 8, 2016Publication date: April 19, 2018Inventor: Mason Sharp
-
Publication number: 20180107704Abstract: A data store maintaining data may implement reducing input/output (I/O) operations for on-demand data page generation. Log records may be maintained for data pages of data describing changes to the data pages. A coalesce operation may be performed when log records for a data page exceed a coalesce threshold for the data page, applying the log records for the data page to a version of the data page and creating a new version that includes the changes indicated by the log records. An indication may be received to increase the coalesce threshold for a particular data page, delaying to a coalesce operation for the data page according to the increased coalesce threshold. The indication may be received from a storage engine that identifies a delay for the particular data page.Type: ApplicationFiled: December 18, 2017Publication date: April 19, 2018Applicant: Amazon Technologies, Inc.Inventors: PRADEEP JNANA MADHAVARAPU, YAN VALERIE LESHINSKY
-
Publication number: 20180107705Abstract: The technology disclosed relates to creating and frequently updating multiple online analytic processing (OLAP) analytic databases from an online transaction processing (OLTP) transaction updatable system that includes transaction commit, rollback, and field level security capabilities. It also relates to transparently decoupling extraction from rebuilding of frequently updated OLAP analytic databases from the OLTP transaction updatable system.Type: ApplicationFiled: November 21, 2016Publication date: April 19, 2018Applicant: salesforce.com, inc.Inventors: Alex GITELMAN, Ravishankar ARIVAZHAGAN, Donovan SCHNEIDER, Alex FIELD, Pradeep MANTHA, Puneet GUPTA
-
Publication number: 20180107706Abstract: Techniques for determining the state of data in database applications are described herein. Changes made to a first entry in a database table are recorded and an aggregate change is determined based at least in part on a data type of a second entry associated with the first entry. The second entry is then updated based at least in part on the aggregate change.Type: ApplicationFiled: January 18, 2017Publication date: April 19, 2018Inventor: Shardool Mishra
-
Publication number: 20180107707Abstract: The subject matter of this specification can be implemented in, among other things, a method that includes receiving, by a processing device, one or more first content items for one or more first user accounts of a content sharing system. The method further includes storing the first content items at the content sharing system. The method further includes receiving, by the processing device, a second content item for a second user account of the content sharing system. The method further includes comparing, by the processing device, the received second content item to the stored first content items to determine that the second content item is not exclusive to the second user account. The method further includes restricting a privilege of the second user account for the second content item in response to the determination that the second content item is not exclusive to the second user account.Type: ApplicationFiled: December 15, 2017Publication date: April 19, 2018Inventors: Johan Georg Granstrƶm, Alexandru Tudor, Thomas Weich
-
Publication number: 20180107708Abstract: Data within a database object are accessed based on a query with a predicate including a plurality of conditional expressions. Elements of the database object are stored among a plurality of different storage regions along with range values for element values within each storage region. Each conditional expression of the query predicate is applied to the range values for each storage region to produce evaluation results of that conditional expression for each storage region. The evaluation result of each conditional expression for a corresponding storage region is combined to produce aggregated results for each of the storage regions, where the aggregated result for a corresponding storage region indicates results of a tri-state evaluation (e.g., true/false or unknown) of the conditional expressions for that storage region. One or more corresponding individual storage regions are scanned based on the aggregated results for those storage regions when the tri-state evaluation is unknown.Type: ApplicationFiled: December 15, 2017Publication date: April 19, 2018Inventor: Garth A. Dickie
-
Publication number: 20180107709Abstract: Methods and systems are described for providing an editor for modifying predefined data match policies. The methods and systems can receive search requests including search criteria and obtain data records and a plurality of respective data match policies for the data records that correspond to the search criteria. The methods and systems can display a first set of data records and a second set of data records. The first set of data records may match the search criteria and the second set of data records may be identified as a partial match to one or more data match policies associated with the first set of data records. The methods and systems can receive a request to modify a data match policy corresponding to at least one of the second set of data records and generate and display a plurality of suggestions for executing the at least one request.Type: ApplicationFiled: October 17, 2016Publication date: April 19, 2018Inventors: Mark Spiess, Jeffrey Woody, Prasanthi Thatavarthy, Ronald Dupey
-
Publication number: 20180107710Abstract: Embodiments of the present invention provide systems and methods for data management. Synopsis tables have been found to be more effective for maintaining a high level of system performance while answering analytical queries. Synopsis tables, which contain MAX, MIN, and Bloom filter columns, may be modified by dropping ineffective data content within these columns and regenerating dropped data when beneficial. By automatically modifying data, database queries may be optimized.Type: ApplicationFiled: December 18, 2017Publication date: April 19, 2018Inventors: Ian R. Finlay, Christian M. Garcia-Arellano, Adam J. Storm, Calisto P. Zuzarte
-
Publication number: 20180107711Abstract: A database query is received at a first time when a database is in a first state. The database query is analyzed to determine whether it has one or more characteristics that fall within a historical top range of database queries. If the database query falls within the historical top range of database queries the query is stored for later query tuning activity. The query is executed against the database in the first state. Query tuning recommendations are generated for stored database queries that fall within the historical top range of database queries. A subsequent request is received at a second time when a database is in a second state. The subsequent database query is executed with at least one of the query tuning recommendations against the database in the second state.Type: ApplicationFiled: October 17, 2016Publication date: April 19, 2018Inventors: AWAIS TARIQ, ROHITASHVA MATHUR, ARUP DUTTA, PREM VEERAMANI, JESSE COLLINS
-
Publication number: 20180107712Abstract: Techniques are described for managing exceptions occurring during query execution. Embodiments receive, from a requesting entity, a query for execution against a database. A first query plan for executing the query is generated, where the query plan comprises a first ordered sequence of operations to be performed in executing the query against the database. Embodiments determine a likelihood that the first query plan, if executed, will result in one or more exceptions being thrown and dynamically modify the first query plan based on the determined likelihood. The modified first query plan is executed against the database to produce a set of query results and the set of query results is returned to the requesting entity.Type: ApplicationFiled: October 13, 2016Publication date: April 19, 2018Inventors: Craig S. ALDRICH, Rafal P. KONIK, Roger A. MITTELSTADT, Brian R. MURAS, Jane A. VOLD
-
Publication number: 20180107713Abstract: Method, apparatus and article of manufacture for managing query execution. A query is received from a requesting entity for execution against a database. Embodiments execute the query to produce a set of query results, by initiating execution of a query plan for the query, catching, via an exception handler, a first one or more exceptions occurring while determining a first one or more query result rows and, after catching the first one or more exceptions, continuing execution of the query plan to produce an initial set of query results. The first one or more query result rows are added to an end of the initial set of query results, to produce the set of query results and the set of query results is returned to the requesting entity, where at least one erroneous query result row that was not omitted is appended to the end of the query results.Type: ApplicationFiled: October 13, 2016Publication date: April 19, 2018Inventors: Craig S. ALDRICH, Rafal P. KONIK, Roger A. MITTELSTADT, Brian R. MURAS, Jane A. VOLD
-
Publication number: 20180107714Abstract: Automated query tuning. A database query to be executed against a database is received. The database query is analyzed to determine one or more potential indexes to be evaluated. The one or more potential indexes are evaluated to determine if an optimization utilizing a selected potential index provides improved performance over performing the database query without the selected potential index. The one or more potential indexes are scored based on results of the evaluating. A recommendation of one or more of the potential indexes is provided to a source of the database query.Type: ApplicationFiled: October 17, 2016Publication date: April 19, 2018Inventors: Awais Tariq, Rohitashva MATHUR, Arup DUTTA, Prem VEERAMANI, Jesse COLLINS
-
Publication number: 20180107715Abstract: A technique includes determining a statistic for values associated with at least one column of a database based at least in part on a first sample of the values; and determining a degree of change in a second sample of the values relative to the first sample; and estimating a count of unique values for the column(s). The estimation of the count of unique values includes selectively incrementally updating the statistic using the second sample based at least in part on the determined degree of change; and basing estimation of the count at least in part on the updated statistic. The technique further includes processing a query to the database based at least in part on the count.Type: ApplicationFiled: April 29, 2015Publication date: April 19, 2018Inventors: QiFan Chen, Choudur Lakshminarayan
-
Publication number: 20180107716Abstract: A lower-dimensional representation (e.g., approximation) of a dataset is determined. The lower-dimensional representation can be used, for example, to perform semantic document analysis. Given a matrix of input data points, where each entry of the matrix indicates a number of times a particular term in a set of terms appears in a particular document in a set of documents, a lower-dimensional compressed matrix is obtained from the matrix by sampling rows of the matrix based on a target rank parameter, a desired accuracy tolerance, leverage scores calculated for the rows, and/or distances from rows of the matrix to a span of the initial set of sampled rows. The compressed matrix is used to determine a similarity metric indicative of a degree of similarity between documents. The documents can then be classified into a same document cluster or different clusters based on whether the similarity metric satisfied a threshold value.Type: ApplicationFiled: October 17, 2016Publication date: April 19, 2018Inventors: Kenneth L. Clarkson, David P. Woodruff
-
Publication number: 20180107717Abstract: Embodiments of the present disclosure include a method, a system, and a computer program product for determining wait times of tuples within a streaming environment. The method includes monitoring one or more tuples being processed within an operator graph where the operator graph includes a first processing element and a queue of the first processing element. The method includes recording a wait time of the one or more tuples within the queue of the first processing element. The method includes recording a processing time of the one or more tuples within the first processing element. The method includes displaying the wait time and the processing time of the one or more tuples. The method includes optimizing a configuration of the operator graph, in response to recording the processing time of the one or more tuples.Type: ApplicationFiled: December 18, 2017Publication date: April 19, 2018Inventors: Eric L. Barsness, Michael J. Branson, John M. Santosuosso
-
Publication number: 20180107718Abstract: Systems and methods include a processor; a memory comprising computer code executed using the processor, in which computer code implements a relational database to provide access to private user profile and private user data from a private data area and determines an access privilege; a custom response and notification generator configured to use the user profile data to retrieve historical user-related data; a compiling engine to select information from the retrieved historical user-related data to determine a public information source, wherein the retrieved historical user-related data are determined from prior stored user-related; a data handler to retrieve, from the public information source, some publicly-accessible information; and a video combination engine to combine information from the relational database and the publicly-available information and create a video using extracted publicly-accessible information, the private user data and create a publicly-accessible link to display a video.Type: ApplicationFiled: October 18, 2017Publication date: April 19, 2018Inventors: Frederick J. Federspiel, Howard Engelhart, Stephen Cooney
-
Publication number: 20180107719Abstract: Methods, systems, and computer program products for accessing data in a data structure are described. Data from a write data structure is read and aggregated into a plurality of data buckets, each data bucket corresponding to a time window. Each data bucket is stored in a read data structure.Type: ApplicationFiled: October 18, 2016Publication date: April 19, 2018Inventors: Zoltan Albrecht, Ulrich Hanno Peter Christoph Keil
-
Publication number: 20180107720Abstract: A computer-implemented method receives a search phrase from a client device and identifies a category of products that was previously assigned to the search phrase, wherein the category of products was previously assigned to the search phrase based on products selected by previous users who entered the search phrase. Search parameters associated with the category are retrieved and are used to control the content of a search result page that is formed in response to the received search phrase. The search result page is then returned to the client device.Type: ApplicationFiled: October 14, 2016Publication date: April 19, 2018Inventors: Christopher Edward Johnson, Dakota Reese Brown, Russell Roy Sanborn, Joseph Andrew Downing