We explore the global and local condensate and superfluid (SF) fractions in a system of a few hard core (HC) bosons (N=8 and N=40) trapped inside a combined harmonic optical cubic lattice (CHOCL) at T=0 K. The condensate fraction (CF) is computed for individual lattice wells by separating the one-body density matrix (OBDM) of the whole system into components at the various lattice sites. Then each lattice-site component is diagonalized to find its eigenvalues. The eigenvalues are obtained by a method presented earlier [Dubois and Glyde, Phys. Rev. A {\bf 63}, 023602 (2001)]. The effects of interference between the condensates in the lattice wells on the CF in one well is also investigated. The SF fraction (SFF) is calculated for N=40 by using the diffusion formula of Pollock and Ceperley [Pollock and Ceperley, Phys. Rev. B {\bf 36}, 8343 (1987)]. Our chief result is an opposing behavior of the global CF and SFF with increasing lattice wave vector
k. In addition, the CF in a lattice well is enhanced by the interference with its neighbor wells beyond the result when the interference is neglected. The global SF is depleted with a rise of the repulsion between the bosons, yet at very strong interaction superfluidity is still present. The global CF remains almost constant with increasing HC repulsion. A reduction in the lattice dimension, i.e. an increase in the lattice wave vector, increases the local CF in each lattice well, but reduces the corresponding local SFF. At large HC repulsion, a coexisting SF-(vacuum)MI phase is established.
The superfluid-to-Anderson-insulator transition of a strongly repulsive Bose gas is studied in a one-dimensional incommensurate optical lattice. In the hard-core limit, the Bose-Fermi mapping allows us to deal with the system using the exact numerical method. Based on the Aubry-Andr\'e model, we exploit the phase transition of the hard-core boson system from the superfluid phase with all single-particle states extended to the Bose-glass phase with all the single-particle states being Anderson localized as the strength of the incommensurate potential increases relative to the hopping amplitude. We evaluate the superfluid fraction, one-particle density matrices, momentum distributions, the natural orbitals, and their occupations. All of these quantities show that there exists a superfluid-to-insulator phase transition in the system.
The properties of a mixture of mutually interacting bound electron pairs and itinerant fermions (the boson-fermion model) on a lattice are further studied. We determine the superconducting critical temperature from a pseudogap phase by applying a self-consistent
T-matrix approach, which includes the pairing fluctuations and the boson self-energy effects. The analysis is made for a three dimensional cubic lattice with tight-binding dispersion for electrons and for both standard bosons and the case of hard-core bosons. The results describe the BCS-Bose-Einstein condensation crossover with varying position of the bosonic (local pair) level and give a further insight into the nature of resonance superfluidity in the boson-fermion model.