Pages

Subscribe:

Wednesday, 28 December 2011

SALARY OF CAREER THAT RELATED TO DATABASE


IT salaries can vary significantly based on the IT specialty you pursue. The following give averages from www.indeed.com about the salaries for IT specialties. The range may be fairly broad, but keep in mind a large factor in the salary for a particular IT field is dependent on the geographic location the job is located in, and the size of the company.
  • Computer Forensics Examiner / Computer Forensics Investigator: $47,000-89,000*
  • Database Administrator: $49,000-93,000*
  • Information Security Analyst / Computer Security Analyst: $48,000-90,000*
  • Graphics Designer / Graphic Designer: $35,000-66,000*
  • Technical Writer: $30,000-56,000*
  • Health Informaticist / Nursing Informaticist: $52,000-98,000*
  • Software Developer: $55,000-104,000*
  • Network Administrator: $46,000-87,000*
  • Web Developer: $53,000-100,000*
  • Web Designer: $42,000-79,000*
  • IT Project Manager: $52,000-97,000*
  • IT Manager: $44,000-82,000*
  • IT Director: $49,000-92,000*

ADVANTAGE AND DISADVANTAGE OF DATABASE


ADVANTAGES 
  • Reduced data redundancy
  • Reduced updating errors and increased consistency
  • Greater data integrity and independence from applications programs
  • Improved data access to users through use of host and query languages
  • Improved data security
  • Reduced data entry, storage, and retrieval costs
  • Facilitated development of new applications program


DISADVANTAGES
  • Complex, difficult, and time-consuming to design
  • Substantial hardware and software start-up costs
  • Damage to database affects virtually all applications programs
  • Extensive conversion costs in moving form a file-based system to a database system
  • Initial training required for all programmers and users

DATABASE ADMINISTRATORS

Many people don't realize the work as a database administrator. This is because database administrator is not a popular job that graduated student want to apply. They prefer a more famous job like software engineer. Many people ask what do database administrators do? why do they exist? did they have a high salary? All this question must have pop up in your mind sometime because in world nowdays people don't want to take risk to apply a job that they seldomly heard about. Now i will tell you a little bit about what do database administrators actually do.

Database administrators is people that use database management software to determine the most efficient ways to organize and access a company's data. They also responsible for maintaining database security and backing up the system.

Database administrators is a fast-growing industry.  Database administrators can expect to earn an annual salary of $48,000 to $85,000.

so student that takes computer science in database system should not worry about finding a job because now days there are a lot of company that want to hire an database administrators.

Skill that needed to be database administrators:
  • strong organizational skills
  • strong logical and analytical thinking
  • ability to concentrate and pay close attention to detail
  • ability to think broadly and consider impacts across system and within the organization.
A database administrator's activities can be listed as below:
  • Transferring Data
  • Replicating Data
  • Maintaining database and ensuring its availability to users
  • Maintaining the data dictionary
  • Controlling privileges and permissions to database users
  • Monitoring database performance
  • Database backup and recovery
  • Database security Stop

HARVARD BUSINESS SCHOOL CASE STUDIES



Brainstorming


SYMBIAN'S STRATEGY



MOBILE INDUSTRY VALUE CHAIN

  • Network operators - MNOs offered wireless voice and data services as early of 2008. MNOs built and operated wireless network  and developed relationship with subscribers. 2007, MNOs served 27 percent of worldwide subscribers. Voice services and SMS provided 90 percent of revenues for most MNOs. Data and internet services take off in UK, Germany and other western european countries in 2002. Network operators in developed markets had strong incentive to encourage  the growth of data and faced a steady decline in voice  revenue per subscriber, but data services could help counter revenue loses due to increasing industry competition.
  • Handset manufacturers - 2008, Nokia remained the world's largest manufacturer of mobile phone, followed by Samsung, Motorola, Sony Ericsson and LG. Handset sales were determined by the rate at which carriers added new subscribers and the rate at which existing subscribers replaced their handset. To retain market share in the developed world, handset manufactures focused their effort on smartphone. 2007, smartphone market had grown rapidly.
  • Mobile operating system (OS) providers - Mobile market share was divided into high-end and lower-end. Lower-end phones supported text messaging and perhaps a simple home page with a few text-based content option. High-end smartphone offered a wider range of services including e-mail, mobile transactions, personal information management and rich content of services. This growing set of functions and applications required increasingly sophisticated operating system software.
  • Content providers and aggregators - Mobile contents included news, entertainment and local information. Its also offered mobile access to materials already available on the web for example, mobile social networking let users access their facebook, myspace account, sometimes adding mobile-specific features.
  • Application developers - Developers offered smartphone application for example, online banking, playing games, purchasing books, sending and receiving e-mail, reading news headlines ang managing travel itineraries. Many mobile applications were simplified versions of services already accessible through Internet-connected PCs. These application were increasingly being designed to take advantage of smartphone's capabilities. Developers preffered to develop for platforms with as many users as possible. With the growth of the smartphone market and the availability of software platforms such as Symbian and Windows Mobile, third party application became increasingly important. OS makers invested significant resources in software development tools, education and reference material, and developer support forums.
  • Shifting balance of power - Apple's iPhone shifted power from network operators toward Apple, the platform provider. Content could be distributed through iTunes Stores, and Apple limited what kinds of content could be offered, for example disallowing sexually-explicit material. Google's approached also challenged the power of network operators. Its proposed an open source policy which would let users to any services they chose which mean its give the users maximum flexibility, but leaving less power for network operators.
