Preview

Database Differentiator

Powerful Essays
Open Document
Open Document
3473 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Database Differentiator
SHAH AND ANCHOR KUTCHHI ENGINEERING COLLEGE
Chembur, Mumbai.

A SYNOPSIS REPORT
ON
DATABASE DIFFERENTIATOR
BY
|SUSHANT PAWAR |BE-6-19 |
|MAYANK VIRA |BE-6-45 |
|DEVENDRA MONDKAR |BE-6-10 |
|MILAN PATEL |BE-6-17 |

A report submitted in partial fulfillment of the requirement of B.E COMPUTERS/IT PROJECT-A syllabus.

[pic]
UNIVERSITY OF MUMBAI
2009-10

ACKNOWLEDGEMENT

We thank the Director of our college Prof M.B.SHAH & our Principal Dr.R.V.KARAMBELKAR

We express our gratitude towards the Head of I.T Dept
Prof B.R.BAIRI for the motivation and suggestions, which enabled to complete the synopsis work on time and our internal project guide Prof MANOJ DHANDE who guided us regarding the technicalities of the project. We are very thankful to our parents and friends for their consistent support

With Regards, Sushant Pawar BE6-19 Mayank Vira BE6-45 Devendra Mondkar BE6-10 Milan Patel BE6-17

ABSTRACT

This final year project aims to present an application that is able to deal with the comparing and modification of the metadata of the database. The application “Database Differentiator” works on databases i.e. it will compare the metadata of two databases and will generate SQL patch files.

In this application the comparison is done on the metadata i.e. structure of the database and not on the data of the database. Comparison has been provided by, taking database as the input, comparing the



References: JDBC in action, Swing, 1349 Kogent ,2009 Edition • Herbert Schidilt, “Java 2- The Complete Reference” metadata methods, 457 ,

