Matches in SemOpenAlex for { <https://semopenalex.org/work/W2271952601> ?p ?o ?g. }
- W2271952601 abstract "Bitemporal data has always been important. But it was not until 2011 that the ISO released a SQL standard that supported it. Currently, among major DBMS vendors, Oracle, IBM and Teradata now provide at least some bitemporal functionality in their flagship products. But to use these products effectively, someone in your IT organization needs to know more than how to code bitemporal SQL statements. Perhaps, in your organization, that person is you. To correctly interpret business requests for temporal data, to correctly specify requirements to your IT development staff, and to correctly design bitemporal databases and applications, someone in your enterprise needs a deep understanding of both the theory and the practice of managing bitemporal data. Someone also needs to understand what the future may bring in the way of additional temporal functionality, so their enterprise can plan for it. Perhaps, in your organization, that person is you. This is the book that will show the do-it-yourself IT professional how to design and build bitemporal databases and how to write bitemporal transactions and queries, and will show those who will direct the use of vendor-provided bitemporal DBMSs exactly what is going on under the covers of that software. Explains the business value of bitemporal data in terms of the information that can be provided by bitemporal tables and not by any other form of temporal data, including history tables, version tables, snapshot tables, or slowly-changing dimensions. Provides an integrated account of the mathematics, logic, ontology and semantics of relational theory and relational databases, in terms of which current relational theory and practice can be seen as unnecessarily constrained to the management of nontemporal and incompletely temporal data. Explains how bitemporal tables can provide the time-variance and nonvolatility hitherto lacking in Inmon historical data warehouses. Explains how bitemporal dimensions can replace slowly-changing dimensions in Kimball star schemas, and why they should do so. Describes several extensions to the current theory and practice of bitemporal data, including the use of episodes, whenever temporal transactions and queries, and future transaction time. Points out a basic error in the ISO's bitemporal SQL standard, and warns practitioners against the use of that faulty functionality. Recommends six extensions to the ISO standard which will increase the business value of bitemporal data. Points towards a tritemporal future for bitemporal data, in which an Aristotelian ontology and a speech-act semantics support the direct management of the statements inscribed in the rows of relational tables, and add the ability to track the provenance of database content to existing bitemporal databases. This book also provides the background needed to become a business ontologist, and explains why an IT data management person, deeply familiar with corporate databases, is best suited to play that role. Perhaps, in your organization, that person is you." @default.
- W2271952601 created "2016-06-24" @default.
- W2271952601 creator A5038032862 @default.
- W2271952601 date "2014-08-19" @default.
- W2271952601 modified "2023-09-29" @default.
- W2271952601 title "Bitemporal Data: Theory and Practice" @default.
- W2271952601 cites W1492581928 @default.
- W2271952601 cites W1493596129 @default.
- W2271952601 cites W1508412218 @default.
- W2271952601 cites W1531918044 @default.
- W2271952601 cites W155596183 @default.
- W2271952601 cites W1557907964 @default.
- W2271952601 cites W171028393 @default.
- W2271952601 cites W1796264214 @default.
- W2271952601 cites W184387631 @default.
- W2271952601 cites W1959945718 @default.
- W2271952601 cites W1971864291 @default.
- W2271952601 cites W1975884197 @default.
- W2271952601 cites W1983721754 @default.
- W2271952601 cites W1992015595 @default.
- W2271952601 cites W2000616942 @default.
- W2271952601 cites W2004851292 @default.
- W2271952601 cites W2008074204 @default.
- W2271952601 cites W2076784334 @default.
- W2271952601 cites W2078970516 @default.
- W2271952601 cites W2083150957 @default.
- W2271952601 cites W2108971776 @default.
- W2271952601 cites W2116470353 @default.
- W2271952601 cites W2137079713 @default.
- W2271952601 cites W2138709157 @default.
- W2271952601 cites W2141312052 @default.
- W2271952601 cites W2155041476 @default.
- W2271952601 cites W2158562456 @default.
- W2271952601 cites W2161484642 @default.
- W2271952601 cites W2288657397 @default.
- W2271952601 cites W2312350985 @default.
- W2271952601 cites W2460071091 @default.
- W2271952601 cites W2505109365 @default.
- W2271952601 cites W607089086 @default.
- W2271952601 hasPublicationYear "2014" @default.
- W2271952601 type Work @default.
- W2271952601 sameAs 2271952601 @default.
- W2271952601 citedByCount "13" @default.
- W2271952601 countsByYear W22719526012016 @default.
- W2271952601 countsByYear W22719526012017 @default.
- W2271952601 countsByYear W22719526012018 @default.
- W2271952601 countsByYear W22719526012019 @default.
- W2271952601 countsByYear W22719526012020 @default.
- W2271952601 countsByYear W22719526012021 @default.
- W2271952601 crossrefType "book" @default.
- W2271952601 hasAuthorship W2271952601A5038032862 @default.
- W2271952601 hasConcept C115903868 @default.
- W2271952601 hasConcept C144133560 @default.
- W2271952601 hasConcept C162853370 @default.
- W2271952601 hasConcept C171250308 @default.
- W2271952601 hasConcept C192562407 @default.
- W2271952601 hasConcept C2777338717 @default.
- W2271952601 hasConcept C41008148 @default.
- W2271952601 hasConcept C510870499 @default.
- W2271952601 hasConcept C55166926 @default.
- W2271952601 hasConcept C5655090 @default.
- W2271952601 hasConcept C70388272 @default.
- W2271952601 hasConcept C75949130 @default.
- W2271952601 hasConcept C77088390 @default.
- W2271952601 hasConceptScore W2271952601C115903868 @default.
- W2271952601 hasConceptScore W2271952601C144133560 @default.
- W2271952601 hasConceptScore W2271952601C162853370 @default.
- W2271952601 hasConceptScore W2271952601C171250308 @default.
- W2271952601 hasConceptScore W2271952601C192562407 @default.
- W2271952601 hasConceptScore W2271952601C2777338717 @default.
- W2271952601 hasConceptScore W2271952601C41008148 @default.
- W2271952601 hasConceptScore W2271952601C510870499 @default.
- W2271952601 hasConceptScore W2271952601C55166926 @default.
- W2271952601 hasConceptScore W2271952601C5655090 @default.
- W2271952601 hasConceptScore W2271952601C70388272 @default.
- W2271952601 hasConceptScore W2271952601C75949130 @default.
- W2271952601 hasConceptScore W2271952601C77088390 @default.
- W2271952601 hasLocation W22719526011 @default.
- W2271952601 hasOpenAccess W2271952601 @default.
- W2271952601 hasPrimaryLocation W22719526011 @default.
- W2271952601 hasRelatedWork W103502898 @default.
- W2271952601 hasRelatedWork W1512659795 @default.
- W2271952601 hasRelatedWork W1580875491 @default.
- W2271952601 hasRelatedWork W1590160690 @default.
- W2271952601 hasRelatedWork W1969681983 @default.
- W2271952601 hasRelatedWork W2003339759 @default.
- W2271952601 hasRelatedWork W2103028615 @default.
- W2271952601 hasRelatedWork W2222925130 @default.
- W2271952601 hasRelatedWork W2226658182 @default.
- W2271952601 hasRelatedWork W2251695047 @default.
- W2271952601 hasRelatedWork W2341878560 @default.
- W2271952601 hasRelatedWork W2370236386 @default.
- W2271952601 hasRelatedWork W2470995396 @default.
- W2271952601 hasRelatedWork W2488763094 @default.
- W2271952601 hasRelatedWork W2508962983 @default.
- W2271952601 hasRelatedWork W2884769809 @default.
- W2271952601 hasRelatedWork W3092716950 @default.
- W2271952601 hasRelatedWork W3190585394 @default.
- W2271952601 hasRelatedWork W43703889 @default.
- W2271952601 hasRelatedWork W639099575 @default.