KMITL

Permanent URI for this communityhttps://dspace.kmitl.ac.th/handle/123456789/1

Browse

Search Results

Now showing 1 - 9 of 9

Some of the metrics are blocked by your
consent settings
A belief-based bitemporal database model
(2015-01-01)
Jiratanachit, Wajee
;
Chittayasothorn, Suphamit
Current bitemporal data models use valid time and transaction time to indicate the time that a fact is valid in a domain, and the time that the fact is stored in a database respectively. In order to store historical data with different beliefs during the same valid time period, there need to be a time dimension which indicates the belief time; the time that the fact is believed to be true. This belief time is different from the conventional transaction time, which is the time that the fact is entered into the database. In this paper, a belief-based approach to bitemporal data model is presented together with its query and manipulation considerations.
Some of the metrics are blocked by your
consent settings
Temporal database application in industrial human resource management
(2014-01-01)
Pornphol, Putsadee
;
Chittayasothorn, Suphamit
Temporal database is an established database technology which has recently been introduced to the industrial and commercial world. Temporal database features are available through specialized modules of commercial database management systems (DBMS). The SQL 2011 standard also includes temporal database features; even though at the time of this paper writing, not many DBMS products comply with the standard. We found temporal database features suitable for human resource applications and apply it in a rubber processing plant in southern Thailand. This paper demonstrates the temporal database design using a conceptual schema approach and temporal database implementations at the SQL level.
Some of the metrics are blocked by your
consent settings
Valid time database implementation using Oracle11g Workspace Manager
(2012-12-01)
Rugtanom, Sitti
;
Chittayasothorn, Suphamit
Valid time database comprises valid time state tables, which keep facts that are currently true, believed to be true in the past, and expected to be true in the future. Temporal queries on these tables are both useful and necessary for many applications. However, the introduction of valid time periods to database tables leads to complex data manipulations especially delete and update operations. Conventional Database Management Systems users have to use standard SQL to handle temporal queries and temporal data manipulations which lead to long and complicated SQL statements. This paper investigates the valid time temporal database features which are available in Oracle11g. We found that the Oracle11g Workspace Manager provides valid time temporal database operations comparable to those appear in temporal database literatures.
Some of the metrics are blocked by your
consent settings
A conceptual schema-based temporal meta database schemas generation technique for 3D objects
(2010-01-01)
Chau, Vo Thi Ngoc
;
Chittayasothorn, Suphamit
In this paper, a temporal meta database for three-dimensional (3D) objects whose properties and relationships are supported by valid time is introduced. Based on our proposed temporal object-oriented conceptual schema model, a conceptual schema of the temporal meta database can be generated from a 3D graphical data source and other particular application requirements. Based on our proposed temporal object relational data model with attribute timestamping, logical schemas of the temporal meta database can be systematically and automatically generated from the conceptual schema. From the temporal meta database, non-temporal/temporal metadata about temporal 3D objects are available for temporal information system users. Convenient access using database languages such as SQL can be performed. Queries over 3D objects using a temporal object relational SQL are demonstrated. © 2009 Springer-Verlag London Limited.
Some of the metrics are blocked by your
consent settings
Toward fuzzy temporal databases with temporal fuzzy linguistic terms
(2009-12-11)
Soysangwarn, Sureeporn
;
Chittayasothorn, Suphamit
Fuzzy databases have been proposed by many researchers for handling fuzziness in databases. Fuzzy linguistic terms are used instead of crisp values. They find applications in areas where exact or crisp values cannot always be obtained. In another database research area, temporal databases find applications where facts which are true in the past, as well as facts that will be true in the future are recorded together with current facts. There are also cases where fuzzy databases are also temporal. In most other works, fuzzy facts are temporal or the time itself is fuzzy. This paper presents the concept of a different fuzzy database where fuzzy linguistic terms are temporal. Sample queries and meta tables for temporal similarity degrees and temporal possibility distribution are also presented. ©2009 IEEE.
Some of the metrics are blocked by your
consent settings
Temporal 3D graphical data management from a database perspective
(2009-11-16)
Chau, Vo Thi Ngoc
;
Chittayasothorn, Suphamit
According to recent advances in computer science and engineering, three dimensional (3D) graphical data is of growing interest in many application areas. In this paper, a data management technique is proposed to handle 3D graphical data with the time dimension from a database perspective. Different from the existing works, our technique deals with 3D graphical data in all of the three various aspects: the visual aspect for the 3D graphical data part, the semantic aspect for the metadata part, and especially the temporal aspect for changes over the time. As a result, 3D graphical data can be managed properly with semantics and time. Therefore, many front-end applications can conveniently have access to them at both graphical and semantic data levels for sharability and reusability. © 2009 IEEE.
Some of the metrics are blocked by your
consent settings
A temporal object relational SQL language with attribute timestamping in a temporal transparency environment
(2008-12-01)
Chau, Vo Thi Ngoc
;
Chittayasothorn, Suphamit
In this paper, a temporal object relational SQL language is proposed. It is intended to facilitate the non-procedural data definitions, queries, and modifications of temporal databases with attribute timestamping in a temporal transparency environment. With attribute timestamping, temporal data of any type is naturally handled. With temporal logic, users can issue temporal queries in an intuitively expressive manner. The language provides valid time support for upward compatibility, temporal upward compatibility, sequenced and non-sequenced variants to serve both non-temporal and temporal users. Using object relational technology, the implementation is made for embedded and interactive SQL modes. All existing interfaces of an ORDBMS are inherited with temporal transparency. © 2008 Elsevier B.V. All rights reserved.
Some of the metrics are blocked by your
consent settings
Toward a temporal object database workbench
(2008-12-01)
Soysangwarn, Sureeporn
;
Chittayasothorn, Suphamit
Nowadays the application of temporal databases in modern information systems becomes more and more popular. Time-varying information with valid time, transaction time or both are required by typical applications such as human resource management, medical information systems, agriculture and farm management. Also, the object-oriented paradigm is now the standard paradigm for software development. Object databases are widely available commercially. However, the concept of temporal database is still not included as a standard feature and the users have to implement them at the application level. This paper presents temporal object database implementation techniques. The techniques can accommodate attribute timestamping both at the object class and the association between object classes. A software tool based on the proposed techniques is developed.
Some of the metrics are blocked by your
consent settings
A temporal compatible object relational database system
(2007-01-01)
Vo, Thi Ngoc Chau
;
Chittayasothorn, Suphamit
Time-varying data management has been much taken into consideration with either the tuple(object)timestamping or attribute-timestamping scheme. The first scheme is simpler with first normal form relations; but the second is more expressive and natural with unnormalized tables. However, no existing database management system has supported the handling of attribute timestamping on such unnormalized tables. In addition, even though planned for a long time, standards SQL have not yet been published with any temporal semantics. Moreover, there exists no available environment where both temporal and nontemporal database users work together with different awareness of temporal aspects of a database. Therefore, to facilitate the temporal data management according to users' needs and their own ability in data manipulations, a database system is figured out with several types of database users in this paper. It is a temporal object relational database system following the attribute timestamping scheme, allowing upward compatibility with SQL:2003 and temporal upward compatibility. The implementation is carried out on Oracle 10g without the introduction of any new temporal clauses into SQL:2003. As a result, both temporal and nontemporal database users do not have to make any effort to use this system © 2007 IEEE.

KMITL

Browse

Filters

Settings

Sort By

Results per page

Search Results