Discussing Database Management Systems E Business Information Technology Essay

Discussing Database Management Systems E Business Information Technology EssaySoftw atomic number 18 systems or calculating machine softw ar which is hired to create, modify, maintain, provide controlled approaching to manipulationr teachingbase. According to Mullins, 2002 It enables end users 7 practise programmes to tout ensembleocate entropy, it enables info to be shargond among multiple applications rather than propagated stored in new files for every new applications.For e.g. Online banking systems uses database vigilance systems, Big hospitals uses database concern systems to keep the track picture of their patients details, their history etc.Database management systems based on the variety of models of distribution architectures such as the widely used Client/Server architecture and centralized architecture among others as also the database models such as Relational Model and the XML Model etc. offshoot DBMS systems were used for primary for large complex v entures such as Apollo moon landing projects. much(prenominal) operations were too expensive to contemplate anyway, as in that era more(prenominal) or less data was stored on magnetic tape1970s Relational DBMSDuring this decade DBMS became a commercial reality. The hierarchical nedeucerk database systems were developed they are gener all(prenominal)y regarded as first generation DBMS. They are still widely used. But bring limitation, like difficulty in irritateing to data, very limited data independence, not widely unsayed.1980sE.F.Codd others developed the relational data model during the 1970. This was second generation DBMS. With relational model all data were represented in form of tables. This has widespread commercial acceptance diffused throughout the ancestry world in 1980s. SQL is the fourth generation language which is used for data retrieval.1990s Object orientated database.This decade was the new era of computing, first with client/server, data warehousing int ernet application which became progressively important.Largely structured, multimedia data became increasingly common during the 1990s. Both relational object oriented database are still of great splendour.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. specially important to internet application.Fully distributed database became a reality, centralization of database volition continue. The lower cost of in high spirits carrying out computing also encourages centralization.Content-addressable storage will become much popular. User can retrieve data by indicateing the data they desire. For e.g. a user can head any detail in Google berth can fork over the computer search for the closest match to that photo.Working on developing data mining algorithms that scale to handle very large data sets which help to analyze data e fficiently. modify abilities to discern patterns, trends, correlation around customers, employees, products suppliers will influence strategic decision making by organisation.The proliferation of the PDAS will lead to improved synchronization of small databases improvement of radio set transmission.The use of web services 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 bunks that a DBMS performs to en legitimate 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 pass to look up the required data comp cardinalnt structures and relationshipsData storage managementThis particular function is used for the storage of data and any related data entry forms or screen definitions, reput ation definitions, data validation rules, procedural code, and structures that can handle video and picture 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.Backup 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 maximizing data consistency, making sure database is returning correct/same answer each time for same question asked.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 majority of DBMS vendors. The use of this language makes it easy for user to specify what they want through 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 considerably related to the internet. A DBMS can provide access to the database using the net income through meshing Browsers (Mozilla Firefox, lucre 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 data base.Advantages of Database management systemsControls Data redundancyConsistency improve data integrityEasy to access data and maintain itProvides backup recover servicesadd-on in productivity concurrencyDisadvantages of database management systemsMaintain data are ComplexMaintaining the database systems are very costly, for e.g. the server database is mainly connected 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- occupancy) e- short letter (ebizNis) the transformation of key 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 CEO of IBM, in his nurse, Who Says Elephant s 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 planning strategies, design and implementation becomes more and more essential.E-business (electronic business), derived from such basis as e-mail and e-commerce, is the conduct of business on the Internet, not further buying and selling but also servicing customers and collaborating with business partners. Today, 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 join forces on sales promotions, and to do joint research. E-business can be conducted using the Web, the Internet, intranets, extranets, or nearly faction of these.E-Business will impact business process, engineering and organizational structureE-Business opportunities exist in Sales market Product Development Supply Chain Management Procurement Support Processes People EnablementFor example amazon (www.amazon.com) and eBay (www.ebay.com) are the worlds two outsizegest e-businesses.Types of e-business or e-commerceB2B (business to business) business communications with other businesses like the direct placement of grease ones palms orders.B2C (business to consumer) business communications with consumers through sales completed from a business website (e-commerce) or a incessant newsletter.B2G (business to government) business communications with government like online taxation lodgements.P2P technology enables internet users to share files computer resources. harmony file sacramental manduction 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.aspxBenefit s/Advantages 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 some(prenominal) 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 procedures conk out transfer of best practicesacquisition of new customers and increased salesimproved customer serviceRemoves locating and Availability RestrictionsReduces Time and Money Spenthttp//www.ecommerceeducation.com/benefits-of-ecommerce.asphttp//www.smallbiz.nsw.gov.au/run/it/pages/benefits.aspxBarriers to E-businessSecurity encryptionTrust risk miss of qualified perso nalLack of business modelsCultureLegal IssuesFraud 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 matched 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 utilize to strategy and operations.Secondly E-business is used as an adjective to describe busin esses that 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 elderly 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 arriere pensee system was introduced in 1964 which was the first large scale DMBs for airline exertion. Both airline travelling agents depends on sabre other reservation systems like Apollo. These database contain informatio n about flight seats of most commercial airlines, permitting co-ordination of reservation. Now 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 enjoy 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 ba nks have online 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 leverage 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 wherefore 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 wide area network. The Internet has completely reshaped customer relationships. The transformation began with the dot-com boom, which spawned a new type of co mpany 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 easy 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 custome rs.E-business is the approaching of all the organisation, as the world is get closer so does the business, to stay in the competition companies essential adapt to new technologies.