28th Feb, 2016
Avalon Consulting Solutions Inc
Question
Asked 24th Feb, 2016
Are there any relational databases which rebuild multiple indexes simultaneously? That is, without multiple full table scans?
One of the barriers to rebuilding tables in Oracle's relational database is that on a table with multiple indexes, the system has to rebuild each index with a separate full table scan. It seems that a "full table scan" should have all of the columns (for all of the indexes) in one pass, but I haven't found any way to do this. Some database systems lock operations during the building of indexes, so this problem becomes even more significant.
Thank you in advance.
Most recent answer
Dear Bruce,
Thank you for this information, this is very helpful. This website and the keywords are a very good idea.
Regards,
Kevin.
All Answers (4)
Dear Kevin,
Consider the literature on X-tree and other multidimensional indexes; these have been implemented "in" or "on" commercial products.
Dear Bruce,
Thanks for the information. Might you know of a commercial relational database product in which these X-tree or other multidimensional indexes have been deployed? My research interest is mostly with OLTP systems rather than OLAP systems.
Dear Kevin,
Even Microsoft has some data_cube support in sql databases. SAP has HANA.
Have a look at http://www.hyper-db.com
From there you will find keywords to search for whatever you need - this is a pretty active field.
Similar questions and discussions
How to extract particular elements and nodes from ODB model and create New ODB file for that ?
Hi All,
i am new to abaqus scripting.i have been trying to extract particular elements and nodes from the bigger ODB file, along with load and boundary conditions and do analysis and create a new ODB file for that particular elements and nodes.Result of the elements may or may not be same.so please help me with you knowledge and experiences .
Related Publications
Standard Data Access Interface (SDAI) in STEP isolates the application program from the underlying data storage system. SDAI contains a functional definition part and several specific programming language bindings. This paper describes an architecture to implement SDAI late binding on relational database systems. The architecture has a database lay...
No discussion of relational databases would be complete without a reference to Edgar Codd’s 1970 paper “A Relational Model of Data for Large Shared Data Banks”. This was a mathematical description of what we now call Relational databases and operations to manipulate them. This is called relational algebra where data could be organised into relation...
The evaluation of a heterogeneous distributed-memory Meiko Oracle platform is discussed, along with an investigation into the possible cost-performance benefits and implementation issues associated with the transfer of a commercial database application from sequential machines to a parallel one. The discussion includes an overview of the hardware,...
