Tips for designing a database
Designing a database is not easy and yes very important, since poor design leads to difficulties in developing or implementing a complex application. Some tips that are very necessary and often not carried out. Poor design: the design is fundamental, we must first know what you need to display and then design the database correctly. [...]
Transactions
Congratulations! But don’t start counting your chickens: You still have some work to do before you make those sales. You can’t send customers their products until you calculate the bottom lines. And more importantly, you still need to determine whether they have the funds to pay for their purchases. So before you accept those orders, [...]
Migrating MySQL to PostgreSQL
This time we continue to see the tools provided in this suite of free software, is now the turn to introduce the use of a new application llamdo Migration Wizard as the name suggests enables a clean migration database implemented in MySQL to another database implemented in PostgreSQL, if as you read, this is aspirin [...]
Database Marketing Power
The Internet is built on information, and it makes sense to utilize that information to build your own e-business. Database marketing is part of the future of online sales and professional database management companies are developing extensive lists of potential customers that can help you to make the most of your marketing efforts.
Tuning Large Oracle Apps
The Optimizer Any attempt to solve performance problems within your applications must start with an understanding of the ORACLE Optimizer and its role in increasing performance. When a SQL SELECT, UPDATE, INSERT or DELETE statement is processed, ORACLE must access the data referenced by the statement. The Optimizer portion of ORACLE is used to determine [...]
QUERY and the Database
Not needing a SQL database for every site or every table means you can use Interchange in more hosting environments, but that”s has usually come at the cost of being able to use SQL as your query language. Fortunately Interchange comes with a built-in SQL interpreter, which means you can use a single query language [...]
