|| List of recent Relational-related patents
|Data mapping using trust services|
Embodiments are directed to mapping encryption policies to user data stored in a database using a policy column uniform resource identifier (uri). In one scenario, a computer system receives the following: a database schema name that identifies the name of a specified schema within a relational database in which user data is stored, a table name that identifies a specified table within the relational database, a column name that identifies a specified column in the specified table and a namespace identifier that identifies a set of relational databases.
|Reducing downtime during upgrades of interrelated components in a database system|
A method, system, and computer program product for reducing downtime during upgrades of interrelated components in a computing environment. The method commences while at least one running software application is executing within the computing environment by loading a plurality of database objects from an initial run edition into a patch edition.
|Using a data dictionary to determine an upgrade edition of a relational database table|
A method, system, and computer program product using a data dictionary to automatically determine an upgrade edition of relational database table in a database installation. The editioning method commences upon receiving a data dictionary of the database comprising at least entries corresponding to a first edition of the relational database table, then reading entries of the data dictionary to identify at least one relational database table column of the relational database table that has a revision identifier.
|Method and apparatus for generating schema of non-relational database|
Embodiments of the present invention disclose a method and apparatus for generating a schema of a non-relational database. In the embodiments of the present invention, relationship among keys in at least one entry of a non-relational database may be determined, the keys may be grouped into at least one group based on the determined relationship, and a schema of the non-relational database may be generated according to the at least one group..
|Pruning disk blocks of a clustered table in a relational database management system|
Techniques are provided for generating a “dimensional zonemap” that allows a database server to avoid scanning disk blocks of a fact table based on filter predicates in a query that qualify one or more dimension tables. The zonemap divides the fact table into sets of contiguous disk blocks referred to as “zones”.
|Clustering a table in a relational database management system|
Techniques are provided that address the problems associated with prior approaches for clustering a fact table in a relational database management system. According to one aspect of the invention, a database server clusters a fact table in a database based on one or more dimension tables.
|Hybrid execution of continuous and scheduled queries|
Techniques for implementing the hybrid execution of continuous and scheduled queries are provided. In some examples, a query engine may be initialized with relational data from at least a first source.
|Systems and methods for redistributing data in a relational database|
Systems and methods for redistributing data in a relational database are disclosed. In one embodiment, the database includes a plurality of rows of data distributed across a plurality of slices of a table in the database.
|Query translation for searching complex structures of objects|
Searching stored content is disclosed. A first mapping is created from an object to one or more stored relational database tables.
|Sql generation for assert, update and delete relational trees|
Presented is a system and method for evaluating relational database queries in a distributed system. An optimized query plan is received by a control node.
|Methods and systems for the collaborative development and discovery of web-based clinical pathways|
A method and system to facilitate the collaborative development and discovery of evidence-based, clinical pathways. Clinicians, medical professionals or researchers, may use the platform to build and find clinical pathways through a graphical interface, creating relational data records between steps in pathways.
|System and method for implementing a scalable data storage service|
A system that implements a scalable data storage service may maintain tables in a non-relational data store on behalf of clients. The system may provide a web services interface through which service requests are received, and an api usable to request that a table be created, deleted, or described; that an item be stored, retrieved, deleted, or its attributes modified; or that a table be queried (or scanned) with filtered items and/or their attributes returned.
|Navigation device database update system|
A difference file which indicates a difference between a second relational database and a first relational database may be transferred to a navigation device. The navigation device may store a first compressed database version of the first relational database.
|Subject-mounted device to measure relative motion of human joints|
The relational motion detection system measures relative motion of a head of a subject relative to a torso of a subject. The system includes a first motion detection sensor on a first apparatus configured to be secured to a head of a subject to detect a first motion.
|Generation of a user interface based on a relational data model|
Technologies are described herein for generating a user interface based on a relational data model. A relational data model may be received.
|Managing workload optimized systems using relational database modeling and triggers|
Relational database modeling and triggers are employed and coordinated to maintain and manage tunable parameters and characteristics of a workload optimized system. The database model is initialized with pre-defined values as per definition of workload optimized systems, which models the optimal configuration of the workload-optimized system, capturing various performance configurations, security and other related system and software configuration.
|Storing compression units in relational tables|
A database server stores compressed units in data blocks of a database. A table (or data from a plurality of rows thereof) is first compressed into a “compression unit” using any of a wide variety of compression techniques.
Provided are techniques for generating a relational query. Information is collected from a query specification and a model for an on-line analytical processing (olap) query having at least a first expression and a second expression.
|Referentially-complete data subsetting using relational databases|
A method, system, and computer program product for relational database management. The method constructs a referentially-complete target subset database from a source database by first estimating the expected size of the target subset database based on application of one or more subsetting rules.
|Database table format conversion based on user data access patterns in a networked computing environment|
An approach for conversion between database formats (e.g., from a relational database format to a hash table or a “big table” database format) based on user data access patterns in a networked computing environment is provided. A first set of database tables having a first format is identified based on a set of access patterns stored in a computer storage device.
|Techniques for constructing minimum supersets of test data from relational databases|
A computer-implemented method is provided for constructing a minimum superset of data that complies with referential completeness as well as other specified data relationships. Given extraction criteria for the data, an iterative process analyzes the database for records to be included in the minimal superset.
|Archiving-safe replication of relational data|
A computer-implemented method for archiving information includes: executing a first application in a first process; determining that the first application is an archiving application configured to archive information stored in a transactional system; assigning, based on the determination, an archiving mode to the first process; receiving, from the first process and after assigning the archiving mode, a request to delete information; and processing the request to delete information according to the archiving mode.. .
|Systems and methods for batch processing of data records in an on-demand system|
Systems and methods are provided for batch processing of data records in an on-demand system. A marker is stored that identifies a node in an on-demand system and identifies a most recent data record processed in a relational database management system by the node.
|Torque distribution apparatus, torque distribution method, torque distribution value generation method, and program|
A torque distribution apparatus acquires an instructed torque input and a motor efficiency map for motors; detects vehicular speed and drive wheel rotational speed; calculates based on the detected speeds, a relational expression of drive wheel slip rate and a friction coefficient; creates based on the relational expression, a performance curve expression indicating relations between torque and the drive wheel rotational speed, superimposes the performance curve expression on the motor efficiency map, creates an efficiency variation expression indicating for each vehicular speed, the torque and efficiency values of the motor efficiency map, and calculates a torque that optimizes efficiency from the efficiency variation expression; calculates based on the instructed torque and the torque optimizing efficiency, a torque distribution value for each motor; and controls torque distribution to each motor, within a range of the slip rate being 0 to 0.2 and based on the torque distribution values.. .
|Method for controlling exposure apparatus and exposure apparatus|
According to one embodiment, a method for controlling an exposure apparatus includes calculating a shift from a target value of an illuminance distribution on a reticle of light irradiated onto the reticle. The calculating is based on a relational expression and a measured value of an illuminance distribution on a wafer of light irradiated onto the wafer via a projection optical system.
|Indexed security for use with databases|
A computer-implemented method for providing security in a relational database hosted by a first server, and configured to interact with a second server, includes associating a first ownership vector with an object in the relational database, detecting a change to the object, and associating a second ownership vector with the object in response to detecting the change to the object.. .
|Context-based graph-relational intersect derived database|
A context-based graph-relational intersect derived (cb-grid) links a real entity graph node to a synthetic entity graph node. The real entity graph node comprises a pointer to a primary key in a first tuple that non-contextually describes the real entity.
|Method and device for synthesis of network traffic|
Embodiments of the present invention provide a method and device for synthesis of network traffic. The method includes extracting a first real traffic composition parameter sequence and a second real traffic composition parameter sequence from real traffic.
|Microfluidic device and microfluidic apparatus using the same|
To improve temperature distribution of fluid in a flow channel of a microfluidic device in which a resistive element disposed in substrate as that in which the channel is formed is heated to control the temperature in accordance with resistance of the element, provided is a microfluidic device including: a substrate; a flow channel disposed in the substrate for flowing through fluid therein; a first resistive element for primarily heating the fluid; and multiple second resistive elements for supplementarily heating the fluid, the elements being disposed at positions different from position where the first element is disposed. A microfluidic apparatus operating the device stores a relational expression between a temperature of the fluid and resistance of the first element, and a fixed value of a ratio between a heat energy input into the first and second element, and controls the temperature in accordance with the expression and the value..
|System, methods, and media for compressing non-relational database objects|
Method, media, and systems for compressing objects, comprising: receiving a request to write a first object including a first key and a first value, wherein the first object is of a given type; receiving a request to write a second object including a second key and a second value, wherein the second object is of the given type; classifying the first object to a compression dictionary according to at least one rule based on a value of the first object and/or the key of the first object; classifying the second object to the compression dictionary according to at least one rule based on a value of the second object and/or the key of the second object; and compressing the first object and the second object based on the compression dictionary.. .
|Fine-grained relational database access-control policy enforcement using reverse queries|
A method of providing access control to a relational database accessible from a user interface is implemented at a policy enforcement point, which is located between the database and the user interface and includes the steps of: (i) intercepting a database query from a user; (ii) assigning attribute values on the basis of a target table or target column in the query, a construct type in the query, or the user or environment; (iii) partially evaluating an access-control policy defined in terms of said attributes, by constructing a partial policy decision request containing the attribute values assigned in step ii) and evaluating the ac policy for this, whereby a simplified policy is obtained; (iv) deriving an access condition, for which the simplified policy permit access; and (v) amending the database query by imposing said access condition and transmitting the amended query to the database.. .
|Gap detection in a temporally unique index in a relational database|
Methods for gap detection in a temporally unique index in a relational database. A temporally unique index is provided in a relational database.
|Collaborative spatial positioning|
Disparate positional data derived from one or more positional determinative resources are fused with peer-to-peer relational data to provide an object with a collaborative positional awareness. An object collects positional determinative information from one or more positional resources so to independently determine its spatial location.
|Systems, methods, and user interface for effectively presenting information|
Systems and methods are disclosed for presenting information related to an object including a word or phrase in a text content that is considered as unstructured data. Methods include identifying a term in the text content as a candidate for presenting such information.
|Aggregate data streams in relational database systems|
Methods, systems, and computer readable media can provide for aggregating high-rate, large-volume input data streams into low-volume output data streams in real-time. Aggregating high-rate, large-volume data streams into low-volume output data streams can be facilitated by analyzing lossless aggregation relationships among helper views within one or more continuous query tasks and executing conventional queries to derive high-level, low-volume output data streams from low-level, high-volume input data streams..
|Mapping non-relational database objects into a relational database model|
According to some embodiments, information may be received about a non-relational database object, such as an infoset, infoset query, or advanced business application programming (“abap”) function for an enterprise resource planning system. The non-relational database object may then be mapped into a relational database model, such as a model associated with a business intelligence platform.
|Support for compensation aware data types in relational database systems|
Techniques are provided for extending a business transaction framework to support user-provided compensation logic for business transactions. The extensibility framework may be used to implement user-defined semantics for (a) validating concurrent updates to shared data and (b) performing compensating actions when an associated transaction is aborted.
|Methods and systems for bulk row save logic in an object relational mapping layer and application framework|
In accordance with embodiments, there are provided mechanisms and methods for saving multiple rows together through an object relational mapping layer to a database. These mechanisms and methods for saving multiple rows together can enable embodiments to detect faults in the save operation(s) and recover.
|Optical element, method of manufacturing optical element, illumination device, window member, and fitting|
An optical element includes a first surface, a second surface positioned to face the first surface, and a plurality of reflecting surfaces arrayed in a first region defined by the first surface and the second surface, wherein the reflecting surfaces have a first length in a first direction vertical to the first surface and are arrayed at a pitch in a second direction perpendicular to the first direction, light incident on one of the first surface and the second surface is reflected by the reflecting surfaces toward the other surface, and predetermined parameters satisfy predetermined relational formulae representing conditions for ensuring total reflection at the reflecting surfaces and for avoiding total reflection at a light emergent surface.. .
|Method and system for managing large write-once tables in shadow page databases|
Methods and systems for managing large write-once tables are described. In some embodiments, a relational database management system includes a space allocation module that utilizes both a logical space allocation scheme, as well as a physical space allocation scheme, to allocate space in units (e.g., pages) having two different sizes—small pages and big pages.
|Systems and methods for reslicing data in a relational database|
Systems and methods for reslicing data in a representation of a relational database are disclosed. In one embodiment, the database includes a representation including a first slice.