Discussing Database Management Systems E Business Information Technology Essay

Discussing Database Management Systems E Business Information Technology showSoftw be systems or computing machine softw atomic number 18 which is hired to create, modify, maintain, provide deemled access to implementr randomnessbase. According to Mullins, 2002 It modifys block users 7 application programmes to sh be info, it enables entropy to be shared among multiple applications rather than propagated stored in un apply files for every new applications.For e.g. Online banking systems uses database management systems, Big hospitals uses database management systems to keep the track record of their patients details, their history etc.Database management systems based on the variety of models of distribution architectures much(prenominal) as the widely used Client/Server architecture and centralized architecture among others as also the database models such(prenominal) as Relational Model and the XML Model etc.First database management system systems were used for pri mary for large complex ventures such as Apollo moon landing projects. Such operations were too expensive to contemplate anyway, as in that era most data was stored on magnetic tapeline1970s Relational DBMSDuring this decade DBMS became a commercial reality. The hierarchical network database systems were develop they are gener entirelyy regarded as first genesis DBMS. They are still widely used. But have limitation, like difficulty in accessing to data, very limited data independence, not widely accepted.1980sE.F.Codd others developed the relative data model during the 1970. This was second generation DBMS. With relational model on the whole data were represented in form of tables. This has widespread commercial sufferance diffused doneout the business innovation in 1980s. SQL is the fourth generation lineinology which is used for data retrieval.1990s Object oriented database.This decade was the new era of computing, first with client/server, data wareho victimisation cyberspace application which became increasingly important.Largely structured, multimedia data became increasingly common during the 1990s. twain relational object oriented database are still of great importance.2000 Beyond.The ability to manage increasingly complex data. Multidimensional data considerably importance in data warehouse application.Development of universal servers based on object relational DBMS. Especially important to internet application.Fully distributed database became a reality, centralization of database will continue. The cut cost of high performance computing also encourages centralization.Content-addressable stock will become more popular. User can retrieve data by specifying the data they desire. For e.g. a user can query any detail in Google site can have the computer search for the closest match to that photo. operative on developing data mining algorithms that scale to handle very large data sets which help to analyze data efficiently. Improving ab ilities to discern patterns, trends, coefficient of correlation about customers, employees, products suppliers will influence strategic decision making by organisation.The proliferation of the PDAS will conduct to improved synchronization of small databases improvement of wireless transmission.The use of web service will become more widespread as reliable XML web services more available.http//en.wikipedia.org/wiki/Database_management_systemOverviewFunction of Database management systems.There are several functions that a DBMS performs to ensure data integrity and consistency of data in the database.Data dictionary managementData Dictionary is where the DBMS stores definitions of the data elements and their relationships (metadata). The DBMS uses this function to look up the required data component structures and relationshipsData storage managementThis particular function is used for the storage of data and any related data entry forms or screen definitions, report definitions, data validation rules, procedural code, and structures that can handle video and drawing formatsSecurity managementThis is one of the most important functions in the DBMS. Security management sets rules that determine specific users that are allowed to access the databaseMultiuser access control,Multiuser access control is a very useful tool in a DBMS, it enables multiple users to access the database simultaneously without affecting the integrity of the database. documentation and recovery managementBackup and recovery is brought to mind whenever there is potential outside threats to a database. Backup management refers to the data safety and integrity for example backing up all your mp3 files on a disk.Data integrity management,The DBMS enforces these rules to reduce things such as data redundancy, which is when data is stored in more than one place unnecessarily, and increase data consistency, making sure database is returning correct/same answer each time for same question aske d.Database access languages application programming interfacesA query language is a nonprocedural language. An example of this is SQL (structured query language). SQL is the most common query language supported by the legal age of DBMS vendors. The use of this language makes it easy for user to specify what they want done without the headache of explaining how to specifically do itDatabase communication interfacesThis refers to how a DBMS can accept different end user requests through different network environments. An example of this Can be easily related to the internet. A DBMS can provide access to the database using the Internet through Web Browsers (Mozilla Firefox, Internet Explorer, and Netscape).http//databasemanagement.wikia.com/wiki/DBMS_FunctionsTypes of Database Management SystemsDatabase management has become important part of every company that has got data to be managed handled. There are two types of database.Server database.Desktop database.Advantages of Database management systemsControls Data redundancyConsistencyImproved data integrityEasy to access data and maintain itProvides second-stringer recover servicesIncrease in productivity concurrencyDisadvantages of database management systemsMaintain data are ComplexMaintaining the database systems are very costly, for e.g. the server database is mainly attached with multiuser application have greater reliability data consistency. It is costlier than desk top database operates on high performance servers.There is high risk of failure.CHAPTER-2E-BusinessAccording to IBM (www.ibm.com/e-business) e-business (ebizNis) the transformation of light upon business processes through the use of Internet technologies. The key business processes referred to in the IBM definitions are the organizational processes. They include research and development, marketing, manufacturing and inbound and outbound logistics.Louis Gerstner, the former chief executive officer of IBM, in his book, Who Says Ele phants Cant Dance? Attributes the term e-Business to IBMs marketing and Internet teams in 1996.Stiller A (2003) related that Sussis (2000) an e-commerce consultant, stated that as businesses move into significant e-businesses, good cookery strategies, design and implementation becomes more and more essential.E-business (electronic business), derived from such terms as e-mail and e-commerce, is the conduct of business on the Internet, not only tainting and marketing but also servicing customers and collaborating with business partners. To twenty-four hours, major corporations are rethinking their businesses in terms of the Internet and its new culture and capabilities. Companies are using the Web to buy parts and supplies from other companies, to collaborate on sales promotions, and to do joint research. E-business can be conducted using the Web, the Internet, intranets, extranets, or some combination of these.E-Business will intrusion business process, technology and organizatio nal structureE-Business opportunities exist in Sales Marketing Product Development Supply Chain Management Procurement jut out Processes People EnablementFor example Amazon (www.amazon.com) and eBay (www.ebay.com) are the worlds two biggest e-businesses.Types of e-business or e-commerceB2B (business to business) business communication theory with other businesses like the direct placement of purchase orders.B2C (business to consumer) business communications with consumers through sales completed from a business website (e-commerce) or a regular newsletter.B2G (business to government) business communications with government like online taxation lodgements.P2P technology enables internet users to share files computer resources.Music file sharing services such as Gnutella are the prime examples of this type of e-commerce.M-commerce involves the use of wireless digital devices to enable the transaction on the web.http//www.smallbiz.nsw.gov.au/run/it/pages/ebiz.aspxBenefits/Adv antages of E-BusinessBusiness whether small or big are using the internet in their own ways. To work with partners and suppliers, for procurement, for internal activities such as knowledge sharing and new product development, and much more. Companies such as United Technologies, J. Sainsbury, General Electric and many others are reporting benefits from the use of the Internet. These benefits includeimproved speed of responsecost savingsimproved communications, information and knowledge sharingreductions in inventoryimproved efficiency and productivityharmonisation and standardisation of proceduresbetter transfer of best practicesacquisition of new customers and increased salesimproved customer serviceRemoves Location and Availability RestrictionsReduces cartridge clip and Money Spenthttp//www.ecommerceeducation.com/benefits-of-ecommerce.asphttp//www.smallbiz.nsw.gov.au/run/it/pages/benefits.aspxBarriers to E-businessSecurity encryptionTrust riskLack of qualified personalLack of b usiness modelsCultureLegal Issues boloney risk of lossInternet/web is too slow not dependable.Constantly change in technology, which is always costly.Source by Veljko Milutinovi, Frdric Patricelli (2002) E-business and e-challenges IOS PRESS page 10CHAPTER-3ROLE OF database management system IN e-BUSINESSEvery big or small organization is now trying their hands on DBMs to remain competitive in their respective fields. Every organisation which is big or at its starting stage wants to have their own DBMs as they dont want themselves to be left behind. To function in an e-business environment, an organization has to have a good command of knowledge on its markets, customers, products and services, methods and processes, competitors, employee skills and its regulatory environment.The term E-business is used in two main ways within organizations.The first is as a concept which can be applied to strategy and operations.second E-business is used as an adjective to describe businesses tha t mainly operate online, i.e. they have no physical presence on the high-streets and seek to minimize customer-service and support through enabling web self-service.Educational institution, public government organisation, private enterprises which require large databases to store informations are using DBMs in their business.Every day some or the other organisation is building database application or re-constructing the older version, for making these application there are two ways Microsoft products such as .net platform or Visual BASIC with an Open Database Connectivity (ODBC) driver connected to SQL Server the other is JSP/Java Server with a JDBC driver in DBMSs such as Oracle or IBM DB2 on the Unix, Linux and Windows platforms.Sabre airline reservation system was introduced in 1964 which was the first large scale DMBs for airline industry. Both airline travelling agents depends on sabre other reservation systems like Apollo. These database contain information about flight s eats of most commercial airlines, permitting co-ordination of reservation. today days every airline company has their own database where they do lot of work. Database helps their customers to book their itineraries fares. It has became lot easy for the customers to sit in the comfort of home respect the services. These databases help the airline industry to grow doubling their profits.DBMS is important to the operations of e-Business because it provides the organisation with the tools to make relevant and concrete decisions concerning the business. With a touch of button, hundreds of data stored in its database about a transaction, product or customer can be extracted, viewed, or amended The DBMSenables the e-Business to reduce waste in that majority of the traditional approach of doing business in the file-based era has been reduced.For e.g. in customer service industry the DBMs helps them to maintain the records information about the customers. For instance all banks have on line telephone banking services provided for their customers as they keep track every record every minute details of the customers.Database management systems are widely used by the information technology in computer manufacturing business, the DBMs help them in understanding their customers need like in some website of a computer manufacturing companies we can virtually customize or make changes in laptops we can purchase make payments online get our laptops within couple of days.ConclusionIn todays world e-business is extremely important for many reasons. Some of which is due to the fact it can speed the whole process of ordering etc. up. This then means that the lead time can be decreased because the ordering of products can be done much more quickly, particularly because the Internet is a fast running game wide area network. The Internet has completely reshaped customer relationships. The transformation began with the dot-com boom, which spawned a new type of company whose entire business model was predicated on Web acceptance and usage. These companies Yahoo (Nasdaq YHOO), Amazon (Nasdaq AMZN), eBay (Nasdaq EBAY) and Google (Nasdaq GOOG) took advantage of the Web in all aspects of their business. Soon, traditional brick-and-mortar enterprises realized that to survive, they too had to satisfy customer expectations to procure goods and services over the Internet.e-business has been benefited by DBMs a lot. But a lot work has to be done in developing more database application which are more user friendly, analytical practical. Lot of work has to be done in security issues of this e-business organisation as they have lot of personal information regarding their customers, to eliminate the fraud which is easily done by the hackers as they have access to these databases or can break the access codes use the valuable information.Up gradation of the databases websites should be always done so that these e-businesses would attract lot of customers.E-busine ss is the future of all the organisation, as the world is get closer so does the business, to continue in the competition companies must adapt to new technologies.