Preview

Database Management Systems

Good Essays
Open Document
Open Document
406 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Database Management Systems
Research Assignment
While the database management system terminology has become widespread in India, there is a vast space for the adoption of the systems. The market potential still has a significant amount of spread to increase market share. A computer database is a repository of structured data or information and a database management system is a collection of programs that allows storage and retrieval of this data efficiently.
Database management systems have undergone significant changes over the last thirty years. Starting with IBM’s IMS, a hierarchical database management system, in the early 1970s to the recent grid computing relational database management system – Oracle, the database technology has undergone a substantial technological change. During the last decade, relational management system or a derivative of it has become a de facto standard of the industry. ANSI SQL has become the standard query language to interact with any DBMS, though each vendor has its own extension to the standard SQL. (The Indian Express Limited)
According to Gartner, in 2008, the Indian DBMS market was worth around $194 million and is expected to grow by 20% in 2010 over 2009. It expects the Indian DBMS market size to reach $233 million in 2010. According to a Forrester Research report, the open-source database market stands at $850 million and is expected to grow by more than 40%, to $1.2 billion, by 2011. Though small in comparison with the $16 billion commercial database market, it is still a significant feat considering most open-source databases bear no licensing costs. (Gartner)
The size, growth, and sheer desire to gain a competitive edge lured global DBMS vendors to India. They have opened offices, signed local partners, and translated their software – and they are finding success. Driven by the inherent need for businesses of all kinds to manage their information, Indian database management system (DBMS) software vendors support customers in a large variety of



Cited: Gartner. Gartner Newsroom. 23 Nov 2010. 30 Nov 2010 <http://www.gartner.com/it/page.jsp?id=1475414>. The Indian Express Limited. Computer Express. 2009. 30 November 2010 <http://www.expresscomputeronline.com/20090309/2009anniversary08.shtml>.

