Abstract: In one technique, a definition of a materialized view is identified. Based on the definition, multiple candidate partitioning schemes are identified. A query is generated that indicates one or more of the candidate partitioning schemes. The query is then executed, where executing the query results in one or more partition counts, each corresponding to a different candidate partitioning scheme of the one or more candidate partitioning schemes. Based on the one or more partition counts, a candidate partitioning scheme is selected from among the plurality of candidate partitioning schemes. The materialized view is automatically partitioned based on the candidate partitioning scheme.

Abstract: The invention provides a system and method for retrieving and storing industrial data, the system comprising a data retriever that includes a data retrieval manager and one or more watchers for monitoring data associated with one or more industrial devices, wherein if the data associated with the one or more industrial devices is new or modified, the one or more watchers notifies the data retrieval manager thereof and the data retrieval manager uploads the new or modified data. The system further includes a database manager for receiving the new or modified data in a first form from the data retrieval manager and for storing the new or modified data in a structural data form in one or more databases.

Abstract: Current data records having a start and end time are transformed into a 2D space having a first dimension for each data record's start time and a second dimension for each data record's end time. Historical queries specifying data ranges are obtained. A response was previously sent for each historical query and specifying a sub-portion of data records that overlap with such historical query's specified data range. Partitioning schemes for the current data records in the 2D space are generated. An optimum partitioning scheme having a lowest cost is selected based on costs of executing the historical queries with respect to each of the partitioning schemes. The optimum partitioning scheme is applied on the current data records, including newly received data records, in the 2D space so that any subsequently received queries are applied against the current data records as partitioned by the optimum partitioning scheme in the 2D space.

Abstract: The present invention extends to methods, systems, and computer program products for partitioning online databases. Online database operations, such as, for example, SPLIT, MERGE, and DROP, are used to alter the arrangement of partitions in a federated database. A SPLIT operation splits rows at one partition across a plurality of other partitions. A MERGE operation merges rows at a plurality of partitions in to one partition. A DROP operation shifts responsibility for rows of data from one partition to another partition and then drops the rows from the one partition.

Abstract: An intelligent system for database retrieval includes a computing device, an input device, a display device, and a storage device. A user initiates a free-form or structured inquiry of the storage device and the system executes a search for the free-form or structured inquiry and additionally for related knowledge if a free-form inquiry was initiated. The related knowledge search is system initiated and based upon the sensory information of the user and the user's behaviors. The free-form or structured inquiry and related knowledge results are returned to the computing device for formatting in a manner compatible with the user, the user's behavior, and the operating environment. The free-form or structured inquiry and related knowledge results are then displayed on the display device.

Abstract: Some embodiments provide a media production application. The application receives a script of a media project and parses the script to identify (i) story sections of the media project and (ii) characters in the media project. The application automatically creates data structures for the story sections and the characters, and associations between the story sections and the characters. The application receives several different types of data related to production of a media project and automatically schedules production activities for the media project based on the different types of data. For each location at which one or more story sections will be filmed, the application receives a photo of the location. The application displays a graphical outline of the media project in which each story section is represented by a thumbnail of the photo of the location at which the story section will be filmed.

Abstract: A data mapping acceleration system may include a syntactic profile module to generate a syntactic profile of a data source to be mapped. A semantic classification module may generate a semantic classification of the data source. A similarity module may evaluate the syntactic profile and semantic classification to determine an overall similarity between attributes of data from the data source for mapping the data source.

Abstract: Method, system, and computer program product for transferring data from transactional data sources to partitioned databases are provided. One or more messages from a transactional data source are read. Each message includes one or more records to be inserted into a database comprising a plurality of partitions. One of the partitions of the database in which the one or more records of each message are to be inserted is then identified. A transaction is initiated to insert the one or more records of each message into the one partition and to delete the one or more messages from the transactional data source. The transaction is committed only when insertion of the one or more records of each message into the one partition and deletion of the one or more messages from the transactional data source succeed.

Abstract: An intelligent system for database retrieval includes a computing device, an input device, a display device, and a storage device. A user initiates a free-form or structured inquiry of the storage device and the system executes a search for the free-form or structured inquiry and additionally for related knowledge if a free-form inquiry was initiated. The related knowledge search is system initiated and based upon the sensory information of the user and the user's behaviors. The free-form or structured inquiry and related knowledge results are returned to the computing device for formatting in a manner compatible with the user, the user's behavior, and the operating environment. The free-form or structured inquiry and related knowledge results are then displayed on the display device.

Abstract: Methods, systems, and computer program products are provided for processing correlated queries in a collaborative, role-based, peer-to-peer (P2P) execution system. A correlated query is configured in accordance to a collaborative correlated query process (CQP) template. The collaborative CQP template defines roles and steps, each step being executable by one of the roles. A role is assigned to each peer node of the P2P system. A peer node having a designated role executes a step that is executable by the designated role. A message is communicated to other P2P nodes to indicate completion of the step. Another peer node having a matching role to a next step in the correlated query executes the next step in response to the message.