SYMBIAN'S STRATEGY
  • Symbian licensees manufactured over 75 percent of the world's mobile phones, providing Symbian with a major distribution advantage.
  • Its ownership structure build relationship with handset manufacturer's product development teams. 
  • Symbian could shorten its product development cycle and better integrate its code with licensees handset by involving manufacturers in the OS revision process as early as possible.
  • Symbian also had strong relationship with its growing network of application developers and claimed that its programming interfaces were clearly documented and easy to master for those familiar with C++ programming language.
  • Symbian gave developers access to source code and Application Programming Interfaces through Binary Access Kit that helped developers take advantage of new features on the handset and the OS.
  • Symbian also provided extensive developer support in the form of education and reference material, development tools and support forums.
SYMBIAN'S COMPETITORS
  • Microsoft.
  • Palm
  • RIMM
  • Apple
  • Google and open sources

VIDEO INTERVIEW

interview with kak herda. The reason why she refused to pursue her degree in database system

interview abang safwan. The reason why he decided to change from mechanical engineering to database system.



Thursday, 22 December 2011

DATABASE PROJECT'S QUESTION

This is a problem-based learning Project.

Computing has tremendously developed to be one of the most critical and important disciplines worldwide and in Malaysia. Based on Multimedia Super Corridor (MSC) Malaysia Supply-Demand Study of ICT Industry by Frost & Sullivan, Computing has contributed on its Core ICT and ICT Enabled Services.
ICT Core includes Software Development, Networking & Security, OS & Server, Database Technologies, Business Intelligence, SAP, Hardware Design and Multimedia Tools.
Apart from Software Development and Networking & Security, Database skills have one of the highest demands recorded.
Databases are the cornerstone of the IT infrastructure and serve a critical business role by archiving data and making it accessible, rapidly and efficiently.
Databases house and deliver significant information, such as client files, inventory, financial records and other information that are vital to business operations. Computer-based databases are used in almost every industry.
Career in Database grows faster than average across all other industries.

However, there are several issues faced (not limited to these):
1. Databases are not widely known when compared to Software Engineering.
2. Day to day tasks are not understood by prospects.
3. Career path as Database Experts are not well promoted in Malaysia.
4. Negative perceptions on Computing careers.

The unfamiliarity is due to unknown career road-maps, day-to-day activities, key performance indicators, opportunities, success indicators, working hours, working environment, nature of activities, interest matching and many more factors.

Your group is required to do research on these problems. Propose a solution that can promote understanding of what Database Career Is, How to be a Database Expert, Where can we apply our skills as Database Experts, .... and lot more.

Fundamental question...Why Database career?

Just Imagine that you are looking for all the answer in your head on What Program to take? You will try to satisfy yourself by having your curiosity answered. So, you need to be really convinced on taking Database as your program of choice.

Project Delivery:
Fully online, using BLOGS. You should be creative, this includes, movies, stories, diagrams, etc. to be embedded your blog.

Final Presentation:
Week 15 (26-28 Dec)

Group Project:
Five (5) members only

Tuesday, 13 December 2011

ADOBE PHOTOSHOP

REMOVING UNWANTED ELEMENTS


LASSO TOOL


MAGIC WAND TOOL


CAMTASIA

TUTORIAL ON CAMTASIA 7


How to Upload Camtasia Studio Screen Recordings to Youtube



How to Edit a Video


 



JOB THAT RELATE TO DATABASE SYSTEM

  1. Network architects or network engineers
  2. Network and computer systems administrators design
  3. Systems administrators
  4. Database administrators
  5. Computer security specialists
  6. Telecommunications specialists
  7. Web developers
  8. Web administrators    

DATABASE!!!!

A special data processing system, or part of a data processing system, which aids in the storage, manipulation, reporting, management, and control of data.The DBMS determines how data are stored and retrieved. It must address problems such as security, accuracy, consistency among different records, response time, and memory requirements. These issues are most significant for database systems on computer networks. Ever-higher processing speeds are required for efficient database management. Relational DBMSs, in which data are organized into a series of tables ("relations") that are easily reorganized for accessing data in different ways, are the most widely used today.

DATABASE SYSTEM

A term that is typically used to encapsulate the constructs of a data model, database Management system (DBMS) and database.

  • Data Definition. Defining new data structures for a database, removing data structures from the database, modifying the structure of existing data.
  • Data Maintenance. Inserting new data into existing data structures, updating data in existing data structures, deleting data from existing data structures.
  • Data Retrieval. Querying existing data by end-users and extracting data for use by application programs.
  • Data Control. Creating and monitoring users of the database, restricting access to data in the database and monitoring the performance of databases.

Technical Heterogeneity

Different file formats, access protocols, query languages etc. Often called syntactic heterogeneity from the point of view of data.

Data Model Heterogeneity

Different ways of representing and storing the same data. Table decompositions may vary, column names (data labels) may be different (but have the same semantics), data encoding schemes may vary (i.e. should a measurement scale be explicitly included in a field or should it be implied elsewhere). Also referred as schematic heterogeneity.

Semantic Heterogeneity

Data across constituent databases may be related but different. Perhaps a database system must be able to integrate genomic and proteomic data. They are related - a gene may have several protein products - but the data is different (nucleotide sequences and amino acid sequences, or hydrophilic/phobic amino acid sequence and positive/negatively charge amino acids). There may be many ways of looking at semantically similar, but distinct datasets.
The system may also be required to present 'new' knowledge to the user. Relationships may be inferred between data according to rules specified in domain ontologies.

Thursday, 8 December 2011

CAREER

  • Database Administrators--Work with business areas to set up and maintain their databases. They are concerned with database objects like tables, indexes, tablespaces, stored procedures, etc.
  • Database Systems Administrators-- Responsible for supporting the database system itself. These individuals are concerned with the actual code that runs the database and how that integrates with the platforms on which it runs and the applications trying to access data from a database.
  • Database Designers--Help business areas design their databases. They determine which tables are needed and how those tables should relate to one another