Database Integrity最新文献

Functional Dependencies for Value Based Identification in Object-Oriented Databases 面向对象数据库中基于值识别的功能依赖

Database Integrity Pub Date : 1900-01-01 DOI: 10.4018/978-1-930708-38-9.CH008

J. Rasch, H. Klein

引用次数: 4

Integrity Constraints in Spatial Databases 空间数据库中的完整性约束

Database Integrity Pub Date : 1900-01-01 DOI: 10.4018/978-1-930708-38-9.CH005

Karla A. V. Borges, C. Davis, Alberto H. F. Laender

引用次数: 19

Translating Advanced Integrity Checking Technology to SQL 将高级完整性检查技术转换为SQL

Database Integrity Pub Date : 1900-01-01 DOI: 10.4018/978-1-930708-38-9.CH007

H. Decker

{"title":"Translating Advanced Integrity Checking Technology to SQL","authors":"H. Decker","doi":"10.4018/978-1-930708-38-9.CH007","DOIUrl":"https://doi.org/10.4018/978-1-930708-38-9.CH007","url":null,"abstract":"INTRODUCTION The main goal of this chapter is to arrive at a coherent technology for deriving efficient SQL triggers from declarative specifications of arbitrary integrity constraints. The user may specify integrity constraints declaratively as closed queries in predicate calculus syntax (i.e., sentences in the language of first-order logic, abbr. FOL), as datalog denials, as query conditions in SQL WHERE clauses, or in some other, possibly more user-friendly manner (e.g., via a dialog-driven graphical or natural language interface which internally translates to equivalent WHERE clause conditions). As we are going to see, the triggers derived from such specifications behave such that whenever some update event would vi late any of the integrity constraints, one or several of the triggers derived from that constraint are activated in order to enforce the constraint. That is, the violation is either prevented by rolling back the update or repaired instantly by subsequent further updates. In this chapter, we describe how to implement advanced datalog technology for integrity checking in the framework of SQL. That is, we show how to represent and evaluate arbitrarily complex constraints in SQL without incurring major disadvantages usually associated to integrity checking in knowledge-rich applications. Error-prone procedural specification and laborious maintenance of integrity constraints is avoided by the declarativity of datalog. The cost of evaluation is considerably reduced by an automated","PeriodicalId":405229,"journal":{"name":"Database Integrity","volume":"113 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"1900-01-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"134224119","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}

引用次数: 20

Database Integrity: Fundamental and Current Implementations 数据库完整性:基本和当前的实现

Database Integrity Pub Date : 1900-01-01 DOI: 10.4018/978-1-930708-38-9.CH002

Laura C. Rivero, J. H. Doorn, Viviana E. Ferraggine

引用次数: 3

Integrity Maintenance in Extensible Databases 可扩展数据库中的完整性维护

Database Integrity Pub Date : 1900-01-01 DOI: 10.4018/978-1-930708-38-9.CH010

U. Schiel

{"title":"Integrity Maintenance in Extensible Databases","authors":"U. Schiel","doi":"10.4018/978-1-930708-38-9.CH010","DOIUrl":"https://doi.org/10.4018/978-1-930708-38-9.CH010","url":null,"abstract":"INTRODUCTION The use of databases for advanced applications is a rapidly growing and changing field, due to the continuous incorporation of new technologies and media in current systems. Whereas in the near past Database Management Systems (DBMS) mainly use to store and manage tabular data, now they need t model complex structured objects, multimedia data, semi-structured and unstructured documents. Each of these improvements has its own semantics and complexity. In order to allow an adequate description of database applications, data models are used to describe the conceptual schema of the database. If new categories of applications need to be incorporated or created, and the data model does not fit well with these applications, the model itself must be expanded. The semantics of the new constructs must be defined and the integrity of objects in the new constructs must be guaranteed. Since a DBMS is in general not expandable, except for future versions of the same product, there are two alternatives: (i) to move the whole application to another system that is capable to adequately process the new structures, or (ii) to develop specific routines, probably with its own storage systems, in order to incorporate the new application. Clearly both solutions are unsatisfactory. The first solution is only applicable if there exists a DBMS that considers the new structures. Even if it exists, moving to the new environment means reimplementation of the application, and this is very traumatic and demands","PeriodicalId":405229,"journal":{"name":"Database Integrity","volume":"4 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"1900-01-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"131696210","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}

引用次数: 0

Preserving Relationship Cardinality Constraints in Relational Schemata 关系模式中关系基数约束的保持

Database Integrity Pub Date : 1900-01-01 DOI: 10.4018/978-1-930708-38-9.CH003

D. Cuadra, Carlos Nieto, Paloma Martínez, Elena Castro, M. Velasco

引用次数: 10

Integrity Issues in the Web: Beyond Distributed Databases 网络中的完整性问题:超越分布式数据库

Database Integrity Pub Date : 1900-01-01 DOI: 10.4018/978-1-930708-38-9.CH009

J. F. A. Montes, Mariemma Inmaculada Yagüe del Valle, Antonio C. Gomez Lora

{"title":"Integrity Issues in the Web: Beyond Distributed Databases","authors":"J. F. A. Montes, Mariemma Inmaculada Yagüe del Valle, Antonio C. Gomez Lora","doi":"10.4018/978-1-930708-38-9.CH009","DOIUrl":"https://doi.org/10.4018/978-1-930708-38-9.CH009","url":null,"abstract":"INTRODUCTION Issues related to integrity in databases and distributed databases have been introduced in previous chapters. Therefore, the integrity problem in databases and how it can be managed in several data models (relational, active, temporal, geographical, and object-relational databases) are well known to the reader. The focus of this chapter is on introducing a new paradigm: The Web as the database, and its implications regarding integrity, i.e., the progressive adaptation of database techniques to Web usage. We consider that this will be done in a quite similar way to the evolution from integrated file management systems to database management systems. In any case, this will be a much more difficult goal and quite a lot of work is still to be done. The special features of the Web make things which are necessary on a database system just optional in this environment. On the other hand, some other things which are usually considered as essential parts of any database, are now disassembled into its building blocks and used as needed (Silberschatz & Zdonik, 1996; Bernstein et al., 1998). At first glance, the Web is a huge repository of information without any structure whatsoever. Nowadays, this is changing quickly. The consolidation of the Extensible Markup Language (XML,1998) as a new standard adopted","PeriodicalId":405229,"journal":{"name":"Database Integrity","volume":"2 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"1900-01-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"133179775","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}

引用次数: 5

Integrity Constraints in an Active Database Environment 活动数据库环境中的完整性约束

Database Integrity Pub Date : 1900-01-01 DOI: 10.4018/978-1-930708-38-9.CH004

J. M. Ale, M. Espil

引用次数: 1

Consistent Queries Over Databases with Integrity Constraints 具有完整性约束的数据库上的一致性查询

Database Integrity Pub Date : 1900-01-01 DOI: 10.4018/978-1-59140-553-5.CH093

S. Greco, E. Zumpano

{"title":"Consistent Queries Over Databases with Integrity Constraints","authors":"S. Greco, E. Zumpano","doi":"10.4018/978-1-59140-553-5.CH093","DOIUrl":"https://doi.org/10.4018/978-1-59140-553-5.CH093","url":null,"abstract":"INTRODUCTION Integrity constraints represent an important source of information about the real world. They are usually used to define constraints on data (functional dependencies, inclusion dependencies, etc.). Nowadays integrity constraints have a wide applicability in several contexts such as semantic query optimization, cooperative query answering, database integration and view update. Often databases may be inconsistent with respect to integrity constraints, that is, one or more integrity constraints are not satisfied. This may happen, for instance, when the database is obtained from the integration of different information sources. The integration of knowledge from multiple sources is an important aspect in several areas such as data warehousing, database integration, automated reasoning systems and active reactive databases. Since the satisfaction of integrity constraints cannot generally be guaranteed, in the evaluation of queries, we must compute answers which are consistent with the integrity constraints. Example 1 shows a case of inconsistency. Example 1: Consider the following database schema consisting of the single binary relation Teaches (Course, Professor) where the attribute Course is a key for the relation. Assume there are two different instances for the relations Teaches as reported in Figure 1.","PeriodicalId":405229,"journal":{"name":"Database Integrity","volume":"60 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"1900-01-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"130790446","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}

引用次数: 9