TAILIEUCHUNG - Managing time in relational databases- P9

Tham khảo tài liệu 'managing time in relational databases- p9', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | 144 Chapter 7 THE BASIC SCENARIO Occupied and Represented In subsequent discussions we will find it convenient to speak of time periods as being occupied by an object or equivalently of an object being represented in a time period by a managed object. In a conventional table a time period is occupied by an object just in case a row representing that object exists in its table throughout that time period. In an asserted version table a time period is occupied by an object just in case one or more contiguous versions representing that object span that time period or as we will also say occupy every clock tick in that time period. For example the clock tick of March 2010 is occupied by policy P861 just in case there is a row with the value P861 as its object identifier and which has an effective begin date less than or equal to March 2010 and an effective end date greater than March 2010. We can equivalently say that policy P861 is represented in the effective time clock tick of March 2010. Because Asserted Versioning is a method of managing bi-temporal data the time periods in question may be either effective time periods or assertion time periods. But we will often find it convenient to speak simply about versions and their effective times presupposing that the rows we are talking about all exist in current assertion time. Basic Temporal Transactions The Mental Model The mental model supported by basic temporal transactions is one which completely hides the temporality of the tables that those transactions maintain. As far as the user is concerned she submits transactions to a program which then submits them to the DBMS. It is no concern of hers that the program actually calls the AVF which after some translation and constraint checking submits one or more SQL transactions to the DBMS. Rather it seems to her that she is inserting updating or deleting rows in conventional tables. Consequently the user thinks about what she is doing in the same way whether she is .

TỪ KHÓA LIÊN QUAN
TÀI LIỆU MỚI ĐĂNG
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.