An organization follows certain process that aims to consistently meet the goals effectively through constant monitoring of employees’ performance and making sure that everyone performs in an outstanding manner. This is called performance management. It is an organizational work system that starts when an employee’s job title is defined along with its competencies and ends when an employee resigns from the company. It is a process of building a work environment wherein working individuals perform their best to contribute to the success of company goals. The term is sometimes associated…
Exforsys Career Tips News Letter Signup for the Exforsys Career Tips and get expert tips and training on various career related subjects. You can unsubscribe anytime. Please note you will need to confirm your subscription before you start getting email based tips and training. * Name: * Your Email Address: * Country: — Please Select Country —USACANADAINDIAUNITED KINGDOMOTHER * Enter the security code shown: Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any…
Since the time Oracle 11g has been released way back in the year 2003, it has waved a new exploring instinct among the database users. Till now, I observe the professionals engaged trying their hands out with Oracle 11g new features.
Reality of Data and Application Protection Business data and applications are crucial for the success of any commercial organisation. Information related to business needs to be protected from system and network disasters. Topics Reality of Data IT Continuity Planning Components for IT Continuity IT Infrastructure Continuity Design IT Related Threat to Business An ideal scenario for complete data protection is to have the network connected to a back-up facility that will monitor any changes in the data. Each time the data changes, the back-up facility will mirror the changes so…
UTL_FILE is an oracle supplied built in package, which can be used for text file operations located within a file system. The file system can exist either on the server side or on the client machine.
Exception can be defined as the state of an entity, which is different from its conventional and normal behavior. In context to programming language, exception refers to the abnormal situation in the normal flow of the program.
In continuation to my last tutorial on PL/SQL enhancements, I have compiled the list of enhancement pertaining to SQL. Similar to PL/SQL, Oracle had done considerable enhancements in SQL to raise performance level from instrumental to advisory. In the tutorial, we shall go through the performance oriented features, fresh additions and language enhancements. Performance improvements a. Alter table to add columns with default value In Oracle 11g, we can alter a table to add a column with a default value. Earlier, a developer used to update the value for the…
Result Caching is a new feature introduced in Oracle 11g. Since its induction in the 11g release, caching of result sets has emerged out as one of the most efficient performance tip in modern database applications.
In this tutorial you will learn how to use timeline that is appropriate to your project schedule in MS Project. Projects with a (more than a year) long duration usually have months as their time unit. This can be reduced to weeks if duration is for 12 months. If a project has a duration of one week, then days can be used as a time unit.
In any aspect of communication, listening is an integral part of the whole process. Basically, we listen to understand and comprehend the message that the speaker is saying. But this becomes a challenge to many of us since we tend not to make use of good and effective listening. According to statistics, we listen to only about 25-50% of what we hear in a particular conversation. And at the end of the day, we forget about 46% of everything we have heard. If you are a facilitator of a team…
Service Autonomy As Businesses continue to step up the process of constructing enterprise automation logic in the service format, there is also an increasing need to step up both the efficiency and reliability that the services are intended to take on at run time. This dire need is increased when it comes time to assemble a service inventory with a vast quantity of reusable services. Reusable Services and Concurrency Service Oriented Architecture entails reuse to the extent that many strategic goals that are associated with enterprise wide Service Oriented Architecture…
Service Oriented Infrastructure Service Oriented Infrastructure is a systematic means for describing Information Technology infrastructures in the terms of a service. The underlying principles of Service Oriented Infrastructure revert back to LDAP and Mainframe technologies, among others. Where Service Oriented Infrastructure manages to distinguish itself is the way in which it provides a mindset or framework for making Business benefits measurable. Service Oriented Infrastructure tends to provide the foundation for Information Technology services. Intel initially developed the concept that had three different domains for Service Orientation; they were the Enterprise,…
Service Reusability One of the most vital principles of Service Oriented Architecture is that of service reusability. And in today’s day and age, it can be said that we have been making a lot of progress towards improving both this central tenet and Service Oriented Architecture in general. One sign that a significant degree of progress in the field has been made is the fact that more and more questions regarding Service Oriented Architecture these days are aimed at the architecture itself, rather than infrastructure and implementation. One question that…
Standardized Service Contract Standardized service contracts are one of the key Service Oriented Architecture principles. They ensure that services that are in the same inventory of services are kept in compliance with contract design standards. The services in a Service Oriented Architecture are able to delineate their capabilities and overall purpose in the form of a service contract. The standardized service contract principle basically requires that specific considerations be taken in to account when a service’s public technical interface is being designed. It simultaneously assesses the nature and quantity of…
Service Discoverability Service discovery protocols can be thought of as network protocols that allow for the automatic detection of both services and devices that are offered by a computer network’s various devices. There are a lot of service discovery protocols available. In this article, we will take a look at the attributes of three of the more popular ones – Service Location Protocol, Simple Service Discovery Protocol, and UDDI for Web Services. Before we proceed, we should point out that a Service Discovery Protocol should not be confused with a…
Service Loose Coupling Loose coupling can be thought of as the resilient relationship that exists among two or more systems or companies that have some sort of relationship based on exchange. Each transactional end should make its requirements explicit somehow and make very few, if any, assumptions about the other end. While the notion of loose coupling originated in computer systems, Karl Weick later brought it in to organizational studies. Loose Coupling in Computing Loosely coupled computers systems are regarded as being useful in the event that either the destination…
Service Encapsulation What is Encapsulation? In the realm of computer networking, the term encapsulation is utilized to include data from an upper layer protocol in to a protocol on a lower layer. Such a method of abstraction through networking allows many different layers to add on functionality and features. The World Wide Web, for instance, is based on the Internet Protocol. The vast majority of applications utilize either the Transmission Control Protocol or the User Datagram Protocol. Thus, a lot of user data is then encapsulated in to the form…
Service Abstraction One aspect of service orientation that is connected directly to loose coupling and service contracts is abstraction. Through abstraction, we are able to control the parts of the underlying service logic that are to be exposed to the external world. Through ensuring that such parts have been designed in a generic fashion as a means of accommodating numerous potential service requestors, the service may be positioned as a reusable Information Technology asset. In this article, we will take a look at different levels of abstraction before moving on…
Service Composability The principle of Service Oriented Architecture known as Service Composability can be broken up into two basic principles: Service Discoverability and Service Composition. When it comes to the realm of Service Design, a lot of attention is paid to the enabling of those characteristics that are so commonly associated with Service Oriented Architecture marketing – reuse and loose coupling. While these two aspects are undoubtedly vital, indeed critical to the attainment of long term Service Oriented Architecture transition projects, there is a lot more that should be taken…
Service Orientation and Interoperability In this article, we will take a look at the Service Oriented Architecture principles of service orientation and interoperability. Let’s start with service orientation first. Service orientation can be thought of as a design paradigm that is used to specify the creation of automation logic in the form of services. Service orientation is applied as a strategic goal in the development of Service Oriented Architecture. Like a lot of other design paradigms, service orientation should successfully provide a means of attaining a separation of concerns. The…
SOA and Business Architecture Businesses are now having to think a lot more seriously about how to best assemble their systems out of common parts. Service Oriented Architecture has caused this change in the way such systems are thought of. It requires a lot more planning and investment at the outset, but it also enables Businesses to build faster systems in the long run as the inventory of reusable parts grows at a frantic pace. In such architectural programs, systems tend to be composed of reusable elements, which are referred…
SOA and Network Management Architecture In recent years, the field of Network Management has been absorbing the principles of Service Oriented Architecture. Examples of service oriented Network Management architectures include the TS 188 001 NGN Management OSS Architecture from ETSA, as well as the more recent M.3060 Principles for the Management of Next Generation Networks, which was a recommendation of the ITU-T Service Oriented Architecture. Some of the tools for the management of Service Oriented Architecture infrastructure include the HyPerformix IPS Performance Optimizer, the Total Software Intersperse, the HP Management…
Service Oriented Design and Development SOAD – Service Oriented Analysis and Design The term Service Oriented Analysis and Design was first used in the publication Elements of Service Oriented Analysis and Design. Service Oriented Analysis and Design is also covered in the publication Service Oriented Architecture Compass. Service Oriented Analysis and Design is a strategy that IBM created especially for Service Oriented Architecture. SOAD added innovations for service orchestration, the enterprise service bus, as well as service repositories. Moreover, it helps the construction, design, aggregation, and deployment of applications as web…
SOA and Web Services A lot of individuals tend to associate Service Oriented Architecture with World Wide Web based services. The two, however, are not one and the same, and thus must be distinguished from one another. We will first begin by elucidating the concept of Service Oriented Architecture before moving on to Web services. For the moment, we are going to focus on Service Oriented Architecture in order to understand how it is distinct from Web based services. Then we will show how the two are in fact connected.…
SOA Job Opportunities New Jobs in SOA SOA need data center architect who is dedicated to overseeing computing, management, facilities, networking, and security, who is on the look out, thinking always at least ten years in advance of current trends and considering how modern day Service Oriented Architecture will affect power requirements in the future. Moving to a more centralized data center that utilize service oriented architecture; virtualization, as well as other new technologies should get Businesses to start thinking more in terms of extended job definitions for its Information…
SOA for Developers Service Oriented Architecture is a structure that requires a number of specialized employees working in positions such as Object Librarian, Configuration Management, and Information Architect. Junior developers or individuals who prefer dealing with web development, focus exclusively on the presentation tier. Such individuals are very productive, as the vast majority of the business services and rules will be available to be assembled into the UI’s. Individuals who enjoy writing code can dwell in the business rules tier, where important services and components may be developed. More experienced…
SOA for Project Managers The idea of handling exceptions manually unveils major significance of individuals involved in Service Oriented Architecture based projects as well as various roles they take on. Service Oriented Architecture projects tends to involve a number of familiar project roles, including project management, Business analysis, architecture, development, security, and administration of systems and databases. At the same time, such roles were generally created for different purposes. A lot of these roles might have different meanings, depending on the views of the Business in question. In order to…
SOA Definitions and Certification Service Oriented Architecture is a design that enables Business and computational resources to be linked together on demand as a means of achieving the results desired for service consumers – which may be end users or other services. Service Oriented Architecture has been defined by the Organization for the Advancement of Structured Information Standards as a paradigmatic approach for the utilization and organization of distributed capabilities that might be under the control of conflicting ownership domains. Service Oriented Architecture provides a single means of offering, interacting,…
SOA Best Practices Service Oriented Architecture is regarded as the key to improve efficiency of Information Technology. But in order to implement Service Oriented Architecture at a Business, one needs to have a lot more than just technical expertise. It is essential to hone skills in management practices. In this article, we will focus on the governance principles that have become widely regarded as the best practices in relation to Service Oriented Architecture. Today’s competitive environment has seen Information Technology chains and Businesses merging at an increasing rate. Service Oriented…
SOA Industry Usage First time usage of SOA tends to highlight the need for semantic interoperability. While SOA provides framework for integration of cross Business operations with information flow in real time, there is also a major semantic interoperability conflict that is not being addressed directly by the SOA. Thus, the usage of information repositories has been the inevitable result. It must be said that the vast majority of implementers of SOA are still in the first, wrapping stage. It would be great if we were in a period when…
SOA Principles In this SOA article, we will focus on some of the core principles of Service Oriented Architecture viz service abstraction, service reusability, service composability, service autonomy, service optimization, service discoverability, service-orientation and interoperability, standardized service contract. Service Abstraction Abstraction is also known under its full name as service interface level abstraction. It is this principle that allows us to establish services as black boxes, hiding their underlying details from potential customers. Abstraction is achieved through a utilization of service contracts. Through limiting what is made public about a…
SOA Future SOA: The Past It is often asked as to why haven’t people been using SOA for the last twenty years? As far as SOA is concerned, in order to build a system out of parts, you require a standard method of representing software parts. If no such standard exists, then building such a system can become incredibly difficult. Though Service Oriented Architecture is not exactly a new thing, Businesses have spent the last fifteen years trying to come up with a set standard. While CORBA and DCOM…
SOA Concepts Today, the concept of Service Oriented Architecture has become ubiquitous. Evidence from recent years establish that SOA is not just about hype, but a part of every major Business environment. The truth is, Service Oriented Architecture can be beneficial to Business only when it is utilized properly. Service Oriented Architecture is no longer a theory – it has moved into the realm of actual initiatives that can ensure that Businesses and investors receive high returns on their investments. It is vital to possess a keen understanding of various…
SOA Architecture It is essential for the Businesses to think a lot more seriously about how best to assemble their systems out of common parts. It requires a lot more planning and investment at the outset, but it also enables Businesses to build faster systems in the long run as the inventory of reusable parts grows at a frantic pace. In such programs, systems tend to be composed of reusable elements, which are referred to as services. A service can be thought of as a software building block that performs…
SOA Standards In this article, you will learn about latest standards for Service Oriented Architecture, and in particular, how it relates to Oracle, in today’s competitive world. SOA of the Next Generation In this day and age, enterprise applications have already begun the transition from user interface driven applications to assemblies of interoperable services that are also reusable. Such services are representative of the easy business functions that are intended to be assembled together in to the form of new applications. One of the main advantages of such a change in application…
SOA Disadvantages Service Oriented Architecture Disadvantages & Applicability Service Oriented Architecture may not always be the best architectural choice because optimal utilization of SOA requires additional development and design attempts as well as infrastructure which translates into costs escalation. When it comes to applications, Web Services and Service Oriented Architecture is not recommend for the following: Stand alone, non distributed applications that do not necessitate application or component integration; that would include, for instance, a word processing application that does not require request and response based calls. . Short lived…
In this C++ tutorial, you will learn how to access Class members, dot operator or class member access operator, difference between struct and class and scope resolution operator. It is possible to access the class members after a class is defined and objects are created. General syntax to access class member: Object_name.function_name (arguments); The dot ('. ') used above is called the dot operator or class member access operator. The dot operator is used to connect the object and the member function. This concept is similar to that of accessing…
In object-oriented programming languages like C++, the data and functions (procedures to manipulate the data) are bundled together as a self-contained unit called an object. A class is an extended concept similar to that of structure in C programming language; this class describes the data properties alone. In C++ programming language, class describes both the properties (data) and behaviors (functions) of objects. Classes are not objects, but they are used to instantiate objects. Features of Class: Classes contain data known as members and member functions. As a unit, the collection…
SOA Advantages Businesses in today’s competitive environment are constantly faced with the challenge of having to provide more with fewer resources. Businesses are constantly under pressure to deliver goods and services to the market at a faster, cheaper rate – and at higher quality than in previous times. It is predicted that investments in Information Technology are going to drive businesses forward – not merely in terms of gaining responsiveness and efficiencies, but additionally in the creation of top line opportunities. It is an ironic fact that the vast majority…
SOA 2.0 Event Driven Architecture There has been much negative press in recent years in regards to Oracle’s touting of SOA 2.0 as the next generation version of SOA. Its combination of Event Driven Architecture with SOA considers the first iteration of SOA to be a mere client-server drive. Despite the fact that it has been presented as a new term, a lot of critics claim that what this merger actually is an advanced SOA, rather than a 2.0 version. The truth is that a lot of pure play middleware…
Service Oriented Architecture : Why SOA? The vast majority of businesses working in the field of Information Technology in this day and age find themselves having to justify their projects with a return on their investments. This puts Information Technology, as a field, under an enormous amount of pressure. IT must boast requirements that are increasingly responsive and flexible to the shifting needs of different businesses. Firms dealing with Information Technology must also be able to face the challenge of taking on an array of software systems that may or…
Service Oriented Architecture : SOA 2.0 Introduction Conceptualizing Service Oriented Architecture Let us take a look at some of the key features of Service Oriented Architecture (SOA). The best way to go about doing this is to break SOA down in to its core verbal elements. We’ll start with the last letter first: A. We will first examine architecture in reference to SOA. Usually, in the realm of software, architecture tends to define the overall intercommunication of different high-level components. To put it simply, this is how a solution is…
NLP Framing for Resourcefulness Introduction Neuro-linguistic Programming presents several frames of reference that are used to put things in different contexts and perspectives, by giving them different meanings. These frames can be applied to handle feedback or criticism effectively, or to cure certain phobias and traumas. The concept of framing is developing the ability to step out of an experience, take a second position so that you can understand the different perspectives, and learn to cope with them. You need to learn the length and degree of changing frames in…
Supply Chain Management : Inventory What is Inventory? Inventory refers to the list of goods and materials in stock by a particular company. The purpose of inventory is to manage and conceal the fact that oftentimes manufacture delay lasts longer than the delays in delivery. Inventory also eases the imperfections that result as part of the normal manufacturing of a product. These imperfections can lower production efficiencies in those instances where production is idle owing to a lack of needed materials. Business Inventory The following stock reasons might apply to…
Client Server Features Web Server Introduction Web servers are the machines or programs from which requests are made and fulfilled over the Internet. They provide one of the endpoints in communication when users request an online service. Clients or users request data through their web browsers. These requests are delivered to the server in HTTP (HyperText Transfer Protocol). The server then searches the World Wide Web for results based on browser specifications and returns its responses in HTML (Hypertext Markup Language), also formatted according to HTTP. This is the basic…
Using UML with PHP and Perl The Unified Modeling Language has a number of features that could be beneficial to both Perl and PHP users. If you have a meeting with managers, and you need to explain the procedure for online credit card payments, your audience could become bored. While explaining it to them is one thing, showing it to them is another. This is where UML can be very useful for developers who use Perl. Instead of simply telling someone how a system works, you can show it to them visually.…
VSAM Control Interval and Control Area In this Mainframe tutorial, you will learn about VSAM Control Interval, What is a Control Interval in VSAM? and Control Area, what is VSAM control area, attributes in the control area index component. What is a Control Interval in VSAM? Control Interval in VSAM is a unit of data that is transferred when an I/O request is made between auxiliary storage and virtual storage. It contains records, free space and control information. The data records are grouped into control intervals. That is in other…
VSAM Structure In this Mainframe tutorial, you will learn about VSAM Structure, four major areas of VSAM structure, what is VSAM cluster, VSAM components, Defining VSAM cluster and Example for defining VSAM clusters. There are four major areas in the structure of VSAM. They are: The Master catalog The User catalog The Data space The file also called as cluster What is VSAM Cluster? VSAM dataset which we have seen in detail in our earlier section when defined logically takes up the form as a VSAM cluster. Before proceeding to…
VSAM Introduction In this Mainframe tutorial, you will learn about VSAM, what is VSAM, VSAM structure, types of VSAM datasets, Entry Sequenced Data Set (ESDS), Key Sequenced Data Set (KSDS), Linear Data Set (LDS) and Relative Record Data Set (RRDS). What is VSAM? VSAM stands for Virtual Storage Access Method. The VSAM is a method used for managing files in mainframe system. That is in other words VSAM is a data management system used in mainframe systems and this was introduced by IBM. VSAM also known as Virtual Storage Access…
JavaScript Introduction In this JavaScript tutorial, you will learn about introduction to JavaScript, why JavaScript, differences between Java and JavaScript and advantages of JavaScript. What is JavaScript? JavaScript was first developed by Netscape as an open scripting language to create interactive web pages. Script is nothing but a small program which is generally very easy to learn and use. JavaScript as an open language implies that it can be used by anyone; no license is required to use JavaScript. Microsoft created Jscript for its Internet Explorer similar to Netscape JavaScript.…
Regular expressions In this PHP Tutorials you will learn about Regular Expressions viz Basic PCRE Syntax, Character classes, preg_match(), preg_match() and Extracting data with regular expressions. Basic PCRE Syntax: A regular expression pattern is a string consisting of plain text and pattern metacharacters. The regexp metacharacters define the type and number of characters that can match part of a pattern. Character classes allow a pattern to match multiple characters simultaneously. Character classes are: d Digits 0–9 D Anything not a digit w Any alphanumeric character or an underscore (_) W…
Ajax, Web Services & XML Part II Last time we created an Ajax application that wrapped an XML request in a SOAP envelope and called a web service. The web service returned another SOAP stream with a listing of theaters, movies and show times. We settled for showing the data in a textarea. In this installment we’ll go the final yard and parse the XML into tabular data to be displayed in the browser. If you look at file ajax2b.html you’ll see that the “updateMe()” method has been updated to…
The concept of functions in C language is the same as for any other programming language. Few languages have methods but, since there are no classes in C, methods are not used. Functions are best used for reusable code, or code that you know works and do want make use of it throughout development. If you find yourself tempted to use copy and paste on a particular block of code, even once, then you should move the code into a function. Lets talk about the different types of variables before…
XML Introduction In this tutorial you will learn about XML, History, Introduction, Uses, XML Technology. HISTORY In 1970 IBM Introduced SGML (Standard Generalized Markup Language). SGML was developed out of the General Markup Language (GML), which was developed by IBM in the late 1960s. SGML is a semantic and structural language for text documents but is very complicated. HTML is a subset of SGML. In 1996 XML Working Group was formed under W3C .The World Wide Web Consortium (W3C) is an international consortium where Member organizations, a full-time staff, and…
JSP Basics Java Server Pages (JSP) is a Java API in J2EE which allows dynamic creation of web pages using Java. It has the same purpose as other existing technologies like CGI or PHP. In this tutorial you will learn about Lifecycle of JSP pages, Dynamic content generation, Invoking Java code using JSP scripting elements, JavaBeans for JSP and Error Handling. The main difference between servlets and JSPs is that servlets are Java classes and JSPs are not (they are embedded in HTML pages). This difference also specifies where you…
VB Script – How to use VBScript with Forms In this tutorial you will learn about How to use VBScript with Forms. Introduction, How to do validate your Forms and Conclusion Introduction Now this is the last topic of the tutorial and you will learn how to validate and submit the data to the web server. How to do validate your Forms The process to validate the forms are as under. The two things should be checked. 1. All of the required data is entered. 2. The data entered is…
VB Script – Controlling VB Script Routines In this tutorial you will learn about Controlling VB Script Routines, Introduction, VB Script Description, If then else, Select Case, Looping Statements – For Next, For Each Next, Do loop, Do While, Do Until, While wend and Conclusion. Introduction Every programming language allows you to control the flow of your program like this VbScript also allows you to control how your scripts process the data by using conditional statements and iteration statements i.e sometimes called the looping statements. With the help of these…
Career Strategies for Women You’re a smart woman. You’ve acquired your top quality education, gained some valuable work experience, and have a multitude of skills to offer the corporate world. You interview well, have a professional appearance, and rival some of the best managers in the industry. Yet, time and time again, you are either passed over for employment opportunities or underpaid. What gives? Many would contend that it’s a man’s world out there. Despite the fact that women have come a long way in the corporate world, they still…
Loops are group of instructions executed repeatedly while certain condition remains true. There are two types of loops, counter controlled and sentinel controlled loops (repetition). Counter controlled repetitions are the loops which the number of repetitions needed for the loop is known before the loop begins; these loops have control variables to count repetitions. Counter controlled repetitions need initialized control variable (loop counter), an increment (or decrement) statement and a condition used to terminate the loop (continuation condition). Sentinel controlled repetitions are the loops with an indefinite repetitions; this type…
“Decision making” is one of the most important concepts of computer programming. Programs should be able to make logical (true/false) decisions based on the condition they are in; every program has one or few problem/s to solve; depending on the nature of the problems, important decisions have to be made in order to solve those particular problems. In C programming “selection construct” or “conditional statement” is used for decision making. Diagram 1 illustrates “selection construct”. Diagram 1 simple selection construct Conditional statement is the term used by many programming languages.…
C programming language provides several operators to perform different kind to operations. There are operators for assignment, arithmetic functions, logical functions and many more. These operators generally work on many types of variables or constants, though some are restricted to work on certain types. Most operators are binary, meaning they take two operands. A few are unary and only take one operand. Operators can be classified based on the type of operations they perform. C Arithmetic Operators Arithmetic operators include the familiar addition (+), subtraction (-), multiplication (*) and division…
C language provides various data types for holding different kinds of values. There are several integral data types, a character data type, floating point data types for holding real numbers and more. In addition you can define your own data types using aggregations of the native types. The C standard gives detailed specifications on the language; implementations of C must conform to the standard. An “implementation” is basically the combination of the compiler, and the hardware platform. As you will see, the C standard usually does not specify exact sizes…
This tutorial will cover constants and identifiers in C. Constants, as the name implies, are values that never change. In the previous tutorial on data types you have seen how a variable can be declared constant by making use of the const keyword. You can also declare a constant by directly entering its value in the source code. For example, in this code: double pi = 3.14159;char c = ‘A’;char hello[] = "Hello World!"; The number 3.14159, the letter A and the string Hello World! are all constants. You have…
SQL Server 2005 – Using the Database Tuning Advisor In this tutorial you will learn about Using the Database Tuning Advisor in SQL Server 2005, Using the DTA, Open the Database Engine Tuning Advisor GUI, Set the tool options, Hide and unhide the Session Monitor, Tune a workload Transact-SQL script file, View tuning recommendations, Starting the dta command prompt utility and viewing Help and Tuning a simple workload with the DTA command prompt utility. Using the DTA The first condition to launching the Database Tuning Advisor graphical user interface is…
SQL Server 2005 – Defining Indexes In this tutorial you will learn about Defining Indexes in SQL Server 2005 – clustered and non clustered indexex, The Query Optimizer, to create an index, To create a unique index, To create a clustered index, To create full-text indexes, To change index properties, To rename an index, to delete an index, To specify a fill factor for an index, To create an XML index and To delete XML Indexes. When data volumes increase, organizations are faced with problems relating to data retrieval and…
SQL Server Configuration Manager In this tutorial you will learn about SQL Server Configuration Manager, Manage Server & Client Network Protocols, To start the default instance of SQL Server, To start an instance of SQL Server with startup options, To stop the default instance of SQL Server, To connect to another computer with SQL Server Configuration Manager, To connect to another computer with Windows Computer Management, To stop the default instance of SQL Server using net commands, To set an instance of SQL Server to start automatically and To start…
SQL Server 2005 – Unattended Installations In this tutorial you will learn about SQL Server 2005 – Unattended Installations, How to perform a silent installation of SQL Server, To Create .iss file, Basic Header Information for Our Script Files, Checking for the Parameters within the Script, Sample of the Combination of the .iss File within the Batch File, To set the security modes use the following code. Unattended installation is an installation of SQL Server that is done entirely using a script embedded in an .ini file. This file can…
SQL Server 2005 Installation – Maintenance Plan Without Using Wizard Earlier you learnt about Maintenance Plan Using Wizard, In this tutorial you will learn about Maintenance Plan Without Using Wizard. You will also learn how to change the tasks in the Maintenance Plan Wizard. Creating a Maintenance Plan without using the Wizard. 1. In Object Explorer, expand a server, and then expand Management. 2. Right-click Maintenance Plans and select New Maintenance Plan. 3. In the New Maintenance Plan dialog box, type a name for the plan. 4. The Toolbox…
SQL Server 2005 Installation – Maintenance Plan Using Wizard Maintenance plans can be created using the Maintenance Plan Wizard or using the design surface. The Wizard is useful if the DBA wants to create a basic maintenance plan. If he intends to create enhanced work flow then, it is advisable to use the design surface. Maintenance Plans are displayed only to users connected using the Windows Authentication. Invoking The Maintenance Plan Wizard from Add/Remove Programs. One method of accessing the Maintenance Plan Wizard is by navigating to the Add/Remove…
SQL server 2005 Editions The SQL Server 2005 family includes a number of editions—Express, Workgroup, Standard and Enterprise . Each of these editions comes with a range of features. These include high availability, Scalability to high business Intelligence tools—all aimed at empowering the organization and catering to mission critical information streaming down the levels in accordance with the security and authentication policies defined. The low cost mainstream database gives value and functionality and is a dramatic step forward in reducing application downtime. The following table indicates the scalability and performance…
SQL Server 2005 – Management studio interface Summary Page The summary page appears as the largest window on the Management studio interface. This window presents information about the item selected in the object window. The summary page can be configured to start as soon as SQL Server Management Studio starts or later. When the list mode is selected the summary page shows information about the higher nodes. When lower nodes are double clicked the information with reference to the clicked item is displayed. Clicking on F7 invokes the summary page. The…
Oracle Apps 11i : Asset Management – Journal Entries In this tutorial you will learn about Journal Entries: Assets Journal Entries Flow – Oracle Assets creates journal entries for depreciation expense, asset cost, other accounts, and automatically creates general ledger transaction journal entries, if you have set up the journal entry category for that transaction type in the asset book. Journal Entries: Assets Journal Entries Flow The GL period for which you want to create journal entries must be open, The period name in the depreciation calendar assigned to the…
ASP.NET : Displaying Master-Detail Data on the Same Page In this tutorial you will learn how to display Master-Detail Data on the same page, To display the master records, To configure a query to display related records and To test the page Data from related tables can be displayed on one page. The master table data is displayed in a grid and users can select individual rows. When they select a row, one or more details of records are displayed I a scrollable control elsewhere on the page. We shall…
ASP.NET : DataBound Controls – Details View In this tutorial you will learn DetailView DataBound Control, To create a file system Web site, Connecting to SQL Server, Use a Drop-Down List as the Master and To test the drop-down list. The DetailsView is a control that is complementary to the GridView control. It has been introduced in ASP.NET 2.0 to provide an ability to work with a single record or row from an associated data source. The default view of this control is vertical with each column of the record…
ASP.NET Using a Grid to Display Detail Information In this tutorial you will learn how to use a GridView Control to display the details of the item selected in the DropDown list and test the page. We shall now use a GridView to display the details of the item selected in the DropDown list. 1. Switch to or open the Default.aspx page (or the page you have been working with), and switch to Design view. 2. From the Data group of the Toolbox, drag a GridView control onto the page.…
Adding Sorting and Paging in GridView In this tutorial you will learn adding sorting and paging in a GridView Control, Implement Two Column Sorting, Create Code for Custom Sorting, Editing the GridView control data, Deleting Displayed Records, Inserting Records and Using Templates. Adding Sorting and Paging Sorting and paging can be added to the GridView control without writing any code. 1. In Design view, right-click the GridView control, and then click Show Smart Tag. 2. On the GridView Tasks menu, select the Enable Sorting box. 3. The column headings in…
ASP.NET GridView Filtering In this tutorial you will learn how to add a filter to a Grid View Control, To modify the query with a parameterized filter, the WHERE Clause, Parameter properties, Parameter Value Editor and To test filtering. Adding Filtering If the developer wants to display only selected data in a page, the query for the SqlDataSource control will have to be modified. The first step in this process is to add a Textbox control where the users can enter the filter condition. The filter condition then becomes the…
ASP.NET Web Pages and Layout In this tutorial you will learn how to Enable Users to Edit Pages and Change Layout, To create a user control that enables changing page layout, To enable users to change the layout and To test layout changes. Enabling Users to Edit Pages and Change Layout As stated earlier in this tutorial, Web parts facilitates the editing of Layout by users. Users can drag and drop controls by dragging them from one zone to another and the characteristics of controls can be edited. This functionality…
ASP.NET Adding Web Parts at Run Time In this tutorial you will learn how to add Web Parts at run time and To test the Web Parts catalog. To allow users to add Web Parts at run time 1. Open the Start.aspx page, and switch to Design view. 2. From the WebParts tab of the Toolbox, drag a CatalogZone control into the right column of the table, beneath the EditorZone control. 3. Both controls can be in the same table cell because they will not be displayed at the same…
Oracle Apps 11i Free Training : Setting up Chart Of Accounts (COA) In this tutorial you will learn how to create a Chart Of Accounts (COA), create a new value set, General Ledger – List Types, Security Types, Format Types, Validation Types, Oracle GL Segments and Create the Accounting Flexfield Structure. Setting up Chart Of Accounts Document Summary This document is a step-by-step guide to understanding and setting up Chart of Accounts and Accounting Flex Fields in Oracle Applications. To setup General Ledger for your organization, step through the following…
VB.NET 2005 Tutorials : Shared Assembly In this tutorial you will learn about Shared Assembly, how to Assign Strong name to an assembly, Microsoft Windows Installer 2.0, Using the Global Assembly Cache tool (Gacutil.exe), Removing an Assembly from the Global Assembly Cache, Referencing an Assembly from Global Assembly Cache, Creating a Setup project for distributing components and Creating a new merge module project. Shared Assembly Shared Assembly can be shared amongst several different applications that reside on the same server. This type of assembly can be used in situations where…
VB.NET 2005 Tutorials : Testing a Windows Application In this tutorial you will learn how to Test a Windows Application, Creating Unit Tests, Generating an ASP.NET Unit Test, benefits of unit testing, Integration Testing, Different approaches to Integration Testing, Regression Testing, goals of regression testing and Testing International Applications. Testing An application is software is created to function efficiently given the necessary parameters. Developers are conscious that, even in the most efficiently created software, errors of a certain nature can occur and must be provided for at design time. Yet…
ASP.NET Managing Membership and Roles In this tutorial you will learn about Anonymous Users, Managing Membership and Roles, The Programming Interface – Properties and Methods, Setting up the Membership, The Membership Provider, The ProviderBase Class, The MembershipProviderBase Class, Managing Roles, The Role Class and The Role Provider. Anonymous Users Before actually moving into the topic of creating roles and managing users, we need to talk on how to deal with Anonymous users ASP.NET 2.0. The Beta version provides a new feature that assigns an identity to the anonymous users. The…
Creating Web Service Project In this tutorial you will learn about Creating a Web Service Project. Creating Web Services Creating a Web Service Project Purpose: To create an XML Web service project and thereby separate the functionality of the web service from the web site: 1. On the File menu, point to New, and then click Web Site. 2. In the New Web Site dialog box, select the ASP.NET Web Service icon. 3. Enter the address of the Web server on which you will develop the XML Web service. Use…
In this tutorial you will learn about Using the Data Form Wizard – Building a Single-Table Data Form, Transform and Filter Data, Using Server Explorer, Drag-and-Drop From Server Explorer, What the user Can and Cannot Drag from Server Explorer, Filtering Data, Filtering With DataViews, Filtering At the Server, Transforming Data with Lookups and Master Detail. Using the Data Form Wizard Building a Single-Table Data Form Adding a single table to a form using a wizard makes for ease of application development. The following example demonstrates the building of a form…
In this tutorial you will learn about Complex Data Binding, Binding to a ComboBox or ListBox, Binding to a DataGrid. Complex Data Binding Complex data binding is the ability of a control to bind to more than one data element, typically more than one record in a database, or to more than one of any other type of bindable data elements. Examples of controls that support complex binding are the DataGridView, ListBox, and ErrorProvider controls. Binding to a ComboBox or ListBox In this section let us create a complex binding…
VB.NET 2005 Tutorials: Simple Data Binding In Section 1 of Data Binding you will learn about definition of Data Binding Bindable Entities, The Architecture of Data Binding, Bind Data to the User Interface and Simple Data Binding Data Binding The process of binding a control to a data source is called data binding. Visual Studio 2005 includes several new features to assist in developing applications that access data. The Data Source Configuration Wizard simplifies connecting the application to data in databases, Web services, and user-created objects. The new Data Sources…
VB.NET Creating and Managing Components Part 1 In this tutorial you will learn about Components, Best practices in using Components, Creating Components by extending the UserControl Class, Testing the Control, Creating and implementing Events, Extending a control through Visual Inheritance and Inheriting from a UserControl. A component is a reusable piece of code in binary form. This code can be reused by inheritance. No class is being inherited. It follows that a containment relationship is defined between the application using the component and the component that is being used. This…
Creating and Managing Components Part 2 In Section 2 of Creating and Managing Components You will learn about Hosting a control inside Internet Explorer, HTMLAnchor Control, HTMLButton Control, HTMLGeneric Control, Creating Components by extending the Control class, Creating a custom control and Creating components by extending the Component class. Hosting a control inside Internet Explorer ASP .NET server controls are group of new controls provided by .NET. They are of different kinds. HTML Server controls, Web Server controls and Validation controls are the other types. These controls derive from System.Object…
How to Install and Use NetBeans for Java Development In this guide, I will try to explain you how you can run examples for J2EE tutorials. There are many ways you can do this, here we will be using the examples in NetBeans IDE which is one of the most powerful open source Java integrated development environments available. The main reason for not selecting another open source IDE like Eclipse is that newest version of NetBeans has built-in free J2EE support. This allows the new users to be able to…
.NET Common Windows Forms Controls In this tutorial we will learn about Common Windows Forms Controls in Visual Basic .NET 2005. IN this part 1 of this article, We will be learning the controls like Control Hierarchy, Label, LinkLabel, TextBox, RichTextBox, PictureBox, GroupBox, Panel, Button, CheckBox , RadioButton, ListBox, CheckedListBox and ComboBox.Control Hierarchy The base class for all Windows controls is located in the System.Windows.Forms namespace. These controls are built into the .NET framework and form the basis for derived controls. These controls have a distinct hierarchy of their own. For…
Oracle Apps 11i Tutorials : Oracle Flex fields This chapter provides you with a conceptual overview of flexfields. The chapter covers the following topics The general features of flexfields, Flexfields terminology , The benefits of flexfields and Descriptive Flexfields.Overview of Flexfields Oracle flexfields is one of the most important parts of Oracle Applications. It is because of the flexfields that the Oracle Applications is so generic in nature and can be used to suit any industry or organization. A flexfield, as the name suggests, is a flexible data field that…
Oracle Apps 11i Free Training : Concurrent Processing : This document talks about the concurrent processing in oracle applications. It will give the step-by-step procedure of creating concurrent programs in oracle applications. All types of concurrent programs are described in detail. Concurrent programs can be scheduled to run or manually run in oracle applications. In Oracle Applications, concurrent processing simultaneously executes programs running in the background with online operations to fully utilize your hardware capacity, hence the name ‘Concurrent Processing’. You can write a program (called a ”concurrent program”) that…
Oracle 10g Installation tutorial depicts step by step installation of Oracle 10g on Windows 7, 64bit (10204_vista_w2k8_x64_production_db) operating system. Installation on Windows 7 will return a operating system version compatibility error. However, there will not be any such issue during installation on older version of Windows operating system. It is important to note that this installation method is neither certified nor recommended by Oracle. If you are planning to install Oracle 10g for production purpose then please follow the Oracle specified installation guidelines and use only the correct and supported…
The predictive model of the decision tree helps users determine whether similar cases will have a similar behavior. The attributes of the tree can be examined for impact analysis by using the Dependency Network Browser. This can be opened by right clicking on a decision tree data mining model in the Analysis services explorer tree control. The Dependency Network Browser window contains a slider on the left and a display window on the right. It contains a Close and help button at the bottom. When the slider is moved…
Let us assume FoodMart wants the members with Golden Membership to be studied. It wants to focus on broadening the membership of the Gold Card. This can be done now using the Decision Tree Model. The Decision Tree model can be created from the relational data contained in the FoodMart 2000 Access database. 1. In the Analysis Manager tree pane right click the Mining model folder and select New mining model… 2. In the Wizard Welcome screen click Next to proceed. 3. In the Select the source type screen select…
The process of probing into a set of information for descriptive and predictive purposes is called data mining. The purpose is to identify those trends and patterns which indicate the direction of effort to achieve desired outcomes. SQL Server 2000 and Analysis Services, has inbuilt powerful data mining capabilities including algorithms for Clustering and for Decision Trees.Before actually studying the data mining capabilities of Analysis Services, let us briefly look at some terminology generally used while discussing data mining. Understanding Terms used in Data Mining A case is the term…
When roles are assigned for cubes the user has access or no access to the cube. When roles are assigned to a dimension, the user gains only partial access to parts of the cube. The simplest method of restricting access to a dimension is to prevent access to all levels except the top level of the dimension. In the Cube role dialog box all users were given complete access to the sales cube. Let us restrict the access of users by permitting them to see only values broken out by…
When a new database is created a default role is created for all OLAP Administrators to have access to the Analysis Manager. However, other users have to be given rights to access the database and its objects. Users can be given rights to Browse the cubes and objects but not to use Analysis Manager. If the user has to be given a right to use both the database objects and the Analysis Manager, specific rights have to be assigned. To assign database roles to users, right click the database and…
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.AcceptRejectRead More
Privacy & Cookies Policy
Privacy Overview
This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
