| Patent application number | Description | Published |
|---|
| 20090271379 | Relational database management system (RDBMS) employing a relational datastore and a multi-dimensional database (MDDB) for serving query statements from client machines - A relational database management system (RDBMS) for servicing query statements from one or more client machines, using a relational data store and a multi-dimensional database (MDDB). The RDBMS includes a query interface which is adapted to receive query statements from the client machines, and to generate one or more query requests. The RDBMS includes a query handling mechanism which receives each request from the query interface, extracts a set of dimensions associated with the request, uses the dimensions to retrieve aggregated fact data from the MDDB, and forwards retrieved aggregated fact data to the query processing mechanism for subsequent processing. When the query processing mechanism of the RDBMS determines that servicing one or more query requests requires data stored in the relational tables, then the query handling mechanism automatically routes the requests to the relational data tables, so that data can be accessed from the relational tables and forwarded to the query processing mechanism for use in servicing the requests, in a manner transparent to the client machine. When the query processing mechanism determines that servicing one or more query requests requires aggregated data from the MDDB, then the query handling mechanism automatically routes the requests to the MDDB, so that data can be accessed from the MDDB and forwarded to the query processing mechanism for use in servicing the requests, in a manner transparent to the client machine. | 10-29-2009 |
| 20090271384 | Relational database management system having integrated non-relational multi-dimensional data store of aggregated data elements - Improved method of and apparatus for joining and aggregating data elements integrated within a relational database management system (RDBMS) using a non-relational multi-dimensional data structure (MDD). The improved RDBMS system of the present invention can be used to realize achieving a significant increase in system performance (e.g. deceased access/search time), user flexibility and ease of use. The improved RDBMS system of the present invention can be used to realize an improved Data Warehouse for supporting on-line analytical processing (OLAP) operations or to realize an improved informational database system or the like. | 10-29-2009 |
| 20090276410 | Relational database management system (RDBMS) employing multi-dimensional database(MDDB) for servicing query statements through one or more client machines - A relational database management system (RDBMS) for servicing query statements through one or more client machines. The RDBMS comprises a query interface adapted to receive query statements from the client machines. The query handling mechanism (i) receives each request from the query interface, (ii) extracts a set of dimensions associated with the request, (iii) uses the dimensions to retrieve aggregated fact data from a multi-dimensional database (MDDB), and (iv) forwards retrieved aggregated fact data to the query processing mechanism for subsequent processing. When the query processing mechanism determines that servicing of one or more query requests require data stored in the relational tables, then the query processing mechanism automatically routes the requests to the relational data tables, so that data can be accessed from the relational tables and forwarded to the query processing mechanism for use in servicing the requests, in a manner transparent to the client machine. | 11-05-2009 |
| 20100042645 | System with a data aggregation module generating aggregated data for responding to OLAP analysis queries in a user transparent manner - A system for supporting OLAP analysis over a network. The system comprises an OLAP server for enabling an OLAP user to perform OLAP analysis via interaction with a client machine on the network. The system also includes a data aggregation module comprising a multi-dimensional datastore, an aggregation engine integrated with the multi-dimensional datastore, and a first interface for loading base data from a data source to the aggregation engine. The aggregation engine performs data aggregation operations on loaded base data, generates aggregated data from the base data, and stores the aggregated data in the multi-dimensional datastore. A second interface receives requests for OLAP analysis from the OLAP server, accesses the aggregation engine to retrieve from the multi-dimensional datastore, aggregated data corresponding to requests, and communicates the retrieved aggregated data to the OLAP server for query servicing, in a manner transparent to the OLAP user. | 02-18-2010 |
| 20100063958 | Database management system (DBMS) employing a relational datastore and a multi-dimensional database (MDDB) for servicing query statements in a manner transparent to client machine - A database management system (DBMS) for servicing query statements through one or more client machines. The DBMS comprises a query interface adapted to receive query statements from the client machines. The query handling mechanism (i) receives each request from the query interface, (ii) extracts a set of dimensions associated with the request, (iii) uses the dimensions to retrieve aggregated fact data from a multi-dimensional database (MDDB), and (iv) forwards retrieved aggregated fact data to the query processing mechanism for subsequent processing. When the query processing mechanism determines that servicing of one or more query requests require data stored in the relational tables, then the query processing mechanism automatically routes the requests to the relational data tables, so that data can be accessed from the relational tables and forwarded to the query processing mechanism for use in servicing the requests, in a manner transparent to the client machine. | 03-11-2010 |
| 20100100558 | Method of servicing query statements from a client machine using a database management system (DBMS) employing a relational datastore and a multi-dimensional database (MDDB) - A method of serving query statements from one or more client machines using a database management system (DBMS) employing a relational data store and a multi-dimensional database (MDDB). A query interface is adapted to receive query statements from the client machines, and generate one or more query requests. A query handling mechanism (i) receives each request from the query interface, (ii) extracts a set of dimensions associated with the request, (iii) uses the dimensions to retrieve aggregated fact data from the MDDB, and (iv) forwards retrieved aggregated fact data to the query processing mechanism for subsequent processing. When the query processing mechanism determines that servicing of one or more query requests require data stored in the relational tables, then the query handling mechanism automatically routes the requests to the relational data tables, so that data can be accessed from the relational tables and forwarded to the query processing mechanism for use in servicing the requests, in a manner transparent to the client machine. | 04-22-2010 |
| 20100185581 | Data aggregation module supporting dynamic query responsive aggregation during the servicing of database query requests provided by one or more client machines - Improved method of and apparatus for aggregating data elements in multidimensional databases (MDDB). In the preferred embodiment, the apparatus is realized in the form of a high-performance stand-alone (i.e. external) aggregation server which can be plugged-into conventional MOLAP systems to achieve significant improments in system performance. In accordance with the principles of the present invention, the stand-alone aggregation server contains a scalable MDDB and a high-performance aggregation engine that are integrated into the modular architecture of the aggregation server. The stand-alone aggregation server of the present invention can uniformly distribute data elements among a plurality of processors, for balanced loading and processing, and therefore is highly scalable. The stand-alone aggregation server of the present invention can be used to realize (i) an improved MDDB for supporting on-line analytical processing (OLAP) operations, (ii) an improved Internet URL Directory for supporting on-line information searching operations by Web-enabled client machines, as well as (iii) diverse types of MDDB-based systems for supporting real-time control of processes in response to complex states of information reflected in the MDDB. | 07-22-2010 |
| 20120089563 | DATA AGGREGATION MODULE SUPPORTING DYNAMIC QUERY RESPONSIVE AGGREGATION DURING THE SERVICING OF DATABASE QUERY REQUESTS PROVIDED BY ONE OR MORE CLIENT MACHINES - Improved method of and apparatus for aggregating data elements in multidimensional databases (MDDB). In the preferred embodiment, the apparatus is realized in the form of a high-performance stand-alone (i.e. external) aggregation server which can be plugged-into conventional MOLAP systems to achieve significant improvements in system performance. In accordance with the principles of the present invention, the stand-alone aggregation server contains a scalable MDDB and a high-performance aggregation engine that are integrated into the modular architecture of the aggregation server. The stand-alone aggregation server of the present invention can uniformly distribute data elements among a plurality of processors, for balanced loading and processing, and therefore is highly scalable. | 04-12-2012 |
| 20120089564 | DATA AGGREGATION MODULE SUPPORTING DYNAMIC QUERY RESPONSIVE AGGREGATION DURING THE SERVICING OF DATABASE QUERY REQUESTS PROVIDED BY ONE OR MORE CLIENT MACHINES - Improved method of and apparatus for aggregating data elements in multidimensional databases (MDDB). In the preferred embodiment, the apparatus is realized in the form of a high-performance stand-alone (i.e. external) aggregation server which can be plugged-into conventional MOLAP systems to achieve significant improvements in system performance. In accordance with the principles of the present invention, the stand-alone aggregation server contains a scalable MDDB and a high-performance aggregation engine that are integrated into the modular architecture of the aggregation server. The stand-alone aggregation server of the present invention can uniformly distribute data elements among a plurality of processors, for balanced loading and processing, and therefore is highly scalable. | 04-12-2012 |
| Patent application number | Description | Published |
|---|
| 20090073560 | Systems and Methods for Polarization Mode Dispersion Mitigation - In one exemplary embodiment, a method comprises transmitting an optical signal via the optical line, measuring a relative change in spectral intensity of the optical signal near a clock frequency (or half of that frequency) while varying a polarization of the optical signal between a first state of polarization and a second state of polarization, and using the relative change in spectral intensity of the optical signal to determine and correct the DGD of the optical line. Another method comprises splitting an optical signal traveling through the optical line into a first and second portions having a first and second principal states of polarization of the optical line, converting the first and second portions into a first and second electrical signals, delaying the second electrical signal to create a delayed electrical signal that compensates for a DGD of the optical line, and combining the delayed electrical signal with the first electrical signal to produce a fixed output electrical signal. | 03-19-2009 |
| 20090073561 | Systems and Methods for Polarization Mode Disperson Mitigation - In one exemplary embodiment, a method comprises transmitting an optical signal via the optical line, measuring a relative change in spectral intensity of the optical signal near a clock frequency (or half of that frequency) while varying a polarization of the optical signal between a first state of polarization and a second state of polarization, and using the relative change in spectral intensity of the optical signal to determine and correct the DGD of the optical line. Another method comprises splitting an optical signal traveling through the optical line into a first and second portions having a first and second principal states of polarization of the optical line, converting the first and second portions into a first and second electrical signals, delaying the second electrical signal to create a delayed electrical signal that compensates for a DGD of the optical line, and combining the delayed electrical signal with the first electrical signal to produce a fixed output electrical signal. | 03-19-2009 |
| 20090080883 | Systems and Methods for Polarization Mode Dispersion Mitigation - In one exemplary embodiment, a method comprises transmitting an optical signal via the optical line, measuring a relative change in spectral intensity of the optical signal near a clock frequency (or half of that frequency) while varying a polarization of the optical signal between a first state of polarization and a second state of polarization, and using the relative change in spectral intensity of the optical signal to determine and correct the DGD of the optical line. Another method comprises splitting an optical signal traveling through the optical line into a first and second portions having a first and second principal states of polarization of the optical line, converting the first and second portions into a first and second electrical signals, delaying the second electrical signal to create a delayed electrical signal that compensates for a DGD of the optical line, and combining the delayed electrical signal with the first electrical signal to produce a fixed output electrical signal. | 03-26-2009 |
| 20110142445 | Systems and Methods for Polarization Mode Dispersion Mitigation - In one exemplary embodiment, a method comprises transmitting an optical signal via the optical line, measuring a relative change in spectral intensity of the optical signal near a clock frequency (or half of that frequency) while varying a polarization of the optical signal between a first state of polarization and a second state of polarization, and using the relative change in spectral intensity of the optical signal to determine and correct the DGD of the optical line. Another method comprises splitting an optical signal traveling through the optical line into a first and second portions having a first and second principal states of polarization of the optical line, converting the first and second portions into a first and second electrical signals, delaying the second electrical signal to create a delayed electrical signal that compensates for a DGD of the optical line, and combining the delayed electrical signal with the first electrical signal to produce a fixed output electrical signal. | 06-16-2011 |
| 20120321298 | Systems and Methods for Polarization Mode Dispersion Mitigation - In one exemplary embodiment, a method comprises transmitting an optical signal via the optical line, measuring a relative change in spectral intensity of the optical signal near a clock frequency (or half of that frequency) while varying a polarization of the optical signal between a first state of polarization and a second state of polarization, and using the relative change in spectral intensity of the optical signal to determine and correct the DGD of the optical line. Another method comprises splitting an optical signal traveling through the optical line into a first and second portions having a first and second principal states of polarization of the optical line, converting the first and second portions into a first and second electrical signals, delaying the second electrical signal to create a delayed electrical signal that compensates for a DGD of the optical line, and combining the delayed electrical signal with the first electrical signal to produce a fixed output electrical signal. | 12-20-2012 |
