VFP: Sedna February CTP released

Thanks for the comment, even though it is hard for me to understand. I used Google translate to translate the comment into English and it did a semi-reasonable job:
http://translate.google.com/

Here it is:
vfp database set: massive storage, the experience is still very fast
(1) At present, for all databases, personal view is that: From the types of operations. Can be divided into two categories. Document-type databases, and service-oriented databases.
The former has access and the vfp database, file-based disk storage, no platform to be used directly. Latter sql_server and oracle and so on, basically the use of platform
To be used. The current common usage, the former focusing on a small local area network or stand-alone, which is focused on large-scale network or remote services. Because the two uses have different emphases,
Therefore, the performance and the performance of their main functions of each other does not take into account. The former are simple and easy to run fast, and very easy to transplant and modified.
Which, vfp database features more prominent. He not only runs faster, but the carrying capacity of more than a single table access. Because he is subject to vfp direct manipulation,
Among the many databases do not need to do is the only database connection can also be played straight through, direct operation of the database. So far, easy to operating performance,
In various databases is still a first. Service-oriented database features, large capacity, sharing high-performance, port security is strong. Therefore suitable for use
Large-scale network and remote. However, the specific use, you can not play straight through, you must be an effective link between the use of more stringent sql query in order to achieve its function,
In contrast, cross-database query is difficult, slow.
(2) from the database table using the characteristics of the capacity of all the database tables can be divided into two categories. Finite type table and the two types of infinite-type table, which is in accordance with the database
Table use, the user storage limits the amount of data to distinguish, on the table itself is irrelevant attributes. For example: for example, his system in a hospital, medicine table of contents
Table of fees and charges, the doctor watches, hospital departments such as the name of the table. These tables store the number of records, with the constant over-time, practical application, he would not be infinite
Increase the number of records. In short, the record data to reach a certain amount, follow the actual needs, there will not be the number of the number of records to continue to add, or are no longer increased.
Present limit state. This table can be called the finite type table. Let us look at some other table: outpatient and in-patient business records, tables, storage items, or a database table, etc.
These tables store the number of records will be accompanied by the constant over time, he will continue to increase indefinitely the number of records. Presents an infinite upward trend, there is no limit.
This table can be called an infinite-type table.
(3) vfp database, set focus on. With regard to finite type table, storage capacity and speed, the general never quite found a little difficulty, the operation is also easy to grasp.
However, the infinite-type form different from that, when a class data on a constant data sheet, when the volume of data reaches a certain level, ultra-large storage data,
Fast as ever you want to still maintain a database operation, apparently become more difficult. For the infinite-type table, the database collection begun to play a significant role.
As the vfp database is a file database, using documentary-type feature to a large extent, solve the vfp massive amount of data tables stored records,
How to quickly implement database operations are still problems. Database set for is the infinite-type data table.
(4) vfp set of structural features of the database. To store data in a similar infinite-type table, divided into the same structure and fields of a large number of tables, and orderly placed
Folder, the folder is ordered, can be superimposed layers, which could accommodate hundreds of thousands of Zhang same structure table. The amount of hard disk storage of documents has always been great.
To accommodate data record for each table, it is relatively small. Normal circumstances, the data manipulation is only a very small number for the records of a few tables for a large number of the same structure
And fields of the tables, temporary tables do not belong to independent operation. Targeted operations, makes the operating speed considerably strengthened. The large quantities of the same structure
And fields of the file folder database is a database set.
The database set, like a huge library, is like a bookshelf inside a folder inside the folder there are folders, layer upon layer overlay,
The bottom of the folder before the last field contains the number of documents with the database and tables. This is what a huge database! Can simply calculate factorial!
Data storage, query, exchange, in a large number of the library the same field in the table, only a very small number of relevant databases folder, just like in a library,
Find information and to keep books in accordance with the laws of nature, of course, is the type of room all the books as close as possible, with shelves of books for further similar
Is more similar books on the same floor .., step by step approximation, with those adjacent. We are the repository of information, it is impossible to all the extremely large number of similar information, are placed in a book, the
Let alone put it in a book within a page, so this page of the paper has become very, very long. Database storage and query pattern set,
Is an isomorphism with the field more than a collection of tables, data storage and query, is the address of an orderly dispersion and concentration of blending, in line with the natural laws of general laws.
(5) vfp database set scalability. He is very easy to expand, and can automatically or manually, directly copy the empty database, the database immediately increased
Number. As long as the capacity of hard disk space permits, he may have been copied down. Presents a true mass storage. At the same time, the data stored in the implementation, the
Can do more than the same time in different disk storage. Therefore, this database usually does not require manual backup, handle it properly will ensure that data is never lost.
Because normal circumstances, the multi-computer multi-disk at the same time damage is almost impossible.
(6) database set classification.
(A) time series model. This is according to a certain period of time to design a table. Example, the same day, a structure of the table. Automatic replacement of a new table every day operations.
Focused primarily on the order of time, regular time, place all the data operations. For example: February 16, 2010 article out of the warehouse database logs.
Can be: \ \ .. \ e $ \ y2010 \ m02 \ wpck! Wpck_16, he just kept on that day all the data.
(B) the number sequence type. This is a table constructed in accordance with the number ordered. Focused primarily on indeterminate period of time, resulting in data operations. For example: the hospital a patient,
Unsolicited hospital treatment, up to now all the diagnosis, detection, treatment, medication program all the data. Because when he will come to the hospital, when another outbreak? Is an indefinite number,
However, his out-patient number is: 000,051,067, then this table can be: \ \ .. \ e $ 005 \ 10 \ br_67. I kept all the information independently.
As for the out-patient number matrix, that is, all the out-patient number stored table of contents, records of non-repetition. Can be made into a database set. And the library set to guide the table, it is almost a
Finite type table, only the records section.
(C) mixed type. This is the time to type and digital-type meter mixed use. Among them, the time-based folder, there may be digital-type folder, or each other
Doping. This should be designed according to actual needs.
(7) vfp database, set to run features. He runs the biggest characteristic is: to “addressing modes” as his main. Operation of the data, the first search
Is the database address. Data stored on the system can automatically identify what data should be placed in which classes into the database. Query, only to find out these
Database table, the required data definitely on the inside, while the other on the same structure of the database simply not be upheld without operation on it.
Normal circumstances, the realization of the database within a variety of data collection operations, usually only one of which the operation of the table, but within this table
The data is relatively so few! Or to more than one repetition of a similar sheet-type operations. Operation him, as simple as operating leaflets table. Data storage and
Changes in general only 2-3 pairs of leaflets or Zhang tables, so quickly. The data query is written in the database inside a fixed stored procedures. Call a database set,
Like calling a single table. Massive data aggregation, the stored procedure to achieve the side of reading, while aggregate functions. Assembly-line style,
Intermediate does not produce a huge amount of temporary tables. Normal circumstances, all the data inside the database collection, most of the long-term inactive, not to be operating.
This is associated with large databases sql_server or oracle, using a small table to do that existed when the principle of storing massive difference. The latter is precisely the opposite.
For example: the data load: Record daily out-patient services, time of day, type libraries open automatically sets two new blank sheet, in which there is a backup.
Fractionated into synchronous mode all the records that day. For example: Query January 1, 2010 – at the end of the drug out of library details. Addressing the time-based database to find set,
1-31 months out of the table, followed by the merger can be. Search the month summary of drug details, plus a select .. group by statement. Fastest
Check details of a day, directly out of this table can be. Because the data is stored, the advance has been classified according to need storage, query, quick and easy.
(8) vfp database, set the relationship between the stock and speed. With the entire library collection, the increase in the number of records, query speed much.
Since many of them operating mode, the operating speed and the entire library collection, storage capacity has nothing to do. When the whole library collection, the amount of stored data far exceeded the sql_server
Or oracle when compared with the latter, he still presents an extremely fast operating mode phenomenon. The reason is that he has some small tables in one or more runs.
Has been a reliance on “addressing mode” for data manipulation. We all know that addressing the current computer functions, in the end a number of pieces! Is self-evident!
If, in the mass of a large table, the search for records of eligible operations. The latter is, data rises, the
Irrelevant data as a cumulative burden to participate in running. This defect, in a large database, for example: oracle is particularly prominent.
The vfp database set do not have this burden, regardless of the data sheet that he would automatically cease to visit, because of his ways to search is based on “Find Address” as the focus,
Rather than the “big table to find records” approach.
(7) vfp database set and the joint use of service-oriented databases. Because both have their own merits emphasis, in the remote large-scale networks, the use of large databases, for
Receiving and sending data, while data backup storage and query, use the vfp database set. The author’s practical application is to enable a large database of some frequent
Application, exchange capacity up to a database table, always return to an empty record status. Program can automatically exchange data between the two kinds of databases,
Play depicting the role of advantage. Of course, this also involves a lot of problems inside, they could do, depending on flexibility. Can be continued .. ..

Welcome to master more pointing! E-mail: qingfameng@yahoo.cn