Abstract: A computer-based system and method for speech to text conversion preprocessing of a presentation with a speech audio, useable in real time. The method captures a presentation speech audio input to be converted into text, temporally associates the speech audio input with at least one supporting text source from the same presentation containing common keywords and creates an optimized and prioritized keyword positional index metadata set for inputting into a speech to text conversion processor.

Abstract: A computer-based method with multilevel hashing for lookup of a complex nested object (such as access control list) which has a plurality of nesting levels and each level has at least one element. Method stores representatives of a complex nested object in a data structure at locations determined by recursive multilevel hashing of the complex nested object elements. When needed, a match for an inputted complex nested object is determined by applying the same recursive multilevel hashing to the inputted complex nested object, as used during the storing of the complex nested object, and performing integer comparisons with hash values of the stored complex nested object.

Abstract: A computer-based filtering method driven by a ruleset for positive and negative filtering with flexible comparison operations. Method first creates a ruleset as an ordered collection of rules which has a single ruleset default action. Each rule has a rule action, a comparison operation and at least one comparison data element. Filtering of an object from the ruleset result set is performed with the comparison operation on the object and the comparison data from the ruleset. Filtering step invokes each rule from the ruleset to compare the object with each comparison data element to determine whether or not the object is to be included or excluded from the result set. Filtering stops after the first matching rule is found and then the rule action is taken, or after invoking all rules without finding the matching rule and then the ruleset default action is taken.

Abstract: A system and computer-based method is provided for decomposing and storing a markup based document into a relational database. For a schema of a markup based document a user identifies multiple items mapping into a same database table-column pair, creates a logical table and associates the logical table to each item and a corresponding database table. Next, a user creates a mapping document of the markup based document with mapping annotations defining mapping of the items into columns of the logical tables. Decomposition of each item into a corresponding logical table column is accomplished by collecting the item content from the markup based document and storing it in the corresponding row column.

Abstract: A method, apparatus and article of manufacture is provided for automatic insertion of a compressed GOP offset table within a previously encoded MPEG video file, for frame accurate random access of each individual video frame in play-from-offset mode. The method creates a compressed GOP offset table having an entry for each GOP header of every video packet of the MPEG video file, and modifies the MPEG video file by inserting the compressed GOP offset table before the MPEG video file as at least one padding packet, thereby preserving the MPEG compliance and compressed audio/video data of the MPEG video file. The method further has a step for estimating a number of padding packets needed for the GOP offset table, thereby limiting the MPEG video file reading to a single read.

Abstract: A method, apparatus and article of manufacture is provided for debugging within a computer system network. The method uses XML dataflows from/to a console for debugging of instructions located in a server, which has a database management system for retrieving data from a database stored in an electronic storage device coupled to the server. The method uses a debugger manager at the console for commanding and monitoring debugging operations of the server-side instructions, performed by a debugger engine, and uses XML command and status report dataflows for providing a database communication interface between the debugger manager and the debugger engine. Some preferred embodiments use stored procedures in addition to the XML dataflows, and the debugger manager executes in a multi-threaded environment.

Abstract: The universal hospital bed designed for nursing the immobile patients with additional bathing equipment” belongs to the category of the health equipment, intended for the health institutions, gerontology institutions and family households. The essence of the invention is in its constructive solution of the three-part bed, which using the mechanism for electrical and mechanical adjustment of the angles of the slope of the mobile parts of bed, could be converted into the form of (arm) chair. The belt holders and belts for fastening the patients are installed on the back part of the bed, and the antidecubitus mattress is placed along the whole bed, used as preventive protection of the patients against decubitus, or if patient already has it, for healing of the wounds. On the middle sitting part of the bed-mattress, part of the mattress is cut and the basic insert (41) is made of it, which if necessary, could be replaced with WC insert.

