15,635 research outputs found
Open issues in semantic query optimization in relational DBMS
After two decades of research into Semantic Query Optimization (SQO) there is clear agreement as to the efficacy of SQO. However, although there are some experimental implementations there are still no commercial implementations. We
first present a thorough analysis of research into SQO. We identify three problems which inhibit the effective use of SQO in Relational Database Management Systems(RDBMS). We then propose solutions to these problems and describe first steps towards the implementation of an effective semantic query optimizer for relational databases
Development of 2MASS Catalog Server Kit
We develop a software kit called "2MASS Catalog Server Kit" to easily
construct a high-performance database server for the 2MASS Point Source Catalog
(includes 470,992,970 objects) and several all-sky catalogs. Users can perform
fast radial search and rectangular search using provided stored functions in
SQL similar to SDSS SkyServer. Our software kit utilizes open-source RDBMS, and
therefore any astronomers and developers can install our kit on their personal
computers for research, observation, etc. Out kit is tuned for optimal
coordinate search performance. We implement an effective radial search using an
orthogonal coordinate system, which does not need any techniques that depend on
HTM or HEALpix. Applying the xyz coordinate system to the database index, we
can easily implement a system of fast radial search for relatively small (less
than several million rows) catalogs. To enable high-speed search of huge
catalogs on RDBMS, we apply three additional techniques: table partitioning,
composite expression index, and optimization in stored functions. As a result,
we obtain satisfactory performance of radial search for the 2MASS catalog. Our
system can also perform fast rectangular search. It is implemented using
techniques similar to those applied for radial search. Our way of
implementation enables a compact system and will give important hints for a
low-cost development of other huge catalog databases.Comment: 2011 PASP accepte
Innovative Evaluation System – IESM: An Architecture for the Database Management System for Mobile Application
As the mobile applications are constantly facing a rapid development in the recent years especially in the academic environment such as student response system [1-8] used in universities and other educational institutions; there has not been reported an effective and scalable Database Management System to support fast and reliable data storage and retrieval. This paper presents Database Management Architecture for an Innovative Evaluation System based on Mobile Learning Applications. The need for a relatively stable, independent and extensible data model for faster data storage and retrieval is analyzed and investigated. It concludes by emphasizing further investigation for high throughput so as to support multimedia data such as video clips, images and documents
AKARI-CAS --- Online Service for AKARI All-Sky Catalogues
The AKARI All-Sky Catalogues are an important infrared astronomical database
for next-generation astronomy that take over the IRAS catalog. We have
developed an online service, AKARI Catalogue Archive Server (AKARI-CAS), for
astronomers. The service includes useful and attractive search tools and visual
tools.
One of the new features of AKARI-CAS is cached SIMBAD/NED entries, which can
match AKARI catalogs with other catalogs stored in SIMBAD or NED. To allow
advanced queries to the databases, direct input of SQL is also supported. In
those queries, fast dynamic cross-identification between registered catalogs is
a remarkable feature. In addition, multiwavelength quick-look images are
displayed in the visualization tools, which will increase the value of the
service.
In the construction of our service, we considered a wide variety of
astronomers' requirements. As a result of our discussion, we concluded that
supporting users' SQL submissions is the best solution for the requirements.
Therefore, we implemented an RDBMS layer so that it covered important
facilities including the whole processing of tables. We found that PostgreSQL
is the best open-source RDBMS products for such purpose, and we wrote codes for
both simple and advanced searches into the SQL stored functions. To implement
such stored functions for fast radial search and cross-identification with
minimum cost, we applied a simple technique that is not based on dividing
celestial sphere such as HTM or HEALPix. In contrast, the Web application layer
became compact, and was written in simple procedural PHP codes. In total, our
system realizes cost-effective maintenance and enhancements.Comment: Yamauchi, C. et al. 2011, PASP..123..852
- …