Regional Bitmap Index: A Secondary Index for Data Management in Could Computing Environment

2012 ◽  
Vol 35 (11) ◽  
pp. 2306 ◽  
Author(s):  
Bi-Ping MENG ◽  
Teng-Jiao WANG ◽  
Hong-Yan LI ◽  
Dong-Qing YANG
Keyword(s):  
Data Management ◽  
Computing Environment ◽  
Bitmap Index ◽  
Secondary Index

Secondary Index

2017 ◽  
pp. 1-2
Author(s):  
Yannis Manolopoulos ◽  
Yannis Theodoridis ◽  
Vassilis J. Tsotras
Keyword(s):  
Secondary Index

scholarly journals High Performance Secondary Index Design for Complex Queries in Smart Grid System

2019 ◽  
Vol 1346 ◽  
pp. 012004
Author(s):  
Qin Jiafeng ◽  
Shu Shitai ◽  
Li Longlong ◽  
Li Chengqi ◽  
Bai Demeng ◽  
...  
Keyword(s):  
Smart Grid ◽  
High Performance ◽  
Grid System ◽  
Complex Queries ◽  
Secondary Index ◽  
Smart Grid System

The Social Integration of American Cities: Network Measures of Connectedness Based on Everyday Mobility Across Neighborhoods

2019 ◽  
pp. 004912411985238 ◽  
Author(s):  
Nolan E. Phillips ◽  
Brian L. Levy ◽  
Robert J. Sampson ◽  
Mario L. Small ◽  
Ryan Q. Wang
Keyword(s):  
Social Integration ◽  
Racial Segregation ◽  
Equal Proportion ◽  
Original Network ◽  
Social Phenomena ◽  
The Social ◽  
Secondary Index ◽  
The Everyday ◽  
Broad Array ◽  
American Cities

The social integration of a city depends on the extent to which people from different neighborhoods have the opportunity to interact with one another, but most prior work has not developed formal ways of conceptualizing and measuring this kind of connectedness. In this article, we develop original, network-based measures of what we call “structural connectedness” based on the everyday travel of people across neighborhoods. Our principal index captures the extent to which residents in each neighborhood of a city travel to all other neighborhoods in equal proportion. Our secondary index captures the extent to which travels within a city are concentrated in a handful of receiving neighborhoods. We illustrate the value of our indices for the 50 largest American cities based on hundreds of millions of geotagged tweets over 18 months. We uncover important features of major American cities, including the extent to which their connectedness depends on a few neighborhood hubs, and the fact that in several cities, contact between some neighborhoods is all but nonexistent. We also show that cities with greater population densities, more cosmopolitanism, and less racial segregation have higher levels of structural connectedness. Our indices can be applied to data at any spatial scale, and our measures pave the way for more powerful and precise analyses of structural connectedness and its effects across a broad array of social phenomena.

Implementation of a Prefetch method for Secondary Index Scan in MySQL InnoDB Engine

2017 ◽  
Vol 44 (2) ◽  
pp. 208-212
Author(s):  
Dasom Hwang ◽  
Sang-Won Lee
Keyword(s):  
Secondary Index
Sign in / Sign up

Export Citation Format

Share Document