Abstract: A method, apparatus and article of manufacture is provided for processing a previously encoded MPEG video high-resolution (HR) file and corresponding proxy file, for frame accurate timecode repair and synchronization of individual video frames of the HR and proxy files. Each video frame header of the HR and proxy files is modified by a compressed timecode packet having an identifying signature, an absolute timecode of the frame, and a relative timecode of the frame. The timecodes have the SMPTE timecode format HH:MM:SS:FF. The method automatically verifies the timecodes in the HR and proxy files timecode packets. If a repair of the HR file anomalous absolute timecodes is needed, the method automatically corrects the anomalous absolute timecodes in the HR file. If the proxy file starting video frame is offset from the HR file starting video frame, the method automatically synchronizes the proxy and the HR files absolute and relative timecodes.

Abstract: A method, apparatus and article of manufacture is provided for SQL debugging within a computer system network. The method uses stored procedures via a console for debugging of SQL instructions located in a server, wherein preferably only one database communication line exists between the server and the console. The server has a database management system for retrieving data from a database stored in an electronic storage device coupled to the server. The method uses a debugger manager at the console for commanding and monitoring debugging operations of the server-side SQL instructions performed by a debugger engine, and uses stored procedures of a debugger router as a database communication interface for receiving commands and sending status reports between the debugger manager and the debugger engine.

Abstract: An apparatus, article of manufacture and computer-based method is provided for determining the optimum join sequence for processing a query having a plurality of tables from a relational database stored in an electronic storage device having a database management system. The method is performed in two passes. The first pass is used for determining an optimum join sequence for joining the plurality of tables from the query. The second pass uses the optimum join sequence for creating a lowest cost access path plan for processing the query. The first pass performs successive steps until creation of a simulated composite table having all tables from the query, wherein each step creates a set of miniplans for simulating all possible joins of a predetermined subset of the query tables and uses a cost model calculations for estimating and saving the least expensive join from this set of joins.

Abstract: A computer-based method for compressing varying-length columns of a non-leaf page high key generated during splitting of an index tree leaf page from a key pair including a last key of a splitting leaf page and a first key of a corresponding new leaf page. The method performs a logical comparison of the key pair by comparing each key pair corresponding columns' data with padding considered as insignificant. In a logically equal key pair with equal-length columns, the high key field will have the entire column data, and for unequal-length columns it will have column data of the shorter column length +1 byte and will have all remaining varying-length columns without trailing padding data. In a logically unequal key pair, the high key will have all columns up to and including a first differing byte, wherein the stored varying-length columns are stored without trailing padding data.

Abstract: A system, method and a computer usable medium tangibly embodying a program of instructions executable by the computer to perform a computer-based method for providing a conflict detection and resolution in a mid-tier server of a multi-tier client-server communication system which performs message synchronization in a client/mid-tier environment and replication in a mid-tier/server environment. The method defines a client/mid-tier conflict resolution look-up table listing all possible conflict states in the client/mid-tier environment and corresponding action rules, and a mid-tier/server conflict resolution look-up table listing all possible conflict states in the mid-tier/server environment and corresponding action rules. For any detected conflict state the method finds and executes the corresponding action rule.

Abstract: A system, computer usable medium and computer-based method for altering a sequence number assignment pattern while preserving integrity and high concurrency in an environment having a plurality of applications on at least one computer system sharing a direct access storage device (DASD). The method generates and assigns sequence numbers for a shared sequence object located on the shared DASD to a plurality of applications executing concurrently and using the shared sequence object. When an application starts altering the shared sequence object attribute(s) during concurrent assignment of sequence numbers by other applications, it notifies all computer systems using the shared sequence object to locally refresh the sequence object attribute descriptor and discard unused reserved sequence numbers, and then updates the altered shared sequence object attribute and last assigned sequence number on the shared DASD.

