Aspects described herein relate to accessing, by a compute node of a database management system (DBMS), one or more objects in state information for a database in a unified memory architecture having multiple memory nodes, such as compute express link (CXL), where the accessing includes using direct memory access (DMA) to access memory in at least a portion of the multiple memory nodes, and performing, by the compute node, one or more query operations for the database based on the state information.
G06F 13/28 - Handling requests for interconnection or transfer for access to input/output bus using burst mode transfer, e.g. direct memory access, cycle steal
G06F 13/42 - Bus transfer protocol, e.g. handshakeSynchronisation
G06F 16/25 - Integrating or interfacing systems involving database management systems
2.
UNIFIED BUFFER MANAGEMENT IN DATABASE MANAGEMENT SYSTEMS
Aspects described herein relate to accessing, by a compute node of a database management system (DBMS), one or more objects in state information for a database in a unified memory architecture having multiple memory nodes, such as compute express link (CXL), where the accessing includes using direct memory access (DMA) to access memory in at least a portion of the multiple memory nodes, and performing, by the compute node, one or more query operations for the database based on the state information.
Aspects described herein relate to performing a distributed join in a database system using computer express link (CXL) memory. A first host device of multiple host devices can access the CXL memory to obtain data written to the CXL memory by at least a second host device of the multiple host devices. The first host device can perform, based on the obtained data, the distributed join.
G06F 13/16 - Handling requests for interconnection or transfer for access to memory bus
G06F 16/27 - Replication, distribution or synchronisation of data between databases or within a distributed database systemDistributed database system architectures therefor
4.
PERFORMING DISTRIBUTED JOINS USING COMPUTE EXPRESS LINK (CXL) IN DATABASE MANAGEMENT SYSTEMS
Aspects described herein relate to performing a distributed join in a database system using computer express link (CXL) memory. A first host device of multiple host devices can access the CXL memory to obtain data written to the CXL memory by at least a second host device of the multiple host devices. The first host device can perform, based on the obtained data, the distributed join.
A system and method for just in time compilation for hash table probing are disclosed. In one implementation, the method of using just-in-time compilation is used to combine the stages of hash value computation and initial lookup into a single compound operation. In another implementation, the method of using just-in-time compilation is used to combine the stages of a hash table record and input record checking to detect if these records are equal, and if not, fetching the next possible record in the linked list of the per-bucket records.
Aspects described herein relate to partitioning multiple data tuples stored in a database system to multiple partitions based on multiple partition keys. The multiple data tuples can be assigned to multiple partitions such that each partition of the multiple partitions includes a portion of the multiple data tuples having same values for at least one of the multiple partition keys. A set of exceptions can be generated including data tuples having a first value of at least a first one of the multiple partition keys that is the same as the same value of a first portion of data tuples assigned to a first one of the multiple partitions, and a second value of at least a second one of the multiple partition keys that is the same as the same value of a second portion of data tuples assigned to a second one of the multiple partitions.
Examples described herein generally relate to database systems for storing and processing both small values that are smaller than size of a database column and large objects that exceed the size of the database column. A database management system (DBMS) determines that a value to be stored in a database is a large object having a size larger than a column of the database. The DBMS stores the value as a large object in an external storage associated with a token stored in the column of the database. The token includes information for processing the large object. A vector processing engine associated with the external storage processes the large object based on the information in the token in response to a database command from the DBMS on multiple records represented as a vector.
Aspects described herein relate to maintaining a dataset with approximate constraints including determining, for a dataset, a constraint collection of tuples that satisfy a constraint and an exception collection of tuples that are an exception to the constraint, constructing, for the dataset, a sharded bitmap of bits, wherein each bit in the sharded bitmap indicates whether a tuple in the dataset is in the exception collection of tuples, wherein the sharded bitmap includes, for each shard of multiple shards, a bitmap of bits and a starting bit location index within the sharded bitmap of bits for the shard, and processing a query on the dataset including processing the constraint collection of tuples and the exception collection of tuples based on the sharded bitmap.
Aspects described herein relate to executing a compiled user defined function (UDF) in an interpreted database query engine. A database query that invokes a UDF defined in an interpreted programming language can be received, and a shared library produced by compiling the UDF can be loaded during database runtime. The UDF can be executed via the shared library during the invocation of the database query, or another database query, in the interpreted database query engine.
Aspects described herein relate to executing a compiled user defined function (UDF) in an interpreted database query engine. A database query that invokes a UDF defined in an interpreted programming language can be received, and a shared library produced by compiling the UDF can be loaded during database runtime. The UDF can be executed via the shared library during the invocation of the database query, or another database query, in the interpreted database query engine.
Aspects described herein relate to executing a compiled user defined function (UDF) in an interpreted database query engine. A database query that invokes a UDF defined in an interpreted programming language can be received, and a shared library produced by compiling the UDF can be loaded during database runtime. The UDF can be executed via the shared library during the invocation of the database query, or another database query, in the interpreted database query engine.
Examples described herein generally relate to database systems for storing and processing both small values that are smaller than size of a database column and large objects that exceed the size of the database column. A database management system (DBMS) determines that a value to be stored in a database is a large object having a size larger than a column of the database. The DBMS stores the value as a large object in an external storage associated with a token stored in the column of the database. The token includes information for processing the large object. A vector processing engine associated with the external storage processes the large object based on the information in the token in response to a database command from the DBMS on multiple records represented as a vector.
Examples described herein generally relate to database operations including encoding, within a length field for a first value to be stored in a column of a database as a token that includes information for processing a large object, an indicator indicating that the first value is of a token type, and storing, in the column of the database, the first value with the length field including the indicator.
Examples described herein generally relate to database operations including encoding, within a length field for a first value to be stored in a column of a database as a token that includes information for processing a large object, an indicator indicating that the first value is of a token type, and storing, in the column of the database, the first value with the length field including the indicator.
Examples described herein generally relate to database systems for storing and processing both small values that are smaller than size of a database column and large objects that exceed the size of the database column. A database management system (DBMS) determines that a value to be stored in a database is a large object having a size larger than a column of the database. The DBMS stores the value as a large object in an external storage associated with a token stored in the column of the database. The token includes information for processing the large object. A vector processing engine associated with the external storage processes the large object based on the information in the token in response to a database command from the DBMS on multiple records represented as a vector.
A database system processes database queries that process external tables representing data obtained from an external systems. The database system generates an execution plan to execute the database query. The database system sends a request for data of the external table to an external system. The request provides connection information to the external system. The external system sends a request to connect to the database system and provides data of the external table as a data stream. If the database system reaches an operator that processes the data of the external table, the database system waits for data from the external system. The database system processes the database query using the data of the data stream. The database system provides the result of the database query to a requestor, for example, a client device.
A system and method for just in time compilation for hash table probing are disclosed. In one implementation, the method of using just-in-time compilation is used to combine the stages of hash value computation and initial lookup into a single compound operation. In another implementation, the method of using just-in-time compilation is used to combine the stages of a hash table record and input record checking to detect if these records are equal, and if not, fetching the next possible record in the linked list of the per-bucket records.
A database system processes database queries that process external tables representing data obtained from an external systems. The database system generates an execution plan to execute the database query. The database system sends a request for data of the external table to an external system. The request provides connection information to the external system. The external system sends a request to connect to the database system and provides data of the external table as a data stream. If the database system reaches an operator that processes the data of the external table, the database system waits for data from the external system. The database system processes the database query using the data of the data stream. The database system provides the result of the database query to a requestor, for example, a client device.
Aspects described herein relate to maintaining a dataset with approximate constraints including determining, for a dataset, a constraint collection of tuples that satisfy a constraint and an exception collection of tuples that are an exception to the constraint, constructing, for the dataset, a sharded bitmap of bits, wherein each bit in the sharded bitmap indicates whether a tuple in the dataset is in the exception collection of tuples, wherein the sharded bitmap includes, for each shard of multiple shards, a bitmap of bits and a starting bit location index within the sharded bitmap of bits for the shard, and processing a query on the dataset including processing the constraint collection of tuples and the exception collection of tuples based on the sharded bitmap.
Aspects described herein relate to maintaining a dataset with approximate constraints including determining, for a dataset, a constraint collection of tuples that satisfy a constraint and an exception collection of tuples that are an exception to the constraint, constructing, for the dataset, a sharded bitmap of bits, wherein each bit in the sharded bitmap indicates whether a tuple in the dataset is in the exception collection of tuples, wherein the sharded bitmap includes, for each shard of multiple shards, a bitmap of bits and a starting bit location index within the sharded bitmap of bits for the shard, and processing a query on the dataset including processing the constraint collection of tuples and the exception collection of tuples based on the sharded bitmap.
Database systems handle queries represented in different character sets. A database system allows data stored in the same database column to be represented in different character sets. In response to a query, the database system returns query results in the same character set as the received query even though the data stored in the database column is in a different character set. The database system creates and maintains a metadata table that stores attributes of database columns. The attributes of database columns include, among others, a data type, and a collation attribute. By tracking the collation attributes for data stored in database columns, the database system determines whether to convert data stored in a database column when processing database queries.
A computer system hosting a column-store database engine is responsive to database requests for the update and retrieval of data from within a stable data table and providing for the storage of database tuples within a column-store organized database structure. A positional delta tree data structure is implemented in the memory space of the database engine and is operatively coupled in an update data transfer path between a database engine interface and the stable data table. The positional delta tree data structure includes a differential data storage layer operative to store differential update data values in positionally defined relative reference to database tuples stored by the stable data table.
09 - Scientific and electric apparatus and instruments
42 - Scientific, technological and industrial services, research and design
Goods & Services
Downloadable database software; downloadable data analytics
software; downloadable database management software;
downloadable software for data warehousing; downloadable
database management and integration software for the filing,
organization, storage, modification, integration,
transformation, governance, research, recalling, analysis,
and reporting of data and data statistics, data quality and
security management; downloadable computer software for
statistical analysis and statistical analysis reporting;
downloadable software for use in business decision making,
for monitoring and aggregating data from multiple sources
and applying rules to discover patterns and trends in the
data, for processing, filing, organization, modification,
research, recalling and analysis of data and data
statistics; downloadable application development software;
downloadable software for developing and executing a
business rules engine; downloadable software for executing
local or remote application software; downloadable computer
software for integrating applications and databases across
internal and external networks and in the cloud. Software as a service (SaaS) services and cloud computing
featuring database software, data analytics software,
database management software; software as a service (SaaS)
services and cloud computing featuring software for data
warehousing, and for the filing, organization, storage,
modification, integration, transformation, governance,
research, recalling, analysis, and reporting of data and
data statistics, data quality and security management;
software as a service (SaaS) services and cloud computing
featuring software for statistical analysis and statistical
analysis reporting; software as a service (SaaS) services
and cloud computing featuring software for use in business
decision making, for monitoring and aggregating data from
multiple sources and applying rules to discover patterns and
trends in the data, for processing, filing, organization,
modification, research, recalling and analysis of data and
data statistics; software as a service (SaaS) services and
cloud computing featuring software for application
development; software as a service (SaaS) services and cloud
computing featuring software for developing and executing
business rules engine; software as a service (SaaS) services
and cloud computing featuring software for executing local
or remote application software; software as a service (SaaS)
services and cloud computing featuring software for
integrating applications and databases across internal and
external networks and in the cloud; consulting regarding the
design, installation, development, maintenance and use of
database and data management and integration software;
technical support services, namely, troubleshooting of
computer software problems for database and data management
and integration software.
09 - Scientific and electric apparatus and instruments
42 - Scientific, technological and industrial services, research and design
Goods & Services
(1) Downloadable computer software for database management and for accessing, querying and analyzing information stored in databases, all the foregoing in the nature of enterprise software targeted to organizations, and not specifically designed to encourage individuals to live healthier lifestyles or to explain personalized health care benefits and information direct to individuals; downloadable computer software in the field of data analytics, all the foregoing in the nature of enterprise software targeted to organizations and not specifically designed to encourage individuals to live healthier lifestyles or to explain personalized health care benefits and information direct to individuals; downloadable database management software, all the foregoing in the nature of enterprise software targeted to organizations, and not specifically designed to encourage individuals to live healthier lifestyles or to explain personalized health care benefits and information direct to individuals; downloadable computer software for accessing, querying and analyzing information stored in data warehouses, all the foregoing in the nature of enterprise software targeted to organizations, and not specifically designed to encourage individuals to live healthier lifestyles or to explain personalized health care benefits and information direct to individuals; downloadable database management and integration software for the filing, organization, storage, modification, integration, transformation, governance, research, recalling, analysis, and reporting of data and data statistics, data quality and security management, all the foregoing in the nature of enterprise software targeted to organizations, and not specifically designed to encourage individuals to live healthier lifestyles or to explain personalized health care benefits and information direct to individuals; downloadable computer software for use in statistical analysis and to produce notification reports, all the foregoing in the nature of enterprise software targeted to organizations, and not specifically designed to encourage individuals to live healthier lifestyles or to explain personalized health care benefits and information direct to individuals; downloadable business analytics computer software for collecting and analyzing computer data to discover patterns and trends to facilitate business decision making, all the foregoing in the nature of enterprise software targeted to organizations, and not specifically designed to encourage individuals to live healthier lifestyles or to explain personalized health care benefits and information direct to individuals; downloadable computer software for the processing, filing, organization, modification, research, recalling and analysis of data and data statistics, all the foregoing in the nature of enterprise software targeted to organizations, and not specifically designed to encourage individuals to live healthier lifestyles or to explain personalized health care benefits and information direct to individuals; downloadable computer software development programs for creating and developing business applications for others, all the foregoing in the nature of enterprise software targeted to organizations, and not specifically designed to encourage individuals to live healthier lifestyles or to explain personalized health care benefits and information direct to individuals; downloadable computer software for development and implementation of business rules and exception handling, all the foregoing in the nature of enterprise software targeted to organizations, and not specifically designed to encourage individuals to live healthier lifestyles or to explain personalized health care benefits and information direct to individuals; downloadable computer software for accessing, viewing and controlling remote computers and computer networks, all the foregoing in the nature of enterprise software targeted to organizations, and not specifically designed to encourage individuals to live healthier lifestyles or to explain personalized health care benefits and information direct to individuals; downloadable computer software for application and database integration across computer networks and hosted on cloud based virtual servers, all the foregoing in the nature of enterprise software targeted to organizations, and not specifically designed to encourage individuals to live healthier lifestyles or to explain personalized health care benefits and information direct to individuals (1) Software as a service (SaaS) services and cloud computing featuring computer software for database management and for accessing, querying and analyzing information stored in databases, database management software, all the foregoing in the nature of enterprise software targeted to organizations, and not specifically designed to encourage individuals to live healthier lifestyles or to explain personalized health care benefits and information direct to individuals; software as a service (SaaS) services and cloud computing featuring software for accessing, querying and analyzing information stored in data warehouses, all the foregoing in the nature of enterprise software targeted to organizations, and not specifically designed to encourage individuals to live healthier lifestyles or to explain personalized health care benefits and information direct to individuals; software as a service (SaaS) services and cloud computing featuring computer database management software for the filing, organization, storage, modification, integration, transformation, governance, research, recalling, analysis and reporting of data and data statistics, data quality and security management, all the foregoing in the nature of enterprise software targeted to organizations, and not specifically designed to encourage individuals to live healthier lifestyles or to explain personalized health care benefits and information direct to individuals; software as a service (SaaS) services and cloud computing featuring software for use in statistical analysis and to produce notification reports, all the foregoing in the nature of enterprise software targeted to organizations, and not specifically designed to encourage individuals to live healthier lifestyles or to explain personalized health care benefits and information direct to individuals; software as a service (SaaS) services and cloud computing featuring software for collecting and analyzing computer data to discover patterns and trends to facilitate business decision making, all the foregoing in the nature of enterprise software targeted to organizations, and not specifically designed to encourage individuals to live healthier lifestyles or to explain personalized health care benefits and information direct to individuals; software as a service (SaaS) services and cloud computing featuring software for the processing, filing, organization, modification, research, recalling and analysis of data and data statistics, all the foregoing in the nature of enterprise software targeted to organizations, and not specifically designed to encourage individuals to live healthier lifestyles or to explain personalized health care benefits and information direct to individuals; software as a service (SaaS) services and cloud computing featuring computer software development programs for creating and developing business applications for others, all the foregoing in the nature of enterprise software targeted to organizations, and not specifically designed to encourage individuals to live healthier lifestyles or to explain personalized health care benefits and information direct to individuals; software as a service (SaaS) services and cloud computing featuring software for development and implementation of business rules and exception handling, all the foregoing in the nature of enterprise software targeted to organizations, and not specifically designed to encourage individuals to live healthier lifestyles or to explain personalized health care benefits and information direct to individuals; software as a service (SaaS) services and cloud computing featuring software for accessing, viewing and controlling remote computers and computer networks, all the foregoing in the nature of enterprise software targeted to organizations, and not specifically designed to encourage individuals to live healthier lifestyles or to explain personalized health care benefits and information direct to individuals; software as a service (SaaS) services and cloud computing featuring software for application and database integration across computer networks and hosted on cloud based virtual servers, all the foregoing in the nature of enterprise software targeted to organizations, and not specifically designed to encourage individuals to live healthier lifestyles or to explain personalized health care benefits and information direct to individuals; consulting regarding the design, installation, development, maintenance and use of database and data management and integration software, all the foregoing in the nature of enterprise software targeted to organizations, and not specifically designed to encourage individuals to live healthier lifestyles or to explain personalized health care benefits and information direct to individuals; technical support services, namely, troubleshooting of computer software problems for database and data management and integration software, all the foregoing in the nature of enterprise software targeted to organizations, and not specifically designed to encourage individuals to live healthier lifestyles or to explain personalized health care benefits and information direct to individuals
09 - Scientific and electric apparatus and instruments
42 - Scientific, technological and industrial services, research and design
Goods & Services
Downloadable database software; downloadable data analytics software; downloadable database management software; downloadable software for data warehousing; downloadable database management and integration software for the filing, organization, storage, modification, integration, transformation, governance, research, recalling, analysis, and reporting of data and data statistics, data quality and security management; downloadable computer software for statistical analysis and statistical analysis reporting; downloadable software for use in business decision making, for monitoring and aggregating data from multiple sources and applying rules to discover patterns and trends in the data, for processing, filing, organization, modification, research, recalling and analysis of data and data statistics; downloadable application development software; downloadable software for developing and executing a business rules engine; downloadable software for executing local or remote application software; downloadable computer software for integrating applications and databases across internal and external networks and in the cloud; all the foregoing in the nature of enterprise software targeted to organizations, and not specifically designed to encourage individuals to live healthier lifestyles or to explain personalized health care benefits and information direct to individuals. Software as a service (saas) services and cloud computing featuring database software, data analytics software, database management software; software as a service (saas) services and cloud computing featuring software for data warehousing, and for the filing, organization, storage, modification, integration, transformation, governance, research, recalling, analysis, and reporting of data and data statistics, data quality and security management; software as a service (saas) services and cloud computing featuring software for statistical analysis and statistical analysis reporting; software as a service (saas) services and cloud computing featuring software for use in business decision making, for monitoring and aggregating data from multiple sources and applying rules to discover patterns and trends in the data, for processing, filing, organization, modification, research, recalling and analysis of data and data statistics; software as a service (saas) services and cloud computing featuring software for application development; software as a service (saas) services and cloud computing featuring software for developing and executing business rules engine; software as a service (saas) services and cloud computing featuring software for executing local or remote application software; software as a service (saas) services and cloud computing featuring software for integrating applications and databases across internal and external networks and in the cloud; consulting regarding the design, installation, development, maintenance and use of database and data management and integration software; technical support services, namely, troubleshooting of computer software problems for database and data management and integration software; all the foregoing in the nature of enterprise software targeted to organizations, and not specifically designed to encourage individuals to live healthier lifestyles or to explain personalized health care benefits and information direct to individuals.
09 - Scientific and electric apparatus and instruments
42 - Scientific, technological and industrial services, research and design
Goods & Services
downloadable data analytics software; downloadable database management software; downloadable software for data warehousing; downloadable database management and integration software for the filing, organization, storage, modification, integration, transformation, research, recalling, analysis, and reporting of data and data statistics; downloadable database management and integration software for the governance of data quality and security management; downloadable computer software for statistical analysis and statistical analysis reporting; downloadable software for use in business decision making, for monitoring and aggregating data from multiple sources and applying rules to discover patterns and trends in the data, for processing, filing, organization, modification, research, recalling and analysis of data and data statistics ; downloadable application development software; downloadable software for developing and executing a business rules engine; downloadable software for executing local or remote application software; downloadable computer software for integrating applications and databases across internal and external networks and in the cloud; all the foregoing in the nature of enterprise software targeted to organizations, and not specifically designed to encourage individuals to live healthier lifestyles or to explain personalized health care benefits and information direct to individuals Software as a service (SaaS) services and cloud computing featuring data analytics software, database management software; software as a service (SaaS) services and cloud computing featuring software for data warehousing, and for the filing, organization, storage, modification, integration, transformation, research, recalling, analysis, and reporting of data and data statistics; software as a service (SaaS) services and cloud computing featuring software for the governance of data quality and security management; software as a service (SaaS) services and cloud computing featuring software for statistical analysis and statistical analysis reporting; software as a service (SaaS) services and cloud computing featuring software for use in business decision making, for monitoring and aggregating data from multiple sources and applying rules to discover patterns and trends in the data, for processing, filing, organization, modification, research, recalling and analysis of data and data statistics; software as a service (SaaS) services and cloud computing featuring software for application development; software as a service (SaaS) services and cloud computing featuring software for developing and executing business rules engine; software as a service (SaaS) services and cloud computing featuring software for executing local or remote application software; software as a service (SaaS) services and cloud computing featuring software for integrating applications and databases across internal and external networks and in the cloud; consulting regarding the design, installation, development, maintenance and use of database and data management and integration software; technical support services, namely, troubleshooting of computer software problems for database and data management and integration software; all the foregoing in the nature of enterprise software targeted to organizations, and not specifically designed to encourage individuals to live healthier lifestyles or to explain personalized health care benefits and information direct to individuals
42 - Scientific, technological and industrial services, research and design
Goods & Services
Software as a service (SaaS) services featuring software for
filing, organization, management, storage, recalling,
analytics, querying, reporting, and mining of data and data
statistics, and for data warehousing; computer services,
namely, cloud hosting provider services.
28.
Maintaining character set compatibility in database systems
Database systems handle queries represented in different character sets. A database system allows data stored in the same database column to be represented in different character sets. In response to a query, the database system returns query results in the same character set as the received query even though the data stored in the database column is in a different character set. The database system creates and maintains a metadata table that stores attributes of database columns. The attributes of database columns include, among others, a data type, and a collation attribute. By tracking the collation attributes for data stored in database columns, the database system determines whether to convert data stored in a database column when processing database queries.
A system and method for just in time compilation for hash table probing are disclosed. In one implementation, the method of using just-in-time compilation is used to combine the stages of hash value computation and initial lookup into a single compound operation. In another implementation, the method of using just-in-time compilation is used to combine the stages of a hash table record and input record checking to detect if these records are equal, and if not, fetching the next possible record in the linked list of the per-bucket records.
42 - Scientific, technological and industrial services, research and design
Goods & Services
Software as a service (SaaS) services featuring software for filing, organization, management, storage, recalling, analytics, querying, reporting, and mining of data and data statistics, and for data warehousing; computer services, namely, cloud hosting of data analytics databases; all of the aforesaid excluding the field of utility operations
31.
Optimizing database queries using subquery composition
A database system optimizes database queries that comprise subqueries. The database system factors out computation from two or more subqueries to a reusable subquery. The reusable subquery returns a result set. The subqueries are rewritten to use the result set and the database query modified to use the rewritten subqueries. The modified database query performs efficiently since the result set is computed only once for each subquery that uses the reusable query. The database system also composes nested subqueries that compute aggregate values. The database system identifies an inner subquery nested within an outer subquery, each subquery computing an aggregate value. The database system determines a new aggregate function corresponding to a composition of aggregate functions of the inner and the outer queries. The database system determines a composed query using the inner query with the outer query. The composed query uses the new aggregate function.
A constant-vector computation system and method are provided that exploit constant-value blocks during data processing in a database. The system and method may be implemented in any data processing system that processes data at a vector or block granularity.
Graphical mapping interface embodiments and method are provided for creating and displaying a schema map, which may be used by a data transformation system to perform a data transformation between at least one source schema and at least one target schema. According to one embodiment, the graphical mapping interface may comprise a source schema region for displaying a graphical representation of at least one source schema, a target schema region for displaying a graphical representation of at least one target schema, and a mapping region for displaying graphical representations of a plurality of links connecting the source nodes displayed in the source schema region to the target nodes displayed in the target schema region. The plurality of links may comprise at least one control link having at least one ECA rule associated therewith and at least one data link having at least one textual-based target field expression associated therewith.
G06F 7/00 - Methods or arrangements for processing data by operating upon the order or content of the data handled
G06F 17/30 - Information retrieval; Database structures therefor
G06F 3/048 - Interaction techniques based on graphical user interfaces [GUI]
G06F 15/16 - Combinations of two or more digital computers each having at least an arithmetic unit, a program unit and a register, e.g. for a simultaneous processing of several programs
34.
Data transformation system, graphical mapping tool, and method for creating a schema map
Graphical mapping interface embodiments and method are provided for creating and displaying a schema map, which may be used by a data transformation system to perform a data transformation between at least one source schema and at least one target schema. According to one embodiment, the graphical mapping interface may comprise a source schema region for displaying a graphical representation of at least one source schema, a target schema region for displaying a graphical representation of at least one target schema, and a mapping region for displaying graphical representations of a plurality of links connecting the source nodes displayed in the source schema region to the target nodes displayed in the target schema region. The plurality of links may comprise at least one control link having at least one ECA rule associated therewith and at least one data link having at least one textual-based target field expression associated therewith.
G06F 17/30 - Information retrieval; Database structures therefor
G06F 3/048 - Interaction techniques based on graphical user interfaces [GUI]
G06F 15/16 - Combinations of two or more digital computers each having at least an arithmetic unit, a program unit and a register, e.g. for a simultaneous processing of several programs
Backups and restore operations of database are customized by performing partial backups and restores. The database maintains information describing database objects that are backed up by subsequent backup operations. The data set that is backed up by backup operations can be modified by executing alter backup commands. An alter backup command identifies one or more database objects and specifies whether the database object should be excluded or included from backup operations. The alter backup command can specify database objects that do not exist in the database. These objects are included or excluded in accordance with the alter backup command whenever they are created in the database. The alter backup command can associate a criteria with a database object in order for the database object to be included or excluded in accordance with the alter backup command.
G06F 17/30 - Information retrieval; Database structures therefor
G06F 11/14 - Error detection or correction of the data by redundancy in operation, e.g. by using different operation sequences leading to the same result
Backups and restore operations of database are customized by performing partial backups and restores. The database maintains information describing database objects that are backed up by subsequent backup operations. The data set that is backed up by backup operations can be modified by executing alter backup commands. An alter backup command identifies one or more database objects and specifies whether the database object should be excluded or included from backup operations. The alter backup command can specify database objects that do not exist in the database. These objects are included or excluded in accordance with the alter backup command whenever they are created in the database. The alter backup command can associate a criteria with a database object in order for the database object to be included or excluded in accordance with the alter backup command.
A database system identifies missing statistics that is not available for processing database queries and determines the missing statistics. The database system generates execution plans for database queries. The database system requests certain statistical information for generating a database query. If the database system determines that the requested statistical information is not available, the database system stores information describing the requested statistical information as missing statistics. The missing statistics may identify one or more columns associated with tables processed by the database query. The database system performs statistical analysis of database tables to generate the missing statistics so that the statistical information is available for generating execution plans for subsequent queries. The database system may rank the missing statistics based on the number of times the missing statistics was identified by the database system while processing database queries.
A system and method for usage metering software applications (or features or functions) by monitoring the data store underlying the software application. The data store function may be implemented in many ways, such as a Relational Database, Transactional Database, Network and Graph Database, Object-Oriented Database, Embedded Database, In-memory Database, Schema-less Database, Files and Directories, whether structured or unstructured, Configuration Registries, or Non-traditional Repositories. Business activities performed by the software application are tracked and are independent of hardware usage. Such usage data is valuable in a variety of contexts, including billing based on business activity.
09 - Scientific and electric apparatus and instruments
42 - Scientific, technological and industrial services, research and design
Goods & Services
Computer software, namely, database management software for
the filing, organization, storage, modification, research,
recalling, analysis, and reporting of data and data
statistics; computer software for statistical analysis and
statistical analysis reporting; computer software to
automate data warehousing, and for data and database query
management and reporting; computer software search engine
for searching and locating database content. Consulting regarding the design, installation, development,
maintenance and use of database management software;
providing computer software via cloud computing featuring
software for use in database management and for the filing,
organization, storage, modification, research, recalling,
analysis and reporting of data, and for statistical analysis
and statistical analysis reporting, and to automate data
warehousing, and for data and database query management and
reporting, and for providing a search engine for searching
and locating database content; technical support services,
namely, troubleshooting of computer software problems for
database management software.
40.
Methods of operating a column-store database engine utilizing a positional delta tree update system
A column-store database engine operates in response to database requests for the update and retrieval of data from within a stable data table and provides for the storage of database tuples within a column-store organized database structure. A positional delta tree data structure is implemented in the memory space of the database engine and is operatively coupled in an update data transfer path between a database engine interface and the stable data table. The positional delta tree data structure includes a differential data storage layer operative to store differential update data values in positionally defined relative reference to database tuples stored by the stable data table.
A computer system hosting a column-store database engine is responsive to database requests for the update and retrieval of data from within a stable data table and providing for the storage of database tuples within a column-store organized database structure. A positional delta tree data structure is implemented in the memory space of the database engine and is operatively coupled in an update data transfer path between a database engine interface and the stable data table. The positional delta tree data structure includes a differential data storage layer operative to store differential update data values in positionally defined relative reference to database tuples stored by the stable data table.
09 - Scientific and electric apparatus and instruments
42 - Scientific, technological and industrial services, research and design
Goods & Services
Computer software, namely, database management software for the filing, organization, storage, modification, research, recalling, analysis, and reporting of data and data statistics; computer software for statistical analysis and statistical analysis reporting; computer software to automate data warehousing, and for data and database query management and reporting; computer software search engine for searching and locating database content. Consulting regarding the design, installation, development, maintenance and use of database management software; providing computer software via cloud computing featuring software for use in database management and for the filing, organization, storage, modification, research, recalling, analysis and reporting of data, and for statistical analysis and statistical analysis reporting, and to automate data warehousing, and for data and database query management and reporting, and for providing a search engine for searching and locating database content; technical support services, namely, troubleshooting of computer software problems for database management software.
43.
METHOD AND APPARATUS FOR THE DEVELOPMENT, DELIVERY AND DEPLOYMENT OF ACTION-ORIENTED BUSINESS APPLICATIONS SUPPORTED BY A CLOUD BASED ACTION SERVER PLATFORM
A method and apparatus for the development, delivery and deployment of action- oriented business applications supported by a cloud based action server platform are provided. The cloud action platform enables the development, delivery and deployment of a new type of business application - Action Apps which are the opposite of traditional business applications which are large, expensive, viewed as an investment, hard to upgrade and oftentimes require training. The Action Apps are light-weight consumer friendly mlcro-apps that enable the business user to take the right actions, at the right time to produce the right business outcome, The action may be as simple as approving a vacation request, or it may trigger a series of more complex actions such as automatically discounting stock based upon competitors pricing within a specific radius in a given timeframe.
G06F 15/16 - Combinations of two or more digital computers each having at least an arithmetic unit, a program unit and a register, e.g. for a simultaneous processing of several programs
09 - Scientific and electric apparatus and instruments
42 - Scientific, technological and industrial services, research and design
Goods & Services
Computer software for software application development, for
developing and executing a business rules engine, for use in
business decision making, for business rules management, for
monitoring and aggregating data from multiple sources and
applying rules to discover patterns and trends in the data,
for triggering responses to predefined conditions and
events, for processing, filing, organization, modification,
research, recalling and analysis of data and data
statistics, and for executing local or remote application
software. Cloud computing featuring a software platform for software
application development, for developing and executing a
business rules engine, for use in business decision making,
for business rules management, for monitoring and
aggregating data from multiple sources and applying rules to
discover patterns and trends in the data, for triggering
responses to predefined conditions and events, for
processing, filing, organization, modification, research,
recalling and analysis of data and data statistics, and for
executing local or remote application software; computer
programming services, namely, programming of data management
software; consulting regarding the design, installation,
development, maintenance and use of data management
software; technical support services, namely,
troubleshooting of computer software problems for data
management software.
09 - Scientific and electric apparatus and instruments
35 - Advertising and business services
42 - Scientific, technological and industrial services, research and design
Goods & Services
Computer software for software application development, for
developing and executing a business rules engine, for use in
business decision making, for business rules management, for
monitoring and aggregating data from multiple sources and
applying rules to discover patterns and trends in the data,
for triggering responses to predefined conditions and
events, for processing, filing, organization, modification,
research, recalling and analysis of data and data
statistics, and for executing local or remote application
software. Online store services, namely, operating online marketplaces
for buying, selling, sharing and offering for free computer
software, provided via the Internet and other computer and
communication networks. Cloud computing featuring a software platform for software
application development, for developing and executing a
business rules engine, for use in business decision making,
for business rules management, for monitoring and
aggregating data from multiple sources and applying rules to
discover patterns and trends in the data, for triggering
responses to predefined conditions and events, for
processing, filing, organization, modification, research,
recalling and analysis of data and data statistics, and for
executing local or remote application software; computer
programming services, namely, programming of data management
software; consulting regarding the design, installation,
development, maintenance and use of data management
software; technical support services, namely,
troubleshooting of computer software problems for data
management software.
09 - Scientific and electric apparatus and instruments
Goods & Services
(1) Computer software for software application development, namely, for creating customized software applications in the field of business intelligence and analysis; database and business intelligence and analysis software, namely, for developing and executing a business rules engine, for use in business decision making, for business rules management, for monitoring and aggregating data from multiple sources and applying rules to discover patterns and trends in the data, for triggering responses to predefined conditions and events, for processing, filing, organization, modification, research, recalling and analysis of data and data statistics, and for executing local or remote application software.
09 - Scientific and electric apparatus and instruments
35 - Advertising and business services
42 - Scientific, technological and industrial services, research and design
Goods & Services
(1) Computer software for software application development, namely, for creating customized software applications in the field of business intelligence and analysis; database and business intelligence and analysis software, namely, for developing and executing a business rules engine, for use in business decision making, for business rules management, for monitoring and aggregating data from multiple sources and applying rules to discover patterns and trends in the data, for triggering responses to predefined conditions and events, for processing, filing, organization, modification, research, recalling and analysis of data and data statistics, and for executing local or remote application software. (1) Online store services, namely, operating online marketplaces for buying, selling, sharing and offering for free computer software, provided via the Internet and other computer and telecommunication networks.
(2) Computer programming services, namely, programming of data management software; consulting in the field of design, installation, development, maintenance and use of data management software.
(3) Cloud computing featuring a software platform for software application development, namely, for creating customized software applications in the field of business intelligence and analysis; Cloud computing featuring a software platform in the field of database and business intelligence and analysis, namely, for developing and executing a business rules engine, for use in business decision making, for business rules management, for monitoring and aggregating data from multiple sources and applying rules to discover patterns and trends in the data, for triggering responses to predefined conditions and events, for processing, filing, organization, modification, research, recalling and analysis of data and data statistics, and for executing local or remote application software.
(4) Technical support services, namely,assisting customers with troubleshooting of computer software problems for data management software.
09 - Scientific and electric apparatus and instruments
42 - Scientific, technological and industrial services, research and design
Goods & Services
(1) Computer software for software application development, namely, for creating customized software applications in the field of business intelligence and analysis, for developing and executing a business rules engine, for use in business decision making, for business rules management, for monitoring and aggregating data from multiple sources and applying rules to discover patterns and trends in the data, for triggering responses to predefined conditions and events, for processing, filing, organization, modification, research, recalling and analysis of data and data statistics, and for executing local or remote application software (1) Consulting in the field of design, installation, development, maintenance and use of data management software
(2) Cloud computing featuring a software platform for software application development, namely, for creating customized software applications in the field of business intelligence and analysis, for developing and executing a business rules engine, for use in business decision making, for business rules management, for monitoring and aggregating data from multiple sources, for triggering responses to predefined conditions and events, and for executing local or remote application software
(3) Technical support services, namely, assisting customers with troubleshooting of computer software problems for data management software
09 - Scientific and electric apparatus and instruments
35 - Advertising and business services
42 - Scientific, technological and industrial services, research and design
Goods & Services
Computer software for software application development, for developing and executing a business rules engine, for use in business decision making, for business rules management, for monitoring and aggregating data from multiple sources and applying rules to discover patterns and trends in the data, for triggering responses to predefined conditions and events, for processing, filing, organization, modification, research, recalling and analysis of data and data statistics, and for executing local or remote application software. Online store services, namely, operating online marketplaces for buying, selling, sharing and offering for free computer software, provided via the Internet and other computer and communication networks. Cloud computing featuring a software platform for software application development, for developing and executing a business rules engine, for use in business decision making, for business rules management, for monitoring and aggregating data from multiple sources and applying rules to discover patterns and trends in the data, for triggering responses to predefined conditions and events, for processing, filing, organization, modification, research, recalling and analysis of data and data statistics, and for executing local or remote application software; computer programming services, namely, programming of data management software; consulting regarding the design, installation, development, maintenance and use of data management software; technical support services, namely, troubleshooting of computer software problems for data management software.
09 - Scientific and electric apparatus and instruments
35 - Advertising and business services
42 - Scientific, technological and industrial services, research and design
Goods & Services
Computer software for software application development, for developing and executing a business rules engine, for use in business decision making, for business rules management, for monitoring and aggregating data from multiple sources and applying rules to discover patterns and trends in the data, for triggering responses to predefined conditions and events, for processing, filing, organization, modification, research, recalling and analysis of data and data statistics, and for executing local or remote application software. Online store services, namely, operating online marketplaces for buying, selling, sharing and offering for free computer software, provided via the Internet and other computer and communication networks. Cloud computing featuring a software platform for software application development, for developing and executing a business rules engine, for use in business decision making, for business rules management, for monitoring and aggregating data from multiple sources and applying rules to discover patterns and trends in the data, for triggering responses to predefined conditions and events, for processing, filing, organization, modification, research, recalling and analysis of data and data statistics, and for executing local or remote application software; computer programming services, namely, programming of data management software; consulting regarding the design, installation, development, maintenance and use of data management software; technical support services, namely, troubleshooting of computer software problems for data management software.
09 - Scientific and electric apparatus and instruments
35 - Advertising and business services
42 - Scientific, technological and industrial services, research and design
Goods & Services
Computer software for software application development, for developing and executing a business rules engine, for use in business decision making, for business rules management, for monitoring and aggregating data from multiple sources and applying rules to discover patterns and trends in the data, for triggering responses to predefined conditions and events, for processing, filing, organization, modification, research, recalling and analysis of data and data statistics, and for executing local or remote application software Online store services, namely, operating online marketplaces for buying [, selling, sharing and offering for free ] computer software, provided via the Internet and other computer and communication networks Cloud computing featuring a software platform for software application development, for developing and executing a business rules engine, for use in business decision making, for business rules management, for monitoring and aggregating data from multiple sources and applying rules to discover patterns and trends in the data, for triggering responses to predefined conditions and events, for processing, filing, organization, modification, research, recalling and analysis of data and data statistics, and for executing local or remote application software; computer programming services, namely, programming of data management software; consulting regarding the design, installation, development, maintenance and use of data management software; technical support services, namely, troubleshooting of computer software problems for data management software
The same data is stored in at least two different database management systems (DBMS's), including a columnar DBMS (320.2) and a non-columnar (e.g. row-oriented) DBMS (320.1). The columnar DBMS may provide fast responses to queries involving aggregation, and such queries can be routed to the columnar DBMS. A query may be routed to the non-columnar DBMS if for example the query execution involves only small DBMS tables on the non-columnar DBMS. In some situations, an execution time estimate can be obtained from each DBMS, and the query is routed to the DBMS providing the shortest estimate.
The execution environment provides for scalability where components will execute in parallel and exploit various patterns of parallelism. Dataflow applications are represented by reusable dataflow graphs called map components, while the executable version is called a prepared map. Using runtime properties the prepared map is executed in parallel with a thread allocated to each map process. The execution environment not only monitors threads, detects and corrects deadlocks, logs and controls program exceptions, but also data input and output ports of the map components are processed in parallel to take advantage of data partitioning schemes. Port implementation supports multi-state null value tokens to more accurately report exceptions. Data tokens are batched to minimize synchronization and transportation overhead and thread contention.
G06F 15/16 - Combinations of two or more digital computers each having at least an arithmetic unit, a program unit and a register, e.g. for a simultaneous processing of several programs
Storage mediums and a computer-implemented method for automating web navigation and content extraction are provided. In particular, a storage medium with program components which are executable through a common application program interface and are utilizable by a developer to write programming instructions is provided. In some cases, the storage medium may include a program component for adaptively navigating through one or more websites and another program component for extracting scripted content from the one or more websites. In addition or alternatively, the storage medium may include a program component for standardizing content on a web page. In some cases, the storage medium may be configured to allow a user to include XPath query language in program instructions written from the storage medium. A storage medium comprising program instructions executable using a processor for performing such functions and a computer-implemented method employing such processes are also provided herein.
G06F 9/44 - Arrangements for executing specific programs
G06F 17/30 - Information retrieval; Database structures therefor
G06F 15/16 - Combinations of two or more digital computers each having at least an arithmetic unit, a program unit and a register, e.g. for a simultaneous processing of several programs
G06F 15/173 - Interprocessor communication using an interconnection network, e.g. matrix, shuffle, pyramid, star or snowflake
57.
System and method for data transformation using dataflow graphs
A system and method for managing data, such as in a data warehousing, analysis, or similar applications, where dataflow graphs are expressed as reusable map components, at least some of which are selected from a library of components, and map components are assembled to create an integrated dataflow application. Composite map components encapsulate a dataflow pattern using other maps as subcomponents. Ports are used as link points to assemble map components and are hierarchical and composite allowing ports to contain other ports. The dataflow application may be executed in a parallel processing environment by recognizing the linked data processes within the map components and assigning threads to the linked data processes.
G06F 9/44 - Arrangements for executing specific programs
G06F 9/45 - Compilation or interpretation of high level programme languages
G06F 7/38 - Methods or arrangements for performing computations using exclusively denominational number representation, e.g. using binary, ternary, decimal representation
G06F 13/12 - Program control for peripheral devices using hardware independent of the central processor, e.g. channel or peripheral processor
09 - Scientific and electric apparatus and instruments
41 - Education, entertainment, sporting and cultural services
42 - Scientific, technological and industrial services, research and design
Goods & Services
Computer software; downloadable software; data management software; object database management software; computer software for development of database software applications; computer software for online catalog management; computer software for management of data in embedded systems and applications. Computer education training services; providing mentoring, on-site, and on-line training, seminars, webinars, and classes in the fields of computer software, database administration, business systems, and computer systems. Computer consultation; computer project management services; database development services; computer network architecture design; computer diagnostic services; computer programming for others; computer software consultation, design and development; computer systems analysis; consulting services in the field of design, selection; implementation and use of computer hardware and software systems for others; customization of computer hardware and software; installation and maintenance of computer software; integration of computer systems and networks; technical support services, namely, troubleshooting of computer hardware and software problems.
09 - Scientific and electric apparatus and instruments
16 - Paper, cardboard and goods made from these materials
35 - Advertising and business services
41 - Education, entertainment, sporting and cultural services
42 - Scientific, technological and industrial services, research and design
Goods & Services
(1) Computer software for data extraction, storage and access of databases, key indexed computer files and records; computer software tools for developing and managing databases and enhancing their productivity.
(2) Computer software for tracking, monitoring and diagnosing database information and business processes, and for providing alerts and reports of access, usage and changes to database information and business processes; computer software for configuring, converting, entering, storing, managing, integrating, analyzing, securing, encrypting, monitoring, retrieving, maintaining, structuring, presenting and mapping data for the development, design, analysis, integration, deployment and maintenance of computer software; computer software for use in regulatory compliance; computer software for use in data conversion, data entry, data connectivity and data transformation, namely, the transformation of source data to a format that can be recognized and used by particular software application targets.
(3) Electronic newsletters featuring information on computers, computer software and technology; computer software manuals.
(4) Computer software for tracking, monitoring, displaying and diagnosing database information and business processes, and for providing alerts and reports of access, usage and changes to computer database information and business process; computer software for configuring, converting, entering, storing, managing, integrating, analyzing, securing, encrypting, monitoring, retrieving, maintaining, structuring, presenting and mapping data for the development, design, analysis, integration, deployment and maintenance of computer software for use in data conversion, data entry, data connectivity and data transformation, namely the transformation of source data to a format that can be recognized and used by particular software application targets.
(5) Newsletters featuring information on computers and computer software. (1) Online retail store services featuring computer software, software tools and manuals; business consulting services.
(2) Online retail store services featuring computer software, software tools and manuals.
(3) Educational services, namely conducting classes, seminars, conferences and workshops in the field of computer programs and software tools and distributing course materials in connection therewith; training in the use and operation of computer programs and software tools.
(4) Computer software design for others; computer software consultation and support.
09 - Scientific and electric apparatus and instruments
Goods & Services
(1) Computer software for general database management, namely computer software for tracking, monitoring and diagnosing computer database information and business processes, and for providing alerts and reports of access, usage and changes to computer database information and business processes, and user manuals sold as a unit.
09 - Scientific and electric apparatus and instruments
Goods & Services
Computer software for tracking, monitoring and diagnosing computer database information and business processes, and for providing alerts and reports of access, usage and changes to computer database information and business processes, and user manuals sold as a unit
09 - Scientific and electric apparatus and instruments
16 - Paper, cardboard and goods made from these materials
Goods & Services
Computer software for processing, monitoring and debugging computer database information, and for providing alerts and reports of access, usage and changes to computer database information. User manuals, reports and written computer software user documentation.
09 - Scientific and electric apparatus and instruments
Goods & Services
(1) Computers and computer software, namely computer programs for use in managing key indexed computer files, records management, and database applications and management; programming tools and utilities and programmer productivity enhancement software, and instructional manuals distributed therewith.
09 - Scientific and electric apparatus and instruments
Goods & Services
(1) Computers and computer software, namely computer programs for use in managing key indexed computer files, records management, and database applications and management; programming tools and utilities and programmer productivity enhancement software, and instructional manuals therefore.
09 - Scientific and electric apparatus and instruments
Goods & Services
(1) Computer software for database management, data access, data control and data manipulation and computer programming tools in the nature of computer programs to facilitate development of applications pertaining to manufacturing, financial planning, forecasting, business management, engineering, scientific research and development in the fields of relational database management systems, object oriented developmental tool applications, graphic user interface and character based developmental tool applications, interactive terminal monitors, rule systems, resources control systems, access control systems, query and reporting tool applications, application porting tool applications and connectivity tool applications.
09 - Scientific and electric apparatus and instruments
Goods & Services
computer programs for database management, data access, data control and data manipulation and computer programming tools in the nature of computer programs to facilitate development of applications pertaining to manufacturing, financial planning, forecasting, business management, engineering, scientific research and development in the fields of relational database management systems, object oriented developmental tool applications, graphic user interface and character based developmental tool applications, interactive terminal monitors, rule systems, resources control systems, access control systems, query and reporting tool applications, application porting tool applications and connectivity tool applications
