Oriented DBMS for many users
Oracle, Borland-Interface, MS-SQL Server, CA-OpenIngres, Sybase, Informix, IBM DB2 are examples of which are more oriented DBMS for many users and therefore more indicated for use on a computer network system (LAN or WAN). Not as the first group, the DBMS in this group is very firmly separating the functions of database management and application development functions. If the first group, the objects generated by the DBMS second group is the opposite. Transparency only applies to the DBMS is concerned, so that the use of the database objects is only possible with the DBMS first turn. Support functions (ultilitas) are generally incorporated in the first group of DBMS, DBMS provided separately in this second group, not only because of the support functions is irrelevant to always turned on, but also because of the management functions are handled kkelompok DBMS is already so and much much more important. In the latest series of the second group of DBMS, such as d also the first group, the expansion of the definition of data structures and enrichment of new data types are also accommodated. Significant difference between the two groups contained in the scope of the DBMS database management functions. In addition to having standard functions (which is also owned by the first group DBMS) such as the establishment of database objects (tables and indexes), data manipulation (adding, changing, deleting data) and data search (query), the second group DBMS management functions It also deals with the following aspects:
1. Safety database objects against unauthorized user access (security aspects) and other forms of surgery are not allowed (aspect integrity)
2. Handling data recovery due to failure of the database operation (recovery aspects), whether caused by database operations are incorrect or conflicting, or caused by external factors such as fakor-jammed machine (crash), the disk is damaged or breaking connections tissue.
3. Of data backup (backup aspects) that can be performed incidental or periodic can be done statically (by disabling the use of the data base) or dynamically (without blocking the use of the database by the user)
4. Competition control use database objects by multiple users at the same time (concurrency control aspects) for ensuring data consistency and optimization of the use of any machine resources.
5. Optimization of query processing (query processing aspects) provided by DBMS applications on the server in order to improve performance / speed of the process.
Optimization of resource utilization (aspects of parallel processing / database) with respect to an optimal usage of resources such as processor machine, disk and main memory if there is more than one in a machine.
Many database programs are already in use, for example: Ms Access, My SQL, Oracle, SQL Server, Postgre, Fire Bird, paradoxically, Interbase. And another example is Sybase, DB2, Informix, FoxPro, Clipper, and others.
Here fiktur and standardization are used in some instances DBMS:
Ms. Access
Microsoft Access (or Microsoft Office Access) is a computer program relational database application that is intended for home and small to medium-sized enterprises. This application is a member of several Microsoft Office applications. This application uses the Microsoft Jet database engine Database Engine, and also uses an intuitive graphical interface making it easier for the user. The latest version is Microsoft Office Access 2007 is included in the Microsoft Office System 2007.
• Version Ms Access
Date Name version version number is supported operating system version of Microsoft Office
1992
Microsoft Access 1 Microsoft Windows 1.1
T / A
1993
Microsoft Access 2.0 2 Microsoft Windows
Microsoft Office Professional 4.3
1995
Microsoft Access for Windows 95 7 Microsoft Windows 95 and Windows NT 3.51
Microsoft Office 95 Professional
1997
Microsoft Access 97 8 Microsoft Windows 95/98 and Windows NT 4.0 3.51/NT
Microsoft Office 97 Professional
1999
Microsoft Access 2000 9 Microsoft Windows 98/Me, Windows NT 4.0/2000
Microsoft Office 2000 Premium and Office 2000 Professional
2001
Microsoft Access 2002 10 Microsoft Windows 98/Me, Windows NT/2000/XP
Microsoft Office XP Professional
2003
Microsoft Access 2003 11 Microsoft Windows 2000 (Service Pack 3 or above) / XP (Service Pack 1 and above) / Server 2003
Microsoft Office System 2003
2007
Microsoft Office Access 2007 12 Microsoft Windows XP (Service Pack 2) / 2003/Vista/Server Server 2008 (Beta 2 and above)
Microsoft Office System 2007
• Use of
Microsoft Access is used mostly by small businesses and medium-sized, in a small organization may also be used by even a fairly large company, and also the programmer to make a homemade system to handle the creation and manipulation of data. Access can also be used as a database for basic Web applications are stored on the server that is running Microsoft Internet Information Services (IIS) and use Microsoft Active Server Pages (ASP). Nevertheless, the use of Access is less recommended, given the existing Microsoft SQL Server that has a higher ability.
Some professional application developers use Microsoft Access to develop applications quickly (used as a Rapid Application Development / RAD tool), especially for the manufacture of prototypes for a larger program and stand-alone applications for the salesman.
Microsoft Access not so good if accessed via the network so that the applications are used by many users tend to use a database management system solutions that are client / server. Despite this, the front view Access (forms, reports, queries, and Visual Basic code) has to be used to handle the actual data base is processed by other database management systems, such as Microsoft Jet Database Engine (which by default is used by Microsoft Access ), Microsoft SQL Server, Oracle Database, and several other products that support ODBC.
• Features of Ms acccess
One of the benefits of Microsoft Access programmer is viewed from the perspective of their compatibility with the programming language Structured Query Language (SQL); queries can be viewed and edited as SQL statements, and SQL statements can be used directly in Macros and VBA Modules to directly manipulate tables data in Access. Users can mix and use both types of languages ??(VBA and Macros) for programming forms and logic and also to apply object-oriented concepts.
Microsoft SQL Server Desktop Engine (MSDE) 2000, which is a mini version of Microsoft SQL Server 2000, included in Office XP Developer Edition and can be used by Microsoft Access as an alternative to Microsoft Jet Database Engine.
Unlike a relational database management system is complete, Microsoft JET Database Engine does not have the feature triggers and stored procedures. Starting from Microsoft Access 2000 using the Microsoft Jet Database Engine version 4.0, there is a syntax that allows making queries with multiple parameters, in a way are like as a stored procedure, although prosesur is restricted to a statement of each procedure. Access also allow forms to contain code that can be executed when there is a change to the database tables, as well as a trigger, as long as the modification is done simply by using the form, and is something which is common to use a query that is passed (pass-through and techniques other in the Access to run stored procedure in the RDBMS that supports it.
In the Access Database file Project (ADP) are supported by Microsoft Access 2000 and later, the features associated with a different version of the database format / structure of the data used Access (*. MDB), because this type of file can make a connection to a database MSDE or Microsoft SQL Server, rather than using Microsoft JET Database Engine. Thus, by using ADP, it is possible to create objects in the hampur all servers running the database engine (database tables with constraints and triggers, views, stored procedures and UDF). Even so, the file is stored in the ADP only forms, reports, macros, and modules, while for tables and other objects stored in the server database back to the program.
• Development with Access
Access allows relatively fast development because all the database tables, queries, forms, and reports are stored in the database file hers (*. MDB). To create a query, using the Access Query Design Grid, a graphical program that allows users to create queries without having to know SQL programming language. DI in the Query Design Grid, the user can show the source of the database table query, and choose which fields to be returned by the process by clicking and dragging it into the grid. Join also can be created by clicking and dragging fields in tables to fields in other tables. Access also allows users to view and manipulate the SQL code if necessary.
Programming language available in Access is a Microsoft Visual Basic for Applications (VBA), as well as in some Microsoft Office applications. Two component library Component Object Model (COM) to access the database is also provided, the Data Access Object (DAO), which is only present in Access 97, and ActiveX Data Objects (ADO) are available in the latest versions of Access.
My SQL
MySQL is a software SQL database management system (English: database management system) or DBMS is multithreaded, multi-user, with about 6 million installations worldwide. MySQL AB makes MySQL available as free software under the GNU General Public License (GPL), but they are also sold under a commercial license for cases where the intended use is incompatible with the GPL.
Not the same with projects like Apache, which software is developed by the general community, and the copyright to the source code are owned by their respective authors, MySQL is owned and sponsored by a Swedish commercial company MySQL AB, which holds the copyright to all code almost the source. Both the Swedish and the Finnish people who founded MySQL AB is: David Axmark, Allan Larsson and Michael "Monty" Widenius.
MySQL is a Relational Database Management System (RDBMS) that is distributed for free under the GPL (General Public License). Where everyone is free to use MySQL, but should not be used as derivatives that are closed source or commercial. MySQL is actually a derivative of one of the main concepts in the database for a long time, which is SQL (Structured Query Language). SQL is a database operation concept, especially for election or selection and data entry, which allows the operation of the data is easily done automatically. Reliability of a database system (DBMS) can be determined from the workings of his optimizer in the process of SQL commands, which is created by the user or application programs. As the database server, MySQL can be said to be superior to the other database server in the data query. This proved to queries made by a single user, MySQL query speed can be ten times faster than PostgreSQL and five times faster than Interbase. Besides MySQL also has several features, among others:
1. Portability
MySQL can run stable on a variety of operating systems such as Windows, Linux, FreeBSD, Mac Os X Server, Solaris, Amiga, and many more.
2. Open Source
MySQL is distributed as open source (free), licensed under the GPL so it can be used free of charge.
3. Multiuser
MySQL can be used by multiple users at the same time without experiencing any problems or conflicts.
4. Performance tuning
MySQL has an amazing speed in dealing with simple queries, in other words more SQL can process per unit time.
5. Column types
MySQL has a very complex field types, such as signed / unsigned integer, float, double, char, text, date, timestamp, and others.
6. Command and functions
MySQL has a full service and functionality that support the command Select and Where in the query.
7. Security
MySQL has several layers of security such as the level subnetmask, host names, and permits the user access to the detailed licensing system and encrypted passwords.
8. Scalability and limits
MySQL database capable of handling large scale, with the number more than 50 million records and 60 thousand tables and 5 billion rows. Also limit the index that can fit up to 32 indexes on each table.
9. Connectivity
MySQL can not connect to the client using TCP / IP, Unix sockets (UNIX), or Named Pipes (NT).
10. Localisation
MySQL can detect an error on the client by using more than twenty languages. Nonetheless, Indonesian not included therein.
11. Interface
MySQL has an interface (interface) to a variety of applications and programming languages ??by using the API (Application Programming Interface).
12. Clients and tools
MySQL comes with a variety of tools that can be used for database administration, and on every tool that is included instructions online.
13. Table structure
MySQL has a table structure that is more flexible in dealing with ALTER TABLE, compared to other databases like PostgreSQL or Oracle.
Programming Language
There are several APIs available that allow computer applications written in different programming languages ??to be able to access the MySQL database include: programming languages ??C, C + +, C # programming language Eiffel programming language Smalltalk, Java programming language, programming language Lisp, Perl , PHP, Python programming language, Ruby, REALbasic and Tcl. An ODBC interface called MyODBC which allows any programming language that supports ODBC to communicate with MySQL database. Most of the MySQL source code in ANSI C.
Use
MySQL is very popular in web applications such as MediaWiki (the software used Wikipedia and similar projects) and PHP-Nuke and acts as the database component of the LAMP. As the popularity of web applications due to its proximity to the popularity of PHP, which is often referred to as the Dynamic Duo.
Administration
To administer the MySQL database, can use the module that includes the command-line (command: mysql and mysqladmin). Can also be downloaded from the MySQL website a graphical module (GUI): MySQL Administrator and MySQL Query Browser. In addition there is also a free software for MySQL database administration is a very popular web-based is phpMyAdmin. For software for MySQL database administration that are sold commercially are: front MySQL, Navicat and EMS SQL Manager for MySQL.
Oracle
Oracle database is a relational database that consists of a collection of data in a database management system RDBMS. Oracle's enterprise software market the type of data base for a variety of applications that can run on many types and brands of computer hardware (platform). Oracle database was first developed by Larry Ellison, Bob Miner and Ed Oates through his consulting company called Software Development Laboratories (SDL) in 1977. In 1983, the company changed its name to Oracle Corporation until now.
Types of hardware (platform) which is used as a server (host):
Apple Mac OS X Server: PowerPC
HP HP-UX: PA-RISC, Itanium
HP Tru64 UNIX Alpha
HP OpenVMS Alpha, Itanium
IBM AIX5L: POWER
IBM z / OS: zSeries
Linux: x86, x86-64, PowerPC, zSeries, Itanium
Microsoft Windows: x86, x86-64, Itanium
Sun Solaris: SPARC, x86, x86-64
Competitors
IBM: DB2, Informix, UDB
Microsoft SQL Server
Teradata (data warehousing and business intelligence)
Software AG: Adabas
Sybase.
Oracle and IBM emphasis on intermediate platforms such as UNIX and Linux, while Microsoft tends to reach the market for low-grade (Microsoft Windows platforms). Oracle databases are also competing with the open-source database (an open-source relational databases), such as PostgreSQL, Firebird, and MySQL. Software-based EnterpriseDB PostgreSQL, has recently announced a feature that is compatible with Oracle at very reasonable and cheap.
SQL Server
Microsoft SQL Server is a relational database management system (RDBMS) products Microsoft. Primary query language is Transact-SQL is an implementation of the SQL standard ANSI / ISO are used by Microsoft and Sybase. SQL Server is generally used in the business world which have a data base of small-to-medium scale, but then developed with the use of SQL Server in a large database.
Microsoft SQL Server and Sybase / ASE can communicate over a network using a protocol TDS (Tabular Data Stream). Aside from that, Microsoft SQL Server also supports ODBC (Open Database Connectivity), and has a JDBC driver for the Java programming language. Another feature of SQL Server is its ability to create a database mirroring and clustering. In the previous version, MS SQL Server 2000 affected by the SQL Slammer computer worm which caused delays in access to the Internet on January 25, 2003.
Version and edition
As a development of previous versions and editions (SQL Server 7.0 and SQL Server 2000), Microsoft has introduced products:
SQL Server 2005
Enterprise edition feature comparison (x86, x64, and IA64) ?
Developer Edition (x86, x64, and IA64) ?
Standard Edition (x86, x64, and IA64) ?
Workgroup Edition (x86 only) ?
Express Edition (x86 which can be downloaded free of charge for the purposes of learning and recognition) ?
? Mobile Edition
? Compact Edition
SQL Server 2008
SQL Server 2008 which will be marketed in 2008. Product support:
SQL Server Integration Services ?
? SQL Server Analysis Services
? SQL Server Reporting Services
? SQL Server Notification Services
? SQL Server Management Studio
• Postgre SQL
Postgre SQL is a database system that is freely distributed under the BSD license agreement. This software is one of the database's most widely used today, in addition to MySQL and Oracle. PostgreSQL provides useful features for database replication. The features provided include PostgreSQL DB Mirror, PGPool, Slony, PGCluster.
Comments
Post a Comment