You May Also Find These Documents Helpful

  • Powerful Essays

    We present an overview of Margaret Mclean’s method to evaluate the risks and benefits associated with genetically modified food.…

    • 2651 Words
    • 11 Pages
    Powerful Essays
  • Powerful Essays

    Database Environment

    • 1121 Words
    • 5 Pages

    When building a system for information, you have to decide how much responsibility for data management your software will take. A database can be rather large or it can be small depending on the information that is being stored. Request for information from a database are made in the form of a query or a question asking the database for particular information. All database management systems are not the same from a technical standpoint. They differ mostly in the way they organize their information internally. The internal organization can then determine how quickly and supplely the information can be extracted (Jupitermedia, 2011) .…

    • 1121 Words
    • 5 Pages
    Powerful Essays
  • Better Essays

    In this paper I am going to discuss about the database and software used in my construction company. Oracle database is a multi platform database, meaning it can run efficiently on any operating system and this makes Oracle flexible and more secure when compared to its competitors. Our Oracle database is running on a Sun server, using the Sun Solaris enterprise operating system. Oracle databases are an enterprise database system, only medium and large companies would need an enterprise database. Oracle Corporation uses RDBMS rational database management systems to maintain all data within the organization. Various data items can be organized according to their relationships with each other, such as the relationship of Employee name and Employee ID, rational databases give Oracle a great deal of flexibility when describing the relationship between data elements. Oracle follows Dr.Cobbs 12 rules on how a true RDBMS should be evaluated. The following are Cobb's 12 rules.…

    • 807 Words
    • 4 Pages
    Better Essays
  • Good Essays

    “Establishing a relational database management system is a great way to increase data integrity, efficiency, ask questions, sort and filter data, provide stronger security, and share information in one concise design which is very user friendly if developed correctly. Relational databases allow the ability to cross-reference data stored by the business and as a result provide a higher level of integrity.” “The key to success is in the foundation of the database's design.” “Relationships of data must be accurately assessed and once this connection is established, the rest falls into place rather smoothly. (Goessl, 2009)”…

    • 672 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    References: 1. Relational and Object-Oriented Databases, by Willi-Hans Steeb , International School for Scientific Computing. 2. Database Management Systems: Relational, Object-Relational, and Object-Oriented Data Models, Lisbeth Bergholt, DTI ,Jacob Steen Due, Rambøll Thomas Hohn, DAIMI, Jørgen Lindskov Knudsen, DAIMI, Kirsten Hjerrild Nielsen WM-data, Thomas Sonne Olesen, DTI, Emil Hahn Pedersen, Rambøll. 3. Comparing Relational and Object-Oriented Databases, Nelson Caballero, University of Maryland University College, 2001.…

    • 2737 Words
    • 11 Pages
    Powerful Essays
  • Powerful Essays

    Replenish & Restore

    • 5013 Words
    • 21 Pages

    4. Ketabchi, M.A., Mathur, S., Risch, T. and Chen, J. (1990) Comparitive Analysis of RDBMS and OODBMS: A Case Study. user.it.uu.se [Online] Available at: http://user.it.uu.se/~torer/publ/COMPCON1990.pdf…

    • 5013 Words
    • 21 Pages
    Powerful Essays
  • Powerful Essays

    This paper contains a comparison of Oracle and MySQL databases in the context of selection of a DBMS. First of all I determined what features of DBMS are important from the point of view of a customer which searches for ideal DBMS. From a papers which I read about comparison, I think the following features are important:…

    • 1593 Words
    • 7 Pages
    Powerful Essays
  • Good Essays

    The relational database model is naturally scalable and extensible, providing a flexible structure to meet changing…

    • 875 Words
    • 4 Pages
    Good Essays
  • Better Essays

    Sql Research Paper

    • 1325 Words
    • 6 Pages

    Although many varieties of sophisticated software are available for database construction, they impose very little restriction on their implemented form. Indeed, it would fly in the face of database philosophy to impose the form of implementation, for this would not encourage features like responsiveness to new requests (Bailey, Creel, Grossman, Gutti, and Sivakumar, 55-57). Thus each operational database is unique, even if the software used in constructing it is an industry standard. A piece of advice one gets from software manuals is to develop two mental pictures of one’s unique database. The first picture is of the contents of the database and the way it is organized; and the second picture is of what can be done with the contents.…

    • 1325 Words
    • 6 Pages
    Better Essays
  • Satisfactory Essays

    In 1970 Dr. E.F. Codd published a paper “A Relational Model of Data for Large Shared Data Banks”. Codd’s model is now accepted as the definitive model for relational database management systems (RDBMS). The language, Structured English Query Language (SEQUEL) was developed by IBM Corporation Inc., to use Codd’s model. SEQUEL later was shortened to SQL. In 1979, Relational Software, Inc. (now Oracle) introduced the first commercially available implementation of SQL. Today, SQL is accepted as the standard language.1…

    • 396 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    “To Study the Consumption Pattern of Bottom of Pyramid Group in Noida and Recommend a Product based on the Analysis”…

    • 3363 Words
    • 14 Pages
    Powerful Essays
  • Powerful Essays

    indo iran ties

    • 3081 Words
    • 13 Pages

    India’s traditionally strong links with Iran, and its increasingly robust relationship with the US, have put the India-Iran relationship firmly in the spotlight. India is a major importer of Iranian oil – the second largest after China – and has been able to get a US waiver on sanctions against Iran, in exchange for a reduction in Iranian oil imports.…

    • 3081 Words
    • 13 Pages
    Powerful Essays
  • Good Essays

    At one point we got a situation to migrate all the data from existing database to other data base and use the latest DB going forward. Now we are in a position to change all the code which we used to establish connections and queries/procedures which we used to pull or insert the data, the changes were essential to interact with new database, which was a big change.…

    • 734 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Database System Concepts

    • 301237 Words
    • 1205 Pages

    Database management has evolved from a specialized computer application to a central component of a modern computing environment, and, as a result, knowledge about database systems has become an essential part of an education in computer science. In this text, we present the fundamental concepts of database management. These concepts include aspects of database design, database…

    • 301237 Words
    • 1205 Pages
    Good Essays
  • Good Essays

    Great Indian personalities

    • 20685 Words
    • 83 Pages

    A Few Great Personalities of INDIA All of us have seen many presentations floating around about eminent people like Aryabhatta, Chankya, Srinivasa Ramanujam etc. While we are very proud of the great deeds our ancestors have achieved, we believe we should also recognise the present day greats who have contributed in this century and/or contributing today. Below is a list of few such great personalities. This list is not comprehensive, many more can be added.…

    • 20685 Words
    • 83 Pages
    Good Essays