add bulk insert & extract ranking into app layer