SEARCH KEYWORD -- ORACLE DATABASE


  How does MySQL handle DROP TABLE

A few days ago, when executing DROP TABLE in MySQL, all processes including DDL and DML were hung until DROP TABLE was completed. I am confused about this phenomenon. I have reviewed the source codes of MySQL to check how MySQL internally handle DROP TABLE. When user trigger DROP TABLE command: ########################MySQL SERVER drop table######################## /* Sql_table.cc  delete (drop) tables. */bool mysql_rm_table( )   /*   Execute the drop of a normal or temporary...

   MySQL,DROP TABLE     2012-09-24 11:34:05

  PHP Apache MySQL Set-up Note

With the emergence of WAMP, LAMP, PHP developers are liberated from the tedious work of setting up PHP environment. Since PHP, Apache and MySQL are so tightly bundled, WAMP and LAMP provide a setp solution for setting up a PHP environment which includes the programming programming environment, server and database. But for a PHP who wants to learn more, you have to try to set the PHP environment yourself by installing PHP, Apache and MySQL manually and configuring them. Below is a simple note on ...

   PHP,Apache,MySQL     2014-04-07 01:56:43

  â€œExperience says it all”- Pentaho ETL Developers’ Comment on the Use of ETL Tools

Since months Pentaho ETL developers have been juggling with three distinct tools- Pentaho DI, SSIS, and PowerShell. Their experience has provided them new perspective on the cons and pros of every tool. In this post, they are sharing their experience with these tools and explain their significance. Before getting started, they first would like to explain ETL in brief and how the tools suits ETL landscape. ETL is Extract Transform Load. Informatica was the initial ETL tool introduced in the mid n...

   Pentaho BI ETL tools     2015-05-13 01:14:57

  Which Type of IT Career is Best For You?

Considering the growth of the information technology job market, a career in IT is an incredibly smart career move.  A career in IT can mean many things – you can become a network administration, website developer, database specialist, programmer or engineer. The job range is vast and can suit various personalities and levels of technical skill. Having a good insight into those job profiles is key to make the right decision about your career path. Here's a selection of some of the mos...

   career,IT,tips     2014-07-30 09:21:40

  Simple PHP paging class

Frequently in our web applications, we may have many records in the database to display. In order to imrpove loading speed and efficiency, we may need to display some records at a time, so we need to paginate the records. For example, if we have 1 million book records and when users want to view the book list, it's inefficient to display all the records on the same page, we may need to have some pagination to allow displaying a portion of the records such as 20 records per page. This is a simple...

   PHP,Paging,Class     2012-09-10 20:23:33

  Which web front-end framework to choose?

When doing web design, we often need to choose which front-end framework to use in order to provide great user experience and simplify the development. Also, compatibility problem can be solved by using front-end frameworks. Here is a list of front-end frameworks. Which one are you using? Which one do you prefer?1. Apache FlexApache Flex, is a software development kit for the development and deployment of cross-platform rich Internet applications based on the Adobe Flash platform. Initially deve...

   Web design,Front-end,Framework     2012-07-30 13:57:26

  Some famous product release venues

About product release conference, you must remember Apple Worldwide Developers Conference(WWDC), right? But do you remember where the conference is held? Actually, when companies release new products, they will hold some kind of conferences or sessions to introduce their products. But does anyone know what are the places where these conferences are held? Here geekpark summarized some product release places for us. 1. Moscone West Convention Center Moscone West Convention Center is the biggest co...

   Conference, Place,Product release     2012-10-11 20:32:22

  JShell -- The command line tool to run Java code in Java 9

Java 9 is currently a work-in-progress and is planned to be GAed in March 2017. Quite a few new features will be introduced in the new release. The coolest feature is project Jigsaw which is to modularize the Java packages so that a customized JDK can be built and shipped with only the necessary modules to fulfill their project requirement. Apart from this feature, another big new feature is project Kulla -- JShell. In simple, JShell is a command line tool which can be used to run...

   JAVA 9,JSHELL,KULLA     2016-04-01 21:46:48

  Something you should know about programming even if you are not a programmer

Out daily life are deeply affected by software and web. More and more people are realizing the importance of software, For example, you want to travel to Brazil for the world cup, right? You should first book the ticket online, when you book the ticket, you should pay for the ticket with your credit card, after successfully booking your ticket, you will get a e-ticket in your mailbox. When you arrive at the airport, your identity information will checked against the immigration database system, ...

   Programming,Programmer     2014-06-11 10:06:40

  The concept of Iterative Model in a Software Development Life Cycle (SDLC)

The iterative model implemented in any Software Development Life Cycle is all about an initial, simplified implementation which may or may not gain more complexity in future. Furthermore, it is can even be called as a broader feature set until and unless the final system is accomplished. Now while discussing the model, chances are there that he concept of incremental development will also often be used liberally and interchangeably. This means incremental alterations made during the design and i...

   SOFTWARE DEVELOPMENT,SDLC,ITERATIVE MODEL,SOFTWARE DEVELOPMENT LIFE CYCLE     2017-09-11 06:02:39

RECENT