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 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: 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 system and method for multi-master synchronous replication optimization, which comprises one device in a system is chosen as insert leader during insert. The insert leader allocates a range of rows (row_ids) to the incoming queries. If the query inserts more records than the range, it is rolled back. During the commit, the row_id range and the new records are sent to other masters for conflict checking. The present disclosure scalability and a throughput of the system is increased because of optimistic concurrency based replication.