Issue 1 • 1000119 J Inform Tech Softw Eng ISSN: 2165-7866 JITSE, an open access journal Mancas and Dicu (original) (raw)
Related papers
Architecture, Design, Development, and Usage of ODBDetective 1.0
Journal of Information Technology & Software Engineering, 2013
"ODBDetective is an Oracle database (Oracle) metadata mining tool for detecting violations of some crucial database (db) design, implementation, usage, and optimization best practice rules (bpr). This paper presents the set of bprs that is considered by the first full version (1.0) of ODBDetective, the db axioms from which they are derived, the corresponding tool's facilities, and the essentials of its actual architecture, design, development, and usage, including the results of a case study on an Oracle production db. Moreover, even this first ODBDetective version also allows for storing semantic decision data on desired db scheme improvements, which will prove very useful to automatic improvement code generation in subsequent versions of this tool."
Business rules are often speci ed only implicitly by applications to express user-de ned constraints. OCL provides the chance to explicitly and automatically deal with business rules when building object-oriented applications. We investigate how OCL constraints can be handled in database applications as one of the most important k i n d of business applications. Based on our OCL toolset prototype and earlier research w ork we particularly experiment w i t h v arious strategies for the evaluation of OCL constraints in object-oriented applications which use relational databases. For this work, a exible SQL code generator is needed which can be used and adapted for di erent relational database systems and di erent object-to-table mappings. We implement such a database tool as an additional module for our OCL toolset using XML techniques.
OCL as a specification language for business rules in database applications
«UML» 2001The Unified Modeling …, 2001
Business rules are often speci ed only implicitly by applications to express user-de ned constraints. OCL provides the chance to explicitly and automatically deal with business rules when building object-oriented applications. We investigate how OCL constraints can be handled in database applications as one of the most important k i n d of business applications. Based on our OCL toolset prototype and earlier research w ork we particularly experiment w i t h v arious strategies for the evaluation of OCL constraints in object-oriented applications which use relational databases. For this work, a exible SQL code generator is needed which can be used and adapted for di erent relational database systems and di erent object-to-table mappings. We implement such a database tool as an additional module for our OCL toolset using XML techniques.
Mining violations to relax relational database constraints
2009
Frequent constraint violations on the data stored in a database may suggest that the represented reality is changing, and thus the database does not reflect it anymore. It is thus desirable to devise methods and tools to support (semi-) automatic schema changes, in order for the schema to mirror the new situation.
An extensible framework for detecting database security flaws
Knowing flaws existing in a database security system is very useful for database protection. Database security flaws come from various sources, not only from network, database management systems, but also from the way an administrator manages a database system. Even then, to the best of our knowledge, existing researches for detecting security flaws mostly focus on the network environment, but database security systems. In this paper, we propose a framework for detecting database security flaws. The proposed framework is extensible and can be adapted to explore security flaws in any database systems. Notably, with this framework we can easily define a new potential database security flaw and an effective method to probe and verify it. The prototype and experimental results with Oracle will confirm our approach's effectiveness and efficiency.
Rule Management in Object Oriented Databases: A Uniform Approach
1991
Rules have been proposed for providing active behaviour in DBMS. Previous attempts to add rules to Object Oriented DBs have often resulted in a dichotomy between rules and other kind of objects. Bere a uniform approach is presented, in which rules are described and handled in the same way as any other object in the system, without any additional mechanisms being introduced. Thus rules can be related to other objects or arranged in hierarchies, and rules can even be defined which are triggered by methods attached to rules themselves. Since rules and classes are both objects, a relationship between these two kinds of objects can be used to provide a class-based index for rules. In this way, the search for applicable rules is considerably reduced. An early implementation and several examples are shown in ADAM, an Object Oriented DB in PROLOG.
2021
Databases are by far the most valuable asset of companies. Since the need was seen not only to count but also to have some type of record of elements such as crops, animals, money, properties and that this record could be consulted and modified according to the situation, that is where the first database was born. , and after that, these databases cannot be disorganized, they also need to be managed and administered under established standards that facilitate their understanding and management not only by their creators but by the other people who subsequently administer them. Databases and database management systems have an interesting evolutionary history that deserves to be analyzed and this is the objective of this document, where it is sought to understand, Along with databases and their management systems, data mining or Data mining arises that in order not to extend ourselves so much, it is the job of finding common patterns in various data sources and in what way they can be used to predict situations or results of various circumstances; We also focus on the other topic that we will present, Oracle data mining, which roughly is to merge data mining with Oracle, which makes it a powerful tool for obtaining information and predicting results based on statistics. In this article we will study and analyze the ideas, concepts and basic examples that make up SGBD and Data Mining and, we will try to go deeper into this topic, the use of decision techniques such as advanced statistical algorithms. We also present a fictitious example of the application of these techniques: predicting which products can be sold based on their relationship with others. we will give a brief explanation of association rules, data mining cycle and the types of learning and the evolution that data mining has had