Triggers, Stored Procedures, User Defined Function (udf) Patents (Class 707/702)
-
Patent number: 8498973Abstract: Making data available from a database is disclosed. Making data available includes specifying a query function having a query function name, wherein the query function includes a structure and a member, determining the structure and the member included in the query function, wherein the query function has a query function name and includes the structure and the member, creating an index for the structure on the member, and compiling the query function to be available to a user by invoking the query function name without the user having to specify the structure and the member. Retrieving data from a database is disclosed. Retrieving includes invoking a query function that specifies a plurality of structures and a value, accessing a cross index of the plurality of structures, and using the cross index to access the data.Type: GrantFiled: February 25, 2011Date of Patent: July 30, 2013Assignee: Infoblox Inc.Inventors: Srinath Gutti, Stuart M. Bailey, Ivan W. Pulleyn
-
Patent number: 8495042Abstract: Automatic information extraction apparatus for extracting data for review by a human curator from digital representations of documents comprising natural language text, the automatic information extraction apparatus having a plurality of selectable operating modes in which the automatic information extraction apparatus is operable to extract different data for review by a human curator. In the different operating modes, the information extraction apparatus may extract data with a different balance between recall and precision.Type: GrantFiled: October 10, 2008Date of Patent: July 23, 2013Assignee: ITI Scotland LimitedInventor: Beatrice Symington
-
Patent number: 8463754Abstract: There is provided electrical equipment which includes a macro file storage portion to store a macro file for acquiring log information under control of an operation system and log information outside control of the operation system at a time and a macro file executing portion to execute the macro file stored in the macro file storage portion and record log information obtained as a result of executing the macro file into a removable external recording medium.Type: GrantFiled: September 30, 2008Date of Patent: June 11, 2013Assignee: Sony CorporationInventor: Hirofumi Murakami
-
Publication number: 20130144852Abstract: A distributed event system for a relational database is disclosed. An event data model operatively describes a target database. For a subject entity in the target database, the event data model declares and defines triggering events and respective corresponding operations. An event engine monitors database queries and events involving the subject entity and determines from the event data model corresponding operations. Execution of the determined corresponding operations is distributed to network-based agents. Agents may be filtered based on skills and/or credentials injected at runtime. Code binaries of the operations are downloaded to the agents for execution.Type: ApplicationFiled: March 11, 2011Publication date: June 6, 2013Applicant: VMWARE, INC.Inventors: Leslie Muller, Michael Morris Wasser, Alberto Arias Maestro
-
Patent number: 8447744Abstract: A framework for extending the capabilities of an event processing system using one or more plug-in components referred to herein as data cartridges. Generally speaking, a data cartridge is a self-contained unit of data that can be registered with an event processing system and can store information pertaining to one or more objects (referred to herein as extensible objects) that are not natively supported by the system. Examples of such extensible objects can include data types, functions, indexes, data sources, and others. By interacting with a data cartridge, an event processing system can compile and execute queries that reference extensible objects defined in the data cartridge, thereby extending the system beyond its native capabilities.Type: GrantFiled: November 30, 2010Date of Patent: May 21, 2013Assignee: Oracle International CorporationInventors: Alexandre de Castro Alves, Anand Srinivasan, Hoyong Park, Shailendra Mishra
-
Patent number: 8447120Abstract: Described is a technology in which an image retrieval system is updated incrementally as new image data becomes available. Updating is incrementally performed and only triggered when the new image data is large enough or diverse enough relative to the image data currently in use for image retrieval. Incremental updating updates the leaf nodes of a vocabulary tree based upon the new image data. Each leaf node's feature frequency is evaluated against upper and/or lower threshold values, to modify the nodes of the tree based on the feature frequency. Upon completion of the incremental updating, a server that performed the incremental updating is switched to an active state with respect to handling client queries for image retrieval, and another server that was actively handling client queries is switched to an inactive state, awaiting a subsequent incremental updating before switching back to active state.Type: GrantFiled: October 4, 2008Date of Patent: May 21, 2013Assignee: Microsoft CorporationInventors: Rongrong Ji, Xing Xie
-
Patent number: 8443012Abstract: A system and method for dynamically retrieving, manipulating, updating, creating, and displaying data from sources of Extensible Markup Language (XML) documents. The program memory comprises system-user entered data definitions and business rules. The system imports XML document data into the system data definitions, processes the data using the business rules definitions and exports XML documents. The system can automatically create XML document formats from its data definitions and can automatically create its data definitions from XML document formats. The system-user can also define the mapping between XML document formats and the system data definitions. The system data definition is the combination of a Relational data model, an Object data model, and an XML data model.Type: GrantFiled: June 3, 2011Date of Patent: May 14, 2013Assignee: Yardley Benham and Rasch, LLCInventor: Richard William VanderDrift
-
Patent number: 8438141Abstract: Methods, systems and articles of manufacture are disclosed for providing secure access to data. Public UDTFs, private UDTFs and a metadata processor are utilized to facilitate secure access to data residing in a variety of data repositories.Type: GrantFiled: January 27, 2005Date of Patent: May 7, 2013Assignee: International Business Machines CorporationInventors: Douglas R. Fish, Hoa T. Tran, David A. Wall
-
Patent number: 8433679Abstract: The invention is a modular backup and retrieval system. The software modules making up the backup and retrieval system run independently, and can run either on the same computing devices or on different computing devices. The modular software system coordinates and performs backups of various computing devices communicating to the modules. At least one module on one of the computing devices acts as a system manager for a network backup regimen. A management component acts as a manager for the archival and restoration of the computing devices on the network. It manages and allocates library media usage, maintains backup scheduling and levels, and supervises or maintains the archives themselves through pruning or aging policies. A second software module acts as a manager for each particular library media.Type: GrantFiled: June 9, 2008Date of Patent: April 30, 2013Assignee: CommVault Systems, Inc.Inventors: John Crescenti, Srinivas Kavuri, David Alan Oshinsky, Anand Prahlad
-
Publication number: 20130091112Abstract: Embodiments provide an approach for efficiently searching a temporal key index as well as enforcing key distinctiveness property in a database table corresponding to the index. For example, by addressing time range overlaps in an index having a sort order for temporal keys, a database management tool of a server system may efficiently process client requests while enforcing a temporal key property in the database table.Type: ApplicationFiled: October 5, 2011Publication date: April 11, 2013Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Balakrishna R. IYER, Robert W. LYLE, Jerry MUKAI
-
Patent number: 8412821Abstract: A system and method provides dynamically selected media content to someone using an electronic device in a social network environment. Items of media content are selected for the user based on his or her relationships with one or more other users. The user's relationships with other users are reflected in the selected media content and its format. An order is assigned to the items of media content, for example, based on their anticipated importance to the user, and the items of media content are displayed to the user in the assigned order. The user may change the order of the items of media content. The user's interactions with media content available in the social network environment are monitored, and those interactions are used to select additional items of media content for the user.Type: GrantFiled: September 13, 2012Date of Patent: April 2, 2013Assignee: Facebook, Inc.Inventors: Mark Zuckerberg, Andrew Bosworth, Chris Cox, Ruchi Sanghvi, Matt Cahill
-
Patent number: 8402069Abstract: In accordance with one or more aspects, one or more portions of each of multiple files that have been freed are determined. One or more delete notifications are generated identifying the one or more portions of the multiple files. Each portion is identified as a range of data on a storage device, and each delete notification includes one or more ranges of data on the storage device. These generated delete notifications are then sent to a storage stack. Additionally, an application can determine that one or more ranges of data of a storage device are to be freed and send a delete notification, in the absence of a file system on the device, to the storage stack identifying the one or more ranges of data of the storage device that are to be freed.Type: GrantFiled: May 4, 2009Date of Patent: March 19, 2013Assignee: Microsoft CorporationInventors: Senthil Rajaram, Andrew Herron, Daniel W. H. Chan, Ravinder S. Thind
-
Patent number: 8396846Abstract: A method, apparatus and program product modify the behavior of a database trigger. An attribute desired by a user for a database trigger may be received. The attribute may relate to a change in the functionality of the trigger, such as a restriction on trigger behavior. An object that includes the attribute may be generated. The attribute may be associated with and applied to the trigger. In this manner, the attribute may be selectively applied to multiple triggers.Type: GrantFiled: December 13, 2007Date of Patent: March 12, 2013Assignee: International Business Machines CorporationInventors: Rafal Przemyslaw Konik, Mark William Theuer, Michael Alan Venz
-
Patent number: 8386541Abstract: Systems and methods for dynamically creating Entity-Specific Views from one or more Data Warehouses are provided. The system may involve multiple data sets within a Data Warehouse and may provide a Target Result data set which excludes fields of information not relevant to the desired view. The system may involve the use of derived fields and logical decision structures for the assignment of overriding boundary date information.Type: GrantFiled: September 16, 2008Date of Patent: February 26, 2013Assignee: Bank of America CorporationInventor: Carlton Merritt
-
Patent number: 8386448Abstract: Methods for providing a generic database security application using virtual private database (VPD) functionality are provided. The methods may include inserting rows into a user security table in a database providing VPD functionality, each row comprising a user ID for which database access is to be controlled, the name of a database object to be secured, and a predicate; and defining a security policy function common to all secured database objects, said security policy function generating a second predicate to be appended by the database's VPD functionality to queries made on a queried secured database object by a querying user, said second predicate based on at least one predicate in at least one row in the user security table, the at least one row referencing the name of the queried secured database object and the user ID of the querying user. Related systems and computer program products are also provided.Type: GrantFiled: November 30, 2009Date of Patent: February 26, 2013Assignee: AT&T Intellectual Property I, L.P.Inventors: James Pooley, Dhanshri Phondge
-
Patent number: 8370474Abstract: A method, device, and medium are provided for improving a user's Internet experience, comprising in one aspect, receiving, from a gateway, an indication of a reply from a content provider indicating an error requiring arbitration, determining, on the basis of an arbitration agreement, one or more remediation measures for the gateway to take in response to the error, the remediation measures selected from the set consisting of: passing the reply to the user unchanged, providing cached content to the user, rewriting the error reply to include a redirection to an alternate page, rewriting the error reply to include an alternate reply status code, providing a standardized error page in place of the error reply provided by the content provider, rejecting future requests sent to the content provider, and redirecting future requests sent to the content provider to an alternate content provider; and sending to the gateway an arbitration response including a remediation policy indicating the remediation measures.Type: GrantFiled: March 26, 2010Date of Patent: February 5, 2013Assignee: Sprint Communications Company L.P.Inventors: Raymond Emilio Reeves, Simon Youngs, Gary Duane Koller
-
Patent number: 8359297Abstract: A solution for managing data received from multiple sources is provided. In particular, when conflicting data values are received from multiple sources for a data element, a conflict rule is used to determine the main data value for the data element, which is subsequently stored for use. The conflict rule can define any automatic, semi-automatic, or manual procedure for resolving the conflict. The conflict rule, or an identifier thereof, can be stored with each data value and the main data value for the data element.Type: GrantFiled: June 29, 2006Date of Patent: January 22, 2013Assignee: International Business Machines CorporationInventors: Andrew J. Garrett, James A. Martin, Jr., Jeffrey E. Prince
-
Patent number: 8346743Abstract: A computer implemented method of adjusting a monitoring system having data collection nodes with instances of templates for collecting data according to data collection rules includes receiving a data propagation path specifying a hierarchy for at least a portion of the templates, the hierarchy specifying a child template, parent templates for the child template, and an order for the parent templates. The method also includes specifying an event data collection rule for the first child template and configuring parent data collection rules for the parent templates accordingly. The parent data collection rules include a data retrieval rule for retrieving event data associated with the event data collection rule or a data aggregation rule for combining the event data associated with the event data collection rule and multiple instances of the child template. The method also includes updating the instances in the data collection nodes.Type: GrantFiled: September 18, 2008Date of Patent: January 1, 2013Assignee: International Business Machines CorporationInventors: John C. Pfuntner, Isaac J. Graf
-
Patent number: 8335772Abstract: A method, system, and computer program for optimizing execution of a DML statement on a temporal database are disclosed. A first execution package is provided to an execution engine. The first execution package includes a plurality of operations to be executed if the contents of a row in a table in the temporal database indicate the row has a first temporal condition. A second execution package is provided to the execution engine. The second execution package includes a plurality of operations to be executed if the contents of the row in the table in the temporal database indicate the row has a second temporal condition. The execution engine is run to produce a result. The result is saved.Type: GrantFiled: November 12, 2008Date of Patent: December 18, 2012Assignee: Teradata US, Inc.Inventors: Bhashyam Ramesh, Manjula Koppuravuri
-
Patent number: 8332373Abstract: A database system constructs representation for predicate expressions invoking user-defined routines. A first representation is constructed if an indicator has a first value, and a second representation is constructed if the indicator has a second value. Based on which representation is used, an optimizer in the database system selects use of indexing and/or statistics and/or other performance-enhancement features in generating a query plan.Type: GrantFiled: December 18, 2002Date of Patent: December 11, 2012Assignee: Teradata US, Inc.Inventor: Gregory H. Milby
-
Patent number: 8332349Abstract: An audit system structured for auditing at least one operational table of a transaction system during an audit event is provided. In an embodiment, the audit system includes at least one audit history table operatively associated with the operational table of the transaction system, and each audit history table includes at least one database trigger configured for monitoring one or more data changes in the operational table. The database trigger generates an XML message for a monitored data change and transmits it to an SQL server service broker queue, which activates a procedure to transmit the message to at least one subscriber service broker queue, which activates an asynchronous data processing service for the monitored data change.Type: GrantFiled: January 6, 2012Date of Patent: December 11, 2012Assignee: Advent Software, Inc.Inventor: Thomas R. Wilson
-
Patent number: 8326813Abstract: A system, method, and computer program product for data transfer. The method includes receiving a request to transfer a principal object from a source location to a target location. The method also includes receiving at least one closure rule corresponding to the principal object, and transferring the principal object from the source location to be stored in the target location. The method also includes identifying at least one secondary object to be transferred with the principal object, according to the at least one closure rule. The method also includes selectively transferring the secondary object from the source location to be stored in the target location.Type: GrantFiled: January 20, 2010Date of Patent: December 4, 2012Assignee: Siemens Product Lifecycle Management Software, Inc.Inventors: Javeed Nizami, Reiner K. Kaiser
-
Patent number: 8321337Abstract: There are disclosed methods and systems for identifying an embedded device to a server system so as to provide an improved permission and billing relationship. The invention enables transaction activities by networked devices, each device being connectable to at least one server and associated with at least one stakeholder, wherein each device and each stakeholder has a unique identifier, and wherein there is provided a plurality of electronic certificates each owned by a stakeholder or on behalf of a device, the certificates being held on the at least one server and comprising a data structure which, when interpreted by the at least one server, determines whether a particular device acting on behalf of a particular stakeholder is entitled to carry out a transaction.Type: GrantFiled: July 8, 2002Date of Patent: November 27, 2012Assignee: Live Devices LimitedInventors: Peter Fenlon, Andrew Davies, Kenneth Tindall
-
Patent number: 8312140Abstract: A system and method provides dynamically selected media content to someone using an electronic device in a social network environment. Items of media content are selected for the user based on his or her relationships with one or more other users. The user's relationships with other users are reflected in the selected media content and its format. An order is assigned to the items of media content, for example, based on their anticipated importance to the user, and the items of media content are displayed to the user in the assigned order. The user may change the order of the items of media content. The user's interactions with media content available in the social network environment are monitored, and those interactions are used to select additional items of media content for the user.Type: GrantFiled: April 16, 2012Date of Patent: November 13, 2012Assignee: Facebook, Inc.Inventors: Mark Zuckerberg, Andrew Bosworth, Chris Cox, Ruchi Sanghvi, Matt Cahill
-
Patent number: 8306989Abstract: An embodiment relates to a novel apparatus and method for changing modes of notification in an electronic device. An electronic device includes a calendar application and a variety of other applications such as the message reader application or the daily alarm application. The device is configured to use the calendar application to track whether and how the user is notified of the receipt of an electronic message. In one embodiment, the user specifically associates a profile behavior to the calendar entry when the calendar entry is first created.Type: GrantFiled: October 13, 2010Date of Patent: November 6, 2012Assignee: Research In Motion LimitedInventors: David Yach, David Castell, Neil Adams, Michael K. Brown, Ian Patterson
-
Patent number: 8306959Abstract: Methods and systems for using algorithms in relational database management systems (RDBMSs) for incremental maintenance of materialized views with outerjoins are disclosed. The algorithms achieve the following goals with respect to a class of materialized outerjoin views and the performance of update operations: relax the requirement for the existence of the primary key attributes in a select list of the view to only some of the relations (i.e., the relations referenced as a preserved side in an outerjoin); relax null-intolerant property requirements for some predicates used in the view definition (i.e., predicates referencing relations which can be null-supplied by more than one outerjoin); and implement maintenance of outerjoin views by using one update statement (e.g., MERGE, UPDATE, INSERT, or DELETE) per view for each relation referenced in the view. The algorithms allow design and implementation of the incremental maintenance of materialized views with outerjoins to be integrated into an RDBMS.Type: GrantFiled: December 20, 2010Date of Patent: November 6, 2012Assignee: iAnywhere Solutions, Inc.Inventor: Anisoara Nica
-
Patent number: 8301603Abstract: Disclosed is a system in which an index registration unit registers an index, which will be used for search processing, as a partitioned index which is partitioned on a time series basis, and a search means reads indexes older than a specified point in time, which is used as a search base point, to perform search processing, thereby searching for information based on a point in time in the past.Type: GrantFiled: October 2, 2007Date of Patent: October 30, 2012Assignee: NEC CorporationInventors: Masaki Kan, Yoshihiro Kajiki, Satoshi Yamakawa, Takashi Torii, Yuji Kaneko
-
Patent number: 8301607Abstract: An embodiment of the invention includes an information management server with a registration unit that registers a status change condition of a database and a notification action so that they are associated with each other. Also, the information management server includes a communication unit that receives an acquisition request for a status change notification via database connection established with respect to a client and a change detection unit that detects a status change satisfying the condition of the acquisition request and invokes the notification action associated therewith. According to aspect of the invention, a notification unit causes the communication unit to send a notification including a result of the notification action via the database connection as a response to the acquisition request, and returns control of the connection to the client.Type: GrantFiled: July 15, 2009Date of Patent: October 30, 2012Assignee: International Business Machines CorporationInventors: Soh Kaijima, Gou Nakashima, Masahiro Okawa
-
Publication number: 20120265743Abstract: Processing is provided for operating an in-memory database, wherein transaction data is stored by a persistence buffer in an FIFO queue, and update processor subsequently: waits for a trigger; extracts the last transactional data associated with a single transaction of the in-memory database from the FIFO memory queue; determines if the transaction data includes updates to data fields in the in-memory database which were already processed; and if not, then stores the extracted transaction data to a store queue, remembering the fields updated in the in-memory database, or otherwise updates the store queue with the extracted transaction data. The process continues until the extracting is complete, and the content of the store queue is periodically written into a persistent storage device.Type: ApplicationFiled: April 10, 2012Publication date: October 18, 2012Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Natalia V. IVANOVA, Edward McCARTHY, Angel NUNEZ MENCIAS, Roland SEIFFERT
-
Patent number: 8280927Abstract: The present invention claims and discloses an electronic equipment capable of executing a processing executing program that performs a predetermined processing. The electronic equipment comprises a memory; a setting unit that sets an allocation time for a memory region in the memory that the processing executing program is to use; and a memory leak detecting unit that detects when the memory region has not been deallocated within the allocation time.Type: GrantFiled: September 4, 2008Date of Patent: October 2, 2012Assignee: KYOCERA Document Solutions Inc.Inventor: Toshiaki Ueno
-
Patent number: 8276194Abstract: Method and systems for user authentication are provided according to the embodiments of the invention. The method mainly includes: sending, by a management station, an authentication request message of an authentication protocol to a managed device via a management protocol, and sending user authentication information to the managed device; and authenticating the user by the managed device via the authentication protocol or a authentication server based on the received user authentication information, and returning an authentication acknowledgement message of the authentication protocol carrying the authentication result to the management station via the management protocol. The system mainly includes a management station and a managed device; or, a management station, a managed device and a backend authentication server. With the present invention, methods and systems for user authentication with a good extensibility and a widened application are provided.Type: GrantFiled: July 29, 2009Date of Patent: September 25, 2012Assignee: Huawei Technologies Co., Ltd.Inventors: Yuzhi Ma, Fuyou Miao
-
Patent number: 8271463Abstract: Methods, systems and articles of manufacture are provided for accessing data within data repositories. Public UDTFs, private UDTFs and a metadata processor are utilized to provide access to data residing in a variety of data repositories.Type: GrantFiled: December 28, 2004Date of Patent: September 18, 2012Assignee: International Business Machines CorporationInventors: Douglas R. Fish, Hoa T. Tran, David A. Wall
-
Patent number: 8266123Abstract: Navigating from an alert related to a state of a data object to a source of the alert includes displaying alerts in a portal environment. The portal environment has an analytical portal application associated with an analytical data store and a transaction portal application associated with a transaction data store. One of the alerts includes a transaction alert that is associated with a data object in the transaction data and another of the alerts includes an analytical alert that is associated with a data object. An indication of a transaction alert or an analytical alert is received from a user. When the indication is an indication of an analytical alert, navigation occurs to the analytical portal application. When the indication is an indication of the transaction alert, navigation occurs to the transaction portal application.Type: GrantFiled: June 18, 2004Date of Patent: September 11, 2012Assignee: SAP AGInventors: Marcus Dill, Stefan Zern, Roman Hayer, Wolfgang Meurer, Jens Weidner, Markus Kupke, Stefan Busch, Martin Diewald, Andre Wachholz-Prill
-
Patent number: 8260758Abstract: A method and system for performing at least one transaction on at least one column of a table in a database system is disclosed. The method includes determining whether a first transaction of the at least one transaction fulfills all of at least one criteria. The method further includes ensuring that the at least one column is in a shared numeric lock if the first transaction fulfills all of the at least one criteria, wherein the shared numeric lock is a lock that allows at least a second transaction fulfilling all of the at least one criteria to access the same column concurrently with the first transaction without releasing the shared numeric lock between transactions, and wherein the shared numeric lock is released only after all of the transactions fulfilling all of the criteria have completed processing. The method further includes processing the first transaction.Type: GrantFiled: October 10, 2008Date of Patent: September 4, 2012Assignee: SAP AGInventor: Konduru Israel Rajakumar
-
Publication number: 20120221536Abstract: a data transfer system and method are provided in the present invention. Wherein, the data transfer system and method comprises a source data obtaining service module and a target table updating service module, both of which are divided into a main part and an affiliated part, and wherein the affiliated part is a dynamic function library, which can package sub-processings such as source data obtaining, data transformation and data inserting/updating. Meanwhile, the data transfer system and method can support quasi real-time data transfer tasks and real-time data transfer tasks at the same time. The data transfer system and method support multi-computer disaster tolerance and extension, and the customization of the dynamic function library can facilitate the change in the requirements of data transfer.Type: ApplicationFiled: August 24, 2010Publication date: August 30, 2012Inventors: Lin Chen, Yuming Mao, Xiao Zhuang, Zhijun Lu, Yanming Yang, Mei Bai
-
Patent number: 8250045Abstract: The present system, software, and methods relate to computer system security, particularly to tracking and controlling electronic access to legacy applications and data records without modifying the legacy applications or records. The present system, software, and methods allow for implementation of complex access audit and control rules even when the continued use of legacy application and data are required.Type: GrantFiled: February 7, 2007Date of Patent: August 21, 2012Assignee: International Business Machines CorporationInventors: Chiang Kai Er, Chee Meng Low, Sharad Ganesh
-
Patent number: 8224797Abstract: A system and associated method for utilizing a record stored in a database. An application requests the record stored in the database to be validated. The method executes a query for retrieval and validation in a unified operation. A set of valid values for an attribute is stored in a configuration table per attribute. The query sets a null value for an attribute in the record that has an invalid value and produces a validated record. The method creates a data object with the validated record. The requester application utilized the data object having a respective value and a corresponding validity flag for each attribute.Type: GrantFiled: March 4, 2008Date of Patent: July 17, 2012Assignee: International Business Machines CorporationInventor: Macam S. Dattathreya
-
Patent number: 8219554Abstract: A computer implemented method, apparatus, and computer program product for generating receptivity cohorts. A receptivity cohort is identified. The receptivity cohort includes a set of members and conduct attributes for the set of members. Each conduct attribute in the set of conduct attributes describes at least one of a facial expression, vocalization, body language, and social interactions of a member in the set of members. Each conduct attribute is an indicator of receptiveness to a proposed future change in a set of circumstances associated with the set of members. Events metadata is received. The events metadata describes the set of circumstances associated with the set of members. The set of conduct attributes and the events metadata is analyzed to generate a receptivity score for the receptivity cohort. The receptivity score indicates a level of receptiveness of the set of members to the proposed future change in the set of circumstances.Type: GrantFiled: December 16, 2008Date of Patent: July 10, 2012Assignee: International Business Machines CorporationInventors: Robert Lee Angell, Robert R. Friedlander, James R. Kraemer
-
Patent number: 8214340Abstract: An observation system includes mechanisms for efficiently tracking the state of source components, which include functions, arguments, or values, etc. In one implementation, an observing component requests that a source component processes a request. The observation system then identifies all possible components in a dependency chain for the request, and all such components that are configured for change notifications. A dependency registry stores a representation of each identified component that is configured for change notifications. Any time any component configured for change notifications changes, including indirectly related components, the observing component can be immediately notified of the change, without having to reprocess the entire set of component dependencies.Type: GrantFiled: January 28, 2011Date of Patent: July 3, 2012Assignee: Microsoft CorporationInventors: Clemens A. Szyperski, Geoffrey M. Kizer, Joshua R. Williams, Anthony J. Moore
-
Publication number: 20120158679Abstract: A database trigger generates a return code having the effect of inhibiting further executions of the trigger within a pre-defined scope of execution. Preferably, the pre-defined scope is a task or process executing on behalf of a particular user. Upon first encountering the applicable trigger condition, the corresponding trigger is fired normally. Internal logic within the trigger determines whether it is necessary to call the same trigger again within the same scope, and if not, generates corresponding return data. A database management system which manages the trigger and causes it to automatically fire intercepts the return data and disables further firing of the trigger for the pre-defined scope.Type: ApplicationFiled: December 16, 2010Publication date: June 21, 2012Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventor: Mark J. Anderson
-
Publication number: 20120143837Abstract: A database program includes loose triggers that are not coupled to specific entities at the time the database program is compiled. The database program provides a user interface that allows a user to couple selected entities to the loose triggers or decouple selected entities from loose triggers. The database program validates the entities that are selected by the user for coupling or decoupling and stores the coupled entities as part of the loose trigger definitions in a loose trigger metadata database.Type: ApplicationFiled: November 4, 2011Publication date: June 7, 2012Applicant: salesforce.com, inc.Inventors: Avrom Irwin Roy-Faderman, Billy Ma
-
Patent number: 8185508Abstract: Techniques are disclosed for creating and using a filter index in order to identify registered queries whose result sets are likely to have been changed by changes made to tables. The filter index entries are based on filter conditions. The filter conditions are created based on predicates contained in the registered queries. The filter conditions may include exclusive predicates and join predicates. Join predicates that join a table T1 with a table T2 may be instantiated by replacing references to table T2 with values extracted from table T2. Various techniques are described for recognizing situations in which a query can be included in, or excluded from, the set of likely-changed queries, without fully evaluating the filter conditions that correspond to the queries.Type: GrantFiled: December 2, 2008Date of Patent: May 22, 2012Assignee: Oracle International CorporationInventors: Srinivas S. Vemuri, Atrayee Mullick, Bipul Sinha, Amit Ganesh, Dieter Gawlick
-
Publication number: 20120117041Abstract: This invention provides tools and methods for debugging a stored procedure in a database. The methods allow for debugging of the stored procedure even when it is invoked over a normal connection to a database management system, for example using ODBC. The developer can debug the stored procedure using an integrated development environment, including viewing the values of variables and the position of the execution pointer as the stored procedure executes. The invention also provides methods for allowing the developer for changing the source code of the stored procedure during debugging.Type: ApplicationFiled: November 8, 2010Publication date: May 10, 2012Applicant: VeriSign, Inc.Inventors: John Rodriguez, George Hillenbrand
-
Publication number: 20120109916Abstract: Various embodiments of the invention relate to an apparatus and a method of managing a snapshot storage pool (SSP) associated with a storage unit of a distributed data storage system. According to some embodiments of the invention, the apparatus may include a logic module and a processor. The logic module may be adapted to provide a threshold corresponding to a ratio between a current amount of storage resources used for storing snapshots in the SSP and a total storage capacity defined for the SSP. The processor may be adapted to trigger an action that may be effective for managing the SSP in response to the amount of storage resources used for storing snapshots in the SSP crossing the threshold.Type: ApplicationFiled: September 30, 2011Publication date: May 3, 2012Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Yaron REVAH, Shemer SCHWARTZ, Efri ZEIDNER, Ofir ZOHAR
-
Patent number: 8171128Abstract: A system and method provides dynamically selected media content to someone using an electronic device in a social network environment. Items of media content are selected for the user based on his or her relationships with one or more other users. The user's relationships with other users are reflected in the selected media content and its format. An order is assigned to the items of media content, for example, based on their anticipated importance to the user, and the items of media content are displayed to the user in the assigned order. The user may change the order of the items of media content. The user's interactions with media content available in the social network environment are monitored, and those interactions are used to select additional items of media content for the user.Type: GrantFiled: August 11, 2006Date of Patent: May 1, 2012Assignee: Facebook, Inc.Inventors: Mark Zuckerberg, Andrew Bosworth, Chris Cox, Ruchi Sanghvi, Matt Cahill
-
Patent number: 8166006Abstract: The present invention provides a method, system and program product for integrating a service external to a database into a database such that the service may be easily invoked from the database. Preferably, the service is a web service available over the internet The service may be invoked from any of a number of invoking mechanisms of the database. In a first specific embodiment, the mechanism comprises a user-defined function within an SQL statement. In a second specific embodiment, the mechanism comprises a virtual table. In a third specific embodiment, the mechanism comprises a stored procedure. In a fourth specific embodiment, the mechanism comprises a trigger. In a fifth specific embodiment, the mechanism comprises a federated table accessed via a nickname and implemented using a wrapper.Type: GrantFiled: September 28, 2001Date of Patent: April 24, 2012Assignee: International Business Machines CorporationInventors: Larry Brown, James C. Kleewein, Berthold Reinwald, Peter M. Schwarz, Charles Daniel Wolfson
-
Patent number: 8161010Abstract: Embodiments may recover from faults by forming a new set of rows by removing rows associated with faulting save operations and repeating the saving and forming operations using the new set of rows until a set of rows that can be saved from the known start state without fault is determined. When the subset of successful rows is found, embodiments are able to provide assurance that no side effects (i.e., code or operations triggered by saving of a data to a particular location) have been executed on behalf of any of the failed rows (side effects from custom PL/SOQL code included) by deferring execution of triggers until an entire set of rows can be saved and committed.Type: GrantFiled: February 23, 2007Date of Patent: April 17, 2012Assignee: salesforce.com, Inc.Inventors: Craig Weissman, Steven Tamm, Simon Fell, Simon Wong, Steve Fisher
-
Publication number: 20120078864Abstract: The present invention discloses an electronic data integrity protection device and method and a data monitoring system, wherein the device includes: a data reception unit configured to receive electronic data; a signal reception unit configured to receive an external signal; a signal processing unit configured to process the external signal in accordance with a predetermined integrity protection strategy, to output a corresponding instruction, wherein the integrity protection strategy specifies at least an integrity protection mode associated with the external signal; and an integrity protection operation unit configured to perform, in response to the instruction, integrity protection operation on the electronic data so as to generate integrity protection information.Type: ApplicationFiled: September 27, 2011Publication date: March 29, 2012Applicant: Sony CorporationInventors: Ji LI, Izuru Kitamura
-
Patent number: 8145680Abstract: A system and method for creating an editable service metadata asset lifecycle event notification distribution list in a service metadata repository. The system provides the capability for a distribution list owner to create a distribution list of one or more distribution recipients. A sender can send a service metadata asset lifecycle event notification to the distribution list owner, and the members of the distribution list will also receive the service metadata asset lifecycle event notification. The system further provides the capability for the sender to edit the distribution list, prior to sending the message to the distribution list owner and the members of the distribution list.Type: GrantFiled: February 2, 2009Date of Patent: March 27, 2012Assignee: Oracle International CorporationInventors: Catherine Betz Lippert, Casey Edward Stella, Philip Daniel Reed, Jr., Dennis A. Burns
-
Patent number: 8126857Abstract: Systems and methods for proactive information monitoring are presented. A user can define alert criteria for generating an alert through a centralized alerting service where the alert criteria relate to the status of records in a data set. The records of the data can be distributed across multiple remote or unaffiliated databases to which the user lacks access. The service can disaggregate the criteria into individual criterion targeting specific records stored in the databases. The criterions are provided to agents that monitor the records. When the records satisfy the criterion, the agents send notifications back to the service. Once the service receives sufficient notifications to indicate the alert criteria are satisfied, the service sends an alert to designated recipients. The systems and methods are able provide alert information without compromising the confidentially or security of the remote databases.Type: GrantFiled: September 12, 2008Date of Patent: February 28, 2012Assignee: Melissa Data Corp.Inventors: Philip M. Maitino, Robert Hull