Abstract: Embodiments relate to a system, method, and device for index compilation to optimize index. Once a CREATE INDEX commands is fired, a first check determines if the user requested has to compile this index. If the index is to be compiled, a corresponding C-file is generated, and a DLL is generated out of the C-file. The DLL is then loaded with server. An INDEX DLL is natively compiled and generated corresponding to each INDEX during definition. The INDEX DLL will contain the required structure and method to perform on INDEX, based on the indexed column data-type.

Abstract: A system and method of caching and parameterizing intermediate representation code includes receiving, by a database, a query, parsing, by the database, the query to obtain a plan tree comprising a plurality of plan nodes arranged in hierarchical order descending from a top plan node, generating, by the database, node intermediate representations (IRs) for the plan nodes, executing, by the database, a first query using the node IRs, and reusing, by the database, the node IRs to execute subsequent queries.

Abstract: A method of optimizing query execution by associating functions with columns includes receiving, by a query optimization server, data definition statement including information of one or more columns and function information for each of the one or more columns. The query optimization server associates the columns having the function information with corresponding predefined functions and stores in a memory. Upon receiving a query comprising a function associated to a column, the query optimization server compares the function with predefined functions stored in the memory. The query optimization server accesses the predefined function from the memory for executing the query based on the comparison.

Abstract: Embodiments relate to a system, method, and device for index compilation to optimize index. Once a CREATE INDEX commands is fired, a first check determines if the user requested has to compile this index. If the index is to be compiled, a corresponding C-file is generated, and a DLL is generated out of the C-file. The DLL is then loaded with server. An INDEX DLL is natively compiled and generated corresponding to each INDEX during definition. The INDEX DLL will contain the required structure and method to perform on INDEX, based on the indexed column data-type.

Abstract: An apparatus and method for creating user defined variable size tags on records in relational database management systems (RDBMS)are disclosed. When creating a table, one of the columns may be created as a new data-type called a “TAG” data-type. The new data-type called “TAG” is used to store various values for a single column against the single record.

Abstract: A system and method to optimize queries on a view comprise a processor coupled to a memory storing a plurality of instructions for directing the processor to receive a query comprising a part of query on view, check, based on the part of query on view, in system table, wherein the system table comprises a status associated with the view indicating the compilation of the view, and if the part of query on view found in the system table, fetch a shared object file storing at least one compilation function associated with the part of query on view, use the compilation function as a part of a query execution plan, and execute the query execution plan to display the result.

Abstract: A method for optimizing query execution comprises receiving one or more optimizing parameters from a user device for optimizing a query execution plan. The one or more optimizing parameters comprise at least one of a query statement, a planning time and a plan execution time. The one or more optimizing parameters are received when duration of execution of the one or more queries using the query execution plan is greater than a predefined time period required for executing the one or more queries. The query execution plan is latest of one or more query execution plans for executing one or more queries. The method comprises generating an optimized query execution plan by iterating optimization of the query execution plan until the optimization satisfies the one or more optimizing parameters.

Abstract: A system and method of caching and parameterizing intermediate representation code includes receiving, by a database, a query, parsing, by the database, the query to obtain a plan tree comprising a plurality of plan nodes arranged in hierarchical order descending from a top plan node, generating, by the database, node intermediate representations (IRs) for the plan nodes, executing, by the database, a first query using the node IRs, and reusing, by the database, the node IRs to execute subsequent queries.

Abstract: A method and system for automatic management of dynamically allocated memory in a computer where the system comprises one or more client machines, a communication network and a computer. The one or more users provide one or more queries to access data from the computer and the client machines send the received queries to the computer through the communication network. The processor configured in the computer creates a heap record upon identifying the received queries to be at least one INSERT, DELETE and first type of UPDATE. The heap record is stored in data segment of the one or more databases and when the received queries is second type of UPDATE, the processor creates an undo record and stores the undo record in undo segment of the databases.