CN107025308A - A kind of railroad train moment network inquiry method - Google Patents
A kind of railroad train moment network inquiry method Download PDFInfo
- Publication number
- CN107025308A CN107025308A CN201710328478.0A CN201710328478A CN107025308A CN 107025308 A CN107025308 A CN 107025308A CN 201710328478 A CN201710328478 A CN 201710328478A CN 107025308 A CN107025308 A CN 107025308A
- Authority
- CN
- China
- Prior art keywords
- station
- train
- time
- inquiry
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 61
- 238000012546 transfer Methods 0.000 claims abstract description 53
- 238000000605 extraction Methods 0.000 claims abstract description 11
- 235000021167 banquet Nutrition 0.000 claims abstract description 10
- 238000010845 search algorithm Methods 0.000 claims description 4
- 238000005314 correlation function Methods 0.000 claims description 3
- 238000000151 deposition Methods 0.000 claims description 3
- 238000012423 maintenance Methods 0.000 claims description 3
- 101100311222 Caenorhabditis elegans stam-1 gene Proteins 0.000 claims description 2
- 230000005540 biological transmission Effects 0.000 claims description 2
- 238000003780 insertion Methods 0.000 claims description 2
- 230000037431 insertion Effects 0.000 claims description 2
- 238000012360 testing method Methods 0.000 claims description 2
- 238000013480 data collection Methods 0.000 claims 1
- 238000007493 shaping process Methods 0.000 claims 1
- ZKKLPDLKUGTPME-UHFFFAOYSA-N diazanium;bis(sulfanylidene)molybdenum;sulfanide Chemical compound [NH4+].[NH4+].[SH-].[SH-].S=[Mo]=S ZKKLPDLKUGTPME-UHFFFAOYSA-N 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 2
- 238000013459 approach Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000015572 biosynthetic process Effects 0.000 description 1
- 238000000205 computational method Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 238000003786 synthesis reaction Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24534—Query rewriting; Transformation
- G06F16/24547—Optimisations to support specific applications; Extensibility of optimisers
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/40—Business processes related to the transportation industry
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Economics (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Train Traffic Observation, Control, And Security (AREA)
Abstract
The present invention relates to a kind of train time querying method.A kind of railroad train moment network inquiry method, train Comprehensive Query System is constituted by management program and database, the database includes train time and inquires about summary table, the Back ground Information of train time inquiry is included in train time inquiry summary table, and train time inquiry summary table includes certain station up to station table, up to certain station station table and transfer station table;The information that management program inquires about summary table to train time is imported, exported and safeguarded, keeps upgrading in time for data;Management program proposes that retrieval is required by interface storing process to database, interface storing process obtains from the reachable table in certain station, certain reachable station table and transfer station table and handles corresponding information respectively, Query Result is returned to management program, starting station and point of destination information are provided, the extraction of train information is realized;The remaining ticket information attended a banquet for train, management program responds the inquiry request of user, and the database interface provided by third party is inquired about and issues Query Result.
Description
Technical field
The present invention relates to a kind of train time querying method, more particularly, to a kind of side of railroad train moment network inquiry
Method.
Background technology
Currently, China railways train time network inquiry system is in a higher level.Numerous passengers can be with
Pass through various modes(Computer, mobile phone)Real-time train time information is obtained, and obtains ticket booking or even send ticket service.However, mesh
The train time inquiry mode of preceding major websites is single, is inquired about at the time of CFS to CFS is only included mostly.Individual Web sites are realized
Transfer inquiry, but it is only limitted to secondary transfer inquiry.Function above can not meet increasingly diversified travelling demand.Specifically
The following aspects can be embodied in:
(1)In the case where there is time restriction, passenger has the demand of most short hourage.With the further expansion of the railway network,
Particularly a large amount of high ferro circuits and various train numbers it is progressively open-minded, not necessarily compared by changing to the route realized between two cities
Time needed for direct train is long.For example, the direct train only one of which train number used time in Zhengzhou to Shanghai most it is short be 4 hours 03 point
Clock, other train numbers are at more than 49 minutes 4 hours.And if by transfer, can find hourage 48 minutes 4 hours with
It is interior(Include the middle transfer time)25 groups of combination.Therefore the automatic search of multiple transfer plan is developed, passenger couple can be met
The demand of most short hourage.
(2)In the case where there is routing, passenger has the demand of arrival time the latest.Due to missing the bus or booking is former
Cause, can catch up with what is gone directly between two cities, and the city row that can be achieved the goal before some set time
Car.Now, if it is possible to provide by changing to twice or repeatedly, it is ensured that passenger can reach mesh before a certain set time
City train time information, it is possible to meet demand of the passenger to arrival time the latest.
(3)The demand for preference of attending a banquet.In some cases, relative to hourage, passenger is more paid close attention to selected in route
Classification of attending a banquet.For example, the passenger for the purpose of tourism, or the passenger of more concern comfort level may be more biased towards crouching in selection
Paving.Even, if whole without sleeping berth, but by transfer, within the specified period(Such as night 10 is when morning 6
Between)Sleeping berth can be used, the comfort level demand of passenger also can be largely met.Therefore, by each train order of classes or grades at school
Remaining ticket species and quantity information combine transfer information, then the choice for traveling of more hommization can be provided for passenger.
(4)Redundancy station booking demand.Such as certain train slave station 1 to station 10, approach station 2,3,4,5,6,7,8,9.Certain trip
Visitor is intended to slave station 5 and got on the bus, but station 5 is without ticket.Now it is possible to that the ticket that slave station 1,2,3,4 is got on the bus can be bought.If looked into
Inquiry system can provide above-mentioned Ticketing information, the ticket of website before passenger can buy, and the website where oneself is got on the bus.
(5)Get on the bus the demand bought one's ticket after normal time.In some cases, between two cities direct train transfers to train
Without remaining ticket.If system can inquire the arrival ticket before purpose city for passenger, passenger just can first buy a part
The ticket of route, then gets on the bus and buys one's ticket after normal time.
Therefore, the demand of numerous passengers is considered, in order to meet the diversified trip requirements of numerous passengers, having must
Train time inquiry mode that will be single to existing capability is improved.
The content of the invention
The present invention is in view of the shortcomings of the prior art, propose a kind of railroad train moment network inquiry method.By building row
Car time information database and the search algorithm for proposing correlation, to meet the diversified trip requirements of numerous passengers.
The technical solution adopted in the present invention:
A kind of railroad train moment network inquiry method, train Comprehensive Query System is constituted by management program and database, described
Database includes train time and inquires about summary table, and the Back ground Information of train time inquiry is included in train time inquiry summary table, row
Car moment inquiry summary table includes certain station up to station table, up to certain station station table and transfer station table;Management program is looked into train time
The information for asking summary table is imported, exported and safeguarded, keeps upgrading in time for data;
Management program proposes that retrieval is required by interface storing process to database, and interface storing process is reachable from certain station respectively
Obtained in table, certain reachable station table and transfer station table and handle corresponding information, returning to Query Result to management program, there is provided go out
Hair station and point of destination information, realize the extraction of train information;
The remaining ticket information attended a banquet for train, management program responds the inquiry request of user, the database provided by third party
Interface is inquired about and issues Query Result.
Beneficial effects of the present invention:
1st, railroad train moment network inquiry method of the present invention, by building train time information database and proposing correlation
Search algorithm, can meet increasingly diversified travelling demand.Train time query interface, can be with to vast User Exploitation
Multiple combinations inquiry mode is realized, is mainly included:
(1)Economic preferential inquiry, as lead referral trip train combination, the ticket network minimal for spending client;
(2)Time priority, as lead referral trip train combination, the time that can spend client are most short;Or make user
Can at the appointed time before, arrive at;
(3)Mileage is preferential, and as lead referral trip train combination, the mileage for passing through client is most short;
(4)Preference is preferential, as lead referral trip train combination, enables a customer to using the classification of attending a banquet specified;
(5)Heat source, is lead referral trip train combination, enables a customer to by specified place, and set necessarily
Residence time.
2nd, railroad train moment network inquiry method of the present invention, storing process is write in database, train information is realized
Extraction.In order to accelerate the speed of data query, the system extracts " the reachable station in certain station for producing each website from " summary table "
Table "(The other stations that can be reached from certain station and order of classes or grades at school information), " up to certain station station table "(It is i.e. all to reach
Other stations at certain station and order of classes or grades at school information)" transfer station table "(In order to reduce data retrieval amount, retrieval rate is improved, it is right
Transfer station proposes certain limitation, i.e., reach certain quantity by the train order of classes or grades at school at the station).Design science rationally, makes
With convenient, precision is high, information is reliable.
3rd, railroad train moment network inquiry method of the present invention, can be achieved redundancy station booking demand, i.e., can not be purchased in passenger
In the case of certain the train number ticket for buying starting station, the remaining ticket information at the train number each station before starting station is provided for passenger;
Can be achieved to get on the bus the demand bought one's ticket after normal time, and as passenger inquires the arrival ticket before purpose city, and passenger just can first buy one
Divide the ticket of route, then get on the bus and buy one's ticket after normal time.
Brief description of the drawings
Fig. 1 is train Comprehensive Query System theory of constitution figure of the present invention;
Fig. 2 is " extraction storing process " program flow chart of the invention;
Fig. 3 is " inquiry storing process " program flow chart of the invention;
Fig. 4(a)It is Time Calculation function addtime program flow charts of the present invention;
Fig. 4(b)It is Time Calculation function caltime program flow diagrams of the present invention;
Fig. 5 is management program structured flowchart of the present invention.
Embodiment
Below by embodiment, technical scheme is described in further detail.
Embodiment 1
Referring to Fig. 1, railroad train moment network inquiry method of the invention constitutes train synthesis by management program and database and looked into
Inquiry system, the database includes train time and inquires about summary table, and the Back ground Information of train time inquiry is looked into included in train time
Ask in summary table, train time inquiry summary table includes certain station up to station table, up to certain station station table and transfer station table;Management program pair
The information of train time inquiry summary table is imported, exported and safeguarded, keeps upgrading in time for data;
Management program proposes that retrieval is required by interface storing process to database, and interface storing process is reachable from certain station respectively
Obtained in table, certain reachable station table and transfer station table and handle corresponding information, returning to Query Result to management program, there is provided go out
Hair station and point of destination information, realize the extraction of train information;
The remaining ticket information attended a banquet for train, management program responds the inquiry request of user, the database provided by third party
Interface is inquired about and issues Query Result.
Embodiment 2
Referring to Fig. 1, train Comprehensive Query System is by management program and database(In Fig. 1 dotted line frames)Two parts are constituted.Train
The Back ground Information of moment inquiry is present in " train time inquiry summary table ".
The railroad train moment network inquiry method of the present embodiment, is with the difference of embodiment 1:Wherein tables of data
Each field be respectively:
(1)ID:Train operation order of classes or grades at school;
(2)Type:Train order of classes or grades at school classification;
(3)Station:All stations that train passes through;
(4)No:The station numbering of this order of classes or grades at school train(1 represents the starting station, and follow-up each station is added up successively);
(5)AT:This order of classes or grades at school train reaches the time at the station;
(6)DT:This order of classes or grades at school train leaves the time at the station;
(7)inDay:If this order of classes or grades at school train is in the situation for reaching appearance leap midnight between time and time departure at the station,
The follow-up field adds 1;
(8)Distance:From the mileage number at the starting station when this order of classes or grades at school train reaches the station.
Storing process is write in database, the extraction of train information is realized.In order to accelerate the speed of data query, this is
Unite and " certain station is up to station table " that produces each website is extracted from " summary table "(The other stations that can be reached from certain station
And order of classes or grades at school information), " up to certain station station table "(I.e. all other stations that can reach certain station and order of classes or grades at school information)" transit wagon
Stand table "(In order to reduce data retrieval amount, retrieval rate is improved, centering station for transference proposes certain limitation, i.e., by the station
Train order of classes or grades at school reaches certain quantity).The extraction of " certain station is up to station table " and " up to certain station station table " is time-consuming longer.Actually should
In, it is called in good time according to actual conditions.
Each field of " certain station up to station table " is respectively:
(1)IDU:Starting station train operation order of classes or grades at school;
(2)StaU:Set out station name;
(3)DTTU:Train leaves the time of starting station;
(4)DU:Train leaves the day counting number that starting station is;
(5)DisU:Train is with a distance from starting station is from the train starting station;
(6)StaM1:The transfer station name of this order of classes or grades at school train;
(7)ATTM:This train reaches the time of transfer stop;
(8)DM1:Day counting number of this train in transfer stop;
(9)DisM1:Train is with a distance from transfer stop is from the train starting station.
" up to certain station station table " each field be respectively:
(1)IDD:Change to train operation order of classes or grades at school;
(2)StaM2:Change to station name;
(3)DTTM:Train leaves the time of transfer stop;
(4)DM2:Train leaves the day counting number that transfer stop is;
(5)DisM2:Train is with a distance from transfer stop is from the transfer train starting station;
(6)StaD:Purpose station name;
(7)ATTD:Change to the time that train reaches point of destination;
(8)DD:This train reaches the day counting number of point of destination;
(9)DisD:Train is with a distance from point of destination is from the train starting station.
Interface storing process is write between management program and database.Management field data base-oriented proposes that retrieval is required,
And starting station and point of destination information are provided.Storing process is respectively from " certain station is up to table ", " up to certain station table " and " transfer station
Obtained in table " and handle corresponding information, Query Result is returned to administration interface.Function is write in database, for calculating
Some computational problems in Query Result(The mileage such as needed for transfer scheme expends time, transfer scheme).Due to database
In there is no the remaining ticket information attended a banquet comprising train, the database interface that management program is provided by third party is inquired about.This is
Unite and the inquiry request of user is responded by management program, and issue Query Result.
Embodiment 3
Referring to Fig. 1, Fig. 2, the railroad train moment network inquiry method of the present embodiment is with the difference of embodiment 2:Adopt
Query Result is calculated with the transfer search algorithm being made up of some storing process, function and tables of data, wherein table of standing(Including certain station
Up to table, up to certain station table and transfer station table)Generated by extraction storing process;Inquire about storing process and be based on station table information, and
There is provided with reference to correlation function and transfer to data.
Fig. 2 gives the FB(flow block) of " extraction storing process ", wherein setting " summary table " as W." transfer station is created first
Table ", then inquiry is met the site information insertion " transfer station table " of requirement from table W.Wherein, it is transfer station setting
The purpose of condition is finally to retrieve the quantity of data and the speed of raising retrieval to reduce.The condition is:By the station
Train number quantity have to be larger than one setting numerical value.The generation of " transfer station table " is relatively simple, and " certain station is up to station
The generation of table " and " up to certain station station table " is more complicated.Vernier is used first, and the name data at all stations is extracted from table W
Collection.Then the record of cursor data concentration is successively read, station name is obtained successively.If the record that cursor data is concentrated does not have
Reading is finished, then creates corresponding " certain station is up to station table " and " up to certain station station table " for station.Next interim table a is created,
For the data message for all trains for depositing website process.The interim table a of conjunctive query and " summary table " W, by effective data
" certain station is up to station table " and " up to certain station table " are inserted respectively.It is wherein so-called effective, that is, the station included in the data inquired about
Point, it is necessary to belong to " transfer station table ".
Embodiment 4
Referring to Fig. 1, Fig. 2, Fig. 3, the railroad train moment network inquiry method of the present embodiment exists with the difference of embodiment 3
In:Storing process includes inquiring about storing process, inquires about storing process and is based on station table information, and combine correlation function offer and transfers to number
According to.Fig. 3 gives the FB(flow block) of " inquiry storing process ".
First, management program transmission " starting station " and " point of destination " is given " inquiry storing process "." inquiry storing process " root
Read " starting station is up to station table " and " up to point of destination station table " respectively according to " starting station " and " point of destination ".Then, create interim
Table a, for storing station data equal in " starting station is up to station table " and " up to point of destination station table ".Next, according to " in
Data in station for transference table ", remove the data that a part is unsatisfactory for requiring.Interim table b and interim table c is respectively created, for depositing
All data of website again simultaneously in interim table a in storage " starting station is up to station table " and " up to point of destination station table ".Finally join
The interim table b of inquiry and interim table c, the inquiry mode sent according to management program are closed, returns fallen according to time inverted order, mileage respectively
The data set of sequence, arrival time positive sequence.
Embodiment 5
Referring to Fig. 1, Fig. 2, Fig. 3, Fig. 4, the railroad train moment network inquiry method of the present embodiment, it is different from embodiment 4 it
Be in:In inquiry storing process, it is related to the calculating of hourage.The present invention uses function addtime and function
Caltime realizes that hourage calculates:In database table, all time(Including:AT、DT、DTTU、ATTM、DTTM、
ATTD)All use the form of character string(“hh:mm”)Represent.Its counting number(Including:inDay、DU、DM1、DM2、DD)Using whole
Figurate number is represented.The system devises function addtime as shown in Figure 4 and function caltime and realizes the time meter entirely travelled
Calculate.Function caltime input parameter is two time character strings(Latter two first time point)With an integer variable(At two
Between put between whether cross over midnight), return value is a time character string(Time and minute used).Function addtime's is defeated
It is four time character strings to enter parameter(DTTU、ATTM、DTTM、ATTD)With two integer variables(DU、DM1、DM2、DD).In letter
Priority call function caltime calculates three time differences in number addtime, is then added three time differences, obtains most
Whole duration.Wherein the computational methods of 60 systems are respectively adopted in Tm subtraction and addition.
Embodiment 6
Referring to Fig. 1~Fig. 5, Fig. 5 show management program structured flowchart(In dotted line frame).The railroad train moment net of the present embodiment
Network querying method, is with the difference of foregoing embodiments:Management program is functionally divided into two parts:(1)Data
Library management is with safeguarding;(2)Train time query interface.Data base administration is opened with maintenance function to keeper, including database
The operations such as importing, export, maintenance, backup, test, setting.Main purpose is to keep upgrading in time for data content.Train
Moment query interface is to vast User Exploitation, it is possible to achieve multiple combinations inquiry mode, mainly includes:
(1)Economic preferential inquiry, as lead referral trip train combination, the ticket network minimal for spending client;
(2)Time priority, as lead referral trip train combination, the time that can spend client are most short;Or make user
Can at the appointed time before, arrive at;
(3)Mileage is preferential, and as lead referral trip train combination, the mileage for passing through client is most short;
(4)Preference is preferential, as lead referral trip train combination, enables a customer to using the classification of attending a banquet specified;
(5)Heat source, is lead referral trip train combination, enables a customer to by specified place, and set necessarily
Residence time.
The inquiry request of user passes to search engine first.Solicited message is sent in database by search engine
" inquiry storing process ", and obtain corresponding data.According to obtained inquiry data, search engine driving third party's interface is read
Take the remaining ticket information in 12306 databases.The remaining ticket information that the data and third party's interface that integrated database is provided are obtained, to use
Family returns to the Query Result of hommization.Main information includes:
(1)The passenger transfer scheme provided according to specific inquiry request;
(2)In the case where starting station is without remaining ticket, there is provided redundancy station booking proposed projects(Background technology last(4)Point is said
It is bright);
(3)In the case where point of destination is without remaining ticket, there is provided proposed projects of buying one's ticket after normal time of getting on the bus(Background technology(5)Point explanation).
Claims (8)
1. a kind of railroad train moment network inquiry method, train Comprehensive Query System is constituted by management program and database, its
It is characterised by:The database includes train time and inquires about summary table, and the Back ground Information of train time inquiry is included in train time
Inquire about in summary table, train time inquiry summary table includes certain station up to station table, up to certain station station table and transfer station table;Management program
The information that train time inquires about summary table is imported, exported and safeguarded, upgrading in time for data is kept;
Management program proposes that retrieval is required by interface storing process to database, and interface storing process is reachable from certain station respectively
Obtained in table, certain reachable station table and transfer station table and handle corresponding information, returning to Query Result to management program, there is provided go out
Hair station and point of destination information, realize the extraction of train information;
The remaining ticket information attended a banquet for train, management program responds the inquiry request of user, the database provided by third party
Interface is inquired about and issues Query Result.
2. railroad train moment network inquiry method according to claim 1, it is characterised in that:In database, during train
Each field of basic information data table is respectively in quarter inquiry summary table:
(1)Train operation order of classes or grades at school:ID;
(2)Train order of classes or grades at school classification:Type;
(3)All stations that train passes through:Station;
(4)The station numbering of this order of classes or grades at school train:No1 represents the starting station, and follow-up each station is added up successively;
(5)This order of classes or grades at school train reaches the time at the station:AT;
(6)This order of classes or grades at school train leaves the time at the station:DT;
(7)If this order of classes or grades at school train reaches situation of the appearance across midnight between time and time departure the station:InDay,
The follow-up field adds 1;
(8)From the mileage number at the starting station when this order of classes or grades at school train reaches the station:Distance.
3. railroad train moment network inquiry method according to claim 2, it is characterised in that:Certain station is each up to station table
Individual field is respectively:
(1)Starting station train operation order of classes or grades at school:IDU;
(2)Set out station name:StaU;
(3)Train leaves the time of starting station:DTTU;
(4)Train leaves the day counting number that starting station is:DU;
(5)Train is with a distance from starting station is from the train starting station:DisU;
(6)The transfer station name of this order of classes or grades at school train:StaM1;
(7)This train reaches the time of transfer stop:TTM;
(8)Day counting number of this train in transfer stop:DM1;
(9)Train is with a distance from transfer stop is from the train starting station:DisM1;
Up to certain station station table each field be respectively:
(1)Change to train operation order of classes or grades at school:IDD;
(2)Change to station name:StaM2;
(3)Train leaves the time of transfer stop:DTTM;
(4)Train leaves the day counting number that transfer stop is:DM2;
(5)Train is with a distance from transfer stop is from the transfer train starting station:DisM2;
(6)Purpose station name:StaD;
(7)Change to the time that train reaches point of destination:ATTD;
(8)This train reaches the day counting number of point of destination:DD;
(9)Train is with a distance from point of destination is from the train starting station:DisD.
4. railroad train moment network inquiry method according to claim 3, it is characterised in that:Stored using by some
The transfer search algorithm of journey, function and tables of data composition calculates Query Result, and wherein station table is generated by extraction storing process;
Transfer station table is created first, and then inquiry is met the site information insertion transfer station table of requirement from summary table W;
Using vernier, the name data collection at all stations is extracted from summary table W;
Then the record of cursor data concentration is successively read, station name is obtained successively;
If the record that cursor data is concentrated does not have reading to finish, certain corresponding station is created up to station table and up to certain for station
Station table;
Next interim table a is created, the data message of all trains for depositing website process;
Effective data are inserted certain station up to station table and up to certain station station table by conjunctive query interim table a and summary table W respectively.
5. railroad train moment network inquiry method according to claim 4, it is characterised in that:Storing process includes inquiry
Storing process, inquiry storing process is based on station table information, and combination correlation function provides and transfers to data:
First, inquiry storing process is given in management program transmission starting station and point of destination;
Inquiry storing process reads starting station up to station table and up to point of destination station table respectively according to starting station and point of destination;
Then, interim table a is created, for storing starting station up to station table and up to station data equal in the table of point of destination station;
Next, the data in transfer station table, remove the data that a part is unsatisfactory for requiring;
Interim table b and interim table c is respectively created, for storing website in " starting station is up to station table " and " up to point of destination station table "
While and all data in interim table a;
The last interim table b of conjunctive query and interim table c, the inquiry mode sent according to management program, were returned according to the time respectively
Inverted order, mileage inverted order, the data set of arrival time positive sequence.
6. railroad train moment network inquiry method according to claim 5, it is characterised in that:In inquiry storing process
In, in database table, all times are all represented in the form of character string;Its counting number is represented using shaping number;Using
Calculate function addtime and caltime and realize that hourage calculates:
Function caltime input parameter is two time character strings and an integer variable, and return value is a time character
String;
Function addtime input parameter is four time character strings and two integer variables;
Priority call function caltime calculates three time differences in function addtime, is then carried out into phase three time differences
Plus, obtain final duration.
7. the railroad train moment network inquiry method according to any one of claim 1~6, it is characterised in that:Pass through pipe
Reason program is realized(1)Data base administration is with safeguarding;(2)Train time query interface;
Data base administration is opened with maintenance function to keeper, including database is imported, exports, safeguards, backs up, tests, set
Operation;
Train time query interface is realized multiple combinations inquiry mode, mainly included to vast User Exploitation:
(1)Economic preferential inquiry, as lead referral trip train combination, the ticket network minimal for spending client;
(2)Time priority, as lead referral trip train combination, the time that can spend client are most short;Or make user
Can at the appointed time before, arrive at;
(3)Mileage is preferential, and as lead referral trip train combination, the mileage for passing through client is most short;
(4)Preference is preferential, as lead referral trip train combination, enables a customer to using the classification of attending a banquet specified;
(5)Heat source, is lead referral trip train combination, enables a customer to by specified place, and set necessarily
Residence time.
8. railroad train moment network inquiry method according to claim 7, it is characterised in that:The inquiry request of user is first
Search engine is first passed to, solicited message is sent to the inquiry storing process in database by search engine, and obtains corresponding
Data;According to obtained inquiry data, search engine driving third party's interface reads the remaining ticket information in 12306 databases;It is comprehensive
The remaining ticket information that the data and third party's interface that conjunction database is provided are obtained, the Query Result of hommization is returned to user:Inquiry
As a result main information includes:
(1)The passenger transfer scheme provided according to specific inquiry request;
(2)In the case where starting station is without remaining ticket, there is provided redundancy station booking proposed projects;
(3)In the case where point of destination is without remaining ticket, there is provided proposed projects of buying one's ticket after normal time of getting on the bus.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710328478.0A CN107025308A (en) | 2017-05-11 | 2017-05-11 | A kind of railroad train moment network inquiry method |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710328478.0A CN107025308A (en) | 2017-05-11 | 2017-05-11 | A kind of railroad train moment network inquiry method |
Publications (1)
Publication Number | Publication Date |
---|---|
CN107025308A true CN107025308A (en) | 2017-08-08 |
Family
ID=59529225
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710328478.0A Pending CN107025308A (en) | 2017-05-11 | 2017-05-11 | A kind of railroad train moment network inquiry method |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN107025308A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107622094A (en) * | 2017-08-30 | 2018-01-23 | 苏州朗动网络科技有限公司 | A kind of high-volume data guiding system and method based on search engine |
Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH09161105A (en) * | 1995-12-07 | 1997-06-20 | Toshiba Corp | Route retrieving system |
CN2710050Y (en) * | 2004-06-09 | 2005-07-13 | 席志刚 | Portable intelligent query device of train schedule |
JP2013060039A (en) * | 2011-09-12 | 2013-04-04 | Hitachi Systems Ltd | Route search system, route search method, and route search program |
CN103412934A (en) * | 2013-08-19 | 2013-11-27 | 合肥航联文化传播有限公司 | Large traffic searching method and system |
CN103544214A (en) * | 2013-09-18 | 2014-01-29 | 北京交通大学 | System and method for guiding urban railway traffic passenger flow based on last bus time |
CN103646069A (en) * | 2013-12-06 | 2014-03-19 | 北京奇虎科技有限公司 | Recommendation method and device for ticket service information |
-
2017
- 2017-05-11 CN CN201710328478.0A patent/CN107025308A/en active Pending
Patent Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH09161105A (en) * | 1995-12-07 | 1997-06-20 | Toshiba Corp | Route retrieving system |
CN2710050Y (en) * | 2004-06-09 | 2005-07-13 | 席志刚 | Portable intelligent query device of train schedule |
JP2013060039A (en) * | 2011-09-12 | 2013-04-04 | Hitachi Systems Ltd | Route search system, route search method, and route search program |
CN103412934A (en) * | 2013-08-19 | 2013-11-27 | 合肥航联文化传播有限公司 | Large traffic searching method and system |
CN103544214A (en) * | 2013-09-18 | 2014-01-29 | 北京交通大学 | System and method for guiding urban railway traffic passenger flow based on last bus time |
CN103646069A (en) * | 2013-12-06 | 2014-03-19 | 北京奇虎科技有限公司 | Recommendation method and device for ticket service information |
Non-Patent Citations (1)
Title |
---|
郑建波: "基于移动设备的铁路旅程规划方法与关键技术研究", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107622094A (en) * | 2017-08-30 | 2018-01-23 | 苏州朗动网络科技有限公司 | A kind of high-volume data guiding system and method based on search engine |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
Beser et al. | SAMPERS—The new Swedish national travel demand forecasting tool | |
Hensher | A practical approach to identifying the market potential for high speed rail: a case study in the Sydney-Canberra corridor | |
Merlin | Comparing automated shared taxis and conventional bus transit for a small city | |
CN103412934B (en) | Big traffic searching method and search system | |
Alshalalfah et al. | Feasibility of flex-route as a feeder transit service to rail stations in the suburbs: case study in Toronto | |
CN106528720A (en) | Transfer station recommendation method and transfer station recommendation system | |
Pan et al. | Demand-oriented integration optimization of train timetabling and rolling stock circulation planning with flexible train compositions: A column-generation-based approach | |
Wielinski et al. | What about free-floating carsharing? A look at the Montreal, Canada, case | |
CN106203725A (en) | Door-to-door trip route scheme personalized recommendation method based on heuristic search | |
Andersson et al. | The successes and failures of a key transportation link: accessibility effects of Taiwan’s high-speed rail | |
CN110222912B (en) | Railway travel route planning method and device based on time dependence model | |
CN110309962A (en) | Railway stroke route method and device for planning based on time extended model | |
CN103544214A (en) | System and method for guiding urban railway traffic passenger flow based on last bus time | |
CN109446381A (en) | A kind of public transport road network integrated approach based on temporal diagram | |
CN106097060A (en) | A kind of university students is left unused Cycle Hire software screening method system and its implementation | |
Wang et al. | Optimization models for high-speed train unit routing problems | |
CN109002923A (en) | A kind of intercity multimode travel route planing method | |
Wang et al. | Synchronized optimization for service scheduling, train parking and routing at high-speed rail maintenance depot | |
CN113723667B (en) | Optimization method and equipment for rail transit network operation scheme and readable storage medium | |
CN111339122A (en) | Active caching method of travel platform, travel query method and related products | |
CN101231718A (en) | Ticket business classifying method of orbit traffic transfer | |
CN107025308A (en) | A kind of railroad train moment network inquiry method | |
Xinfeng et al. | Route selection for railway passengers: a multi-objective model and optimization algorithm | |
Feng et al. | Optimal Operation Scheme with Short‐Turn, Express, and Local Services in an Urban Rail Transit Line | |
Tian et al. | Method for determining the valid travel route of railways based on generalised cost under the syncretic railway network |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170808 |
|
RJ01 | Rejection of invention patent application after publication |