p*1
2 楼
HP申请一个create partially sorted index的专利 (US 2008/0104102)。
"To provide an index for a table in a database system, the index is
partially sorted in an initial phase of building the index. Subsequently, in
response to accessing portions of the index to process a database query,
further sorting of the accessed portions of the index is performed."
it is using B-Tree, divid index into different internal nodes, will sort the nodes (but not the entire tree). where each node may overlap with each other.
"To provide an index for a table in a database system, the index is
partially sorted in an initial phase of building the index. Subsequently, in
response to accessing portions of the index to process a database query,
further sorting of the accessed portions of the index is performed."
it is using B-Tree, divid index into different internal nodes, will sort the nodes (but not the entire tree). where each node may overlap with each other.
n*y
3 楼
I k this song...
【在 g******n 的大作中提到】
【在 g******n 的大作中提到】
v*r
4 楼
Oracle 的 B-Tree 是 fully sorted,好像没有这种 partilly sorted 的
implementation. 和 "fully sorted" 比较， "partilly sorted" 应该speed up
insert new record, but will slow down query using index.
implementation. 和 "fully sorted" 比较， "partilly sorted" 应该speed up
insert new record, but will slow down query using index.
s*s
5 楼
顶 五轮真弓
m*n
6 楼
I love this song
相关阅读
who know deductive database?Enterprise Application Integration(EAI)关于数据库有什么可学的呢?sosHow to extract data from webwant help on RDBMSRe: another job[转载] LDAP + SQL[转载] what's the equivalent of 'minus' (oracle) in access?link and destroy the link in access 97Any Chinese Tutorial for Access Programming?如何建基于WWW的BBS?datawarehouse, datamining网上哪里有便宜的PC有谁会用ode4.1?如何在PB5中调用Delphi4做的DLLLooking for ODBC Resouces --- New Standard?请教C++制作数据库的问题how to do a case insensitive comparisonPattern Match in Oracle