6) Impak Indexing Good : Kesan peningkatan prestasi MySQL Peningkatan penggunaan memori Peningkatan integriti data
Bad : Prestasi lemah Pembaziran 'disk space' untuk duplikasi,indexing yang tidak efektif dan indexing yang tidak digunakan Penggunaan memori yang tidak efektif
7) Meminimumkan proses dalaman MySQL Rekabentuk 'table' dan indexing yang betul serta tepat Penggunaan 'temporary table' Penggunaan 'filesort'
8) Transaksi Menitikberatkan rekabentuk yang melibatkan transaksi
Kini terdapat banyak kelemahan dalam merekabentuk aplikasi pangkalan data. Salah satu sebab ialah kerana kurang kemahiran mengendalikan pangkalan dengan baik, kurang memahami fungsi sesuatu pangkalan data, pendedahan yang terhad, kurang kreativiti dalam merangka pangkalan data dan sebagainya.
Bagi menjurus kepada penyediaan pangkalan terbaik untuk sesuatu aplikasi,berikut adalah 10 tips-tips yang perlu diambil kira dalam merekabentuk sesuatu pangkalan data MySQL.Kali ini hanya 5 tips yang akan dibincangkan.
The Knowledge Commodities Information System (Phase 2), K-Commodities 2, is a web based knowledge system for collecting, analysing, and sharing data and information for the Malaysian Ministry of Plantation Industries and Commodities. This allows the Ministry to automatically consolidate about 200 datasets from the internet into a centralised database that is accessible securely through the internet. These datasets include daily prices; daily news; monthly production, exports and imports; quarterly economic statistics; annual domestic and international data; and various electronic documents.
These datasets are then sorted, categorised, cummulated, and consolidated using automated processes overnight, so that it can be analysed using articles, tables, maps, charts, and spreadsheets the next day. The analysed information is then published in specific industry dashboards, where the information can then be sent automatically on a daily, weekly or monthly basis via email to key stakeholders, management, and analysts.
The Ministry of Plantation Industries and Commodities fosters the orderly development of the plantation and commodity sector through the development of higher value-added through downstream processing and promote the marketing of commodities, particularly semi-processed and processed. It's functions are also to oversee the development of the plantation and commodity sector covering research and development (R&D), production, processing, and marketing in respect of palm oil, rubber, wood and wood-based products, cocoa, pepper and tobacco.
The system is developed based on the open source IDA 2.1 (intelligence data analytics) application framework using LInux, Apache, MySQL, PHP and Javascript; and the open source Palo Business Intelligence Suite 3.1. K-Commodities 2 can be viewed at http://k-commodities.kppk.gov.my
Submitted by rajaiskandar @k... on Wed, 09/15/2010 - 23:25
This case use illustrates how a table of monthly data can be further enriched by using the spreadsheet and mapping feature of our Intelligence Data Analytics (IDA) 2.1 application framework. IDA 2.1 was implemented for the Malaysian Ministry of Plantation Industries and Commodities and includes the automated extraction of data from the websites of its agencies.
Data Source : http://econ.mpob.gov.my/stat/web_report1.php?val=201035
End Result : http://k-commodities.kppk.gov.my/dashboard/dataset/733
(access requires a free registration : http://k-commodities.kppk.gov.my/user/register )
Submitted by rajaiskandar @k... on Thu, 11/26/2009 - 14:29
I have recorded a video guide for creating an ETL job (Extract-Transform-Load) for extracting data from a Palo MOLAP (multi-dimensional online analytical processing) cube into a MySQL relational database table. This video was recorded using GTKRecordMyDesktop for the Chromium web browser on Ubuntu Netbook Remix accessing the Palo ETL, Palo MOLAP and MySQL Database on a 64bit Red Hat Enteprise Linux 5.4 on a dual processor Intel Xeon with 4GB of memory.
Submitted by rajaiskandar @k... on Wed, 11/04/2009 - 23:19
KRIMnet is currently participating in the 24 hour WebDev Contest at the time of writing this post. The contest is held as a precursor to the Malaysian Government Open Source Software Conference (MyGOSSCon) 2009 at the Putrajaya International Convention Centre. The KRIMnet team consist of Taufiq, Fazli, Nurhakimah, Shahida and Fadhil. There are another 7 teams competing, including SUK Terengganu which are represented by Pn. Hashimah, Pn. Hayati, Aidil, Shafiq, and a trainee. Click here for a video clip taken about 4 hours from the start of the competition.
We develop web based software applications based on the PHP application and MySQL database open source technologies. These are among the top three most popular technologies for building database driven web applications. By using this technologies, employees, customers and suppliers can access the application at any location which has an internet connection.
We have three basic product platforms (web portals, web intelligence and web enterprise), so that a project does not have to start from scratch. Using modular and object-oriented programming, we are able to quickly add customised module according to the specific requirements.
Joomla is an award-winning web content management system (CMS), which enables you to build Web sites and powerful online applications. Many aspects, including its ease-of-use and extensibility, have made Joomla the most popular Web site software available. Best of all, Joomla is an open source solution that is freely available to everyone.
We can help you to transform your website into a Top Performer according to what you want to achieve. Whether it is to enhance your organisational image, attract more potential customers, or provide online services to support your business process. Or all of them ? Contact us for enquiries.
The Demographic Intelligence Data Analytics (d-IDA) is an internal project to develop a web based application for conducting population surveys and census. It is to be developed on the open source PHP and MySQL technologies. The objective of the web application is to allow organisations to design a web based questionnaire, gather information from individuals and households and other organisations, and be able to generate graphical and statistical analysis. Please read on about the d-IDA features and target price.A pre-alpha test site is available at http://dida.krimnet.com
An application of the Drupal open source content management framework for collecting data and analysing textual information from the internet. Includes a taxonomy of multilingual ontologies, automated content tagging, time-series marking, flash chart queries. A tool for people who need to analyse unstructured textual content. The web based application is developed using open source Linux, Apache, MySQL and PHP technologies. Subscribed users can access the i-IDA Knowledge Base. Announcement : Alpha demo will be made available in October 2008.
Copyright © 2008-2011 KRIM Network Sdn Bhd | Malaysia Terengganu
MSC
Socio Economic
Web
Application
PHP and
Javascript
Software
Developer