You May Also Find These Documents Helpful

  • Good Essays

    Cis 515week 3

    • 1024 Words
    • 4 Pages

    Bibliography: (2012). Database systems: Design, implementation, and management. (10 ed.). United States of America: Joe Sabatino.…

    • 1024 Words
    • 4 Pages
    Good Essays
  • Best Essays

    Rob, P., & Coronel, C. (2002). Database systems: design, implementation, and management (5th ed.). Boston, MA: Course Technology.…

    • 1383 Words
    • 5 Pages
    Best Essays
  • Powerful Essays

    References: Rob, Peter and Coronel, Carlos. (2005). Database Systems: Design, Implementation, and Management. United States: Thomson Course Technology.…

    • 2376 Words
    • 10 Pages
    Powerful Essays
  • Good Essays

    * In an inventory order system, you don't want an order to be deleted if there are inventory order items, or those items will be orphaned.…

    • 579 Words
    • 3 Pages
    Good Essays
  • Good Essays

    1.) There have been several versions of SQL created in the last 26 years. In 1986, SQL-86 (SQL-87) was first published. In 1989, SQL-89 was a minor revision made to the original SQL. In 1992, SQL-92 (SQL2) was a major revision to its previous version. In 1999, SQL-99 (SQL3) added regular expression matching, recursive queries, triggers, non scalar types and some object oriented features. In 2003, SQL-2003 introduced XML related features, standardized sequences, and columns with auto generated values. In 2006, SQL-2006 defined ways in which SQL can be used in conjunction with XML and it defined ways of importing and storing XML data in an SQL database, manipulating it within the database and publishing both XML and conventional SQL-data in XML form. It also enables applications to integrate into their SQL code the use of XQuery. In 2008, SQL-2008 Legalized ORDER BY outside cursor definitions, added INSTEAD OF triggers, and added the TRUNCATE statement. As of March 2012, the newest SQL was released its new features include AlwaysOn SQL Server Failover Cluster Instances and Availability Groups which provides a set of options to improve database availability, Contained Databases which simplify the moving of databases between instances, new and modified Dynamic Management Views and Functions, programmability enhancements including new Spatial features, Metadata discovery, Sequence objects and the THROW statement, performance enhancements such as ColumnStore Indexes as well as improvements to OnLine and Partition level operations and security enhancements including Provisioning During Setup, new permissions, improved role management and default schema assignment for groups…

    • 701 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Athabasca Assignment

    • 837 Words
    • 4 Pages

    Relational databases are not new technology. Commercially, they gained importance in the early 1980s with the introduction of Oracle’s relational database, and since then they have been an essential tool for most businesses. Databases are critical tools that help to support various business functions in an organization. These information systems help a business to build and maintain competitive advantage. Databases not only support the operational levels of business—they are also used to support the activities of managers.…

    • 837 Words
    • 4 Pages
    Good Essays
  • Good Essays

    References: Pratt, P.J, & Adamski J.J, (2011). Concepts of Database Management. Ohio, OH: CENGAGE Learning.…

    • 688 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Database Environment

    • 1121 Words
    • 5 Pages

    A database defines a structure for storing information and it collects information that is organized in such a way that a computer program can quickly select desired pieces of data. A database can also be thought of as an electronic filing system. Data and information are extracted from a database by creating a query and then submitting it to the query database management system (DBMS) and it is posed in a language that only the DBMS can understand. The query can be in the form of a question or just a keyword and once these queries run against the database, it will find a matching record (Reynolds, 2004) .…

    • 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

    One of the most important elements of a computer based information system is the database. A database is a collection of records or information that is stored in a computer in a structured manner so that information can be stored, managed, and retrieved. Databases are very useful for manipulating large amounts of data and producing reports and documents. This paper takes a look at the Oracle database system and its usage within my organization.…

    • 592 Words
    • 3 Pages
    Good Essays
  • Good Essays

    References: Barrodale Computing Services Ltd. (2011). Applications of Object Relational Database Management Systems at BCS. Retrieved from Barrodale Computing Services Ltd. (BCS): http://www.barrodale.com/docs/ORDBMS%20Applications%20at%20BCS.pdf…

    • 672 Words
    • 3 Pages
    Good Essays
  • Good Essays

    The project for the implementation of our new system for billing and customer management is approaching completion. At the moment, the application has passed the user acceptance testing stage and the hardware is already in place. During the development of the system, the team realized that the existing database platform was inadequate to the new system; hence, they suggested using more modern database environment which will cost the company additional licensing costs.…

    • 681 Words
    • 3 Pages
    Good Essays
  • Better Essays

    Standardizing data, once done predominately by large corporations, is now filtering down to medium- size and small companies. The meshing of the old and new database causes administrators to maintain two or three database products on a single network. (Wong 1995) Relational database management systems incorporate complex features and components to help with logic procedures. This requires organizations to expand the traditional approach to database management and administration.…

    • 1186 Words
    • 5 Pages
    Better Essays
  • Satisfactory Essays

    I am writing a brief essay on the history of SQL and database developers that have to offer “Express” versions of their database. SQL that is also known as Structured Query Language, is the standard language used to communicate with a relational database. The model was originally developed by IBM using Dr. E.F. Codd’s paper as a model of data for large shared data bank. In 1979, not long after IBM’s prototype, the first SQL product, Oracle, was released by Relational Software, Incorporated.…

    • 374 Words
    • 2 Pages
    Satisfactory Essays
  • Best Essays

    Data Warehousing and Olap

    • 2507 Words
    • 11 Pages

    In the 1990s, as businesses grew more complex, corporation spread globally, and competition became fiercer, business executives became desperate for information to stay competitive and improve the bottom line. Data warehousing technologies have been successfully deployed in many industries: manufacturing (for order shipment and customer support), retail (for user profiling and inventory management), financial services (for claims analysis, risk analysis, credit card analysis, and fraud detection), transportation (for fleet management), telecommunications (for call analysis and fraud detection), utilities (for power usage analysis), and healthcare (for outcomes analysis). This paper presents a roadmap of data warehousing technologies, focusing on the special requirements that data warehouses place on database management systems (DBMSs).…

    • 2507 Words
    • 11 Pages
    Best Essays