Abstract: A method, apparatus and article of manufacture is provided for mapping data objects residing in multiple data sources, or generated dynamically, into a single, reusable software component, for integrated information access to multiple disparate data sources, residing on or generating the data dynamically on different hardware systems and possibly in different data formats. The method has steps for identifying data objects in multiple data sources, employing an information integration software facility for connecting to the data sources containing the data objects, and registering the data objects with the software facility, creating a single virtual data object consolidating multiple attributes from the registered data objects, and establishing a connection to the software facility for referencing the virtual data object as though it was a single real data object. It also has a step for wrapping this virtual data object as a reusable software component accessible directly from applications.

Abstract: A method, apparatus and program storage device for monitoring and managing a remote computer in a computer network is provided. The apparatus includes a server computer system having a database management system for retrieving data from a database stored in an electronic storage device coupled to the server computer system, a console computer system for managing the server computer system, and only one communication line between the server and the console. The server computer system services the communication line via a database management system protocol. It receives server management operation requests from the console and returns the requested information to the console. When the server database management system recognizes the server management operation requests, sent in a stored procedure call format, it invokes an appropriate DBMS stored procedure encoding the requested server management operation.

Abstract: An apparatus, article of manufacture and computer-based markup serialization method is provided for transferring data contained in a markup based document, such as an Extensible Markup Language (XML) document, into a relational database stored in an electronic storage device having a database management system. They are used for easy subsequent retrieval of data from the database in the XML format and reconstruction of the XML document. The method decomposes the document according to basic markup types of the documents' data components and stores the decomposed document in a set of markup tables created in the database, one markup table for each basic markup type, thereby preserving the hierarchical tree structure, parent-child order, and components of the document. For querying the database markup tables the method uses SQL queries to retrieve the XML document components in the XML format.

Abstract: A system, a program storage device and a software method for efficient handling of multiple Unicode formats in the same database on a table level is provided. The routines of the method are used to create a plurality of database tables and specify each table data storage format, including a first table for storing data in a first Unicode format and a second table for storing data in a second Unicode format. The method inputs characters which are encoded in the first Unicode format. When the data should be stored in the second Unicode format, the method uses a conversion routine for transforming some inputted characters into the second Unicode format and stores them in the second table, and then stores unconverted inputted characters in the first table. The first Unicode format is preferably the UCS-2 format and the second Unicode format is the UTF-8 format.

Abstract: An optimization technique for SQL queries, a program storage device storing the optimization program, and an apparatus for optimizing a query is provided. A query is analyzed to determine whether it includes subselect expressions that return exactly or at most one tuple. If so, the quantifier merger or elimination is performed, if possible, to allow query to perform more efficiently than that of the original query while providing same results. The query is then executed in the computer to efficiently retrieve data from the database.

Abstract: A method, apparatus and article of manufacture for storyboard thumbnail and video rights metadata insertion is provided for preventing unauthorized use of restricted video frames of a previously encoded MPEG video file. It can insert video rights metadata in the timecode packet of the affected video frame of the MPEG video file; if requested. To allow automatic recreation of a storyboard file from the MPEG video file, it can insert thumbnail status metadata in the timecode packet of the selected video storyboard thumbnail frame of the MPEG video file. If requested, it can update the video rights metadata in a video catalog record and in the timecode packet of the affected video frame of the MPEG video file. When needed, it can update the thumbnail status metadata in a video catalog record and in the timecode packet of the selected video storyboard thumbnail frame of the MPEG video file.

Abstract: A method, system and article of manufacture is provided for processing a previously encoded MPEG video file for frame accurate timecode identification of each individual video frame. For each frame of the MPEG video file, the method creates a compressed timecode packet having an identifying signature, an absolute timecode of the frame, and a relative timecode of the frame, wherein the timecodes have the SMPTE timecode format HH:MM:SS:FF. Next, the MPEG video file is modified by inserting in a header of each frame of the MPEG video file the corresponding compressed timecode packet, while maintaining the MPEG video file's original frame presentation timing, thereby preserving the MPEG compliance and compressed audio/video data of the MPEG video file. The timecode packet is preferably automatically inserted in a user data packet of the frame, between the picture start header and the first slice header.