Concept Planning Database

Database (the database) is a collection of data that are interconnected with others, are stored in the computer hardware and software used for manipulate it. The database is one important component in the system information, because it is the basis of providing information to users.Implementation of database in the information system is called the database system. Database system (database system) is an information system that integrates collection of data related to each others and make available for several applications in a variety organization.With This database system of each person or part can look at a database of some other view points. The credit department can look at it as a receivable data, the sale can be looked at as sales data, the personnel can view it as employee data, the part can be looked at as a data warehouse
inventories.

Everything is integrated into a common data. In contrast to the treatment system
traditional data, data sources are handled individually for each application.

Continued....

Reasons to Migrate from Microsoft Access to MySQL

The use of MySQL as a storage manager for Access offers several benefits. One is that you can use your information in additional ways when it's not locked into Access. Other differences pertain more specifically to the case where you intend to continue using Access as the user interface to your information.

Deployment of information. When your information resides in MySQL, you're free to continue using it from Access if you wish, but a number of other possibilities open up as well. Any kind of MySQL client can use the information, not just Access. This allows your data to be exploited more fully in more contexts, and by more people.For example, other people can use the data through the standard MySQL client programs or from GUI-based applications. Your database also becomes more accessible over the Web. Access now provides some capabilities for making a database available on the Web, but if MySQL manages the database, you have a wider range of options. MySQL integrates easily with Web servers like Apache through any of a number of languages, such as Perl, PHP, Python, Java, and Ruby. This allows you to provide a Web interface to your database with the language of your choice. In addition, the interface can be accessed by browsers on many types of machines, providing a platform independent entryway to your information. All of these components can be obtained for free—MySQL, Apache, and the languages just mentioned have been released as Open Source. You can also obtain them in packages that include support.

Multiple-user access. Although Access provides some data sharing capabilities,that's not really its strength. It has the feel of a single-user data manager designed for local use. MySQL, on the other hand, easily handles many simultaneous users. It was designed from the ground up to run in a networked environment and to be a multiple-user system that is capable of servicing large numbers of clients.

Management of large databases. MySQL can manage hundreds of megabytes of data, and
more. Care to try that with Access?

Security. When Access tables are stored locally, anyone can walk up to your Windows machine, launch Access, and gain access to your tables. It's possible to assign a database a password, but many people routinely neglect to do so. When your tables are stored in MySQL, the MySQL server manages security. Anyone attempting to access your data must know the proper user name and password for connecting to MySQL.

Backup management. If you work in an organization that supports many Access users, migrating data to MySQL provides a benefit for backups and data integrity. With Access databases centralized in MySQL, they're all backed up using the regular MySQL backup procedures that already exist at your site. If individual Access users each store their data locally, backup can be more complicated: 50 users means 50 database backups. While some sites address this problem through the use of network backups, others deal with it by making backups the responsibility of individual machine owners which unfortunately sometimes means no backups at all.

Local disk storage requirements. Local Access database files become smaller, because the contents of tables are not stored internally, they're stored as links to the MySQL server where the tables reside. This results in reduced local disk usage. And, should you wish to distribute a database, less information need be copied. (Of course, anyone you distribute the database to also must have access to the MySQL server.)

Cost. MySQL can be obtained for free. Access cannot. Providing other means of using your database (such as through a Web interface) can reduce your dependence on proprietary software and lower your software acquisition and licensing costs.

Hardware choices. MySQL runs on several platforms; Access is a single-platform application. If you want to use Access, your choice of hardware is determined for you.

Microsoft Access or MySQL?

Microsoft Access is a popular data management application that allows you to store information in tables that it manages directly from the local disk. You can also use Access as a front end, that is, as an interface to information that is located else where and handled by another storage management system. In this case, Access acts as a client that connects to a server that provides the data. The MySQL database system is one such storage manager; if you install the MyODBC driver, Access can make ODBC connections to MySQL servers over the network. You can still use the contents of your tables through Access, but the tables themselves are hosted by the MySQL server.

Access has its strengths, such as an easy to use interface. Access also has its limitations—it's generally used as a personal or single-user application, typically for managing limited amounts of data. (Access is not commonly used for databases hundreds of megabytes in size, for example.) Because of its storage management limitations, you may be considering how to retain the Access interface but migrate your information to a storage manager with greater capabilities. Or you may even be considering a move away from Access entirely. This article outlines some benefits that you stand to gain by using MySQL to manage your data, and provides some guidelines to help you migrate locally stored Access tables to MySQL. The final section of the article lists links to locations where you can find the tools discussed here.

How to create tables in FoxPro

1. Make sure your computer has installed FoxPro for Windows.
2. Click Start then All Programs then FoxPro for Windows then FoxPro for Windows.
3. Then will appear.
4. Click File then New.
5. In the File Type option, select Table / DBF and click New.
6. Then fill the table structure that dibutuhkan.lalu click OK.
7. Before storing the table structure that has been created. Note the location of the directory as a place to store the table structure.
8. After the selected directory. Save with the DBF extension. Then click Save.

WAMP SERVER installation

1. Open Windows Explorer and doble click the file wamp5_1.6.1.exe
2. Then Wamp5 setup will appear. Choose Next.
3. Then the dialog box appears. Select I accept the aggrement and click Next.
4. Then a dialogue box will appear, to determine the folder where it will be in store, then click Next.
5. Wait a few minutes, until the dialog box appears to specify the name of the shortcut in start menu that is used by default WampServer. Then select Next.
6. Appears option to automatically launch WAMP5 when the computer is turned on. √ Tick (check) to vote. Continue by clicking the Next button.
7. After that click Install.
8. The installation process begins.
9. Enter the name of the folder where you save the name of the website. Default folder name is www. Then click OK.
10. Select a browser to run this program, the default is the explorer. Then press Open.
11. Select Launch WAMP5 now for immediate start to run the existing service in WAMP, and then press the Finish button.
12. If run the bottom right corner (sys tray icon) you will find the symbol of WAMP5_1.6.1.
13. Try Right click on the icon will display a taskbar wamp5 menu.
14. Meanwhile, if the left click on WAMP server will appear taskbar menu that others.
15. Now we try to run the server using your favorite browser (or the existing browser - IE / Modzilla). The way typing localhost in the address bar.
16. Program ready to wear.

Know a web server

Web server is a server software that functions accept HTTP or HTTPS requests from clients who called with a web browser and sends the results back in the form of web pages are typically in the form of an HTML document. Web servers are known to include Apache and Microsoft Internet Information Services (IIS).
Apache (Apache HTTP Server or Web Server / Apache WWW) is a web server that can run on many operating systems (Unix, BSD, Linux, Microsoft Windows and Novell Netware and other platforms) that allows you to serve and enable the web site. A protocol used to serve the facility of web / www uses HTTP.

While IIS or Internet Information Server is an HTTP web server used in the Windows Server operating systems, ranging from Windows NT Server, Windows 2000 Server, Windows Server 2003 or Windows Server 2008. Integrate the service is a service in Windows 2000 Server, and Windows Server 2003, Windows Server, 2008 or as an add-on in Windows NT Server. This service serves as a support TCP / IP protocol that runs the application layer. IIS also be the foundation of the Internet and Intranet Microsoft platforms, including Microsoft Site Server, Microsoft Commercial Internet System Microsoft and other products BackOffice.