Abstract: A system and method for creating a unique alias associated with an individual identified in a health care database such that health care data, and particularly pharmaceutical-related data, can be efficiently gathered and analyzed. The system has a first data store for storing at least one record where each record includes a plurality of identification fields which when concatenated uniquely identify an individual, and at least one health care field corresponding to health care data associated with the individual. The system also has a second data store, and a processor. The processor selects a record of the first data store, then selects a subset of the plurality of identification fields within the selected record, and concatenates the selected subset of identification fields. Then the processor stores the concatenated identification fields in a record in the second data store with the at least one health care field from the selected record of the first data store.

Abstract: A method and apparatus for generating partition keys in an information handling system having a partitioned database. Partition keys are generated by concatenating a partition subrange identifier specifying a subrange of key values and a sequence number specifying a particular key value within a subrange. Partition keys are assigned with the aid of a partition key control table that stores subrange and available key block information and is updated whenever key blocks are reserved or the database is repartitioned. An activity indicator maintained for each partition indicates recent activity in the partition. In response to a request for a partition key, a partition is selected for key assignment having the least recent activity as indicated by its activity indicator. Specific activity indicators disclosed include a timestamp for each partition in the control table, as well as a count of the threads in a particular application instance concurrently accessing a partition.

Abstract: Embodiments disclosed herein provide an implementation defined segments (IDS) subsystem which allows new data segments to be added to an identity hub after deployment. A set of metadata tables are utilized to describe IDS, each of which is a data structure encapsulating a single row from a master data record residing in the identity hub. Once a segment (an object) is described, the identity hub can use the information to define persistent storage for the object in the database for any relational database management system, create internal structures to hold the data and process business rules and demographic comparisons against the data object, describe the data object to remote clients, and allow the clients to query the identity hub at runtime about what data objects exist, what fields and data types they contain, and additionally how they might be displayed or formatted on various clients.

Abstract: Techniques are provided for analyzing performance differences for a set of database query language statements on two different database systems. The performance analysis is based on quantitative measurements and estimates of the execution of the set of database query language statements on the two different database systems. This performance analysis process may be used by database administrators to predict impacts to performance due to a change in a database system.

Abstract: In various embodiments, a system, method, and related computer-related medium to process data transactions are provided. In one example, a system is arranged to process data transactions in a data store including a plurality of databases. The system includes a computer interface module to receive a data transaction request from at least one requesting computer and a data access layer having one or more processors to identify at least one database in the plurality of databases. The data access layer is to define an abstraction layer between a computer interface module and the plurality of databases.

Abstract: The present invention aims to facilitate integration of databases by classifying a plurality of tables in databases into a group of similar tables. A table classification device 1 includes a semantic classifying unit 20 carrying out classification with considering meanings of columns which form a database and a statistical classifying unit 30 carrying out classification based on statistical information of the columns. The tables are classified hierarchically by combining a classification method of the semantic classifying unit 20 and a classification method of the statistical classifying unit 30.

Abstract: An apparatus for and a method are provided for managing data by dividing file identifier descriptors (FIDs) included in metadata of a universal disk format (UDF) file system, and arranging them. The apparatus for managing data includes an input unit that receives a command for generating data in a file system environment, a controller that determines a data type corresponding to the command, a data generator that generates the data by referring to the command, and a metadata updater that arranges an FID with respect to the generated data according to the data type.

Abstract: A method and apparatus for increasing the speed at which a block of data can be partitioning into variable-length subblocks is provided. The method combines a relatively high-speed partitioning algorithm (that can only partition a block into relatively small mean-length subblocks) with a relatively low-speed algorithm (that can partition a block into subblocks of any mean length) to yield a relatively high-speed partitioning algorithm that can partition blocks into subblocks of any mean-length.

Abstract: The invention has as its object to selectively reproduce on an external apparatus apart of digital data with index that a user wants to reproduce out of the digital data being made up of audio data and/or video data without having to use an application program dedicated for the external apparatus. The present invention is characterized in that in a case that a data file linked with a position information file is to be transmitted to the external apparatus, there are provided a data file divider which performs division processing on the data file on the basis of predetermined positions on the time axis of the digital data specified by the position information to thereby create a plurality of divided data files and a data file transmitter for transmitting the divided data files created by the data file divider to the external apparatus.

Abstract: A method and system for optimizing data redistribution in a database. In one embodiment, the method includes moving, during a first scan, outgoing records from a sending partition to one or more receiving partitions, where free space is created in the sending partition due to the outgoing records leaving the sending partition. The method also includes filling, during the first scan, some of the free space with remaining records that do not leave the sending partition.

Abstract: This invention is related to electronic product description transfer between a trading partner that designs a product and a trading partner that manufactures the product and more particularly to the organization and use of a catalog of component information used in the generation of process documents and programs to adapt an assembly process to assemble the product as specified in the electronic product description. In the present invention, a consolidated component catalog provides the information for a component used in the assembly of a product in two sections: an assembly process independent section and an assembly process dependent section. The assembly process independent information is used to correct and validate the product description information. The assembly process dependent information is used to generate the programs and documents to adapt an assembly process to assemble the product described in the product description.