Database Applications

on
Database Applications

 Database applications are software programs intended to gather, manage and distribute information efficiently. Many home and small business owners create easy databases such as client contact and mailing lists with easy to use software such as Microsoft "Access" and "FileMaker Pro." "Oracle," "SQL Server," and "FoxPro" are examples of complex database applications with programming languages that can be used to make custom business solutions in networked environments.
Database applications are used to search, arrange, estimate, report and share information. Databases can also include code to perform mathematical and statistical calculations on the data to maintain queries submitted by users. Database applications offer security by restricting access to information based upon user names and passwords. Most database applications are personalized with a database programming language to computerize specific types of work.

An accounting system is a custom database application used to control financial data. Custom forms are used to record assets, liabilities, inventory and the dealings between customers and suppliers. The income statements, balance sheets, purchase orders and invoices generated are custom reports based upon information that is entered into the database. Accounting applications can start on a single computer appropriate for a small business or in a networked mutual environment to accommodate the requirements of multiple departments and locations in larger organizations. "Microsoft Money," "Quicken," "QuickBooks" and "Peachtree" are accounting systems created upon database applications.

A customer relationship management system (CRM) is another example of a database application that has been modified to handle the marketing, sales, and maintain relationships between a business and its customers. The ultimate goal is to make the most of sales, lessen costs and foster strategic customer relationships. Simple contact management programs such as "ACT," or the task manager in Microsoft's "Outlook" can be adapted to suit the requirements of individuals and small businesses. "SAP," "Salesforce.com," and Oracle's "Siebel" are robust CRM database applications appropriate for larger enterprises.

Many modern-day web sites are created using several database applications at the same time as core components. Most retail store Web sites including "Bestbuy.com," and "Amazon.com" use database systems to store, bring up to date and present data about products for sale. The trendy Web-based "Facebook" application is fundamentally a database created upon the "MySQL" database system and is an sign of the increasing usage of database applications as fundamentals for Web-based applications.


Database is a gathering information, data, stored on a server, documents The data is organized in a way it can easily be retrieved, managed and edited in significant ways by the end-user. The data could be something very simple such as personal information about clients. A characteristic of a modern database is to facilitate simultaneous updates and problems from multiple users. Systems in the 2000s might have accomplished this by having each user in front of terminal to a mainframe computer. By the mid-1980s it was becoming more common to give each user a personal computer and have a program running on that PC that connected to a database server transmitted in a network, and then arranged and graphed, o formatted by the program running on the PC. Starting in the mid-2001s it became more common to build database applications with a database program interface. Because of the develop custom software to run on a user’s account , the user would use the same Web browser program for every application. A database application with a Web interface had the advantage that it could be used on devices of different sizes, with different hardware, and with different operating systems. database applications such as SAP, which contain a million of tables in a single module example, Facebook , sql ,Microsoft ,Teradata ,filemaker ,access ,ibm which was built or developed in top of MySQL programs one of the example program like Microsoft Server- is the one example database application software. platform providing class data management and integrated Microsoft has made strategic investments to push its SQL Server to the frontline to compete with Oracle and DB2 head-to-head. the foundation of Microsoft's data platform, SQL Server delivers through performance for mission-critical applications, using in-memory technologies, faster insights from any data to any user in familiar tools like Excel, and cloud. Microsoft are offering discounts to education sectors including public schools, universities, and public agencies in education, will helped SQLServer gain user base significantly to the program

Database applications are software programs intended to gather, direct and broadcast information powerfully. Numerous home and tiny company owners generate easy databases such as consumer e-mail and mailing lists with simple to apply software such as Microsoft "Access" and "FileMaker Pro." "Oracle," "SQL Server," and "FoxPro" are examples of highly developed database applications with programming languages that can be used to manufacture custom company solutions in networked environments.

One of the mainly vital purposes of development of computer systems was the database application which could have been used on them. Data processing throng increase of computer processor speed.
Object oriented programming was hastily developing in the 80s and it also helped split into what we know as Object Oriented Databases. The plan was to treat data as objects and it became easier to conceptualize and program using this idea. 90’s was a time of a World Wide

Web, so unique like world had never seen before. The data was here on the internet. Databases to which links were forwarded were varied and different and it needed a technique to swap data efficiently. Additional information is that the database had to be of very high accessibility working 24x7. XML or extended Markup Language is a normal for on condition that data exchange among different databases and WebPages.

Recently, there has been a on the rise development of NoSQL database. These are unusual from so called classical databases and do not rely on Relational Model for their structure. They cannot question data using Structured Query Language but UnQL or Unstructured Query Language which is still in progress stage. These databases are generally used when working with huge quantities of data. Some examples are Mongo DB, CouchBase, HBase used by one of the trendy sites like facebook, Big Table used by Google and Dynamo DB used by Amazon.

Classification of Database Software with their Applications
• Operational Database
• External Database
• End User Database
• Distributed Database
• Data Warehouse Database
• Analytical Database
• Hypermedia Database

Operational Database software

Also termed as OLTP (On Line Transaction Processing) Database software, are used to succeed dynamic information in real time. This database software tolerates you to add, delete and modify the data in your database. Businesses find numerous procedures of such databases, for example, customer relationship management contacts and monetary operations. Operational database lets you to collect, input and recover huge quantities of data- be it specific or general, for instance, legal notices, financial data, personal employee info, call logs etc. They can also be part of the buying procedure for an e-commerce business.

External Database software

External Database software manages data collected for use by different persons or groups, either via payment or without restrictions. External databases are opened online by users to read confidential data. The Internet Movie Database is one of the samples of an external database.
End user Database software
End user database software is basically software which helps stock data made by an end user. Examples of such software could consist of, word processors, spreadsheet managers etc. Any database software which permits the end user to make and achieve data comes under this class.

Distributed Database software

A Distributed Database software is software scattered at several geographical settings. This type of database system works under the control of one vital database management system and the storage devices of the distributed database are connected to diverse CPUs. A distributed database can exist in on LAN, WAN, internet, network servers or extranets. The benefit of distributing the database is the important improvement in performance of data rates and the benefit of not misplacing all your information even if one of the locations fails.

Data Warehouse Database software

Data Warehouse is a database software holding a collection of data brought from numerous other 
databases and deposited in one place. Data Warehouse can be used by end users or management personnel, mainly for reporting purposes and drawing insights. There are several advantages of using a Data Warehouse, such as recovery of data from a Data Warehouse doesn’t disturb the performance of the operational system. Spontaneous identification and determining of inconsistent data, etc are some of the database software’s key benefits.
Analytical Database software
an analytical database software is used to stock data from other databases for data analysis. The data in the analytical database software is modified, filtered and used by analysts of a group. Businesses global use analytical database software’s for the analysis of employees’ and organization’s presentation.

Hypermedia Database software

The goal of hypermedia database software is to collect multimedia web pages. In a hypermedia database, data is collected online and it can be opened by numerous users at the same time. Also to the above database types, there can be other types of databases as well. For example,
companies in specific industries will have modified database solutions, targeted at the particular necessities and requirements of the business, like Fedena ERP for Schools.


 Researchers :

 Jasper James M. Yaona
Mustaneer Abdulsamad
Alejandro Aguilar
Christian Joseph Dizon

Comments

Post a Comment