Thursday, July 23, 2009

Database transaction

A database transaction comprises a unit of work performed within a database management system (or similar system) against a database, and treated in a coherent and reliable way independent of other transactions. Transactions in a database environment have two main purposes:

1. To provide reliable units of work that allow correct recovery from failures and keep a database consistent even in cases of system failure, when execution stops (completely or partially) and many operations upon a database remain uncompleted, with unclear status.
2. To provide isolation between programs accessing a database concurrently. Without isolation the programs' outcomes are typically erroneous.

A database transaction, by definition, must be atomic, consistent, isolated and durable. Database practitioners often refer to these properties of database transactions using the acronym ACID.

Transactions provide an "all-or-nothing" proposition, stating that each work-unit performed in a database must either complete in its entirety or have no effect whatsoever. Further, the system must isolate each transaction from other transactions, results must conform to existing constraints in the database, and transactions that complete successfully must get written to durable storage.

Thursday, July 09, 2009

NetApp Named MS 2009 Storage Solutions Partner

NetApp has been named the Microsoft 2009 Partner of the Year, in the advanced infrastructure, storage solutions category. NetApp was chosen out of an international field of top Microsoft partners for delivering market-leading customer solutions for Microsoft Hyper-V environments.

NetApp was chosen on its partnership with Microsoft and complete solutions that help reduce customers' costs, maximize storage efficiency, and improve availability in virtual environments. With NetApp, Microsoft customers can reduce the amount of storage they need by at least 50 percent when they also use NetApp technologies such as thin provisioning and deduplication, the company said.

NetApp utilizes a variety of Windows Server platform technologies to improve storage system management and streamline backup, recovery, and remote replication in Windows Server 2008 Hyper-V environments. In addition, tight integration with the Microsoft System Center family of products and additional application-integrated NetApp products help maximize uptime for a wide variety of application environments, including Microsoft Exchange Server, SQL Server, and SharePoint Server. Since NetApp storage solutions are tightly integrated with Microsoft's technologies, customers are backed by NetApp's global customer support infrastructure, which integrates Microsoft Premier Support.

"We are very excited about working with NetApp to deliver innovative end-to-end solutions to our joint customers. The combination of our technology with NetApp's storage solutions gives our customers the tools they need to improve efficiency, reduce costs, and drive their businesses forward," said Kim Akers, General Manager (Global Partner Team), Microsoft.

Rajesh Janey, President (Sales), India & SAARC, NetApp, said, "Being chosen as Microsoft's Storage Partner of the Year is a great honor for NetApp. While this award establishes NetApp as the leading storage solutions provider for Microsoft virtualization customers, more than anything it underlines the customer success our partnership and close collaboration has delivered."

Wednesday, July 01, 2009

Native MySQL Storage Engines

The MySQL offers a number of within developed storage engines that are well-suited for data warehouses, with the mainly popular being the evasion MyISAM storage engine. The MyISAM engine delivers rapid data loading capabilities, fast study times, and much more for data warehousing users. Typical MyISAM support for data warehouse volumes range up to 1TB contentedly. MySQL offers other storage engines that can also be used for data warehousing as well. MySQL supports these key data warehousing features:

  • Data/Index partitioning (range, hash, key, list, composite) in MySQL 5.1 and above
  • No practical storage limits with automatic storage management
  • Built-in Replication
  • Strong indexing support (B-tree, fulltext, clustered, hash, GIS)
  • Multiple, configurable data/index caches
  • Pre-loading of data into caches
  • Unique query cache (caches result set + query; not just data)
  • Parallel data load
  • Multi-insert DML
  • Read-only tables
  • Cost-based optimizer
  • Wide platform support

Infobright offers a storage engine for the MySQL Server that is tailor-made for large scale, analytic-styled data warehousing. Infobright enables MySQL users to move up to data warehouses that support data volumes of 1-10TB or more with these key capabilities:

  • Column-oriented design
  • High data compression capabilities
  • Advanced optimizer with "Knowledge Grid"
  • High-speed loader

Friday, June 19, 2009

MySQL to Microsoft SQL database Converter

The MySQL to MSSQL Database Converter value has an easy, read only, quick responding explanation for converting MySQL database proceedings into Microsoft SQL database format. MySQL server to Microsoft SQL server database migration utility does not change the table, rows or columns of the source database and maintain the MySQL database file integrity during the database migration process.

Advanced database translation software is purposely designed for professionals who need quick and reliable database conversion and support the entire database Architecture, Schemas, Default Values, Primary key, and other database attributes. The cost-effective, secure database converter even provides you an option to save the converted MSSQL database format at user defined location.

Microsoft SQL database generator is a prominent program having a good looking graphical interface and has an exclusive do-it-yourself feature with no technical learning required while working on the software. Download the freeware demo of MySQL to Microsoft SQL database converter utility to understand the effective functionality of the software. On getting satisfactory results purchase the full version from our website.

