Open-source database company MySQL plans to provide technical details next week on its homegrown storage engine and upcoming administration tools.
The database engine, code-named Falcon and due for completion later this year, will be built specifically for running transactions, said Zack Urlocker, vice president of marketing at the company. A beta version is due out this summer, he said.
MySQL executives will detail Falcon and other upcoming tools at its user conference, which will take place Monday through Thursday in Santa Clara, Calif.
The company gained the beginnings of Falcon when it acquired Netfrastructure, a consulting company that employed database luminary Jim Starkey.
MySQL's database is built so that it can use a range of different storage mechanisms, tuned for different purposes, such as transactions or indexing large amounts of text.
"Rather than have one perfect engine, it's better to have a pluggable architecture," Urlocker said. "The idea is you can mix and match within a single application because data will be used in different ways."
He said that Falcon is being designed for "scale out" configurations, where an application, such as an e-commerce site, is powered by several, relatively low-priced servers, rather than a few, more powerful machines.
MySQL is expected to disclose the names of other software companies, including Solid Information Technology, that intend to write storage engines for the MySQL database.
Company executives also intend to show off MySQL Workbench, a graphical database design tool under development, which will be released under the open-source General Public License.
Look, I really don't want to throw cold water on you. The implementation of an ANSI standard SQL DBMS, is not restricted to a vision of "Rows are not records, etc", in truth its, well, wrong.
However, I was intrigued by this statement, so I decided to take a look at your site. There is nothing wrong with pushing yourself, but you must be careful about forming strong views, that could be based on an assumption. I guess I'm saying its ok to be wrong, just be aware that sometimes, especially within the first five years of coding, when you think you're absolutely right you can be absolutely wrong. Unfortunately, this "affliction" occurrs throughout ones career, but with far less frequency with experience.
So, instead of being critical, which is a good thing if you can learn from it, I am including something for you to look at (in reference to your link):
CREATE TABLE [Suburbs] ( [id] INT IDENTITY(1, 1) PRIMARY KEY, [suburb] VARCHAR(50) NOT NULL, [state] VARCHAR(2) NOT NULL ) GO CREATE TABLE [Surrounds] ( suburb_id INT REFERENCES [Suburbs]([id]) ON DELETE CASCADE, [n_suburb_id] INT REFERENCES [Suburbs]([id]) ON DELETE NO ACTION ) GO CREATE UNIQUE INDEX ucix ON [Surrounds]([suburb_id], [n_suburb_id]) WITH IGNORE_DUP_KEY GO
The search giant is considering selling its merchandise in a retail store at its European headquarters. Plans have been approved, but the company hasn't made a decision yet.
Members from Change.org deliver a quarter of a million signatures to Apple's Manhattan flagship store in Grand Central Terminal on a petition calling for an ethical iPhone 5. It was part of the delivery of signatures to stores around the world.
Now due on February 29, the new Windows 8 Consumer Preview will offer several built-in Metro apps, including Music, Video, Mail, Messaging, and SkyDrive.
After large numbers of longtime 'Burners' failed to get tickets during the event's recent selection process, many claimed organizers had failed to adopt a sensible system. Now, those organizers are trying to calm community anger.
Creating a tiny version of a coaxial cable, researchers at the University of California at San Diego create smallest laser to date, an advance that could lead to optical computer chips or high-resolution displays.
Star Wars Episode I 3D comes out on Friday, but CNET UK's Jason Jenkins got an advanced screening of the flick. Should you spend your hard-earned money to go see it? Read on to find out.
SolarReserve hits a milestone on a 110-megawatt solar power plant that will have between 10 and 15 hours of energy storage in tanks of molten salt for supplying Nevada.
Rows are not records; fields are not columns; tables are not files!!
<a class="jive-link-external" href="http://joecelkothesqlapprentice.blogspot.com/" target="_newWindow">http://joecelkothesqlapprentice.blogspot.com/</a>
implementation of an ANSI standard SQL DBMS, is not restricted
to a vision of "Rows are not records, etc", in truth its, well,
wrong.
However, I was intrigued by this statement, so I decided to take
a look at your site. There is nothing wrong with pushing
yourself, but you must be careful about forming strong views,
that could be based on an assumption. I guess I'm saying its ok
to be wrong, just be aware that sometimes, especially within the
first five years of coding, when you think you're absolutely right
you can be absolutely wrong. Unfortunately, this "affliction"
occurrs throughout ones career, but with far less frequency with
experience.
So, instead of being critical, which is a good thing if you can
learn from it, I am including something for you to look at (in
reference to your link):
CREATE TABLE [Suburbs]
(
[id] INT IDENTITY(1, 1) PRIMARY KEY,
[suburb] VARCHAR(50) NOT NULL,
[state] VARCHAR(2) NOT NULL
)
GO
CREATE TABLE [Surrounds]
(
suburb_id INT REFERENCES [Suburbs]([id]) ON DELETE CASCADE,
[n_suburb_id] INT REFERENCES [Suburbs]([id]) ON DELETE NO
ACTION
)
GO
CREATE UNIQUE INDEX ucix ON [Surrounds]([suburb_id],
[n_suburb_id]) WITH IGNORE_DUP_KEY
GO