Software Features

  • Powerful and versatile MSSQL to MySQL database converter suite with simple and fast working.
  • Supports all database Key Constraints, Data Types, Schemas, Attributes, Tables, Rows, etc. even after MySQL database conversion.
  • Specifically designed for database developers and programmers since save time by converting single or multiple database records.
  • Far easier to use and supports all versions of MSSQL and MySQL database.
  • Provides the option of saving the converted database records either at new location with new name or overwrites the existing database records.
  • Have an impressive user friendly graphical interface and an exclusive do-it-yourself feature.
  • Windows compatible database converting wizard smoothly runs on all windows platform.


  • Time-saving, reliable and easy to use database conversion utility.
  • Reduces the labor cost since automatically converts the MySQL database records.
  • No database scripting or encoding is required for database conversion.
  • Efficiently works with all the MySQL and MSSQL database versions.
  • An alternative solution for the complicated MySQL to MSSQL database converting programs.

System Requirement

  • Pentium-class or equivalent processor
  • RAM (128 MB recommended)
  • 10 MB of free space

Supported Operating System:

Windows 98/ME/NT/2000/2003/XP/Vista

Monday, May 25, 2009

microsoft sql

The code base for MS SQL Server (prior to version 7.0) originated in Sybase SQL Server, and was Microsoft's entry to the enterprise-level database market, competing against Oracle, IBM, and, later, Sybase itself. Microsoft, Sybase and Ashton-Tate originally teamed up to create and market the first version named SQL Server 1.0 for OS/2 (about 1989) which was essentially the same as Sybase SQL Server 3.0 on Unix, VMS, etc. Microsoft SQL Server 4.2 was shipped around 1992 (available bundled with Microsoft OS/2 version 1.3). Later Microsoft SQL Server 4.21 for Windows NT was released at the same time as Windows NT 3.1. Microsoft SQL Server v6.0 was the first version designed for NT, and did not include any direction from Sybase.About the time Windows NT was released, Sybase and Microsoft parted ways and each pursued their own design and marketing schemes. Microsoft negotiated exclusive rights to all versions of SQL Server written for Microsoft operating systems. Later, Sybase changed the name of its product to Adaptive Server Enterprise to avoid confusion with Microsoft SQL Server. Until 1994, Microsoft's SQL Server carried three Sybase copyright notices as an indication of its origin.

Since parting ways, several revisions have been done independently. SQL Server 7.0 was a rewrite from the legacy Sybase code. It was succeeded by SQL Server 2000, which was the first edition to be launched in a variant for the IA-64 architecture.In the eight years since release of Microsoft's previous SQL Server product (SQL Server 2000), advancements have been made in performance, the client IDE tools, and several complementary systems that are packaged with SQL Server 2005. These include: an ETL tool (SQL Server Integration Services or SSIS), a Reporting Server, an OLAP and data mining server (Analysis Services), and several messaging technologies, specifically Service Broker and Notification Services.

Monday, May 04, 2009

Integrated Circuit

In electronics, an integrated circuit (also known as IC, microcircuit, microchip, silicon chip, or chip) is a miniaturized electronic circuit (consisting mainly of semiconductor devices, as well as passive components) that has been manufactured in the surface of a thin substrate of semiconductor material. Integrated circuits are used in almost all electronic equipment in use today and have revolutionized the world of electronics.

A hybrid integrated circuit is a miniaturized electronic circuit constructed of individual semiconductor devices, as well as passive components, bonded to a substrate or circuit board.
This article is about monolithic integrated circuits.

Integrated circuits were made possible by experimental discoveries which showed that semiconductor devices could perform the functions of vacuum tubes, and by mid-20th-century technology advancements in semiconductor device fabrication. The integration of large numbers of tiny transistors into a small chip was an enormous improvement over the manual assembly of circuits using discrete electronic components. The integrated circuit's mass production capability, reliability, and building-block approach to circuit design ensured the rapid adoption of standardized ICs in place of designs using discrete transistors.

There are two main advantages of ICs over discrete circuits: cost and performance. Cost is low because the chips, with all their components, are printed as a unit by photolithography and not constructed one transistor at a time. Furthermore, much less material is used to construct a circuit as a packaged IC die than as a discrete circuit. Performance is high since the components switch quickly and consume little power (compared to their discrete counterparts), because the components are small and close together. As of 2006, chip areas range from a few square mm to around 350 mm², with up to 1 million transistors per mm².

Thursday, April 16, 2009

Old IBM Personal Computer

The IBM Personal Computer, commonly known as the IBM PC, is the original version and progenitor of the IBM PC compatible hardware platform. It is IBM model number 5150, and was introduced on August 12, 1981. It was created by a team of engineers and designers under the direction of Don Est ridge of the IBM Entry Systems Division in Boca Raton, Florida.

Alongside "microcomputer" and "home computer", the term "personal computer" was already in use before 1981. It was used as early as 1972 to characterize Xerox PARC's Alto. However, because of the success of the IBM Personal Computer, the term came to mean more specifically a microcomputer compatible with IBM's PC products.